Таблица: 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 - Not linked to other order type
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