PENSION GL BALANCES Table
View exposing pension general ledger balance records used for financial reconciliation and reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
APRIL_AMOUNT |
April amount associated with the record. |
NUMBER |
13,2 |
AUGUST_AMOUNT |
August amount associated with the record. |
NUMBER |
13,2 |
COMPANY_CODE |
Code identifying company. |
VARCHAR2 |
4 |
CUMULATIVE_AMOUNT |
Cumulative amount associated with the record. |
NUMBER |
13,2 |
DECEMBER_AMOUNT |
December amount associated with the record. |
NUMBER |
13,2 |
FEBRUARY_AMOUNT |
February amount associated with the record. |
NUMBER |
13,2 |
FISCAL_YEAR |
Fiscal year associated with the record. |
VARCHAR2 |
4 |
FYTD_AMOUNT |
Fytd amount associated with the record. |
NUMBER |
13,2 |
GL_ACCOUNT_KEY |
Surrogate key identifying the gl account. |
VARCHAR2 |
10 |
JANUARY_AMOUNT |
January amount associated with the record. |
NUMBER |
13,2 |
JULY_AMOUNT |
July amount associated with the record. |
NUMBER |
13,2 |
JUNE_AMOUNT |
June amount associated with the record. |
NUMBER |
13,2 |
MARCH_AMOUNT |
March amount associated with the record. |
NUMBER |
13,2 |
MAY_AMOUNT |
May amount associated with the record. |
NUMBER |
13,2 |
NOVEMBER_AMOUNT |
November amount associated with the record. |
NUMBER |
13,2 |
OCTOBER_AMOUNT |
October amount associated with the record. |
NUMBER |
13,2 |
OPENING_BALANCE |
Opening balance associated with the record. |
NUMBER |
13,2 |
PREV_YEAR_CUM_AMOUNT |
Prev year cum amount associated with the record. |
NUMBER |
13,2 |
RECORD_COUNTER |
Record counter associated with the record. |
NUMBER |
|
SEPTEMBER_AMOUNT |
September amount associated with the record. |
NUMBER |
13,2 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |