XLA_FSN_BAL_HEADERS_GT
This table is used by the Accounting Engine to perform intercompany balancing.
Details
-
Schema: FUSION
-
Object owner: XLA
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| AE_HEADER_ID | NUMBER | 18 | Yes | Accounting entry identifier to be balanced. | |
| LEDGER_ID | NUMBER | 18 | Yes | Self-contained accounting information set for single or multiple legal or management entities. | |
| BASE_LEDGER_ID | NUMBER | 18 | Yes | Ledger of the accounting entry. | |
| JE_CATEGORY_NAME | VARCHAR2 | 25 | Yes | Journal category of the accounting entry. | |
| ACCOUNTING_DATE | DATE | Yes | Date, that is referenced from Oracle Fusion General Ledger, used to determine the accounting period for transactions. | ||
| PERIOD_NAME | VARCHAR2 | 15 | Period that contains the accounting entry. | ||
| CHART_OF_ACCOUNTS_ID | NUMBER | 18 | Yes | Chart of accounts identifier of the primary or reporting currency ledger owned by the accounting entry. | |
| LGR_CURRENCY_CODE | VARCHAR2 | 15 | Yes | Currency of the primary or reporting currency ledger owned by the accounting entry. | |
| EVENT_NUMBER | NUMBER | 18 | Yes | Event number of the event owned by the accounting entry. | |
| MAX_LINE_NUM | NUMBER | 18 | Yes | Maximum line number used in this accounting entry. | |
| NEED_BAL_CODE | VARCHAR2 | 30 | Indicates whether intercompany is necessary. Also, indicates whether this is a transaction reversal or transaction line reversal. N: No intercompany, Y: Intercompany. | ||
| PARTITION_GROUP_CODE | VARCHAR2 | 15 | Partition grouping information which determines the database partition in which large accounting entries will be stored temporarily for processing by the accounting engine. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| XLA_FSN_BAL_HEADERS_GT_U1 | Unique | AE_HEADER_ID |