One level Up / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «Stock Control»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица SCWW — Central Warehouse Intercompany Delivery Transaction History

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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
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      

История изменения структуры таблицы / Table structure changes history:

Поле / Field
iScala 2.2 HF 2.3318
iScala 2.3
iScala 2.3 SR1
iScala 2.3 SR2
iScala 2.3 SR3
iScala 3.0 FSP2
iScala 3.0 FSP4
Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length Длина поля / Field length Длина iScala / iScala length
SCWW022 18 10 28 20 28 20 28 20 28 20 28 20 28 20
SCWW023 28 20 18 10 18 10 18 10 18 10 18 10 18 10
SCWW026 18 10 28 20 28 20 28 20 28 20 28 20 28 20
SCWW027 28 20 18 10 18 10 18 10 18 10 18 10 18 10
SCWW033 0 2 0 2 0 2 2 2 2 2 2 2 2 2
SCWW070 1 1 1 1 1 1 1 1 1 1 1 1
SCWW071 0 8 0 8 0 8 0 8 0 8 0 8
SCWW072 2 2 2 2 2 2 2 2
SCWW073 25 25 25 25 25 25 25 25

Навигация: