XLA_BAL_PERIOD_STATS_GT
This table is used by the balance calculation program to store the status of accounting period.
Details
-
Schema: FUSION
-
Object owner: XLA
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
XLA_BAL_PERIOD_STATS_GT_PK |
LEDGER_ID, PERIOD_NAME |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| LEDGER_ID | NUMBER | 18 | Yes | Self-contained accounting information set for single or multiple legal or management entities. | |
| PERIOD_NAME | VARCHAR2 | 15 | Yes | Fiscal period that reports financial results, such as a calendar month or fiscal period. | |
| PERIOD_YEAR | NUMBER | 18 | Yes | Fiscal year a company uses to report financial results. | |
| EFFECTIVE_PERIOD_NUM | NUMBER | 18 | Yes | Effective period number of the latest period for which the opening of the balances has been completed successfully for the ledger, application and balance source. | |
| FIRST_PERIOD_IN_YEAR_FLAG | VARCHAR2 | 1 | Yes | Indicates whether it is the first period in the year. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| XLA_BAL_PERIOD_STATS_GT_U1 | Unique | LEDGER_ID, PERIOD_NAME |