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

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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
ORD2001 NCHAR STRING 10 0 10 OrderNo Order Number   1 Да
ORD2002 NCHAR STRING 6 0 6 LineNo Line Number   2 Да
ORD2003 NCHAR STRING 6 0 6 StructLineNo Sub-line Number   3 Да
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 Margin% 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 Site_Code Site Code      
ORD2024 NCHAR STRING 27 0 27 ContractNo Contract Number      
ORD2025 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
   
ORD2026 NCHAR STRING 12 0 12 ProjectNo Project      
ORD2027 INT INTEGER 0 0 1 Original receipt rule        
ORD2028 NVARCHAR VSTRING 1 0 1 Drop Shipment Code        

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

TopList

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