Apicosoft

ERP iScala Database Structure
iScala Supprort & Customization

Business processes implementation, ad-hock services, end-users training and education, maintenance support.

Read More Contact Us
Epicor Service Connect

Integration with any third-party services. Customize internal workflows.

Read More Contact Us
Reporting

SAP Crystal Reports, SQL Server Reporting Services, Excel.

Read More Contact Us
Tables
Name Description Dependences Example
OR01 Sales Order Head Company OR010100
OR03 Sales Order Lines Company OR030100
OR04 Sales Order Delivery Addresses Company OR040100
OR05 Order Parameters Company OR050100
OR06 Document Text File Company OR060100
OR07 Phrase File Company OR070100
OR09 Export Document Parameters Company OR090100
OR10 Transport Document Parameters Company OR100100
OR11 Transport Documents Company OR110100
OR12 Order History (Compressed) Company OR120100
OR13 External Programs Company OR130100
OR14 Order Status Company OR140100
OR16 ECC doc.printout OR160000
OR17 Order Text Lines Company OR170100
OR18 Order History Text (Compressed) Company OR180100
OR19 Order Delivery Lines Company OR190100
OR20 Sales Order Head History Company OR200100
OR21 Sales Order Lines History Company OR210100
OR22 Sales Order Delivery Addresses History Company OR220100
OR23 Order Delivery Lines History Company OR230100
OR24 Order Text Lines History Company OR240100
OR25 Order Line Amount History Company OR250100
OR26 Order Total Amounts History Company OR260100
OR27 Discount Groups Company OR270100
OR29 Order Lines Lead Time Details History Company OR290100
OR2A Discount Group Descriptions Company OR2A0100
OR2E History Transport Documents Company OR2E0100
OR33 Sales Order Discount Lines Company OR330100
OR34 Sales Order Discount Lines History Company OR340100
OR3L Order Lines Lead Time Details Company OR3L0100
OR40 Sales Order Header Historical Versions Company OR400100
OR41 Sales Order Lines Historical Versions Company OR410100
OR42 Sales Order Text Line Historical Versions Company OR420100
OR43 Sales Order Delivery Address Historical Version Company OR430100
OR44 Sales Order Discount Lines Historical Version Company OR440100
OR45 Order Lines Lead Time Details Historical Versions Company OR450100
OR50 Company OR500100
OR51 Company OR510100
OR52 Company OR520100
OR91 Export Invoice Company OR910100
OR92 Freight Document (Finnish) Company OR920100
ORB1 Sales Order BOM Node Company ORB10100
ORB2 Sales Order BOM Name Company ORB20100
ORB3 Sales Order BOM Link Company ORB30100
ORB4 Sales Order BOM Branch Company ORB40100
ORD0 Drop Shipment, Template Company ORD00100
ORD2 Drop Shipment Lines Company ORD20100
ORD3 Drop Shipment History Company ORD30100
ORDW Wrk Documents ORDW0000
ORH1 Sales Order BOM Node History Company ORH10100
ORH2 Sales Order BOM Node Name History Company ORH20100
ORH3 Sales Order BOM Link History Company ORH30100
ORH4 Sales Order BOM Branch History Company ORH40100
ORI2 Instalments Company ORI20100
ORI4 Instalments History Company ORI40100
ORMT Business Transaction Type Sales Order Mapping Company ORMT0100
ORN1 Order Notes Company ORN10100
ORN2 Order Notes history Company ORN20100
ORN3 Company ORN30100
ORR1 Original Order Link Company ORR10100
ORR2 History Original Order Link Company ORR20100
ORT1 Sales Order Tax Transactions Company ORT10100
ORTF Order Template foreign description Company ORTF0100
ORTH Order Template header Company ORTH0100
ORTL Order Template columns Company ORTL0100
ORV1 Sale Order BOM Node Version History Company ORV10100
ORV2 Sales Order BOM Node Name Version History Company ORV20100
ORV3 Sales Order BOM Node Link Version History Company ORV30100
ORV4 Sales Order BOM Node Branch Version History Company ORV40100
ORWA Order Work A ORWA0000
ORWK Order Work K ORWK0000
ORXM Order Merge wrk Company ORXM0100
ORXX External Upd.Wr ORXX0000
ORXY Closing Ord.Wrk ORXY0000
sca_trg_Audit_OR01 Audit trigger for OR01 table Company sca_trg_Audit_OR010100
sca_trg_Audit_OR03 Audit trigger for OR03 table Company sca_trg_Audit_OR030100
sca_trg_Audit_OR04 Audit trigger for OR04 table Company sca_trg_Audit_OR040100
sca_trg_Audit_OR33 Audit trigger for OR33 table Company sca_trg_Audit_OR330100
SLIN Invoice Based Intrastat SL Company SLIN0100

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