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

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

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
OR05001 NCHAR STRING 2 0 2 YearKey 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 DefaultInvoiceSplit 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 FlagSiteCodeAdjustmentinOrderLine Site Code Adjustment in an Order Line      
OR05129 INT INTEGER 0 0 3 WeightCustomerPriority Weight Customer Priority for Order      
OR05130 INT INTEGER 0 0 3 WeightServiceOrderPriority Weight Order Priority      
OR05131 INT INTEGER 0 0 1 DefaultOrderPriority Default Order Priority      
OR05132 NCHAR SWITCH 1 0 1 FlagAllowSiteCodeEmpty Site Code Can be Empty      
OR05133 NCHAR SWITCH 1 0 1 FlagAllowErrorLogonOrderClose 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 FlagDSSplitperSalesOrder Drop Shipment Split per Sales Order?      
OR05135 INT INTEGER 0 0 1 SaveVersionHistory Save Version History      
OR05136 NUMERIC NUMBER 20 0 1 DefaultStructQueryStockItem 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 FlexibleBOMPricing Flexible BOM Pricing      
OR05138 NCHAR STRING 6 0 6 TaxCodeNonStockItem Tax code Non-Tangible Items      
OR05139 NCHAR SWITCH 1 0 1 ConsolidatedDSDelivery Consolidated DS Delivery      
OR05140 NCHAR SWITCH 1 0 1 DefaultStructQryBOMConfigurator 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 LTAPStartBeforeToday LT AP start before today      
OR05144 NCHAR SWITCH 1 0 1 CreateInvFutureBookDate Create Invoices with Future Booking Date      
OR05145 NCHAR SWITCH 1 0 1 CloseInvFutureBookDate Close Invoices with Future Booking Date      
OR05146 NVARCHAR VSTRING 4 0 4 ATPCancellationCode ATP Cancellation Code      
OR05147 NUMERIC X_NUMERIC 18 8 10 EDIProcessLeadTime 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 UpdateWO Update work order      
OR05150 INT INTEGER 0 0 1 UpdateWOTill Update work order till      
OR05151 INT INTEGER 0 0 1 CostDSItemBeforeDelivery Cost of drop shipment items before delivery      
OR05152 INT INTEGER 0 0 1 FreightTaxCodeSrc Freight tax code source      
OR05153 NCHAR SWITCH 1 0 1 CostCheckFlag Cost Check Flag      
OR05154 NCHAR SWITCH 1 0 1 CustomerForPrice Customer for price      
OR05155 NCHAR SWITCH 1 0 1 PackMtrlChargePerOR Pack. Material charge per Sales Order?      
OR05156 NUMERIC MONEY 28 8 20 PackagingTaxAmountperOrder Packaging Tax Amount per Order      
OR05157 NCHAR STRING 2 0 2 TaxCodePackMtrlPerOrder Tax Code, Pack. Material per Order      
OR05158 NCHAR SWITCH 1 0 1 BlockConvQuotOrd Block conversion quotation to order if customer is blocked by credit control      
OR05159 NCHAR SWITCH 1 0 1 BlockOREntry Block Sales Order entry if customer is blocked by credit control      
OR05160 NCHAR SWITCH 1 0 1 CrCheckORLineEntry Credit check at Sales order line entry      
OR05161 NCHAR SWITCH 1 0 1 CrCheckORExit Credit check at Sales order exit      
OR05162 NCHAR SWITCH 1 0 1 BlockAlloc Block allocation if customer is blocked by credit control      
OR05163 NCHAR SWITCH 1 0 1 BlockDeliv Block delivery if customer is blocked by credit control      
OR05164 NCHAR SWITCH 1 0 1 BlockDSPO Block drop shipment PO creation if customer is blocked by credit control      
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 customer is blocked by credit control      
OR05168 NVARCHAR VSTRING 10 0 10 ProductTaxTypeNonStockItem Product Tax Type Non Stock Item      
OR05169 NCHAR SWITCH 1 0 1 RedStornoDef Red Storno Default      
OR05170 NCHAR STRING 1 0 1 DefTaxPoint DefTaxPoint      
OR05171 INT INTEGER 0 0 2 NoReturnNoteCopies Number of Copies for Return Note Print Return Notes functionality    
OR05172 NCHAR SWITCH 1 0 1 BlockPLPrintCRC Block picking list printing if customer is blocked by credit control      
OR05173 NCHAR STRING 3 0 3 TaxReasonCode Tax Reason Code      

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