Таблица | Table: SCWE - «Central Warehouse Purchase Statistics Transfer». Маска имени таблицы | Table Name Mask: «SCWE%cc00»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
Field Field Type iScala Field Type Field Length Pre­cision iScala Length Comment Extended Comment Additional Description Index Position Is Primary key?
SCWE001 NCHAR STRING 2 0 2 Central Warehouse Owner Company     1 Да / Yes
SCWE002 NVARCHAR VSTRING 10 0 10 Supplier     2 Да / Yes
SCWE003 NVARCHAR VSTRING 15 0 15 Invoice number     3 Да / Yes
SCWE004 NCHAR STRING 6 0 6 Auto Line     4 Да / Yes
SCWE005 NVARCHAR VSTRING 4 0 4 Supplier Category        
SCWE006 NVARCHAR VSTRING 10 0 10 Order No        
SCWE007 NVARCHAR VSTRING 1 0 1 Order Type        
SCWE008 NVARCHAR ACCSTR 50 0 50 Accounting string        
SCWE009 NVARCHAR VSTRING 6 0 6 Spare        
SCWE010 NVARCHAR VSTRING 6 0 6 Spare        
SCWE011 DATETIME DATE 0 0 8 Invoice Date        
SCWE012 DATETIME DATE 0 0 8 Delivery Date        
SCWE013 NVARCHAR VSTRING 6 0 6 +/- Delivery Time        
SCWE014 NVARCHAR VSTRING 35 0 35 Stock Code        
SCWE015 NVARCHAR VSTRING 4 0 4 Product Group        
SCWE016 NVARCHAR VSTRING 4 0 4 Alt Product Group        
SCWE017 NUMERIC X_NUMERIC 20 8 12 Purchase Qty        
SCWE018 NUMERIC MONEY 28 8 20 Price LCU        
SCWE019 NUMERIC MONEY 28 8 20 Price        
SCWE020 NVARCHAR VSTRING 6 0 6 Warehouse        
SCWE021 NCHAR SWITCH 1 0 1 Fully Shipped        
SCWE022 DATETIME DATE 0 0 8 Delivery Date Request        
SCWE023 NVARCHAR VSTRING 8 0 8 Spare        
SCWE024 NUMERIC X_NUMERIC 20 8 12 Qty SC        
SCWE025 NVARCHAR VSTRING 12 0 12 Batch ID Delivery        
SCWE026 NVARCHAR VSTRING 2 0 2 Currency Code        
SCWE027 NVARCHAR VSTRING 15 0 15 Invoice Number        
SCWE028 NVARCHAR VSTRING 10 0 10 Goods Received Note No        
SCWE029 NVARCHAR VSTRING 10 0 10 CWH Picking List        
SCWE030 NVARCHAR VSTRING 10 0 10 CWH Customer Code Ord        
SCWE031 NVARCHAR VSTRING 10 0 10 CWH Customer Code Inv        
SCWE032 NVARCHAR VSTRING 10 0 10 CWH Customer Code Del        
SCWE033 NVARCHAR VSTRING 1 0 1 CWH Inv Type        
SCWE034 NCHAR SWITCH 1 0 1 PL Updated        
SCWE035 NCHAR STRING 1 0 1 Source of request Source of request      
SCWE036 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 Purchase Statistics Transfer