Таблица: ST10 - «Bookings». Маска имени таблицы: «ST10%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
ST10001 | NCHAR | STRING | 2 | 0 | 2 | TransactType | Transaction Type | |||
ST10002 | NVARCHAR | VSTRING | 35 | 0 | 35 | StockCode | Stock Item Code | |||
ST10003 | NVARCHAR | VSTRING | 10 | 0 | 10 | CustomerCode | Customer Code | |||
ST10004 | NVARCHAR | VSTRING | 10 | 0 | 10 | OrderNumber | Order Number | |||
ST10005 | NVARCHAR | VSTRING | 1 | 0 | 1 | OrderType | Order Type | 0 - Quotation
1 - Normal Order 2 - Invoice Order 3 - Direct Order 4 - Back Order 5 - Repeat Order 6 - Work Order 7 - Direct Credit Order 8 - Credit Order 9 - Re-invoice Order |
||
ST10006 | DATETIME | DATE | 0 | 0 | 8 | TransactDate | Transaction Date | |||
ST10007 | DATETIME | DATE | 0 | 0 | 8 | CustRequDat | Delivery Date Requested | |||
ST10008 | DATETIME | DATE | 0 | 0 | 8 | FactCommDate | Actual Date | |||
ST10009 | DATETIME | DATE | 0 | 0 | 8 | OrdEntryDate | Order Entry Date | |||
ST10010 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Qty | Quantity | |||
ST10011 | NUMERIC | MONEY | 28 | 8 | 20 | UnitPriInLCU | Unit Price (Local Currency) | |||
ST10012 | NUMERIC | MONEY | 28 | 8 | 20 | UnitPrLCUShi | Unit Price Shipment (Local Currency) | |||
ST10013 | NVARCHAR | VSTRING | 3 | 0 | 3 | Salesman | Salesman | |||
ST10014 | NVARCHAR | VSTRING | 4 | 0 | 4 | ProductGroup | Product Group | |||
ST10015 | NVARCHAR | VSTRING | 1 | 0 | 1 | FLAG13Week | 13 Week Flag | |||
ST10016 | NVARCHAR | VSTRING | 2 | 0 | 2 | AccountCode | Accounting Code | |||
ST10017 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccCodeStrin | Accounting String | |||
ST10018 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | (obsolete) | |||
ST10019 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | (obsolete) | |||
ST10020 | NCHAR | STRING | 8 | 0 | 8 | SrcIndAutCou | Index Key | 1 | Да |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Statistics | Bookings