XLA_VALIDATION_LINES_GT
The XLA_VALIDATION_LINES_GT table is used internally for journal entry creation validation.
Details
-
Schema: FUSION
-
Object owner: XLA
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| EVENT_ID | NUMBER | 18 | Yes | Identifier of the categorization of accounting events that is unique within an application and event class. | |
| ENTITY_ID | NUMBER | 18 | Identifies subledger transactions associated with the accounting events. | ||
| AE_HEADER_ID | NUMBER | 18 | Yes | Subledger journal entry identifier. | |
| AE_LINE_NUM | NUMBER | 18 | Subledger journal entry line number. | ||
| DISPLAYED_LINE_NUMBER | NUMBER | 18 | Line number of subledger journal entry line that is displayed. | ||
| MAX_AE_LINE_NUM | NUMBER | 18 | Max value of accounting entry line number. | ||
| MAX_DISPLAYED_LINE_NUMBER | NUMBER | 18 | Max value of displayed accounting line number. | ||
| ACCOUNTING_BATCH_ID | NUMBER | 18 | Acconting program batch identifier. | ||
| ACCOUNTING_DATE | DATE | Date, referenced from Oracle Fusion General Ledger, used to determine the accounting period for transactions. | |||
| ACCOUNTING_CLASS_CODE | VARCHAR2 | 30 | Short name of a lookup type that is shared across application used to classify journal entry lines. | ||
| BALANCE_TYPE_CODE | VARCHAR2 | 1 | Balance type. Actual, Budget, or Encumbrance. | ||
| JE_CATEGORY_NAME | VARCHAR2 | 25 | Group of journal entries with similar characteristics such allocations, accruals, or revenues. | ||
| BUDGET_VERSION_ID | NUMBER | 18 | Unique identifier of budget version. | ||
| LEDGER_ID | NUMBER | 18 | Self-contained accounting information set for single or multiple legal or management entities. | ||
| LEDGER_CATEGORY_CODE | VARCHAR2 | 30 | Abbreviated name of a ledger category. | ||
| LEDGER_NAME | VARCHAR2 | 30 | Self-contained accounting information set for single or multiple legal or management entities. | ||
| LEDGER_CURRENCY_CODE | VARCHAR2 | 15 | Currency used for accounting and reporting in a ledger, often referred to as the accounting currency, base currency, or functional currency. | ||
| LEDGER_COA_ID | NUMBER | 18 | Ledger chart of accounts identifier. | ||
| BAL_SEG_COLUMN_NAME | VARCHAR2 | 25 | Name a database table column to store an accounting flexfield segment that is used to automatically balance all journal entries for each value of this segment. | ||
| MGT_SEG_COLUMN_NAME | VARCHAR2 | 25 | Oracle internal use only. | ||
| ALLOW_INTERCOMPANY_POST_FLAG | VARCHAR2 | 1 | Allow intercompany posting flag. | ||
| SLA_BAL_BY_LEDGER_CURR_FLAG | VARCHAR2 | 1 | Balance by ledger currency flag. | ||
| SLA_LEDGER_CUR_BAL_SUS_CCID | NUMBER | 18 | Oracle internal use only. | ||
| SLA_ENTERED_CUR_BAL_SUS_CCID | NUMBER | 18 | Oracle internal use only. | ||
| ENTERED_CURRENCY_CODE | VARCHAR2 | 15 | Oracle internal use only. | ||
| ENTERED_CURR_ENABLED_FLAG | VARCHAR2 | 1 | Indicates whether entered currency is enabled. | ||
| ENTERED_DR | NUMBER | Entered currency debit amount on a journal entry line. | |||
| ENTERED_CR | NUMBER | Entered currency credit amount on a journal entry line. | |||
| ACCOUNTED_DR | NUMBER | Accounted debit amount for a journal entry line. | |||
| ACCOUNTED_CR | NUMBER | Accounted crebit amount for a journal entry line. | |||
| 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. | |||
| PARTY_TYPE_CODE | VARCHAR2 | 1 | Abbreviated name for a party type. | ||
| PARTY_ID | NUMBER | 18 | Identifier of additional party that participates in a business relationship. | ||
| 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_ID_VALID_FLAG | VARCHAR2 | 1 | Valid party identifier indicator. | ||
| PARTY_SITE_ID_VALID_FLAG | VARCHAR2 | 1 | Valid party site identifier indicator. | ||
| CODE_COMBINATION_ID | NUMBER | 18 | Unique identifier of an accounting flexfield segment. | ||
| BAL_SEG_VALUE | VARCHAR2 | 25 | Value of the segment in the chart of accounts flexfields where transactions will be balanced for each of the values in the segment. | ||
| MGT_SEG_VALUE | VARCHAR2 | 25 | Oracle internal use only. | ||
| CCID_COA_ID | NUMBER | 18 | Identifier of the account structure your organization uses to record transactions and maintain account balances. | ||
| CCID_SUMMARY_FLAG | VARCHAR2 | 1 | Code combination id summary flag. | ||
| CCID_ENABLED_FLAG | VARCHAR2 | 1 | Code combination id enabled flag. | ||
| DETAIL_POSTING_ALLOWED_FLAG | VARCHAR2 | 1 | Indicates whether detail posting in general ledger is allowed. | ||
| DETAIL_BUDGETING_ALLOWED_FLAG | VARCHAR2 | 1 | Indicates whether detail budgeting is alloweed. | ||
| CONTROL_ACCOUNT_ENABLED_FLAG | VARCHAR2 | 25 | Indicates whethere the subledger is enabled for control account. | ||
| BUDGET_CCID_VALID_FLAG | VARCHAR2 | 1 | Budget code combination id valid flag. | ||
| ACCESS_SET_SV_VALID_FLAG | VARCHAR2 | 1 | Oracle internal use only. | ||
| BAL_SEG_VALID_STATUS | NUMBER | 18 | Indicates if balancing segment is in valid status. | ||
| MGT_SEG_VALID_STATUS | NUMBER | 18 | Oracle internal use only. | ||
| VALIDATE_IND_SEG_VAL_FLAG | VARCHAR2 | 1 | Oracle internal use only. | ||
| BALANCING_LINE_TYPE | VARCHAR2 | 1 | Yes | Indicates the source of balancing line creation. | |
| EVENT_TYPE_CODE | VARCHAR2 | 30 | Unique abbreviated name assigned to an event type and used for reporting or in reference to an option. | ||
| PRODUCT_RULE_CODE | VARCHAR2 | 30 | Short name of a product rule that contains effective accounting rules that are valid for a specific assignment date. | ||
| PRODUCT_RULE_TYPE_CODE | VARCHAR2 | 1 | Unique abbreviated name assigned to indicate whether the product rule is created by user or predefined by the application. | ||
| ERROR_FLAG | VARCHAR2 | 1 | Indicates whether error is marked on the journal line. | ||
| UNROUNDED_ACCOUNTED_DR | NUMBER | Unrounded accounted debit amount. | |||
| UNROUNDED_ACCOUNTED_CR | NUMBER | Unrounded credit amount in base currency. | |||
| SUBSTITUTED_CCID | NUMBER | 18 | Substituted accounting code combination identifier. | ||
| GAIN_OR_LOSS_FLAG | VARCHAR2 | 1 | Determines whether gain or loss amount calculation is performed. | ||
| SUBSTITUTED_BY_SUSPENSE_FLAG | VARCHAR2 | 1 | Substituted by suspense account flag. | ||
| SUSPENSE_CODE_COMBINATION_ID | NUMBER | 18 | Suspense account code combination identifier. | ||
| UNROUNDED_ENTERED_CR | NUMBER | Unrounded credit amount in entered currency. | |||
| UNROUNDED_ENTERED_DR | NUMBER | Unrounded debit amount in entered currency. | |||
| ENTERED_CURRENCY_MAU | NUMBER | Oracle internal use only. | |||
| 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). | ||
| ACCOUNTING_ENTRY_STATUS_CODE | VARCHAR2 | 30 | Tracks the status of the accounting entries generated from events. | ||
| FUNDS_STATUS_CODE | VARCHAR2 | 30 | Short name of status values assigned to fund check performed on journal entries. | ||
| PERIOD_NAME | VARCHAR2 | 30 | Fiscal period a company uses to report financial results, such as a calendar month or fiscal period. | ||
| COST_CENTER_SEG_VALUE | VARCHAR2 | 25 | Cost center segment value of an account. | ||
| NATURAL_ACCOUNT_SEG_VALUE | VARCHAR2 | 25 | Natural account segment value of an account. | ||
| PARTITION_GROUP_CODE | VARCHAR2 | 15 | Partition grouping information which determines the database partition in which the journal entry validation information will be stored. |