Таблица | Table: ST03 - «Invoicing Statistics». Маска имени таблицы | Table Name Mask: «ST03%cc00»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
Field Field Type iScala Field Type Field Length Pre­cision iScala Length Comment Extended Comment Additional Description Index Position Is Primary key?
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 Да / Yes
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      
ST03066 NUMERIC MONEY 28 8 20 Commission Withheld Cost Commission Withheld Cost      

Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Statistics | Sales Order Invoicing Statistics