На один уровень вверх / 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 PC05 — Purchase Order Parameters

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PC05001 NCHAR STRING 2 0 2 YearKey Year   1 Да / Yes
PC05002 NUMERIC NUMBER 20 0 1 OrNoCounterA (obsolete)      
PC05003 NUMERIC NUMBER 20 0 1 OrNoCounterB (obsolete)      
PC05004 NUMERIC NUMBER 20 0 1 OrNoCounterC (obsolete)      
PC05005 INT INTEGER 0 0 2 NoOfPuOrCopy No of Purchase Order Copies      
PC05006 INT INTEGER 0 0 2 NoOfRemCopy No of Reminder Copies      
PC05007 NCHAR STRING 2 0 2 AccCodNoStIt Accounting Code None Stock Items      
PC05008 INT INTEGER 0 0 1 DefStConfRem Normal Status Reminder of Confirmation 0 — Order confirmation reminder is not selected, it can still be printed manually

1 — The order is selected for printing order confirmation reminder		    
PC05009 INT INTEGER 0 0 1 DefStShipRem Normal Status Reminder of Shipment 0 — Delivery reminder is not selected, it can still be printed manually

1 — The order is selected for printing delivery reminder		    
PC05010 INT INTEGER 0 0 1 DefOrType Normal Order Type 0 — Purchase order proposal / Request for quotation

1 — Normal order

2 — Back order

3 — Direct delivery to customer		    
PC05011 INT INTEGER 0 0 2 DayReminConf Days Until Printing Reminder of Confirmation      
PC05012 INT INTEGER 0 0 2 DayReminShip Days Until Printing Reminder of Shipment      
PC05013 INT INTEGER 0 0 3 OrLineIncrem Order Line Number Increment      
PC05014 INT INTEGER 0 0 2 ForecastPeri Planning Weeks Purchases      
PC05015 INT INTEGER 0 0 2 OffsetShipm Move Delivery Forward (weeks)      
PC05016 NVARCHAR VSTRING 1 0 1 DfltAssignmtPrior Default Assignment Priority 0 — No Default Assignment

1 — Highest Escalation Level and Priority within Requested Delivery Date

2 — Highest Weighted Order Priorities within Requested Delivery Date

3 — Earliest Required Delivery Date		    
PC05017 INT INTEGER 0 0 1 StratSelSupp Priority Supplier Selection 0 — The supplier from the stock item is selected

1 — The supplier with lowest purchase price is selected

2 — The supplier with shortest delivery time is selected		    
PC05018 INT INTEGER 0 0 1 BudgForComm Budget Alternative for Commitments      
PC05019 INT INTEGER 0 0 3 IncrBatchLine Batch Line Number Increment      
PC05020 INT INTEGER 0 0 3 IncrTextLine Text Line Number Increment      
PC05021 NUMERIC NUMBER 20 0 1 OrdNoCountD (obsolete)      
PC05022 NUMERIC NUMBER 20 0 1 OrdNoCountE (obsolete)      
PC05023 NUMERIC NUMBER 20 0 1 OrdNoCountF (obsolete)      
PC05024 NUMERIC NUMBER 20 0 1 OrdNoCountG (obsolete)      
PC05025 NUMERIC NUMBER 20 0 1 OrdNoCountH (obsolete)      
PC05026 NUMERIC NUMBER 20 0 1 OrdNoCountI (obsolete)      
PC05027 NUMERIC NUMBER 20 0 1 OrdNoCountJ (obsolete)      
PC05028 NUMERIC NUMBER 20 0 1 OrdNoCountK (obsolete)      
PC05029 NUMERIC NUMBER 20 0 1 OrdNoCountL (obsolete)      
PC05030 NUMERIC NUMBER 20 0 1 OrdNoCountM (obsolete)      
PC05031 NUMERIC NUMBER 20 0 1 OrdNoCountN (obsolete)      
PC05032 NUMERIC NUMBER 20 0 1 OrdNoCountO (obsolete)      
PC05033 NUMERIC NUMBER 20 0 1 OrdNoCountP (obsolete)      
PC05034 NUMERIC NUMBER 20 0 1 OrdNoCountQ (obsolete)      
PC05035 NUMERIC NUMBER 20 0 1 OrdNoCountR (obsolete)      
PC05036 NUMERIC NUMBER 20 0 1 OrdNoCountS (obsolete)      
PC05037 NUMERIC NUMBER 20 0 1 OrdNoCountT (obsolete)      
PC05038 NUMERIC NUMBER 20 0 1 OrdNoCountU (obsolete)      
PC05039 NUMERIC NUMBER 20 0 1 OrdNoCountV (obsolete)      
PC05040 NUMERIC NUMBER 20 0 1 OrdNoCountW (obsolete)      
PC05041 NUMERIC NUMBER 20 0 1 OrdNoCountX (obsolete)      
PC05042 NUMERIC NUMBER 20 0 1 OrdNoCountY (obsolete)      
PC05043 NUMERIC NUMBER 20 0 1 OrdNoCountZ (obsolete)      
PC05044 NCHAR SWITCH 1 0 1 DelivDateDay Delivery Date as Week Number      
PC05045 NCHAR SWITCH 1 0 1 SavOrdAftInv Save Order After Invoice 0 — Save invoiced order neither in master nor in history tables.

1 — Save invoiced order in master tables only.

2 — Save invoiced order in history tables only.

3 — Save invoiced order both in master and history tables.		    
PC05046 NCHAR SWITCH 1 0 1 DelAfDelivNt Delete Without Reversing Transactions Y — Delivered Purchase Orders can be deleted without reversed stock transactions.

N — Stock transactions will be reversed on delivered orders if deleted.		    
PC05047 NCHAR SWITCH 1 0 1 ExtrTextDocu Print Extra Text from Stock Item on Documents      
PC05048 NCHAR SWITCH 1 0 1 CreatePICS Create Basis for Invoice Coding Slip      
PC05049 NCHAR SWITCH 1 0 1 UpdatePurchP Update Purchase Price      
PC05050 NCHAR SWITCH 1 0 1 DispTextLine Display Text Lines      
PC05051 NCHAR SWITCH 1 0 1 DocInSuppOrd Print Document in Supplier Order      
PC05052 INT INTEGER 0 0 1 CommitAccoun Commitment Accounting      
PC05053 NVARCHAR VSTRING 1 0 1 FFB Allow Change of Backorder Date      
PC05054 NVARCHAR VSTRING 1 0 1 PurchaseContractByStartDate Purchase Contract by Start date      
PC05055 NVARCHAR VSTRING 1 0 1 CounterConsGRN (obsolete)      
PC05056 NCHAR SWITCH 1 0 1 DispTextLineDN Display Text Lines at DN Entry Display Text Lines at DN Entry    
PC05057 NVARCHAR VSTRING 1 0 1 FFB4 (obsolete)      
PC05058 NVARCHAR VSTRING 1 0 1 FFB5 (obsolete)      
PC05059 NVARCHAR VSTRING 1 0 1 FFB6 (obsolete)      
PC05060 NVARCHAR VSTRING 10 0 10 NewPC05Par01 (obsolete)      
PC05061 NVARCHAR VSTRING 10 0 10 NewPC05Par02 (obsolete)      
PC05062 NVARCHAR VSTRING 10 0 10 NewPC05Par03 (obsolete)      
PC05063 NVARCHAR VSTRING 10 0 10 NewPC05Par04 (obsolete)      
PC05064 NVARCHAR VSTRING 10 0 10 NewPC05Par05 (obsolete)      
PC05065 NVARCHAR VSTRING 10 0 10 NewPC05Par06 (obsolete)      
PC05066 NVARCHAR VSTRING 10 0 10 NewPC05Par07 (obsolete)      
PC05067 NVARCHAR VSTRING 10 0 10 NewPC05Par08 (obsolete)      
PC05068 NVARCHAR VSTRING 10 0 10 NewPC05Par09 (obsolete)      
PC05069 NVARCHAR VSTRING 10 0 10 NewPC05Par10 (obsolete)      
PC05070 NCHAR STRING 1 0 1 SupplPerfAnalysus Save Statistics for Suppler Performance Analysis      
PC05071 NCHAR SWITCH 1 0 1 DeleteStatisticLine Save Tracking of Purchase Order Changes      
PC05072 NCHAR SWITCH 1 0 1 WeightVolCalcPerUnit Weight and Volume Calculation per Unit      
PC05073 NCHAR SWITCH 1 0 1 PrintItemsNoinDispatchNote Print no of Items on Dispatch Notes      
PC05074 INT INTEGER 0 0 2 StatusImportDocumentNormal Normal Status Import Document 0 — Import document is not selected, it can still be printed manually

1 — Import document is selected for printing		    
PC05075 NCHAR SWITCH 1 0 1 DelDateFromOrderHead DeliveryDateFromOrderHead      
PC05076 NCHAR SWITCH 1 0 1 FlagBOMAutomaticEntry BoM Price View 0 — Price for top order line is displayed; prices for components are set to zero.

