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

Таблица: OR20 — «HI. Order Head». Маска имени таблицы: «OR20%cc00»

Поле	Тип поля	Тип поля Scala	Длина поля	Точность	Длина Scala	Комментарий	Расширенный комментарий	Дополнительное описание	Позиция в индексе	Первичный ключ?
OR20001	NCHAR	STRING	10	0	10	OrderNo	Order Number		1	Да
OR20002	INT	INTEGER	0	0	1	OrderType	Order Type	0 — Quotation 1 — Normal Order 2 — Invoice Order 3 — Direct Order 4 — Back Order 5 — Repeat Order 6 — Work Order 7 — Direct Credit Order 8 — Credit Order 9 — Re-invoice Order
OR20003	NCHAR	STRING	10	0	10	CustCodeInv	Customer Code Invoice
OR20004	NCHAR	STRING	10	0	10	CustCodDeliv	Customer Code Delivery
OR20005	NVARCHAR	VSTRING	35	0	35	Remark1	Remark Line 1
OR20006	NVARCHAR	VSTRING	35	0	35	Remark2	Remark Line 2
OR20007	INT	INTEGER	0	0	1	FLAGOrderAck	Order Confirmation Status	0 — Document not ready for printing 1 — Print document 2 — Document sent
OR20008	INT	INTEGER	0	0	1	FLAGPickList	Picking List Status	0 — Document not ready for printing 1 — Print document 2 — Document sent
OR20009	INT	INTEGER	0	0	1	FLAGDispNote	Delivery Note Status	0 — Document not ready for printing 1 — Print document 2 — Document sent
OR20010	INT	INTEGER	0	0	1	FLAGInv	Invoice Status	0 — Not ready for printing 1 — Print invoice 2 — Invoice sent 3 — Print partial invoice 4 — Partial invoice sent 5 — Print consolidated invoice 6 — Consolidated invoice sent
OR20011	INT	INTEGER	0	0	1	FLAGProcStru	Structure Order Processed
OR20012	INT	INTEGER	0	0	2	TermsOfPaym	Payment Terms
OR20013	INT	INTEGER	0	0	2	TermsOfDeliv	Delivery Terms
OR20014	INT	INTEGER	0	0	2	WayOfDeliv	Delivery Method
OR20015	DATETIME	DATE	0	0	8	OrderDate	Order Date
OR20016	DATETIME	DATE	0	0	8	DeliveryDate	Delivery Date
OR20017	NVARCHAR	VSTRING	35	0	35	OurReference	Our Reference
OR20018	NVARCHAR	VSTRING	35	0	35	YourReferenc	Your Reference
OR20019	NVARCHAR	VSTRING	3	0	3	SalesmanNo	Salesman
OR20020	NVARCHAR	VSTRING	6	0	6	OrDiscount	Order Discount %
OR20021	NCHAR	STRING	15	0	15	InvoiceNo	Invoice Number		2	Да
OR20022	DATETIME	DATE	0	0	8	InvDaQuotDa	Invoice Date/Quote Valid To Date	Depends on order type: Order type 0 (quote): Quote valid to date All other types: Invoice date
OR20023	NVARCHAR	VSTRING	20	0	20	DispatNotNo	Delivery Note Number
OR20024	NUMERIC	MONEY	28	8	20	OrderValue	Order Value (Order Currency)
OR20025	NVARCHAR	ACCSTR	50	0	50	AccingString	Accounting String
OR20026	INT	INTEGER	0	0	1	OrMergeOptio	Order Merge Option	0 — Not to be merged/consolidate 1 — Merge/Consolidate per week 2 — Merge/Consolidate per month
OR20027	NVARCHAR	VSTRING	3	0	3	LanguageCode	Language
OR20028	INT	INTEGER	0	0	2	CurrencyCode	Currency Code Order
OR20029	INT	INTEGER	0	0	1	FLAGExportOr	Export Order
OR20030	INT	INTEGER	0	0	1	FLAGExporDoc	Export Document Status	0 — Document not ready for printing 1 — Print document 2 — Document sent
OR20031	INT	INTEGER	0	0	1	FLAGTrnspDoc	Transport Document Status	0 — Document not ready for printing 1 — Print document 2 — Document sent
OR20032	INT	INTEGER	0	0	1	FLAGCurrComp	Currency Compensation
OR20033	INT	INTEGER	0	0	2	CompensCurr	Currency Code Compensation
OR20034	NUMERIC	X_NUMERIC	14	8	6	LimitCompens	Limit For Compensation %
OR20035	NUMERIC	X_NUMERIC	14	8	6	Compensation	Compensation %
OR20036	NUMERIC	MONEY	28	8	20	OrderDExRate	Order Date Exchange Rate
OR20037	NUMERIC	X_NUMERIC	28	8	20	DelivDateExc	Delivery Date Exchange Rate
OR20038	NCHAR	STRING	4	0	4	OrRepeatIntr	Order Repeat Interval	Time unit is dependent on the first character of the field: Number of days (no leading character) Number of Weeks (W as leading character) Number of Month (M as leading character)
OR20039	DATETIME	DATE	0	0	8	RepOrStartDa	Repeat Order Start Date
OR20040	DATETIME	DATE	0	0	8	RepOrStopDa	Repeat Order End Date
OR20041	NUMERIC	MONEY	28	8	20	ROrAccInvAmt	Repeat Order Accumulated Invoiced Amount (Order Currency)
OR20042	NUMERIC	MONEY	28	8	20	ROrAccCost	Repeat Order Accumulated Costs (Local Currency)
OR20043	NUMERIC	MONEY	28	8	20	HandlingFee	Handling Fee (Order Currency)
OR20044	NUMERIC	MONEY	28	8	20	FreightAmont	Freight Amount (Order Currency)
OR20045	NVARCHAR	VSTRING	10	0	10	CustCodeOrd	Customer Code Order
OR20046	NUMERIC	MONEY	28	8	20	Packing	Packing Amount (Order Currency)
OR20047	INT	INTEGER	0	0	1	FLAGDeliProp	Delivery Proposal Status	0 — Document not ready for printing 1 — Print document 2 — Document sent
OR20048	NUMERIC	MONEY	28	8	20	Insurance	Insurance Amount (Order Currency)
OR20049	NVARCHAR	VSTRING	1	0	1	Spare	Storno Invoice
OR20050	NVARCHAR	VSTRING	6	0	6	WareHouse	Warehouse
OR20051	NVARCHAR	VSTRING	2	0	2	PriceList	Price List
OR20052	NCHAR	SWITCH	1	0	1	FLAGUpdIntra	Update Intrastat
OR20053	NVARCHAR	VSTRING	1	0	1	Spare	Point of Title
OR20054	NVARCHAR	VSTRING	1	0	1	PrTypeOnRepe	Price Type Repeat Order	0 — Use the price defined on the order line when invoicing the order 1 — Get current prices when invoicing the order
OR20055	NVARCHAR	VSTRING	1	0	1	FLAGTaxInvoice	Tax Invoice Status	0 — Document not ready for printing 1 — Print document 2 — Document sent
OR20056	NVARCHAR	VSTRING	35	0	35	ShipmentMark	Shipment Mark
OR20057	NUMERIC	X_NUMERIC	18	8	10	NetWeight	Net Weight
OR20058	NUMERIC	X_NUMERIC	18	8	10	GrossWeight	Gross Weight
OR20059	NUMERIC	X_NUMERIC	18	8	10	Volume	Volume
OR20060	NUMERIC	X_NUMERIC	18	8	10	NoOfUnits	No of Units
OR20061	NUMERIC	X_NUMERIC	14	8	6	ExternCommis	External Commission %
OR20062	NVARCHAR	VSTRING	10	0	10	ExtCommCode	External Commission Code
OR20063	NUMERIC	MONEY	28	8	20	OwnFreight	Own Freight Amount (Order Currency)
OR20064	NUMERIC	MONEY	28	8	20	ExternalCommissionAmount	External Commission Amount
OR20065	INT	INTEGER	0	0	1	DocLayout	Document Layout
OR20066	NCHAR	SWITCH	1	0	1	CurrContract	Currency Contract
OR20067	NUMERIC	X_NUMERIC	28	8	20	FixedExcRate	Fixed Exchange Rate
OR20068	NVARCHAR	VSTRING	15	0	15	ContractNo	Currency Contract Number
OR20069	NVARCHAR	VSTRING	8	0	8	CampaignCode	Campaign
OR20070	NVARCHAR	VSTRING	20	0	20	ExtDeliNotNo	Extended Delivery Note Number
OR20071	INT	INTEGER	0	0	1	InvRoundMod	Invoice Rounding Model
OR20072	NVARCHAR	VSTRING	20	0	20	CustPONo	Customer Purchase Order Number
OR20073	NCHAR	SWITCH	1	0	1	LetterOfCred	Letter of Credit
OR20074	DATETIME	DATE	0	0	8	LCOpenDate	Letter of Credit Open Date
OR20075	DATETIME	DATE	0	0	8	LCDueDate	Letter of Credit Due Date
OR20076	NVARCHAR	VSTRING	20	0	20	LCReference	Letter of Credit Reference
OR20077	DATETIME	DATE	0	0	8	BookEntrDate	Book-Entry Date
OR20078	NVARCHAR	VSTRING	6	0	6	CommonWHouNo	Common Warehouse
OR20079	NCHAR	SWITCH	1	0	1	PartDelivCod	Allow Partial Delivery
OR20080	INT	INTEGER	0	0	2	EDITransmCou	EDI Transmit Count
OR20081	INT	INTEGER	0	0	2	EDIReceCount	EDI Receive Count
OR20082	NVARCHAR	VSTRING	1	0	1	EDIFlag1	EDI Flag 1	Currently not used for any specific functionality
OR20083	NVARCHAR	VSTRING	1	0	1	EDIFlag2	EDI Flag 2	Currently not used for any specific functionality
OR20084	NVARCHAR	VSTRING	1	0	1	EDIFlag3	EDI Flag 3	Currently not used for any specific functionality
OR20085	NVARCHAR	VSTRING	1	0	1	EDIFlag4	EDI Flag 4	Currently not used for any specific functionality
OR20086	NVARCHAR	VSTRING	3	0	3	SalesmanNo2	Salesman 2
OR20087	NVARCHAR	VSTRING	3	0	3	SalesmanNo3	Salesman 3
OR20088	NVARCHAR	VSTRING	1	0	1	OR2088SPARE	Original Order Type	0 — Quotation 1 — Normal Order 2 — Invoice Order 3 — Direct Order 4 — Back Order 5 — Repeat Order 6 — Work Order 7 — Direct Credit Order 8 — Credit Order 9 — Re-invoice Order
OR20089	NVARCHAR	VSTRING	4	0	4	SaleTaxRemar	Sales Tax Remark
OR20090	NVARCHAR	VSTRING	4	0	4	Forwarder	Forwarder
OR20091	INT	INTEGER	0	0	1	OrderStatus	Order Status
OR20092	INT	INTEGER	0	0	2	VATCodFreigh	VAT Code Freight
OR20093	INT	INTEGER	0	0	2	VATCodePack	VAT Code Packing
OR20094	INT	INTEGER	0	0	2	VATCodeInsur	VAT Code Insurance
OR20095	NVARCHAR	VSTRING	2	0	2	OverrideSTax	VAT Code Override
OR20096	NVARCHAR	VSTRING	8	0	8	UserIdEntry	Entered By
OR20097	DATETIME	DATE	0	0	8	DueDate	Due Date
OR20098	NVARCHAR	VSTRING	10	0	10	SuborContrNo	Sub-Order Contract Number
OR20099	NVARCHAR	VSTRING	10	0	10	SuborderNo	Sub-Order Number
OR20100	INT	INTEGER	0	0	1	OrCreatModul	Order created from module	5 or 7: Linked to project activity line
OR20101	NVARCHAR	VSTRING	30	0	30	OrigModulLiD	Original Module Line ID
OR20102	INT	INTEGER	0	0	1	OrigModuStat	Original Module Status
OR20103	NVARCHAR	VSTRING	27	0	27	Contract	Contract
OR20104	NCHAR	STRING	1	0	1	VATFlag	VAT Option
OR20105	NCHAR	STRING	3	0	3	OrderHandler	Number of Printed Invoice Copies
OR20106	NCHAR	SWITCH	1	0	1	IntereBlock	Interest Block
OR20107	NVARCHAR	VSTRING	6	0	6	InterLatePay	Interest Late Payment
OR20108	NVARCHAR	ACCSTR	50	0	50	INTRDeSdAcSt	Internal Debiting Accounting String
OR20109	NVARCHAR	VSTRING	4	0	4	InvPrefix	Invoice Prefix
OR20110	NUMERIC	X_NUMERIC	18	8	10	Odexrate2	Order Date Exchange Rate 2
OR20111	NCHAR	STRING	3	0	3	Odexalgm	Order Date Exchange Algorithm
OR20112	NUMERIC	X_NUMERIC	18	8	10	Deldtexrate2	Delivery Date Exchange Rate 2
OR20113	NCHAR	STRING	3	0	3	Deldtexalgm	Delivery Date Exchange Algorithm
OR20114	NUMERIC	X_NUMERIC	18	8	10	Fixexrate2	Fixed Exchange Rate 2
OR20115	NCHAR	STRING	3	0	3	Fixexalgm	Fixed Exchange Algorithm
OR20116	INT	INTEGER	0	0	2	Invcurcode	Currency Code Invoice
OR20117	NCHAR	SWITCH	1	0	1	Ediswitch	EDI-Contract
OR20118	INT	INTEGER	0	0	2	VATCodeInvFee	VAT Code Invoice Fee
OR20119	NUMERIC	X_NUMERIC	18	8	10	InvCurrExchRate1	Invoice Currency Exchange Rate
OR20120	NUMERIC	X_NUMERIC	18	8	10	InvCurrExchRate2	Invoice Currency Exchange Rate 2
OR20121	NCHAR	STRING	3	0	3	InvCurrExchAlg	Invoice Currency Exchange Algorithm
OR20122	INT	INTEGER	0	0	1	InclInStat	Include in Billing Statement
OR20123	NUMERIC	MONEY	28	8	20	AllowAmICU	Allowance Amount
OR20124	NCHAR	STRING	2	0	2	AllowTaxRate	VAT Code Allowance
OR20125	NUMERIC	MONEY	28	8	20	SurchargeAmICU	Surcharge Amount (Order Currency)
OR20126	NCHAR	STRING	2	0	2	SurchargeTaxRate	VAT Code Surcharge
OR20127	NUMERIC	MONEY	28	8	20	AdvanceAmount	Advance Amount (Order Currency)
OR20128	NCHAR	SWITCH	1	0	1	ExternalControl	External Control
OR20129	INT	INTEGER	0	0	1	FLAGOrAcknXML	EDI/XML Order Acknowledgement Status	0 — Document not ready for sending 1 — Send document 2 — Document sent
OR20130	INT	INTEGER	0	0	1	FLAGPickListXML	EDI/XML Picking List Status	0 — Document not ready for sending 1 — Send document 2 — Document sent
OR20131	INT	INTEGER	0	0	1	FLAGDispNoteXML	EDI/XML Delivery Note Status	0 — Document not ready for sending 1 — Send document 2 — Document sent
OR20132	INT	INTEGER	0	0	1	FLAGInvoiceXML	EDI/XML Invoice Status	0 — Invoice not ready for sending 1 — Send invoice 2 — Invoice sent 3 — Send partial invoice 4 — Partial invoice sent
OR20133	INT	INTEGER	0	0	1	FLAGTranspDocXML	EDI/XML Transport Document Status	0 — Document not ready for sending 1 — Send document 2 — Document sent
OR20134	INT	INTEGER	0	0	1	FLAGExpDocXML	EDI/XML Export Document Status	0 — Document not ready for sending 1 — Send document 2 — Document sent
OR20135	INT	INTEGER	0	0	1	DeliPropFlagXML	EDI/XML Delivery Proposal Status	0 — Document not ready for sending 1 — Send document 2 — Document sent
OR20136	INT	INTEGER	0	0	1	FLAGTaxInvoiceXML	EDI/XML Tax Invoice Status	0 — Document not ready for sending 1 — Send document 2 — Document sent
OR20137	NCHAR	STRING	12	0	12	ProjectNumber	Project
OR20138	NCHAR	STRING	25	0	25	SiteCode	Site Code
OR20139	NCHAR	STRING	15	0	15	OriginalInvoiceNo	Original Invoice Number
OR20140	NCHAR	STRING	10	0	10	OriginalOrderNo	Original Order Number
OR20141	NVARCHAR	VSTRING	1	0	1	FlagCreateInvoice	Create Invoice
OR20142	NCHAR	STRING	10	0	10	PriReschedule	Order Priority Rescheduling ATP
OR20143	NCHAR	SWITCH	1	0	1	AccLineSplit	Accept Order Line Split ATP
OR20144	NCHAR	SWITCH	1	0	1	AccOrderSplit	Accept Order Split ATP
OR20145	DATETIME	DATE	0	0	8	QuoteDate	Quote Date
OR20146	INT	INTEGER	0	0	1	DetainOrdDisc	Detain Order Discount
OR20147	NVARCHAR	VSTRING	20	0	20	DelCustPONo	Delivery Customer Purchase Order Number
OR20148	INT	INTEGER	0	0	9	DiscountSchemaNo	Discount Schema Code
OR20149	NCHAR	STRING	10	0	10	RequestNo	Customer Request
OR20150	NUMERIC	X_NUMERIC	14	8	6	MarkUp	Mark-up %
OR20151	DATETIME	DATE	0	0	8	OrderPricingDate	Order Pricing Date
OR20152	INT	INTEGER	0	0	1	Priority	Order Priority
OR20153	INT	INTEGER	0	0	1	PriorityWeighted	Weighted Priority
OR20154	NCHAR	STRING	10	0	10	ContractNumber	Contract Number
OR20155	NCHAR	STRING	4	0	4	VersionNumber	Version Number
OR20156	NVARCHAR	VSTRING	4	0	4	CancellationCode	Cancellation Code
OR20157	NCHAR	STRING	6	0	6	TaxLiability	Tax Liability Code
OR20158	NCHAR	STRING	6	0	6	TaxCodeFreight	Tax Code for Freight
OR20159	NCHAR	STRING	6	0	6	TaxCodeInsurance	Tax Code for Insurance
OR20160	NCHAR	STRING	6	0	6	TaxCodePacking	Tax Code for Packing
OR20161	NCHAR	STRING	6	0	6	TaxCodeInvFee	Tax Code for Invoicing Fee
OR20162	NCHAR	STRING	6	0	6	TaxCodeDistribution	Tax Code for Distribution
OR20163	NCHAR	STRING	6	0	6	TaxCodeAllowance	Tax Code for Allowance
OR20164	NCHAR	STRING	6	0	6	TaxCodeSurcharge	Tax Code for Surcharge
OR20165	NVARCHAR	VSTRING	10	0	10	CFOPCode	CFOP Code
OR20166	NVARCHAR	VSTRING	10	0	10	OperationType	Operation Code
OR20167	NVARCHAR	VSTRING	10	0	10	FOPFiscTxtCode	Fiscal Text Code
OR20168	NCHAR	STRING	6	0	6	InvoiceIssuer	Invoice Issuer Code
OR20169	NCHAR	SWITCH	1	0	1	InvCategory	Invoice Category [A;B;C;E;Z]
OR20170	NCHAR	SWITCH	1	0	1	InvType	Invoice Type [0;1;2]
OR20171	NCHAR	SWITCH	1	0	1	ConsolidatedDSDelivery	Consolidated DS Delivery
OR20172	NCHAR	SWITCH	1	0	1	ConsolidatedCWHDelivery	Consolidated cwh Delivery	Consolidated cwh Delivery
OR20173	NVARCHAR	VSTRING	10	0	10	FinOperationCode2	Financial Operation Code 2
OR20174	NCHAR	STRING	10	0	10	DSSupplier	Drop Shipment Supplier
OR20175	NCHAR	SWITCH	1	0	1	Instalment	Instalment
OR20176	NVARCHAR	VSTRING	6	0	6	Interest	Interest
OR20177	NUMERIC	MONEY	28	8	20	FinCharge	FinCharge
OR20178	NCHAR	STRING	6	0	6	TaxCodeInterest	TaxCodeInterest
OR20179	NCHAR	STRING	6	0	6	TaxCodeFinCharge	TaxCodeFinCharge
OR20180	DATETIME	DATE	0	0	8	ActivateNewInterest	ActivateNewInterest
OR20181	NVARCHAR	VSTRING	6	0	6	NewInterestPercent	NewInterest%
OR20182	INT	INTEGER	0	0	1	SalesReturnReasonCode	Sales Return Reason Code
OR20183	NCHAR	NUMERICSTRING	10	0	10	RMAReference	RMA Reference
OR20184	NVARCHAR	VSTRING	50	0	50	ReturnComment	Return Comment
OR20185	NVARCHAR	VSTRING	15	0	15	KindOfBox	Kind of Box
OR20186	NVARCHAR	VSTRING	15	0	15	BoxNumbering	Box numbering
OR20187	NVARCHAR	VSTRING	15	0	15	NumberOfPallets	Number of pallets
OR20188	NVARCHAR	VSTRING	10	0	10	TransportCompanyCode	Transport Company Code
OR20189	NVARCHAR	VSTRING	10	0	10	VehicleState	Vehicle State/Province
OR20190	NVARCHAR	VSTRING	15	0	15	VehicleLicensePlate	Vehicle License Plate
OR20191	NCHAR	SWITCH	1	0	1	FreightPayer	Freight Payer
OR20192	NCHAR	STRING	6	0	6	OwnFreightTaxCode	Own Freight Tax Code
OR20193	NVARCHAR	VSTRING	2	0	2	OrigTermsPayment	Orig Terms Payment
OR20194	NCHAR	STRING	10	0	10	SalesContractNo	Contract Number
OR20195	DATETIME	DATE	0	0	8	ShipmentDateActual	Shipment Date Actual
OR20196	DATETIME	DATE	0	0	8	DeliveryDateEstimated	Delivery Date Estimated
OR20197	DATETIME	DATE	0	0	8	TitlePassDate	Title Pass Date
OR20198	NCHAR	SWITCH	1	0	1	DelNoteSort	Delivery Note, sort
OR20199	NVARCHAR	VSTRING	1	0	1	AutoprintDN	Auto print DN
OR20200	NVARCHAR	VSTRING	1	0	1	AutosendDN	Auto send DN
OR20201	INT	INTEGER	0	0	1	ReleaseForWithdrawal	Release for withdrawal
OR20202	INT	INTEGER	0	0	1	DelNotePrinting	Delivery note printing
OR20203	INT	INTEGER	0	0	1	InvPrinting	Invoice printing
OR20204	NCHAR	STRING	1	0	1	CreateBackOrder	Create back-order
OR20205	NCHAR	STRING	10	0	10	OrderPricingNumber	Order Pricing Number
OR20206	NVARCHAR	VSTRING	1	0	1	AutoPrintInvoice	Auto print Invoice
OR20207	NVARCHAR	VSTRING	1	0	1	AutoSendInvoice	Auto send Invoice
OR20208	NVARCHAR	VSTRING	2	0	2	District	District
OR20209	NVARCHAR	VSTRING	2	0	2	AdvertisingCode	Advertising Code
OR20210	NVARCHAR	VSTRING	4	0	4	CityCode	City Code
OR20211	NVARCHAR	VSTRING	5	0	5	SNICode	SNI Code
OR20212	NVARCHAR	VSTRING	1	0	1	CommissionDistrMethod	Commision Distribution Method
OR20213	INT	INTEGER	0	0	3	ReasonCode	Reason Code
OR20214	NVARCHAR	VSTRING	2	0	2	WayOfPayment	Way of payments
OR20215	NVARCHAR	VSTRING	10	0	10	BankCode	Bank Code
OR20216	NVARCHAR	VSTRING	2	0	2	PaymentAddressCode	Payment Address Code
OR20217	DATETIME	DATE	0	0	8	AcceptedDeliveryDate	Accepted Delivery Date
OR20218	NVARCHAR	VSTRING	20	0	20	PlannedDeliveryTime	Planned Delivery Time
OR20219	NVARCHAR	VSTRING	20	0	20	AcceptedDeliveryTime	Accepted Delivery Time
OR20220	NCHAR	NUMERICSTRING	10	0	10	SalesReturnOrderNo	Sales Return Order No
OR20221	NCHAR	STRING	15	0	15	SalesReturnInvoiceNo	Sales Return Invoice No
OR20222	NVARCHAR	VSTRING	200	0	200	EmailAddress	Email address
OR20223	DATETIME	X_DATETIME	0	0	17	InvoiceTime	Invoice Time
OR20224	NVARCHAR	VSTRING	1	0	1	PartialDeliveryPlanning	Partial Delivery Planning	0 – allowed 1 – prohibited
OR20225	INT	INTEGER	0	0	1	LockOrderPayments	Lock Order Payments	0 – Default. Order can be linked to advance payments. 1 – Order is ‘locked’ for linking to advance payments.
OR20226	NCHAR	SWITCH	1	0	1	CustomerForPrice	Customer for price
OR20227	NUMERIC	MONEY	28	8	20	PackageTaxAmntPerKg	Packaging Tax Amount per kg
OR20228	NCHAR	SWITCH	1	0	1	CreditCheckPassed	Credit check passed
OR20229	NVARCHAR	VSTRING	10	0	10	CodeANTT	Code ANTT
OR20230	NCHAR	STRING	1	0	1	FreightTaxMode	Freight Tax Mode
OR20231	NVARCHAR	VSTRING	50	0	50	FiscalReference	Fiscal Reference
OR20232	NVARCHAR	VSTRING	12	0	12	SpesometroForms	Spesometro Forms
OR20233	NCHAR	STRING	1	0	1	TaxPoint	TaxPoint
OR20234	NVARCHAR	VSTRING	20	0	20	PublicProcuremCode1	Public Procurement Code1
OR20235	NVARCHAR	VSTRING	20	0	20	PublicProcuremCode2	Public Procurement Code2

История изменения структуры таблицы / 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
OR20168	4	4	4	4	4	4	6	6	6	6	6	6	6	6
OR20173	—	—	10	10	10	10	10	10	10	10	10	10	10	10
OR20174	—	—	10	10	10	10	10	10	10	10	10	10	10	10
OR20175	—	—	1	1	1	1	1	1	1	1	1	1	1	1
OR20176	—	—	6	6	6	6	6	6	6	6	6	6	6	6
OR20177	—	—	28	20	28	20	28	20	28	20	28	20	28	20
OR20178	—	—	6	6	6	6	6	6	6	6	6	6	6	6
OR20179	—	—	6	6	6	6	6	6	6	6	6	6	6	6
OR20180	—	—	0	8	0	8	0	8	0	8	0	8	0	8
OR20181	—	—	6	6	6	6	6	6	6	6	6	6	6	6
OR20182	—	—	0	1	0	1	0	1	0	1	0	1	0	1
OR20183	—	—	10	10	10	10	10	10	10	10	10	10	10	10
OR20184	—	—	50	50	50	50	50	50	50	50	50	50	50	50
OR20185	—	—	15	15	15	15	15	15	15	15	15	15	15	15
OR20186	—	—	15	15	15	15	15	15	15	15	15	15	15	15
OR20187	—	—	15	15	15	15	15	15	15	15	15	15	15	15
OR20188	—	—	10	10	10	10	10	10	10	10	10	10	10	10
OR20189	—	—	10	10	10	10	10	10	10	10	10	10	10	10
OR20190	—	—	15	15	15	15	15	15	15	15	15	15	15	15
OR20191	—	—	1	1	1	1	1	1	1	1	1	1	1	1
OR20192	—	—	6	6	6	6	6	6	6	6	6	6	6	6
OR20193	—	—	2	2	2	2	2	2	2	2	2	2	2	2
OR20194	—	—	10	10	10	10	10	10	10	10	10	10	10	10
OR20195	—	—	0	8	0	8	0	8	0	8	0	8	0	8
OR20196	—	—	0	8	0	8	0	8	0	8	0	8	0	8
OR20197	—	—	0	8	0	8	0	8	0	8	0	8	0	8
OR20198	—	—	1	1	1	1	1	1	1	1	1	1	1	1
OR20199	—	—	1	1	1	1	1	1	1	1	1	1	1	1
OR20200	—	—	1	1	1	1	1	1	1	1	1	1	1	1
OR20201	—	—	0	1	0	1	0	1	0	1	0	1	0	1
OR20202	—	—	0	1	0	1	0	1	0	1	0	1	0	1
OR20203	—	—	0	1	0	1	0	1	0	1	0	1	0	1
OR20204	—	—	1	1	1	1	1	1	1	1	1	1	1	1
OR20205	—	—	10	10	10	10	10	10	10	10	10	10	10	10
OR20206	—	—	—	—	1	1	1	1	1	1	1	1	1	1
OR20207	—	—	—	—	1	1	1	1	1	1	1	1	1	1
OR20208	—	—	—	—	2	2	2	2	2	2	2	2	2	2
OR20209	—	—	—	—	2	2	2	2	2	2	2	2	2	2
OR20210	—	—	—	—	4	4	4	4	4	4	4	4	4	4
OR20211	—	—	—	—	5	5	5	5	5	5	5	5	5	5
OR20212	—	—	—	—	1	1	1	1	1	1	1	1	1	1
OR20213	—	—	—	—	0	3	0	3	0	3	0	3	0	3
OR20214	—	—	—	—	2	2	2	2	2	2	2	2	2	2
OR20215	—	—	—	—	10	10	10	10	10	10	10	10	10	10
OR20216	—	—	—	—	2	2	2	2	2	2	2	2	2	2
OR20217	—	—	—	—	0	8	0	8	0	8	0	8	0	8
OR20218	—	—	—	—	20	20	20	20	20	20	20	20	20	20
OR20219	—	—	—	—	20	20	20	20	20	20	20	20	20	20
OR20220	—	—	—	—	—	—	10	10	10	10	10	10	10	10
OR20221	—	—	—	—	—	—	15	15	15	15	15	15	15	15
OR20222	—	—	—	—	—	—	200	200	200	200	200	200	200	200
OR20223	—	—	—	—	—	—	0	17	0	17	0	17	0	17
OR20224	—	—	—	—	—	—	1	1	1	1	1	1	1	1
OR20225	—	—	—	—	—	—	0	1	0	1	0	1	0	1
OR20226	—	—	—	—	—	—	—	—	1	1	1	1	1	1
OR20227	—	—	—	—	—	—	—	—	28	20	28	20	28	20
OR20228	—	—	—	—	—	—	—	—	1	1	1	1	1	1
OR20229	—	—	—	—	—	—	—	—	—	—	10	10	10	10
OR20230	—	—	—	—	—	—	—	—	—	—	1	1	1	1
OR20231	—	—	—	—	—	—	—	—	—	—	50	50	50	50
OR20232	—	—	—	—	—	—	—	—	—	—	12	12	12	12
OR20233	—	—	—	—	—	—	—	—	—	—	1	1	1	1
OR20234	—	—	—	—	—	—	—	—	—	—	—	—	20	20
OR20235	—	—	—	—	—	—	—	—	—	—	—	—	20	20

Навигация:

Изменение полей в таблицах БД 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