Таблица | Table: OR05 - «Order Parameters». Маска имени таблицы | Table Name Mask: «OR05%cc00»
| Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
| Field | Field Type | iScala Field Type | Field Length | Precision | iScala Length | Comment | Extended Comment | Additional Description | Index Position | Is Primary key? |
| OR05001 | NCHAR | STRING | 2 | 0 | 2 | Year_Key | Year | 1 | Да / Yes | |
| OR05002 | NUMERIC | NUMBER | 20 | 0 | 1 | ORCountA | (obsolete) | |||
| OR05003 | NUMERIC | NUMBER | 20 | 0 | 1 | ORCountB | (obsolete) | |||
| OR05004 | NUMERIC | NUMBER | 20 | 0 | 1 | ORCountC | (obsolete) | |||
| OR05005 | NUMERIC | NUMBER | 20 | 0 | 1 | InvNoCount | (obsolete) | |||
| OR05006 | NUMERIC | NUMBER | 20 | 0 | 1 | CredNoteCoun | (obsolete) | |||
| OR05007 | NUMERIC | NUMBER | 20 | 0 | 1 | IntInvCount | (obsolete) | |||
| OR05008 | NUMERIC | NUMBER | 20 | 0 | 1 | DispNotCoun | (obsolete) | |||
| OR05009 | INT | INTEGER | 0 | 0 | 2 | NooInvCop | Number of Invoice Copies | |||
| OR05010 | INT | INTEGER | 0 | 0 | 2 | NoDisNotCop | Number of Dispatch Note Copies | |||
| OR05011 | INT | INTEGER | 0 | 0 | 2 | NoConfQuCop | Number of Confirmation/Quotation Copies | |||
| OR05012 | NCHAR | STRING | 2 | 0 | 2 | AcCodNStItm | Accounting Code None Stock Items | |||
| OR05013 | INT | INTEGER | 0 | 0 | 1 | DefStOrConf | Default Status Order Confirmation | |||
| OR05014 | INT | INTEGER | 0 | 0 | 1 | DefStaPickLs | Default Status Picking List | |||
| OR05015 | INT | INTEGER | 0 | 0 | 1 | DefaOrType | Default Order Type | |||
| OR05016 | INT | INTEGER | 0 | 0 | 1 | DiscouMethod | Discount Method | 0 - No discount is calculated.
1 - Customer and volume discount added. 2 - Volume discount only if customer discount is zero. 3 - Multiplied discount (each disc. deducted in turn from net amount) |
||
| OR05017 | NUMERIC | MONEY | 28 | 8 | 20 | InvoiceFee | Invoicing Fee (Local Currency) | |||
| OR05018 | NUMERIC | MONEY | 28 | 8 | 20 | LimitInvoFee | Limit on Invoicing Fee (Local Currency) | |||
| OR05019 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | DefLimCurCla | Default Limit Currency Clause | |||
| OR05020 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | DefFacCurCla | Default Factor Currency Clause | |||
| OR05021 | INT | INTEGER | 0 | 0 | 2 | DefCurrClaus | Default Currency Clause | |||
| OR05022 | INT | INTEGER | 0 | 0 | 3 | IncreOrdPosi | Increment for order positions | |||
| OR05023 | INT | INTEGER | 0 | 0 | 3 | DefDelivTime | Default Delivery Time | |||
| OR05024 | INT | INTEGER | 0 | 0 | 1 | ALevLineAdju | (obsolete) | |||
| OR05025 | INT | INTEGER | 0 | 0 | 1 | ALevPricAdju | (obsolete) | |||
| OR05026 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | FreigSurCha | Calculated Freight Charges | |||
| OR05027 | INT | INTEGER | 0 | 0 | 2 | WeekBooStat | Weeks for Booking Statistics | |||
| OR05028 | INT | INTEGER | 0 | 0 | 1 | CodStruArtic | Coding of Structured Articles | Receipt and Cost Distribution in Bill of Materials:
0 - Receipts on main product, costs on subsidiary products. 1 - Receipts and costs on main product. 2 - Receipts and costs on subsidiary product. |
||
| OR05029 | INT | INTEGER | 0 | 0 | 2 | IncrStruLine | Increment for Structure Lines | |||
| OR05030 | NUMERIC | NUMBER | 20 | 0 | 1 | ORCountD | (obsolete) | |||
| OR05031 | NUMERIC | NUMBER | 20 | 0 | 1 | ORCountE | (obsolete) | |||
| OR05032 | NUMERIC | NUMBER | 20 | 0 | 1 | ORCountF | (obsolete) | |||
| OR05033 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | RepORInd | Repeat Order Index | |||
| OR05034 | NUMERIC | NUMBER | 20 | 0 | 1 | PickListCoun | (obsolete) | |||
| OR05035 | INT | INTEGER | 0 | 0 | 2 | IncrBatchLin | Increment for Batch Lines | |||
| OR05036 | INT | INTEGER | 0 | 0 | 2 | IncrTexLine | Increment for Text Lines | |||
| OR05037 | NCHAR | SWITCH | 1 | 0 | 1 | SaveHistMod | History Option | 0 - Order history not saved.
1 - Compressed order history saved. 2 - Detailed order history saved. 3 - Compressed and detailed Order history are saved. |
||
| OR05038 | NUMERIC | NUMBER | 20 | 0 | 1 | DelPropNoCou | (obsolete) | |||
| OR05039 | NVARCHAR | VSTRING | 1 | 0 | 1 | Spare | (obsolete) | |||
| OR05040 | NUMERIC | NUMBER | 20 | 0 | 1 | OrNoCountG | (obsolete) | |||
| OR05041 | NUMERIC | NUMBER | 20 | 0 | 1 | OrNoCountH | (obsolete) | |||
| OR05042 | NUMERIC | NUMBER | 20 | 0 | 1 | OrNoCountI | (obsolete) | |||
| OR05043 | NUMERIC | NUMBER | 20 | 0 | 1 | OrNoCountJ | (obsolete) | |||
| OR05044 | NUMERIC | NUMBER | 20 | 0 | 1 | OrNoCountK | (obsolete) | |||
| OR05045 | NUMERIC | NUMBER | 20 | 0 | 1 | OrNoCountL | (obsolete) | |||
| OR05046 | NUMERIC | NUMBER | 20 | 0 | 1 | OrNoCountM | (obsolete) | |||
| OR05047 | NUMERIC | NUMBER | 20 | 0 | 1 | OrNoCountN | (obsolete) | |||
| OR05048 | NUMERIC | NUMBER | 20 | 0 | 1 | OrNoCountO | (obsolete) | |||
| OR05049 | NUMERIC | NUMBER | 20 | 0 | 1 | OrNoCountP | (obsolete) | |||
| OR05050 | NUMERIC | NUMBER | 20 | 0 | 1 | OrNoCountQ | (obsolete) | |||
| OR05051 | NUMERIC | NUMBER | 20 | 0 | 1 | OrNoCountR | (obsolete) | |||
| OR05052 | NUMERIC | NUMBER | 20 | 0 | 1 | OrNoCountS | (obsolete) | |||
| OR05053 | NUMERIC | NUMBER | 20 | 0 | 1 | OrNoCountT | (obsolete) | |||
| OR05054 | NUMERIC | NUMBER | 20 | 0 | 1 | OrNoCountU | (obsolete) | |||
| OR05055 | NUMERIC | NUMBER | 20 | 0 | 1 | OrNoCountV | (obsolete) | |||
| OR05056 | NUMERIC | NUMBER | 20 | 0 | 1 | OrNoCountW | (obsolete) | |||
| OR05057 | NUMERIC | NUMBER | 20 | 0 | 1 | OrNoCountX | (obsolete) | |||
| OR05058 | NUMERIC | NUMBER | 20 | 0 | 1 | OrNoCountY | (obsolete) | |||
| OR05059 | NCHAR | SWITCH | 1 | 0 | 1 | OrNoCountZ | (obsolete) | |||
| OR05060 | NCHAR | SWITCH | 1 | 0 | 1 | StockAccng | Stock Accounting | 0 - Cost of material sold not booked.
1 - When the order is booked, stock issued and cost of material sold are noted via the Automatic Accounting Schedule in the Sales Ledger. 2 - Stock accounting with date stamping 3 - Stock accounting with value stamping |
||
| OR05061 | NCHAR | SWITCH | 1 | 0 | 1 | PrnTotConfir | BOM Allocation on Costs | |||
| OR05062 | NCHAR | SWITCH | 1 | 0 | 1 | DispNotPickL | Quantity Option on Delivery Note | 0 - Print delivery note using delivered quantity
1 - Print delivery note using ordered quantity 2 - Print delivery note with only delivered lines 3 - Print delivery note with only last delivery |
||
| OR05063 | NCHAR | SWITCH | 1 | 0 | 1 | AutRelAftDel | Release Invoice after Stock Issue | |||
| OR05064 | NCHAR | SWITCH | 1 | 0 | 1 | DiscOnInvo | Show Discounts on Invoice | |||
| OR05065 | NCHAR | SWITCH | 1 | 0 | 1 | DiscAccing | Discount Accounting | |||
| OR05066 | NCHAR | SWITCH | 1 | 0 | 1 | DelDateWee | Delivery Date as Weeks | |||
| OR05067 | NCHAR | SWITCH | 1 | 0 | 1 | ItemsDispNot | Print No of items on dispatch Notes | |||
| OR05068 | NCHAR | SWITCH | 1 | 0 | 1 | CustCredLim | Check Customer Credit Limit | |||
| OR05069 | NCHAR | SWITCH | 1 | 0 | 1 | WeVolCalc | Weight and volume calculation per unit | |||
| OR05070 | NCHAR | SWITCH | 1 | 0 | 1 | PrnDispNot | Print Dispatch Notes for Order Type 2 | |||
| OR05071 | NCHAR | SWITCH | 1 | 0 | 1 | DiscPriOrLi | Enter discount and price on order lines | |||
| OR05072 | NCHAR | SWITCH | 1 | 0 | 1 | QyShipUniN | Enter qty as no of shipment units | |||
| OR05073 | NCHAR | SWITCH | 1 | 0 | 1 | CrPOrProp | Create purchase order proposals | |||
| OR05074 | NCHAR | SWITCH | 1 | 0 | 1 | OrlineDelDat | Update line delivery date when Order Head Delivery Date Changed | |||
| OR05075 | NCHAR | SWITCH | 1 | 0 | 1 | TermsDelCus | Use terms from delivery customer | |||
| OR05076 | NCHAR | SWITCH | 1 | 0 | 1 | OrEntryStat | Generate order entry statistics | |||
| OR05077 | NCHAR | SWITCH | 1 | 0 | 1 | InvoicStat | Generate invoicing statistics | |||
| OR05078 | NCHAR | SWITCH | 1 | 0 | 1 | CurrClausStd | Currency Clause as Standard | |||
| OR05079 | NCHAR | SWITCH | 1 | 0 | 1 | CurrClItem | Currency Clause per Item | |||
| OR05080 | NCHAR | SWITCH | 1 | 0 | 1 | AdInvRepOr | Advance Invoice Repeat Orders | |||
| OR05081 | NCHAR | SWITCH | 1 | 0 | 1 | PrcDelDate | Pricing on Delivery Date | 0 - Price will be calculated when entering order lines
1 - Price will be calculated when delivering 2 - Price will be calculated when invoicing |
||
| OR05082 | NCHAR | SWITCH | 1 | 0 | 1 | GenBookSt | Generate Booking Statistics | |||
| OR05083 | NCHAR | SWITCH | 1 | 0 | 1 | DelivSched | Delivery Planning | 0 - No stock planning
1 - Standard stock planning 2 - Lead time model based stock planning |
||
| OR05084 | NCHAR | SWITCH | 1 | 0 | 1 | StDelCust | Statistics on Delivery Customer | |||
| OR05085 | NCHAR | SWITCH | 1 | 0 | 1 | DelNoteProp | (obsolete) | |||
| OR05086 | NCHAR | SWITCH | 1 | 0 | 1 | ShipOnInv | Only Shipped Lines/Quantity on Invoices | |||
| OR05087 | NCHAR | SWITCH | 1 | 0 | 1 | AutStrPrep | Automatic Structure Prepare | |||
| OR05088 | NCHAR | SWITCH | 1 | 0 | 1 | SortPickLst | Sorted Picking List | |||
| OR05089 | NCHAR | SWITCH | 1 | 0 | 1 | Spare | Keep historical BoM distribution | |||
| OR05090 | NCHAR | SWITCH | 1 | 0 | 1 | GrpVolDisc | Group Volume Discounts | |||
| OR05091 | NCHAR | SWITCH | 1 | 0 | 1 | OrMergeSL | Order Merge via SL | |||
| OR05092 | NCHAR | SWITCH | 1 | 0 | 1 | CurrFrCust | Source of Currency | 0 - Order and invoice currency determined by Price List Currency.
1 - Order and invoice currency determined by customer currency. 2 - Order currency determined by price list currency, invoice currency determined by customer currency |
||
| OR05093 | NCHAR | SWITCH | 1 | 0 | 1 | TextLnOrEnt | Show Text Lines at Order entry | |||
| OR05094 | NCHAR | SWITCH | 1 | 0 | 1 | ConvPriceToOrdCurr | Convert price to order currency | |||
| OR05095 | NCHAR | SWITCH | 1 | 0 | 1 | PrnDocInvCuO | Print Documents in Invoice Customer Order | |||
| OR05096 | NCHAR | SWITCH | 1 | 0 | 1 | PickDispNWH | Sort Picking List/Dispatch Note per Warehouse | |||
| OR05097 | NVARCHAR | VSTRING | 1 | 0 | 1 | SectnsQuote | Sections on Quote | |||
| OR05098 | NVARCHAR | VSTRING | 1 | 0 | 1 | BEdatDelDat | BE-date= delivery date | |||
| OR05099 | NVARCHAR | VSTRING | 1 | 0 | 1 | BEdaOrClosg | Check BE-Date on Order Closing | |||
| OR05100 | NVARCHAR | VSTRING | 1 | 0 | 1 | PricingInvDt | Pricing on Invoice Date | |||
| OR05101 | NVARCHAR | VSTRING | 1 | 0 | 1 | ValidateDates | Validate Dates | |||
| OR05102 | NVARCHAR | VSTRING | 1 | 0 | 1 | AccLevel | (obsolete) | |||
| OR05103 | NCHAR | SWITCH | 1 | 0 | 1 | AllowZeroEffect | Allow zero effective price | |||
| OR05104 | NVARCHAR | VSTRING | 1 | 0 | 1 | Spare | Reservation for Backorders | |||
| OR05105 | NVARCHAR | VSTRING | 1 | 0 | 1 | Spare | Sales Slips printing | |||
| OR05106 | NVARCHAR | VSTRING | 1 | 0 | 1 | Spare | Prices for internal customer | Effect only sales prices for internal customers but not production orders.
0 - Prices cannot be adjusted and are equal to the cost of stock item according to the current stock valuation model 1 - Prices cannot be adjusted and are equal to zero 2 - Prices can be adjusted |
||
| OR05107 | NVARCHAR | VSTRING | 1 | 0 | 1 | Spare | Split Cost of Goods Sold | |||
| OR05108 | NVARCHAR | VSTRING | 10 | 0 | 10 | AdditParam1 | Greece: verification period for 30-days rule | |||
| OR05109 | NVARCHAR | VSTRING | 10 | 0 | 10 | AdditParam2 | (obsolete) | |||
| OR05110 | NVARCHAR | VSTRING | 10 | 0 | 10 | AdditParam3 | (obsolete) | |||
| OR05111 | NVARCHAR | VSTRING | 10 | 0 | 10 | AdditParam4 | (obsolete) | |||
| OR05112 | NVARCHAR | VSTRING | 10 | 0 | 10 | AdditParam5 | (obsolete) | |||
| OR05113 | NVARCHAR | VSTRING | 10 | 0 | 10 | AdditParam6 | (obsolete) | |||
| OR05114 | NVARCHAR | VSTRING | 10 | 0 | 10 | AdditParam7 | (obsolete) | |||
| OR05115 | NVARCHAR | VSTRING | 10 | 0 | 10 | AdditParam8 | (obsolete) | |||
| OR05116 | NVARCHAR | VSTRING | 10 | 0 | 10 | AdditParam9 | (obsolete) | |||
| OR05117 | NVARCHAR | VSTRING | 10 | 0 | 10 | AdditParam10 | (obsolete) | |||
| OR05118 | NCHAR | SWITCH | 1 | 0 | 1 | AdditParam11 | Allow change of Backorder Date | |||
| OR05119 | NCHAR | SWITCH | 1 | 0 | 1 | AdditParam12 | Close Condition Traditional Orders | 0 - Invoice was printed
1 - Invoice was printed or XML send 2 - Invoice was printed and XML sent |
||
| OR05120 | NCHAR | SWITCH | 1 | 0 | 1 | AdditParam13 | Close Condition Electronic Orders | 0 - Invoice was printed
1 - Invoice was printed or XML send 2 - Invoice was printed and XML sent 3 - XML was sent |
||
| OR05121 | NCHAR | SWITCH | 1 | 0 | 1 | AdditParam14 | Create Electronic Order Option | 0 - If any customer (order, invoice or delivery) is market as electronic
1 - If order customer is marked as electronic 2 - If Invoice customer is marked as electronic 3 - If Delivery customer is marked as electronic |
||
| OR05122 | NCHAR | SWITCH | 1 | 0 | 1 | AdditParam15 | Automatic Grouping Method | 0 - Manual sales orders grouping
1 - Semi-automatic sales orders grouping 2 - Automatic sales orders grouping |
||
| OR05123 | NCHAR | SWITCH | 1 | 0 | 1 | Default Invoice Split | Default Invoice Split | |||
| OR05124 | NCHAR | SWITCH | 1 | 0 | 1 | AdditParam17 | (obsolete) | |||
| OR05125 | NCHAR | SWITCH | 1 | 0 | 1 | AdditParam18 | (obsolete) | |||
| OR05126 | NCHAR | SWITCH | 1 | 0 | 1 | AdditParam19 | (obsolete) | |||
| OR05127 | NCHAR | SWITCH | 1 | 0 | 1 | AdditParam20 | (obsolete) | |||
| OR05128 | INT | INTEGER | 0 | 0 | 1 | Flag_Site_Code_Adjustment_in_Order_Line | Site Code Adjustment in an Order Line | |||
| OR05129 | INT | INTEGER | 0 | 0 | 3 | Weight_Customer_Priority | Weight Customer Priority for Order | |||
| OR05130 | INT | INTEGER | 0 | 0 | 3 | Weight_ServiceOrder_Priority | Weight Order Priority | |||
| OR05131 | INT | INTEGER | 0 | 0 | 1 | Default_Order_Priority | Default Order Priority | |||
| OR05132 | NCHAR | SWITCH | 1 | 0 | 1 | Flag_Allow_Site_Code_Empty | Site Code Can be Empty | |||
| OR05133 | NCHAR | SWITCH | 1 | 0 | 1 | Flag_Allow_ErrorLog_on_Order_Close | 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. |
||
| OR05134 | INT | INTEGER | 0 | 0 | 1 | Flag_DS_Split_per_Sales_Order | Drop Shipment Split per Sales Order? | |||
| OR05135 | INT | INTEGER | 0 | 0 | 1 | Save Version History | Save Version History | |||
| OR05136 | NUMERIC | NUMBER | 20 | 0 | 1 | Default structure query for Stock Item | Default Structure Query | 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. |
||
| OR05137 | NCHAR | SWITCH | 1 | 0 | 1 | Flexible BOM Pricing | Flexible BOM Pricing | |||
| OR05138 | NCHAR | STRING | 6 | 0 | 6 | TaxCodeNonStockItem | Tax code Non-Tangible Items | |||
| OR05139 | NCHAR | SWITCH | 1 | 0 | 1 | Consolidated DS Delivery | Consolidated DS Delivery | |||
| OR05140 | NCHAR | SWITCH | 1 | 0 | 1 | Default Structure Query in BOM Configurator | ||||
| OR05141 | NCHAR | SWITCH | 1 | 0 | 1 | SaveInvoiceImage | Save Invoice Image | |||
| OR05142 | NCHAR | SWITCH | 1 | 0 | 1 | DeliveryMilestone | Milestone related to Delivery Date | |||
| OR05143 | NCHAR | SWITCH | 1 | 0 | 1 | LT AP start before today | ||||
| OR05144 | NCHAR | SWITCH | 1 | 0 | 1 | Create Invoices with Future Booking Date | Create Invoices with Future Booking Date | |||
| OR05145 | NCHAR | SWITCH | 1 | 0 | 1 | Close Invoices with Future Booking Date | Close Invoices with Future Booking Date | |||
| OR05146 | NVARCHAR | VSTRING | 4 | 0 | 4 | ATP Cancellation Code | ATP Cancellation Code | |||
| OR05147 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | EDI Process Lead Time | EDI Process Lead Time | |||
| OR05148 | NCHAR | SWITCH | 1 | 0 | 1 | DistrChargeTaxSwitch | Distr Charge Tax Switch | Distribution Charge Tax on Line Level | ||
| OR05149 | INT | INTEGER | 0 | 0 | 1 | Update work order | Update work order | |||
| OR05150 | INT | INTEGER | 0 | 0 | 1 | Update work order till | Update work order till | |||
| OR05151 | INT | INTEGER | 0 | 0 | 1 | Cost of drop shipment items before delivery | Cost of drop shipment items before delivery | |||
| OR05152 | INT | INTEGER | 0 | 0 | 1 | Freight tax code source | ||||
| OR05153 | NCHAR | SWITCH | 1 | 0 | 1 | Cost Check Flag | Cost Check Flag | |||
| OR05154 | NCHAR | SWITCH | 1 | 0 | 1 | Customer for price | Customer for price | |||
| OR05155 | NCHAR | SWITCH | 1 | 0 | 1 | Pack. Material charge per Sales Order? | Pack. Material charge per Sales Order? | |||
| OR05156 | NUMERIC | MONEY | 28 | 8 | 20 | Packaging Tax Amount per Order | Packaging Tax Amount per Order | |||
| OR05157 | NCHAR | STRING | 2 | 0 | 2 | Tax Code, Pack. Material per Order | Tax Code, Pack. Material per Order | |||
| OR05158 | NCHAR | SWITCH | 1 | 0 | 1 | BlockConvQuotOrd | Block conversion quotation to order if credit limit is exceeded | |||
| OR05159 | NCHAR | SWITCH | 1 | 0 | 1 | BlockOREntry | Block Sales Order entry if credit limit is exceeded | |||
| OR05160 | NCHAR | SWITCH | 1 | 0 | 1 | CrCheck@ORLineEntry | Credit check at Sales order line entry | |||
| OR05161 | NCHAR | SWITCH | 1 | 0 | 1 | CrCheck@ORExit | Credit check at Sales order exit | |||
| OR05162 | NCHAR | SWITCH | 1 | 0 | 1 | BlockAlloc | Block allocation if credit limit is exceeded | |||
| OR05163 | NCHAR | SWITCH | 1 | 0 | 1 | BlockDeliv | Block delivery if credit limit is exceeded | |||
| OR05164 | NCHAR | SWITCH | 1 | 0 | 1 | Block DS PO | Block drop shipment PO creation if credit limit is exceeded | |||
| OR05165 | NCHAR | SWITCH | 1 | 0 | 1 | SkipCrCheck | Skip additional credit checks after order entry | |||
| OR05166 | NCHAR | SWITCH | 1 | 0 | 1 | ExcludeDO | Exclude Credit blocked, Direct orders at Purchase proposal creation | |||
| OR05167 | NCHAR | SWITCH | 1 | 0 | 1 | BlockWO | Block Work Order creation if credit limit is exceeded |
Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Sales Order | Order Parameters
/* */