One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Sales Order»

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / Table OR40 — Sales Order Header Historical Versions

Таблица / Table: OR40 — «Sales Order Header Historical Versions». Маска имени таблицы / Table name mask: «OR40%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
OR40001 NCHAR NUMERICSTRING 10 0 10 OrderNumber Order Number   1 Да / Yes
OR40002 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
   
OR40003 NCHAR STRING 10 0 10 CustCodeInv Customer Code Invoice      
OR40004 NCHAR STRING 10 0 10 CustCodeDel Customer Code Delivery      
OR40005 NVARCHAR VSTRING 35 0 35 Remark1 Remark Line 1      
OR40006 NVARCHAR VSTRING 35 0 35 Remark2 Remark Line 2      
OR40007 INT INTEGER 0 0 1 FLAGOrAckn Order Confirmation Status 0 — Document not ready for printing

1 — Print document

2 — Document sent
   
OR40008 INT INTEGER 0 0 1 FLAGPickList Picking List Status 0 — Document not ready for printing

1 — Print document

2 — Document sent
   
OR40009 INT INTEGER 0 0 1 FLAGDispNote Delivery Note Status 0 — Document not ready for printing

1 — Print document

2 — Document sent
   
OR40010 INT INTEGER 0 0 1 FLAGInvoice 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
   
OR40011 INT INTEGER 0 0 1 FLAGProcStru Structure Order Processed      
OR40012 INT INTEGER 0 0 2 TermsPayment Payment Terms      
OR40013 INT INTEGER 0 0 2 TermsofDel Delivery Terms      
OR40014 INT INTEGER 0 0 2 WayofDel Delivery Method      
OR40015 DATETIME DATE 0 0 8 OrderDate Order Date      
OR40016 DATETIME DATE 0 0 8 DelDate Delivery Date      
OR40017 NVARCHAR VSTRING 35 0 35 OurReferen Our Reference      
OR40018 NVARCHAR VSTRING 35 0 35 YourReferen Your Reference      
OR40019 NVARCHAR VSTRING 3 0 3 SalesmanNo Salesman      
OR40020 NVARCHAR VSTRING 6 0 6 OrdDiscount Order Discount %      
OR40021 NCHAR STRING 15 0 15 InvoiceNo Invoice Number      
OR40022 DATETIME DATE 0 0 8 InvoiceQuot Invoice Date/Quote Valid To Date Depends on order type:

Order type 0 (quote): Quote valid to date

All other types: Invoice date
   
OR40023 NVARCHAR VSTRING 20 0 20 DispatNoteNo Delivery Note Number      
OR40024 NUMERIC MONEY 28 8 20 OrderValue Order Value (Order Currency)      
OR40025 NVARCHAR ACCSTR 120 0 120 AccCodString Accounting String      
OR40026 INT INTEGER 0 0 1 ORMergeOption Order Merge Option 0 — Not to be merged/consolidate

1 — Merge/Consolidate per week

2 — Merge/Consolidate per month
   
OR40027 NVARCHAR VSTRING 3 0 3 LanguageCode Language      
OR40028 INT INTEGER 0 0 2 CurrCode Currency Code      
OR40029 INT INTEGER 0 0 1 FLAGExportOR Export Order      
OR40030 INT INTEGER 0 0 1 FLAGExpDoc Export Document Status 0 — Document not ready for printing

1 — Print document

2 — Document sent
   
OR40031 INT INTEGER 0 0 1 FLAGTransDoc Transport Document Status 0 — Document not ready for printing

1 — Print document

2 — Document sent
   
OR40032 INT INTEGER 0 0 1 FLAGCurrComp Currency Compensation      
OR40033 INT INTEGER 0 0 2 CompCurrNo Currency Code Compensation      
OR40034 NUMERIC X_NUMERIC 14 8 6 LimitCompens Limit For Compensation %      
OR40035 NUMERIC X_NUMERIC 14 8 6 Compensation Compensation %      
OR40036 NUMERIC MONEY 28 8 20 ORDateExRat Order Date Exchange Rate      
OR40037 NUMERIC X_NUMERIC 28 8 20 DelDateExRat Delivery Date Exchange Rate      
OR40038 NCHAR STRING 4 0 4 OrRepInterva 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)
   
OR40039 DATETIME DATE 0 0 8 RepOrStartD Repeat Order Start Date      
OR40040 DATETIME DATE 0 0 8 RepOrStopDa Repeat Order End Date      
OR40041 NUMERIC MONEY 28 8 20 RepOrAccInv Repeat Order Accumulated Invoiced Amount (Order Currency)      
OR40042 NUMERIC MONEY 28 8 20 RepOrdAccum Repeat Order Accumulated Costs (Local Currency)      
OR40043 NUMERIC MONEY 28 8 20 HandlingFee Handling Fee (Order Currency)      
OR40044 NUMERIC MONEY 28 8 20 FreightAmoun Freight Amount (Order Currency)      
OR40045 NVARCHAR VSTRING 10 0 10 CustCodeOrd Customer Code Order      
OR40046 NUMERIC MONEY 28 8 20 Packing Packing Amount (Order Currency)      
OR40047 INT INTEGER 0 0 1 FLAGDeliProp Delivery Proposal Status 0 — Document not ready for printing

1 — Print document

2 — Document sent
   
OR40048 NUMERIC MONEY 28 8 20 Insurance Insurance Amount (Order Currency)      
OR40049 NVARCHAR VSTRING 1 0 1 StornoInvSw Storno Invoice      
OR40050 NVARCHAR VSTRING 6 0 6 WareHouse Warehouse      
OR40051 NVARCHAR VSTRING 2 0 2 PriceList Price List      
OR40052 NCHAR SWITCH 1 0 1 FLAGUpdatInt Update Intrastat      
OR40053 NVARCHAR VSTRING 1 0 1 PtOfTitlPass Point of Title      
OR40054 NVARCHAR VSTRING 1 0 1 PricTypOnRep 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
   
OR40055 NVARCHAR VSTRING 1 0 1 FLAGTaxInvoice Tax Invoice Status 0 — Document not ready for printing

1 — Print document

2 — Document sent
   
OR40056 NVARCHAR VSTRING 35 0 35 ShipmentMark Shipment Mark      
OR40057 NUMERIC X_NUMERIC 18 8 10 NetWeight Net Weight      
OR40058 NUMERIC X_NUMERIC 18 8 10 GrossWeight Gross Weight      
OR40059 NUMERIC X_NUMERIC 18 8 10 Volume Volume      
OR40060 NUMERIC X_NUMERIC 18 8 10 NoOfUnits No of Units      
OR40061 NUMERIC X_NUMERIC 14 8 6 ExternComm1 External Commission %      
OR40062 NVARCHAR VSTRING 10 0 10 ExternComm2 External Commission Code      
OR40063 NUMERIC MONEY 28 8 20 OwnFreight Own Freight Amount (Order Currency)      
OR40064 NUMERIC MONEY 28 8 20 ExternalCommissionAmount External Commission Amount      
OR40065 INT INTEGER 0 0 1 DocuLayout Document Layout      
OR40066 NCHAR SWITCH 1 0 1 CurrContract Currency Contract      
OR40067 NUMERIC X_NUMERIC 28 8 20 FixedExchRat Fixed Exchange Rate      
OR40068 NVARCHAR VSTRING 15 0 15 ContractNo Currency Contract Number      
OR40069 NVARCHAR VSTRING 8 0 8 CampaignCode Campaign      
OR40070 NVARCHAR VSTRING 20 0 20 ExtDelNoteNo Extended Delivery Note Number      
OR40071 INT INTEGER 0 0 1 InvRoundMod Invoice Rounding Model      
OR40072 NVARCHAR VSTRING 30 0 30 CustPONo Customer Purchase Order Number      
OR40073 NCHAR SWITCH 1 0 1 LetterOfCred Letter of Credit      
OR40074 DATETIME DATE 0 0 8 LetterCredOp Letter of Credit Open Date      
OR40075 DATETIME DATE 0 0 8 LetterCredDu Letter of Credit Due Date      
OR40076 NVARCHAR VSTRING 20 0 20 LetteCredRef Letter of Credit Reference      
OR40077 DATETIME DATE 0 0 8 BookEntrDate Book-Entry Date      
OR40078 NVARCHAR VSTRING 6 0 6 CommWarehNo Common Warehouse      
OR40079 NCHAR SWITCH 1 0 1 PartialDelCd Allow Partial Delivery      
OR40080 INT INTEGER 0 0 2 EDITrmittCou EDI Transmit Count      
OR40081 INT INTEGER 0 0 2 EDIReceivCou EDI Receive Count      
OR40082 NVARCHAR VSTRING 1 0 1 EDIFlag1 EDI Flag 1 Currently not used for any specific functionality    
OR40083 NVARCHAR VSTRING 1 0 1 EDIFlag2 EDI Flag 2 Currently not used for any specific functionality    
OR40084 NVARCHAR VSTRING 1 0 1 EDIFlag3 EDI Flag 3 Currently not used for any specific functionality    
OR40085 NVARCHAR VSTRING 1 0 1 EDIFlag4 EDI Flag 4 Currently not used for any specific functionality    
OR40086 NVARCHAR VSTRING 3 0 3 SalesmanNo2 Salesman 2      
OR40087 NVARCHAR VSTRING 3 0 3 SalesmanNo3 Salesman 3      
OR40088 NVARCHAR VSTRING 1 0 1 Spare 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
   
OR40089 NVARCHAR VSTRING 4 0 4 SalesTaxRema Sales Tax Remark      
OR40090 NVARCHAR VSTRING 4 0 4 Forwarder Forwarder      
OR40091 INT INTEGER 0 0 1 OrderStatus Order Status      
OR40092 INT INTEGER 0 0 2 VATCodeFreig VAT Code Freight      
OR40093 INT INTEGER 0 0 2 VATCodePack VAT Code Packing      
OR40094 INT INTEGER 0 0 2 VATCodeInsur VAT Code Insurance      
OR40095 NVARCHAR VSTRING 2 0 2 OvrideSlTaxC VAT Code Override      
OR40096 NVARCHAR VSTRING 8 0 8 UserIDEntry Entered By      
OR40097 DATETIME DATE 0 0 8 DueDate Due Date      
OR40098 NVARCHAR VSTRING 10 0 10 SuborContrNo Sub-Order Contract Number      
OR40099 NVARCHAR VSTRING 10 0 10 SuborderNo Sub-Order Number      
OR40100 INT INTEGER 0 0 1 OrCreatModul Order created from module 5 or 7: Linked to project activity line    
OR40101 NVARCHAR VSTRING 30 0 30 OrigModLinID Original Module Line ID      
OR40102 INT INTEGER 0 0 1 OrigModStatu Original Module Status      
OR40103 NVARCHAR VSTRING 27 0 27 Contract Contract      
OR40104 NCHAR STRING 1 0 1 VATFlag VAT Option      
OR40105 NCHAR STRING 3 0 3 OrdHandler Number of Printed Invoice Copies      
OR40106 NCHAR SWITCH 1 0 1 IntereBlock Interest Block      
OR40107 NVARCHAR VSTRING 6 0 6 IntrLatePaym Interest Late Payment      
OR40108 NVARCHAR ACCSTR 120 0 120 INTRDebit Internal Debiting Accounting String      
OR40109 NVARCHAR VSTRING 4 0 4 InvPrefix Invoice Prefix      
OR40110 NUMERIC X_NUMERIC 18 8 10 OrderDateExchgRate1 Order Date Exchange Rate 2      
OR40111 NCHAR STRING 3 0 3 OrderDateExchgAlgtm Order Date Exchange Algorithm      
OR40112 NUMERIC X_NUMERIC 18 8 10 DlvryDateExchgRate2 Delivery Date Exchange Rate 2      
OR40113 NCHAR STRING 3 0 3 DlvryDateExchgAlgtm Delivery Date Exchange Algorithm      
OR40114 NUMERIC X_NUMERIC 18 8 10 FixedExchgRate2 Fixed Exchange Rate 2      
OR40115 NCHAR STRING 3 0 3 FixedExchgAlgtm Fixed Exchange Algorithm      
OR40116 INT INTEGER 0 0 2 InvoiceCurrCode Currency Code Invoice      
OR40117 NCHAR SWITCH 1 0 1 EDIContractSwitch EDI-Contract      
OR40118 INT INTEGER 0 0 2 VATCodeInvFee VAT Code Invoice Fee      
OR40119 NUMERIC X_NUMERIC 18 8 10 InvCurrExchRate1 Invoice Currency Exchange Rate      
OR40120 NUMERIC X_NUMERIC 18 8 10 InvCurrExchRate2 Invoice Currency Exchange Rate 2      
OR40121 NCHAR STRING 3 0 3 InvCurrExchAlg Invoice Currency Exchange Algorithm      
OR40122 INT INTEGER 0 0 1 InclInStat Include in Billing Statement      
OR40123 NUMERIC MONEY 28 8 20 AllowAmICU Allowance Amount      
OR40124 NCHAR STRING 2 0 2 AllowTaxRate VAT Code Allowance      
OR40125 NUMERIC MONEY 28 8 20 SurchargeAmICU Surcharge Amount (Order Currency)      
OR40126 NCHAR STRING 2 0 2 SurchargeTaxRate VAT Code Surcharge      
OR40127 NUMERIC MONEY 28 8 20 AdvanceAmount Advance Amount (Order Currency)      
OR40128 NCHAR SWITCH 1 0 1 ExternalControl External Control      
OR40129 INT INTEGER 0 0 1 FLAGOrAcknXML EDI/XML Order Acknowledgement Status 0 — Document not ready for sending

1 — Send document

2 — Document sent
   
OR40130 INT INTEGER 0 0 1 FLAGPickListXML EDI/XML Picking List Status 0 — Document not ready for sending

1 — Send document

2 — Document sent
   
OR40131 INT INTEGER 0 0 1 FLAGDispNoteXML EDI/XML Delivery Note Status 0 — Document not ready for sending

1 — Send document

2 — Document sent
   
OR40132 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
   
OR40133 INT INTEGER 0 0 1 FLAGTranspDocXML EDI/XML Transport Document Status 0 — Document not ready for sending

1 — Send document

2 — Document sent
   
OR40134 INT INTEGER 0 0 1 FLAGExpDocXML EDI/XML Export Document Status 0 — Document not ready for sending

1 — Send document

2 — Document sent
   
OR40135 INT INTEGER 0 0 1 DeliPropFlagXML EDI/XML Delivery Proposal Status 0 — Document not ready for sending

1 — Send document

2 — Document sent
   
OR40136 INT INTEGER 0 0 1 FLAGTaxInvoiceXML EDI/XML Tax Invoice Status 0 — Document not ready for sending

1 — Send document

2 — Document sent
   
OR40137 NCHAR STRING 12 0 12 ProjectNumber Project      
OR40138 NCHAR STRING 25 0 25 SiteCode Site Code      
OR40139 NCHAR STRING 15 0 15 OriginalInvoiceNo Original Invoice Number      
OR40140 NCHAR STRING 10 0 10 OriginalOrderNo Original Order Number      
OR40141 NVARCHAR VSTRING 1 0 1 FlagCreateInvoice Create Invoice      
OR40142 NCHAR STRING 10 0 10 PriReschedule Order Priority Rescheduling ATP      
OR40143 NCHAR SWITCH 1 0 1 AccLineSplit Accept Order Line Split ATP      
OR40144 NCHAR SWITCH 1 0 1 AccOrderSplit Accept Order Split ATP      
OR40145 DATETIME DATE 0 0 8 QuoteDate Quote Date      
OR40146 INT INTEGER 0 0 1 DetainOrdDisc Detain Order Discount      
OR40147 NVARCHAR VSTRING 20 0 20 DelCustPONo Delivery Customer Purchase Order Number      
OR40148 INT INTEGER 0 0 9 DiscountSchemeCode Discount Schema Code      
OR40149 NCHAR STRING 10 0 10 RequestNo Customer Request      
OR40150 NUMERIC X_NUMERIC 14 8 6 MarkUp Mark-up %      
OR40151 DATETIME DATE 0 0 8 OrderPricingDate Order Pricing Date      
OR40152 INT INTEGER 0 0 1 Priority Order Priority      
OR40153 INT INTEGER 0 0 1 PriorityWeighted Weighted Priority      
OR40154 NCHAR STRING 10 0 10 ContractNumber Contract Number      
OR40155 NCHAR STRING 4 0 4 VersionNumber Version Number   2 Да / Yes
OR40156 NVARCHAR VSTRING 4 0 4 CancellationCode Cancellation Code      
OR40157 NCHAR STRING 6 0 6 TaxLiability Tax Liability Code      
OR40158 NCHAR STRING 6 0 6 TaxCodeFreight Tax Code for Freight      
OR40159 NCHAR STRING 6 0 6 TaxCodeInsurance Tax Code for Insurance      
OR40160 NCHAR STRING 6 0 6 TaxCodePacking Tax Code for Packing      
OR40161 NCHAR STRING 6 0 6 TaxCodeInvFee Tax Code for Invoicing Fee      
OR40162 NCHAR STRING 6 0 6 TaxCodeDistribution Tax Code for Distribution      
OR40163 NCHAR STRING 6 0 6 TaxCodeAllowance Tax Code for Allowance      
OR40164 NCHAR STRING 6 0 6 TaxCodeSurcharge Tax Code for Surcharge      
OR40165 NVARCHAR VSTRING 10 0 10 CFOPCode CFOP Code      
OR40166 NVARCHAR VSTRING 10 0 10 OperationType Operation Code      
OR40167 NVARCHAR VSTRING 10 0 10 FOPFiscTxtCode Fiscal Text Code      
OR40168 NCHAR STRING 6 0 6 InvoiceIssuer Invoice Issuer Code      
OR40169 NCHAR SWITCH 1 0 1 InvCategory Invoice Category [A;B;C;E;Z]      
OR40170 NCHAR SWITCH 1 0 1 InvType Invoice Type [0;1;2]      
OR40171 NCHAR SWITCH 1 0 1 ConsolidatedDSDelivery Consolidated DS Delivery      
OR40172 NCHAR SWITCH 1 0 1 ConsolidatedCWHDelivery Consolidated cwh Delivery      
OR40173 NVARCHAR VSTRING 10 0 10 FinOperationCode2 Financial Operation Code 2      
OR40174 NCHAR STRING 10 0 10 DSSupplier Drop Shipment Supplier      
OR40175 NCHAR SWITCH 1 0 1 Instalment Instalment      
OR40176 NVARCHAR VSTRING 6 0 6 Interest Interest      
OR40177 NUMERIC MONEY 28 8 20 FinCharge FinCharge      
OR40178 NCHAR STRING 6 0 6 TaxCodeInterest TaxCodeInterest      
OR40179 NCHAR STRING 6 0 6 TaxCodeFinCharge TaxCodeFinCharge      
OR40180 DATETIME DATE 0 0 8 ActivateNewInterest ActivateNewInterest      
OR40181 NVARCHAR VSTRING 6 0 6 NewInterestPercent NewInterest%      
OR40182 INT INTEGER 0 0 1 SalesReturnReasonCode Sales Return Reason Code      
OR40183 NCHAR NUMERICSTRING 10 0 10 RMAReference RMA Reference      
OR40184 NVARCHAR VSTRING 50 0 50 ReturnComment Return Comment      
OR40185 NVARCHAR VSTRING 15 0 15 KindOfBox Kind of Box      
OR40186 NVARCHAR VSTRING 15 0 15 BoxNumbering Box numbering      
OR40187 NVARCHAR VSTRING 15 0 15 NumberOfPallets Number of pallets      
OR40188 NVARCHAR VSTRING 10 0 10 TransportCompanyCode Transport Company Code      
OR40189 NVARCHAR VSTRING 10 0 10 VehicleState Vehicle State/Province      
OR40190 NVARCHAR VSTRING 15 0 15 VehicleLicensePlate Vehicle License Plate      
OR40191 NCHAR SWITCH 1 0 1 FreightPayer Freight Payer      
OR40192 NCHAR STRING 6 0 6 OwnFreightTaxCode Own Freight Tax Code      
OR40193 NVARCHAR VSTRING 2 0 2 OrigTermsPayment Orig Terms Payment      
OR40194 NCHAR STRING 10 0 10 SalesContractNo Contract Number      
OR40195 DATETIME DATE 0 0 8 ShipmentDateActual Shipment Date Actual      
OR40196 DATETIME DATE 0 0 8 DeliveryDateEstimated Delivery Date Estimated      
OR40197 DATETIME DATE 0 0 8 TitlePassDate Title Pass Date      
OR40198 NCHAR SWITCH 1 0 1 DelNoteSort Delivery Note, sort      
OR40199 NVARCHAR VSTRING 1 0 1 AutoprintDN Auto print DN      
OR40200 NVARCHAR VSTRING 1 0 1 AutosendDN Auto send DN      
OR40201 INT INTEGER 0 0 1 ReleaseForWithdrawal Release for withdrawal      
OR40202 INT INTEGER 0 0 1 DelNotePrinting Delivery note printing      
OR40203 INT INTEGER 0 0 1 InvPrinting Invoice printing      
OR40204 NCHAR STRING 1 0 1 CreateBackOrder Create back-order      
OR40205 NCHAR STRING 10 0 10 OrderPricingNumber Order Pricing Number      
OR40206 NVARCHAR VSTRING 1 0 1 AutoPrintInvoice Auto print Invoice      
OR40207 NVARCHAR VSTRING 1 0 1 AutoSendInvoice Auto send Invoice      
OR40208 NVARCHAR VSTRING 2 0 2 District District      
OR40209 NVARCHAR VSTRING 2 0 2 AdvertisingCode Advertising Code      
OR40210 NVARCHAR VSTRING 4 0 4 CityCode City Code      
OR40211 NVARCHAR VSTRING 5 0 5 SNICode SNI Code      
OR40212 NVARCHAR VSTRING 1 0 1 CommissionDistrMethod Commision Distribution Method      
OR40213 INT INTEGER 0 0 3 ReasonCode Reason Code      
OR40214 NVARCHAR VSTRING 2 0 2 WayOfPayment Way of payments      
OR40215 NVARCHAR VSTRING 10 0 10 BankCode Bank Code      
OR40216 NVARCHAR VSTRING 2 0 2 PaymentAddressCode Payment Address Code      
OR40217 DATETIME DATE 0 0 8 AcceptedDeliveryDate Accepted Delivery Date      
OR40218 NVARCHAR VSTRING 20 0 20 PlannedDeliveryTime Planned Delivery Time      
OR40219 NVARCHAR VSTRING 20 0 20 AcceptedDeliveryTime Accepted Delivery Time      
OR40220 NCHAR NUMERICSTRING 10 0 10 SalesReturnOrderNo Sales Return Order No      
OR40221 NCHAR STRING 15 0 15 SalesReturnInvoiceNo Sales Return Invoice No      
OR40222 NVARCHAR VSTRING 200 0 200 EmailAddress Email address      
OR40223 DATETIME X_DATETIME 0 0 17 InvoiceTime Invoice Time      
OR40224 NVARCHAR VSTRING 1 0 1 PartialDeliveryPlanning Partial Delivery Planning 0 ? allowed

