One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Заказы на Продажу» / List of tables of module «Sales Order»

Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Таблица / Table ORD3 — Drop Shipment History

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
ORD3001 NCHAR STRING 10 0 10 OrderNo Order Number   1 Да / Yes
ORD3002 NCHAR STRING 6 0 6 LineNo Line Number   2 Да / Yes
ORD3003 NCHAR STRING 6 0 6 StructLineNo Sub-line Number   3 Да / Yes
ORD3004 NCHAR STRING 4 0 4 Number Number   4 Да / Yes
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      

Навигация / Navigation: