Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else... / Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще...

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

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SCWW001 NCHAR STRING 1 0 1 Type Delivery Type   1 Да
SCWW002 NCHAR STRING 2 0 2 OrderingCompany Order Company   2 Да
SCWW003 NCHAR STRING 10 0 10 OrderNumber Order Number   4 Да
SCWW004 NCHAR STRING 6 0 6 OrderLine Order Line Number   5 Да
SCWW005 NCHAR STRING 6 0 6 StructLine Order Sub-line Number   6 Да
SCWW006 NCHAR STRING 4 0 4 DeliveryLine Order Delivery Line Number   7 Да
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 Да
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 50 0 50 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 NotInUse (obsolete)      
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 Да
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      

Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Stock Control | Central Warehouse Intercompany Delivery Transaction History