Таблица: ST03 - «Invoicing Statistics». Маска имени таблицы: «ST03%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
ST03001 | NVARCHAR | VSTRING | 10 | 0 | 10 | CustomerCode | Customer Code | |||
ST03002 | NVARCHAR | VSTRING | 4 | 0 | 4 | CustomCateg | Customer Category | |||
ST03003 | NVARCHAR | VSTRING | 2 | 0 | 2 | District | Customer District | |||
ST03004 | NVARCHAR | VSTRING | 2 | 0 | 2 | AdvertisCode | Customer Advertising Area | |||
ST03005 | NVARCHAR | VSTRING | 4 | 0 | 4 | CityCode | Customer Area Code | |||
ST03006 | NVARCHAR | VSTRING | 5 | 0 | 5 | SNICode | Customer Trade Code | |||
ST03007 | NVARCHAR | VSTRING | 3 | 0 | 3 | Salesman | Salesman | |||
ST03008 | NVARCHAR | VSTRING | 10 | 0 | 10 | CustCodeInvo | Customer Code Invoice | |||
ST03009 | NVARCHAR | VSTRING | 10 | 0 | 10 | OrderNumber | Order Number | |||
ST03010 | 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 |
||
ST03011 | NVARCHAR | VSTRING | 50 | 0 | 50 | AccCodeStrin | Accounting String | |||
ST03012 | NVARCHAR | VSTRING | 10 | 0 | 10 | Spare | Product Category | |||
ST03013 | NVARCHAR | VSTRING | 20 | 0 | 20 | Spare | Extended Product Group | |||
ST03014 | NVARCHAR | VSTRING | 15 | 0 | 15 | InvoicNumber | Invoice Number | |||
ST03015 | DATETIME | DATE | 0 | 0 | 8 | InvOrderDate | Invoice Date | |||
ST03016 | DATETIME | DATE | 0 | 0 | 8 | ActuaDelDate | Actual Delivery Date | |||
ST03017 | NVARCHAR | VSTRING | 35 | 0 | 35 | StockCode | Stock Item Code | |||
ST03018 | NVARCHAR | VSTRING | 4 | 0 | 4 | ProductGroup | Product Group | |||
ST03019 | NVARCHAR | VSTRING | 4 | 0 | 4 | AlternProdGr | Alternative Product Group | |||
ST03020 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Qty | Quantity | |||
ST03021 | NUMERIC | MONEY | 28 | 8 | 20 | PriceLCU | Unit Price (Local Currency) | |||
ST03022 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | Discount | Discount | |||
ST03023 | NUMERIC | MONEY | 28 | 8 | 20 | CostPriceLCU | Unit Cost Price (Local Currency) | |||
ST03024 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | BudgetQty | Budgeted Quantity | |||
ST03025 | NUMERIC | MONEY | 28 | 8 | 20 | BudgPriceLCU | Budgeted Price (Local Currency) | |||
ST03026 | NUMERIC | MONEY | 28 | 8 | 20 | CostPric2LCU | Standard Cost Price (Local Currency) | |||
ST03027 | DATETIME | DATE | 0 | 0 | 8 | DelDateCommi | Delivery Date Committed | |||
ST03028 | NVARCHAR | VSTRING | 1 | 0 | 1 | ServiceLevel | Service Level | |||
ST03029 | NVARCHAR | VSTRING | 6 | 0 | 6 | Warehouse | Warehouse | |||
ST03030 | NCHAR | SWITCH | 1 | 0 | 1 | FullyShipped | Fully Shipped | |||
ST03031 | DATETIME | DATE | 0 | 0 | 8 | DelDateReque | Delivery Date Requested | |||
ST03032 | NUMERIC | MONEY | 28 | 8 | 20 | AmountOCU | Unit Price (Invoice Currency) | |||
ST03033 | NVARCHAR | VSTRING | 2 | 0 | 2 | CurrCode | Currency Code Invoice | |||
ST03034 | NVARCHAR | VSTRING | 10 | 0 | 10 | CustCodeOrd | Customer Code Order | |||
ST03035 | NVARCHAR | VSTRING | 4 | 0 | 4 | OrdCancelCde | Cancellation Code | |||
ST03036 | NCHAR | STRING | 8 | 0 | 8 | SearcIndAuto | Index Key | 1 | Да | |
ST03037 | NVARCHAR | VSTRING | 12 | 0 | 12 | BatchIDDel | Batch ID Delivery | |||
ST03038 | NCHAR | SWITCH | 1 | 0 | 1 | Ediswitch | EDI-Contract | |||
ST03039 | NUMERIC | MONEY | 28 | 8 | 20 | CostPriceCCU | Cost Unit Price (Alternative Currency) | |||
ST03040 | 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. | ||
ST03041 | NUMERIC | MONEY | 28 | 8 | 20 | LineAmtOCU | Line Amount (Invoice Currency) | Line amount is the order line total before discount, it's calculated with rounding logic as defined for the currency. | ||
ST03042 | NUMERIC | MONEY | 28 | 8 | 20 | StandardVPC | Standard-Variable Product Cost (Local Currency) | This field is only used with the feature factory price | ||
ST03043 | NUMERIC | MONEY | 28 | 8 | 20 | RealVPC | Real-Variable Product Cost (Local Currency) | This field is only used with the feature factory price | ||
ST03044 | 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 |
||
ST03045 | NCHAR | SWITCH | 1 | 0 | 1 | GL Update Flag | General Ledger Updated | This field is only used with the feature factory price | ||
ST03046 | INT | INTEGER | 0 | 0 | 9 | Discount Scheme Code | Discount Scheme Code | |||
ST03047 | INT | INTEGER | 0 | 0 | 9 | Discount Group Code | Discount Group Code | |||
ST03048 | NUMERIC | MONEY | 28 | 8 | 20 | AllowanceAmnt | Allowance Amount (Local Currency) | |||
ST03049 | NUMERIC | MONEY | 28 | 8 | 20 | SurchargeAmnt | Surcharge Amount (Local Currency) | |||
ST03050 | NCHAR | SWITCH | 1 | 0 | 1 | POS Statistics flag | POS Statistics Flag | |||
ST03051 | NVARCHAR | VSTRING | 40 | 0 | 40 | POS Import File Name | POS Import File Name | |||
ST03052 | NUMERIC | MONEY | 28 | 8 | 20 | POS Current Average Cost [LCU] | POS Current Average Cost (Local Currency) | |||
ST03053 | INT | INTEGER | 0 | 0 | 1 | POS Calculation Method | POS Calculation Method | |||
ST03054 | NCHAR | SWITCH | 1 | 0 | 1 | POS Product Category | POS Product Category | |||
ST03055 | NVARCHAR | VSTRING | 2 | 0 | 2 | CWH company code | Central Warehouse Company Code | |||
ST03056 | NVARCHAR | VSTRING | 10 | 0 | 10 | CWH Customer code | Central Warehouse Customer Code | |||
ST03057 | NUMERIC | MONEY | 28 | 8 | 20 | Spare | (obsolete) | |||
ST03058 | INT | INTEGER | 0 | 0 | 2 | Spare | (obsolete) | |||
ST03059 | NVARCHAR | VSTRING | 10 | 0 | 10 | CWH Pickinglist | Central Warehouse Picking List | |||
ST03060 | NVARCHAR | VSTRING | 1 | 0 | 1 | CWH Type of invoice | Central Warehouse Type of Invoice | |||
ST03061 | NVARCHAR | VSTRING | 15 | 0 | 15 | CWH Intercompany invoice | Central Warehouse Inter-company Invoice Number | |||
ST03062 | NCHAR | STRING | 6 | 0 | 6 | Sales Order Line Number | ||||
ST03063 | NCHAR | STRING | 6 | 0 | 6 | Sales Order Sub-Line Number | ||||
ST03064 | INT | INTEGER | 0 | 0 | 1 | SalesReturnReasonCode | Sales Return Reason Code | |||
ST03065 | NCHAR | NUMERICSTRING | 10 | 0 | 10 | RMAReference | RMA Reference |
Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Statistics | Sales Order Invoicing Statistics