Таблица: PC42 - «Purchase Order Lines History». Маска имени таблицы: «PC42%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
PC42001 | NCHAR | STRING | 10 | 0 | 10 | PurchaOrdNo | Purchase Order Number | 1 | Да | |
PC42002 | NCHAR | STRING | 6 | 0 | 6 | LineNumber | Purchase Order Line Number | 3 | Да | |
PC42003 | NCHAR | STRING | 6 | 0 | 6 | StructLineNo | Purchase Order Sub-line Number | 4 | Да | |
PC42004 | INT | INTEGER | 0 | 0 | 1 | LineType | Line Type | |||
PC42005 | NVARCHAR | VSTRING | 35 | 0 | 35 | StockCode | Stock Item Code | |||
PC42006 | NVARCHAR | VSTRING | 25 | 0 | 25 | DescriptLine1 | Description Line 1 | |||
PC42007 | NVARCHAR | VSTRING | 25 | 0 | 25 | DescriptLine2 | Description Line 2 | |||
PC42008 | NUMERIC | MONEY | 28 | 8 | 20 | UnitPrice | Unit Price (Order Currency) | |||
PC42009 | INT | INTEGER | 0 | 0 | 4 | UnitCode | Unit Code | |||
PC42010 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | PCQtyOrdered | Quantity Ordered | |||
PC42011 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | PCQtyReceive | Quantity Received | |||
PC42012 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | PCQtyInvoice | Quantity Invoiced | |||
PC42013 | NCHAR | STRING | 2 | 0 | 2 | AccountCode | Accounting Code | |||
PC42014 | NCHAR | SWITCH | 1 | 0 | 1 | FLAGBackOrd | Back Order | |||
PC42015 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | Discount | Discount | |||
PC42016 | DATETIME | DATE | 0 | 0 | 8 | DelDateCommi | Delivery Date Committed | |||
PC42017 | DATETIME | DATE | 0 | 0 | 8 | DelDateActua | Actual Delivery Date | |||
PC42018 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | QtyUnitInDel | Items per Package (Purchase) | |||
PC42019 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | CostPrcMult | Cost Price Multiplier | |||
PC42020 | NVARCHAR | VSTRING | 3 | 0 | 3 | SPARE | (obsolete) | |||
PC42021 | INT | INTEGER | 0 | 0 | 1 | TransactSour | Related Type of Order | 1 - Sales Order 2 - Service Order 3 - Work Order |
||
PC42022 | NVARCHAR | VSTRING | 1 | 0 | 1 | SPARE | (obsolete) | |||
PC42023 | INT | INTEGER | 0 | 0 | 1 | StockStatus | Stock Item Status | |||
PC42024 | DATETIME | DATE | 0 | 0 | 8 | BatchCreatDt | Date Batch Created | |||
PC42025 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | DelExchRate | Delivery Date Exchange Rate | |||
PC42026 | NVARCHAR | VSTRING | 1 | 0 | 1 | Spare | (obsolete) | |||
PC42027 | NCHAR | STRING | 1 | 0 | 1 | FLAGNewOrLin | New Order Line | |||
PC42028 | NVARCHAR | VSTRING | 1 | 0 | 1 | UserOption2 | UserOption2 | |||
PC42029 | NVARCHAR | VSTRING | 1 | 0 | 1 | Flag_Line_Confirmed | Line Confirmed | |||
PC42030 | DATETIME | DATE | 0 | 0 | 8 | DelDateReque | Delivery Date Requested | |||
PC42031 | DATETIME | DATE | 0 | 0 | 8 | DelDatBackOr | Delivery Date Back Order | |||
PC42032 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | NetWeight | Net Weight | |||
PC42033 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | GrossWeight | Gross Weight | |||
PC42034 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | Volume | Volume | |||
PC42035 | NVARCHAR | VSTRING | 6 | 0 | 6 | WarehouseID | Warehouse | |||
PC42036 | NVARCHAR | VSTRING | 50 | 0 | 50 | AccounString | Accounting String | |||
PC42037 | NVARCHAR | VSTRING | 12 | 0 | 12 | ProjectRefer | Project Reference | |||
PC42038 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | QtyRecDispNt | Total Received Quantity | |||
PC42039 | NVARCHAR | VSTRING | 10 | 0 | 10 | OrReference | Order Reference | |||
PC42040 | NVARCHAR | VSTRING | 9 | 0 | 9 | Purchaser/Department | Purchaser/Department | |||
PC42041 | NVARCHAR | VSTRING | 12 | 0 | 12 | DelivBatchNo | Delivery Batch Number | |||
PC42042 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | UnConvForPur | Unit Conversion Factor Purchase to Stock | |||
PC42043 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | DeliverQtySC | Quantity Received (Stock Unit) | |||
PC42044 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | OrdQtySCunit | Quantity Ordered (Stock Unit) | |||
PC42045 | NCHAR | STRING | 14 | 0 | 14 | OrdLineRefer | Order Line Reference | |||
PC42046 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | RemainQtySC | Remaining Quantity (Stock Unit) | |||
PC42047 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | RemainQtyPC | Remaining Quantity | |||
PC42048 | NCHAR | STRING | 1 | 0 | 1 | SubType | Sub Type | |||
PC42049 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | QCQuantity | Quantity on Quality Control | |||
PC42050 | NCHAR | STRING | 1 | 0 | 1 | StatusQC | Status Quality Control | |||
PC42051 | NVARCHAR | VSTRING | 27 | 0 | 27 | Contract | Contract | |||
PC42052 | NCHAR | STRING | 3 | 0 | 3 | Spare1 | (obsolete) | |||
PC42053 | NCHAR | STRING | 3 | 0 | 3 | Spare2 | (obsolete) | |||
PC42054 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | DelExchRate2 | Delivery Date Exchange Rate 2 | |||
PC42055 | NCHAR | STRING | 3 | 0 | 3 | DelExchRateAlg | Delivery Date Exchange Rate Algorithm | |||
PC42056 | INT | INTEGER | 0 | 0 | 2 | CurrencyCode | Currency Code Order | |||
PC42057 | NCHAR | STRING | 1 | 0 | 1 | OverDeliveryControl | Over Delivery Control | |||
PC42058 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | OverDeliveryPerc | Over Delivery % | |||
PC42059 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | OverDeliveryQTY | Over Delivery Quantity | |||
PC42060 | NCHAR | SWITCH | 1 | 0 | 1 | EDIContractSwitch | EDI-Contract | |||
PC42061 | INT | INTEGER | 0 | 0 | 2 | OrigPriceCurCode | Currency Code Original Price | |||
PC42062 | NUMERIC | MONEY | 28 | 8 | 20 | OrigUnitPrice | Original Unit Price | |||
PC42063 | NCHAR | STRING | 20 | 0 | 20 | SupplierOrderNumber | Supplier Order Number | |||
PC42064 | NCHAR | STRING | 20 | 0 | 20 | SupplierOrderLineRef | Supplier Order Line Reference | |||
PC42065 | NCHAR | STRING | 12 | 0 | 12 | LineNumberOrg | Line Number Original Line | |||
PC42066 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | PCQtyOrderedOrg | Original Quantity Ordered | |||
PC42067 | NVARCHAR | VSTRING | 15 | 0 | 15 | Invoice number | Invoice Number | 2 | Да | |
PC42068 | NVARCHAR | VSTRING | 1 | 0 | 1 | POReceipt | Drop Shipment Receipt Rule | 0 - Receive into Inventory
1 - Receive into Inventory and hard allocate to sales/service order 2 - Receive into Inventory and issue to sales/service order 3 - Issue to sales/service order without inventory update |
||
PC42069 | NVARCHAR | VSTRING | 1 | 0 | 1 | POAdjustment | Drop Shipment Adjustment Allowed | |||
PC42070 | NVARCHAR | VSTRING | 1 | 0 | 1 | MarginRule | Delivery Margin Rule | |||
PC42071 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | Margin% | Delivery Margin % | |||
PC42072 | NVARCHAR | VSTRING | 1 | 0 | 1 | DSLine | Drop Shipment Line | |||
PC42073 | NVARCHAR | VSTRING | 20 | 0 | 20 | Owner | Owner | |||
PC42074 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Qty_PCUnit_LastInvoice | Quantity Last Invoiced | |||
PC42075 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Qty_SCUnit_LastInvoice | Quantity Last Invoiced (Stock Unit) | |||
PC42076 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | Spare | (obsolete) | |||
PC42077 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | Spare | (obsolete) | |||
PC42078 | NCHAR | STRING | 38 | 0 | 38 | NodeID_BOM_PC | BoM Node ID Purchase Order | |||
PC42079 | NCHAR | STRING | 38 | 0 | 38 | NodeID_BOM_SC | BoM Node ID Stock | |||
PC42080 | NCHAR | STRING | 1 | 0 | 1 | Blocked for Processing | BoM Blocked for Processing | |||
PC42081 | NVARCHAR | VSTRING | 10 | 0 | 10 | InstallationCustomer | Installation Customer | |||
PC42082 | NVARCHAR | VSTRING | 4 | 0 | 4 | InstallationSite | Installation Site | |||
PC42083 | NCHAR | STRING | 10 | 0 | 10 | ServiceMasterOrder | Service Master Order | |||
PC42084 | DATETIME | DATE | 0 | 0 | 8 | Original Conf.DD | Original Confirmed Delivery Date | |||
PC42085 | INT | INTEGER | 0 | 0 | 1 | CreationSource | Creation Source | |||
PC42086 | NCHAR | STRING | 6 | 0 | 6 | TaxCode | Tax Code | |||
PC42087 | DATETIME | DATE | 0 | 0 | 8 | ReminderDateFPO | Reminder Date FPO |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Purchase Order | Purchase Order Lines History