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

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица ORD3 — Drop Shipment History

Таблица: 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 MarginPercent 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 SiteCode Site Code      
ORD3030 NCHAR STRING 27 0 27 ContractNo Contract Number      
ORD3031 INT INTEGER 0 0 1 DSBOMDependancy 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 OrigReceiptRule Original receipt rule      
ORD3034 NVARCHAR VSTRING 1 0 1 DropShipmentCode Drop Shipment Code      

Навигация: