GL Departments (DEPT)

A list of departments for each company in your organization. Department information includes address, contact information, tax codes, and various flags configured in General Ledger.

GL Accounts (GL_COMPANY_ACCOUNT)

A GL account is an account used when posting expenses to the General Ledger. It is a record of financial transactions that are categorized by account type, such as assets, liabilities, equity, revenue, and expenses. This folder contains information about each GL account including the code, name, type code, controlling type code, group codes, etc.

GL Balances (BALANCE)

A GL balance refers to the balance of an account within a company's General Ledger. It displays the account activity for each department, account, year, and period. Each GL account has a balance at any given time. This folder contains that information, broken down by debit, credit, and other amounts.

GL Budgets (BUDGET)

This folder contains the budget for each GL account by fiscal period, broken down by debits, credits, and units.

GL Transactions (GLEDGER)

GL transactions are general ledger transactions that record financial transactions for the entire company. GL transactions may include job cost transactions. This folder contains information for each GL transaction including company, department, account, post date, amount, units, etc.

GL Chart Codes (CONSCHART)

A chart code is a code that defines groups of GL accounts and is used as the name of the master chart of accounts list for a specific company or department. It is important to note that only business entities, companies, and departments that share a specific chart code may be consolidated. This folder contains basic information about each chart code including various flags set up in General Ledger.

GL Periods (PERIOD)

Fiscal periods set up for each chart code have specific start and end dates. This folder contains information about each GL period that is linked to each chart code created in General Ledger, including the start and end dates.

GL Account Types (ACCTYPE)

This folder contains information about each GL account type including the chart code, name, and various flags set up in General Ledger.

GL Account Detail (ACCOUNT)

This folder contains details about each GL account including type code, currency code, TAV codes, and various flags configured in General Ledger.

GL Activity (GLACTIVITY)

This folder contains information about the opening and closing balances of each GL account per period, as well as the activity of each account.

GLBI Balances by Period (GL_ACCOUNT_BALANCE_BY_PERIOD)

This folder contains the GL account balances by period as well as the balances for the prior year, prior quarter, prior period, quarter to date, period to date and other balance comparisons.

GLBI Budgets by Period (GL_ACCOUNT_BUDGET_BY_PERIOD)

This folder contains the GL account budgets by period as well as the budgets for the prior year, prior quarter, prior period, quarter to date, period to date and other budget comparisons.

GLBI 12 Column Account Balances (GL_BALANCE_LOG_V)

This folder contains the closing balances for a given GL account in a 12-period time span, organized into 12 columns.

GLBI Transactions with Year Period (GLEDGER_WITH_YEAR_PERIOD)

This folder is like GL Transactions and contains more details about the fiscal year and period, as well as context variables that allow you to easily filter the data in a BI report.

GLBI 12 Column Account Activity (GL_PER_ACTIVITY_LOG_V)

This folder shows a log view of the GL account activity for each fiscal period organized into 12 columns.

GLBI Financial Documents (GL_BI_DOCPRINT)

Financial Document Formatter (FDF) 2.0 stores data when financial documents are processed and/or printed. This folder contains the data from those documents such as row descriptions, data from the columns as they are customized, run date information, fiscal year, fiscal period, and other information. This data can be used to create customized BI reports based on FDF 2.0 documents.