На один уровень вверх / One level Up: Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Список таблиц модуля /List of tables of module «Purchase Order»

Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Таблица / Table PC42 — Purchase Order Lines History

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PC42001 NCHAR STRING 10 0 10 PurchaOrdNo Purchase Order Number   1 Да / Yes
PC42002 NCHAR STRING 6 0 6 LineNumber Purchase Order Line Number   3 Да / Yes
PC42003 NCHAR STRING 6 0 6 StructLineNo Purchase Order Sub-line Number   4 Да / Yes
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 AccountCode1 Accounting Code 1      
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 25 0 25 SPARE NomenclatureNo Nomenclature Number    
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 ItemType Item Type      
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 FlagLineConfirmed 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 ACCSTR 120 0 120 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 PurchaserDepartment 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 25 0 25 InvoiceNumber Invoice Number   2 Да / Yes
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 MarginPercent 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 QtyPCUnitLastInvoice Quantity Last Invoiced      
PC42075 NUMERIC X_NUMERIC 20 8 12 QtySCUnitLastInvoice 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 BlockForProcess 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 OriginalConfDD 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      
PC42088 INT INTEGER 0 0 1 LinkedToContract Linked to Contract      
PC42089 NCHAR STRING 2 0 2 AccountCode2 Accounting Code 2      
PC42090 NVARCHAR VSTRING 10 0 10 ContractNumber Contract Number      
PC42091 NCHAR STRING 6 0 6 ContractLineNumber Contract Line Number      
PC42092 NCHAR STRING 6 0 6 DeliveryScheduleLineNumber Delivery Schedule Line Number      
PC42093 DATETIME DATE 0 0 8 OrgReqDeliveryDate Org. Req. Delivery Date      
PC42094 NVARCHAR VSTRING 35 0 35 CommodityCode Commodity code      
PC42095 NVARCHAR VSTRING 10 0 10 ProductTaxType Product Tax Type      
PC42096 NVARCHAR VSTRING 10 0 10 FinancialOperationCode Financial Operation Code      
PC42097 NVARCHAR VSTRING 150 0 150 ExUserDef1 Extended User-Defined Field 1      
PC42098 NVARCHAR VSTRING 150 0 150 ExUserDef2 Extended User-Defined Field 2      
PC42099 NVARCHAR VSTRING 150 0 150 ExUserDef3 Extended User-Defined Field 3      
PC42100 NVARCHAR VSTRING 150 0 150 ExUserDef4 Extended User-Defined Field 4      
PC42101 NVARCHAR VSTRING 150 0 150 ExUserDef5 Extended User-Defined Field 5      
PC42102 NVARCHAR VSTRING 150 0 150 ExUserDef6 Extended User-Defined Field 6      
PC42103 NVARCHAR VSTRING 150 0 150 ExUserDef7 Extended User-Defined Field 7      
PC42104 NVARCHAR VSTRING 150 0 150 ExUserDef8 Extended User-Defined Field 8      
PC42105 NVARCHAR VSTRING 150 0 150 ExUserDef9 Extended User-Defined Field 9      
PC42106 NVARCHAR VSTRING 150 0 150 ExUserDef10 Extended User-Defined Field 10      
PC42107 NVARCHAR VSTRING 150 0 150 ExUserDef11 Extended User-Defined Field 11      
PC42108 NVARCHAR VSTRING 150 0 150 ExUserDef12 Extended User-Defined Field 12      
PC42109 NVARCHAR VSTRING 150 0 150 ExUserDef13 Extended User-Defined Field 13      
PC42110 NVARCHAR VSTRING 150 0 150 ExUserDef14 Extended User-Defined Field 14      
PC42111 NVARCHAR VSTRING 150 0 150 ExUserDef15 Extended User-Defined Field 15      
PC42112 NVARCHAR VSTRING 150 0 150 ExUserDef16 Extended User-Defined Field 16      
PC42113 NVARCHAR VSTRING 150 0 150 ExUserDef17 Extended User-Defined Field 17      
PC42114 NVARCHAR VSTRING 150 0 150 ExUserDef18 Extended User-Defined Field 18      
PC42115 NVARCHAR VSTRING 150 0 150 ExUserDef19 Extended User-Defined Field 19      
PC42116 NVARCHAR VSTRING 150 0 150 ExUserDef20 Extended User-Defined Field 20      
PC42117 NVARCHAR VSTRING 10 0 10 Requisition Requisition      
PC42118 NCHAR STRING 4 0 4 RqsnLine Requisition Line      
PC42119 INT INTEGER 0 0 1 DeliveryBlock Delivery Block      

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