General Ledger Division
Overview
The General Ledger (GL) Division subject area defines the financial segmentation used in the General Ledger. It assigns transactions to divisions such as business units, cost centers, or regional entities to ensure accurate allocation of revenue, expenses, and other financial activities. Each GL division is associated with a currency code for consistent transaction denomination and linked to an accounting calendar that specifies financial periods, fiscal years, and reporting timelines.
Conforming Layers
The only conforming layer of this subject area is GL_DIVISION_OBJ.
GL_DIVISION_OBJ
| Column | Description | Data Type | Data Length |
|---|---|---|---|
| GL_DIVISION | Unique identifier for the general ledger division. | VARCHAR | 5 |
| CURRENCY_CD | ISO code for the currency in which the general ledger is recorded. | VARCHAR | 3 |
| CALENDAR_ID | Calendar used for the GL division’s accounting periods. It defines the period logic for processing and reporting transactions. | VARCHAR | 2 |
| DESCR | Descriptive name of the GL division. | VARCHAR | 60 |
| CDC_LOAD_DTTM | Timestamp when the record was loaded into the data warehouse. | TIMESTAMP | CDC_FLAG | Flag specifying the type of data change captured in the record during the Change Data Capture (CDC) process. | VARCHAR | 1 |
| COMPOSITE_KEY | Unique identifier in the GL_DIVISION format. This is the primary key. |
VARCHAR | 5 |
| CREATE_DTTM | Date and time when the record was created in the system. | TIMESTAMP | |
| UPDATE_DTTM | Date and time when the record was last updated. | TIMESTAMP |