Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else... / Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще...
Таблица | Table: PC05 - «Purchase Order Parameters». Маска имени таблицы | Table Name Mask: «PC05%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
Field | Field Type | iScala Field Type | Field Length | Precision | 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 | FFB | (obsolete) | |||
PC05055 | NVARCHAR | VSTRING | 1 | 0 | 1 | CounterConsGRN | (obsolete) | |||
PC05056 | NVARCHAR | VSTRING | 1 | 0 | 1 | FFB | (obsolete) | |||
PC05057 | NVARCHAR | VSTRING | 1 | 0 | 1 | FFB | (obsolete) | |||
PC05058 | NVARCHAR | VSTRING | 1 | 0 | 1 | FFB | (obsolete) | |||
PC05059 | NVARCHAR | VSTRING | 1 | 0 | 1 | FFB | (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 | Weight\VolumeCalculateperUnit | 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 | Status_ImportDocument_Normal | 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 | Delivery date from order head | DeliveryDateFromOrderHead | |||
PC05076 | NCHAR | SWITCH | 1 | 0 | 1 | Flag_BOM_Automatic_Entry | 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 | Consumption note counter | (obsolete) | |||
PC05079 | INT | INTEGER | 0 | 0 | 1 | StockAccFlg | (obsolete) | |||
PC05080 | NUMERIC | NUMBER | 20 | 0 | 1 | Default structure query for Stock Item | 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 | Update DS purchase order till | ||||
PC05087 | NCHAR | SWITCH | 1 | 0 | 1 | Default Structure Query in BOM Configurator | ||||
PC05088 | NCHAR | SWITCH | 1 | 0 | 1 | DeliveryMilestone | Milestone related to Delivery Date | |||
PC05089 | NCHAR | SWITCH | 1 | 0 | 1 | LT AP start before today | ||||
PC05090 | NCHAR | STRING | 1 | 0 | 1 | Renew supplier and price in requisition | Renew supplier and price in requisition | |||
PC05091 | NCHAR | SWITCH | 1 | 0 | 1 | Automatic Requisition Conversion | Automatic Requisition Conversion | |||
PC05092 | NCHAR | SWITCH | 1 | 0 | 1 | Picking Request upon Authorisation | Picking Request upon Authorisation | |||
PC05093 | NCHAR | SWITCH | 1 | 0 | 1 | Create allocations during creation of picking request | 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 | Automatic printing of Product Labels | Automatic printing of Product Labels | |||
PC05096 | NVARCHAR | VSTRING | 255 | 0 | 255 | Automatic Product Labels Print Channel | Automatic Product Labels Print Channel | |||
PC05097 | INT | INTEGER | 0 | 0 | 1 | StratSelSuppRqsn | Priority Supplier Selection in Requisitions | |||
PC05098 | INT | INTEGER | 0 | 0 | 1 | Commodity code activation | Commodity code activation |
Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Purchase Order | Purchase Order Parameters