Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица OR21 — Sales Order Lines History — О системах планирования ресурсов предприятия Scala, iScala

Таблица: OR21 — «History Sales Order Lines». Маска имени таблицы: «OR21%cc00»

Поле	Тип поля	Тип поля Scala	Длина поля	Точность	Длина Scala	Комментарий	Расширенный комментарий	Дополнительное описание	Позиция в индексе	Первичный ключ?
OR21001	NCHAR	STRING	10	0	10	OrderNo	Order Number		1	Да
OR21002	NCHAR	STRING	6	0	6	LineNo	Line Number		3	Да
OR21003	NCHAR	STRING	6	0	6	StrucLineNo	Sub-line Number		4	Да
OR21004	INT	INTEGER	0	0	1	LineType	Line Type	0 — Normal Order Line Related to Stock Item 1 — Non Stock Item Line (dot item)
OR21005	NVARCHAR	VSTRING	35	0	35	StockCode	Stock Item Code
OR21006	NVARCHAR	VSTRING	25	0	25	DescripLine1	Description Line 1
OR21007	NVARCHAR	VSTRING	25	0	25	DescripLine2	Description Line 2
OR21008	NUMERIC	MONEY	28	8	20	UnitPrice	Unit Price (Order Currency)
OR21009	NUMERIC	MONEY	28	8	20	UnitCostPric	Unit Cost Price (Local Currency)
OR21010	INT	INTEGER	0	0	4	UnitCode	Unit Code
OR21011	NUMERIC	X_NUMERIC	20	8	12	QtyOrdered	Quantity Ordered
OR21012	NUMERIC	X_NUMERIC	20	8	12	QtyShipped	Quantity Delivered
OR21013	INT	INTEGER	0	0	1	Spare	Picking List Status	0 — Line not ready for printing 1 — Line ready for printing on picking list 2 — Line sent on picking list
OR21014	NCHAR	STRING	2	0	2	AccountCode1	Accounting Code 1
OR21015	NCHAR	SWITCH	1	0	1	BackOrdrFlag	Back Order	Only used temporary during stock withdraw to indicate the lines that has been delivered during the process, lines with ‘1’ will not be issued when pressing ‘+’ or ‘A’ to deliver all lines.
OR21016	INT	INTEGER	0	0	1	LinePrntFlag	Line Layout	0 — The line is NOT printed on order documents. 1 — The line is printed with quantity, unit price and line total (Controlled by DDF file). 2 — The line is printed with line total amount only on the documents (Controlled by DDF file).
OR21017	NVARCHAR	VSTRING	6	0	6	VolDiscount	Volume Discount %
OR21018	NVARCHAR	VSTRING	6	0	6	CustDiscount	Customer Discount %
OR21019	DATETIME	DATE	0	0	8	IntrPlanning	Internal Planning Date
OR21020	NUMERIC	X_NUMERIC	18	8	10	QtyUnInDeliv	Items per Package (Purchase)
OR21021	NUMERIC	X_NUMERIC	18	8	10	QtyUnOutDeli	Items per Package (Sales)
OR21022	NUMERIC	X_NUMERIC	18	8	10	SellPrMultip	Selling Price Multiplier
OR21023	NUMERIC	X_NUMERIC	18	8	10	CostPrMultip	Cost Price Multiplier
OR21024	NUMERIC	X_NUMERIC	28	8	20	CurrExchRate	Currency Exchange Rate
OR21025	INT	INTEGER	0	0	1	ExtraTaxCode	Extra Tax Code	0 — Line is not liable for extra tax 1-3 Line is liable for extra tax (rate is defined in stock control)
OR21026	INT	INTEGER	0	0	1	DistCostCode	Distribution Cost Code
OR21027	INT	INTEGER	0	0	1	RepOrPrcCode	Repeat Order Price Option	0 — Use the price defined on the order line when invoicing the order 1 — Get current prices when invoicing the order
OR21028	NVARCHAR	ACCSTR	50	0	50	AccounString	Accounting String
OR21029	INT	INTEGER	0	0	1	FLAGDeliStat	Delivery Status
OR21030	INT	INTEGER	0	0	1	FLAGInvStat	Invoice Status
OR21031	INT	INTEGER	0	0	1	StockStatus	Stock Item Status
OR21032	BINARY	BINSTRING	1	0	1	ShipmRoule	Delivery Rule	0 — No test of the stock balance. 1 — Test on positive stock balance . 2 — Closed stock item, blocked orders. 3 — Direct delivery from supplier to customer. 4 — No over delivery. 5 — Back-delivery to purchase control.
OR21033	NUMERIC	X_NUMERIC	20	8	12	QyAllocated	Quantity Allocated
OR21034	NCHAR	SWITCH	1	0	1	FLAGHasSubIt	Has Sub-items in structure	Indicates if the order line is a BoM and there are sub-items attached to the item
OR21035	NVARCHAR	VSTRING	8	0	8	ItemType	Item Type
OR21036	NUMERIC	MONEY	28	8	20	Spare	Sales Tax Amount (Order Currency)	Sales tax amount for the order line, this is only applicable when using country code 1 (US) and there the system has been setup to use an external tax system.
OR21037	DATETIME	DATE	0	0	8	DelivDateReq	Delivery Date Requested
OR21038	NCHAR	SWITCH	1	0	1	FLAGCurrComp	Currency Compensation
OR21039	INT	INTEGER	0	0	2	CompensCurr	Currency Code Compensation
OR21040	NUMERIC	MONEY	28	8	20	OrDateExch	Order Date Exchange Rate
OR21041	NUMERIC	X_NUMERIC	28	8	20	OR2141SPARE	Delivery Date Exchange Rate
OR21042	DATETIME	DATE	0	0	8	IntrPlanningBO	Internal Planning Date Back Order
OR21043	NUMERIC	X_NUMERIC	18	8	10	NetWeight	Net Weight
OR21044	NUMERIC	X_NUMERIC	18	8	10	GrossWeight	Gross Weight
OR21045	NUMERIC	X_NUMERIC	18	8	10	Volume	Volume
OR21046	NVARCHAR	VSTRING	6	0	6	WarehouseID	Warehouse
OR21047	NUMERIC	MONEY	28	8	20	StatistPrice	Statistical Price (Local Currency)
OR21048	NUMERIC	X_NUMERIC	14	8	6	StatiDiscou	Statistical Discount
OR21049	NUMERIC	MONEY	28	8	20	StatCostPrc	Statistical Cost Price (Local Currency)
OR21050	NUMERIC	X_NUMERIC	20	8	12	QtyOriginal	Original Quantity
OR21051	NVARCHAR	VSTRING	6	0	6	Spare	Picking List Number
OR21052	NCHAR	STRING	1	0	1	DiscountsFrozen	Discounts Frozen
OR21053	NUMERIC	X_NUMERIC	20	8	12	Spare	Quantity Allocated
OR21054	NUMERIC	X_NUMERIC	20	8	12	Spare	Quantity Delivered
OR21055	NCHAR	SWITCH	1	0	1	FLAGStatNot	Statistics Not Updated	Used internally during order line entry to indicate if statistics has been updated or not.
OR21056	NUMERIC	X_NUMERIC	20	8	12	Spare	Quantity Ordered
OR21057	NUMERIC	X_NUMERIC	18	8	10	UnitConvFact	UOM Conversion Factor	Conversion factor used to convert between sales unit of measurement and stock unit of measurement.
OR21058	NUMERIC	X_NUMERIC	12	8	4	CusDisCalIt1	Customer Discount Calculation Item 1
OR21059	NUMERIC	X_NUMERIC	12	8	4	CusDisCalIt2	Customer Discount Calculation Item 2
OR21060	NUMERIC	X_NUMERIC	12	8	4	CusDisCalIt3	Customer Discount Calculation Item 3
OR21061	INT	INTEGER	0	0	2	VATCode1099	VAT Code 1
OR21062	INT	INTEGER	0	0	2	VATCode2099	VAT Code 2
OR21063	NUMERIC	MONEY	28	8	20	OrigDefaPri	Original Default Price (Original Currency)	The original price that was given when the order line was created.
OR21064	NUMERIC	X_NUMERIC	14	8	6	OriDefCusCod	Original Default Discount	The original line discount given when the order line was created.
OR21065	NVARCHAR	VSTRING	15	0	15	InvoiceNo	Invoice Number		2	Да
OR21066	NVARCHAR	VSTRING	10	0	10	SuborderNo	Sub-order Number
OR21067	NVARCHAR	VSTRING	10	0	10	PurchaseOrNo	Purchase Order Number
OR21068	NVARCHAR	VSTRING	12	0	12	PurchaLineNo	Purchase Order Line Number
OR21069	INT	INTEGER	0	0	1	PurcStatFlag	Purchase Order Status	0 — Purchase order line created 1 — Purchase order printed 2 — Purchase order line confirmed 3 — Delivery entered for purchase order line
OR21070	NCHAR	STRING	1	0	1	Status1	Status 1
OR21071	NCHAR	STRING	1	0	1	Status2	Status 2
OR21072	NCHAR	STRING	1	0	1	Status3	Status 3
OR21073	NCHAR	STRING	1	0	1	SubType	Sub-type
OR21074	NVARCHAR	VSTRING	27	0	27	Contract	Contract Number
OR21075	NVARCHAR	VSTRING	35	0	35	SearchField	Search Key
OR21076	NUMERIC	NUMBER	20	0	10	PickingList	Picking List Number
OR21077	NUMERIC	X_NUMERIC	18	8	10	Curexrate2	Currency Exchange Rate 2
OR21078	NCHAR	STRING	3	0	3	Curexalgm	Currency Exchange Algorithm
OR21079	NUMERIC	X_NUMERIC	18	8	10	Orddtexrate2	Order Date Exchange Rate 2
OR21080	NCHAR	STRING	3	0	3	Orddtexalgm	Order Date Exchange Algorithm
OR21081	NUMERIC	X_NUMERIC	18	8	10	Deldtexrate2	Delivery Date Exchange Rate 2
OR21082	NCHAR	STRING	3	0	3	Deldtexalgm	Delivery Date Exchange Algorithm
OR21083	INT	INTEGER	0	0	2	Currcode	Currency Code Order
OR21084	NCHAR	SWITCH	1	0	1	Ediswitch	EDI Contract
OR21085	INT	INTEGER	0	0	2	OrigPriceCurCode	Currency Code Original Price
OR21086	NUMERIC	MONEY	28	8	20	OrigUnitPrice	Original Unit Price (Original Currency)
OR21087	NVARCHAR	VSTRING	11	0	11	PriceDiscountHistory	Price/Discount History
OR21088	NUMERIC	MONEY	28	8	20	CostPriceCC	Unit Cost Price (Order Currency)
OR21089	NCHAR	STRING	25	0	25	SiteCode	Site Code
OR21090	DATETIME	DATE	0	0	8	TargetDate	Target Date
OR21091	NVARCHAR	VSTRING	2	0	2	GRPAltRout	Graphical Alternative Routing
OR21092	DATETIME	DATE	0	0	8	GRPStartDate	Graphical Planning Start Date
OR21093	DATETIME	DATE	0	0	8	GRPDueDate	Graphical Planning Due Date
OR21094	INT	INTEGER	0	0	1	GRPStatus	Graphical Status
OR21095	NVARCHAR	VSTRING	1	0	1	DropShipmentline	Drop Shipment Line
OR21096	NCHAR	STRING	38	0	38	ORBOMNodeID	BoM Node ID Order
OR21097	NCHAR	STRING	38	0	38	SCBOMNodeID	BoM Node ID Stock
OR21098	NVARCHAR	VSTRING	20	0	20	CustPOLineNo	Customer Purchase Order Line Number
OR21099	NVARCHAR	VSTRING	20	0	20	DelCustPOLineNo	Delivery Customer Purchase Order Line Number
OR21100	INT	INTEGER	0	0	9	DiscountGroupNumber	Discount Group
OR21101	DATETIME	DATE	0	0	8	DateConfirmationPrinted	Date Confirmation Printed
OR21102	DATETIME	DATE	0	0	8	DatePickListPrinted	Date Picking List Printed
OR21103	DATETIME	DATE	0	0	8	DateDeliveryProposalPrinted	Date Delivery Proposal Printed
OR21104	NCHAR	STRING	1	0	1	BlockForProcess	BOM Blocked for Processing
OR21105	NCHAR	STRING	4	0	4	VersionNumber	Version Number
OR21106	NUMERIC	MONEY	28	8	20	UnitCostPriceCC	Unit Cost Price (Alternative Currency)
OR21107	NVARCHAR	VSTRING	1	0	1	DSIssueOnGRR	Drop Shipment Issue on Receipt Rule	0 — Receive into Inventory 1 — Receive into Inventory and hard allocate to sales/service order 2 — Receive into Inventory and issue to sales/service order 3 — Issue to sales/service order without inventory update
OR21108	NCHAR	STRING	6	0	6	TaxCode	Tax Code Order Line
OR21109	NUMERIC	MONEY	28	8	20	PriceInclTax	Unit Price Including Tax (Order Currency)
OR21110	NCHAR	SWITCH	1	0	1	UseLocalBalance	Use local balance
OR21111	NCHAR	SWITCH	1	0	1	DeliveryWithoutStockTrans	Delivery Without Stock Trans
OR21112	NCHAR	STRING	8	0	8	StatisticsLineID	Statistics Line ID
OR21113	NCHAR	SWITCH	1	0	1	BlockPriceChange	Block Price Change	Blocked for automatic price change
OR21114	DATETIME	DATE	0	0	8	ConfDD	Confirmed Delivery Date
OR21115	DATETIME	DATE	0	0	8	ConfDDBO	Confirmed Delivery Date Back Order
OR21116	DATETIME	DATE	0	0	8	OriginalConfDD	Original Confirmed Delivery Date
OR21117	NVARCHAR	VSTRING	25	0	25	NomenclatureNo	NomenclatureNo
OR21118	DATETIME	DATE	0	0	8	DelDateAccepted	Accepted Delivery Date
OR21119	NCHAR	STRING	10	0	10	OrderCustomerCode	Order Customer Code
OR21120	NVARCHAR	VSTRING	10	0	10	FinOperationCode	FinOperationCode
OR21121	DATETIME	DATE	0	0	8	OrderLinePricingDate	Order Line Pricing Date
OR21122	NCHAR	STRING	10	0	10	OrderPricingNumber	Order Pricing Number
OR21123	NVARCHAR	VSTRING	20	0	20	RequestedDeliveryTime	Requested Delivery Time
OR21124	NVARCHAR	VSTRING	20	0	20	AcceptedDeliveryTime	Accepted Delivery Time
OR21125	INT	INTEGER	0	0	4	ExternalStatus	External status
OR21126	INT	INTEGER	0	0	1	LinePriceType	Line Price Type	0 –> Gross price + Discount (existing model) 1 –> Gross price + Net price (new)
OR21127	NUMERIC	MONEY	28	8	20	NetUnitPrice	Net Unit Price
OR21128	DATETIME	DATE	0	0	8	ConfirmedProductionDate	Confirmed Production Date
OR21129	NCHAR	STRING	2	0	2	ExemptTaxCode	Exempt Tax Code
OR21130	NUMERIC	MONEY	28	8	20	ExemptLimit	Exempt Limit	Tax exemption limit used for order line
OR21131	NUMERIC	MONEY	28	8	20	TaxablePrice	Taxable Price	Taxable Price for FOC items
OR21132	NCHAR	STRING	2	0	2	AccountCode2	Accounting Code 2
OR21133	NCHAR	SWITCH	1	0	1	DeliveryBlocked	Delivery Blocked
OR21134	NCHAR	SWITCH	1	0	1	Spare	Spare
OR21135	NUMERIC	MONEY	28	8	20	PackageTaxAmntPerKg	Packaging Tax Amount per kg
OR21136	NCHAR	SWITCH	1	0	1	ApprovedCreditLimit	Approved credit limit
OR21137	NVARCHAR	VSTRING	10	0	10	ProductTaxType	Product Tax Type
OR21138	NUMERIC	MONEY	28	8	20	LineFreightOCU	Line Freight OCU
OR21139	NUMERIC	MONEY	28	8	20	LineFreightICU	Line Freight ICU
OR21140	NCHAR	STRING	4	0	4	InvPrefix	Inv Prefix

