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
GLF1 Financial Reporting Report Definition Company GLF10100
GLF2 Financial Reporting RowSet Company GLF20100
GLF3 Financial Reporting Row Company GLF30100
GLF4 Financial Reporting Leaf Row Properties Company GLF40100
GLF5 Financial Reporting ColumnSet Company GLF50100
GLF6 Financial Reporting Column Company GLF60100
GLF7 Accounting Dimension Categories Company GLF70100
GLF8 Accounting Dimension Categories Leaf Properties Company GLF80100
GLFA Financial Reporting Report Definition Descriptions Company GLFA0100
GLFB Financial Reporting RowSet Descriptions Company GLFB0100
GLFC Financial Reporting Row Descriptions Company GLFC0100
GLFD Financial Reporting ColumnSet Descriptions Company GLFD0100
GLFE Financial Reporting Column Descriptions Company GLFE0100
GLFF Accounting Dimension Categories Descriptions Company GLFF0100
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 GL53 GL53001 AccountNo VSTRING 12 12 0 Account Number
GL53 GL53002 AccountName VSTRING 100 100 0 Account Name
GL53 GL53003 AccountType VSTRING 1 1 0 Account Type 0 - Profit & Loss Account
1 - Balance Account
2 - Statistical Account
GL53 GL53004 AutomatAlloc VSTRING 2 2 0 Automatic Allocation No
GL53 GL53005 SegmentSw STRING 9 9 0 Segment Switches String with on character per accounting dimension (character 1-9 = accounting dimension 1-9):
0 - Accounting dimension is not used for the account
1 - Accounting dimension is mandatory for the account
2 - Accounting dimension is optional for the account
GL53 GL53006 EntryBlock STRING 1 1 0 Blocked Entry (Inactive) 0 - Active account, allows new entries
1 - Inactive account, no entries can be made (used for accounts to be deleted)
2 - No direct entries is allowed
GL53 GL53007 BudgetModNo STRING 1 1 0 Budget Model Number
GL53 GL53008 BookedAm MONEY 20 28 8 Booked Amount
GL53 GL53009 SubLedgerCode VSTRING 2 2 0 Sub-Ledger Code 00 - No sub-ledger
01 - Sales ledger account
02 - Purchase ledger account
03 - Sales ledger with currency account
04 - Purchase ledger with currency account
05 - Asset account
07 - Quantity accounting
08 - Quantity accounting with constant
09 - Currency account type 1 (statistical as secondary account)
10 - Currency account type 2 (statistical as primary account)
11 - Inter-company transactions
12 - Tax transactions
13 - Promissory notes
14 - Analytical ledger
15 - Direct tax transactions
16 - Petty cash-book
GL53 GL53010 DescrLine1 VSTRING 100 100 0 Account Description Line 1
GL53 GL53011 DescrLine2 VSTRING 100 100 0 Account Description Line 2
GL53 GL53012 DescrLine3 VSTRING 100 100 0 Account Description Line 3
GL53 GL53013 DefaultSgmt ACCSTR 120 120 0 Default Segment
GL53 GL53014 SubLedgPar1 VSTRING 15 15 0 Sub-Ledger Parameter 1 Used for sub-ledger code (GL53005), 07 and 08:
Label in dialog asking for quantity
GL53 GL53015 SubLedgPar2 VSTRING 12 12 0 Sub-Ledger Parameter 2 Usage depends on sub-ledger code (GL53005):
Sub-ledger 07 and 08: Statistical account to hold quantity
Sub-ledger 16: Statistical account to hold amount in foreign currency
Sub-ledger 03, 04, 09: Statistical account to hold amount in foreign currency or '*' to indicate that the account is linked to multiple statistical accounts, in this case the sub-ledger information is stored in GL5A.
Sub-ledger 10: Account to hold amount in local currency
GL53 GL53016 SubLedgPar3 VSTRING 12 12 0 Sub-Ledger Parameter 3 Used for sub-ledger code (GL53005), 03, 04, 09, 10 and 16:
Profit account for revaluation
GL53 GL53017 SubLedgPar4 VSTRING 12 12 0 Sub-Ledger Parameter 4 Used for sub ledger code (GL53005) 03, 04, 09, 10 and 16:
Loss account for revaluation
GL53 GL53018 SubLedgPar5 VSTRING 12 12 0 Sub-Ledger Parameter 5 Only used for Greece: Analytical Ledger Allocation
GL53 GL53019 SubLedgPar6 VSTRING 10 10 0 Sub-Ledger Parameter 6 Used for sub-ledger code (GL53005), 08:
Constant
GL53 GL53020 SubLedgPar7 VSTRING 25 25 0 Sub-Ledger Parameter 7 Two first character in string is used for sub-ledger code (GL53005), 09, 10 and 16:
Rate option for debit, first character in string is for debit transaction lines and second character is for credit:
0 - Query menu to adjust the rate at transaction entry.
1 - Debit/Credit transactions are calculated using selling rate for currency.
2 - Debit/Credit transactions are calculated using buying rate for currency.

Third character in string used for sub-ledger code (GL53005), 10:
0 - Currency code defined in GL53020 is used on entry of amount.
1 - Alternative currency code can be selected on entry of amount.

Character 4-9 in string used for sub-ledger code (GL53005), 10:
Valid currencies, (the 30 currencies are packed in-to the 5 character long string)
GL53 GL53021 SubLedgPar8 VSTRING 2 2 0 Sub-Ledger Parameter 8 Used for-sub-ledger code (GL53005), 03, 04, 09, 10 and 16:
Currency Code
GL53 GL53022 SubLedgPar9 VSTRING 2 2 0 Sub-Ledger Parameter 9 Used for sub-ledger code (GL53005), 03, 04, 09, 10 and 16:
Revaluation Method:
0 - No revaluation
1 - Only revaluate account when the result is a currency loss.
2 - Revaluate account regardless if the result is a profit or a loss.
3 - Only revaluate account when the result is a currency profit.
GL53 GL53023 ExtRepCode VSTRING 20 20 0 External Report Code
GL53 GL53024 DecimalStat INTEGER 1 0 0 Number of Decimals For Stat. Account
GL53 GL53025 ScalaUserGrp VSTRING 8 8 0 Scala User Group
GL53 GL53026 TransfNextYr STRING 1 1 0 Transfer to Next Year
GL53 GL53027 SubLedgPar10 VSTRING 12 12 0 Sub-Ledger Parameter 10 To be used as alternative account when the currency account is revalue.
GL53 GL53028 AccountSubType VSTRING 1 1 0 Account Sub-Type
GL53 GL53029 ExtUserDefFld1 VSTRING 150 150 0 Extended User defined field 1 Ext. User defined field 1
GL53 GL53030 ExtUserDefFld2 VSTRING 150 150 0 Extended User defined field 2 Ext. User defined field 2
GL53 GL53031 ExtUserDefFld3 VSTRING 150 150 0 Extended User defined field 3 Ext. User defined field 3
GL53 GL53032 ExtUserDefFld4 VSTRING 150 150 0 Extended User defined field 4 Ext. User defined field 4
GL53 GL53033 ExtUserDefFld5 VSTRING 150 150 0 Extended User defined field 5 Ext. User defined field 5
GL53 GL53034 ExtUserDefFld6 VSTRING 150 150 0 Extended User defined field 6 Ext. User defined field 6
GL53 GL53035 ExtUserDefFld7 VSTRING 150 150 0 Extended User defined field 7 Ext. User defined field 7
GL53 GL53036 ExtUserDefFld8 VSTRING 150 150 0 Extended User defined field 8 Ext. User defined field 8
GL53 GL53037 ExtUserDefFld9 VSTRING 150 150 0 Extended User defined field 9 Ext. User defined field 9
GL53 GL53038 ExtUserDefFld10 VSTRING 150 150 0 Extended User defined field 10 Ext. User defined field 10
GL53 GL53039 ExtUserDefFld11 VSTRING 150 150 0 Extended User defined field 11 Ext. User defined field 11
GL53 GL53040 ExtUserDefFld12 VSTRING 150 150 0 Extended User defined field 12 Ext. User defined field 12
GL53 GL53041 ExtUserDefFld13 VSTRING 150 150 0 Extended User defined field 13 Ext. User defined field 13
GL53 GL53042 ExtUserDefFld14 VSTRING 150 150 0 Extended User defined field 14 Ext. User defined field 14
GL53 GL53043 ExtUserDefFld15 VSTRING 150 150 0 Extended User defined field 15 Ext. User defined field 15
GL53 GL53044 ExtUserDefFld16 VSTRING 150 150 0 Extended User defined field 16 Ext. User defined field 16
GL53 GL53045 ExtUserDefFld17 VSTRING 150 150 0 Extended User defined field 17 Ext. User defined field 17
GL53 GL53046 ExtUserDefFld18 VSTRING 150 150 0 Extended User defined field 18 Ext. User defined field 18
GL53 GL53047 ExtUserDefFld19 VSTRING 150 150 0 Extended User defined field 19 Ext. User defined field 19
GL53 GL53048 ExtUserDefFld20 VSTRING 150 150 0 Extended User defined field 20 Ext. User defined field 20
GL53 GL53049 TaxonomyCode STRING 3 3 0 Taxonomy code for account
GL53 GL53050 AccGroupCategory STRING 6 6 0 Account Grouping Category
GL53 GL53051 BalanceType INTEGER 1 0 0 Balance Type Balance Type