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 GL10 GL10001 CompYear STRING 4 4 0 Company Year
GL10 GL10002 AutoAlloc VSTRING 2 2 0 Next Period for Automatic Allocation
GL10 GL10003 LowestAccPer VSTRING 2 2 0 Lowest Accounting Period (GL)
GL10 GL10004 DateEmptying DATE 8 0 0 Date of Emptying
GL10 GL10005 NoOfAccPer VSTRING 2 2 0 Number of Accounting Periods
GL10 GL10006 AccessLevel VSTRING 1 1 0 Access Level
GL10 GL10007 DummyCounter VSTRING 1 1 0 Dummy Counter
GL10 GL10008 AccPer1Start DATE 8 0 0 Account Period 1 Start Date
GL10 GL10009 AccPer1End DATE 8 0 0 Account Period 1 End Date
GL10 GL10010 AccPer2Start DATE 8 0 0 Account Period 2 Start Date
GL10 GL10011 AccPer2End DATE 8 0 0 Account Period 2 End Date
GL10 GL10012 AccPer3Start DATE 8 0 0 Account Period 3 Start Date
GL10 GL10013 AccPer3End DATE 8 0 0 Account Period 3 End Date
GL10 GL10014 AccPer4Start DATE 8 0 0 Account Period 4 Start Date
GL10 GL10015 AccPer4End DATE 8 0 0 Account Period 4 End Date
GL10 GL10016 AccPer5Start DATE 8 0 0 Account Period 5 Start Date
GL10 GL10017 AccPer5End DATE 8 0 0 Account Period 5 End Date
GL10 GL10018 AccPer6Start DATE 8 0 0 Account Period 6 Start Date
GL10 GL10019 AccPer6End DATE 8 0 0 Account Period 6 End Date
GL10 GL10020 AccPer7Start DATE 8 0 0 Account Period 7 Start Date
GL10 GL10021 AccPer7End DATE 8 0 0 Account Period 7 End Date
GL10 GL10022 AccPer8Start DATE 8 0 0 Account Period 8 Start Date
GL10 GL10023 AccPer8End DATE 8 0 0 Account Period 8 End Date
GL10 GL10024 AccPer9Start DATE 8 0 0 Account Period 9 Start Date
GL10 GL10025 AccPer9End DATE 8 0 0 Account Period 9 End Date
GL10 GL10026 AccPer10St DATE 8 0 0 Account Period 10 Start Date
GL10 GL10027 AccPer10End DATE 8 0 0 Account Period 10 End Date
GL10 GL10028 AccPer11St DATE 8 0 0 Account Period 11 Start Date
GL10 GL10029 AccPer11End DATE 8 0 0 Account Period 11 End Date
GL10 GL10030 AccPer12St DATE 8 0 0 Account Period 12 Start Date
GL10 GL10031 AccPer12End DATE 8 0 0 Account Period 12 End Date
GL10 GL10032 AccPer13St DATE 8 0 0 Account Period 13 Start Date
GL10 GL10033 AccPer13End DATE 8 0 0 Account Period 13 End Date
GL10 GL10034 AccPer14St DATE 8 0 0 Account Period 14 Start Date
GL10 GL10035 AccPer14End DATE 8 0 0 Account Period 14 End Date
GL10 GL10036 AccPer15St DATE 8 0 0 Account Period 15 Start Date
GL10 GL10037 AccPer15End DATE 8 0 0 Account Period 15 End Date
GL10 GL10038 AccPer16St DATE 8 0 0 Account Period 16 Start Date
GL10 GL10039 AccPer16End DATE 8 0 0 Account Period 16 End Date
GL10 GL10040 AccPer17St DATE 8 0 0 Account Period 17 Start Date
GL10 GL10041 AccPer17End DATE 8 0 0 Account Period 17 End Date
GL10 GL10042 AccPer18St DATE 8 0 0 Account Period 18 Start Date
GL10 GL10043 AccPer18End DATE 8 0 0 Account Period 18 End Date
GL10 GL10044 Switches VSTRING 18 18 0 Switches Each character in the string is a parameter switch (1-16)
1 - Enter Display Total
2 - Automatic Transaction Number
3 - Reports from Company 01
4 - Report Layouts from Company 01
5 - Journal Control
6 - Obligatory Batch Control
7 - Print Account Summary on Journals
8 - Automatic Error Bookings
17 - Create Projects in Project Module
GL10 GL10045 AccPer19St DATE 8 0 0 Account Period 19 Start Date
GL10 GL10046 AccPer19End DATE 8 0 0 Account Period 19 End Date
GL10 GL10047 AccPer20St DATE 8 0 0 Account Period 20 Start Date
GL10 GL10048 AccPer20End DATE 8 0 0 Account Period 20 End Date
GL10 GL10049 AccPer21St DATE 8 0 0 Account Period 21 Start Date
GL10 GL10050 AccPer21End DATE 8 0 0 Account Period 21 End Date
GL10 GL10051 AccPer22St DATE 8 0 0 Account Period 22 Start Date
GL10 GL10052 AccPer22End DATE 8 0 0 Account Period 22 End Date
GL10 GL10053 AccPer23St DATE 8 0 0 Account Period 23 Start Date
GL10 GL10054 AccPer23End DATE 8 0 0 Account Period 23 End Date
GL10 GL10055 AccPer24St DATE 8 0 0 Account Period 24 Start Date
GL10 GL10056 AccPer24End DATE 8 0 0 Account Period 24 End Date
GL10 GL10057 ClAccPerSt DATE 8 0 0 Closing Period Start Date
GL10 GL10058 ClAccPerEnd DATE 8 0 0 Closing Period End Date
GL10 GL10059 ClJourCode STRING 6 6 0 Closing Journal Code
GL10 GL10060 RoundOffTolerance MONEY 20 28 8 Rounding-Off Tolerance Amount
GL10 GL10061 RoundOffProfitAcc VSTRING 12 12 0 Rounding-Off Profit Account
GL10 GL10062 RoundOffLossAcc VSTRING 12 12 0 Rounding-Off Loss Account
GL10 GL10063 CloseGL SWITCH 1 1 0 Close GL
GL10 GL10064 ClosePL SWITCH 1 1 0 Close PL
GL10 GL10065 CloseSL SWITCH 1 1 0 Close SL
GL10 GL10066 ClosePA SWITCH 1 1 0 Close PA
GL10 GL10067 ClosePR SWITCH 1 1 0 Close PR
GL10 GL10068 CloseSC SWITCH 1 1 0 Close SC
GL10 GL10069 CloseSM SWITCH 1 1 0 Close SM
GL10 GL10070 CloseMP SWITCH 1 1 0 Close MP
GL10 GL10071 GLTransactionsFilePath VSTRING 256 256 0 GL Transactions File Path (Hospitality)
GL10 GL10072 JournalLineCounter INTEGER 9 0 0 Journal Line Counter
GL10 GL10073 JournalRunningTotalAmnt MONEY 20 28 8 Journal Running Total Amount
GL10 GL10074 OpeningJournalPrinted SWITCH 1 1 0 Opening Journal Printed
GL10 GL10075 ClosingJournalPrinted SWITCH 1 1 0 Closing Journal Printed
GL10 GL10076 JournalCloseDate DATE 8 0 0 Journal Closing Date
GL10 GL10077 UseGLTransNum SWITCH 1 1 0 Use GL Transaction Number (Revenue Recognition)
GL10 GL10078 Automatic transformation at update of journals SWITCH 1 1 0 Auto. transformation at journal update BLiner functionality
GL10 GL10079 Use system rules at automatic transformation SWITCH 1 1 0 Use system rules at auto. transformation BLiner functionality
GL10 GL10080 AllocationSorting SWITCH 1 1 0 Allocation sorting flag Daybook journal transactions created during execution of compound or periodic automatic allocations in non-condensed mode have transaction lines sorted
GL10 GL10081 TaxonomyCodeFlag SWITCH 1 1 0 Taxonomy Code Flag
GL10 GL10082 ApplyPartPosting SWITCH 1 1 0 Apply Partial Posting
GL10 GL10083 GroupCategoryFlag SWITCH 1 1 0 Group Category Flag
GL10 GL10084 AccountPerCashOffice SWITCH 1 1 0 One Account Per Cash Office
GL10 GL10085 LateAssignmentOfTransactionNumber SWITCH 1 1 0 Late Assignment Of Transaction Number
GL10 GL10086 AmountValidation SWITCH 1 1 0 Bank Statement Amount Validation
GL10 GL10087 ControlOpenFromPeriod SWITCH 1 1 0 Control of Open from Period Strict Control of Open from Period
GL10 GL10088 KeepBEDateInClosedPeriod SWITCH 1 1 0 Keep BE-Date In Closed Period Keep BE-Date In Closed Period