BALANCE SHEET BALANCES BY FP Table
View exposing balance sheet balances by account and fiscal period used for period-based financial statement reporting and analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AMOUNT |
Amount associated with the record. |
NUMBER |
13,2 |
BALANCE_SHEET_ACCOUNT_KEY |
Balance sheet account key associated with the record. |
VARCHAR2 |
12 |
COMPANY_CODE |
Company code associated with the record. |
VARCHAR2 |
4 |
CUMULATIVE_AMOUNT |
Cumulative amount associated with the record. |
NUMBER |
13,2 |
FYTD_AMOUNT |
Fytd amount associated with the record. |
NUMBER |
13,2 |
FY_OPENING_BALANCE |
Fy opening balance associated with the record. |
NUMBER |
13,2 |
GL_ACCOUNT_KEY |
Gl account key associated with the record. |
VARCHAR2 |
10 |
RECORD_COUNTER |
Record counter associated with the record. |
NUMBER |
1 |
TIME_MONTH_KEY |
Time month key associated with the record. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |