One level Up / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «Service Order Management»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица SM09 — Service Order Text Storage

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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
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 Да
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 Да
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 Да
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 Да
SM09005 INT INTEGER 0 0 5 LineID Line Number   6 Да
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 Да
SM09009 NCHAR STRING 15 0 15 InvoiceNumber Invoice Number      

Навигация: