На один уровень вверх / One level Up: Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Service Order Management»

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / Table SM09 — Service Order Text Storage

Таблица / Table: SM09 — «Service Management Text File». Маска имени таблицы / Table name mask: «SM09%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SM09001 NCHAR STRING 4 0 4 FileNo Table ID Specifies the object the text is related to:

SM01 — Service Order

SM11 — Contract

SY80 — Installation Site

SMDC — Document Texts		 1 Да / Yes
SM09002 NCHAR STRING 35 0 35 FileIndex Index Key String that holds the key value and formatted depending on the table id and text type:

Format for SM01 and text type 1-3:

01-10 Service order number

Format for SM01 and text type A:

01-10 Service order number

Format for SM11 and text type 1:

01-10 Contract number

Format for SY80 and text type 1:

01-10 Customer code

11-14 Site code

Format for document text:

01-02 Document type

The following document types exist:

01 — Quote

02 — Confirmation

03 — Service order 1

04 — Service order 2

05 — Service order 3

06 — Service order 4

07 — Material picking list local

08 — Material picking list external

09 — Return note

10 — Delivery note customer 1

11 — Delivery note customer 2

12 — Delivery note customer 3

13 — Delivery note supplier

14 — Proforma

15 — Invoice

 2 Да / Yes
SM09003 NCHAR STRING 1 0 1 TextType Text Type Text types for service order object (SM01):

1 — Order text

2 — Internal order text

3 — Message to engineer

A — Accessories

Text types for document texts (SMDC):

1 — Document text

Text types for contracts (SM11):

1 — Contract text

Text type for site address (SY80):

1 — Extra text

 4 Да / Yes
SM09004 NCHAR STRING 2 0 2 PageNo Page Number 01 in most cases but for accessories (SM01-A) page 11 hold the stock item description. 5 Да / Yes
SM09005 INT INTEGER 0 0 5 LineID Line Number   6 Да / Yes
SM09006 DATETIME DATE 0 0 8 Date Date Created      
SM09007 NCHAR STRING 70 0 70 Text Text      
SM09008 NCHAR STRING 3 0 3 Language Language Code   3 Да / Yes
SM09009 NCHAR STRING 15 0 15 InvoiceNumber Invoice Number      

Навигация / Navigation: