Таблица | 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
/* */