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
2 ORT1 ORT1001 OrderLineNo VSTRING 15 15 0 Order Line Number
3 ORT1 ORT1002 CustomerCode VSTRING 10 10 0 Customer Code
4 ORT1 ORT1003 TransactType VSTRING 1 1 0 Transaction Type
7 ORT1 ORT1004 TaxCodeRateCode VSTRING 2 2 0 TaxCode/RateCode
8 ORT1 ORT1005 TransactDate DATE 8 0 0 Transaction Date
ORT1 ORT1006 InvoiceDate DATE 8 0 0 Invoice Date
ORT1 ORT1007 BaseAmount MONEY 20 28 8 Base Amount
ORT1 ORT1008 TaxAmount MONEY 20 28 8 Tax Amount
5 ORT1 ORT1009 Remark VSTRING 4 4 0 Remark
9 ORT1 ORT1010 TransactionNo VSTRING 9 9 0 Transaction Number
ORT1 ORT1011 CashMethod VSTRING 1 1 0 Cash Method
ORT1 ORT1012 InvoiceNoOld VSTRING 60 60 0 Invoice Number Old (Italian Cash Method) Also is used to store invoice line ID
ORT1 ORT1013 InvoiceDateOld DATE 8 0 0 Invoice Date Old (Italian Cash Method)
ORT1 ORT1014 IntVersOfFile VSTRING 1 1 0 Internal Table Version
ORT1 ORT1015 ExpandedMacro VSTRING 1 1 0 Expanded Macro
ORT1 ORT1016 Reported VSTRING 1 1 0 Reported
ORT1 ORT1017 TransNature VSTRING 1 1 0 Transaction Nature
ORT1 ORT1018 SalesTaxPercent VSTRING 8 8 0 Sales Tax Percent
ORT1 ORT1019 TaxCode STRING 6 6 0 Tax Code
6 ORT1 ORT1020 TaxType STRING 6 6 0 Tax Type
10 ORT1 ORT1021 TransactLineNo STRING 7 7 0 Transaction Line Number
ORT1 ORT1022 TaxLiability STRING 6 6 0 Tax Liability Code
ORT1 ORT1023 TaxClassifCode STRING 2 2 0 Tax Classification Code
ORT1 ORT1024 TaxCertificate STRING 15 15 0 Tax Certificate
ORT1 ORT1025 PaymentNumber STRING 2 2 0 Payment Number
ORT1 ORT1026 StockItem VSTRING 35 35 0 Stock Item Code
ORT1 ORT1027 OrigBatchNumber VSTRING 12 12 0 Original Batch Number
ORT1 ORT1028 TaxCalculMethod INTEGER 2 0 0 Tax Calculation Method
ORT1 ORT1029 RateType STRING 1 1 0 Rate Type
ORT1 ORT1030 TaxBase INTEGER 2 0 0 Tax Base Type
ORT1 ORT1031 TaxExemption STRING 2 2 0 Tax Exemption Type
ORT1 ORT1032 TaxExemptionRate X_NUMERIC 12 20 8 Tax Exemption Rate
ORT1 ORT1033 TaxRate X_NUMERIC 8 16 8 Tax Rate
ORT1 ORT1034 TributarySitCode VSTRING 10 10 0 Tributary Situation Code
ORT1 ORT1035 CVFCode VSTRING 10 10 0 CVF Code
1 ORT1 ORT1036 SalesOrderNo VSTRING 10 10 0 Sales Order Number
ORT1 ORT1037 FiscTextCode VSTRING 10 10 0 Fiscal Text Code
ORT1 ORT1038 STBase MONEY 20 28 8 Tributary Substitution Amount (Local Currency)
ORT1 ORT1039 STAmount MONEY 20 28 8 Tributary Substitution Amount (Local Currency)
ORT1 ORT1040 TaxCategory VSTRING 10 10 0 Tax Category
ORT1 ORT1041 OriginalCompany VSTRING 2 2 0 Original Company
ORT1 ORT1042 MarginPercent X_NUMERIC 12 20 8 Margin Percent
ORT1 ORT1043 FixedPrice MONEY 20 28 8 Fixed Price (Local Currency)
ORT1 ORT1044 AcceptedDifference X_NUMERIC 12 20 8 Accepted Difference
ORT1 ORT1045 ResolutionName VSTRING 40 40 0 Resolution Name
ORT1 ORT1046 ResolutionDate DATE 8 0 0 Resolution Date
ORT1 ORT1047 InvoiceRefer VSTRING 25 25 0 InvoiceRefer
ORT1 ORT1048 OrigCurrCode VSTRING 2 2 0 Original Currency Code This field should contain the invoice currency code.
ORT1 ORT1049 BaseAmountOCU MONEY 20 28 8 Base Amount (Original Currency) This field should contain the base amount in original currency.
ORT1 ORT1050 VATType VSTRING 6 6 0 VAT Type This field should contain the VAT type.
ORT1 ORT1051 AccountingInfo ACCSTR 120 120 0 Accounting Info
ORT1 ORT1052 LineRefSL04 VSTRING 7 7 0 Line Ref SL04
ORT1 ORT1053 FinYear VSTRING 4 4 0 Financial Year
ORT1 ORT1054 RefGL06 VSTRING 9 9 0 Ref GL06
ORT1 ORT1055 DirectfromGL VSTRING 1 1 0 Direct from GL
ORT1 ORT1056 SurchTaxCode VSTRING 6 6 0 Surcharge Tax Code This field should contain the surcharge tax code linked to usual VAT
ORT1 ORT1057 AASCode VSTRING 25 25 0 AAS code
ORT1 ORT1058 OrderLineNum STRING 12 12 0 Order Line Number Order Line Number
ORT1 ORT1059 ReferPLInvoice VSTRING 25 25 0 Reference to PL Invoice
ORT1 ORT1060 ReferPLSupplier VSTRING 10 10 0 ReferPLSupplier ReferPLSupplier for Italy VAT self-invoices
ORT1 ORT1061 ActualTaxBase MONEY 20 28 8 Actual Tax Base
ORT1 ORT1062 FreightTaxAmount MONEY 20 28 8 Freight Tax Amount
ORT1 ORT1063 DestinationRate X_NUMERIC 8 16 8 Destination Rate
ORT1 ORT1064 TaxDescription VSTRING 30 30 0 Tax Description
ORT1 ORT1065 InvoiceLineNo VSTRING 6 6 0 Invoice Line No
ORT1 ORT1066 TaxAmountOCU MONEY 20 28 8 Tax Amount OCU
ORT1 ORT1067 HMRCPeriodKey VSTRING 4 4 0 HMRC Period Key Key of HMRC period to which this transaction line is included.
ORT1 ORT1068 TaxRegCountry STRING 3 3 0 Tax Registration Country
ORT1 ORT1069 Specification STRING 3 3 0 Specification
ORT1 ORT1070 Notification STRING 3 3 0 Notification