Таблица: ST16 - «PO Header Lines Statistics». Маска имени таблицы: «ST16%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
ST16001 | NCHAR | STRING | 10 | 0 | 10 | OrderNo | Purchase Order Number | 1 | Да | |
ST16002 | NCHAR | STRING | 6 | 0 | 6 | OrderLine | Purchase Order Line Number | 2 | Да | |
ST16003 | NCHAR | STRING | 6 | 0 | 6 | OrderSubLine | Purchase Order Sub-line Number | 3 | Да | |
ST16004 | NCHAR | SWITCH | 1 | 0 | 1 | OrderType | Order Type | 0 - Purchase Order Proposal / Request for Quotation
1 - Normal Order 2 - Back Order 3 - Direct Delivery to Customer 4 - Replenishment Order |
4 | Да |
ST16005 | INT | INTEGER | 0 | 0 | 10 | Counter | Line Counter | 5 | Да | |
ST16006 | NCHAR | STRING | 35 | 0 | 35 | StockCode | Stock Item Code | |||
ST16007 | NCHAR | STRING | 4 | 0 | 4 | ProductGroup | Product Group | |||
ST16008 | NCHAR | STRING | 4 | 0 | 4 | AltProductGroup | Alternative Product Group | |||
ST16009 | NCHAR | STRING | 6 | 0 | 6 | Warehouse | Warehouse | |||
ST16010 | NCHAR | STRING | 2 | 0 | 2 | AccountCode | Accounting Code | |||
ST16011 | NCHAR | STRING | 50 | 0 | 50 | AccountString | Accounting String | |||
ST16012 | NCHAR | STRING | 8 | 0 | 8 | ScaUser | User | |||
ST16013 | DATETIME | DATE | 0 | 0 | 8 | TransactionDate | Transaction Date | |||
ST16014 | NCHAR | STRING | 8 | 0 | 8 | TransactionTime | Transaction Time | |||
ST16015 | NCHAR | STRING | 2 | 0 | 2 | TransactionType | Transaction Type | 10 - Created
20 - Updated 60 - Deleted |
||
ST16016 | NCHAR | SWITCH | 1 | 0 | 1 | Flag_Active | Active |
Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Statistics | Purchase Order Line Statistics