Таблица: OR05 - «Order Parameters». Маска имени таблицы: «OR05%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
OR05001 NCHAR STRING 2 0 2 Year_Key Year   1 Да
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 INT INTEGER 0 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 AdditParam16 (obsolete)      
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    

Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Sales Order | Order Parameters