One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Статистика»/List of tables of module «Statistics»

Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Таблица / Table ST02 — Sales Order Entry Statistics

Таблица / Table: ST02 — «Order statistics». Маска имени таблицы / Table name mask: «ST02%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
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 120 0 120 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 Да / Yes
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 FreightOption 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 GLUpdateFlag General Ledger Updated This field is only used with the feature factory price    
ST02046 INT INTEGER 0 0 9 DiscountSchemeCode Discount Scheme Code      
ST02047 INT INTEGER 0 0 9 DiscountGroupCode 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 POSStatFlag POS Statistics Flag      
ST02051 NVARCHAR VSTRING 40 0 40 POSImportFileName POS Import File Name      
ST02052 NUMERIC MONEY 28 8 20 POSCurrentAverageCostLCU] POS Current Average Cost (Local Currency)      
ST02053 INT INTEGER 0 0 1 POSCalculationMethod POS Calculation Method      
ST02054 NCHAR SWITCH 1 0 1 POSProductCategory POS Product Category      
ST02055 NVARCHAR VSTRING 2 0 2 CWHCompanyCode Central Warehouse Company Code      
ST02056 NVARCHAR VSTRING 10 0 10 CWHCustomerCode 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 CWHPickinglist Central Warehouse Picking List      
ST02060 NVARCHAR VSTRING 1 0 1 CWHTypeOfInvoice Central Warehouse Type of Invoice      
ST02061 NVARCHAR VSTRING 15 0 15 CWHIntercompanyInvoice Central Warehouse Inter-company Invoice Number      
ST02062 NCHAR STRING 6 0 6 SalesOrderLine Sales Order Line Number      
ST02063 NCHAR STRING 6 0 6 SalesOrderSubline 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      
ST02066 NUMERIC MONEY 28 8 20 CommissionWithheldCost Commission Withheld Cost      
ST02067 DATETIME DATE 0 0 8 TransactionDate Transaction Date      

Навигация / Navigation: