The General Ledger main details for each ledger account code are recorded in GL_Ledger, including current balance of the account and details on transaction code postings, distribution details and quad postings.
GL_Sets maintains the header record for journal set postings, including journals posting from modules external to the ledger. GL_Transactions details the line information for each journal set, including transaction code postings.
Current balances on a month by month basis are stored in GL_Movement and updated when journal sets are saved from GL_Transactions.
GL_AutoJournals and GL_AutoJournalLines stores details on automatic and standing journal details, including the source and destination journal sets.
Additional General Ledger information is stored as follows:
GL_Config - controls the configuration settings for the General Ledger - year starting, creating a new year and period names for report headings
GL_Segment - maintains the segment details that comprise the ledger account code
GL_Category - details the category selections that are used as a lookup table when setting up new ledger account codes
GL_TranCodes - maintains the description codes for transaction code postings. The titles for these categories are controlled from the .ini file.
GL_Distribution - stores the distribution ledger accounts and percentages where postings to an account are to be distributed to at least one other account
GL_Budget1, GLBudget2 and GL_Budget3 - stores three levels of budget details for last, current and next year by monthly periods. End of Year rollover transfers current year budgets into last year, and next into current year
Copyright © 2012 Jiwa Financials. All rights reserved.