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

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / Table SCWW — Central Warehouse Intercompany Delivery Transaction History

Таблица / Table: SCWW — «Central Warehouse Intercompany delivery transaction history». Маска имени таблицы / Table name mask: «SCWW0000»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SCWW001 NCHAR STRING 1 0 1 Type Delivery Type   1 Да / Yes
SCWW002 NCHAR STRING 2 0 2 OrderingCompany Order Company   2 Да / Yes
SCWW003 NCHAR STRING 10 0 10 OrderNumber Order Number   4 Да / Yes
SCWW004 NCHAR STRING 6 0 6 OrderLine Order Line Number   5 Да / Yes
SCWW005 NCHAR STRING 6 0 6 StructLine Order Sub-line Number   6 Да / Yes
SCWW006 NCHAR STRING 4 0 4 DeliveryLine Order Delivery Line Number   7 Да / Yes
SCWW007 NVARCHAR VSTRING 35 0 35 StockCode Stock Item Code      
SCWW008 NVARCHAR VSTRING 12 0 12 Batch Batch ID      
SCWW009 NUMERIC X_NUMERIC 20 8 12 QtyDelivOR Delivered Quantity (Stock Unit)      
SCWW010 DATETIME DATE 0 0 8 ActualDeliveryDate Delivery Date      
SCWW011 NUMERIC X_NUMERIC 18 8 10 NetWeight Net Weight      
SCWW012 NUMERIC X_NUMERIC 18 8 10 GrossWeight Gross Weight      
SCWW013 NUMERIC X_NUMERIC 18 8 10 Volume Volume      
SCWW014 NUMERIC X_NUMERIC 20 8 12 QtyDeliv Delivered Quantity (Sales Unit)      
SCWW015 NCHAR STRING 15 0 15 InvoiceNumber Invoice Number (Order)   8 Да / Yes
SCWW016 DATETIME DATE 0 0 8 InvDate Invoice Date (Order)      
SCWW017 NCHAR STRING 2 0 2 CompanyCodeCWHOwner Company Warehouse Owner      
SCWW018 NCHAR STRING 6 0 6 Warehouse Warehouse      
SCWW019 NVARCHAR VSTRING 10 0 10 Pickinglist Picking List      
SCWW020 NUMERIC MONEY 28 8 20 CostCCUQtyOR Cost (Alternative Currency)      
SCWW021 INT INTEGER 0 0 2 CurrencyCodeCWH Currency Code Central Warehouse      
SCWW022 NUMERIC X_NUMERIC 28 8 20 DelDateExchRateCWH Currency Exchange Rate Central Warehouse      
SCWW023 NUMERIC X_NUMERIC 18 8 10 DelDateExchRate2CWH Currency Exchange Rate 2 Central Warehouse      
SCWW024 NVARCHAR VSTRING 3 0 3 DelDateExchAlgCWH Currency Exchange Rate Algorithm Central Warehouse      
SCWW025 INT INTEGER 0 0 2 CurrencyCodeOrd Currency Code Order      
SCWW026 NUMERIC X_NUMERIC 28 8 20 DelDateExchRateOrd Currency Exchange Rate Order      
SCWW027 NUMERIC X_NUMERIC 18 8 10 DelDateExchRate2Ord Currency Exchange Rate 2 Order      
SCWW028 NVARCHAR VSTRING 3 0 3 DelDateExchAlgOrd Currency Exchange Rate Algorithm Order      
SCWW029 NUMERIC MONEY 28 8 20 ICPAmntPCU ICP Amount (Price List Currency)      
SCWW030 NUMERIC MONEY 28 8 20 ICPAmntLCU ICP Amount (Local Currency Order)      
SCWW031 NUMERIC MONEY 28 8 20 ICPAmntLCUOrd ICP Amount (Local Currency Central Warehouse)      
SCWW032 NUMERIC MONEY 28 8 20 UnitCostLCU_CWH Unit Cost (Local Currency Central Warehouse)      
SCWW033 NCHAR STRING 2 0 2 Accountingcode1 Accounting Code 1      
SCWW034 NVARCHAR ACCSTR 120 0 120 AccString Accounting String      
SCWW035 NCHAR SWITCH 1 0 1 OrderClosed Order Closed      
SCWW036 NVARCHAR VSTRING 15 0 15 OrderInvNum Invoice Number (Transfer Invoice)      
SCWW037 NVARCHAR VSTRING 4 0 4 AutoLine Auto Line      
SCWW038 NVARCHAR VSTRING 20 0 20 UserDef1 User defined 1 Batch      
SCWW039 NVARCHAR VSTRING 10 0 10 UserDef2 User defined 2 Batch      
SCWW040 NVARCHAR VSTRING 10 0 10 UserDef3 User defined 3 Batch      
SCWW041 NVARCHAR VSTRING 8 0 8 UserDef4 User defined 4 Batch      
SCWW042 NVARCHAR VSTRING 8 0 8 UserDef5 User defined 5 Batch      
SCWW043 NVARCHAR VSTRING 4 0 4 Userdef6 User defined 6 Batch      
SCWW044 NVARCHAR VSTRING 4 0 4 Userdef7 User defined 7 Batch      
SCWW045 NVARCHAR VSTRING 2 0 2 Userdef8 User defined 8 Batch      
SCWW046 NVARCHAR VSTRING 2 0 2 Userdef9 User defined 9 Batch      
SCWW047 NVARCHAR VSTRING 1 0 1 Userdef10 User defined 10 Batch      
SCWW048 INT INTEGER 0 0 2 VATCodeOrd VAT Code Order      
SCWW049 INT INTEGER 0 0 2 VATCodeCWH VAT Code Central Warehouse      
SCWW050 NUMERIC MONEY 28 8 20 VATAmntICPCurr VAT Amount (Price List Currency)      
SCWW051 NUMERIC MONEY 28 8 20 VATAmntLCUOrd VAT Amount (Local Currency Central Order)      
SCWW052 NUMERIC MONEY 28 8 20 VATAmntLCU_CWH VAT Amount (Local Currency Central Warehouse)      
SCWW053 NUMERIC MONEY 28 8 20 SalesPriceLCUOrd Sales Price (Local Currency Order)      
SCWW054 INT INTEGER 0 0 1 TransferInvPrinted Print Status Transfer Invoice      
SCWW055 NVARCHAR VSTRING 10 0 10 CustCodeInvoice Invoice Customer      
SCWW056 NVARCHAR VSTRING 6 0 6 NotInUse (obsolete)      
SCWW057 NVARCHAR VSTRING 8 0 8 InvoicePrefix Invoice Prefix      
SCWW058 NUMERIC MONEY 28 8 20 CostSP Cost Price Split Profit      
SCWW059 NUMERIC MONEY 28 8 20 ProfitSP Profit Calculated      
SCWW060 NUMERIC X_NUMERIC 20 8 12 ReturnedQty Reversed Quantity      
SCWW061 NVARCHAR VSTRING 20 0 20 DeliveryNote Delivery Note      
SCWW062 NVARCHAR VSTRING 10 0 10 OrderingCustomer Order customer      
SCWW063 NVARCHAR VSTRING 10 0 10 DeliveryCustomer Delivery customer      
SCWW064 NUMERIC X_NUMERIC 18 8 10 ICPMult ICP Multiple      
SCWW065 NVARCHAR VSTRING 12 0 12 BatchOrd Batch ID Local Order      
SCWW066 NUMERIC X_NUMERIC 20 8 12 QuantityReceivedOKOR Quantity Received OK (OR)      
SCWW067 NUMERIC X_NUMERIC 20 8 12 QuantityReceivedOKSC Quantity Received OK (SC)      
SCWW068 NUMERIC X_NUMERIC 20 8 12 QuantityReceivedNotOKOR Quantity Received Not OK (OR)      
SCWW069 NUMERIC X_NUMERIC 20 8 12 QuantityReceivedNotOKSC Quantity Received Not OK (SC)      
SCWW070 NCHAR STRING 1 0 1 SourceOfRequest Source of request   3 Да / Yes
SCWW071 DATETIME DATE 0 0 8 DeliveryNotePrintedDate Delivery Note Printed Date      
SCWW072 NCHAR STRING 2 0 2 AccountingCode2 Accounting Code 2      
SCWW073 NVARCHAR VSTRING 25 0 25 AASCode AAS code      
SCWW074 NVARCHAR VSTRING 6 0 6 TradeWarehouse Trade Warehouse      

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