История изменения структуры таблицы / Table structure changes history:

Поле / Field	iScala 2.2 HF 2.3318		iScala 2.3		iScala 2.3 SR1		iScala 2.3 SR2		iScala 2.3 SR3		iScala 3.0 FSP2		iScala 3.0 FSP4
Поле / Field	Длина поля / Field length	Длина iScala / iScala length	Длина поля / Field length	Длина iScala / iScala length	Длина поля / Field length	Длина iScala / iScala length	Длина поля / Field length	Длина iScala / iScala length	Длина поля / Field length	Длина iScala / iScala length	Длина поля / Field length	Длина iScala / iScala length	Длина поля / Field length	Длина iScala / iScala length
OR21010	0	2	0	2	0	4	0	4	0	4	0	4	0	4
OR21014	0	2	0	2	0	2	2	2	2	2	2	2	2	2
OR21114	—	—	0	8	0	8	0	8	0	8	0	8	0	8
OR21115	—	—	0	8	0	8	0	8	0	8	0	8	0	8
OR21116	—	—	0	8	0	8	0	8	0	8	0	8	0	8
OR21117	—	—	25	25	25	25	25	25	25	25	25	25	25	25
OR21118	—	—	0	8	0	8	0	8	0	8	0	8	0	8
OR21119	—	—	10	10	10	10	10	10	10	10	10	10	10	10
OR21120	—	—	10	10	10	10	10	10	10	10	10	10	10	10
OR21121	—	—	0	8	0	8	0	8	0	8	0	8	0	8
OR21122	—	—	10	10	10	10	10	10	10	10	10	10	10	10
OR21123	—	—	20	20	20	20	20	20	20	20	20	20	20	20
OR21124	—	—	20	20	20	20	20	20	20	20	20	20	20	20
OR21125	—	—	—	—	0	4	0	4	0	4	0	4	0	4
OR21126	—	—	—	—	0	1	0	1	0	1	0	1	0	1
OR21127	—	—	—	—	28	20	28	20	28	20	28	20	28	20
OR21128	—	—	—	—	0	8	0	8	0	8	0	8	0	8
OR21129	—	—	—	—	2	2	2	2	2	2	2	2	2	2
OR21130	—	—	—	—	28	20	28	20	28	20	28	20	28	20
OR21131	—	—	—	—	28	20	28	20	28	20	28	20	28	20
OR21132	—	—	—	—	—	—	2	2	2	2	2	2	2	2
OR21133	—	—	—	—	—	—	1	1	1	1	1	1	1	1
OR21134	—	—	—	—	—	—	1	1	1	1	1	1	1	1
OR21135	—	—	—	—	—	—	—	—	28	20	28	20	28	20
OR21136	—	—	—	—	—	—	—	—	1	1	1	1	1	1
OR21137	—	—	—	—	—	—	—	—	—	—	10	10	10	10
OR21138	—	—	—	—	—	—	—	—	—	—	28	20	28	20
OR21139	—	—	—	—	—	—	—	—	—	—	28	20	28	20
OR21140	—	—	—	—	—	—	—	—	—	—	—	—	4	4

Навигация:

Изменение полей в таблицах БД iScala 3.4 по сравнению с iScala 3.2 / Difference between DB structure of iScala 3.4 and iScala 3.2
Изменение полей в таблицах БД iScala 3.5 по сравнению с iScala 2.2 / Difference between DB structure of iScala 3.5 and iScala 2.2
Изменение структуры таблиц iScala 3.1 по сравнению с iScala 3.0 FSP4 / Table structure changes between iScala 3.0 FSP4 and iScala 3.1
История изменения структуры таблиц разных версий iScala / Tables structure changes history from iScala 2.2 SR2 to iScala 3.0 FSP4
Структура таблиц / Table structure Epicor iScala 3.0 FSP4 — 3.0.4267
Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511
Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317
Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419
Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399
Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0.0429