XLA_BAL_AC_CTRBS_GT
This is a temporary table which is used internally by Oracle.
Details
-
Schema: FUSION
-
Object owner: XLA
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| APPLICATION_ID | NUMBER | 18 | Yes | Functional area within a software suite of products. For example, Financials or Payroll. | |
| LEDGER_ID | NUMBER | 18 | Yes | Self-contained accounting information set for single or multiple legal or management entities. | |
| 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. | |
| CODE_COMBINATION_ID | NUMBER | 18 | Yes | Unique identifier of an accounting flexfield segment. | |
| ANALYTICAL_CRITERION_CODE | VARCHAR2 | 30 | Yes | Supporting reference short name. | |
| ANALYTICAL_CRITERION_TYPE_CODE | VARCHAR2 | 1 | Yes | Supporting reference type code. Values are User: the supporting reference is defined by the user; System: the supporting reference is defined by the product team and is made available as a seeded data. | |
| AMB_CONTEXT_CODE | VARCHAR2 | 30 | Yes | Accounting methods builder context. | |
| AC1 | VARCHAR2 | 30 | Oracle internal use only. | ||
| AC2 | VARCHAR2 | 30 | Oracle internal use only. | ||
| AC3 | VARCHAR2 | 30 | Oracle internal use only. | ||
| AC4 | VARCHAR2 | 30 | Oracle internal use only. | ||
| AC5 | VARCHAR2 | 30 | Oracle internal use only. | ||
| 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. | |
| CONTRIBUTION_DR | NUMBER | Contribution debit balance amount. | |||
| CONTRIBUTION_CR | NUMBER | Contribution credit balance amount. | |||
| NET_CONTRIBUTION_DR | NUMBER | Net contribution debit balance amount. | |||
| NET_CONTRIBUTION_CR | NUMBER | Net contribution credit balance amount. | |||
| BALANCE_STATUS_EFF_PER_NUM | NUMBER | 18 | Yes | Oracle internal use only. | |
| ACCOUNT_TYPE | VARCHAR2 | 1 | Classification of whether an account segment value of an account distribution is an asset, liability, equity, revenue or expense account |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| XLA_BAL_AC_CTRBS_GT_U1 | Unique | LEDGER_ID, APPLICATION_ID, EFFECTIVE_PERIOD_NUM, CODE_COMBINATION_ID, ANALYTICAL_CRITERION_CODE, ANALYTICAL_CRITERION_TYPE_CODE, AMB_CONTEXT_CODE, AC1, AC2, AC3, AC4, AC5 |