Таблица: 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
11-13 Language

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
03-05 Language

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
3 Да
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. 4 Да
SM09005 INT INTEGER 0 0 5 LineID Line Number   5 Да
SM09006 DATETIME DATE 0 0 8 Date Date Created      
SM09007 NCHAR STRING 70 0 70 Text Text      

Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Service Order Management | Service Order Text Storage