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

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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PC43001 NCHAR STRING 10 0 10 OrderNo Purchase Order Number   1 Да
PC43002 NCHAR STRING 6 0 6 LineNo Purchase Order Line Number   3 Да
PC43003 NCHAR STRING 6 0 6 StructLineNo Purchase Order Sub-line Number   4 Да
PC43004 NCHAR STRING 4 0 4 AutSubStrLNo Purchase Order Delivery Line Number   5 Да
PC43005 NVARCHAR VSTRING 12 0 12 BatchNumber Batch Number      
PC43006 NUMERIC X_NUMERIC 20 8 12 QtyRequested Quantity Ordered      
PC43007 NUMERIC X_NUMERIC 20 8 12 QtyDelivered Quantity Delivered      
PC43008 NUMERIC X_NUMERIC 20 8 12 QtyPropDeliv Quantity Proposed Delivery      
PC43009 DATETIME DATE 0 0 8 DelDatRequst Delivery Date Requested      
PC43010 DATETIME DATE 0 0 8 DelDateComm Delivery Date Committed      
PC43011 DATETIME DATE 0 0 8 DelivDateActl Actual Delivery Date      
PC43012 NVARCHAR VSTRING 20 0 20 DelivNoteNo Delivery Note Number      
PC43013 NUMERIC X_NUMERIC 28 8 20 DelDatExcRat Delivery Date Exchange Rate      
PC43014 NUMERIC MONEY 28 8 20 UnitPrice Unit Price (Purchase Currency)      
PC43015 INT INTEGER 0 0 1 DocumFLAG Goods Received Note Printed      
PC43016 INT INTEGER 0 0 1 DocumFLAG Goods Received Note Sent (XML)      
PC43017 INT INTEGER 0 0 1 DocumFLAG (obsolete)      
PC43018 INT INTEGER 0 0 1 DocumFLAG (obsolete)      
PC43019 INT INTEGER 0 0 1 DocumFLAG (obsolete)      
PC43020 INT INTEGER 0 0 1 DocumFLAG (obsolete)      
PC43021 INT INTEGER 0 0 1 DocumFLAG (obsolete)      
PC43022 INT INTEGER 0 0 1 DocumFLAG (obsolete)      
PC43023 INT INTEGER 0 0 1 DocumFLAG (obsolete)      
PC43024 INT INTEGER 0 0 1 DocumFLAG (obsolete)      
PC43025 NUMERIC X_NUMERIC 18 8 10 NetWeight Net Weight      
PC43026 NUMERIC X_NUMERIC 18 8 10 GrossWeight Gross Weight      
PC43027 NUMERIC X_NUMERIC 18 8 10 Volume Volume      
PC43028 NVARCHAR VSTRING 1 0 1 SPARE1 (obsolete)      
PC43029 NVARCHAR VSTRING 5 0 5 SPARE2 (obsolete)      
PC43030 NVARCHAR VSTRING 6 0 6 SPARE3 (obsolete)      
PC43031 NVARCHAR VSTRING 3 0 3 SPARE4 (obsolete)      
PC43032 NUMERIC X_NUMERIC 14 8 6 Discount Discount      
PC43033 NVARCHAR VSTRING 6 0 6 DeliveryTime Delivery Time      
PC43034 NUMERIC X_NUMERIC 14 8 6 PurchSurchar Purchase On-charge      
PC43035 NUMERIC X_NUMERIC 20 8 12 QtyInvSCUnit Quantity Invoiced (Stock Unit)      
PC43036 NUMERIC X_NUMERIC 20 8 12 QtyDelSCUnit Quantity Delivered (Stock Unit)      
PC43037 NUMERIC X_NUMERIC 20 8 12 QtyInvPCUnit Quantity Invoiced (Purchase Unit)      
PC43038 NUMERIC X_NUMERIC 18 8 10 DlvryDateExchgRate2 Delivery Date Exchange Rate 2      
PC43039 NCHAR STRING 3 0 3 DlvryDateExchgAlgtm Delivery Date Exchange Rate Algorithm      
PC43040 INT INTEGER 0 0 2 CurrencyCode Currency Code Order      
PC43041 NVARCHAR VSTRING 10 0 10 AutoDelNoteNo Internal Goods Received Note Number      
PC43042 NVARCHAR VSTRING 10 0 10 ConsGoodsRecNoteNo Consolidated Goods Received Note Number      
PC43043 NVARCHAR VSTRING 1 0 1 InclInCGRNFlag Has Been Included in Goods Received Note      
PC43044 NVARCHAR VSTRING 15 0 15 InvoiceNo_Last Invoice Number   2 Да
PC43045 INT INTEGER 0 0 2 ConsCurrCode Currency Code Alternative      
PC43046 NUMERIC X_NUMERIC 18 8 10 CCExchgRate1 Alternative Currency Exchange Rate      
PC43047 NUMERIC X_NUMERIC 18 8 10 CCExchgRate2 Alternative Currency Exchange Rate 2      
PC43048 NCHAR STRING 3 0 3 CCExchgAlgtm Alternative Currency Exchange Rate Algorithm      
PC43049 NUMERIC MONEY 28 8 20 Allocation of costs on PO Allocation of Costs on Purchase Order      
PC43050 NUMERIC X_NUMERIC 28 8 20 Qty_PCUnit_LastInvoice LastInvoice Qty in PCUnit      
PC43051 NUMERIC X_NUMERIC 28 8 20 Qty_SCUnit_LastInvoice LastInvoice Qty in SCUnit      
PC43052 NCHAR SWITCH 1 0 1 Product Label Printed Product Label Printed      
PC43053 NUMERIC X_NUMERIC 20 8 12 Rejected quantity Rejected quantity      
PC43054 NVARCHAR VSTRING 4 0 4 Rejection Code Rejection Code      
PC43055 NVARCHAR VSTRING 12 0 12 Temperature Temperature      
PC43056 NVARCHAR VSTRING 12 0 12 Humidity Humidity      
PC43057 NVARCHAR VSTRING 12 0 12 User def. 1 User def. 1      
PC43058 NVARCHAR VSTRING 12 0 12 User def. 2 User def. 2      
PC43059 NVARCHAR VSTRING 12 0 12 User def. 3 User def. 3      
PC43060 NVARCHAR VSTRING 12 0 12 User def. 4 User def. 4      
PC43061 NVARCHAR VSTRING 12 0 12 User def. 5 User def. 5      
PC43062 NUMERIC MONEY 28 8 20 Subcontract cost Subcontract cost      

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

TopList

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