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

Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Таблица / Table PC43 — Purchase Order Delivery Lines History

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PC43001 NCHAR STRING 10 0 10 OrderNo Purchase Order Number   1 Да / Yes
PC43002 NCHAR STRING 6 0 6 LineNo Purchase Order Line Number   3 Да / Yes
PC43003 NCHAR STRING 6 0 6 StructLineNo Purchase Order Sub-line Number   4 Да / Yes
PC43004 NCHAR STRING 4 0 4 AutSubStrLNo Purchase Order Delivery Line Number   5 Да / Yes
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 FlagGRNPrinted Goods Received Note Printed      
PC43016 INT INTEGER 0 0 1 FlagGRNSent Goods Received Note Sent (XML)      
PC43017 INT INTEGER 0 0 1 DocumFLAG1 (obsolete)      
PC43018 INT INTEGER 0 0 1 DocumFLAG2 (obsolete)      
PC43019 INT INTEGER 0 0 1 DocumFLAG3 (obsolete)      
PC43020 INT INTEGER 0 0 1 DocumFLAG4 (obsolete)      
PC43021 INT INTEGER 0 0 1 DocumFLAG5 (obsolete)      
PC43022 INT INTEGER 0 0 1 DocumFLAG6 (obsolete)      
PC43023 INT INTEGER 0 0 1 DocumFLAG7 (obsolete)      
PC43024 INT INTEGER 0 0 1 DocumFLAG8 (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 20 8 12 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 25 0 25 InvoiceNoLast Invoice Number   2 Да / Yes
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 AllocCostsOnPO Allocation of Costs on Purchase Order      
PC43050 NUMERIC X_NUMERIC 28 8 20 QtyPCUnitLastInvoice LastInvoice Qty in PCUnit      
PC43051 NUMERIC X_NUMERIC 28 8 20 QtySCUnitLastInvoice LastInvoice Qty in SCUnit      
PC43052 NCHAR SWITCH 1 0 1 ProductLabelPrinted Product Label Printed      
PC43053 NUMERIC X_NUMERIC 20 8 12 QtyRejected Rejected quantity      
PC43054 NVARCHAR VSTRING 4 0 4 RejectionCode Rejection Code      
PC43055 NVARCHAR VSTRING 12 0 12 Temperature Temperature      
PC43056 NVARCHAR VSTRING 12 0 12 Humidity Humidity      
PC43057 NVARCHAR VSTRING 12 0 12 UserDef1 User def. 1      
PC43058 NVARCHAR VSTRING 12 0 12 UserDef2 User def. 2      
PC43059 NVARCHAR VSTRING 12 0 12 UserDef3 User def. 3      
PC43060 NVARCHAR VSTRING 12 0 12 UserDef4 User def. 4      
PC43061 NVARCHAR VSTRING 12 0 12 UserDef5 User def. 5      
PC43062 NUMERIC MONEY 28 8 20 SubcontractCost Subcontract cost      
PC43063 NCHAR STRING 1 0 1 TaxRegStatus Tax Reg. Status      
PC43064 DATETIME DATE 0 0 8 TaxRegDate Tax Reg. Date      

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