пользователям программных продуктов Scala 5.0, Scala 5.1, iScala 2.1, iScala 2.2, iScala 2.3, iScala 3.0 (и так далее)

Таблица: ORD3 - «Drop Shipment, History». Маска имени таблицы: «ORD3%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
ORD3001 NCHAR STRING 10 0 10 OrderNo Order Number   1 Да
ORD3002 NCHAR STRING 6 0 6 LineNo Line Number   2 Да
ORD3003 NCHAR STRING 6 0 6 StructLineNo Sub-line Number   3 Да
ORD3004 NCHAR STRING 4 0 4 Number Number   4 Да
ORD3005 DATETIME DATE 0 0 8 DSHistDate Drop Shipment History Date      
ORD3006 NCHAR STRING 6 0 6 DSHistTime Drop Shipment History Time      
ORD3007 DATETIME DATE 0 0 8 DelDatePO Delivery Date Purchase Order      
ORD3008 DATETIME DATE 0 0 8 PurchDatePO Purchase Date      
ORD3009 NVARCHAR VSTRING 1 0 1 POReceipt Purchase Order Receipt Option Handling of Receipt/Issue:
0 - Into Inventory
1 - Into Inventory and hard allocate to sales/service order
2 - Into Inventory and issue to sales/service order
3 - Issue to sales/service order without stock update
   
ORD3010 NVARCHAR VSTRING 1 0 1 POAdjustment Purchase Order Adjustment      
ORD3011 NUMERIC X_NUMERIC 14 8 6 Margin% Margin %      
ORD3012 NVARCHAR VSTRING 1 0 1 MarginRule Margin Rule      
ORD3013 NVARCHAR VSTRING 1 0 1 TextRule Text Rule      
ORD3014 DATETIME DATE 0 0 8 DSDate Drop Shipment Created Date      
ORD3015 NCHAR STRING 6 0 6 DSTime Drop Shipment Create Time      
ORD3016 NVARCHAR VSTRING 10 0 10 Supplier Supplier Code      
ORD3017 NVARCHAR VSTRING 6 0 6 Purchaser Purchaser Code      
ORD3018 NVARCHAR VSTRING 6 0 6 Warehouse Warehouse      
ORD3019 INT INTEGER 0 0 1 Type Type 0 - New
1 - Changed
2 - Deleted
   
ORD3020 NUMERIC MONEY 28 8 20 PurchPrice Purchase Price (Purchase Currency)      
ORD3021 NVARCHAR VSTRING 2 0 2 CurrCode Currency Code Purchase      
ORD3022 NVARCHAR VSTRING 1 0 1 CreateDS Create Drop Shipment 0 - Not decided
1 - Yes, but not created
3 - No
4 - Creation delayed
   
ORD3023 NUMERIC X_NUMERIC 20 8 12 DSPCQty Purchase Quantity      
ORD3024 NUMERIC X_NUMERIC 20 8 12 DSSCQty Stock Quantity      
ORD3025 NVARCHAR VSTRING 8 0 8 UserId User ID      
ORD3026 NCHAR STRING 10 0 10 POOrderNo Purchase Order Number      
ORD3027 NCHAR STRING 6 0 6 POLineNo Purchase Order Line Number      
ORD3028 NCHAR STRING 6 0 6 POStructLineNo Purchase Order Sub-line Number      
ORD3029 NCHAR STRING 25 0 25 Site_Code Site Code      
ORD3030 NCHAR STRING 27 0 27 ContractNo Contract Number      
ORD3031 INT INTEGER 0 0 1 DS_BOM_Dependancy BOM Dependency 0 = No drop shipment, Independent BOM
1 = Own drop shipment, Dependent BOM
2 = Mixed drop shipment
   
ORD3032 NCHAR STRING 12 0 12 ProjectNo Project      
ORD3033 INT INTEGER 0 0 1 Original receipt rule        
ORD3034 NVARCHAR VSTRING 1 0 1 Drop Shipment Code        

Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Sales Order | Drop Shipment History

TopList

© Алексей Васильев. 2004-2019. При использовании материалов ссылка обязательна.