XLA_LEDGER_OPTIONS_GT
This table stores the relationship of all applications/ledgers to the partition_group_code. This is used for internal processing only.
Details
-
Schema: FUSION
-
Object owner: XLA
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
XLA_LEDGER_OPTIONS_GT_PK |
LEDGER_ID, APPLICATION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| LEDGER_ID | NUMBER | 18 | Yes | Ledger identifier. This is used for internal processing only. | |
| APPLICATION_ID | NUMBER | 18 | Yes | Subledger application identifier. | |
| PARTITION_GROUP_CODE | VARCHAR2 | 15 | Yes | Partition grouping information for this application and ledger, which, when combined with the journal or balance period, determines the database partition in which journals or balances for this application and ledger are stored. | |
| ADDITIONAL_INFORMATION1 | VARCHAR2 | 30 | Additional information column. This is used for internal processing only. | ||
| ADDITIONAL_INFORMATION2 | VARCHAR2 | 30 | Additional information column. This is used for internal processing only. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| XLA_LEDGER_OPTIONS_GT_U1 | Unique | LEDGER_ID, APPLICATION_ID |