MASTER PROJECT HISTORY DETAIL Table
View exposing historical master-project financial detail by fiscal month including profit center, cost collector category, expense, revenue, settlement, principal, fiscal-year-to-date, cumulative, and authorized-total measures.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AUTHORIZED_TOTAL_AMOUNT |
Authorized total amount associated with the record. |
NUMBER |
18,2 |
COST_COLLECTOR_CATEGORY_KEY |
Surrogate key identifying the cost collector category. |
VARCHAR2 |
5 |
CUMULATIVE_EXPENSE_AMOUNT |
Cumulative expense amount associated with the record. |
NUMBER |
18,2 |
CUMULATIVE_PRINCIPAL_AMOUNT |
Cumulative principal amount associated with the record. |
NUMBER |
18,2 |
CUMULATIVE_REVENUE_AMOUNT |
Cumulative revenue amount associated with the record. |
NUMBER |
18,2 |
CUMULATIVE_SETTLEMENT_AMOUNT |
Cumulative settlement amount associated with the record. |
NUMBER |
18,2 |
EXPENSE_AMOUNT |
Expense amount associated with the record. |
NUMBER |
18,2 |
FYTD_EXPENSE_AMOUNT |
Fytd expense amount associated with the record. |
NUMBER |
18,2 |
FYTD_PRINCIPAL_AMOUNT |
Fytd principal amount associated with the record. |
NUMBER |
18,2 |
FYTD_REVENUE_AMOUNT |
Fytd revenue amount associated with the record. |
NUMBER |
18,2 |
FYTD_SETTLEMENT_AMOUNT |
Fytd settlement amount associated with the record. |
NUMBER |
18,2 |
IS_TERMINATED_MASTER_PROJECT |
Indicator identifying whether terminated master project (Y/N). |
VARCHAR2 |
1 |
MASTER_PROJECT_FP_KEY |
Surrogate key identifying the master project fp. |
VARCHAR2 |
12 |
PRINCIPAL_AMOUNT |
Principal amount associated with the record. |
NUMBER |
18,2 |
PROFIT_CENTER_KEY |
Surrogate key identifying the profit center. |
VARCHAR2 |
11 |
RECORD_COUNTER |
Record counter associated with the record. |
NUMBER |
1 |
REVENUE_AMOUNT |
Revenue amount associated with the record. |
NUMBER |
18,2 |
SETTLEMENT_AMOUNT |
Settlement amount associated with the record. |
NUMBER |
18,2 |
TIME_MONTH_KEY |
Surrogate key identifying the time month. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |