Таблица: SM46 - «Service Management Text History File». Маска имени таблицы: «SM46%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
SM46001 | NCHAR | STRING | 4 | 0 | 4 | FileNo | Table ID | Specifies the object the text is related to:
SM01 - Service Order |
1 | Да |
SM46002 | 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 |
2 | Да |
SM46003 | 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 |
5 | Да |
SM46004 | NCHAR | STRING | 2 | 0 | 2 | PageNo | Page Number | 01 in most cases but for accessories (SM01-A) page 11 hold the stock item description. | 6 | Да |
SM46005 | INT | INTEGER | 0 | 0 | 5 | LineID | Line Number | 7 | Да | |
SM46006 | DATETIME | DATE | 0 | 0 | 8 | Date | Date Created | |||
SM46007 | NCHAR | STRING | 70 | 0 | 70 | Text | Text | |||
SM46008 | NCHAR | STRING | 3 | 0 | 3 | Language | Language Code | 4 | Да | |
SM46009 | NCHAR | STRING | 15 | 0 | 15 | InvoiceNumber | Invoice Number | 3 | Да |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Service Order Management | Service Management Texts History