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 ORD2 — Drop Shipment Lines

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
ORD2001 NCHAR STRING 10 0 10 OrderNo Order Number   1 Да / Yes
ORD2002 NCHAR STRING 6 0 6 LineNo Line Number   2 Да / Yes
ORD2003 NCHAR STRING 6 0 6 StructLineNo Sub-line Number   3 Да / Yes
ORD2004 DATETIME DATE 0 0 8 DelDatePO Delivery Date Purchase Order      
ORD2005 DATETIME DATE 0 0 8 PurchDatePO Purchase Date      
ORD2006 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
   
ORD2007 NVARCHAR VSTRING 1 0 1 POAdjustment Purchase Order Adjustment      
ORD2008 NUMERIC X_NUMERIC 14 8 6 MarginPercent Margin %      
ORD2009 NVARCHAR VSTRING 1 0 1 MarginRule Margin Rule      
ORD2010 NVARCHAR VSTRING 1 0 1 TextRule Text Rule      
ORD2011 DATETIME DATE 0 0 8 DSDate Drop Shipment Created Date      
ORD2012 NCHAR STRING 6 0 6 DSTime Drop Shipment Create Time      
ORD2013 NVARCHAR VSTRING 10 0 10 Supplier Supplier Code      
ORD2014 NVARCHAR VSTRING 6 0 6 Purchaser Purchaser Code      
ORD2015 NVARCHAR VSTRING 6 0 6 Warehouse Warehouse      
ORD2016 INT INTEGER 0 0 1 Type Type 0 — New

1 — Changed

2 — Deleted
   
ORD2017 NUMERIC MONEY 28 8 20 PurchPrice Purchase Price (Purchase Currency)      
ORD2018 NVARCHAR VSTRING 2 0 2 CurrCode Currency Code Purchase      
ORD2019 NVARCHAR VSTRING 1 0 1 CreateDS Create Drop Shipment 0 — Not decided

1 — Yes, but not created

3 — No

4 — Creation delayed
   
ORD2020 NUMERIC X_NUMERIC 20 8 12 DSPCQty Purchase Quantity      
ORD2021 NUMERIC X_NUMERIC 20 8 12 DSSCQty Stock Quantity      
ORD2022 NVARCHAR VSTRING 8 0 8 UserId User ID      
ORD2023 NCHAR STRING 25 0 25 SiteCode Site Code      
ORD2024 NCHAR STRING 27 0 27 ContractNo Contract Number      
ORD2025 INT INTEGER 0 0 1 DSBOMDependancy BOM Dependency 0 = No drop shipment, Independent BOM

1 = Own drop shipment, Dependent BOM

2 = Mixed drop shipment
   
ORD2026 NCHAR STRING 12 0 12 ProjectNo Project      
ORD2027 INT INTEGER 0 0 1 OrigReceiptRule Original receipt rule      
ORD2028 NVARCHAR VSTRING 1 0 1 DropShipmentCode Drop Shipment Code      

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