XLA_AE_LINES_GT
This table contains the subledger journal entry lines during accounting creation.
Details
-
Schema: FUSION
-
Object owner: XLA
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
XLA_AE_LINES_GT_PK |
LEDGER_ID, REF_AE_HEADER_ID, TEMP_LINE_NUM, AE_HEADER_ID, HEADER_NUM |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| AE_HEADER_ID | NUMBER | 18 | Yes | Subledger journal entry identifier. | |
| TEMP_LINE_NUM | NUMBER | 18 | Yes | Temporary line number that is used for processing. | |
| AE_LINE_NUM | NUMBER | 18 | Subledger journal entry line number. | ||
| LINE_HASH_NUM | NUMBER | 18 | Oracle internal use only. | ||
| EVENT_ID | NUMBER | 18 | Identifier of the categorization of accounting events that is unique within an application and event class. | ||
| REF_EVENT_ID | NUMBER | 18 | Identifier of a reference event. | ||
| REF_AE_HEADER_ID | NUMBER | 18 | Yes | Identifier of reference accounting entry header. | |
| REF_AE_LINE_NUM | NUMBER | 18 | Reference accounting entry line number. | ||
| ACCOUNTING_CLASS_CODE | VARCHAR2 | 30 | Short name of a lookup type that is shared across the application and used to classify journal entry lines. | ||
| EVENT_CLASS_CODE | VARCHAR2 | 30 | Unique abbreviated name assigned to an event class and used for reporting or in reference to an option. | ||
| EVENT_TYPE_CODE | VARCHAR2 | 30 | Unique abbreviated name assigned to an event type and used for reporting or in reference to an option. | ||
| LINE_DEFINITION_OWNER_CODE | VARCHAR2 | 30 | Abbreviated name of the person who creates the line definition. | ||
| LINE_DEFINITION_CODE | VARCHAR2 | 30 | Abbreviated name of a subledger journal line definition. | ||
| ACCOUNTING_LINE_TYPE_CODE | VARCHAR2 | 1 | Unique abbreviated name assigned to a journal line rule and used for reporting or in reference to an option. | ||
| ACCOUNTING_LINE_CODE | VARCHAR2 | 30 | Unique abbreviated name assigned to a journal line rule and used for reporting or in reference to an option. | ||
| ACCOUNTING_LINE_NAME | VARCHAR2 | 80 | Name of a rule to convert transactional data into a journal entry line. | ||
| CODE_COMBINATION_STATUS_CODE | VARCHAR2 | 30 | Accounting code combination status code. | ||
| CODE_COMBINATION_ID | NUMBER | 18 | Accounting code combination identifier. | ||
| SWITCH_SIDE_FLAG | VARCHAR2 | 1 | Determines whether negative amounts will result in negative amounts on the same side or positive amounts on the opposite side. | ||
| CCID_COA_ID | NUMBER | 18 | Identifier of the account structure your organization uses to record transactions and maintain account balances. | ||
| SEGMENT1 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT2 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT3 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT4 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT5 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT6 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT7 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT8 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT9 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT10 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT11 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT12 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT13 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT14 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT15 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT16 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT17 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT18 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT19 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT20 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT21 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT22 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT23 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT24 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT25 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT26 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT27 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT28 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT29 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT30 | VARCHAR2 | 30 | Key Flexfield: segment of the key flexfield. | ||
| DESCRIPTION | VARCHAR2 | 1996 | Additional information on accounting journal entry line. | ||
| GL_TRANSFER_MODE_CODE | VARCHAR2 | 1 | Unique abbreviated name assigned to denote the general ledger transfer mode. | ||
| MERGE_DUPLICATE_CODE | VARCHAR2 | 1 | Unique abbreviated name that indicates merge duplicate value on journal entry line. | ||
| PARTY_ID | NUMBER | 18 | Identifier that refers to any business unit or organization representing both sides of a contract, whether internal or external. | ||
| PARTY_SITE_ID | NUMBER | 18 | Identifier that refers to the name given to represent the location where a person or organization can be reached. | ||
| PARTY_TYPE_CODE | VARCHAR2 | 1 | A unique abbreviated name assigned to a classification used to categorize a party. For example, organization, individual, group, or relationship. | ||
| ENTERED_AMOUNT | NUMBER | Subledger journal entry line amount in entered currency. | |||
| ENTERED_DR | NUMBER | Debit amount in entered currency. | |||
| ENTERED_CR | NUMBER | Credit amount in entered currency. | |||
| ACCOUNTED_DR | NUMBER | Subledger journal entry line accounted debit amount. | |||
| ACCOUNTED_CR | NUMBER | Subledger journal entry line accounted credit amount. | |||
| STATISTICAL_AMOUNT | NUMBER | Amount entered in a journal that is based on the unit of measure. | |||
| CURRENCY_CODE | VARCHAR2 | 15 | Three-letter ISO code associated with a currency. | ||
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | Source of a currency conversion rate, such as user defined, spot, or corporate. | ||
| CURRENCY_CONVERSION_DATE | DATE | Date as of which a conversion rate is used to convert an amount into another currency. | |||
| CURRENCY_CONVERSION_RATE | NUMBER | Ratio at which the principal unit of one currency can be converted into another currency. | |||
| USSGL_TRANSACTION_CODE | VARCHAR2 | 30 | United States Standard General Ledger transaction code. | ||
| JGZZ_RECON_REF | VARCHAR2 | 240 | System-assigned identifier used for reconciliation matching. | ||
| SOURCE_DISTRIBUTION_ID_CHAR_1 | VARCHAR2 | 240 | Source distribution identifier 1. | ||
| SOURCE_DISTRIBUTION_ID_CHAR_2 | VARCHAR2 | 240 | Source distribution identifier 2. | ||
| SOURCE_DISTRIBUTION_ID_CHAR_3 | VARCHAR2 | 240 | Source distribution identifier 3. | ||
| SOURCE_DISTRIBUTION_ID_CHAR_4 | VARCHAR2 | 240 | Source distribution identifier 4. | ||
| SOURCE_DISTRIBUTION_ID_CHAR_5 | VARCHAR2 | 240 | Source distribution identifier 5. | ||
| SOURCE_DISTRIBUTION_ID_NUM_1 | NUMBER | 18 | Source distribution identifier 1. | ||
| SOURCE_DISTRIBUTION_ID_NUM_2 | NUMBER | 18 | Source distribution identifier 2. | ||
| SOURCE_DISTRIBUTION_ID_NUM_3 | NUMBER | 18 | Source distribution identifier 3. | ||
| SOURCE_DISTRIBUTION_ID_NUM_4 | NUMBER | 18 | Source distribution identifier 4. | ||
| SOURCE_DISTRIBUTION_ID_NUM_5 | NUMBER | 18 | Source distribution identifier 5. | ||
| SOURCE_DISTRIBUTION_TYPE | VARCHAR2 | 30 | Transaction source distribution type. | ||
| TAX_LINE_REF_ID | NUMBER | 18 | Identifier of tax line reference. | ||
| TAX_SUMMARY_LINE_REF_ID | NUMBER | 18 | Internal reference identifier of tax summary line. | ||
| TAX_REC_NREC_DIST_REF_ID | NUMBER | 18 | Internal reference identifier of tax distribution. | ||
| ANALYTICAL_BALANCE_FLAG | VARCHAR2 | 1 | Flag for analytical balances. Null indicates not eligible for balance calculation. P indicates balance calculation pending. Y indicates balance calculation done. | ||
| BALANCE_TYPE_CODE | VARCHAR2 | 30 | Yes | Type of balances. Valid values are Actual, Budget, and Encumbrance. | |
| MERGE_INDEX | NUMBER | 18 | Index used to merge journal entry lines. | ||
| LEDGER_ID | NUMBER | 18 | Yes | Identifier for a self-contained accounting information set for single or multiple legal or management entities. | |
| ENTITY_ID | NUMBER | 18 | Identifies subledger transactions associated with the accounting events. | ||
| EVENT_NUMBER | NUMBER | 18 | Identifying number of an accounting event. | ||
| ACCOUNTING_ENTRY_STATUS_CODE | VARCHAR2 | 30 | Abbreviated name to indicate the status of an accounting entry. | ||
| REVERSAL_CODE | VARCHAR2 | 30 | Unique abbreviated name to indicate a reversal journal entry line. | ||
| CALCULATE_ACCTD_AMTS_FLAG | VARCHAR2 | 1 | Calculated accounted amount flag. | ||
| CALCULATE_G_L_AMTS_FLAG | VARCHAR2 | 1 | Oracle internal use only. | ||
| GAIN_OR_LOSS_FLAG | VARCHAR2 | 1 | Indicates whether a journal line is a gain or loss line. | ||
| ROUNDING_CLASS_CODE | VARCHAR2 | 30 | Oracle internal use only. | ||
| DOCUMENT_ROUNDING_LEVEL | VARCHAR2 | 30 | Oracle internal use only. | ||
| UNROUNDED_ACCOUNTED_DR | NUMBER | Unrounded debit amount in base currency. | |||
| UNROUNDED_ACCOUNTED_CR | NUMBER | Unrounded credit amount in base currency. | |||
| UNROUNDED_ENTERED_DR | NUMBER | Unrounded debit amount in entered currency. | |||
| UNROUNDED_ENTERED_CR | NUMBER | Unrounded credit amount in entered currency. | |||
| DOC_ROUNDING_ENTERED_AMT | NUMBER | Oracle internal use only. | |||
| DOC_ROUNDING_ACCTD_AMT | NUMBER | Oracle internal use only. | |||
| ENTERED_CURRENCY_MAU | NUMBER | Oracle internal use only. | |||
| INHERIT_DESC_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the description will be inherited or copied from the corresponding or prior entry journal entry line. | |
| REF_TEMP_LINE_NUM | NUMBER | 18 | Reference temporary accounting line number. | ||
| MPA_ACCRUAL_ENTRY_FLAG | VARCHAR2 | 1 | Multiperiod accrual entry flag. | ||
| ENCUMBRANCE_TYPE_ID | NUMBER | 18 | Identifier of an encumbrance category that allows you to track your encumbrances or anticipated expenditures according to your purchase approval process and to more accurately control your planned expenditures. Examples of encumbrance types are commitments (requisition encumbrances) and obligations (purchase order encumbrances). | ||
| HEADER_NUM | NUMBER | 18 | Yes | Header number of a journal entry line. | |
| ACCOUNTING_DATE | DATE | Date, that is referenced from Oracle Fusion General Ledger, used to determine the accounting period for transactions. | |||
| CONTROL_BALANCE_FLAG | VARCHAR2 | 1 | Indicates whether a a journal line supports a specific, none, or all third party types. | ||
| BUSINESS_CLASS_CODE | VARCHAR2 | 30 | Unique abbreviated name assigned to a business class and used for reporting or in reference to an option. | ||
| PARTITION_GROUP_CODE | VARCHAR2 | 15 | Partition grouping information which determines the database partition in which accounting journal entry line information will be stored temporarily for further processing by other programs. | ||
| PERIOD_NAME | VARCHAR2 | 15 | Accounting period of the accounting entry. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| XLA_AE_LINES_GT_N1 | Non Unique | LEDGER_ID, AE_HEADER_ID, TEMP_LINE_NUM, BALANCE_TYPE_CODE |
| XLA_AE_LINES_GT_N2 | Non Unique | LEDGER_ID, AE_HEADER_ID, GAIN_OR_LOSS_FLAG, CALCULATE_G_L_AMTS_FLAG |
| XLA_AE_LINES_GT_N3 | Non Unique | LEDGER_ID, AE_HEADER_ID, BALANCE_TYPE_CODE, GAIN_OR_LOSS_FLAG, EVENT_ID |
| XLA_AE_LINES_GT_U1 | Unique | LEDGER_ID, REF_AE_HEADER_ID, TEMP_LINE_NUM, AE_HEADER_ID, HEADER_NUM |