Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Таблица / Table OR05 — Order Parameters — О системах планирования ресурсов предприятия Scala, iScala

Таблица / 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
OR05174	NCHAR	SWITCH	1	0	1	ConfirmationControlledbyPlanner	Confirmation Controlled by Planner

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

Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список системных таблиц / System Tables
Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Управление Основными Средствами»/List of tables of module «Asset Management»
Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Управление Контрактами»/List of tables of module «Contract Management»
Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Прямая выписка счетов»/List of tables of module «Direct Invoicing»
Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Главная Книга»/List of tables of module «General Ledger»
Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Управление Ресурсами»/List of tables of module «Resourse Management»
Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «База Данных рынка»/List of tables of module «Market Database»
Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Управление Материалами в Производстве»/List of tables of module «Material Production Control»
Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Заказы на Продажу»/List of tables of module «Sales Order»
Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Зарплата»/List of tables of module «Payroll»
Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Заказ на Закупку»/List of tables of module «Purchase Order»
Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Книга Закупок»/List of tables of module «Purchase Ledger»
Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Долговые обязательства»/List of tables of module «Promissory Notes»
Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Управление Проектами»/List of tables of module «Project Management»
Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Управление Запасами»/List of tables of module «Stock Control»
Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Книга Продаж»/List of tables of module «Sales Ledger»
Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Управление заказом на обслуживание»/List of tables of module «Service Order Management»
Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Статистика»/List of tables of module «Statistics»
Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Системные Утилиты/Автом. Офиса»/List of tables of module «System Utilities/Office Autom.»