Таблица: ST11 - «Selected Bookings». Маска имени таблицы: «ST11%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
ST11001 | NCHAR | STRING | 2 | 0 | 2 | TransactType | Transaction Type | |||
ST11002 | NVARCHAR | VSTRING | 35 | 0 | 35 | StockCode | Stock Item Code | |||
ST11003 | NVARCHAR | VSTRING | 10 | 0 | 10 | CustomerCode | Customer Code | |||
ST11004 | NVARCHAR | VSTRING | 10 | 0 | 10 | OrderNumber | Order Number | |||
ST11005 | 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 |
||
ST11006 | DATETIME | DATE | 0 | 0 | 8 | TransactDate | Transaction Date | |||
ST11007 | DATETIME | DATE | 0 | 0 | 8 | CustRequeDat | Delivery Date Requested | |||
ST11008 | DATETIME | DATE | 0 | 0 | 8 | FactCommDate | Actual Date | |||
ST11009 | DATETIME | DATE | 0 | 0 | 8 | OrdEntryDate | Order Entry Date | |||
ST11010 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Qty | Quantity | |||
ST11011 | NUMERIC | MONEY | 28 | 8 | 20 | UnitPrcInLCU | Unit Price (Local Currency) | |||
ST11012 | NUMERIC | MONEY | 28 | 8 | 20 | UnitPrcLCUSh | Unit Price Shipment (Local Currency) | |||
ST11013 | NVARCHAR | VSTRING | 3 | 0 | 3 | Salesman | Salesman | |||
ST11014 | NVARCHAR | VSTRING | 4 | 0 | 4 | ProductGroup | Product Group | |||
ST11015 | NVARCHAR | VSTRING | 1 | 0 | 1 | FLAG13Week | 13 Week Flag | |||
ST11016 | NVARCHAR | VSTRING | 2 | 0 | 2 | AccountCode | Accounting Code | |||
ST11017 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccCodeStrin | Accounting String | |||
ST11018 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | (obsolete) | |||
ST11019 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | (obsolete) | |||
ST11020 | NCHAR | STRING | 8 | 0 | 8 | SrcIndAutCou | Index Key | 1 | Да |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Statistics | Selected Bookings