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

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

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
Field Field Type iScala Field Type Field Length Pre­cision 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 Ordering company Order Company   2 Да / Yes
SCWW003 NCHAR STRING 10 0 10 Order number Order Number   4 Да / Yes
SCWW004 NCHAR STRING 6 0 6 Order line Order Line Number   5 Да / Yes
SCWW005 NCHAR STRING 6 0 6 Structure line Order Sub-line Number   6 Да / Yes
SCWW006 NCHAR STRING 4 0 4 Delivery line Order Delivery Line Number   7 Да / Yes
SCWW007 NVARCHAR VSTRING 35 0 35 Stock code Stock Item Code      
SCWW008 NVARCHAR VSTRING 12 0 12 Batch Batch ID      
SCWW009 NUMERIC X_NUMERIC 20 8 12 Quantity delivered OR Delivered Quantity (Stock Unit)      
SCWW010 DATETIME DATE 0 0 8 Actual delivery date Delivery Date      
SCWW011 NUMERIC X_NUMERIC 18 8 10 Net weight Net Weight      
SCWW012 NUMERIC X_NUMERIC 18 8 10 Gross weight Gross Weight      
SCWW013 NUMERIC X_NUMERIC 18 8 10 Volume Volume      
SCWW014 NUMERIC X_NUMERIC 20 8 12 Quantity delivered Delivered Quantity (Sales Unit)      
SCWW015 NCHAR STRING 15 0 15 Invoice number Invoice Number (Order)   8 Да / Yes
SCWW016 DATETIME DATE 0 0 8 Invoice date Invoice Date (Order)      
SCWW017 NCHAR STRING 2 0 2 Company code cwh owner 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 Cost CCU/OR-QTY Cost (Alternative Currency)      
SCWW021 INT INTEGER 0 0 2 Currency code cwh Currency Code Central Warehouse      
SCWW022 NUMERIC X_NUMERIC 28 8 20 Delivery date exchange rate cwh Currency Exchange Rate Central Warehouse      
SCWW023 NUMERIC X_NUMERIC 18 8 10 Delivery date exchange rate 2 cwh Currency Exchange Rate 2 Central Warehouse      
SCWW024 NVARCHAR VSTRING 3 0 3 Delivery date exchange alg. cwh Currency Exchange Rate Algorithm Central Warehouse      
SCWW025 INT INTEGER 0 0 2 Currency code ord Currency Code Order      
SCWW026 NUMERIC X_NUMERIC 28 8 20 Delivery date exchange rate ord Currency Exchange Rate Order      
SCWW027 NUMERIC X_NUMERIC 18 8 10 Delivery date exchange rate 2 ord Currency Exchange Rate 2 Order      
SCWW028 NVARCHAR VSTRING 3 0 3 Delivery date exchange alg. ord Currency Exchange Rate Algorithm Order      
SCWW029 NUMERIC MONEY 28 8 20 icp (Icp-Curr/SC-Qty) ICP Amount (Price List Currency)      
SCWW030 NUMERIC MONEY 28 8 20 icp (Cwh Lcu/SC-Qty) ICP Amount (Local Currency Order)      
SCWW031 NUMERIC MONEY 28 8 20 icp (Ord Lcu/SC-Qty) ICP Amount (Local Currency Central Warehouse)      
SCWW032 NUMERIC MONEY 28 8 20 Unit cost (Cwh Lcu)) Unit Cost (Local Currency Central Warehouse)      
SCWW033 NCHAR STRING 2 0 2 Accounting code 1 Accounting Code 1      
SCWW034 NVARCHAR ACCSTR 50 0 50 Accounting string Accounting String      
SCWW035 NCHAR SWITCH 1 0 1 Order closed Order Closed      
SCWW036 NVARCHAR VSTRING 15 0 15 Order invoice number Invoice Number (Transfer Invoice)      
SCWW037 NVARCHAR VSTRING 4 0 4 OR19 auto line ref Auto Line      
SCWW038 NVARCHAR VSTRING 20 0 20 User def 1 User defined 1 Batch      
SCWW039 NVARCHAR VSTRING 10 0 10 User def 2 User defined 2 Batch      
SCWW040 NVARCHAR VSTRING 10 0 10 User def 3 User defined 3 Batch      
SCWW041 NVARCHAR VSTRING 8 0 8 User def 4 User defined 4 Batch      
SCWW042 NVARCHAR VSTRING 8 0 8 User def 5 User defined 5 Batch      
SCWW043 NVARCHAR VSTRING 4 0 4 User def 6 User defined 6 Batch      
SCWW044 NVARCHAR VSTRING 4 0 4 User def 7 User defined 7 Batch      
SCWW045 NVARCHAR VSTRING 2 0 2 User def 8 User defined 8 Batch      
SCWW046 NVARCHAR VSTRING 2 0 2 User def 9 User defined 9 Batch      
SCWW047 NVARCHAR VSTRING 1 0 1 User def 10 User defined 10 Batch      
SCWW048 INT INTEGER 0 0 2 VAT code ord VAT Code Order      
SCWW049 INT INTEGER 0 0 2 VAT code cwh VAT Code Central Warehouse      
SCWW050 NUMERIC MONEY 28 8 20 VAT amount icp-curr VAT Amount (Price List Currency)      
SCWW051 NUMERIC MONEY 28 8 20 VAT amount lcu-ord VAT Amount (Local Currency Central Order)      
SCWW052 NUMERIC MONEY 28 8 20 VAT amount lcu-cwh VAT Amount (Local Currency Central Warehouse)      
SCWW053 NUMERIC MONEY 28 8 20 Sales price lcu-ord Sales Price (Local Currency Order)      
SCWW054 INT INTEGER 0 0 1 Transfer invoice printed Print Status Transfer Invoice      
SCWW055 NVARCHAR VSTRING 10 0 10 Customer code invoice Invoice Customer      
SCWW056 NVARCHAR VSTRING 6 0 6 Not in use (obsolete)      
SCWW057 NVARCHAR VSTRING 8 0 8 Not in use (obsolete)      
SCWW058 NUMERIC MONEY 28 8 20 Cost (S.P.) Cost Price Split Profit      
SCWW059 NUMERIC MONEY 28 8 20 Profit (S.P.) Profit Calculated      
SCWW060 NUMERIC X_NUMERIC 20 8 12 Returned quantity Reversed Quantity      
SCWW061 NVARCHAR VSTRING 20 0 20 Delivery note Delivery Note      
SCWW062 NVARCHAR VSTRING 10 0 10 Ordering customer Order customer      
SCWW063 NVARCHAR VSTRING 10 0 10 Delivery customer Delivery customer      
SCWW064 NUMERIC X_NUMERIC 18 8 10 Icp multiple ICP Multiple      
SCWW065 NVARCHAR VSTRING 12 0 12 Batch - ord Batch ID Local Order      
SCWW066 NUMERIC X_NUMERIC 20 8 12 Quantity Received OK (OR) Quantity Received OK (OR)      
SCWW067 NUMERIC X_NUMERIC 20 8 12 Quantity Received OK (SC) Quantity Received OK (SC)      
SCWW068 NUMERIC X_NUMERIC 20 8 12 Quantity Received Not OK (OR) Quantity Received Not OK (OR)      
SCWW069 NUMERIC X_NUMERIC 20 8 12 Quantity Received Not OK (SC) Quantity Received Not OK (SC)      
SCWW070 NCHAR STRING 1 0 1 Source of request Source of request   3 Да / Yes
SCWW071 DATETIME DATE 0 0 8 Delivery Note Printed Date Delivery Note Printed Date      
SCWW072 NCHAR STRING 2 0 2 Accounting Code 2 Accounting Code 2      
SCWW073 NVARCHAR VSTRING 25 0 25 AAScode AAS code      

Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Stock Control | Central Warehouse Intercompany Delivery Transaction History