1 — Price for top order line is set to zero; prices for components are displayed.

2 — Prices for both top order line and components are displayed.		    
PC05077 NCHAR STRING 1 0 1 Sw4DelSched Use Delivery Time Planning      
PC05078 NUMERIC NUMBER 20 0 13 ConsumpNoteCounter (obsolete)      
PC05079 INT INTEGER 0 0 1 StockAccFlg (obsolete)      
PC05080 NUMERIC NUMBER 20 0 1 DefaultStructQueryStockItem Default Structure Query for Stock Item 0 — BOM configurations query will be shown by default for stock item.

1 — BOM templates query will be shown by default for stock item.

2 — Both BoM templates and BoM configurations will be shown by default for stock item.		    
PC05081 INT INTEGER 0 0 3 RqsnFulfilment Normal Requisition Fulfilment Time (days)      
PC05082 INT INTEGER 0 0 3 RqsnValidPeriod Maximum Requisition Valid Period (month)      
PC05083 INT INTEGER 0 0 1 RqsnGroupCriteria Requisition Grouping Criteria 0 — Supplier, requisition type, and requisition number

1 — Supplier, requisition type and department

2 — Supplier and requisition type		    
PC05084 NCHAR STRING 1 0 1 RqsnPONoSerie (obsolete)      
PC05085 NCHAR SWITCH 1 0 1 RqsnLineDefaultsTo4 Requisition Default Line Type as 4      
PC05086 INT INTEGER 0 0 1 UpdateDSPOTill Update DS purchase order till      
PC05087 NCHAR SWITCH 1 0 1 DefaultStructQryBOMConfigurator Default Structure Query in BOM Configurator      
PC05088 NCHAR SWITCH 1 0 1 DeliveryMilestone Milestone related to Delivery Date      
PC05089 NCHAR SWITCH 1 0 1 LTAPStartBeforeToday LT AP start before today      
PC05090 NCHAR STRING 1 0 1 RenewSuppPriceRqsn Renew supplier and price in requisition      
PC05091 NCHAR SWITCH 1 0 1 AutoConvertRqsn Automatic Requisition Conversion      
PC05092 NCHAR SWITCH 1 0 1 PickListOnAuth Picking Request upon Authorisation      
PC05093 NCHAR SWITCH 1 0 1 AllocPickRequest Create allocations during creation of picking request      
PC05094 NCHAR STRING 6 0 6 TaxCodeNonStockItem Tax Code Non Stock Item      
PC05095 INT INTEGER 0 0 1 AutoPrintProdLabels Automatic printing of Product Labels      
PC05096 NVARCHAR VSTRING 255 0 255 AutoProdLabelsPrintChannel Automatic Product Labels Print Channel      
PC05097 INT INTEGER 0 0 1 StratSelSuppRqsn Priority Supplier Selection in Requisitions      
PC05098 INT INTEGER 0 0 1 CommodityCodeActivation Commodity code activation      
PC05099 NVARCHAR VSTRING 10 0 10 ProductTaxTypeNonStockItem Product Tax Type Non Stock Item      
PC05100 NCHAR STRING 1 0 1 SourceOfSuppInvBEDate Source of Supplier Invoice BE Date      
PC05101 NCHAR STRING 1 0 1 SourceOfEInvBEDate Source of Electronic Invoice BE Date      
PC05102 NCHAR SWITCH 1 0 1 RedStornoDef Red Storno Default      
PC05103 NCHAR SWITCH 1 0 1 ManualConvOfRqsn Manual Conversion of Requisitions      
PC05104 NCHAR SWITCH 1 0 1 AdjSuppAndPrice Adjust Supplier and Price      
PC05105 INT INTEGER 0 0 1 Spare Spare      
PC05106 INT INTEGER 0 0 1 Spare Spare      
PC05107 INT INTEGER 0 0 1 PurchaseBudget Purchase Budget      
PC05108 INT INTEGER 0 0 1 BudgetAccumulation Budget Accumulation      
PC05109 INT INTEGER 0 0 1 BudgetControlDate Budget Control Date      
PC05110 INT INTEGER 0 0 1 OptForAbsenceBudget Option For Absence of Budget      
PC05111 INT INTEGER 0 0 1 AccountingSeg1 Accounting Segment 1      
PC05112 INT INTEGER 0 0 1 AccountingSeg2 Accounting Segment 2      
PC05113 INT INTEGER 0 0 1 AccountingSeg3 Accounting Segment 3      
PC05114 INT INTEGER 0 0 1 DeliveryBlock Delivery Block      

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