Таблица | Table: MA21 - «Customer Request Lines». Маска имени таблицы | Table Name Mask: «MA21%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
Field | Field Type | iScala Field Type | Field Length | Precision | iScala Length | Comment | Extended Comment | Additional Description | Index Position | Is Primary key? |
MA21001 | NCHAR | STRING | 10 | 0 | 10 | RequestNo | Customer Request | 1 | Да / Yes | |
MA21002 | NCHAR | STRING | 3 | 0 | 3 | LineNo | Line Number | 2 | Да / Yes | |
MA21003 | INT | INTEGER | 0 | 0 | 2 | ObjectType | Object Type | Indicates the type of order the line is related to:
1 - Sales Order 2 - Purchase Order 3 - Main Project 4 - Project 5 - Service Order 6 - Contract 7 - Work Order (MPC) |
||
MA21004 | NCHAR | STRING | 12 | 0 | 12 | ObjectNo | Object Number | |||
MA21005 | INT | INTEGER | 0 | 0 | 1 | HistoryFlag | Is History Record | |||
MA21006 | INT | INTEGER | 0 | 0 | 1 | LinkedObjectState | Linked Object State | Indicates the state of the linked object with the following alternatives:
1 - Open 2 - Closed 3 - Cancelled |
Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Market Database | Customer Request Lines