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

Таблица: PC19 - «Purchase Order Delivery Lines». Маска имени таблицы: «PC19%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PC19001 NCHAR STRING 10 0 10 OrderNo Purchase Order Number   1 Да
PC19002 NCHAR STRING 6 0 6 LineNo Purchase Order Line Number   2 Да
PC19003 NCHAR STRING 6 0 6 StructLineNo Purchase Order Sub-line Number   3 Да
PC19004 NCHAR STRING 4 0 4 AutSubStrLNo Purchase Order Delivery Line Number   4 Да
PC19005 NVARCHAR VSTRING 12 0 12 BatchNumber Batch Number      
PC19006 NUMERIC X_NUMERIC 20 8 12 QtyRequested Quantity Ordered      
PC19007 NUMERIC X_NUMERIC 20 8 12 QtyDelivered Quantity Delivered      
PC19008 NUMERIC X_NUMERIC 20 8 12 QtyPropDeliv Quantity Proposed Delivery      
PC19009 DATETIME DATE 0 0 8 DelDatRequst Delivery Date Requested      
PC19010 DATETIME DATE 0 0 8 DelDateComm Delivery Date Committed      
PC19011 DATETIME DATE 0 0 8 DelivDateActl Delivery Date Actual      
PC19012 NVARCHAR VSTRING 20 0 20 DelivNoteNo Delivery Note Number      
PC19013 NUMERIC X_NUMERIC 28 8 20 DelDatExcRat Delivery Date Exchange Rate      
PC19014 NUMERIC MONEY 28 8 20 UnitPrice Unit Price (Purchase Currency)      
PC19015 INT INTEGER 0 0 1 DocumFLAG Goods Received Note Printed      
PC19016 INT INTEGER 0 0 1 DocumFLAG Goods Received Note Sent (XML)      
PC19017 INT INTEGER 0 0 1 DocumFLAG (obsolete)      
PC19018 INT INTEGER 0 0 1 DocumFLAG (obsolete)      
PC19019 INT INTEGER 0 0 1 DocumFLAG (obsolete)      
PC19020 INT INTEGER 0 0 1 DocumFLAG (obsolete)      
PC19021 INT INTEGER 0 0 1 DocumFLAG (obsolete)      
PC19022 INT INTEGER 0 0 1 DocumFLAG (obsolete)      
PC19023 INT INTEGER 0 0 1 DocumFLAG (obsolete)      
PC19024 INT INTEGER 0 0 1 DocumFLAG (obsolete)      
PC19025 NUMERIC X_NUMERIC 18 8 10 NetWeight Net Weight      
PC19026 NUMERIC X_NUMERIC 18 8 10 GrossWeight Gross Weight      
PC19027 NUMERIC X_NUMERIC 18 8 10 Volume Volume      
PC19028 NVARCHAR VSTRING 1 0 1 SPARE1 (obsolete)      
PC19029 NVARCHAR VSTRING 5 0 5 SPARE2 (obsolete)      
PC19030 NVARCHAR VSTRING 6 0 6 SPARE3 (obsolete)      
PC19031 NVARCHAR VSTRING 3 0 3 SPARE4 (obsolete)      
PC19032 NUMERIC X_NUMERIC 14 8 6 Discount Discount      
PC19033 NVARCHAR VSTRING 6 0 6 DeliveryTime Time Entered      
PC19034 NUMERIC X_NUMERIC 14 8 6 PurchSurchar Purchase On-charge      
PC19035 NUMERIC X_NUMERIC 20 8 12 QtyInvSCUnit Quantity Invoiced (Stock Unit)      
PC19036 NUMERIC X_NUMERIC 20 8 12 QtyDelSCUnit Quantity Delivered (Stock Unit)      
PC19037 NUMERIC X_NUMERIC 20 8 12 QtyInvPCUnit Quantity Invoiced (Purchase Unit)      
PC19038 NUMERIC X_NUMERIC 18 8 10 DlvryDateExchgRate2 Delivery Date Exchange Rate 2      
PC19039 NCHAR STRING 3 0 3 DlvryDateExchgAlgtm Delivery Date Exchange Rate Algorithm      
PC19040 INT INTEGER 0 0 2 CurrencyCode Currency Code Order      
PC19041 NVARCHAR VSTRING 10 0 10 AutoDelNoteNo Internal Goods Received Note Number      
PC19042 NVARCHAR VSTRING 10 0 10 ConsGoodsRecNoteNo Consolidated Goods Received Note Number      
PC19043 NVARCHAR VSTRING 1 0 1 InclInCGRNFlag Has Been Included in Goods Received Note      
PC19044 NVARCHAR VSTRING 15 0 15 InvoiceNo_Last Invoice Number      
PC19045 INT INTEGER 0 0 2 ConsCurrCode Currency Code Alternative      
PC19046 NUMERIC X_NUMERIC 18 8 10 CCExchgRate1 Alternative Currency Exchange Rate      
PC19047 NUMERIC X_NUMERIC 18 8 10 CCExchgRate2 Alternative Currency Exchange Rate 2      
PC19048 NCHAR STRING 3 0 3 CCExchgAlgtm Alternative Currency Exchange Rate Algorithm      
PC19049 NUMERIC MONEY 28 8 20 Allocation of costs on PO Allocation of Costs on Purchase Order      
PC19050 NUMERIC X_NUMERIC 28 8 20 Qty_PCUnit_LastInvoice LastInvoice Qty in PCUnit      
PC19051 NUMERIC X_NUMERIC 28 8 20 Qty_SCUnit_LastInvoice LastInvoice Qty in SCUnit      
PC19052 NCHAR SWITCH 1 0 1 Product Label Printed Product Label Printed      
PC19053 NUMERIC X_NUMERIC 20 8 12 Rejected quantity Rejected quantity      
PC19054 NVARCHAR VSTRING 4 0 4 Rejection Code Rejection Code      
PC19055 NVARCHAR VSTRING 12 0 12 Temperature Temperature      
PC19056 NVARCHAR VSTRING 12 0 12 Humidity Humidity      
PC19057 NVARCHAR VSTRING 12 0 12 User def. 1 User def. 1      
PC19058 NVARCHAR VSTRING 12 0 12 User def. 2 User def. 2      
PC19059 NVARCHAR VSTRING 12 0 12 User def. 3 User def. 3      
PC19060 NVARCHAR VSTRING 12 0 12 User def. 4 User def. 4      
PC19061 NVARCHAR VSTRING 12 0 12 User def. 5 User def. 5      
PC19062 NUMERIC MONEY 28 8 20 Subcontract cost Subcontract cost      

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

TopList

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