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
GL00 Ordered Reports File Company GL000100
GL03 Accounting Dimensions Company Year GL030112
GL06 General Ledger Transactions Company Year GL060112
GL07 Daybook Journal Transactions Company Year GL070112
GL08 Opening Balance Journal Transactions Company Year GL080112
GL09 Report Layouts Company GL090100
GL10 General Ledger Parameters Company Year GL100112
GL11 Automatic Allocations Company GL110100
GL12 Chart of Account Headings Company Year GL120112
GL14 Simulation Transactions Company Year GL140112
GL15 Transaction Workfile C Company GL150100
GL16 General Ledger Parameters 2 Company Year GL160112
GL18 Phrase File Company GL180100
GL19 Transaction Workfile D Company GL190100
GL1A GL Budget Profiles Company Year GL1A0112
GL21 Project History Transactions Company GL210100
GL22 Transaction Workfile A Company GL220100
GL23 Report Generator Company GL230100
GL24 Report Notes Company GL240100
GL25 Report Interactive Notes Company GL250100
GL26 Cash Flow Planned Transaction Setup Company GL260100
GL27 Cash Flow Accounts Company GL270100
GL28 Parameter File Interest Charge Project Company GL280100
GL29 Account Number Alias Company GL290100
GL30 Transaction Workfile B Company GL300100
GL34 WrkDepreciation GL340000
GL40 Consolidated Currencies Company Year GL400112
GL41 Consolidation Account Translations Company Year GL410112
GL42 Cash-Book Reconciliation Accounts Company GL420100
GL43 Cash-Book Reconciliation Transactions Company GL430100
GL44 Workfile Cheques Company GL440100
GL45 Transaction Text Company Year GL450112
GL46 Valid Coding Combinations Company Year GL460112
GL52 General Ledger Balances Company Year GL520112
GL53 Account Schedule Company Year GL530112
GL55 Foreign Descriptions Company Year GL550112
GL56 Commitments Company Year GL560112
GL57 Bank Statement Header Company GL570100
GL58 Bank Statement Transactions Company GL580100
GL59 Reconcilation Proposal Company GL590100
GL5A Multi-Currency Links Company Year GL5A0112
GL5B Multi-Currency General Ledger Balances Company Year GL5B0112
GL5C Bank Definition Company GL5C0100
GL5D Multi-Link Statistical Account Balances Company Year GL5D0112
GL5S SPED parameters Company Year GL5S0112
GL60 Compound Allocations Company GL600100
GL61 Compound Allocation Descriptions Company GL610100
GL62 Compound Allocation Lines Company GL620100
GL65 Compound Allocation Remeasurement Transactions Company GL650100
GL67 Compound Allocation Selection History Company GL670100
GL77 EMU Conversion Set-up Company GL770100
GL80 Un-Authorized Transactions (Greece) Company Year GL800112
GLB2 Operation Details Company GLB20100
GLB3 Receipt Information Company GLB30100
GLBT Converted GL06 transactions Company Year GLBT0112
GLC1 Statement- or Debit/Credit Notification Message Company GLC10100
GLC2 Statement- or Debit/Credit Notification Message Page Company GLC20100
GLC3 Statement- or Debit/Credit Notification Company GLC30100
GLC4 Statement- or Debit/Credit Notification Entry Company GLC40100
GLC5 Statement- or Debit/Credit Notification Entry Detail Company GLC50100
GLC6 Statement- or Debit/Credit Notification Entry Detail Transaction Company GLC60100
GLC7 Statement- or Debit/Credit Notification Entry Detail Transaction Unstructured Remittance Company GLC70100
GLC8 Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance Company GLC80100
GLC9 Charges Company GLC90100
GLCB Petty Cash Master Table Company Year GLCB0112
GLCD Petty Cash Desk Parameters Company Year GLCD0112
GLCE Cash Office Company GLCE0100
GLCF Cash Office Language Dependent Description Company GLCF0100
GLCG Reason Code Company GLCG0100
GLCH Notification processing template header Company GLCH0100
GLCI Reason Code Language Dependent Description Company GLCI0100
GLCL Notification processing template Line Company GLCL0100
GLCW Compound Periodic Allocation Work File GLCW0000
GLCX Petty Cash Extension File Company Year GLCX0112
GLCY Petty Cash Transaction File Company Year GLCY0112
GLEB Extended General Ledger Balance Company Year GLEB0112
GLGL GL Consolidation Company GLGL0100
GLH0 PMS Interface File Structure Definition (Header) Company GLH00100
GLH1 PMS Interface File Structure Definition (Records) Company GLH10100
GLH2 PMS Interface Mapping File Company GLH20100
GLHI FA Transaction History Company GLHI0100
GLII Company fiscal parameters for Italian fiscal reports Company GLII0100
GLR1 Company GLR10100
GLR2 Company GLR20100
GLR6 GL Reversed Transactions Company Year GLR60112
GLR7 GL Reversed Transactions in Daybook Journal Company Year GLR70112
GLRD Company GLRD0100
GLRH Revenue Recognition History WIP Journal Company GLRH0100
GLRJ Company Year GLRJ0112
GLRM Revenue Recognition Model Codes Company GLRM0100
GLRR Company GLRR0100
GLTH BLiner functionality Company Year GLTH0112
GLTM Transaction Mapping Company GLTM0100
GLTR Transformation Rules for BLiner functionality Company Year GLTR0112
GLXX Wrk. Acc.Spec. GLXX0000
GLXZ SQL work file GLXZ0000
GLZZ Hyperion Export Parameters Company GLZZ0100
sca_trg_Audit_GL03 Audit trigger for GL03 table Company Year sca_trg_Audit_GL030112
sca_trg_Audit_GL10 Audit trigger for GL10 table Company Year sca_trg_Audit_GL100112
sca_trg_Audit_GL16 Audit trigger for GL16 table Company Year sca_trg_Audit_GL160112
sca_trg_Audit_GL53 Audit trigger for GL53 table Company Year sca_trg_Audit_GL530112
sca_trg_Audit_GLCD Audit trigger for GLCD table Company Year sca_trg_Audit_GLCD0112
sca_trg_Audit_GLCE Audit trigger for GLCE table Company sca_trg_Audit_GLCE0100
sca_trg_Audit_GLCF Audit trigger for GLCF table Company sca_trg_Audit_GLCF0100
sca_trg_Audit_GLCG Audit trigger for GLCG table Company sca_trg_Audit_GLCG0100
sca_trg_Audit_GLCI Audit trigger for GLCI table Company sca_trg_Audit_GLCI0100

Fields
PK Table Name Description Type Length Precision Note
1 GL09 GL09001 LayoutNumber VSTRING 2 2 0 Layout Number
GL09 GL09002 Name VSTRING 25 25 0 Name
GL09 GL09003 lifno0 INTEGER 2 0 0 Layout Information Number (0)
GL09 GL09004 lifpx0 INTEGER 1 0 0 Layout Amount Format (0)
GL09 GL09005 lifli0 INTEGER 1 0 0 Layout Line (0)
GL09 GL09006 lifpo0 INTEGER 3 0 0 Layout Position (0)
GL09 GL09007 lifhe10 VSTRING 25 25 0 Layout Head 1 (0)
GL09 GL09008 lifhe20 VSTRING 25 25 0 Layout Head 2 (0)
GL09 GL09009 lifhol0 VSTRING 3 3 0 Layout Formula Column (0)
GL09 GL09010 lifmath0 VSTRING 1 1 0 Layout Formula Operation (0)
GL09 GL09011 lifop0 VSTRING 9 9 0 Layout Formula Constant (0)
GL09 GL09012 lifno1 INTEGER 2 0 0 Layout Information Number (1)
GL09 GL09013 lifpx1 INTEGER 1 0 0 Layout Amount Format (1)
GL09 GL09014 lifli1 INTEGER 1 0 0 Layout Line (1)
GL09 GL09015 lifpo1 INTEGER 3 0 0 Layout Position (1)
GL09 GL09016 lifhe11 VSTRING 25 25 0 Layout Head 1 (1)
GL09 GL09017 lifhe21 VSTRING 25 25 0 Layout Head 2 (1)
GL09 GL09018 lifkol1 VSTRING 3 3 0 Layout Formula Column (1)
GL09 GL09019 lifmath1 VSTRING 1 1 0 Layout Formula Operation (1)
GL09 GL09020 lifop1 VSTRING 9 9 0 Layout Formula Constant (1)
GL09 GL09021 lifno2 INTEGER 2 0 0 Layout Information Number (2)
GL09 GL09022 lifpx2 INTEGER 1 0 0 Layout Amount Format (2)
GL09 GL09023 lifli2 INTEGER 1 0 0 Layout Line (2)
GL09 GL09024 lifpo2 INTEGER 3 0 0 Layout Position (2)
GL09 GL09025 lifhe12 VSTRING 25 25 0 Layout Head 1 (2)
GL09 GL09026 lifhe22 VSTRING 25 25 0 Layout Head 2 (2)
GL09 GL09027 lifkol2 VSTRING 3 3 0 Layout Formula Column (2)
GL09 GL09028 lifmath2 VSTRING 1 1 0 Layout Formula Operation (2)
GL09 GL09029 lifop2 VSTRING 9 9 0 Layout Formula Constant (2)
GL09 GL09030 lifno3 INTEGER 2 0 0 Layout Information Number (3)
GL09 GL09031 lifpx3 INTEGER 1 0 0 Layout Amount Format (3)
GL09 GL09032 lifli3 INTEGER 1 0 0 Layout Line (3)
GL09 GL09033 lifpo3 INTEGER 3 0 0 Layout Position (3)
GL09 GL09034 lifhe13 VSTRING 25 25 0 Layout Head 1 (3)
GL09 GL09035 lifhe23 VSTRING 25 25 0 Layout Head 2 (3)
GL09 GL09036 lifkol3 VSTRING 3 3 0 Layout Formula Column (3)
GL09 GL09037 lifmath3 VSTRING 1 1 0 Layout Formula Operation (3)
GL09 GL09038 lifop3 VSTRING 9 9 0 Layout Formula Constant (3)
GL09 GL09039 lifno4 INTEGER 2 0 0 Layout Information Number (4)
GL09 GL09040 lifpx4 INTEGER 1 0 0 Layout Amount Format (4)
GL09 GL09041 lifli4 INTEGER 1 0 0 Layout Line (4)
GL09 GL09042 lifpo4 INTEGER 3 0 0 Layout Position (4)
GL09 GL09043 lifhe14 VSTRING 25 25 0 Layout Head 1 (4)
GL09 GL09044 lifhe24 VSTRING 25 25 0 Layout Head 2 (4)
GL09 GL09045 lifkol4 VSTRING 3 3 0 Layout Formula Column (4)
GL09 GL09046 lifmath4 VSTRING 1 1 0 Layout Formula Operation (4)
GL09 GL09047 lifop4 VSTRING 9 9 0 Layout Formula Constant (4)
GL09 GL09048 lifno5 INTEGER 2 0 0 Layout Information Number (5)
GL09 GL09049 lifpx5 INTEGER 1 0 0 Layout Amount Format (5)
GL09 GL09050 lifli5 INTEGER 1 0 0 Layout Line (5)
GL09 GL09051 lifpo5 INTEGER 3 0 0 Layout Position (5)
GL09 GL09052 lifhe15 VSTRING 25 25 0 Layout Head 1 (5)
GL09 GL09053 lifhe25 VSTRING 25 25 0 Layout Head 2 (5)
GL09 GL09054 lifkol5 VSTRING 3 3 0 Layout Formula Column (5)
GL09 GL09055 lifmath5 VSTRING 1 1 0 Layout Formula Operation (5)
GL09 GL09056 lifop5 VSTRING 9 9 0 Layout Formula Constant (5)
GL09 GL09057 lifno6 INTEGER 2 0 0 Layout Information Number (6)
GL09 GL09058 lifpx6 INTEGER 1 0 0 Layout Amount Format (6)
GL09 GL09059 lifli6 INTEGER 1 0 0 Layout Line (6)
GL09 GL09060 lifpo6 INTEGER 3 0 0 Layout Position (6)
GL09 GL09061 lifhe16 VSTRING 25 25 0 Layout Head 1 (6)
GL09 GL09062 lifhe26 VSTRING 25 25 0 Layout Head 2 (6)
GL09 GL09063 lifkol6 VSTRING 3 3 0 Layout Formula Column (6)
GL09 GL09064 lifmath6 VSTRING 1 1 0 Layout Formula Operation (6)
GL09 GL09065 lifop6 VSTRING 9 9 0 Layout Formula Constant (6)
GL09 GL09066 lifno7 INTEGER 2 0 0 Layout Information Number (7)
GL09 GL09067 lifpx7 INTEGER 1 0 0 Layout Amount Format (7)
GL09 GL09068 lifli7 INTEGER 1 0 0 Layout Line (7)
GL09 GL09069 lifpo7 INTEGER 3 0 0 Layout Position (7)
GL09 GL09070 lifhe17 VSTRING 25 25 0 Layout Head 1 (7)
GL09 GL09071 lifhe27 VSTRING 25 25 0 Layout Head 2 (7)
GL09 GL09072 lifkol7 VSTRING 3 3 0 Layout Formula Column (7)
GL09 GL09073 lifmath7 VSTRING 1 1 0 Layout Formula Operation (7)
GL09 GL09074 lifop7 VSTRING 9 9 0 Layout Formula Constant (7)
GL09 GL09075 lifno8 INTEGER 2 0 0 Layout Information Number (8)
GL09 GL09076 lifpx8 INTEGER 1 0 0 Layout Amount Format (8)
GL09 GL09077 lifli8 INTEGER 1 0 0 Layout Line (8)
GL09 GL09078 lifpo8 INTEGER 3 0 0 Layout Position (8)
GL09 GL09079 lifhe18 VSTRING 25 25 0 Layout Head 1 (8)
GL09 GL09080 lifhe28 VSTRING 25 25 0 Layout Head 2 (8)
GL09 GL09081 lifkol8 VSTRING 3 3 0 Layout Formula Column (8)
GL09 GL09082 lifmath8 VSTRING 1 1 0 Layout Formula Operation (8)
GL09 GL09083 lifop8 VSTRING 9 9 0 Layout Formula Constant (8)
GL09 GL09084 lifno9 INTEGER 2 0 0 Layout Information Number (9)
GL09 GL09085 lifpx9 INTEGER 1 0 0 Layout Amount Format (9)
GL09 GL09086 lifli9 INTEGER 1 0 0 Layout Line (9)
GL09 GL09087 lifpo9 INTEGER 3 0 0 Layout Position (9)
GL09 GL09088 lifhe19 VSTRING 25 25 0 Layout Head 1 (9)
GL09 GL09089 lifhe29 VSTRING 25 25 0 Layout Head 2 (9)
GL09 GL09090 lifkol9 VSTRING 3 3 0 Layout Formula Column (9)
GL09 GL09091 lifmath9 VSTRING 1 1 0 Layout Formula Operation (9)
GL09 GL09092 lifop9 VSTRING 9 9 0 Layout Formula Constant (9)
GL09 GL09093 lifno10 INTEGER 2 0 0 Layout Information Number (10)
GL09 GL09094 lifpx10 INTEGER 1 0 0 Layout Amount Format (10)
GL09 GL09095 lifli10 INTEGER 1 0 0 Layout Line (10)
GL09 GL09096 lifpo10 INTEGER 3 0 0 Layout Position (10)
GL09 GL09097 lifhe110 VSTRING 25 25 0 Layout Head 1 (10)
GL09 GL09098 lifhe210 VSTRING 25 25 0 Layout Head 2 (10)
GL09 GL09099 lifkol10 VSTRING 3 3 0 Layout Formula Column (10)
GL09 GL09100 lifmath10 VSTRING 1 1 0 Layout Formula Operation (10)
GL09 GL09101 lifop10 VSTRING 9 9 0 Layout Formula Constant (10)
GL09 GL09102 lifno11 INTEGER 2 0 0 Layout Information Number (11)
GL09 GL09103 lifpx11 INTEGER 1 0 0 Layout Amount Format (11)
GL09 GL09104 lifli11 INTEGER 1 0 0 Layout Line (11)
GL09 GL09105 lifpo11 INTEGER 3 0 0 Layout Position (11)
GL09 GL09106 lifhe111 VSTRING 25 25 0 Layout Head 1 (11)
GL09 GL09107 lifhe211 VSTRING 25 25 0 Layout Head 2 (11)
GL09 GL09108 lifkol11 VSTRING 3 3 0 Layout Formula Column (11)
GL09 GL09109 lifmath11 VSTRING 1 1 0 Layout Formula Operation (11)
GL09 GL09110 lifop11 VSTRING 9 9 0 Layout Formula Constant (11)
GL09 GL09111 lifno12 INTEGER 2 0 0 Layout Information Number (12)
GL09 GL09112 lifpx12 INTEGER 1 0 0 Layout Amount Format (12)
GL09 GL09113 lifli12 INTEGER 1 0 0 Layout Line (12)
GL09 GL09114 lifpo12 INTEGER 3 0 0 Layout Position (12)
GL09 GL09115 lifhe112 VSTRING 25 25 0 Layout Head 1 (12)
GL09 GL09116 lifhe212 VSTRING 25 25 0 Layout Head 2 (12)
GL09 GL09117 lifkol12 VSTRING 3 3 0 Layout Formula Column (12)
GL09 GL09118 lifmath12 VSTRING 1 1 0 Layout Formula Operation (12)
GL09 GL09119 lifop12 VSTRING 9 9 0 Layout Formula Constant (12)
GL09 GL09120 lifno13 INTEGER 2 0 0 Layout Information Number (13)
GL09 GL09121 lifpx13 INTEGER 1 0 0 Layout Amount Format (13)
GL09 GL09122 lifli13 INTEGER 1 0 0 Layout Line (13)
GL09 GL09123 lifpo13 INTEGER 3 0 0 Layout Position (13)
GL09 GL09124 lifhe113 VSTRING 25 25 0 Layout Head 1 (13)
GL09 GL09125 lifhe213 VSTRING 25 25 0 Layout Head 2 (13)
GL09 GL09126 lifkol13 VSTRING 3 3 0 Layout Formula Column (13)
GL09 GL09127 lifmath13 VSTRING 1 1 0 Layout Formula Operation (13)
GL09 GL09128 lifop13 VSTRING 9 9 0 Layout Formula Constant (13)
GL09 GL09129 Licurr0 STRING 2 2 0 Currency Code for Column (0)
GL09 GL09130 Licuurr1 STRING 2 2 0 Currency Code for Column (1)
GL09 GL09131 Licurr2 STRING 2 2 0 Currency Code for Column (2)
GL09 GL09132 Licurr3 STRING 2 2 0 Currency Code for Column (3)
GL09 GL09133 Licurr4 STRING 2 2 0 Currency Code for Column (4)
GL09 GL09134 Licurr5 STRING 2 2 0 Currency Code for Column (5)
GL09 GL09135 Licurr6 STRING 2 2 0 Currency Code for Column (6)
GL09 GL09136 Licurr7 STRING 2 2 0 Currency Code for Column (7)
GL09 GL09137 Licurr8 STRING 2 2 0 Currency Code for Column (8)
GL09 GL09138 Licurr9 STRING 2 2 0 Currency Code for Column (9)
GL09 GL09139 Licurr10 STRING 2 2 0 Currency Code for Column (10)
GL09 GL09140 Licurr11 STRING 2 2 0 Currency Code for Column (11)
GL09 GL09141 Licurr12 STRING 2 2 0 Currency Code for Column (12)
GL09 GL09142 Licurr13 STRING 2 2 0 Currency Code for Column (13)