1 ? prohibited
   
OR40225 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.
   
OR40226 NCHAR SWITCH 1 0 1 CustomerForPrice Customer for price      
OR40227 NUMERIC MONEY 28 8 20 PackageTaxAmntPerKg Packaging Tax Amount per kg      
OR40228 NCHAR SWITCH 1 0 1 CreditCheckPassed Credit check passed      
OR40229 NVARCHAR VSTRING 10 0 10 CodeANTT Code ANTT      
OR40230 NCHAR STRING 1 0 1 FreightTaxMode Freight Tax Mode      
OR40231 NVARCHAR VSTRING 50 0 50 FiscalReference Fiscal Reference      
OR40232 NVARCHAR VSTRING 12 0 12 SpesometroForms Spesometro Forms      
OR40233 NCHAR STRING 1 0 1 TaxPoint TaxPoint      
OR40234 NVARCHAR VSTRING 20 0 20 PublicProcuremCode1 Public Procurement Code1      
OR40235 NVARCHAR VSTRING 20 0 20 PublicProcuremCode2 Public Procurement Code2      
OR40236 NCHAR STRING 1 0 1 FixExchRateFlag Fixed Exchange Rate Flag      
OR40237 NUMERIC X_NUMERIC 18 8 10 OCUExchangeRate1 OCU Exchange Rate 1      
OR40238 NCHAR STRING 3 0 3 OCUExchAlgorithm OCU Exchange Algorithm      
OR40239 NUMERIC X_NUMERIC 18 8 10 OCUExchangeRate2 OCU Exchange Rate 2      
OR40240 NCHAR STRING 2 0 2 OwnBankCode1 Own Bank Code 1      
OR40241 NCHAR STRING 2 0 2 OwnBankCode2 Own Bank Code 2      
OR40242 NVARCHAR VSTRING 34 0 34 BankAccount1 Bank Account 1      
OR40243 NVARCHAR VSTRING 10 0 10 BankCode2 Bank Code 2      
OR40244 NVARCHAR VSTRING 34 0 34 BankAccount2 Bank Account 2      
OR40245 DATETIME DATE 0 0 8 TaxRegDate Tax Registration Date      

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