На один уровень вверх / One level Up: Структура таблиц / 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 :: Таблица / Table OR20 — Sales Order Head History

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
OR20001 NCHAR STRING 10 0 10 OrderNo Order Number   1 Да / Yes
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 Да / Yes
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 120 0 120 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 120 0 120 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      
OR20236 NCHAR STRING 1 0 1 FixExchRateFlag Fixed Exchange Rate Flag      
OR20237 NUMERIC X_NUMERIC 18 8 10 OCUExchangeRate1 OCU Exchange Rate 1      
OR20238 NCHAR STRING 3 0 3 OCUExchAlgorithm OCU Exchange Algorithm      
OR20239 NUMERIC X_NUMERIC 18 8 10 OCUExchangeRate2 OCU Exchange Rate 2      
OR20240 NCHAR STRING 2 0 2 OwnBankCode1 Own Bank Code 1      
OR20241 NCHAR STRING 2 0 2 OwnBankCode2 Own Bank Code 2      
OR20242 NVARCHAR VSTRING 34 0 34 BankAccount1 Bank Account 1      
OR20243 NVARCHAR VSTRING 10 0 10 BankCode2 Bank Code 2      
OR20244 NVARCHAR VSTRING 34 0 34 BankAccount2 Bank Account 2      

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