Таблица: SM46 - «Service Management Text History File». Маска имени таблицы: «SM46%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
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 11-13 Language 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 |
3 | Да |
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. | 4 | Да |
SM46005 | INT | INTEGER | 0 | 0 | 5 | LineID | Line Number | 5 | Да | |
SM46006 | DATETIME | DATE | 0 | 0 | 8 | Date | Date Created | |||
SM46007 | NCHAR | STRING | 70 | 0 | 70 | Text | Text |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Service Order Management | Service Management Texts History