Таблица: ST02 - «Order statistics». Маска имени таблицы: «ST02%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
ST02001 | NVARCHAR | VSTRING | 10 | 0 | 10 | CustomerCode | Customer Code Delivery | |||
ST02002 | NVARCHAR | VSTRING | 4 | 0 | 4 | CustomCateg | Customer Category | |||
ST02003 | NVARCHAR | VSTRING | 2 | 0 | 2 | District | Customer District | |||
ST02004 | NVARCHAR | VSTRING | 2 | 0 | 2 | AdvertisCode | Customer Advertising Area | |||
ST02005 | NVARCHAR | VSTRING | 4 | 0 | 4 | CityCode | Customer Area Code | |||
ST02006 | NVARCHAR | VSTRING | 5 | 0 | 5 | SNICode | Customer Trade Code | |||
ST02007 | NVARCHAR | VSTRING | 3 | 0 | 3 | Salesman | Salesman | |||
ST02008 | NVARCHAR | VSTRING | 10 | 0 | 10 | CustCodeInv | Customer Code Invoice | |||
ST02009 | NVARCHAR | VSTRING | 10 | 0 | 10 | OrderNumber | Order Number | |||
ST02010 | INT | INTEGER | 0 | 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 |
||
ST02011 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccCodeStrin | Accounting String | |||
ST02012 | NVARCHAR | VSTRING | 10 | 0 | 10 | Spare | Product Category | |||
ST02013 | NVARCHAR | VSTRING | 20 | 0 | 20 | Spare | Extended Product Group | |||
ST02014 | NVARCHAR | VSTRING | 15 | 0 | 15 | InvoiceNo | Invoice Number | |||
ST02015 | DATETIME | DATE | 0 | 0 | 8 | InvoicOrdDat | Order Date | |||
ST02016 | DATETIME | DATE | 0 | 0 | 8 | ActuaDelDate | Actual Delivery Date | |||
ST02017 | NVARCHAR | VSTRING | 35 | 0 | 35 | StockCode | Stock Item Code | |||
ST02018 | NVARCHAR | VSTRING | 4 | 0 | 4 | ProductGroup | Product Group | |||
ST02019 | NVARCHAR | VSTRING | 4 | 0 | 4 | AlternProdGr | Alternative Product Group | |||
ST02020 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Qty | Quantity | |||
ST02021 | NUMERIC | MONEY | 28 | 8 | 20 | PriceLCU | Unit Price (Local Currency) | |||
ST02022 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | Discount | Discount | |||
ST02023 | NUMERIC | MONEY | 28 | 8 | 20 | CostPriceLCU | Unit Cost Price (Local Currency) | |||
ST02024 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | BudgetQty | Budgeted Quantity | |||
ST02025 | NUMERIC | MONEY | 28 | 8 | 20 | BudgPriceLCU | Budgeted Unit Price (Local Currency) | |||
ST02026 | NUMERIC | MONEY | 28 | 8 | 20 | CostPric2LCU | Standard Cost Price (Local Currency) | |||
ST02027 | DATETIME | DATE | 0 | 0 | 8 | DelDatCommit | Delivery Date Committed | |||
ST02028 | NVARCHAR | VSTRING | 1 | 0 | 1 | ServiceLevel | Service Level | |||
ST02029 | NVARCHAR | VSTRING | 6 | 0 | 6 | Warehouse | Warehouse | |||
ST02030 | NCHAR | SWITCH | 1 | 0 | 1 | FullyShipped | Fully Shipped | |||
ST02031 | DATETIME | DATE | 0 | 0 | 8 | DelDateRequ | Delivery Date Requested | |||
ST02032 | NUMERIC | MONEY | 28 | 8 | 20 | AmountOCU | Unit Price (Order Currency) | |||
ST02033 | NVARCHAR | VSTRING | 2 | 0 | 2 | CurrCode | Currency Code Order | |||
ST02034 | NVARCHAR | VSTRING | 10 | 0 | 10 | CustCodeOrd | Customer Code Order | |||
ST02035 | NVARCHAR | VSTRING | 4 | 0 | 4 | OrdCancelCde | Cancellation Code | |||
ST02036 | NCHAR | STRING | 8 | 0 | 8 | SearcIndAuto | Index Key | 1 | Да | |
ST02037 | NCHAR | STRING | 12 | 0 | 12 | BatchIDDel | Batch ID Delivery | |||
ST02038 | NCHAR | SWITCH | 1 | 0 | 1 | EDIContractSwitch | EDI-Contract | |||
ST02039 | NUMERIC | MONEY | 28 | 8 | 20 | CostPriceCCU | Cost Unit Price (Alternative Currency) | |||
ST02040 | NUMERIC | MONEY | 28 | 8 | 20 | LineAmtLCU | Line Amount (Local Currency) | Line amount is the order line total before discount, it's calculated with rounding logic as defined for the currency. | ||
ST02041 | NUMERIC | MONEY | 28 | 8 | 20 | LineAmtOCU | Line Amount (Order Currency) | Line amount is the order line total before discount, it's calculated with rounding logic as defined for the currency. | ||
ST02042 | NUMERIC | MONEY | 28 | 8 | 20 | StandardVPC | Standard-Variable Product Cost (Local Currency) | This field is only used with the feature factory price | ||
ST02043 | NUMERIC | MONEY | 28 | 8 | 20 | RealVPC | Real-Variable Product Cost (Local Currency) | This field is only used with the feature factory price | ||
ST02044 | NCHAR | SWITCH | 1 | 0 | 1 | Freight Option | Freight Option | This field is only used with the feature factory price:
0 - Freight is Include in VPC Cost 1 - Freight is not Include in VPC Cost |
||
ST02045 | NCHAR | SWITCH | 1 | 0 | 1 | GL Update Flag | General Ledger Updated | This field is only used with the feature factory price | ||
ST02046 | INT | INTEGER | 0 | 0 | 9 | Discount Scheme Code | Discount Scheme Code | |||
ST02047 | INT | INTEGER | 0 | 0 | 9 | Discount Group Code | Discount Group Code | |||
ST02048 | NUMERIC | MONEY | 28 | 8 | 20 | AllowanceAmnt | Allowance Amount (Local Currency) | |||
ST02049 | NUMERIC | MONEY | 28 | 8 | 20 | SurchargeAmnt | Surcharge Amount (Local Currency) | |||
ST02050 | NCHAR | SWITCH | 1 | 0 | 1 | POS Statistics flag | POS Statistics Flag | |||
ST02051 | NVARCHAR | VSTRING | 40 | 0 | 40 | POS Import File Name | POS Import File Name | |||
ST02052 | NUMERIC | MONEY | 28 | 8 | 20 | POS Current Average Cost [LCU] | POS Current Average Cost (Local Currency) | |||
ST02053 | INT | INTEGER | 0 | 0 | 1 | POS Calculation Method | POS Calculation Method | |||
ST02054 | NCHAR | SWITCH | 1 | 0 | 1 | POS Product Category | POS Product Category | |||
ST02055 | NVARCHAR | VSTRING | 2 | 0 | 2 | CWH company code | Central Warehouse Company Code | |||
ST02056 | NVARCHAR | VSTRING | 10 | 0 | 10 | CWH Customer code | Central Warehouse Customer Code | |||
ST02057 | NUMERIC | MONEY | 28 | 8 | 20 | Spare | (obsolete) | |||
ST02058 | INT | INTEGER | 0 | 0 | 2 | Spare | (obsolete) | |||
ST02059 | NVARCHAR | VSTRING | 10 | 0 | 10 | CWH Pickinglist | Central Warehouse Picking List | |||
ST02060 | NVARCHAR | VSTRING | 1 | 0 | 1 | CWH Type of invoice | Central Warehouse Type of Invoice | |||
ST02061 | NVARCHAR | VSTRING | 15 | 0 | 15 | CWH Intercompany invoice | Central Warehouse Inter-company Invoice Number | |||
ST02062 | NCHAR | STRING | 6 | 0 | 6 | Sales Order Line Number | ||||
ST02063 | NCHAR | STRING | 6 | 0 | 6 | Sales Order Sub-Line Number |
Навигация: Структура БД iScala | iScala 2.2 HF 2.3318 - 2.02.3318 | Statistics | Sales Order Entry Statistics