SING CONSOLIDATED Table
View exposing consolidated Singapore financial results including aggregated financial measures across entities or reporting structures.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ANNUAL_BUDGET_SGD |
Annual budget sgd associated with the record. |
NUMBER |
|
ANNUAL_BUDGET_USD |
Annual budget usd associated with the record. |
NUMBER |
|
CATEGORY |
Category associated with the record. |
VARCHAR2 |
50 |
COMMITMENTS_SGD |
Commitments sgd associated with the record. |
NUMBER |
|
COMMITMENTS_USD |
Commitments usd associated with the record. |
NUMBER |
|
COST_OBJECT |
Cost object associated with the record. |
VARCHAR2 |
7 |
COST_OBJECT_KEY |
Surrogate key identifying the cost object. |
VARCHAR2 |
12 |
COST_OBJECT_NAME |
Cost object name associated with the record. |
VARCHAR2 |
40 |
CUMULATIVE_BUDGET_SGD |
Cumulative budget sgd associated with the record. |
NUMBER |
|
CUMULATIVE_BUDGET_USD |
Cumulative budget usd associated with the record. |
NUMBER |
|
FILE_LOAD_DATE |
Date associated with file load. |
DATE |
|
GL_ACCOUNT_ID |
Business identifier for the gl account. |
VARCHAR2 |
6 |
GL_ACCOUNT_KEY |
Surrogate key identifying the gl account. |
VARCHAR2 |
10 |
GL_ACCOUNT_NAME |
Gl account name associated with the record. |
VARCHAR2 |
50 |
IRG |
Irg associated with the record. |
VARCHAR2 |
50 |
PI |
Pi associated with the record. |
VARCHAR2 |
90 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |