Таблица: 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