Profit & Loss account. More...
Go to the source code of this file.
Profit & Loss account.
PK | Variable | Type | Required? | Relationships | Label | Description | Required by models |
---|---|---|---|---|---|---|---|
![]() | REPORTING_DT | NUMERIC(8) | Y | Reporting Date | Reporting Period | ST - Financial Statement Projection | |
ENTITY_ID | VARCHAR(32) | Y | entity.sas | Entity Id | Unique Entity identifier | ST - Financial Statement Projection | |
![]() | PL_ACCOUNT_ID | VARCHAR(32) | Y | P&L Account Id | Identifier of the P&L 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 | ||
![]() | PROFIT_LOSS_CD | VARCHAR(32) | N | map_profit_loss_hierarchy.sas | P&L Code | P&L 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 P&L account value | |||
PL_ACCOUNT_VALUE_AMT | NUMERIC(8) | N | P&L Account Value Amount | Value amount of the P&L account | ST - Financial Statement Projection |
Definition in file profit_loss_account.sas.