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 OR92 OR92001 TransportDocNO STRING 9 9 0 Transport Document Number
OR92 OR92002 CustomerCodeDelivery STRING 10 10 0 Customer Code Delivery
OR92 OR92003 WayOfDelivery STRING 2 2 0 Delivery Method
OR92 OR92004 OrderNO1 STRING 10 10 0 Order Number 1
OR92 OR92005 OrderNO2 STRING 10 10 0 Order Number 2
OR92 OR92006 OrderNO3 STRING 10 10 0 Order Number 3
OR92 OR92007 OrderNO4 STRING 10 10 0 Order Number 4
OR92 OR92008 OrderNO5 STRING 10 10 0 Order Number 5
OR92 OR92009 OrderNO6 STRING 10 10 0 Order Number 6
OR92 OR92010 OrderNO7 STRING 10 10 0 Order Number 7
OR92 OR92011 OrderNO8 STRING 10 10 0 Order Number 8
OR92 OR92012 CustomerName VSTRING 35 35 0 Customer Name
OR92 OR92013 CustomerAddr1 VSTRING 35 35 0 Customer Address Line 1
OR92 OR92014 CustomerAddr2 VSTRING 35 35 0 Customer Address Line 2
OR92 OR92015 CustomerAddr3 VSTRING 35 35 0 Customer Address Line 3
OR92 OR92016 CustomerPhone VSTRING 20 20 0 Customer Telephone Number
OR92 OR92017 DestID1 STRING 3 3 0 Destination ID 1
OR92 OR92018 DestID2 STRING 2 2 0 Destination ID 2
OR92 OR92019 DeliveryDate DATE 8 0 0 Delivery Date
OR92 OR92020 Explain4OtherPayway VSTRING 15 15 0 Explanation for Other Payment Way
OR92 OR92021 TransportInfo1 VSTRING 25 25 0 Transportation Information Line 1
OR92 OR92022 TransportInfo2 VSTRING 25 25 0 Transportation Information Line 2
OR92 OR92023 TransportInfo3 VSTRING 25 25 0 Transportation Information Line 3
OR92 OR92024 WayOfDeliveryText VSTRING 30 30 0 Delivery Method Text
OR92 OR92025 FreightPayer STRING 1 1 0 Freight Payer
OR92 OR92026 LavaOrKontti SWITCH 1 1 0 Lava or Kontti
OR92 OR92027 LavaOrKonttiQTY X_NUMERIC 3 11 8 Lava or Kontti Quantity
OR92 OR92028 Cash2PayInTextForm VSTRING 50 50 0 Cash to Pay In Text
OR92 OR92029 Cah2PayInNumbers MONEY 20 28 8 Cash to Pay In Numbers
OR92 OR92030 BankAccountInfo VSTRING 50 50 0 Bank Account
OR92 OR92031 CustomersContractNO STRING 10 10 0 Customers Contract Number
OR92 OR92032 Mark1 VSTRING 20 20 0 Mark Line 1
OR92 OR92033 NOofItems1 NUMBER 3 20 0 Number of Items 1
OR92 OR92034 PackageType1 STRING 4 4 0 Package Type 1
OR92 OR92035 Content1 VSTRING 25 25 0 Content 1
OR92 OR92036 Code1 INTEGER 6 0 0 Code 1
OR92 OR92037 GrossWeight1 X_NUMERIC 9 17 8 Gross Weight 1
OR92 OR92038 Mark2 VSTRING 20 20 0 Mark Line 2
OR92 OR92039 NOofItems2 NUMBER 3 20 0 Number of Items 2
OR92 OR92040 PackageType2 STRING 4 4 0 Package Type 2
OR92 OR92041 Content2 VSTRING 25 25 0 Content 2
OR92 OR92042 Code2 INTEGER 6 0 0 Code 2
OR92 OR92043 GrossWeight2 X_NUMERIC 9 17 8 Gross Weight 2
OR92 OR92044 Mark3 VSTRING 20 20 0 Mark Line 3
OR92 OR92045 NOofItems3 NUMBER 3 20 0 Number of Items 3
OR92 OR92046 PackageType3 STRING 4 4 0 Package Type 3
OR92 OR92047 Content3 VSTRING 25 25 0 Content 3
OR92 OR92048 Code3 INTEGER 6 0 0 Code 3
OR92 OR92049 GrossWeight3 X_NUMERIC 9 17 8 Gross Weight 3
OR92 OR92050 Mark4 VSTRING 20 20 0 Mark Line 4
OR92 OR92051 NOofItems4 NUMBER 3 20 0 Number of Items 4
OR92 OR92052 PackageType4 STRING 4 4 0 Package Type 4
OR92 OR92053 Content4 VSTRING 25 25 0 Content 4
OR92 OR92054 Code4 INTEGER 6 0 0 Code 4
OR92 OR92055 GrossWeight4 X_NUMERIC 9 17 8 Gross Weight 4
OR92 OR92056 Mark5 VSTRING 20 20 0 Mark Line 5
OR92 OR92057 NOofItems5 NUMBER 3 20 0 Number of Items 5
OR92 OR92058 PackageType5 STRING 4 4 0 Package Type 5
OR92 OR92059 Content5 VSTRING 25 25 0 Content 5
OR92 OR92060 Code5 INTEGER 6 0 0 Code 5
OR92 OR92061 GrossWeight5 X_NUMERIC 9 17 8 Gross Weight 5
OR92 OR92062 Mark6 VSTRING 20 20 0 Mark Line 6
OR92 OR92063 NOofItems6 NUMBER 3 20 0 Number of Items 6
OR92 OR92064 PackageType6 STRING 4 4 0 Package Type 6
OR92 OR92065 Content6 VSTRING 25 25 0 Content 6
OR92 OR92066 Code6 INTEGER 6 0 0 Code 6
OR92 OR92067 GrossWeight6 X_NUMERIC 9 17 8 Gross Weight 6
OR92 OR92068 Mark7 VSTRING 20 20 0 Mark Line 7
OR92 OR92069 NOofItems7 NUMBER 3 20 0 Number of Items 7
OR92 OR92070 PackageType7 STRING 4 4 0 Package Type 7
OR92 OR92071 Content7 VSTRING 25 25 0 Content 7
OR92 OR92072 Code7 INTEGER 6 0 0 Code 7
OR92 OR92073 GrossWeight7 X_NUMERIC 9 17 8 Gross Weight 7
OR92 OR92074 Mark8 VSTRING 20 20 0 Mark Line 8
OR92 OR92075 NOofItems8 NUMBER 3 20 0 Number of Items 8
OR92 OR92076 PackageType8 STRING 4 4 0 Package Type 8
OR92 OR92077 Content8 VSTRING 25 25 0 Content 8
OR92 OR92078 Code8 INTEGER 6 0 0 Code 8
OR92 OR92079 GrossWeight8 X_NUMERIC 9 17 8 Gross Weight 8
OR92 OR92080 TotalLavaQTY4Par1 X_NUMERIC 5 13 8 Total Lava Quantity
OR92 OR92081 TotalGrossWeight X_NUMERIC 10 18 8 Total Gross Weight
OR92 OR92082 RouteNO STRING 10 10 0 Route Number
OR92 OR92083 OtherContract STRING 10 10 0 Other Contract
OR92 OR92084 OurCustomerNO STRING 10 10 0 Our Customer Number
OR92 OR92085 OurContractNO STRING 10 10 0 Our Contract Number
OR92 OR92086 TermsOfDelivery STRING 2 2 0 Delivery Terms
OR92 OR92087 TermsOfDeliveryText VSTRING 30 30 0 Delivery Terms Text
OR92 OR92088 OrderNO9 STRING 10 10 0 Order Number 9
OR92 OR92089 OrderNO10 STRING 10 10 0 Order Number 10
OR92 OR92090 OrderNO11 STRING 10 10 0 Order Number 11
OR92 OR92091 OrderNO12 STRING 10 10 0 Order Number 12
OR92 OR92092 OrderNO13 STRING 10 10 0 Order Number 13
OR92 OR92093 OrderNO14 STRING 10 10 0 Order Number 14
OR92 OR92094 OrderNO15 STRING 10 10 0 Order Number 15
OR92 OR92095 Volume VSTRING 10 10 0 Volume
OR92 OR92096 spare VSTRING 35 35 0 Packed Information
OR92 OR92097 TransportForm NUMBER 2 20 0 Transport Form
OR92 OR92098 CurrCode VSTRING 2 2 0 Currency Code
OR92 OR92099 AddService1 NUMBER 1 20 0 Additional Service 1
OR92 OR92100 AddService2 NUMBER 1 20 0 Additional Service 2
OR92 OR92101 AddService3 NUMBER 1 20 0 Additional Service 3
OR92 OR92102 AddService4 NUMBER 1 20 0 Additional Service 4
OR92 OR92103 ShipmentCode NUMBER 11 20 0 Shipment Code
OR92 OR92104 SpecialTreatment NUMBER 1 20 0 Special Treatment
OR92 OR92105 TransportUnit NUMBER 1 20 0 Transport Unit
OR92 OR92106 DocumentCode NUMBER 1 20 0 Document Code
OR92 OR92107 PrintoutFlag NUMBER 1 20 0 Printout Flag
OR92 OR92108 OrderFromModule NUMBER 1 20 0 Order From Module