На один уровень вверх / One level Up: Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Список таблиц модуля /List of tables of module «Statistics»

Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Таблица / Table ST03 — Sales Order Invoicing Statistics

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / 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 ACCSTR 120 0 120 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 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		    
ST03045 NCHAR SWITCH 1 0 1 GLUpdateFlag General Ledger Updated This field is only used with the feature factory price    
ST03046 INT INTEGER 0 0 9 DiscountSchemeCode Discount Scheme Code      
ST03047 INT INTEGER 0 0 9 DiscountGroupCode 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 POSStatFlag POS Statistics Flag      
ST03051 NVARCHAR VSTRING 40 0 40 POSImportFileName POS Import File Name      
ST03052 NUMERIC MONEY 28 8 20 POSCurrentAverageCostLCU] POS Current Average Cost (Local Currency)      
ST03053 INT INTEGER 0 0 1 POSCalculationMethod POS Calculation Method      
ST03054 NCHAR SWITCH 1 0 1 POSProductCategory POS Product Category      
ST03055 NVARCHAR VSTRING 2 0 2 CWHCompanyCode Central Warehouse Company Code      
ST03056 NVARCHAR VSTRING 10 0 10 CWHCustomerCode 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 CWHPickinglist Central Warehouse Picking List      
ST03060 NVARCHAR VSTRING 1 0 1 CWHTypeOfInvoice Central Warehouse Type of Invoice      
ST03061 NVARCHAR VSTRING 15 0 15 CWHIntercompanyInvoice Central Warehouse Inter-company Invoice Number      
ST03062 NCHAR STRING 6 0 6 SalesOrderLine Sales Order Line Number      
ST03063 NCHAR STRING 6 0 6 SalesOrderSubline 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 CommissionWithheldCost Commission Withheld Cost      
ST03067 DATETIME DATE 0 0 8 TransactionDate Transaction Date      

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