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 OR40 OR40001 OrderNumber NUMERICSTRING 10 10 0 Order Number
OR40 OR40002 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
OR40 OR40003 CustCodeInv STRING 10 10 0 Customer Code Invoice
OR40 OR40004 CustCodeDel STRING 10 10 0 Customer Code Delivery
OR40 OR40005 Remark1 VSTRING 35 35 0 Remark Line 1
OR40 OR40006 Remark2 VSTRING 35 35 0 Remark Line 2
OR40 OR40007 FLAGOrAckn INTEGER 1 0 0 Order Confirmation Status 0 - Document not ready for printing
1 - Print document
2 - Document sent
OR40 OR40008 FLAGPickList INTEGER 1 0 0 Picking List Status 0 - Document not ready for printing
1 - Print document
2 - Document sent
OR40 OR40009 FLAGDispNote INTEGER 1 0 0 Delivery Note Status 0 - Document not ready for printing
1 - Print document
2 - Document sent
OR40 OR40010 FLAGInvoice 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
OR40 OR40011 FLAGProcStru INTEGER 1 0 0 Structure Order Processed
OR40 OR40012 TermsPayment INTEGER 2 0 0 Payment Terms
OR40 OR40013 TermsofDel INTEGER 2 0 0 Delivery Terms
OR40 OR40014 WayofDel INTEGER 2 0 0 Delivery Method
OR40 OR40015 OrderDate DATE 8 0 0 Order Date
OR40 OR40016 DelDate DATE 8 0 0 Delivery Date
OR40 OR40017 OurReferen VSTRING 35 35 0 Our Reference
OR40 OR40018 YourReferen VSTRING 35 35 0 Your Reference
OR40 OR40019 SalesmanNo VSTRING 3 3 0 Salesman
OR40 OR40020 OrdDiscount VSTRING 6 6 0 Order Discount %
OR40 OR40021 InvoiceNo STRING 15 15 0 Invoice Number
OR40 OR40022 InvoiceQuot 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
OR40 OR40023 DispatNoteNo VSTRING 20 20 0 Delivery Note Number
OR40 OR40024 OrderValue MONEY 20 28 8 Order Value (Order Currency)
OR40 OR40025 AccCodString ACCSTR 120 120 0 Accounting String
OR40 OR40026 ORMergeOption INTEGER 1 0 0 Order Merge Option 0 - Not to be merged/consolidate
1 - Merge/Consolidate per week
2 - Merge/Consolidate per month
OR40 OR40027 LanguageCode VSTRING 3 3 0 Language
OR40 OR40028 CurrCode INTEGER 2 0 0 Currency Code
OR40 OR40029 FLAGExportOR INTEGER 1 0 0 Export Order
OR40 OR40030 FLAGExpDoc INTEGER 1 0 0 Export Document Status 0 - Document not ready for printing
1 - Print document
2 - Document sent
OR40 OR40031 FLAGTransDoc INTEGER 1 0 0 Transport Document Status 0 - Document not ready for printing
1 - Print document
2 - Document sent
OR40 OR40032 FLAGCurrComp INTEGER 1 0 0 Currency Compensation
OR40 OR40033 CompCurrNo INTEGER 2 0 0 Currency Code Compensation
OR40 OR40034 LimitCompens X_NUMERIC 6 14 8 Limit For Compensation %
OR40 OR40035 Compensation X_NUMERIC 6 14 8 Compensation %
OR40 OR40036 ORDateExRat MONEY 20 28 8 Order Date Exchange Rate
OR40 OR40037 DelDateExRat X_NUMERIC 20 28 8 Delivery Date Exchange Rate
OR40 OR40038 OrRepInterva 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)
OR40 OR40039 RepOrStartD DATE 8 0 0 Repeat Order Start Date
OR40 OR40040 RepOrStopDa DATE 8 0 0 Repeat Order End Date
OR40 OR40041 RepOrAccInv MONEY 20 28 8 Repeat Order Accumulated Invoiced Amount (Order Currency)
OR40 OR40042 RepOrdAccum MONEY 20 28 8 Repeat Order Accumulated Costs (Local Currency)
OR40 OR40043 HandlingFee MONEY 20 28 8 Handling Fee (Order Currency)
OR40 OR40044 FreightAmoun MONEY 20 28 8 Freight Amount (Order Currency)
OR40 OR40045 CustCodeOrd VSTRING 10 10 0 Customer Code Order
OR40 OR40046 Packing MONEY 20 28 8 Packing Amount (Order Currency)
OR40 OR40047 FLAGDeliProp INTEGER 1 0 0 Delivery Proposal Status 0 - Document not ready for printing
1 - Print document
2 - Document sent
OR40 OR40048 Insurance MONEY 20 28 8 Insurance Amount (Order Currency)
OR40 OR40049 StornoInvSw VSTRING 1 1 0 Storno Invoice
OR40 OR40050 WareHouse VSTRING 6 6 0 Warehouse
OR40 OR40051 PriceList VSTRING 2 2 0 Price List
OR40 OR40052 FLAGUpdatInt SWITCH 1 1 0 Update Intrastat
OR40 OR40053 PtOfTitlPass VSTRING 1 1 0 Point of Title
OR40 OR40054 PricTypOnRep 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
OR40 OR40055 FLAGTaxInvoice VSTRING 1 1 0 Tax Invoice Status 0 - Document not ready for printing
1 - Print document
2 - Document sent
OR40 OR40056 ShipmentMark VSTRING 35 35 0 Shipment Mark
OR40 OR40057 NetWeight X_NUMERIC 10 18 8 Net Weight
OR40 OR40058 GrossWeight X_NUMERIC 10 18 8 Gross Weight
OR40 OR40059 Volume X_NUMERIC 10 18 8 Volume
OR40 OR40060 NoOfUnits X_NUMERIC 10 18 8 No of Units
OR40 OR40061 ExternComm1 X_NUMERIC 6 14 8 External Commission %
OR40 OR40062 ExternComm2 VSTRING 10 10 0 External Commission Code
OR40 OR40063 OwnFreight MONEY 20 28 8 Own Freight Amount (Order Currency)
OR40 OR40064 ExternalCommissionAmount MONEY 20 28 8 External Commission Amount
OR40 OR40065 DocuLayout INTEGER 1 0 0 Document Layout
OR40 OR40066 CurrContract SWITCH 1 1 0 Currency Contract
OR40 OR40067 FixedExchRat X_NUMERIC 20 28 8 Fixed Exchange Rate
OR40 OR40068 ContractNo VSTRING 15 15 0 Currency Contract Number
OR40 OR40069 CampaignCode VSTRING 8 8 0 Campaign
OR40 OR40070 ExtDelNoteNo VSTRING 20 20 0 Extended Delivery Note Number
OR40 OR40071 InvRoundMod INTEGER 1 0 0 Invoice Rounding Model
OR40 OR40072 CustPONo VSTRING 30 30 0 Customer Purchase Order Number
OR40 OR40073 LetterOfCred SWITCH 1 1 0 Letter of Credit
OR40 OR40074 LetterCredOp DATE 8 0 0 Letter of Credit Open Date
OR40 OR40075 LetterCredDu DATE 8 0 0 Letter of Credit Due Date
OR40 OR40076 LetteCredRef VSTRING 20 20 0 Letter of Credit Reference
OR40 OR40077 BookEntrDate DATE 8 0 0 Book-Entry Date
OR40 OR40078 CommWarehNo VSTRING 6 6 0 Common Warehouse
OR40 OR40079 PartialDelCd SWITCH 1 1 0 Allow Partial Delivery
OR40 OR40080 EDITrmittCou INTEGER 2 0 0 EDI Transmit Count
OR40 OR40081 EDIReceivCou INTEGER 2 0 0 EDI Receive Count
OR40 OR40082 EDIFlag1 VSTRING 1 1 0 EDI Flag 1 Currently not used for any specific functionality
OR40 OR40083 EDIFlag2 VSTRING 1 1 0 EDI Flag 2 Currently not used for any specific functionality
OR40 OR40084 EDIFlag3 VSTRING 1 1 0 EDI Flag 3 Currently not used for any specific functionality
OR40 OR40085 EDIFlag4 VSTRING 1 1 0 EDI Flag 4 Currently not used for any specific functionality
OR40 OR40086 SalesmanNo2 VSTRING 3 3 0 Salesman 2
OR40 OR40087 SalesmanNo3 VSTRING 3 3 0 Salesman 3
OR40 OR40088 Spare 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
OR40 OR40089 SalesTaxRema VSTRING 4 4 0 Sales Tax Remark
OR40 OR40090 Forwarder VSTRING 4 4 0 Forwarder
OR40 OR40091 OrderStatus INTEGER 1 0 0 Order Status
OR40 OR40092 VATCodeFreig INTEGER 2 0 0 VAT Code Freight
OR40 OR40093 VATCodePack INTEGER 2 0 0 VAT Code Packing
OR40 OR40094 VATCodeInsur INTEGER 2 0 0 VAT Code Insurance
OR40 OR40095 OvrideSlTaxC VSTRING 2 2 0 VAT Code Override
OR40 OR40096 UserIDEntry VSTRING 8 8 0 Entered By
OR40 OR40097 DueDate DATE 8 0 0 Due Date
OR40 OR40098 SuborContrNo VSTRING 10 10 0 Sub-Order Contract Number
OR40 OR40099 SuborderNo VSTRING 10 10 0 Sub-Order Number
OR40 OR40100 OrCreatModul INTEGER 1 0 0 Order created from module 5 or 7: Linked to project activity line
OR40 OR40101 OrigModLinID VSTRING 30 30 0 Original Module Line ID
OR40 OR40102 OrigModStatu INTEGER 1 0 0 Original Module Status
OR40 OR40103 Contract VSTRING 27 27 0 Contract
OR40 OR40104 VATFlag STRING 1 1 0 VAT Option
OR40 OR40105 OrdHandler STRING 3 3 0 Number of Printed Invoice Copies
OR40 OR40106 IntereBlock SWITCH 1 1 0 Interest Block
OR40 OR40107 IntrLatePaym VSTRING 6 6 0 Interest Late Payment
OR40 OR40108 INTRDebit ACCSTR 120 120 0 Internal Debiting Accounting String
OR40 OR40109 InvPrefix VSTRING 4 4 0 Invoice Prefix
OR40 OR40110 OrderDateExchgRate1 X_NUMERIC 10 18 8 Order Date Exchange Rate 2
OR40 OR40111 OrderDateExchgAlgtm STRING 3 3 0 Order Date Exchange Algorithm
OR40 OR40112 DlvryDateExchgRate2 X_NUMERIC 10 18 8 Delivery Date Exchange Rate 2
OR40 OR40113 DlvryDateExchgAlgtm STRING 3 3 0 Delivery Date Exchange Algorithm
OR40 OR40114 FixedExchgRate2 X_NUMERIC 10 18 8 Fixed Exchange Rate 2
OR40 OR40115 FixedExchgAlgtm STRING 3 3 0 Fixed Exchange Algorithm
OR40 OR40116 InvoiceCurrCode INTEGER 2 0 0 Currency Code Invoice
OR40 OR40117 EDIContractSwitch SWITCH 1 1 0 EDI-Contract
OR40 OR40118 VATCodeInvFee INTEGER 2 0 0 VAT Code Invoice Fee
OR40 OR40119 InvCurrExchRate1 X_NUMERIC 10 18 8 Invoice Currency Exchange Rate
OR40 OR40120 InvCurrExchRate2 X_NUMERIC 10 18 8 Invoice Currency Exchange Rate 2
OR40 OR40121 InvCurrExchAlg STRING 3 3 0 Invoice Currency Exchange Algorithm
OR40 OR40122 InclInStat INTEGER 1 0 0 Include in Billing Statement
OR40 OR40123 AllowAmICU MONEY 20 28 8 Allowance Amount
OR40 OR40124 AllowTaxRate STRING 2 2 0 VAT Code Allowance
OR40 OR40125 SurchargeAmICU MONEY 20 28 8 Surcharge Amount (Order Currency)
OR40 OR40126 SurchargeTaxRate STRING 2 2 0 VAT Code Surcharge
OR40 OR40127 AdvanceAmount MONEY 20 28 8 Advance Amount (Order Currency)
OR40 OR40128 ExternalControl SWITCH 1 1 0 External Control
OR40 OR40129 FLAGOrAcknXML INTEGER 1 0 0 EDI/XML Order Acknowledgement Status 0 - Document not ready for sending
1 - Send document
2 - Document sent
OR40 OR40130 FLAGPickListXML INTEGER 1 0 0 EDI/XML Picking List Status 0 - Document not ready for sending
1 - Send document
2 - Document sent
OR40 OR40131 FLAGDispNoteXML INTEGER 1 0 0 EDI/XML Delivery Note Status 0 - Document not ready for sending
1 - Send document
2 - Document sent
OR40 OR40132 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
OR40 OR40133 FLAGTranspDocXML INTEGER 1 0 0 EDI/XML Transport Document Status 0 - Document not ready for sending
1 - Send document
2 - Document sent
OR40 OR40134 FLAGExpDocXML INTEGER 1 0 0 EDI/XML Export Document Status 0 - Document not ready for sending
1 - Send document
2 - Document sent
OR40 OR40135 DeliPropFlagXML INTEGER 1 0 0 EDI/XML Delivery Proposal Status 0 - Document not ready for sending
1 - Send document
2 - Document sent
OR40 OR40136 FLAGTaxInvoiceXML INTEGER 1 0 0 EDI/XML Tax Invoice Status 0 - Document not ready for sending
1 - Send document
2 - Document sent
OR40 OR40137 ProjectNumber STRING 12 12 0 Project
OR40 OR40138 SiteCode STRING 25 25 0 Site Code
OR40 OR40139 OriginalInvoiceNo STRING 15 15 0 Original Invoice Number
OR40 OR40140 OriginalOrderNo STRING 10 10 0 Original Order Number
OR40 OR40141 FlagCreateInvoice VSTRING 1 1 0 Create Invoice
OR40 OR40142 PriReschedule STRING 10 10 0 Order Priority Rescheduling ATP
OR40 OR40143 AccLineSplit SWITCH 1 1 0 Accept Order Line Split ATP
OR40 OR40144 AccOrderSplit SWITCH 1 1 0 Accept Order Split ATP
OR40 OR40145 QuoteDate DATE 8 0 0 Quote Date
OR40 OR40146 DetainOrdDisc INTEGER 1 0 0 Detain Order Discount
OR40 OR40147 DelCustPONo VSTRING 20 20 0 Delivery Customer Purchase Order Number
OR40 OR40148 DiscountSchemeCode INTEGER 9 0 0 Discount Schema Code
OR40 OR40149 RequestNo STRING 10 10 0 Customer Request
OR40 OR40150 MarkUp X_NUMERIC 6 14 8 Mark-up %
OR40 OR40151 OrderPricingDate DATE 8 0 0 Order Pricing Date
OR40 OR40152 Priority INTEGER 1 0 0 Order Priority
OR40 OR40153 PriorityWeighted INTEGER 1 0 0 Weighted Priority
OR40 OR40154 ContractNumber STRING 10 10 0 Contract Number
2 OR40 OR40155 VersionNumber STRING 4 4 0 Version Number
OR40 OR40156 CancellationCode VSTRING 4 4 0 Cancellation Code
OR40 OR40157 TaxLiability STRING 6 6 0 Tax Liability Code
OR40 OR40158 TaxCodeFreight STRING 6 6 0 Tax Code for Freight
OR40 OR40159 TaxCodeInsurance STRING 6 6 0 Tax Code for Insurance
OR40 OR40160 TaxCodePacking STRING 6 6 0 Tax Code for Packing
OR40 OR40161 TaxCodeInvFee STRING 6 6 0 Tax Code for Invoicing Fee
OR40 OR40162 TaxCodeDistribution STRING 6 6 0 Tax Code for Distribution
OR40 OR40163 TaxCodeAllowance STRING 6 6 0 Tax Code for Allowance
OR40 OR40164 TaxCodeSurcharge STRING 6 6 0 Tax Code for Surcharge
OR40 OR40165 CFOPCode VSTRING 10 10 0 CFOP Code
OR40 OR40166 OperationType VSTRING 10 10 0 Operation Code
OR40 OR40167 FOPFiscTxtCode VSTRING 10 10 0 Fiscal Text Code
OR40 OR40168 InvoiceIssuer STRING 6 6 0 Invoice Issuer Code
OR40 OR40169 InvCategory SWITCH 1 1 0 Invoice Category [A;B;C;E;Z]
OR40 OR40170 InvType SWITCH 1 1 0 Invoice Type [0;1;2]
OR40 OR40171 ConsolidatedDSDelivery SWITCH 1 1 0 Consolidated DS Delivery
OR40 OR40172 ConsolidatedCWHDelivery SWITCH 1 1 0 Consolidated cwh Delivery
OR40 OR40173 FinOperationCode2 VSTRING 10 10 0 Financial Operation Code 2
OR40 OR40174 DSSupplier STRING 10 10 0 Drop Shipment Supplier
OR40 OR40175 Instalment SWITCH 1 1 0 Instalment
OR40 OR40176 Interest VSTRING 6 6 0 Interest
OR40 OR40177 FinCharge MONEY 20 28 8 FinCharge
OR40 OR40178 TaxCodeInterest STRING 6 6 0 TaxCodeInterest
OR40 OR40179 TaxCodeFinCharge STRING 6 6 0 TaxCodeFinCharge
OR40 OR40180 ActivateNewInterest DATE 8 0 0 ActivateNewInterest
OR40 OR40181 NewInterestPercent VSTRING 6 6 0 NewInterest%
OR40 OR40182 SalesReturnReasonCode INTEGER 1 0 0 Sales Return Reason Code
OR40 OR40183 RMAReference NUMERICSTRING 10 10 0 RMA Reference
OR40 OR40184 ReturnComment VSTRING 50 50 0 Return Comment
OR40 OR40185 KindOfBox VSTRING 15 15 0 Kind of Box
OR40 OR40186 BoxNumbering VSTRING 15 15 0 Box numbering
OR40 OR40187 NumberOfPallets VSTRING 15 15 0 Number of pallets
OR40 OR40188 TransportCompanyCode VSTRING 10 10 0 Transport Company Code
OR40 OR40189 VehicleState VSTRING 10 10 0 Vehicle State/Province
OR40 OR40190 VehicleLicensePlate VSTRING 15 15 0 Vehicle License Plate
OR40 OR40191 FreightPayer SWITCH 1 1 0 Freight Payer
OR40 OR40192 OwnFreightTaxCode STRING 6 6 0 Own Freight Tax Code
OR40 OR40193 OrigTermsPayment VSTRING 2 2 0 Orig Terms Payment
OR40 OR40194 SalesContractNo STRING 10 10 0 Contract Number
OR40 OR40195 ShipmentDateActual DATE 8 0 0 Shipment Date Actual
OR40 OR40196 DeliveryDateEstimated DATE 8 0 0 Delivery Date Estimated
OR40 OR40197 TitlePassDate DATE 8 0 0 Title Pass Date
OR40 OR40198 DelNoteSort SWITCH 1 1 0 Delivery Note, sort
OR40 OR40199 AutoprintDN VSTRING 1 1 0 Auto print DN
OR40 OR40200 AutosendDN VSTRING 1 1 0 Auto send DN
OR40 OR40201 ReleaseForWithdrawal INTEGER 1 0 0 Release for withdrawal
OR40 OR40202 DelNotePrinting INTEGER 1 0 0 Delivery note printing
OR40 OR40203 InvPrinting INTEGER 1 0 0 Invoice printing
OR40 OR40204 CreateBackOrder STRING 1 1 0 Create back-order
OR40 OR40205 OrderPricingNumber STRING 10 10 0 Order Pricing Number
OR40 OR40206 AutoPrintInvoice VSTRING 1 1 0 Auto print Invoice
OR40 OR40207 AutoSendInvoice VSTRING 1 1 0 Auto send Invoice
OR40 OR40208 District VSTRING 2 2 0 District
OR40 OR40209 AdvertisingCode VSTRING 2 2 0 Advertising Code
OR40 OR40210 CityCode VSTRING 4 4 0 City Code
OR40 OR40211 SNICode VSTRING 5 5 0 SNI Code
OR40 OR40212 CommissionDistrMethod VSTRING 1 1 0 Commision Distribution Method
OR40 OR40213 ReasonCode INTEGER 3 0 0 Reason Code
OR40 OR40214 WayOfPayment VSTRING 2 2 0 Way of payments
OR40 OR40215 BankCode VSTRING 10 10 0 Bank Code
OR40 OR40216 PaymentAddressCode VSTRING 2 2 0 Payment Address Code
OR40 OR40217 AcceptedDeliveryDate DATE 8 0 0 Accepted Delivery Date
OR40 OR40218 PlannedDeliveryTime VSTRING 20 20 0 Planned Delivery Time
OR40 OR40219 AcceptedDeliveryTime VSTRING 20 20 0 Accepted Delivery Time
OR40 OR40220 SalesReturnOrderNo NUMERICSTRING 10 10 0 Sales Return Order No
OR40 OR40221 SalesReturnInvoiceNo STRING 15 15 0 Sales Return Invoice No
OR40 OR40222 EmailAddress VSTRING 200 200 0 Email address
OR40 OR40223 InvoiceTime X_DATETIME 17 0 0 Invoice Time
OR40 OR40224 PartialDeliveryPlanning VSTRING 1 1 0 Partial Delivery Planning 0 – allowed
1 – prohibited
OR40 OR40225 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.
OR40 OR40226 CustomerForPrice SWITCH 1 1 0 Customer for price
OR40 OR40227 PackageTaxAmntPerKg MONEY 20 28 8 Packaging Tax Amount per kg
OR40 OR40228 CreditCheckPassed SWITCH 1 1 0 Credit check passed
OR40 OR40229 CodeANTT VSTRING 10 10 0 Code ANTT
OR40 OR40230 FreightTaxMode STRING 1 1 0 Freight Tax Mode
OR40 OR40231 FiscalReference VSTRING 50 50 0 Fiscal Reference
OR40 OR40232 SpesometroForms VSTRING 12 12 0 Spesometro Forms
OR40 OR40233 TaxPoint STRING 1 1 0 TaxPoint
OR40 OR40234 PublicProcuremCode1 VSTRING 20 20 0 Public Procurement Code1
OR40 OR40235 PublicProcuremCode2 VSTRING 20 20 0 Public Procurement Code2
OR40 OR40236 FixExchRateFlag STRING 1 1 0 Fixed Exchange Rate Flag
OR40 OR40237 OCUExchangeRate1 X_NUMERIC 10 18 8 OCU Exchange Rate 1
OR40 OR40238 OCUExchAlgorithm STRING 3 3 0 OCU Exchange Algorithm
OR40 OR40239 OCUExchangeRate2 X_NUMERIC 10 18 8 OCU Exchange Rate 2
OR40 OR40240 OwnBankCode1 STRING 2 2 0 Own Bank Code 1
OR40 OR40241 OwnBankCode2 STRING 2 2 0 Own Bank Code 2
OR40 OR40242 BankAccount1 VSTRING 34 34 0 Bank Account 1
OR40 OR40243 BankCode2 VSTRING 10 10 0 Bank Code 2
OR40 OR40244 BankAccount2 VSTRING 34 34 0 Bank Account 2
OR40 OR40245 TaxRegDate DATE 8 0 0 Tax Registration Date
OR40 OR40246 Contribution MONEY 20 28 8 Contribution to consolidated invoice
OR40 OR40247 TaxRegCountry STRING 3 3 0 Tax Registration Country