пользователям программных продуктов Scala 5.0, Scala 5.1, iScala 2.1, iScala 2.2, iScala 2.3, iScala 3.0 (и так далее)

Таблица: 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        
ST02064 INT INTEGER 0 0 1 SalesReturnReasonCode Sales Return Reason Code      
ST02065 NCHAR NUMERICSTRING 10 0 10 RMAReference RMA Reference      

Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Statistics | Sales Order Entry Statistics

TopList

© Алексей Васильев. 2004-2018. При использовании материалов ссылка обязательна.