Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else... / Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще...
Таблица: 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