One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Заказы на Закупку» / List of tables of module «Purchase Order»

Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Таблица / Table PC03 — Purchase Order Lines

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PC03001 NCHAR STRING 10 0 10 PurchaOrdNo Purchase Order Number   1 Да / Yes
PC03002 NCHAR STRING 6 0 6 LineNumber Purchase Order Line Number   2 Да / Yes
PC03003 NCHAR STRING 6 0 6 StructLineNo Purchase Order Sub-line Number   3 Да / Yes
PC03004 INT INTEGER 0 0 1 LineType Line Type 0 — Stock Item Line

1 — Non Stock Item Line (dot item)
   
PC03005 NVARCHAR VSTRING 35 0 35 StockCode Stock Item Code      
PC03006 NVARCHAR VSTRING 25 0 25 DescriptLine1 Description Line 1      
PC03007 NVARCHAR VSTRING 25 0 25 DescriptLine2 Description Line 2      
PC03008 NUMERIC MONEY 28 8 20 UnitPrice Unit Price (Order Currency)      
PC03009 INT INTEGER 0 0 4 UnitCode Unit Code      
PC03010 NUMERIC X_NUMERIC 20 8 12 PCQtyOrdered Quantity Ordered      
PC03011 NUMERIC X_NUMERIC 20 8 12 PCQtyReceive Quantity Received      
PC03012 NUMERIC X_NUMERIC 20 8 12 PCQtyInvoice Quantity Invoiced      
PC03013 NCHAR STRING 2 0 2 AccountCode1 Accounting Code 1      
PC03014 NCHAR SWITCH 1 0 1 FLAGBackOrd Back Order      
PC03015 NUMERIC X_NUMERIC 14 8 6 Discount Discount      
PC03016 DATETIME DATE 0 0 8 DelDateCommi Delivery Date Committed      
PC03017 DATETIME DATE 0 0 8 DelDateActua Actual Delivery Date      
PC03018 NUMERIC X_NUMERIC 18 8 10 QtyUnitInDel Items per Package (Purchase)      
PC03019 NUMERIC X_NUMERIC 18 8 10 CostPrcMult Cost Price Multiplier      
PC03020 NVARCHAR VSTRING 25 0 25 NomenclatureNo Nomenclature Number      
PC03021 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
   
PC03022 NVARCHAR VSTRING 1 0 1 ItemType Item Type      
PC03023 INT INTEGER 0 0 1 StockStatus Stock Item Status      
PC03024 DATETIME DATE 0 0 8 BatchCreatDt Date Batch Created      
PC03025 NUMERIC X_NUMERIC 28 8 20 DelExchRate Delivery Date Exchange Rate      
PC03026 NVARCHAR VSTRING 1 0 1 Spare (obsolete)      
PC03027 NCHAR STRING 1 0 1 FLAGNewOrLin New Order Line      
PC03028 NVARCHAR VSTRING 1 0 1 UserOption2 UserOption2      
PC03029 NVARCHAR VSTRING 1 0 1 FlagLineConfirmed Line Confirmed      
PC03030 DATETIME DATE 0 0 8 DelDateReque Delivery Date Requested      
PC03031 DATETIME DATE 0 0 8 DelDatBackOr Delivery Date Back Order      
PC03032 NUMERIC X_NUMERIC 18 8 10 NetWeight Net Weight      
PC03033 NUMERIC X_NUMERIC 18 8 10 GrossWeight Gross Weight      
PC03034 NUMERIC X_NUMERIC 18 8 10 Volume Volume      
PC03035 NVARCHAR VSTRING 6 0 6 WarehouseID Warehouse      
PC03036 NVARCHAR VSTRING 50 0 50 AccounString Accounting String      
PC03037 NVARCHAR VSTRING 12 0 12 ProjectRefer Project Reference      
PC03038 NUMERIC X_NUMERIC 20 8 12 QtyRecDispNt Total Received Quantity      
PC03039 NVARCHAR VSTRING 10 0 10 OrReference Order Reference      
PC03040 NVARCHAR VSTRING 9 0 9 PurchaserDepartment Purchaser/Department      
PC03041 NVARCHAR VSTRING 12 0 12 DelivBatchNo Delivery Batch Number      
PC03042 NUMERIC X_NUMERIC 18 8 10 UnConvForPur Unit Conversion Factor Purchase to Stock      
PC03043 NUMERIC X_NUMERIC 20 8 12 DeliverQtySC Quantity Received (Stock Unit)      
PC03044 NUMERIC X_NUMERIC 20 8 12 OrdQtySCunit Quantity Ordered (Stock Unit)      
PC03045 NCHAR STRING 14 0 14 OrdLineRefer Order Line Reference      
PC03046 NUMERIC X_NUMERIC 20 8 12 RemainQtySC Remaining Quantity (Stock Unit)      
PC03047 NUMERIC X_NUMERIC 20 8 12 RemainQtyPC Remaining Quantity      
PC03048 NCHAR STRING 1 0 1 SubType Sub Type      
PC03049 NUMERIC X_NUMERIC 20 8 12 QCQuantity Quantity on Quality Control      
PC03050 NCHAR STRING 1 0 1 StatusQC Status Quality Control      
PC03051 NVARCHAR VSTRING 27 0 27 Contract Contract      
PC03052 NCHAR STRING 3 0 3 Spare1 (obsolete)      
PC03053 NCHAR STRING 3 0 3 Spare2 (obsolete)      
PC03054 NUMERIC X_NUMERIC 18 8 10 DelExchRate2 Delivery Date Exchange Rate 2      
PC03055 NCHAR STRING 3 0 3 DelExchRateAlg Delivery Date Exchange Rate Algorithm      
PC03056 INT INTEGER 0 0 2 CurrencyCode Currency Code Order      
PC03057 NCHAR STRING 1 0 1 OverDeliveryControl Over Delivery Control      
PC03058 NUMERIC X_NUMERIC 14 8 6 OverDeliveryPerc Over Delivery %      
PC03059 NUMERIC X_NUMERIC 20 8 12 OverDeliveryQTY Over Delivery Quantity      
PC03060 NCHAR SWITCH 1 0 1 EDIContractSwitch EDI-Contract      
PC03061 INT INTEGER 0 0 2 OrigPriceCurCode Currency Code Original Price      
PC03062 NUMERIC MONEY 28 8 20 OrigUnitPrice Original Unit Price      
PC03063 NCHAR STRING 20 0 20 SupplierOrderNumber Supplier Order Number      
PC03064 NCHAR STRING 20 0 20 SupplierOrderLineRef Supplier Order Line Reference      
PC03065 NCHAR STRING 12 0 12 LineNumberOrg Line Number Original Line      
PC03066 NUMERIC X_NUMERIC 20 8 12 PCQtyOrderedOrg Original Quantity Ordered      
PC03067 NVARCHAR VSTRING 25 0 25 InvoiceNumber Invoice Number      
PC03068 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
   
PC03069 NVARCHAR VSTRING 1 0 1 POAdjustment Drop Shipment Adjustment Allowed      
PC03070 NVARCHAR VSTRING 1 0 1 MarginRule Delivery Margin Rule      
PC03071 NUMERIC X_NUMERIC 14 8 6 MarginPercent Delivery Margin %      
PC03072 NVARCHAR VSTRING 1 0 1 DSLine Drop Shipment Line      
PC03073 NVARCHAR VSTRING 20 0 20 Owner Owner      
PC03074 NUMERIC X_NUMERIC 20 8 12 QtyPCUnitLastInvoice Quantity Last Invoiced      
PC03075 NUMERIC X_NUMERIC 20 8 12 QtySCUnitLastInvoice Quantity Last Invoiced (Stock Unit)      
PC03076 NUMERIC X_NUMERIC 28 8 20 Spare (obsolete)      
PC03077 NUMERIC X_NUMERIC 28 8 20 Spare (obsolete)      
PC03078 NCHAR STRING 38 0 38 NodeID_BOM_PC BoM Node ID Purchase Order      
PC03079 NCHAR STRING 38 0 38 NodeID_BOM_SC BoM Node ID Stock      
PC03080 NCHAR STRING 1 0 1 BlockForProcess BoM Blocked for Processing      
PC03081 NVARCHAR VSTRING 10 0 10 InstallationCustomer Installation Customer      
PC03082 NVARCHAR VSTRING 4 0 4 InstallationSite Installation Site      
PC03083 NCHAR STRING 10 0 10 ServiceMasterOrder Service Master Order      
PC03084 DATETIME DATE 0 0 8 OriginalConfDD Original Confirmed Delivery Date      
PC03085 INT INTEGER 0 0 1 CreationSource Creation Source      
PC03086 NCHAR STRING 6 0 6 TaxCode Tax Code      
PC03087 DATETIME DATE 0 0 8 ReminderDateFPO Reminder Date FPO      
PC03088 INT INTEGER 0 0 1 LinkedToContract Linked to contract      
PC03089 NCHAR STRING 2 0 2 AccountCode2 Accounting Code 2      
PC03090 NVARCHAR VSTRING 10 0 10 ContractNumber Contract Number      
PC03091 NCHAR STRING 6 0 6 ContractLineNumber Contract Line Number      
PC03092 NCHAR STRING 6 0 6 DeliveryScheduleLineNumber Delivery Schedule Line Number      
PC03093 DATETIME DATE 0 0 8 OrgReqDeliveryDate Org. Req. Delivery Date      
PC03094 NVARCHAR VSTRING 35 0 35 CommodityCode Commodity code      
PC03095 NVARCHAR VSTRING 10 0 10 ProductTaxType Product Tax Type      
PC03096 NVARCHAR VSTRING 10 0 10 FinancialOperationCode Financial Operation Code      
PC03097 NVARCHAR VSTRING 150 0 150 ExUserDef1 Extended User-Defined Field 1      
PC03098 NVARCHAR VSTRING 150 0 150 ExUserDef2 Extended User-Defined Field 2      
PC03099 NVARCHAR VSTRING 150 0 150 ExUserDef3 Extended User-Defined Field 3      
PC03100 NVARCHAR VSTRING 150 0 150 ExUserDef4 Extended User-Defined Field 4      
PC03101 NVARCHAR VSTRING 150 0 150 ExUserDef5 Extended User-Defined Field 5      
PC03102 NVARCHAR VSTRING 150 0 150 ExUserDef6 Extended User-Defined Field 6      
PC03103 NVARCHAR VSTRING 150 0 150 ExUserDef7 Extended User-Defined Field 7      
PC03104 NVARCHAR VSTRING 150 0 150 ExUserDef8 Extended User-Defined Field 8      
PC03105 NVARCHAR VSTRING 150 0 150 ExUserDef9 Extended User-Defined Field 9      
PC03106 NVARCHAR VSTRING 150 0 150 ExUserDef10 Extended User-Defined Field 10      
PC03107 NVARCHAR VSTRING 150 0 150 ExUserDef11 Extended User-Defined Field 11      
PC03108 NVARCHAR VSTRING 150 0 150 ExUserDef12 Extended User-Defined Field 12      
PC03109 NVARCHAR VSTRING 150 0 150 ExUserDef13 Extended User-Defined Field 13      
PC03110 NVARCHAR VSTRING 150 0 150 ExUserDef14 Extended User-Defined Field 14      
PC03111 NVARCHAR VSTRING 150 0 150 ExUserDef15 Extended User-Defined Field 15      
PC03112 NVARCHAR VSTRING 150 0 150 ExUserDef16 Extended User-Defined Field 16      
PC03113 NVARCHAR VSTRING 150 0 150 ExUserDef17 Extended User-Defined Field 17      
PC03114 NVARCHAR VSTRING 150 0 150 ExUserDef18 Extended User-Defined Field 18      
PC03115 NVARCHAR VSTRING 150 0 150 ExUserDef19 Extended User-Defined Field 19      
PC03116 NVARCHAR VSTRING 150 0 150 ExUserDef20 Extended User-Defined Field 20      
PC03117 NVARCHAR VSTRING 10 0 10 Requisition Requisition      
PC03118 NCHAR STRING 4 0 4 RqsnLine Requisition Line      

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