General Ledger account. More...
Go to the source code of this file.
General Ledger account.
PK | Variable | Type | Required? | Relationships | Label | Description | Required by models |
---|---|---|---|---|---|---|---|
![]() | REPORTING_DT | NUMERIC(8) | Y | Reporting Date | Date the GL entry was reported | ST - Financial Statement Projection | |
ENTITY_ID | VARCHAR(32) | Y | entity.sas | Entity Id | Unique Entity identifier | ST - Financial Statement Projection | |
![]() | GL_ACCOUNT_ID | VARCHAR(32) | Y | GL Account Id | Identifier used to define the type of GL account | ST - Financial Statement Projection | |
![]() | FORECAST_HORIZON | NUMERIC(8) | Y | Forecast Horizon | Forecast horizon: - FORECAST_HORIZON = 0 identifies actual values. - FORECAST_HORIZON > 0 indicate forecasts. Forecast values (if any) override any computed values | ST - Financial Statement Projection | |
GEOGRAPHY_CD | VARCHAR(32) | N | map_geo_hierarchy.sas | Geography Code | Geography code | ||
CHART_OF_ACCOUNT_CD | VARCHAR(32) | N | map_chart_of_account.sas | Chart of Account Code | Chart of Account Code | ||
![]() | BALANCE_SHEET_CD | VARCHAR(32) | N | map_balance_sheet_hierarchy.sas | Balance Sheet Code | Balance Sheet Code | ST - Financial Statement Projection |
![]() | SCENARIO_ID | VARCHAR(32) | Y | Scenario Id | Scenario Identifier | ||
![]() | MOVEMENT_TYPE_CD | VARCHAR(32) | Y | map_movement_type.sas | Movement Type Code | Movement Type Code | |
CURRENCY_CD | VARCHAR(3) | N | Currency Code | 3 character ISO code for nominal currency of GL account value | |||
GL_ACCOUNT_VALUE_AMT | NUMERIC(8) | N | GL Account Value Amount | Value amount of the GL account | ST - Financial Statement Projection |
Definition in file gl_account.sas.