Таблица | Table: SM09 - «Service Management Text File». Маска имени таблицы | Table Name Mask: «SM09%cc00»
| Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
| Field | Field Type | iScala Field Type | Field Length | Precision | 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 |
Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Service Order Management | Service Order Text Storage
/* */