PAYROLL COMMITMENT SUMMARY Table
View exposing payroll commitment summary by cost collector, general ledger account, and fiscal month including adjusted and unadjusted commitment amounts and commitment origin.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COMMITMENT_AMOUNT |
Commitment amount associated with the record. |
NUMBER |
15,2 |
COMMITMENT_ORIGIN |
Commitment origin associated with the record. |
VARCHAR2 |
3 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
GL_ACCOUNT_KEY |
Surrogate key identifying the gl account. |
VARCHAR2 |
10 |
TIME_MONTH_KEY |
Surrogate key identifying the time month. |
VARCHAR2 |
6 |
UNADJUSTED_COMMITMENT_AMOUNT |
Unadjusted commitment amount associated with the record. |
NUMBER |
15,2 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |