| Subledger Accounting - XLA_GL_TRANSFER_BATCHES_ALL | Transferred Batches History Table. Maintains the log of the transfers submitted. |
|---|---|
| Column Name | Descritpion |
| REQUEST_ID | Concurrent Program Request Id |
| INTERFACE_RUN_ID | Journal Import Processing defining column |
| GROUP_ID | Interface group defining column |
| ORG_ID | Operating Unit ID |
| LEGAL_ENTITY_ID | Legal Entity Id. Used for CST transfer |
| COST_TYPE_ID | Cost Type Id. Used for CST transfer. |
| COST_GROUP_ID | Cost Group ID Used for CST transfer |
| TRANSFER_STATUS | Describes the transfer status. 'P' - The transfer is in progress, 'C' - The transfer completed successfully, 'N' - No rows are created. |
| PACKET_ID | Budgetary control packet defining column. |
| APPLICATION_ID | Calling Application ID |
| USER_ID | User Id |
| SELECTION_TYPE | Describes the transfer type. e.g. 1-Batch Transfer 2- Document Invoice Specific Transfer |
| SET_OF_BOOKS_ID | Id of the Set of Books |
| BATCH_NAME | Transfer batch Name |
| SOURCE_ID | The Id of the source document. |
| SOURCE_TABLE | Source entity that accounting event is linked to |
| GL_TRANSFER_RUN_ID | Transfer Run Id for a Batch. Unique for each set of book |
| TRANSFER_FROM_DATE | Transfer start date |
| TRANSFER_TO_DATE | Transfer end date. Used together with the transfer start date to set the transfer date range |
| AE_CATEGORY | Describes the journal category of the document |
| GL_TRANSFER_MODE | Describes the mode in which the transfer was submitted. D - Detail, A- Summarized by accounting date, P- Summarized by accounting period |
| SUBMIT_JOURNAL_IMPORT | Specifies whether journal import to be submitted immediately after the transfer |
| SUMMARY_JOURNAL_ENTRY | Specifies whether journal import should summarize the entries. |
| PROCESS_DAYS | Describes number of days to be processed in one commit cycle. |
| GL_TRANSFER_DATE | Date on which the transfer was submitted (System date) |
| GLLEZL_REQUEST_ID | Journal Import Request Id |
| Subledger Accounting - XLA_GL_TRANSFER_PROGRAMS | GL Transfer program definition. Stores runtime parameters for a transfer program. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Calling application ID. |
| ACCOUNT_VALIDATION_FLAG | If set to 'Y' the transfer will perform account validation for each accounting entry line being transferred. |
| PERIOD_STATUS_TABLE_NAME | Describes the table name that has accounting periods information |
| JE_SOURCE_NAME | Journal Entry Source Name e.g. Payables, Periodic Inventory etc. |
| PRE_COMMIT_API_NAME | Sub Ledger API to be called before commiting changes. |
| ENTRY_TYPE | Indicates accounting entry types created by the application. |
| PROGRAM_NAME | Uniquely identifies the calling application. |
| Subledger Accounting - XLA_GL_TRANSFER_PROGRAM_LINES | GL Transfer program definition details. |
|---|---|
| Column Name | Descritpion |
| ACCT_EVENTS_TABLE_NAME | Accounting Events Table Name |
| AE_HEADERS_TABLE_NAME | Accounting Entry Headers table Name |
| AE_LINES_TABLE_NAME | Accounting Entry Lines table name |
| AE_ENCUMBRANCE_TABLE_NAME | Encumbrance entries table Name |
| AE_LINES_LINKID_SEQ_NAME | Link Id sequence name for Actual entries |
| AE_ENC_LINES_LINKID_SEQ_NAME | Link Id sequence name for encumbrance entries |
| AE_LINES_TABLE_ALIAS | Table alias for actual accounting entries table |
| AE_ENC_TABLE_ALIAS | Table alias for encumbrance accounting entries table |
| PROGRAM_NAME | Uniquely identifies the calling application. |
| Subledger Accounting - XLA_AE_HEADERS | The XLA_AE_HEADERS table stores subledger journal entries. There is a one-to-many relationship between accounting events and journal entry headers. |
|---|---|
| Column Name | Descritpion |
| AE_HEADER_ID | Accounting entry id |
| JE_CATEGORY_NAME | General Ledger category name |
| ACCOUNTING_ENTRY_STATUS_CODE | Accounting entry status code |
| ACCOUNTING_ENTRY_TYPE_CODE | Accounting entry type code |
| AMB_CONTEXT_CODE | Accounting Methods Builder context. |
| PRODUCT_RULE_TYPE_CODE | Application Accounting Definition type code, not applicable for manual adjustments |
| PRODUCT_RULE_CODE | Application Accounting Definition type code, not applicable for manual adjustments |
| PRODUCT_RULE_VERSION | Version of the rules, not applicable for manual adjustments |
| DESCRIPTION | Description |
| DOC_SEQUENCE_ID | Sub-Ledger document sequence identifier |
| DOC_SEQUENCE_VALUE | Sub-Ledger document sequence value |
| APPLICATION_ID | Internal Id of the application |
| ACCOUNTING_BATCH_ID | Accounting Program batch Id |
| COMPLETION_ACCT_SEQ_VERSION_ID | Subledger journal entry creation sequence Identifier |
| CLOSE_ACCT_SEQ_VERSION_ID | Accounting entry reporting sequence |
| COMPLETION_ACCT_SEQ_VALUE | Subledger journal entry creation sequence Value |
| CLOSE_ACCT_SEQ_VALUE | Accounting entry reporting sequence Value |
| BUDGET_VERSION_ID | Budget version defining column |
| FUNDS_STATUS_CODE | Funds checker status |
| ENCUMBRANCE_TYPE_ID | Encumbrance type identifier |
| BALANCE_TYPE_CODE | Balance type (Actual, Budget, or Encumbrance) |
| REFERENCE_DATE | Accounting Entry reference Date. |
| LEDGER_ID | Ledger id |
| COMPLETED_DATE | Subledger journal entry completion date |
| PERIOD_NAME | Subledger journal entry period name. |
| PACKET_ID | Budgetary control packet defining column. |
| COMPLETION_ACCT_SEQ_ASSIGN_ID | Journal entry completion sequence assignment identifier |
| CLOSE_ACCT_SEQ_ASSIGN_ID | Journal entry reporting sequence assignment identifier |
| DOC_CATEGORY_CODE | Document sequence category category code. It used as part of the subledger journal entry sequencing criteria. |
| ATTRIBUTE_CATEGORY | Descriptive Flexfield structure defining column. |
| ATTRIBUTE1 | Descriptive Flexfield segment column. |
| ATTRIBUTE2 | Descriptive Flexfield segment column. |
| ATTRIBUTE3 | Descriptive Flexfield segment column. |
| ENTITY_ID | Entity id |
| ATTRIBUTE4 | Descriptive Flexfield segment column. |
| ATTRIBUTE5 | Descriptive Flexfield segment column. |
| ATTRIBUTE6 | Descriptive Flexfield segment column. |
| ATTRIBUTE7 | Descriptive Flexfield segment column. |
| ATTRIBUTE8 | Descriptive Flexfield segment column. |
| ATTRIBUTE9 | Descriptive Flexfield segment column. |
| ATTRIBUTE10 | Descriptive Flexfield segment column. |
| ATTRIBUTE11 | Descriptive Flexfield segment column. |
| ATTRIBUTE12 | Descriptive Flexfield segment column. |
| ATTRIBUTE13 | Descriptive Flexfield segment column. |
| EVENT_ID | Event id |
| ATTRIBUTE14 | Descriptive Flexfield segment column. |
| ATTRIBUTE15 | Descriptive Flexfield segment column. |
| GROUP_ID | Interface group identifying column. |
| DOC_SEQUENCE_VERSION_ID | Document sequence identifier |
| DOC_SEQUENCE_ASSIGN_ID | Document sequence assignment identifier |
| CREATION_DATE | Standard Who Column |
| CREATED_BY | Standard Who Column |
| LAST_UPDATE_DATE | Standard Who Column |
| LAST_UPDATED_BY | Standard Who Column |
| LAST_UPDATE_LOGIN | Standard Who Column |
| EVENT_TYPE_CODE | Event type code |
| PROGRAM_UPDATE_DATE | Extended Who Column |
| PROGRAM_APPLICATION_ID | Extended Who Column |
| PROGRAM_ID | Extended Who Column |
| REQUEST_ID | Extended Who Column |
| UPG_BATCH_ID | Upgrade batch identifier |
| UPG_SOURCE_APPLICATION_ID | Internal Id of the Upgrading application |
| UPG_VALID_FLAG | Flag to indicate if Validation was successfully run for the batch |
| ZERO_AMOUNT_FLAG | Indicate whether the entry is a zero-amount entry. |
| PARENT_AE_HEADER_ID | The journal entry header id of the parent entry. |
| PARENT_AE_LINE_NUM | The journal entry line number of the parent entry. |
| ACCOUNTING_DATE | Accounting date |
| ACCRUAL_REVERSAL_FLAG | |
| MERGE_EVENT_ID | |
| NEED_BAL_FLAG | |
| GL_TRANSFER_STATUS_CODE | General Ledger transfer status code |
| GL_TRANSFER_DATE | General Ledger transfer date |
| Subledger Accounting - XLA_AE_LINES | The XLA_AE_LINES table stores the subledger journal entry lines. There is a one-to-many relationship between subledger journal entry headers and subledger journal entry lines. |
|---|---|
| Column Name | Descritpion |
| AE_HEADER_ID | |
| PARTY_TYPE_CODE | |
| ENTERED_DR | |
| ENTERED_CR | |
| ACCOUNTED_DR | |
| ACCOUNTED_CR | |
| DESCRIPTION | |
| STATISTICAL_AMOUNT | |
| CURRENCY_CODE | |
| CURRENCY_CONVERSION_DATE | |
| CURRENCY_CONVERSION_RATE | |
| AE_LINE_NUM | |
| CURRENCY_CONVERSION_TYPE | |
| USSGL_TRANSACTION_CODE | |
| JGZZ_RECON_REF | |
| CONTROL_BALANCE_FLAG | |
| ANALYTICAL_BALANCE_FLAG | |
| ATTRIBUTE_CATEGORY | |
| ATTRIBUTE1 | |
| ATTRIBUTE2 | |
| ATTRIBUTE3 | |
| ATTRIBUTE4 | |
| APPLICATION_ID | |
| ATTRIBUTE5 | |
| ATTRIBUTE6 | |
| ATTRIBUTE7 | |
| ATTRIBUTE8 | |
| ATTRIBUTE9 | |
| ATTRIBUTE10 | |
| ATTRIBUTE11 | |
| ATTRIBUTE12 | |
| ATTRIBUTE13 | |
| ATTRIBUTE14 | |
| CODE_COMBINATION_ID | |
| ATTRIBUTE15 | |
| GL_SL_LINK_TABLE | |
| DISPLAYED_LINE_NUMBER | |
| CREATION_DATE | |
| CREATED_BY | |
| LAST_UPDATE_DATE | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_LOGIN | |
| PROGRAM_UPDATE_DATE | |
| PROGRAM_APPLICATION_ID | |
| GL_TRANSFER_MODE_CODE | |
| PROGRAM_ID | |
| REQUEST_ID | |
| UPG_BATCH_ID | |
| UPG_TAX_REFERENCE_ID1 | |
| UPG_TAX_REFERENCE_ID2 | |
| UPG_TAX_REFERENCE_ID3 | |
| UNROUNDED_ACCOUNTED_DR | |
| UNROUNDED_ACCOUNTED_CR | |
| GAIN_OR_LOSS_FLAG | |
| UNROUNDED_ENTERED_DR | |
| GL_SL_LINK_ID | |
| UNROUNDED_ENTERED_CR | |
| SUBSTITUTED_CCID | |
| BUSINESS_CLASS_CODE | |
| MPA_ACCRUAL_ENTRY_FLAG | |
| ENCUMBRANCE_TYPE_ID | |
| FUNDS_STATUS_CODE | |
| MERGE_CODE_COMBINATION_ID | |
| MERGE_PARTY_ID | |
| MERGE_PARTY_SITE_ID | |
| ACCOUNTING_DATE | |
| ACCOUNTING_CLASS_CODE | |
| LEDGER_ID | |
| SOURCE_TABLE | |
| SOURCE_ID | |
| ACCOUNT_OVERLAY_SOURCE_ID | |
| PARTY_ID | |
| PARTY_SITE_ID |
| Subledger Accounting - XLA_AE_LINES_GT | |
|---|---|
| Column Name | Descritpion |
| AE_HEADER_ID | |
| EVENT_CLASS_CODE | |
| ANC_ID_8 | |
| ANC_ID_9 | |
| ANC_ID_10 | |
| ANC_ID_11 | |
| ANC_ID_12 | |
| ANC_ID_13 | |
| ANC_ID_14 | |
| ANC_ID_15 | |
| ANC_ID_16 | |
| ANC_ID_17 | |
| EVENT_TYPE_CODE | |
| ANC_ID_18 | |
| ANC_ID_19 | |
| ANC_ID_20 | |
| ANC_ID_21 | |
| ANC_ID_22 | |
| ANC_ID_23 | |
| ANC_ID_24 | |
| ANC_ID_25 | |
| ANC_ID_26 | |
| ANC_ID_27 | |
| LINE_DEFINITION_OWNER_CODE | |
| ANC_ID_28 | |
| ANC_ID_29 | |
| ANC_ID_30 | |
| ANC_ID_31 | |
| ANC_ID_32 | |
| ANC_ID_33 | |
| ANC_ID_34 | |
| ANC_ID_35 | |
| ANC_ID_36 | |
| ANC_ID_37 | |
| LINE_DEFINITION_CODE | |
| ANC_ID_38 | |
| ANC_ID_39 | |
| ANC_ID_40 | |
| ANC_ID_41 | |
| ANC_ID_42 | |
| ANC_ID_43 | |
| ANC_ID_44 | |
| ANC_ID_45 | |
| ANC_ID_46 | |
| ANC_ID_47 | |
| ACCOUNTING_LINE_TYPE_CODE | |
| ANC_ID_48 | |
| ANC_ID_49 | |
| ANC_ID_50 | |
| ANC_ID_51 | |
| ANC_ID_52 | |
| ANC_ID_53 | |
| ANC_ID_54 | |
| ANC_ID_55 | |
| ANC_ID_56 | |
| ANC_ID_57 | |
| ACCOUNTING_LINE_CODE | |
| ANC_ID_58 | |
| ANC_ID_59 | |
| ANC_ID_60 | |
| ANC_ID_61 | |
| ANC_ID_62 | |
| ANC_ID_63 | |
| ANC_ID_64 | |
| ANC_ID_65 | |
| ANC_ID_66 | |
| ANC_ID_67 | |
| ACCOUNTING_LINE_NAME | |
| ANC_ID_68 | |
| ANC_ID_69 | |
| ANC_ID_70 | |
| ANC_ID_71 | |
| ANC_ID_72 | |
| ANC_ID_73 | |
| ANC_ID_74 | |
| ANC_ID_75 | |
| ANC_ID_76 | |
| ANC_ID_77 | |
| CODE_COMBINATION_STATUS_CODE | |
| ANC_ID_78 | |
| ANC_ID_79 | |
| ANC_ID_80 | |
| ANC_ID_81 | |
| ANC_ID_82 | |
| ANC_ID_83 | |
| ANC_ID_84 | |
| ANC_ID_85 | |
| ANC_ID_86 | |
| ANC_ID_87 | |
| CODE_COMBINATION_ID | |
| ANC_ID_88 | |
| ANC_ID_89 | |
| ANC_ID_90 | |
| ANC_ID_91 | |
| ANC_ID_92 | |
| ANC_ID_93 | |
| ANC_ID_94 | |
| ANC_ID_95 | |
| ANC_ID_96 | |
| ANC_ID_97 | |
| SL_COA_MAPPING_NAME | |
| ANC_ID_98 | |
| ANC_ID_99 | |
| ANC_ID_100 | |
| BALANCE_TYPE_CODE | |
| MERGE_INDEX | |
| LEDGER_ID | |
| ENTITY_ID | |
| REVERSE_DIST_ID_CHAR_1 | |
| REVERSE_DIST_ID_CHAR_2 | |
| REVERSE_DIST_ID_CHAR_3 | |
| TEMP_LINE_NUM | |
| DYNAMIC_INSERT_FLAG | |
| REVERSE_DIST_ID_CHAR_4 | |
| REVERSE_DIST_ID_CHAR_5 | |
| REVERSE_DIST_ID_NUM_1 | |
| REVERSE_DIST_ID_NUM_2 | |
| REVERSE_DIST_ID_NUM_3 | |
| REVERSE_DIST_ID_NUM_4 | |
| REVERSE_DIST_ID_NUM_5 | |
| REVERSE_DISTRIBUTION_TYPE | |
| EVENT_NUMBER | |
| ACCOUNTING_ENTRY_STATUS_CODE | |
| SWITCH_SIDE_FLAG | |
| REVERSAL_CODE | |
| CALCULATE_ACCTD_AMTS_FLAG | |
| CALCULATE_G_L_AMTS_FLAG | |
| GAIN_OR_LOSS_FLAG | |
| ROUNDING_CLASS_CODE | |
| DOCUMENT_ROUNDING_LEVEL | |
| UNROUNDED_ACCOUNTED_DR | |
| UNROUNDED_ACCOUNTED_CR | |
| EXTRACT_LINE_NUM | |
| ALT_CODE_COMBINATION_ID | |
| SOURCE_COA_ID | |
| ALT_SEGMENT1 | |
| ALT_SEGMENT2 | |
| ALT_SEGMENT3 | |
| ALT_SEGMENT4 | |
| ALT_SEGMENT5 | |
| ALT_SEGMENT6 | |
| ALT_SEGMENT7 | |
| ALT_SEGMENT8 | |
| ALT_SEGMENT9 | |
| ALT_SEGMENT10 | |
| CCID_COA_ID | |
| ALT_SEGMENT11 | |
| ALT_SEGMENT12 | |
| ALT_SEGMENT13 | |
| ALT_SEGMENT14 | |
| ALT_SEGMENT15 | |
| ALT_SEGMENT16 | |
| ALT_SEGMENT17 | |
| ALT_SEGMENT18 | |
| ALT_SEGMENT19 | |
| ALT_SEGMENT20 | |
| SEGMENT1 | |
| ALT_SEGMENT21 | |
| ALT_SEGMENT22 | |
| ALT_SEGMENT23 | |
| ALT_SEGMENT24 | |
| ALT_SEGMENT25 | |
| ALT_SEGMENT26 | |
| ALT_SEGMENT27 | |
| ALT_SEGMENT28 | |
| ALT_SEGMENT29 | |
| ALT_SEGMENT30 | |
| SEGMENT2 | |
| ALT_CCID_STATUS_CODE | |
| UNROUNDED_ENTERED_DR | |
| UNROUNDED_ENTERED_CR | |
| DOC_ROUNDING_ENTERED_AMT | |
| DOC_ROUNDING_ACCTD_AMT | |
| ENTERED_CURRENCY_MAU | |
| BUSINESS_METHOD_CODE | |
| BUSINESS_CLASS_CODE | |
| INHERIT_DESC_FLAG | |
| BFLOW_APPLICATION_ID | |
| SEGMENT3 | |
| BFLOW_ENTITY_CODE | |
| BFLOW_SOURCE_ID_NUM_1 | |
| BFLOW_SOURCE_ID_NUM_2 | |
| BFLOW_SOURCE_ID_NUM_3 | |
| BFLOW_SOURCE_ID_NUM_4 | |
| BFLOW_SOURCE_ID_CHAR_1 | |
| BFLOW_SOURCE_ID_CHAR_2 | |
| BFLOW_SOURCE_ID_CHAR_3 | |
| BFLOW_SOURCE_ID_CHAR_4 | |
| BFLOW_DISTRIBUTION_TYPE | |
| SEGMENT4 | |
| BFLOW_DIST_ID_NUM_1 | |
| BFLOW_DIST_ID_NUM_2 | |
| BFLOW_DIST_ID_NUM_3 | |
| BFLOW_DIST_ID_NUM_4 | |
| BFLOW_DIST_ID_NUM_5 | |
| BFLOW_DIST_ID_CHAR_1 | |
| BFLOW_DIST_ID_CHAR_2 | |
| BFLOW_DIST_ID_CHAR_3 | |
| BFLOW_DIST_ID_CHAR_4 | |
| BFLOW_DIST_ID_CHAR_5 | |
| SEGMENT5 | |
| BFLOW_PRIOR_ENTRY_STATUS_CODE | |
| SL_COA_MAPPING_ID | |
| NATURAL_SIDE_CODE | |
| TEMP_CURRENCY_CODE | |
| TEMP_REF_AE_HEADER_ID | |
| REF_TEMP_LINE_NUM | |
| APPLIED_TO_ENTITY_ID | |
| ALLOC_TO_APPLICATION_ID | |
| ALLOC_TO_ENTITY_CODE | |
| ALLOC_TO_SOURCE_ID_NUM_1 | |
| SEGMENT6 | |
| ALLOC_TO_SOURCE_ID_NUM_2 | |
| ALLOC_TO_SOURCE_ID_NUM_3 | |
| ALLOC_TO_SOURCE_ID_NUM_4 | |
| ALLOC_TO_SOURCE_ID_CHAR_1 | |
| ALLOC_TO_SOURCE_ID_CHAR_2 | |
| ALLOC_TO_SOURCE_ID_CHAR_3 | |
| ALLOC_TO_SOURCE_ID_CHAR_4 | |
| ALLOC_TO_DISTRIBUTION_TYPE | |
| ALLOC_TO_DIST_ID_NUM_1 | |
| ALLOC_TO_DIST_ID_NUM_2 | |
| AE_LINE_NUM | |
| SEGMENT7 | |
| ALLOC_TO_DIST_ID_NUM_3 | |
| ALLOC_TO_DIST_ID_NUM_4 | |
| ALLOC_TO_DIST_ID_NUM_5 | |
| ALLOC_TO_DIST_ID_CHAR_1 | |
| ALLOC_TO_DIST_ID_CHAR_2 | |
| ALLOC_TO_DIST_ID_CHAR_3 | |
| ALLOC_TO_DIST_ID_CHAR_4 | |
| ALLOC_TO_DIST_ID_CHAR_5 | |
| MPA_ACCRUAL_ENTRY_FLAG | |
| ENCUMBRANCE_TYPE_ID | |
| SEGMENT8 | |
| HEADER_NUM | |
| ACCOUNTING_DATE | |
| MULTIPERIOD_END_DATE | |
| MULTIPERIOD_START_DATE | |
| MULTIPERIOD_OPTION_FLAG | |
| GAIN_OR_LOSS_REF | Used to group entry lines together when calculating gain/loss. |
| BFLOW_APPLIED_TO_AMOUNT | Used in calculating the accounted amount when foreign exchange is used in business flow. |
| OVERRIDE_ACCTD_AMT_FLAG | |
| DERIVED_EXCH_RATE | |
| SEGMENT9 | |
| SEGMENT10 | |
| SEGMENT11 | |
| SEGMENT12 | |
| SEGMENT13 | |
| SEGMENT14 | |
| SEGMENT15 | |
| SEGMENT16 | |
| LINE_HASH_NUM | |
| SEGMENT17 | |
| SEGMENT18 | |
| SEGMENT19 | |
| SEGMENT20 | |
| SEGMENT21 | |
| SEGMENT22 | |
| SEGMENT23 | |
| SEGMENT24 | |
| SEGMENT25 | |
| SEGMENT26 | |
| EVENT_ID | |
| SEGMENT27 | |
| SEGMENT28 | |
| SEGMENT29 | |
| SEGMENT30 | |
| DESCRIPTION | |
| GL_TRANSFER_MODE_CODE | |
| MERGE_DUPLICATE_CODE | |
| PARTY_ID | |
| PARTY_SITE_ID | |
| PARTY_TYPE_CODE | |
| REF_EVENT_ID | |
| ENTERED_AMOUNT | |
| LEDGER_AMOUNT | |
| ENTERED_DR | |
| ENTERED_CR | |
| ACCOUNTED_DR | |
| ACCOUNTED_CR | |
| STATISTICAL_AMOUNT | |
| CURRENCY_CODE | |
| CURRENCY_CONVERSION_TYPE | |
| CURRENCY_CONVERSION_DATE | |
| REF_AE_HEADER_ID | |
| CURRENCY_CONVERSION_RATE | |
| USSGL_TRANSACTION_CODE | |
| JGZZ_RECON_REF | |
| SOURCE_DISTRIBUTION_ID_CHAR_1 | |
| SOURCE_DISTRIBUTION_ID_CHAR_2 | |
| SOURCE_DISTRIBUTION_ID_CHAR_3 | |
| SOURCE_DISTRIBUTION_ID_CHAR_4 | |
| SOURCE_DISTRIBUTION_ID_CHAR_5 | |
| SOURCE_DISTRIBUTION_ID_NUM_1 | |
| SOURCE_DISTRIBUTION_ID_NUM_2 | |
| REF_AE_LINE_NUM | |
| SOURCE_DISTRIBUTION_ID_NUM_3 | |
| SOURCE_DISTRIBUTION_ID_NUM_4 | |
| SOURCE_DISTRIBUTION_ID_NUM_5 | |
| SOURCE_DISTRIBUTION_TYPE | |
| TAX_LINE_REF_ID | |
| TAX_SUMMARY_LINE_REF_ID | |
| TAX_REC_NREC_DIST_REF_ID | |
| DEFERRED_INDICATOR | |
| DEFERRED_START_DATE | |
| DEFERRED_END_DATE | |
| ACCOUNTING_CLASS_CODE | |
| DEFERRED_NO_PERIOD | |
| DEFERRED_PERIOD_TYPE | |
| ANALYTICAL_BALANCE_FLAG | |
| ANC_ID_1 | |
| ANC_ID_2 | |
| ANC_ID_3 | |
| ANC_ID_4 | |
| ANC_ID_5 | |
| ANC_ID_6 | |
| ANC_ID_7 |
| Subledger Accounting - XLA_DISTRIBUTION_LINKS | The XLA_DISTRIBUTION_LINKS table stores the link between transactions and subledger journal entry lines. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Internal Id of the application |
| SOURCE_DISTRIBUTION_ID_CHAR_5 | Flexible source distribution id (Char) |
| SOURCE_DISTRIBUTION_ID_NUM_1 | Transaction source distribution identifer (Number) |
| SOURCE_DISTRIBUTION_ID_NUM_2 | Transaction source distribution identifer (Number) |
| SOURCE_DISTRIBUTION_ID_NUM_3 | Transaction source distribution identifer (Number) |
| SOURCE_DISTRIBUTION_ID_NUM_4 | Transaction source distribution identifer (Number) |
| SOURCE_DISTRIBUTION_ID_NUM_5 | Transaction source distribution identifer (Number) |
| TAX_LINE_REF_ID | Detail Tax Line Reference |
| TAX_SUMMARY_LINE_REF_ID | Summary Tax Line Reference |
| TAX_REC_NREC_DIST_REF_ID | Detail Tax Distribution Reference |
| STATISTICAL_AMOUNT | Statistical amount |
| EVENT_ID | Event Id |
| REF_AE_HEADER_ID | Reversed subledger journal entry header identifier. |
| REF_TEMP_LINE_NUM | |
| ACCOUNTING_LINE_CODE | Accounting line type code |
| ACCOUNTING_LINE_TYPE_CODE | |
| MERGE_DUPLICATE_CODE | Indicates how duplicate subledger journal lines are merged. The possible values are 'A' - Merge all lines 'W' - All matching debit lines will be merged and all matching credit lines will be merged to produce a single deb |
| TEMP_LINE_NUM | It is the intermediary line number generated by the accounting engine when the entries are in most detail form |
| REF_EVENT_ID | Reference EVENT_ID. For a reversal row it is the EVENT_ID from the actual AE line reversed otherwise it is NULL |
| LINE_DEFINITION_OWNER_CODE | Journal lines definition owner code |
| LINE_DEFINITION_CODE | Journal lines definition code |
| EVENT_CLASS_CODE | Event class code |
| AE_HEADER_ID | Subledger journal entry identifier |
| EVENT_TYPE_CODE | Event type code |
| UPG_BATCH_ID | Upgrade batch identifier |
| CALCULATE_ACCTD_AMTS_FLAG | Indicates whether the accounted amounts are calculated by SLA or passed through transaction objects. Y - indicates that accounted amounts are calculated by the accounting program. N- indicates that accounted amounts were passed through the |
| CALCULATE_G_L_AMTS_FLAG | Indicates whether the gain/loss amounts is calculated by the accounting engine. Y - indicates that gain/loss amounts are calculated by the accounting program. N- indicates that gain/loss amounts were passed through the extract. |
| ROUNDING_CLASS_CODE | The accounting class associated to the journal line. It is used as the grouping criteria for rounding. Accounting Program uses this field and the document_rounding_level together to group lines together to perform rounding. |
| DOCUMENT_ROUNDING_LEVEL | Indicates the document identifier for which the accounting engine must perform the rounding. Accounting Program uses this field and the rounding_class_code together to group lines together to perform rounding. |
| UNROUNDED_ENTERED_DR | Unrounded Entered Debit Amount for the journal line |
| UNROUNDED_ENTERED_CR | Unrounded Entered Credit Amount for the journal line |
| DOC_ROUNDING_ENTERED_AMT | The rounding amount for entered amount calculated by the accounting engine for the document |
| DOC_ROUNDING_ACCTD_AMT | The rounding amount for accounted amount calculated by the accounting engine for the document |
| AE_LINE_NUM | Subledger journal entry line number |
| UNROUNDED_ACCOUNTED_CR | |
| UNROUNDED_ACCOUNTED_DR | |
| APPLIED_TO_APPLICATION_ID | |
| APPLIED_TO_ENTITY_CODE | |
| APPLIED_TO_ENTITY_ID | |
| APPLIED_TO_SOURCE_ID_NUM_1 | |
| APPLIED_TO_SOURCE_ID_NUM_2 | |
| APPLIED_TO_SOURCE_ID_NUM_3 | |
| APPLIED_TO_SOURCE_ID_NUM_4 | |
| APPLIED_TO_SOURCE_ID_CHAR_1 | |
| SOURCE_DISTRIBUTION_TYPE | |
| APPLIED_TO_SOURCE_ID_CHAR_2 | |
| APPLIED_TO_SOURCE_ID_CHAR_3 | |
| APPLIED_TO_SOURCE_ID_CHAR_4 | |
| APPLIED_TO_DISTRIBUTION_TYPE | |
| APPLIED_TO_DIST_ID_NUM_1 | |
| APPLIED_TO_DIST_ID_NUM_2 | |
| APPLIED_TO_DIST_ID_NUM_3 | |
| APPLIED_TO_DIST_ID_NUM_4 | |
| APPLIED_TO_DIST_ID_NUM_5 | |
| APPLIED_TO_DIST_ID_CHAR_1 | |
| SOURCE_DISTRIBUTION_ID_CHAR_1 | Flexible source distribution id (Char) |
| APPLIED_TO_DIST_ID_CHAR_2 | |
| APPLIED_TO_DIST_ID_CHAR_3 | |
| APPLIED_TO_DIST_ID_CHAR_4 | |
| APPLIED_TO_DIST_ID_CHAR_5 | |
| ALLOC_TO_APPLICATION_ID | |
| ALLOC_TO_ENTITY_CODE | |
| ALLOC_TO_SOURCE_ID_NUM_1 | |
| ALLOC_TO_SOURCE_ID_NUM_2 | |
| ALLOC_TO_SOURCE_ID_NUM_3 | |
| ALLOC_TO_SOURCE_ID_NUM_4 | |
| SOURCE_DISTRIBUTION_ID_CHAR_2 | Flexible source distribution id (Char) |
| ALLOC_TO_SOURCE_ID_CHAR_1 | |
| ALLOC_TO_SOURCE_ID_CHAR_2 | |
| ALLOC_TO_SOURCE_ID_CHAR_3 | |
| ALLOC_TO_SOURCE_ID_CHAR_4 | |
| ALLOC_TO_DISTRIBUTION_TYPE | |
| ALLOC_TO_DIST_ID_NUM_1 | |
| ALLOC_TO_DIST_ID_NUM_2 | |
| ALLOC_TO_DIST_ID_NUM_3 | |
| ALLOC_TO_DIST_ID_NUM_4 | |
| ALLOC_TO_DIST_ID_NUM_5 | |
| SOURCE_DISTRIBUTION_ID_CHAR_3 | Flexible source distribution id (Char) |
| ALLOC_TO_DIST_ID_CHAR_1 | |
| ALLOC_TO_DIST_ID_CHAR_2 | |
| ALLOC_TO_DIST_ID_CHAR_3 | |
| ALLOC_TO_DIST_ID_CHAR_4 | |
| ALLOC_TO_DIST_ID_CHAR_5 | |
| GAIN_OR_LOSS_REF | Used to group entry lines together when calculating gain/loss. |
| SOURCE_DISTRIBUTION_ID_CHAR_4 | Flexible source distribution id (Char) |
| Subledger Accounting - XLA_EVENTS | The XLA_EVENTS table record all information related to a specific event. This table is created as a type XLA_ARRAY_EVENT_TYPE. |
|---|---|
| Column Name | Descritpion |
| EVENT_ID | Event Id |
| REFERENCE_NUM_3 | Additional reference (number) |
| REFERENCE_NUM_4 | Additional reference (number) |
| REFERENCE_CHAR_1 | Additional reference (char) |
| REFERENCE_CHAR_2 | Additional reference (char) |
| REFERENCE_CHAR_3 | Additional reference (char) |
| REFERENCE_CHAR_4 | Additional reference (char) |
| REFERENCE_DATE_1 | Additional reference (date) |
| REFERENCE_DATE_2 | Additional reference (date) |
| REFERENCE_DATE_3 | Additional reference (date) |
| REFERENCE_DATE_4 | Additional reference (date) |
| APPLICATION_ID | Internal Id of the application |
| EVENT_NUMBER | Event number |
| REQUEST_ID | Extended Who Column |
| ON_HOLD_FLAG | This flag indicates whether the event is on hold or not. possible values: (Y)--yes, (N)--No |
| CREATION_DATE | Standard Who Column |
| CREATED_BY | Standard Who Column |
| LAST_UPDATE_DATE | Standard Who Column |
| LAST_UPDATED_BY | Standard Who Column |
| LAST_UPDATE_LOGIN | Standard Who Column |
| PROGRAM_UPDATE_DATE | Extended Who Column |
| PROGRAM_APPLICATION_ID | Extended Who Column |
| PROGRAM_ID | Extended Who Column |
| EVENT_TYPE_CODE | Event type code |
| UPG_BATCH_ID | Upgrade batch identifier |
| UPG_SOURCE_APPLICATION_ID | Internal Id of the Upgrading application |
| UPG_VALID_FLAG | Flag to indicate if Validation was successfully run for the batch |
| TRANSACTION_DATE | Transaction Date |
| BUDGETARY_CONTROL_FLAG | Indicates if itis a budgetary control event |
| MERGE_EVENT_SET_ID | |
| EVENT_DATE | Event date |
| ENTITY_ID | Internal Identified of the entity |
| EVENT_STATUS_CODE | Event status code |
| PROCESS_STATUS_CODE | Processing status code |
| REFERENCE_NUM_1 | Additional reference (number) |
| REFERENCE_NUM_2 | Additional reference (number) |
| Subledger Accounting - XLA_EVENTS_INT_GT | It is an interface table used to create accounting events in bulk.It is a temporary table. The information in this table is deleted upon COMMIT. |
|---|---|
| Column Name | Descritpion |
| ENTITY_ID | |
| SOURCE_ID_INT_4 | |
| SOURCE_ID_CHAR_1 | |
| SOURCE_ID_CHAR_2 | |
| SOURCE_ID_CHAR_3 | |
| SOURCE_ID_CHAR_4 | |
| EVENT_ID | |
| EVENT_CLASS_CODE | |
| EVENT_TYPE_CODE | |
| EVENT_NUMBER | |
| EVENT_DATE | |
| APPLICATION_ID | |
| EVENT_STATUS_CODE | |
| PROCESS_STATUS_CODE | |
| REFERENCE_NUM_1 | |
| REFERENCE_NUM_2 | |
| REFERENCE_NUM_3 | |
| REFERENCE_NUM_4 | |
| REFERENCE_CHAR_1 | |
| REFERENCE_CHAR_2 | |
| REFERENCE_CHAR_3 | |
| REFERENCE_CHAR_4 | |
| LEDGER_ID | |
| REFERENCE_DATE_1 | |
| REFERENCE_DATE_2 | |
| REFERENCE_DATE_3 | |
| REFERENCE_DATE_4 | |
| VALUATION_METHOD | |
| SECURITY_ID_INT_1 | |
| SECURITY_ID_INT_2 | |
| SECURITY_ID_INT_3 | |
| SECURITY_ID_CHAR_1 | |
| SECURITY_ID_CHAR_2 | |
| LEGAL_ENTITY_ID | |
| SECURITY_ID_CHAR_3 | |
| ON_HOLD_FLAG | |
| TRANSACTION_DATE | |
| BUDGETARY_CONTROL_FLAG | |
| ENTITY_CODE | |
| TRANSACTION_NUMBER | |
| SOURCE_ID_INT_1 | |
| SOURCE_ID_INT_2 | |
| SOURCE_ID_INT_3 |
| Subledger Accounting - XLA_EVT_CLASS_ORDERS_GT | |
|---|---|
| Column Name | Descritpion |
| EVENT_CLASS_CODE | |
| PROCESSING_ORDER |
| Subledger Accounting - XLA_EVT_CLASS_SOURCES_GT | |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | |
| COLUMN_DATATYPE_CODE | |
| SOURCE_HASH_ID | |
| SOURCE_APPLICATION_ID | |
| REFERENCE_OBJECT_FLAG | |
| JOIN_CONDITION | |
| ENTITY_CODE | |
| EVENT_CLASS_CODE | |
| SOURCE_CODE | |
| SOURCE_DATATYPE_CODE | |
| SOURCE_LEVEL_CODE | |
| EXTRACT_OBJECT_NAME | |
| EXTRACT_OBJECT_TYPE_CODE | |
| ALWAYS_POPULATED_FLAG |
| Subledger Accounting - XLA_TRANSACTION_ACCTS_GT | |
|---|---|
| Column Name | Descritpion |
| LINE_NUMBER | |
| PROCESSING_STATUS_CODE | |
| SL_COA_MAPPING_ID | |
| AE_HEADER_ID | |
| TEMP_LINE_NUM | |
| LEDGER_ID | |
| SIDE_CODE | |
| CODE_COMBINATION_ID | |
| SEGMENT | |
| FROM_SEGMENT_CODE | |
| TO_SEGMENT_CODE |
| Subledger Accounting - XLA_TB_BALANCES_GT | Global temporary table to store the trial balance upgraded balance information. |
|---|---|
| Column Name | Descritpion |
| DEFINITION_CODE | Subledger trial balance report definition code |
| CODE_COMBINATION_ID | Account with the initial balance |
| BALANCE_DATE | The date the initial balance is effective |
| BALANCE_AMOUNT | The amount of the initial balance |
| LEDGER_ID | Ledger identifier against which the Open Account Balances Listing is generated. |
| DEFINITION_NAME | The Name for the Open Account Balances Listing report definition. |
| DEFINITION_DESC | The Description for the Open Account Balances Listing report definition. |
| Subledger Accounting - XLA_TRANSACTION_ENTITIES | The table XLA_ENTITIES contains information about sub-ledger document or transactions. |
|---|---|
| Column Name | Descritpion |
| ENTITY_ID | Entity id |
| SOURCE_ID_INT_1 | Flexible source id (Integer) |
| SOURCE_ID_CHAR_1 | Flexible source id (Char) |
| SECURITY_ID_INT_1 | Flexible security id (Integer) |
| SECURITY_ID_INT_2 | Flexible security id (Integer) |
| SECURITY_ID_INT_3 | Flexible security id (Integer) |
| SECURITY_ID_CHAR_1 | Flexible security id (Char) |
| SECURITY_ID_CHAR_2 | Flexible security id (Char) |
| SECURITY_ID_CHAR_3 | Flexible security id (Char) |
| SOURCE_ID_INT_2 | Flexible source id (Integer) |
| SOURCE_ID_CHAR_2 | Flexible source id (Char) |
| APPLICATION_ID | Internal id of the application |
| SOURCE_ID_INT_3 | Flexible source id (Integer) |
| SOURCE_ID_CHAR_3 | Flexible source id (Char) |
| SOURCE_ID_INT_4 | Flexible source id (Integer) |
| SOURCE_ID_CHAR_4 | Flexible source id (Char) |
| TRANSACTION_NUMBER | Transaction id |
| LEDGER_ID | Internal Identifier for the Ledger. |
| VALUATION_METHOD | Valuation Method |
| SOURCE_APPLICATION_ID | Source application identifier |
| UPG_BATCH_ID | Upgrade batch identifier |
| UPG_SOURCE_APPLICATION_ID | Internal Id of the Upgrading application |
| LEGAL_ENTITY_ID | Legal entity id |
| UPG_VALID_FLAG | Flag to indicate if Validation was successfully run for the batch |
| ENTITY_CODE | Entity code |
| CREATION_DATE | Standard Who Column |
| CREATED_BY | Standard Who Column |
| LAST_UPDATE_DATE | Standard Who Column |
| LAST_UPDATED_BY | Standard Who Column |
| LAST_UPDATE_LOGIN | Standard Who Column |
| Subledger Accounting - XLA_TRIAL_BALANCES | |
|---|---|
| Column Name | Descritpion |
| DEFINITION_CODE | |
| TRX_CURRENCY_CODE | |
| ENTERED_ROUNDED_DR | |
| ENTERED_ROUNDED_CR | |
| ENTERED_UNROUNDED_DR | |
| ENTERED_UNROUNDED_CR | |
| ACCTD_ROUNDED_DR | |
| ACCTD_ROUNDED_CR | |
| ACCTD_UNROUNDED_DR | |
| ACCTD_UNROUNDED_CR | |
| CODE_COMBINATION_ID | |
| LEDGER_ID | |
| BALANCING_SEGMENT_VALUE | |
| NATURAL_ACCOUNT_SEGMENT_VALUE | |
| COST_CENTER_SEGMENT_VALUE | |
| INTERCOMPANY_SEGMENT_VALUE | |
| MANAGEMENT_SEGMENT_VALUE | |
| PARTY_ID | |
| PARTY_SITE_ID | |
| PARTY_TYPE_CODE | |
| AE_HEADER_ID | |
| GENERATED_BY_CODE | |
| RECORD_TYPE_CODE | |
| SOURCE_VALUATION_METHOD | |
| APPLIED_VALUATION_METHOD | |
| CREATION_DATE | |
| CREATED_BY | |
| LAST_UPDATE_DATE | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_LOGIN | |
| REQUEST_ID | |
| PROGRAM_APPLICATION_ID | |
| PROGRAM_ID | |
| SOURCE_ENTITY_ID | |
| PROGRAM_UPDATE_DATE | |
| SOURCE_APPLICATION_ID | |
| APPLIED_TO_ENTITY_ID | |
| APPLIED_TO_APPLICATION_ID | |
| EVENT_CLASS_CODE | |
| GL_DATE |
| Subledger Accounting - XLA_VALIDATION_LINES_GT | |
|---|---|
| Column Name | Descritpion |
| EVENT_ID | |
| ACCOUNTING_CLASS_CODE | |
| BALANCE_TYPE_CODE | |
| JE_CATEGORY_NAME | |
| BUDGET_VERSION_ID | |
| LEDGER_ID | |
| LEDGER_CATEGORY_CODE | |
| LEDGER_NAME | |
| LEDGER_CURRENCY_CODE | |
| LEDGER_COA_ID | |
| BAL_SEG_COLUMN_NAME | |
| ENTITY_ID | |
| MGT_SEG_COLUMN_NAME | |
| ALLOW_INTERCOMPANY_POST_FLAG | |
| SLA_BAL_BY_LEDGER_CURR_FLAG | |
| SLA_LEDGER_CUR_BAL_SUS_CCID | |
| SLA_ENTERED_CUR_BAL_SUS_CCID | |
| ENTERED_CURRENCY_CODE | |
| ENTERED_CURR_ENABLED_FLAG | |
| ENTERED_DR | |
| ENTERED_CR | |
| ACCOUNTED_DR | |
| AE_HEADER_ID | |
| ACCOUNTED_CR | |
| CURRENCY_CONVERSION_TYPE | |
| CURRENCY_CONVERSION_DATE | |
| CURRENCY_CONVERSION_RATE | |
| PARTY_TYPE_CODE | |
| PARTY_ID | |
| PARTY_SITE_ID | |
| PARTY_ID_VALID_FLAG | |
| PARTY_SITE_ID_VALID_FLAG | |
| CODE_COMBINATION_ID | |
| AE_LINE_NUM | |
| BAL_SEG_VALUE | |
| MGT_SEG_VALUE | |
| CCID_COA_ID | |
| CCID_SUMMARY_FLAG | |
| CCID_ENABLED_FLAG | |
| DETAIL_POSTING_ALLOWED_FLAG | |
| DETAIL_BUDGETING_ALLOWED_FLAG | |
| CONTROL_ACCOUNT_ENABLED_FLAG | |
| BUDGET_CCID_VALID_FLAG | |
| ACCESS_SET_SV_VALID_FLAG | |
| DISPLAYED_LINE_NUMBER | |
| BAL_SEG_VALID_STATUS | |
| MGT_SEG_VALID_STATUS | |
| VALIDATE_IND_SEG_VAL_FLAG | |
| BALANCING_LINE_TYPE | |
| EVENT_TYPE_CODE | |
| PRODUCT_RULE_CODE | |
| PRODUCT_RULE_TYPE_CODE | |
| ERROR_FLAG | |
| UNROUNDED_ACCOUNTED_DR | |
| UNROUNDED_ACCOUNTED_CR | |
| MAX_AE_LINE_NUM | |
| SUBSTITUTED_CCID | |
| GAIN_OR_LOSS_FLAG | |
| SUBSTITUTED_BY_SUSPENSE_FLAG | |
| SUSPENSE_CODE_COMBINATION_ID | |
| UNROUNDED_ENTERED_CR | |
| UNROUNDED_ENTERED_DR | |
| ENTERED_CURRENCY_MAU | |
| ENCUMBRANCE_TYPE_ID | |
| ACCOUNTING_ENTRY_STATUS_CODE | |
| FUNDS_STATUS_CODE | |
| MAX_DISPLAYED_LINE_NUMBER | |
| PERIOD_NAME | |
| COST_CENTER_SEG_VALUE | |
| NATURAL_ACCOUNT_SEG_VALUE | |
| ACCOUNTING_BATCH_ID | |
| ACCOUNTING_DATE |
| Subledger Accounting - XLA_JE_LINE_TYPES | This table holds information for journal entry line types. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application identifier |
| LINE_TYPE_CODE | Line type identifier |
| SUMMARY_FLAG | Indicates whether the line should be summarized |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| Subledger Accounting - XLA_AADS_H | The XLA_AADS_H table stores the history of the application accounting definitions. The history is updated when the application accounting definitions are exported. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Internal identifier of the application |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| PROGRAM_UPDATE_DATE | Concurrent Program who column - date when a program last updated this row). |
| PROGRAM_APPLICATION_ID | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). |
| PROGRAM_ID | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). |
| REQUEST_ID | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
| PRODUCT_RULE_TYPE_CODE | Application accounting definition owner code. Possible value includes: S:Oracle C:Customer |
| PRODUCT_RULE_CODE | Application accounting definition code |
| VERSION_NUM | Version number |
| BASE_VERSION_NUM | The base version number |
| USER_VERSION | The version entered by the user |
| VERSION_COMMENT | Comment entered when the application accounting definition is exported. |
| LEAPFROG_FLAG | Indicates if the application accounting definition is a leapfrog. Possible values are Y or N. |
| OBJECT_VERSION_NUMBER | Standard WHO column |
| Subledger Accounting - XLA_AAD_GROUPS | The XLA_AAD_GROUPS table stores the merge dependencies analyzed during the merge analysis. All application accounting definitions with the same GROUP_NUM must be merged together. |
|---|---|
| Column Name | Descritpion |
| AMB_CONTEXT_CODE | AMB context code |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| PROGRAM_UPDATE_DATE | Concurrent Program who column - date when a program last updated this row). |
| PROGRAM_APPLICATION_ID | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). |
| PROGRAM_ID | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). |
| REQUEST_ID | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
| APPLICATION_ID | Internal identifier of the application |
| GROUP_NUM | Application accounting definition owner code. Possible value includes: S - Oracle C - Customer |
| PRODUCT_RULE_TYPE_CODE | Application accounting definition code. |
| PRODUCT_RULE_CODE | The group number of the application accounting definition |
| REQUIRED_FLAG | Required flag. The possible values are Y or N. |
| OBJECT_VERSION_NUMBER | Standard WHO column |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| Subledger Accounting - XLA_AAD_HDR_ACCT_ATTRS | The XLA_AAD_HDR_ACCT_ATTRS stores standard, system and custom sources assigned to an accounting attribute at the AAD level. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application Identifier |
| SOURCE_CODE | Source code |
| EVENT_CLASS_DEFAULT_FLAG | Flag to indicate if the value of source is a default from the accounting attribute assignments at event class. Possible values are Y (Yes) or N (No). |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| AMB_CONTEXT_CODE | Accounting Methods Builder context |
| PRODUCT_RULE_TYPE_CODE | Application Accounting Definition type code |
| PRODUCT_RULE_CODE | Application Accounting Definition code |
| EVENT_CLASS_CODE | Event Class Code |
| EVENT_TYPE_CODE | Event Type code |
| ACCOUNTING_ATTRIBUTE_CODE | Accounting Attribute code |
| SOURCE_APPLICATION_ID | Application identifier that owns the source |
| SOURCE_TYPE_CODE | Indicates whether it is a System, Standard or a Custom source. |
| Subledger Accounting - XLA_AAD_HEADER_AC_ASSGNS | Store the analytical criteria for the application accounting definitions. |
|---|---|
| Column Name | Descritpion |
| AMB_CONTEXT_CODE | AMB context code |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| APPLICATION_ID | Internal identifier of the application |
| PRODUCT_RULE_TYPE_CODE | Application Accounting definition owner code |
| PRODUCT_RULE_CODE | Application Accounting definition code |
| EVENT_CLASS_CODE | Event class code |
| EVENT_TYPE_CODE | Event type code |
| ANALYTICAL_CRITERION_TYPE_CODE | Journal line type code |
| ANALYTICAL_CRITERION_CODE | Analytical criterion owner code |
| OBJECT_VERSION_NUMBER | Standard OVN column |
| Subledger Accounting - XLA_AAD_LINE_DEFN_ASSGNS | This table stores the journal lines definitions for the application accounting definitions. |
|---|---|
| Column Name | Descritpion |
| AMB_CONTEXT_CODE | AMB context code |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| APPLICATION_ID | Internal identifier of the application |
| PRODUCT_RULE_TYPE_CODE | Application accounting definition owner code |
| PRODUCT_RULE_CODE | Application accounting definition code |
| EVENT_CLASS_CODE | Event class code |
| EVENT_TYPE_CODE | Event type code |
| LINE_DEFINITION_OWNER_CODE | Journal lines definition owner code |
| LINE_DEFINITION_CODE | Journal lines definition code |
| OBJECT_VERSION_NUMBER | Standard OVN column |
| Subledger Accounting - XLA_AAD_LOADER_DEFNS_T | The XLA_AAD_LOADER_DEFNS_T table is the interface table that facilitates the data transfer from data files and the database. |
|---|---|
| Column Name | Descritpion |
| AAD_LOADER_DEFINITION_ID | Internal id |
| ACCOUNTING_LINE_CODE | Accounting line code |
| VALUE_CCID_SEGMENT21 | Segment 21 of the the value code combination id |
| VALUE_CCID_SEGMENT22 | Segment 22 of the the value code combination id |
| VALUE_CCID_SEGMENT23 | Segment 23 of the the value code combination id |
| VALUE_CCID_SEGMENT24 | Segment 24 of the the value code combination id |
| VALUE_CCID_SEGMENT25 | Segment. 25 of the the value code combination id |
| VALUE_CCID_SEGMENT26 | Segment 26 of the the value code combination id |
| VALUE_CCID_SEGMENT27 | Segment 27 of the the value code combination id |
| VALUE_CCID_SEGMENT28 | Segment 28 of the the value code combination id |
| VALUE_CCID_SEGMENT29 | Segment 29 of the the value code combination id |
| VALUE_CCID_SEGMENT30 | Segment 30 of the the value code combination id |
| ACCOUNTING_LINE_TYPE_CODE | Accounting line type code |
| VALUE_CONSTANT | Constant |
| VALUE_CODE_COMBINATION_ID | The value code combination identifier |
| VALUE_FLEXFIELD_SEGMENT_CODE | Value flexfield segment code |
| VALUE_MAPPING_SET_CODE | Mapping set code |
| VALUE_SOURCE_APP_SHORT_NAME | Value source application |
| VALUE_SOURCE_CODE | Value source code |
| VALUE_SOURCE_TYPE_CODE | Value source type code |
| VALUE_TYPE_CODE | Value type code |
| VERSION_NUM | Version number |
| VERSION_COMMENT | Comment entered when the application accounting definition is exported |
| ACCOUNTING_METHOD_TYPE_CODE | Accounting method type code |
| VIEW_APP_SHORT_NAME | View application short name |
| VIEW_COLUMN_NUM | View column number |
| YEAR_END_CARRY_FORWARD_CODE | Year end carry forward code |
| OBJECT_VERSION_NUMBER | Standard Who column |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| PROGRAM_UPDATE_DATE | Concurrent Program who column - date when a program last updated this row). |
| ACCOUNTING_METHOD_CODE | Accounting method code |
| PROGRAM_APPLICATION_ID | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). |
| PROGRAM_ID | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). |
| REQUEST_ID | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
| LINE_DEFINITION_OWNER_CODE | Journal lines definition owner code |
| LINE_DEFINITION_CODE | Journal lines definition code |
| VALIDATION_STATUS_CODE | Validation status code |
| BUSINESS_METHOD_CODE | Business flow method code |
| BUSINESS_CLASS_CODE | Business flow class code |
| INHERIT_DESC_FLAG | Indicate if the description is inherited |
| INHERIT_ADR_FLAG | Indicate if the account derivation rule is inherited |
| ROUNDING_CLASS_CODE | Rounding class code |
| SIDE_CODE | Side code |
| VALUE_SEGMENT_RULE_APPL_ID | Attached segment rule application id |
| VALUE_SEGMENT_RULE_TYPE_CODE | Attached segment rule type code |
| VALUE_SEGMENT_RULE_CODE | Attached segment rule code |
| SEGMENT_RULE_APPL_ID | Segment rule application id |
| ADR_VERSION_NUM | Version number of the account derivation rule |
| VALUE_ADR_VERSION_NUM | Version number of the value account derivation rule |
| ACCOUNTING_REQUIRED_FLAG | Indicates if accounting is required for this product accounting definition and event class or type |
| SEGMENT_RULE_APPL_SN | Application short name of the account derivation rule |
| VALUE_SEGMENT_RULE_APPL_SN | Application short name of the value account derivation rule |
| ENCUMBRANCE_TYPE | Encumbrance type identifier |
| BUDGETARY_CONTROL_FLAG | Indicates if the journal lines definition is used in budgetary control |
| MPA_HEADER_DESC_CODE | Multiperiod header description code |
| MPA_HEADER_DESC_TYPE_CODE | Multiperiod header description owner code |
| MPA_NUM_JE_CODE | The number of multiperiod journal entries to be created |
| MPA_GL_DATES_CODE | Option which denotes how the GL date for the multiperiod journal entries are derived |
| MPA_PRORATION_CODE | Option which denotes how multiperiod journal entries should be prorated |
| MPA_OPTION_CODE | Multiperiod accounting option |
| MPA_ACCOUNTING_LINE_TYPE_CODE | Multiperiod journal line type owner |
| MPA_ACCOUNTING_LINE_CODE | Multiperiod journal line type |
| MPA_INHERIT_AC_FLAG | Indicate if the analytical criteria should be inherited for the multiperiod accounting entries. |
| ACTIVE_FLAG | Active flag |
| ANALYTICAL_CRITERION_CODE | Analytical criterion code |
| ANALYTICAL_CRITERION_TYPE_CODE | Analytical criterion type code |
| ANALYTICAL_DETAIL_CODE | Analytical criterion detail code |
| APPLICATION_SHORT_NAME | Application short name |
| STAGING_AMB_CONTEXT_CODE | AMB Context of the staging area |
| BALANCING_FLAG | Indicate whether balances should be maintained for the analytical criteria |
| BRACKET_LEFT_CODE | Left bracket code |
| BRACKET_RIGHT_CODE | Right bracket code |
| COMPILE_STATUS_CODE | Indicates the compile status of the application accounting definition |
| COMPONENT_CODE | The component code |
| COMPONENT_TYPE_CODE | The component type code |
| COMPONENT_OWNER_CODE | The component Owner code |
| CONDITION_NUM | Condition number (mapped to xla_conditions.user_sequence) |
| CRITERION_VALUE_CODE | Internal key for analytical criteria |
| DATA_TYPE_CODE | Data type code |
| TABLE_NAME | The table name of the information of the row belongs to with the exception of XLA_CONDITIONS table, which will be indentified by XLA_DESC_CONDITIONS, XLA_JLT_CONDITIONS, and XLA_ADR_CONDITIONS for the different component type |
| DESCRIPTION_CODE | Description code |
| DESCRIPTION_TYPE_CODE | Description type code |
| DISPLAY_DESCRIPTION_FLAG | Indicate if the flexfield segment is displayed with a meaning or a description |
| DISPLAY_IN_INQUIRIES_FLAG | Indicate if journal entry lines associated to this analytical criterion is displayed in the inquiries |
| DISPLAY_ORDER | Display order |
| EFFECTIVE_DATE_FROM | Effective start date |
| EFFECTIVE_DATE_TO | Effective end date |
| ENABLED_FLAG | Enabled flag |
| END_DATE_ACTIVE | Effective end date |
| ENTITY_CODE | Entity code |
| NAME | Name of the component |
| EVENT_CLASS_CODE | Event class code |
| EVENT_CLASS_DEFAULT_FLAG | Event class default flag |
| EVENT_TYPE_CODE | Event type code |
| FLEXFIELD_ASSIGN_MODE_CODE | Indicates whether to account by accounting flexfield or by segment |
| FLEXFIELD_SEGMENT_CODE | Flexfield segment code |
| FLEX_VALUE_SET_NAME | Flex value set code |
| GL_TRANSFER_MODE_CODE | General ledger transfer mode |
| GROUPING_ORDER | |
| INDEPENDENT_VALUE_CONSTANT | |
| INPUT_SOURCE_APP_SHORT_NAME | Source application short name |
| DESCRIPTION | Description of the component |
| INPUT_SOURCE_CODE | Source code |
| INPUT_SOURCE_TYPE_CODE | Source type code |
| INPUT_VALUE_CONSTANT | Constant |
| INPUT_VALUE_TYPE_CODE | Value type code |
| LEAPFROG_FLAG | Indicates if the application accounting definition is a leapfrog |
| LINE_OPERATOR_CODE | Line operator code |
| LITERAL | Translated text entered by the user |
| LOCKING_STATUS_FLAG | Indicates the locating status of the application accounting definition |
| LOGICAL_OPERATOR_CODE | Logical operator code |
| LOOKUP_TYPE | Lookup type |
| ACCOUNTING_ATTRIBUTE_CODE | Accounting attribute |
| MAPPING_SET_CODE | Mapping set code |
| MERGE_DUPLICATE_CODE | Indicate how duplicate accounting lines must be merged |
| NATURAL_SIDE_CODE | Natural side for the accounting line type |
| ORIG_LAST_UPDATE_DATE | The original last update date |
| OWNER | The owner of the record |
| BASE_VERSION_NUM | The base version number of the application accounting definition |
| PRIORITY_NUM | Description priority number (mapped to xla_desc_priorities. user_sequence) |
| PRODUCT_RULE_CODE | Application accounting definition code |
| PRODUCT_RULE_TYPE_CODE | Application accounting definition type code |
| PRODUCT_RULE_VERSION | Application accounting definition version |
| ACCOUNTING_CLASS_CODE | Accounting class code |
| SEGMENT_RULE_CODE | Segment rule code |
| SEGMENT_RULE_TYPE_CODE | Segment rule type code |
| SOURCE_APP_SHORT_NAME | Source application short name |
| SOURCE_CODE | Standard source internal code |
| SOURCE_TYPE_CODE | Indicates whether it is a seeded source of a derived source |
| START_DATE_ACTIVE | Effective start date |
| SWITCH_SIDE_FLAG | Indicate whether to switch side when amount is negative |
| TRANS_COA_ID_FLEX_STRUCT_CODE | Id flex structure code of the chart of accounts of the transaction |
| USER_SEQUENCE | User sequence (priority) |
| VALUE_CCID_ID_FLEX_STRUCT_CODE | Id flex code of the chart of accounts of the value code combination id |
| ACCT_COA_ID_FLEX_STRUCT_CODE | Id flex structure code of the chart of accounts for which the accounting is created |
| VALUE_CCID_SEGMENT1 | Segment 1 of the the value code combination id |
| VALUE_CCID_SEGMENT2 | Segment 2 of the the value code combination id |
| VALUE_CCID_SEGMENT3 | Segment 3 of the the value code combination id |
| VALUE_CCID_SEGMENT4 | Segment 4 of the the value code combination id |
| VALUE_CCID_SEGMENT5 | Segment 5 of the the value code combination id |
| VALUE_CCID_SEGMENT6 | Segment 6 of the the value code combination id |
| VALUE_CCID_SEGMENT7 | Segment 7 of the the value code combination id |
| VALUE_CCID_SEGMENT8 | Segment 8 of the the value code combination id |
| VALUE_CCID_SEGMENT9 | Segment 9 of the the value code combination id |
| VALUE_CCID_SEGMENT10 | Segment 10 of the the value code combination id |
| ACCOUNTING_ENTRY_TYPE_CODE | Accounting line type, for example Actual, Encumbrances or Budget |
| VALUE_CCID_SEGMENT11 | Segment 11 of the the value code combination id |
| VALUE_CCID_SEGMENT12 | Segment 12 of the the value code combination id |
| VALUE_CCID_SEGMENT13 | Segment 13 of the the value code combination id |
| VALUE_CCID_SEGMENT14 | Segment 14 of the the value code combination id |
| VALUE_CCID_SEGMENT15 | Segment 15 of the the value code combination id |
| VALUE_CCID_SEGMENT16 | Segment 16 of the the value code combination id |
| VALUE_CCID_SEGMENT17 | Segment 17 of the the value code combination id |
| VALUE_CCID_SEGMENT18 | Segment 18 of the the value code combination id |
| VALUE_CCID_SEGMENT19 | Segment 19 of the the value code combination id |
| VALUE_CCID_SEGMENT20 | Segment 20 of the the value code combination id |
| Subledger Accounting - XLA_AAD_LOADER_LOGS | The XLA_AAD_LOADER_LOGS table stores the errors and logs generated by the application accounting definitions loader. |
|---|---|
| Column Name | Descritpion |
| AAD_LOADER_LOG_ID | Internal identifier of the log |
| PRODUCT_RULE_CODE | Application accounting definition code |
| COMPONENT_TYPE_CODE | Component type code |
| COMPONENT_OWNER_CODE | Component owner code. Possible value includes:S - OracleC - Customer |
| COMPONENT_CODE | Component code |
| VERSION_FROM | The from version number |
| VERSION_TO | The to version number |
| ORIGINAL_CODE | The original component code |
| ORIGINAL_NAME | The original component name |
| OBJECT_VERSION_NUMBER | Standard WHO column |
| CREATION_DATE | Standard who column - date when this row was created. |
| AMB_CONTEXT_CODE | AMB context code |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| PROGRAM_UPDATE_DATE | Concurrent Program who column - date when a program last updated this row). |
| PROGRAM_APPLICATION_ID | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). |
| PROGRAM_ID | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). |
| REQUEST_ID | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
| APPLICATION_ID | Internal identifier of the application |
| REQUEST_CODE | Request type. Possible values are: IMPORTEXPORT OVERWRITEMERGEMERGE_ANALYSIS |
| LOG_TYPE_CODE | The type of the log. |
| ENCODED_MESSAGE | The error message |
| MESSAGE_NUM | The message number |
| AAD_APPLICATION_ID | The application of the application accounting definition |
| PRODUCT_RULE_TYPE_CODE | Application accounting definition owner code. Possible value includes:S:OracleC:Customer |
| Subledger Accounting - XLA_ACCOUNTING_ERRORS | The XLA_ACCOUNTING_ERRORS table stores the errors encountered during execution of the Accounting Program. |
|---|---|
| Column Name | Descritpion |
| EVENT_ID | Identifier for the Event |
| MESSAGE_NUMBER | Error message number |
| ERROR_SOURCE_CODE | Code for the sub-routine that generated the error message. |
| APPLICATION_ID | Internal Id of the Application |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| CREATION_DATE | Standard who column - date when this row was created. |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| PROGRAM_UPDATE_DATE | Concurrent Program who column - date when a program last updated this row). |
| PROGRAM_APPLICATION_ID | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). |
| PROGRAM_ID | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). |
| ACCOUNTING_ERROR_ID | Error internal identifier |
| REQUEST_ID | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
| ENTITY_ID | Identifier for the Entity |
| LEDGER_ID | Identifier for the Ledger |
| ACCOUNTING_BATCH_ID | Identifier for a Accounting Batch |
| ENCODED_MSG | Error Message as given by the FND API |
| AE_HEADER_ID | Subledger journal entry header identifier |
| AE_LINE_NUM | Subledger journal entry line identifier |
| Subledger Accounting - XLA_ACCTG_METHODS_B | The XLA_ACCTG_METHODS_B table stores Subledger Accounting Methods (SLAM) across products. SLAMs provided by development are not chart of accounts specific. Enabled SLAMs are assigned to ledgers. |
|---|---|
| Column Name | Descritpion |
| ACCOUNTING_METHOD_CODE | Accounting method code |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| TRANSACTION_COA_ID | Chart of accounts of the transaction |
| ACCOUNTING_COA_ID | Chart of accounts for which the accounting is created |
| ENABLED_FLAG | Internal flag. Enabled accounting method can be assigned to ledgers. |
| ACCOUNTING_METHOD_TYPE_CODE | Accounting method type code |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| Subledger Accounting - XLA_ACCTG_METHODS_TL | The XLA_ACCTG_METHODS_TL table stores translated information about Subledger Accounting Methods. |
|---|---|
| Column Name | Descritpion |
| ACCOUNTING_METHOD_CODE | Accounting method code |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| LANGUAGE | Standard Language code |
| NAME | Accounting method name |
| DESCRIPTION | Accounting method description |
| ACCOUNTING_METHOD_TYPE_CODE | Accounting method type code |
| SOURCE_LANG | Standard Source Language code |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| Subledger Accounting - XLA_ACCTG_METHOD_RULES | The XLA_ACCTG_METHODS_RULES table stores the assignments for all Application Accounting Definitions (AAD) within each Subledger Accounting Method. |
|---|---|
| Column Name | Descritpion |
| ACCOUNTING_METHOD_CODE | Accounting method code |
| START_DATE_ACTIVE | Effective start date |
| END_DATE_ACTIVE | Effective end date |
| APPLICATION_ID | Internal Id of the application |
| ACCTG_METHOD_RULE_ID | Accounting method, Application Accounting Definition internal identifier |
| AMB_CONTEXT_CODE | Accounting methods builder context. |
| PRODUCT_RULE_TYPE_CODE | Application Accounting Definition type code |
| PRODUCT_RULE_CODE | Application Accounting Definition code |
| ACCOUNTING_METHOD_TYPE_CODE | Accounting method type code |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| Subledger Accounting - XLA_ACCT_ATTRIBUTES_B | The XLA_ACCT_ATTRIBUTES_B table captures accounting attributes available to the end users. Accounting attributes are pre-defined by the Oracle Subledger Accounting Architecture. Oracle Subledger Accounting Architecture has identified accoun |
|---|---|
| Column Name | Descritpion |
| ACCOUNTING_ATTRIBUTE_CODE | Accounting Attribute code |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| INHERITED_FLAG | Decides whether the accounting attribute can be inherited from a prior journal entry. |
| DATATYPE_CODE | Accounting Attribute data type. Possible values are C (alphanumeric), N (Numeric), or D (Date) |
| JOURNAL_ENTRY_LEVEL_CODE | Code to indicate the level of sources that can be mapped to the accounting attribute. The possible values are H (Header Level), L (Line Level), or C (Ledger Currency Level) |
| ASSIGNMENT_EXTENSIBLE_FLAG | Flag to indicate if users can define assignments for the accounting attribute in context of an Oracle application. Possible values are Y (Yes) or N (No). |
| ASSIGNMENT_REQUIRED_CODE | Indicates if an assignment is mandatory. Possible values are Y (Mandatory) or N (Not mandatory), or G (Mandatory if any accounting attribute for the group is mapped). |
| ASSIGNMENT_GROUP_CODE | Group code for the accounting attribute |
| ASSIGNMENT_LEVEL_CODE | The level at which the assignments can be made for the accounting attribute. Possible values are EVT_CLASS_ONLY, JLT_ONLY, AAD_ONLY, EVT_CLASS_JLT, EVT_CLASS_AAD |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| Subledger Accounting - XLA_ACCT_ATTRIBUTES_TL | The XLA_ACCT_ATTRIBUTES_TL table captures translated values for the accounting attributes. Accounting attributes are pre-defined by Subledger Accounting. Accounting attributes are necessary to complete specific processing associated with th |
|---|---|
| Column Name | Descritpion |
| ACCOUNTING_ATTRIBUTE_CODE | Accounting Attribute code |
| LANGUAGE | Standard Language code |
| NAME | Accounting Attribute name (Translatable) |
| SOURCE_LANG | Standard Source Language code |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| Subledger Accounting - XLA_ACCT_LINE_TYPES_B | The XLA_ACCT_LINE_TYPES_B table stores line accounting types for an event class. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Internal Id of the application |
| ACCOUNTING_ENTRY_TYPE_CODE | Indicates the accounting line type, for example Actual, Encumbrances or budget |
| NATURAL_SIDE_CODE | Natural side for the accounting line type |
| GL_TRANSFER_MODE_CODE | General Ledger Transfer mode |
| SWITCH_SIDE_FLAG | Flag to indicate whether to switch side when the amount is negative |
| MERGE_DUPLICATE_CODE | Code to indicate how duplicate accounting lines must be merged |
| ENABLED_FLAG | Internal flag. Enabled accounting line types can be assigned to product rules |
| ACCOUNTING_CLASS_CODE | Accounting Class code i.e. Asset, Liability, Revenue, Expense. |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| AMB_CONTEXT_CODE | Accounting Methods Builder context. |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| ROUNDING_CLASS_CODE | The accounting class used by the accounting program as the basis for grouping journal lines when performing rounding. |
| BUSINESS_METHOD_CODE | Business Flow Method code |
| BUSINESS_CLASS_CODE | Business flow class code |
| MPA_OPTION_CODE | Multiperiod accounting option |
| ENCUMBRANCE_TYPE_ID | |
| GAIN_OR_LOSS_FLAG | To identify product calculated gain or loss so that the gain or loss amount provided in transaction objects will not be conterted to reporting currency and non valuation method secondary ledgers |
| ENTITY_CODE | Entity code |
| EVENT_CLASS_CODE | Event class code |
| ACCOUNTING_LINE_TYPE_CODE | Accounting line type code |
| ACCOUNTING_LINE_CODE | Accounting line code |
| TRANSACTION_COA_ID | Chart of accounts of the transaction |
| Subledger Accounting - XLA_ACCT_LINE_TYPES_TL | The XLA_ACCT_LINE_TYPES_TL table stores translated information about accounting line type definitions. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Internal Id of the application |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| AMB_CONTEXT_CODE | Accounting Methods Builder context. |
| ENTITY_CODE | Entity code |
| EVENT_CLASS_CODE | Event class code |
| ACCOUNTING_LINE_TYPE_CODE | Accounting line type code |
| ACCOUNTING_LINE_CODE | Accounting line code |
| LANGUAGE | Standard Language code |
| NAME | Line type name |
| DESCRIPTION | Line type description |
| SOURCE_LANG | Standard Source Language code |
| Subledger Accounting - XLA_AE_SEGMENT_VALUES | The XLA_AE_SEGMENT_VALUES table stores information about the balancing or management segment values associated with the journal entry. |
|---|---|
| Column Name | Descritpion |
| AE_HEADER_ID | Subledger journal entry header Id |
| SEGMENT_TYPE_CODE | Indicates the segment type. The segment type can have values B or M. (B)-Balancing Segment, (M)- Management Segment |
| SEGMENT_VALUE | Indicates the value of the balancing or the management segment. |
| AE_LINES_COUNT | Indicates the number of journal lines associated with the segment value. |
| UPG_BATCH_ID | Upgrade batch identifier |
| Subledger Accounting - XLA_AMB_COMPONENTS_H | The XLA_AMB_COMPONENTS_H table stores the history of the non-application specific journal entry setups, i.e. analytical criteria and mapping sets. The history is updated when the components are exported. |
|---|---|
| Column Name | Descritpion |
| COMPONENT_TYPE_CODE | Component type code |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| PROGRAM_UPDATE_DATE | Concurrent Program who column - date when a program last updated this row). |
| PROGRAM_APPLICATION_ID | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). |
| PROGRAM_ID | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). |
| REQUEST_ID | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
| LEAPFROG_FLAG | Indicate if the application accounting definition is a result of leapfrogging |
| APPLICATION_ID | Application internal identifier |
| COMPONENT_OWNER_CODE | Component owner code. Possible value includes:S - Oracle C - CustomerX - For journal entry setups that have no owner, e.g. mapping set, use 'X'. |
| COMPONENT_CODE | Component code |
| VERSION_NUM | Version number of the component |
| BASE_VERSION_NUM | The base version number of the Component |
| OBJECT_VERSION_NUMBER | Standard WHO column |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| Subledger Accounting - XLA_AMB_SETUP_ERRORS | The XLA_AMB_SETUP_ERRORS table stores errors reported by the Create and Assign Source program and the Application Accounting Definition validation program. |
|---|---|
| Column Name | Descritpion |
| AMB_ERROR_ID | Surrogate primary key |
| ENTITY_CODE | Entity Code |
| EVENT_CLASS_CODE | Event Class Code |
| EVENT_TYPE_CODE | Event Type Code |
| ACCOUNTING_LINE_TYPE_CODE | Owner for the Accounting Line Type |
| ACCOUNTING_LINE_CODE | Accounting Line Code |
| DESCRIPTION_TYPE_CODE | Owner for the description |
| DESCRIPTION_CODE | Description Code |
| ANALYTICAL_CRITERION_TYPE_CODE | Owner for the analytical criterion |
| ANALYTICAL_CRITERION_CODE | Analytical Criterion Code |
| SEGMENT_RULE_TYPE_CODE | Owner for the Segment Rule |
| MESSAGE_NAME | Gives the message name of the error or warning message |
| SEGMENT_RULE_CODE | Segment Rule Code |
| MAPPING_SET_CODE | Mapping Set Code |
| SOURCE_TYPE_CODE | Type of source |
| SOURCE_CODE | Source Code |
| EXTRACT_OBJECT_NAME | Extract Object Name |
| EXTRACT_OBJECT_TYPE_CODE | Extract Object Type |
| EXTRACT_COLUMN_NAME | This column is needed for the errors encountered during sources creation. |
| ACCOUNTING_SOURCE_CODE | Accounting Source Code |
| MAPPING_GROUP_CODE | Accounting Source Group Code |
| LANGUAGE | Standard Language Code |
| MESSAGE_TYPE_FLAG | Describes whether it is a warning or error. |
| PROGRAM_APPLICATION_ID | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). |
| PROGRAM_UPDATE_DATE | Concurrent Program who column - date when a program last updated this row). |
| PROGRAM_ID | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). |
| REQUEST_ID | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| CREATION_DATE | Standard who column - date when this row was created. |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LINE_DEFINITION_OWNER_CODE | Journal lines definition owner code |
| LINE_DEFINITION_CODE | Comment: Journal lines definition code |
| SOURCE_APPLICATION_ID | Source application id |
| CATEGORY_SEQUENCE_NUM | Describes the order in which the messages will be displayed. How is this column populated? How do you know how to order these categories? |
| MPA_ACCOUNTING_LINE_TYPE_CODE | Multiperiod journal line type owner code |
| MPA_ACCOUNTING_LINE_CODE | Multiperiod journal line type code |
| MESSAGE_CATEGORY_CODE | Describes the category of the message. |
| APPLICATION_ID | Application Identifier |
| AMB_CONTEXT_CODE | Development Context |
| PRODUCT_RULE_TYPE_CODE | Owner for the Application Accounting Definition |
| PRODUCT_RULE_CODE | Code for the Application Accounting Definition |
| Subledger Accounting - XLA_AMB_UPDATED_COMPS | The XLA_AMB_UPDATED_COMPS table stores the application accounting definitions and journal entry setups that has been updated. |
|---|---|
| Column Name | Descritpion |
| AMB_UPDATED_COMP_ID | Internal identifier of the updated component |
| PRODUCT_RULE_CODE | The application accounting definition code |
| ACCT_LINE_TYPE_CODE | The journal line owner code. Possible value includes:S - OracleC - Customer |
| ACCT_LINE_CODE | The journal line code |
| COMPONENT_OWNER_CODE | Component owner code. Possible value includes:S - OracleC - Customer |
| COMPONENT_CODE | Component code |
| MERGE_IMPACT_CODE | Merge impact code |
| PROPERTY_CODE | Property code |
| LOOKUP_TYPE | The lookup type of the property value |
| OLD_VALUE | The old value |
| NEW_VALUE | The new value |
| APPLICATION_ID | Internal identifier of the application |
| PARENT_COMPONENT_TYPE_CODE | Component type of the parent component. |
| PARENT_COMPONENT_KEY | Component key of the parent component |
| MERGE_ENABLED_FLAG | Indicate if the component is allowed to be merged to the working context |
| MERGE_FLAG | Indicate if the component is selected to be merged to the working context. Possible values are Y or N. |
| DUPLICATE_COMPONENT_CODE | If 'N' is selected for MERGE_FLAG, it is the new component type code of the diverged component |
| DUPLICATE_COMPONENT_NAME | If 'N' is selected for MERGE_FLAG, it is the new component name of the diverged component |
| OBJECT_VERSION_NUMBER | Standard WHO column |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| AMB_CONTEXT_CODE | AMB context code |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| PROGRAM_UPDATE_DATE | Concurrent Program who column - date when a program last updated this row). |
| PROGRAM_APPLICATION_ID | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). |
| PROGRAM_ID | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). |
| REQUEST_ID | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
| PARENT_COMPONENT_OWNER_CODE | Owner of the parent component |
| PARENT_COMPONENT_CODE | Component code of the parent component |
| OLD_SOURCE_APP_ID | Original source application id |
| OLD_SOURCE_TYPE_CODE | Original source type code |
| OLD_SOURCE_CODE | Original source code |
| NEW_SOURCE_APP_ID | New source application id |
| NEW_SOURCE_TYPE_CODE | New source type code |
| NEW_SOURCE_CODE | New source code |
| COMPONENT_APPLICATION_ID | Application identifier of the component |
| COMPONENT_TYPE_CODE | Component owner code. Possible value includes:S - OracleC - Customer |
| COMPONENT_KEY | The key to identify the component |
| ENTITY_CODE | The entity code |
| EVENT_CLASS_CODE | The event class code |
| EVENT_TYPE_CODE | The event type code |
| PRODUCT_RULE_TYPE_CODE | Application accounting definition owner code. Possible value includes:S - OracleC - Customer |
| Subledger Accounting - XLA_ANALYTICAL_ASSGNS | The XLA_ANALYTICAL_ASSGNS table stores the assignment between the Analytical Criteria and the Application Accounting Definition headers or the Application Accounting Definition lines. |
|---|---|
| Column Name | Descritpion |
| ANALYTICAL_CRITERION_CODE | Analytical Criteria code |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| ANALYTICAL_CRITERION_TYPE_CODE | Analytical Criteria type code |
| APPLICATION_ID | Internal Id of the application |
| AMB_CONTEXT_CODE | Accounting Methods Builder context. |
| PRODUCT_RULE_TYPE_CODE | Application rule type code |
| PRODUCT_RULE_CODE | Application rule code |
| ENTITY_CODE | Entity Code |
| ANALYTICAL_ASSIGNMENT_ID | Analytical detail value identifier |
| EVENT_CLASS_CODE | Event class code |
| EVENT_TYPE_CODE | Event type code |
| ACCOUNTING_LINE_TYPE_CODE | Line type code (it is null when the assignment is done to the header) |
| ACCOUNTING_LINE_CODE | Line code (it is null when the assignment is done to the header) |
| Subledger Accounting - XLA_ANALYTICAL_BALANCES | The XLA_ANALYTICAL_BALANCES table stores the balances for each analytical criterion. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Internal id of the application |
| BEGINNING_BALANCE_CR | Beginning balance for the period (CR) |
| PERIOD_BALANCE_DR | Current balance for the period (DR): made up of the period activity |
| PERIOD_BALANCE_CR | Current balance for the period (CR) ): made up of the period activity |
| DRAFT_BEGINNING_BALANCE_DR | Draft beginning balance for the period (DR) |
| DRAFT_BEGINNING_BALANCE_CR | Draft beginning balance for the period (CR) |
| PERIOD_DRAFT_BALANCE_DR | Current draft balance for the period (DR): made up of the period activity |
| PERIOD_DRAFT_BALANCE_CR | Current draft balance for the period (CR): made up of the period activity |
| INITIAL_BALANCE_FLAG | Flag that shows if this is an initial balanceY: initial balanceN: non initial balance |
| FIRST_PERIOD_FLAG | This flag indicates if this is the first period in a fiscal year for which balances have been calculated for a given key: Y: first period in a fiscal year N: not first period in a fiscal year |
| PERIOD_YEAR | Fiscal year of the period |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| LEDGER_ID | Ledger id |
| PROGRAM_UPDATE_DATE | Concurrent Program who column - date when a program last updated this row). |
| PROGRAM_APPLICATION_ID | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). |
| PROGRAM_ID | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). |
| REQUEST_ID | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
| CODE_COMBINATION_ID | Account Code combination id |
| ANALYTICAL_DETAIL_VALUE_ID | Analytical detail value identifier |
| PERIOD_NAME | Accounting period name |
| BEGINNING_BALANCE_DR | Beginning balance for the period (DR) |
| Subledger Accounting - XLA_ANALYTICAL_DTLS_B | The XLA_ANALYTICAL_DTLS_B table stores the translated header information (name and description) for the Analytical Criteria. |
|---|---|
| Column Name | Descritpion |
| ANALYTICAL_CRITERION_CODE | Analytical Criteria code |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| ANALYTICAL_CRITERION_TYPE_CODE | Analytical Criteria type code |
| ANALYTICAL_DETAIL_CODE | Analytical Criteria detail code |
| GROUPING_ORDER | Grouping order of the analytical details within an Analytical Criterion |
| AMB_CONTEXT_CODE | Accounting Methods Builder context. |
| DATA_TYPE_CODE | Data type of the analytical criterion detail, as derived based on the sources assigned to it and the value of the internal key or meaning of the analytical criterion: C: character D: date N: numeric |
| VIEW_COLUMN_NUM | Contains the corresponding column number in the view xla_analytical_criteria_v. The number is not absolute, rather it is relative to the data type. |
| Subledger Accounting - XLA_ANALYTICAL_DTLS_TL | The XLA_ANALYTICAL_DTLS_TL table stores the detail information for the Analytical Criterion. |
|---|---|
| Column Name | Descritpion |
| ANALYTICAL_CRITERION_CODE | Analytical Criteria code |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| ANALYTICAL_CRITERION_TYPE_CODE | Analytical Criteria type code |
| ANALYTICAL_DETAIL_CODE | Analytical Criterion Detail Code |
| LANGUAGE | Standard Language Code |
| AMB_CONTEXT_CODE | Accounting Methods Builder context. |
| SOURCE_LANG | Standard Source Language Code |
| NAME | Analytical Criteria detail name |
| DESCRIPTION | Analytical Criteria detail description |
| Subledger Accounting - XLA_ANALYTICAL_DTL_VALS | The XLA_ANALYTICAL_DTL_VALS table stores the existing values for the analytical criteria details based on the actual data on the sources for each subledger journal entry line. For example, if the analytical criterion 'Project Expense' has o |
|---|---|
| Column Name | Descritpion |
| ANALYTICAL_DETAIL_VALUE_ID | Analytical detail value identifier |
| ANALYTICAL_DETAIL_DATE_2 | Analytical detail value, date type |
| ANALYTICAL_DETAIL_DATE_3 | Analytical detail value, date type |
| ANALYTICAL_DETAIL_DATE_4 | Analytical detail value, date type |
| ANALYTICAL_DETAIL_DATE_5 | Analytical detail value, date type |
| ANALYTICAL_DETAIL_NUMBER_1 | Analytical detail value, number type |
| ANALYTICAL_DETAIL_NUMBER_2 | Analytical detail value, number type |
| ANALYTICAL_DETAIL_NUMBER_3 | Analytical detail value, number type |
| ANALYTICAL_DETAIL_NUMBER_4 | Analytical detail value, number type |
| ANALYTICAL_DETAIL_NUMBER_5 | Analytical detail value, number type |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| ANALYTICAL_CRITERION_CODE | Analytical Criteria code |
| ANALYTICAL_CRITERION_TYPE_CODE | Analytical Criteria type code |
| AMB_CONTEXT_CODE | Accounting Methods Builder context. |
| ANALYTICAL_DETAIL_CHAR_1 | Analytical detail value |
| ANALYTICAL_DETAIL_CHAR_2 | Analytical detail value |
| ANALYTICAL_DETAIL_CHAR_3 | Analytical detail value |
| ANALYTICAL_DETAIL_CHAR_4 | Analytical detail value |
| ANALYTICAL_DETAIL_CHAR_5 | Analytical detail value |
| ANALYTICAL_DETAIL_DATE_1 | Analytical detail value, date type |
| Subledger Accounting - XLA_ANALYTICAL_HDRS_B | This table stores the header information for the Analytical Criteria. Since some analytical criteria are delivered as seeded data by the product teams, the name and the description are subjected to translation, so there are two tables for t |
|---|---|
| Column Name | Descritpion |
| AMB_CONTEXT_CODE | Accounting methods builder context. |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| APPLICATION_ID | Internal Id of the application |
| ANALYTICAL_CRITERION_CODE | Analytical Criterion code |
| ANALYTICAL_CRITERION_TYPE_CODE | Analytical Criterion type code. Values are:User: the analytical criterion is defined by the user.System: the analytical criterion is defined by the product team and is made available as a seeded data. |
| BALANCING_FLAG | Y: balances are maintained for this Analytical CriterionN: balances are not maintained for this Analytical Criterion |
| DISPLAY_ORDER | Dispaly order of the analytical criteria for reports and inquiry forms. |
| ENABLED_FLAG | Y: the analytical criterion is enabled and can be attached to a product accounting definition.N: : the analytical criterion is not enabled and cannot be attached to a product accounting definition. |
| YEAR_END_CARRY_FORWARD_CODE | If balancing_flag = 'Y' it must have one of the following values, otherwise it must be null: A: The analytical criterion balances are always carried forward to the next fiscal year.N: The analytical criterion balances are never carried forw |
| DISPLAY_IN_INQUIRIES_FLAG | Y: the journal entry lines associated to this analytical criterion are candidates to be displayed in the inquiries N: the journal entry lines associated to this analytical criterion will not be displayed in the inquiries |
| CRITERION_VALUE_CODE | INTERNAL KEY: for this analytical criterion, the value stored is the internal key of the source. MEANING: for this analytical criterion, the value stored is the translated meaning of the source (the source is associated to a lookup code or |
| UPDATED_FLAG | Indicate if the application accounting definition is updated since last exported |
| VERSION_NUM | Version number generated automatically at the time of export |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| Subledger Accounting - XLA_ANALYTICAL_HDRS_TL | The XLA_ANALYTICAL_HDRS_TL table stores the translated header information (name and description) for the Analytical criteria. |
|---|---|
| Column Name | Descritpion |
| ANALYTICAL_CRITERION_CODE | Analytical Criterion code |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| ANALYTICAL_CRITERION_TYPE_CODE | Analytical Criterion type code. Values are:User: the analytical criterion is defined by the user.System: the analytical criterion is defined by the product team and is made available as a seeded data. |
| LANGUAGE | Standard Language Code |
| SOURCE_LANG | Standard Source Language Code |
| AMB_CONTEXT_CODE | Accounting Methods Builder context. |
| NAME | Analytical Criterion name |
| DESCRIPTION | Analytical Criterion description |
| Subledger Accounting - XLA_ANALYTICAL_SOURCES | The XLA_ANALYTICAL_SOURCES table stores the assignment between the Analytical Criteria detail and the sources. |
|---|---|
| Column Name | Descritpion |
| ANALYTICAL_CRITERION_CODE | Analytical Criteria code |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| ANALYTICAL_CRITERION_TYPE_CODE | Analytical Criteria type code |
| ANALYTICAL_DETAIL_CODE | Analytical Criteria detail code |
| ENTITY_CODE | Entity Code |
| AMB_CONTEXT_CODE | Accounting Methods Builder context. |
| EVENT_CLASS_CODE | Event class code |
| APPLICATION_ID | Internal Id of the application |
| SOURCE_CODE | Source code |
| SOURCE_TYPE_CODE | Source type code |
| SOURCE_APPLICATION_ID | Internal Id of the source application |
| Subledger Accounting - XLA_APPLI_AMB_CONTEXTS | The XLA_APPLI_AMB_CONTEXTS table stores the information for the application and the AMB contexts. |
|---|---|
| Column Name | Descritpion |
| AMB_CONTEXT_CODE | The XLA_APPLI_AMB_CONTEXTS table stores the information for the application and the AMB contexts. |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| APPLICATION_ID | Application internal identifier |
| STAGING_AMB_CONTEXT_CODE | AMB context code of the staging area |
| UPDATED_FLAG | Indicate if there is any update to the AMB context since last merge analysis was run. Possible values are Y or N. |
| LAST_ANALYZED_DATE | The date-time when the last merge analysis was run |
| BATCH_NAME | The user-defined batch name |
| OBJECT_VERSION_NUMBER | Standard WHO column |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| Subledger Accounting - XLA_BALANCE_STATUSES | The XLA_BALANCE_STATUSES table stores the status of the balance for a code combination Id and allows the simultaneous execution of the balance calculation, the balance recreation and the balance synchronization. For more details on the tran |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Internal Id of the application |
| BALANCING_SEGMENT | Balancing segment from the accounting flexfield. |
| NATURAL_ACCOUNT_SEGMENT | Natural account segment from the accounting flexfield. |
| ACCOUNT_TYPE | Account Type from the Accounting Flexfield. |
| WARNING_FLAG | Used by the Balance Recreation. The recreation of this balance status has not been completed by a previous Recreation request. The next Recreation request will complete the task but will end with a warning. |
| RECREATE_EFFECTIVE_PERIOD_NUM | Used by the Balance Recreation to resume the task of a previous request that ended with a failure |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| LEDGER_ID | Ledger identifier |
| PROGRAM_UPDATE_DATE | Concurrent Program who column - date when a program last updated this row). |
| PROGRAM_APPLICATION_ID | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). |
| PROGRAM_ID | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). |
| REQUEST_ID | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
| CODE_COMBINATION_ID | Account code combination Id |
| BALANCE_SOURCE_CODE | This code identifies the type of balance: A : Analytical balanceC : Control balance |
| BALANCE_STATUS_CODE | This code identifies the status of balance period:A : available for balance calculation B : balance is currently processed by the recreation function in the second phase of the recreation C : balance is currently processed by the recreation |
| EFFECTIVE_PERIOD_NUM | The 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. |
| RECREATE_PARTY_TYPE_CODE | |
| RECREATE_PARTY_ID | |
| RECREATE_PARTY_SITE_ID |
| Subledger Accounting - XLA_CONDITIONS | The XLA_CONDITIONS table stores the conditions for an accounting line or header types, segment rules and descriptions. |
|---|---|
| Column Name | Descritpion |
| CONDITION_ID | Internal Id |
| BRACKET_LEFT_CODE | Left Bracket code |
| BRACKET_RIGHT_CODE | Right Bracket code |
| VALUE_TYPE_CODE | ) Value type code, source or constant |
| SOURCE_APPLICATION_ID | Source application Id |
| SOURCE_TYPE_CODE | Source type code |
| USER_SEQUENCE | User defined sequence |
| SOURCE_CODE | Source code |
| FLEXFIELD_SEGMENT_CODE | Flexfield segment code |
| VALUE_FLEXFIELD_SEGMENT_CODE | Value Flexfield segment code |
| VALUE_SOURCE_APPLICATION_ID | Value Source application |
| VALUE_SOURCE_TYPE_CODE | Value Source type code |
| VALUE_SOURCE_CODE | value Source code |
| VALUE_CONSTANT | Constant value when the value type is Constant |
| LINE_OPERATOR_CODE | Line operator code |
| LOGICAL_OPERATOR_CODE | Logical operator code |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| INDEPENDENT_VALUE_CONSTANT | Stores the Independent value of a key flexfield |
| APPLICATION_ID | Internal Id of the application |
| AMB_CONTEXT_CODE | Accounting Methods Builder context. |
| ENTITY_CODE | Entity code |
| EVENT_CLASS_CODE | Event class code |
| ACCOUNTING_LINE_TYPE_CODE | Accounting line type code |
| ACCOUNTING_LINE_CODE | Accounting line code |
| SEGMENT_RULE_DETAIL_ID | Segment rule detail Id |
| DESCRIPTION_PRIO_ID | Description priority Id |
| Subledger Accounting - XLA_CONTROL_BALANCES | The XLA_CONTROL_BALANCES table stores the balances for each third party control account. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Internal Id of the application |
| BEGINNING_BALANCE_DR | Beginning balance for the period (DR) |
| BEGINNING_BALANCE_CR | Beginning balance for the period (CR) |
| PERIOD_BALANCE_DR | Current balance for the period (DR): made up of the period activity |
| PERIOD_BALANCE_CR | Current balance for the period (CR): made up of the period activity |
| DRAFT_BEGINNING_BALANCE_DR | Draft beginning balance for the period (DR) |
| DRAFT_BEGINNING_BALANCE_CR | Draft beginning balance for the period (CR) |
| PERIOD_DRAFT_BALANCE_DR | Current draft balance for the period (DR): made up of the period activity |
| PERIOD_DRAFT_BALANCE_CR | Current draft balance for the period (CR): made up of the period activity |
| INITIAL_BALANCE_FLAG | Flag that shows if this is an initial balanceY: initial balanceN: non initial balance |
| FIRST_PERIOD_FLAG | This flag indicates if this is the first period in a fiscal year for which balances have been calculated for a given key:Y: first period in a fiscal year N: not first period in a fiscal year |
| LEDGER_ID | Ledger identifier |
| PERIOD_YEAR | Fiscal year of the period |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| PROGRAM_UPDATE_DATE | Concurrent Program who column - date when a program last updated this row). |
| PROGRAM_APPLICATION_ID | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). |
| PROGRAM_ID | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). |
| REQUEST_ID | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
| CODE_COMBINATION_ID | Account code combination Id |
| PARTY_TYPE_CODE | Indicates the type of the third party: C: customer S: supplier |
| PARTY_ID | Party identifier. Together with the party_site_id, these two columns make up the third party identification. |
| PARTY_SITE_ID | Party site identifier. Together with the party_id, these two columns make up the third party identification. Since party_site_id may be null, it is populated with -999 in this table. |
| PERIOD_NAME | Accounting period name |
| Subledger Accounting - XLA_DESCRIPTIONS_B | The XLA_DESCRIPTIONS_B table stores all descriptions created for an application. These descriptions are then attached to accounting header and line types. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Internal Id of the application Id |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| AMB_CONTEXT_CODE | Accounting methods builder context. |
| DESCRIPTION_CODE | Description code |
| DESCRIPTION_TYPE_CODE | Description type code |
| TRANSACTION_COA_ID | Chart of accounts of the transaction |
| ENABLED_FLAG | Internal flag |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| Subledger Accounting - XLA_DESCRIPTIONS_TL | The XLA_DESCRIPTIONS_TL table stores translated information about the descriptions. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Internal Id of the application |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| AMB_CONTEXT_CODE | Accounting Methods Builder context. |
| DESCRIPTION_CODE | Description code |
| DESCRIPTION_TYPE_CODE | Description type code |
| LANGUAGE | Standard Language Code |
| NAME | Description name |
| DESCRIPTION | Description of the description |
| SOURCE_LANG | Standard Source Language Code |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| Subledger Accounting - XLA_DESCRIPT_DETAILS_B | The XLA_DESCRIPT_DETAILS_B table stores the details of a description. It holds a string of literal and sources in the sequence in which they should appear in the description.A flexfield segment can be specified only if TRANSACTION_COA_ID is |
|---|---|
| Column Name | Descritpion |
| DESCRIPTION_DETAIL_ID | Description detail Id |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| AMB_CONTEXT_CODE | Accounting Methods Builder context. |
| DESCRIPTION_PRIO_ID | Description priority Id |
| USER_SEQUENCE | User Sequence |
| VALUE_TYPE_CODE | Value type code |
| SOURCE_APPLICATION_ID | Source application |
| SOURCE_TYPE_CODE | Source type code |
| SOURCE_CODE | Source code |
| FLEXFIELD_SEGMENT_CODE | Accounting flexfield segment |
| DISPLAY_DESCRIPTION_FLAG | Internal flag, indicate if the flexfield segment is displayed with a meaning or a description |
| Subledger Accounting - XLA_DESCRIPT_DETAILS_TL | The XLA_DESCRIPT_DETAILS_TL table stores the translation details of a description. |
|---|---|
| Column Name | Descritpion |
| DESCRIPTION_DETAIL_ID | Description detail Id |
| AMB_CONTEXT_CODE | Accounting Methods Builder context. |
| LANGUAGE | Accounting Methods Builder context. |
| LITERAL | Translated text entered by the user |
| SOURCE_LANG | Standard Source Language Code |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| Subledger Accounting - XLA_DESC_PRIORITIES | The XLA_DESc_PRIORTIES table stores priority information about descriptions |
|---|---|
| Column Name | Descritpion |
| AMB_CONTEXT_CODE | Accounting Methods Builder context. |
| DESCRIPTION_TYPE_CODE | Description type code |
| DESCRIPTION_CODE | Description code |
| USER_SEQUENCE | User Sequence (priority) |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| DESCRIPTION_PRIO_ID | Description priority Id |
| APPLICATION_ID | Internal id of the application |
| Subledger Accounting - XLA_DIAG_EVENTS | Events processed by the diagnostic framework. |
|---|---|
| Column Name | Descritpion |
| EVENT_ID | Accounting event internal identifier |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| PROGRAM_UPDATE_DATE | Concurrent Program who column - date when a program last updated this row). |
| PROGRAM_APPLICATION_ID | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). |
| PROGRAM_ID | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). |
| REQUEST_ID | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
| APPLICATION_ID | Internal Id of the application |
| LEDGER_ID | Ledger internal identifier |
| TRANSACTION_NUMBER | Subledger transaction number |
| EVENT_NUMBER | Event number |
| EVENT_DATE | Event date |
| ENTITY_CODE | Entity code |
| EVENT_CLASS_CODE | Event class code |
| EVENT_TYPE_CODE | Event type code |
| Subledger Accounting - XLA_DIAG_LEDGERS | Ledgers processed by the diagnostic framework. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Internal Id of the application |
| NLS_DESC_LANGUAGE | NLS Description language code |
| CURRENCY_CODE | Entered currency for the subledger journal entry line |
| START_DATE_ACTIVE | Effective start date for Accounting Application Definition |
| END_DATE_ACTIVE | Effective end date for Accounting Application Definition |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| PROGRAM_UPDATE_DATE | Concurrent Program who column - date when a program last updated this row). |
| PROGRAM_APPLICATION_ID | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). |
| LEDGER_ID | Ledger internal identifier |
| PROGRAM_ID | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). |
| REQUEST_ID | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
| PRODUCT_RULE_CODE | Code for the Application Accounting Definition |
| PRODUCT_RULE_TYPE_CODE | Owner for the Application Accounting Definition |
| AMB_CONTEXT_CODE | Development context |
| ACCOUNTING_REQUEST_ID | Associated accounting program request identifier |
| PRIMARY_LEDGER_ID | Primary ledger internal identifier |
| SLA_LEDGER_ID | SLA ledger internal identifier |
| DESCRIPTION_LANGUAGE | Description language code |
| Subledger Accounting - XLA_DIAG_SOURCES | Source values retrieved by the diagnostic framework from the Transaction Objects. |
|---|---|
| Column Name | Descritpion |
| EVENT_ID | Accounting event internal identifier |
| OBJECT_TYPE_CODE | Owner of the transaction object |
| SOURCE_VALUE | Source value |
| SOURCE_MEANING | Source meaning |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| PROGRAM_UPDATE_DATE | Concurrent Program who column - date when a program last updated this row). |
| PROGRAM_APPLICATION_ID | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). |
| PROGRAM_ID | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). |
| LEDGER_ID | Ledger internal identifier |
| REQUEST_ID | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
| SOURCE_APPLICATION_ID | Source code |
| SOURCE_TYPE_CODE | Source type code |
| SOURCE_CODE | Internal identifier of the source application |
| LINE_NUMBER | Transaction object line number |
| SLA_LEDGER_ID | SLA ledger internal identifier |
| DESCRIPTION_LANGUAGE | Description language code |
| OBJECT_NAME | Name of the transaction object |
| Subledger Accounting - XLA_ENTITY_ID_MAPPINGS | The XLA_ENTITY_ID_MAPPINGS table stores the mapping of the primary key columns of the entity table of the event table. It contains one row for each entity for which a maximum of four primary keys columns are supported. Each row includes the |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Internal Id of the application |
| SOURCE_ID_COL_NAME_4 | Flexible Id column |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| ENTITY_CODE | Entity code |
| TRANSACTION_ID_COL_NAME_1 | Primary column name on the entity |
| TRANSACTION_ID_COL_NAME_2 | Primary column name on the entity |
| TRANSACTION_ID_COL_NAME_3 | Primary column name on the entity |
| TRANSACTION_ID_COL_NAME_4 | Primary column name on the entity |
| SOURCE_ID_COL_NAME_1 | Flexible Id column |
| SOURCE_ID_COL_NAME_2 | Flexible Id column |
| SOURCE_ID_COL_NAME_3 | Flexible Id column |
| Subledger Accounting - XLA_ENTITY_TYPES_B | The XLA_ENTITY_TYPES_B table stores all event entities that are used to group event classes. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Internal Id of the application |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| ENTITY_CODE | Entity code |
| ENABLED_FLAG | Internal flag |
| ENABLE_GAPLESS_EVENTS_FLAG | indicates whether the events generated for the entity are subject to gapless processing possible values: (Y)--yes, (N)--No |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| Subledger Accounting - XLA_ENTITY_TYPES_TL | The XLA_ENTITY_TYPES_TL table record translated information related to entity. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Internal Id of the application |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| ENTITY_CODE | Entity code |
| LANGUAGE | Standard Language Code |
| NAME | Entity name |
| DESCRIPTION | Entity description |
| SOURCE_LANG | Standard Source Language Code |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| Subledger Accounting - XLA_EVENT_CLASSES_B | The XLA_EVENT_CLASSES_B table stores all event classes for an entity. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Internal if of the Application |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| ENTITY_CODE | Event entity code |
| EVENT_CLASS_CODE | Event class code |
| ENABLED_FLAG | Internal flag. Indicate if the event class is enabled |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| Subledger Accounting - XLA_EVENT_CLASSES_TL | The XLA_EVENT_CLASSES table record translated information related to event classes. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Internal id of the application |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| ENTITY_CODE | Entity code |
| EVENT_CLASS_CODE | Event class code |
| LANGUAGE | Standard Language Code |
| NAME | Event class name |
| DESCRIPTION | Event class description |
| SOURCE_LANG | Standard Source Language Code |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| Subledger Accounting - XLA_EVENT_CLASS_ATTRS | The XLA_EVENT_CLASSES_ATTR table stores generic or specific attributes related to event classes. |
|---|---|
| Column Name | Descritpion |
| ENTITY_CODE | Entity code |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| CALCULATE_ACCTD_AMTS_FLAG | Indicates whether the accounting program must calculate the accounted amounts for the event class. The possible values are Y-Calcaulated accounted amountsN - Do not calculate accounted amounts |
| CALCULATE_G_L_AMTS_FLAG | Indicates whether the accounting program must calculate gain or loss amounts for the event class. The possible values are Y- Calculate Gain/Loss amounts.N- Do not calculate Gain/Loss amounts. |
| EVENT_CLASS_CODE | Event class code |
| EVENT_CLASS_GROUP_CODE | |
| JE_CATEGORY_NAME | General Ledger transfer category |
| REPORTING_VIEW_NAME | Table or view Table Name used for reporting |
| ALLOW_ACTUALS_FLAG | Indicates if actual entries are allowed for the event class. |
| ALLOW_BUDGETS_FLAG | Indicates if budgetl entries are allowed for the event class. |
| APPLICATION_ID | Internal id of the application |
| ALLOW_ENCUMBRANCE_FLAG | Indicates if encumbrance entries are allowed for the event class. |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| Subledger Accounting - XLA_EVENT_CLASS_GRPS_B | The table XLA_EVENT_CLASS_GRPS_B record groups of event classes for processing purpose. |
|---|---|
| Column Name | Descritpion |
| EVENT_CLASS_GROUP_CODE | Event class group code |
| CREATION_DATE | Standard who column - date when this row was created. |
| ENABLED_FLAG | |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| APPLICATION_ID | Internal id of the application id |
| Subledger Accounting - XLA_EVENT_CLASS_GRPS_TL | The table XLA_EVENT_CLASS_GRPS_TL record translated information about event class groups. |
|---|---|
| Column Name | Descritpion |
| EVENT_CLASS_GROUP_CODE | Event class group code |
| LANGUAGE | Standard Language Code |
| NAME | Event group name |
| DESCRIPTION | Event group description |
| SOURCE_LANG | Standard Source Language Code |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| APPLICATION_ID | Internal id of the application |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| Subledger Accounting - XLA_EVENT_MAPPINGS_B | The XLA_EVENT_MAPPINGS_B table stores information to build reports based on information available on the base document.It contains a row for each column name to be printed on these reports. |
|---|---|
| Column Name | Descritpion |
| EVENT_MAPPING_ID | Event mapping id |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| APPLICATION_ID | Internal id of the application |
| ENTITY_CODE | Entity code |
| EVENT_CLASS_CODE | Event class code |
| USER_SEQUENCE | User sequence |
| COLUMN_NAME | Column name |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| Subledger Accounting - XLA_EVENT_MAPPINGS_TL | The XLA_EVENT_MAPPINGS_TL table record translated information related to event mappings. |
|---|---|
| Column Name | Descritpion |
| EVENT_MAPPING_ID | Event mapping id |
| LANGUAGE | Standard Language Code |
| COLUMN_TITLE | Column title |
| SOURCE_LANG | Standard Source Language Code |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| Subledger Accounting - XLA_EVENT_SOURCES | The XLA_EVENT_SOURCES table stores all sources assigned to an event class or an event entity. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Internal id of the application id |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| LEVEL_CODE | Level of the standard source assignment. The possible values are H-Header, L-Line, C-Currency |
| ENTITY_CODE | Entity code |
| EVENT_CLASS_CODE | Event class code |
| SOURCE_APPLICATION_ID | Source application id |
| SOURCE_TYPE_CODE | Source type code |
| SOURCE_CODE | Source code |
| ACTIVE_FLAG | Flag to indicate if the source is assigned to the event class |
| CREATION_DATE | Standard who column - date when this row was created. |
| Subledger Accounting - XLA_EVENT_TYPES_B | The XLA_EVENT_TYPES_B table stores all event types that belong to an event class. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Internal id of the application |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| ENTITY_CODE | Entity code |
| EVENT_CLASS_CODE | Event class code |
| EVENT_TYPE_CODE | Event type code |
| ACCOUNTING_FLAG | Internal flag |
| TAX_FLAG | Internal flag |
| ENABLED_FLAG | Internal flag |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| Subledger Accounting - XLA_EVENT_TYPES_TL | The XLA_EVENT_TYPES_TL table stores translated information about event types. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Internal id of the application |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| ENTITY_CODE | Entity code |
| EVENT_CLASS_CODE | Event class code |
| EVENT_TYPE_CODE | Event type code |
| LANGUAGE | Standard Language Code |
| NAME | Event type name |
| DESCRIPTION | Event type description |
| SOURCE_LANG | Standard Source Language Code |
| CREATION_DATE | Standard who column - date when this row was created. |
| Subledger Accounting - XLA_EVT_CLASS_ACCT_ATTRS | The XLA_EVT_CLASS_ACCT_ATTRS stores standard, system and custom sources assigned to an accounting attribute at the event class level. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application Identifier |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| EVENT_CLASS_CODE | Event Class Code |
| ACCOUNTING_ATTRIBUTE_CODE | Accounting Attribute code |
| SOURCE_APPLICATION_ID | Application Identifier that owns the source |
| SOURCE_TYPE_CODE | Indicates whether it is a System, Standard or a Custom source. |
| SOURCE_CODE | Source code |
| DEFAULT_FLAG | Flag to indicate if the assignment is used to default the source value at JLT/AAD level. Possible values are Y (Yes) or N (No). |
| ASSIGNMENT_OWNER_CODE | Assignment Owner Code. |
| CREATION_DATE | Standard who column - date when this row was created. |
| Subledger Accounting - XLA_EXTRACT_OBJECTS | It stores the extract object name and type used by the Accounting Program to derive sources for an event class. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| ENTITY_CODE | Entity code |
| EVENT_CLASS_CODE | |
| OBJECT_NAME | |
| OBJECT_TYPE_CODE | Extract object type |
| ALWAYS_POPULATED_FLAG | Indicates if the extract object will always return a row for the extract header and all extract lines. The possible values are (Y)- The extract object will return a row for all extract lines. (N)- The extract object need not alway |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| Subledger Accounting - XLA_JE_CATEGORIES | This table stores Journal Categories for a combination of an event class and an application. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application Id |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| PROCESSING_UNIT_SIZE | Indicates the number of documents to be processed at a time, as a batch, while creating accounting entries |
| LEDGER_ID | Ledger Internal Identifier |
| ENTITY_CODE | Entity Code |
| EVENT_CLASS_CODE | Event Class Code |
| JE_CATEGORY_NAME | Journal Category Name |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| Subledger Accounting - XLA_JLT_ACCT_ATTRS | The XLA_JLT_ACCT_ATTRS stores standard, system and custom sources assigned to an accounting attribute at the Journal Line Type level. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application Identifier |
| EVENT_CLASS_DEFAULT_FLAG | Flag to indicate if the value of source is a default from the accounting attribute assignments at event class. Possible values are Y (Yes) or N (No). |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| EVENT_CLASS_CODE | Event Class Code |
| AMB_CONTEXT_CODE | Accounting Methods Builder context |
| ACCOUNTING_LINE_TYPE_CODE | Journal Line type code |
| ACCOUNTING_LINE_CODE | Journal Line code |
| ACCOUNTING_ATTRIBUTE_CODE | Accounting Attribute code |
| SOURCE_APPLICATION_ID | Application Identifier that owns the source |
| SOURCE_TYPE_CODE | Indicates whether it is a System, Standard or a Custom source. |
| SOURCE_CODE | Source code |
| Subledger Accounting - XLA_LAUNCH_OPTIONS | The XLA_LAUNCH_OPTIONS table stores the defaults for accounting program launch options for an application and a ledger. For applications that support valuation method accounting, these default options are stored for a primary and secondary |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application Id |
| SUBMIT_GL_POST_FLAG | Submit GL Post ( Y-Yes, N-No) |
| SUBMIT_GL_POST_OVERRIDE_FLAG | Allows the user to override the Submit GL Post option during the Accounting Program submission. The possible values are Y-Yes/N-No |
| ERROR_LIMIT | Accounting Program Errors Limit |
| PROCESSES | Number of parallel processes used for creating accounting entries. |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| PROCESSING_UNIT_SIZE | Indicates the number of documents to be processed at a time while creating accounting entries. |
| LEDGER_ID | Ledger internal identifier. If an application uses a valuation method then the ledger could be a primary or a secondary ledger. If an application does not use a valuation method then it can only be a primary ledger. |
| ACCOUNTING_MODE_CODE | Accounting Mode (D-Draft, T-Test, F-Final) |
| ACCOUNTING_MODE_OVERRIDE_FLAG | Allows the user to override the Accounting Mode during Accounting Program submission. The possible values are Y-Yes/N-No |
| SUMMARY_REPORT_FLAG | Accounting Report Mode(S-Summary, D-Detail) |
| SUMMARY_REPORT_OVERRIDE_FLAG | Allows the user to override the Report Summary option during the Accounting Program submission. The possible values are Y-Yes/N-No |
| SUBMIT_TRANSFER_TO_GL_FLAG | Indicates whether the transfer to GL should be submitted along after creating accounting entries. (Y-Yes, N-No) |
| SUBMIT_TRANSFER_OVERRIDE_FLAG | Allows the user to override the Submit Transfer to GL option during the Accounting Program submission. The possible values are Y-Yes/N-No |
| Subledger Accounting - XLA_LEDGER_OPTIONS | This table stores the ledger level default setup information for an application. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application Id |
| ENABLED_FLAG | Indicates whether subledger accounting (or GL consolidation) should populate the ledger |
| ROUNDING_RULE_CODE | Indicates how amount will be rounded when rounding is performed. Possible Values are:Up: The amount will be rounded upDown: The amount will be rounded downNearest: The amount will be rounded to the nearest number. |
| MERGE_ACCT_OPTION_CODE | Indicated the third party merge accounting option should be applied |
| LEDGER_ID | Ledger Internal Identifier |
| TRANSFER_TO_GL_MODE_CODE | Indicates the summary mode for the transfer to GL Program. (P- Summarize by PeriodA-Summarize by Accounting DateD-No Summarization) |
| ACCT_REVERSAL_OPTION_CODE | Indicates whether accounting reversal should reverse the sides or reverse the amount signs. The possible values are SIDE -reverse the sides for the reversal entries, SIGN- Reverse the amount sings for the reversal lines. |
| CAPTURE_EVENT_FLAG | In the context of application, the column stores a value indicating if accounting events can be created for the ledger or not. If the flag value is 'Y' events can be created for the ledger and if the value is 'N' no events can be created |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| Subledger Accounting - XLA_LINE_DEFINITIONS_B | This table stores the journal lines definitions for an application. |
|---|---|
| Column Name | Descritpion |
| AMB_CONTEXT_CODE | AMB context code |
| ACCOUNTING_COA_ID | Chart of accounts for which the accounting is created |
| OBJECT_VERSION_NUMBER | Standard OVN column |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| BUDGETARY_CONTROL_FLAG | Indicates if it is used in budgetary control |
| APPLICATION_ID | Internal identifier of the application |
| EVENT_CLASS_CODE | Event class code |
| EVENT_TYPE_CODE | Event type code |
| LINE_DEFINITION_OWNER_CODE | Journal lines definition owner code |
| LINE_DEFINITION_CODE | Journal lines definition code |
| VALIDATION_STATUS_CODE | Validation status code |
| ENABLED_FLAG | Indicate if the journal lines definition is enabled |
| TRANSACTION_COA_ID | Chart of accounts of the transaction |
| Subledger Accounting - XLA_LINE_DEFINITIONS_TL | This table stores translated information about journal lines definitions. |
|---|---|
| Column Name | Descritpion |
| AMB_CONTEXT_CODE | AMB context code |
| SOURCE_LANG | Standard Source Language Code |
| OBJECT_VERSION_NUMBER | Standard OVN column |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| APPLICATION_ID | Internal identifier of the application |
| EVENT_CLASS_CODE | Event class code |
| EVENT_TYPE_CODE | Event type code |
| LINE_DEFINITION_OWNER_CODE | Journal lines definition owner code |
| LINE_DEFINITION_CODE | Journal lines definition code |
| LANGUAGE | Standard language code |
| NAME | Name of the line assignment |
| DESCRIPTION | Description of the line assignment |
| Subledger Accounting - XLA_LINE_DEFN_AC_ASSGNS | This table stores the analytical criteria assigned to the journal lines definitions. |
|---|---|
| Column Name | Descritpion |
| AMB_CONTEXT_CODE | AMB context code |
| ANALYTICAL_CRITERION_CODE | Analytical criterion owner code |
| OBJECT_VERSION_NUMBER | Standard OVN column |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| APPLICATION_ID | Internal identifier of the application |
| EVENT_CLASS_CODE | Event class code |
| EVENT_TYPE_CODE | Event class code |
| LINE_DEFINITION_OWNER_CODE | Journal lines definition owner code |
| LINE_DEFINITION_CODE | Journal lines definition code |
| ACCOUNTING_LINE_TYPE_CODE | Journal line type owner code |
| ACCOUNTING_LINE_CODE | Journal line type code |
| ANALYTICAL_CRITERION_TYPE_CODE | Journal line type code |
| Subledger Accounting - XLA_LINE_DEFN_ADR_ASSGNS | This table stores the account derivation rules assigned to the journal lines definitions. |
|---|---|
| Column Name | Descritpion |
| AMB_CONTEXT_CODE | AMB context code |
| SEGMENT_RULE_TYPE_CODE | Account derivation rule owner code |
| SEGMENT_RULE_CODE | Account derivation rule code |
| OBJECT_VERSION_NUMBER | Standard OVN column |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| SIDE_CODE | The Gain/loss line could have two accounts : Gain account and Loss account. Only when the final gain or loss is determined, the account can be decided based whether the line is a gain line or a loss line. If the line is a gain line, the gai |
| INHERIT_ADR_FLAG | Indicate if the account derivation rule is inherited |
| SEGMENT_RULE_APPL_ID | Segment rule application id |
| ADR_VERSION_NUM | Version number of the account derivation rule |
| APPLICATION_ID | Internal identifier of the application |
| EVENT_CLASS_CODE | Event class code |
| EVENT_TYPE_CODE | Event type code |
| LINE_DEFINITION_OWNER_CODE | Journal lines definition owner code |
| LINE_DEFINITION_CODE | Journal lines definition code |
| ACCOUNTING_LINE_TYPE_CODE | Journal line type owner code |
| ACCOUNTING_LINE_CODE | Journal line type code |
| FLEXFIELD_SEGMENT_CODE | Segment code of the accounting flexfield |
| Subledger Accounting - XLA_LINE_DEFN_JLT_ASSGNS | This table stores the journal line types assigned to the journal lines definitions. |
|---|---|
| Column Name | Descritpion |
| AMB_CONTEXT_CODE | AMB context code |
| DESCRIPTION_CODE | Description code |
| ACTIVE_FLAG | Indicate if the journal lines definition is active |
| OBJECT_VERSION_NUMBER | Standard OVN column |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| INHERIT_DESC_FLAG | Indicate if the description is inherited |
| MPA_HEADER_DESC_CODE | Multiperiod header description code |
| MPA_HEADER_DESC_TYPE_CODE | Multiperiod header description owner code |
| MPA_NUM_JE_CODE | The number of multiperiod journal entries to be created |
| MPA_GL_DATES_CODE | Option which denotes how the GL date for the multiperiod JE are derived. |
| APPLICATION_ID | Internal identifier of the application |
| MPA_PRORATION_CODE | Option which denotes how multiperiod journal entries should be prorated |
| EVENT_CLASS_CODE | Event class code |
| EVENT_TYPE_CODE | Event type code |
| LINE_DEFINITION_OWNER_CODE | Journal lines definition owner code |
| LINE_DEFINITION_CODE | Journal lines definition code |
| ACCOUNTING_LINE_TYPE_CODE | Journal line type owner code |
| ACCOUNTING_LINE_CODE | Journal line type code |
| DESCRIPTION_TYPE_CODE | Description owner code |
| Subledger Accounting - XLA_MAPPING_SETS_B | The XLA_MAPPING_SETS_B table stores Mapping Sets created by End Users. These mapping sets are then used in the definition of account derivation rules. |
|---|---|
| Column Name | Descritpion |
| MAPPING_SET_CODE | Mapping set code |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| FLEX_VALUE_SET_ID | Stores the Flex value set id for a value set. |
| AMB_CONTEXT_CODE | Accounting methods builder context. |
| ACCOUNTING_COA_ID | Chart of accounts for which accounting is done |
| VALUE_SET_ID | Value set for the source |
| FLEXFIELD_ASSIGN_MODE_CODE | Indicates whether to account by accounting flexfield or by segment |
| FLEXFIELD_SEGMENT_CODE | Accounting flexfield segment name code |
| ENABLED_FLAG | Internal flag |
| VIEW_APPLICATION_ID | Indicates whether a mapping set is associated with a lookup application |
| LOOKUP_TYPE | Indicates whether the mapping set is associated with a lookup type |
| UPDATED_FLAG | Indicate if the application accounting definition is updated since last exported |
| VERSION_NUM | Version number generated automatically at the time of export |
| Subledger Accounting - XLA_MAPPING_SETS_TL | The XLA_MAPPING_SETS_TL table stores all translated information about mapping sets. |
|---|---|
| Column Name | Descritpion |
| MAPPING_SET_CODE | Mapping set code |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| AMB_CONTEXT_CODE | Accounting methods builder context. |
| LANGUAGE | Standard Language Code |
| NAME | Mapping set code name |
| DESCRIPTION | Mapping set code description |
| SOURCE_LANG | Standard Source Language Code |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| Subledger Accounting - XLA_MAPPING_SET_VALUES | The XA_MAPPING_SET_VALUES table store the mapping of account or segment values to a source value for a mapping set. |
|---|---|
| Column Name | Descritpion |
| MAPPING_SET_VALUE_ID | Mapping set value identifier |
| ENABLED_FLAG | Internal flag |
| INPUT_VALUE_TYPE_CODE | |
| INPUT_VALUE_CONSTANT | |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| AMB_CONTEXT_CODE | Accounting methods builder context. |
| MAPPING_SET_CODE | Mapping set code |
| VALUE_CONSTANT | Value for a constant |
| VALUE_CODE_COMBINATION_ID | |
| EFFECTIVE_DATE_FROM | Date from which the mapping set value is effective |
| EFFECTIVE_DATE_TO | Date to which the mapping set value is effective |
| Subledger Accounting - XLA_PRODUCT_RULES_B | The XLA_PRODUCT_RULES_B table stores the accounting rules for an application. Standard product accounting rules are independent of a chart of .accounts. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Internal id of the application |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| PRODUCT_RULE_VERSION | Product rule version |
| COMPILE_STATUS_CODE | Indicates compilation status of a product rule. |
| LOCKING_STATUS_FLAG | Indicates the locking status of the product rule. 'Y' - Locked, 'N' - Unlocked. |
| PROGRAM_UPDATE_DATE | Concurrent Program who column - date when a program last updated this row). |
| PROGRAM_APPLICATION_ID | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). |
| PROGRAM_ID | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). |
| PRODUCT_RULE_HASH_ID | Product accounting definition hash identifier |
| UPDATED_FLAG | Indicate if the application accounting definition is updated since last exported |
| VERSION_NUM | Version number generated automatically at the time of export |
| AMB_CONTEXT_CODE | Accounting methods builder context. |
| PRODUCT_RULE_TYPE_CODE | Product rule type code |
| PRODUCT_RULE_CODE | Product rule code |
| TRANSACTION_COA_ID | Chart of accounts of the transaction |
| ACCOUNTING_COA_ID | Chart of accounts for which the accounting is created |
| ENABLED_FLAG | Internal flag. Enabled product rules can be assigned to an accounting method |
| REQUEST_ID | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| Subledger Accounting - XLA_PRODUCT_RULES_TL | The XLA_PRODUCT_RULES_TL table stores translated information about Application Accounting Definitions. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Internal id of the application |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| AMB_CONTEXT_CODE | Accounting methods builder context. |
| PRODUCT_RULE_TYPE_CODE | Product rule type code |
| PRODUCT_RULE_CODE | Product rule code |
| LANGUAGE | Standard Language Code |
| NAME | Product rule name |
| DESCRIPTION | Product rule description |
| SOURCE_LANG | Standard Source Language Code |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| Subledger Accounting - XLA_PROD_ACCT_HEADERS | The XLA_PROD_ACCT_HEADERS table optionally stores the accounting headers types for a Application Accounting Definition and event class or type. If not specified, a flag must be set to indicate that no accounting is required for the combinat |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Internal id of the application |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| VALIDATION_STATUS_CODE | Comment: Indicate the validation status of an event class and event type assignment. |
| LOCKING_STATUS_FLAG | Indicates the locking status of an event class and event type assignment. 'Y' - Locked, 'N' - Unlocked. |
| AMB_CONTEXT_CODE | Accounting methods builder context. |
| PRODUCT_RULE_TYPE_CODE | Product rule type code |
| PRODUCT_RULE_CODE | Application Accounting Definition code |
| ENTITY_CODE | Event entity code |
| EVENT_CLASS_CODE | Event class code |
| EVENT_TYPE_CODE | Event type code |
| DESCRIPTION_TYPE_CODE | Description type code |
| DESCRIPTION_CODE | Description code |
| ACCOUNTING_REQUIRED_FLAG | Internal flag. Indicates if accounting is required for this product rule and event class or type. |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| Subledger Accounting - XLA_PROD_ACCT_LINES | The XLA_PROD_ACCT_LINES table stores all accounting line types for Application Accounting Definition and event type or class combinations. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Internal id of the application |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| AMB_CONTEXT_CODE | Accounting methods builder context. |
| PRODUCT_RULE_TYPE_CODE | Product rule type code |
| PRODUCT_RULE_CODE | Product rule code |
| ENTITY_CODE | Entity code |
| EVENT_CLASS_CODE | Event class code |
| EVENT_TYPE_CODE | Event type code |
| ACCOUNTING_LINE_TYPE_CODE | Line type code |
| ACCOUNTING_LINE_CODE | Line code |
| DESCRIPTION_TYPE_CODE | Description type code |
| DESCRIPTION_CODE | Description code |
| ACTIVE_FLAG | Internal flag. Actively assigned accounting line types are taken into account in the product rule definition |
| CREATION_DATE | Standard who column - date when this row was created. |
| Subledger Accounting - XLA_PROD_SEG_RULES | The XLA_PROD_SEG_RULES table stores all account derivation rules attached to an accounting line type and a product rule. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Internal id of the application |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| AMB_CONTEXT_CODE | Accounting methods builder context. |
| PRODUCT_RULE_TYPE_CODE | |
| PRODUCT_RULE_CODE | |
| ENTITY_CODE | Entity code |
| EVENT_CLASS_CODE | Event class code |
| EVENT_TYPE_CODE | Event type code |
| ACCOUNTING_LINE_TYPE_CODE | Accounting line type code |
| ACCOUNTING_LINE_CODE | Accounting line code |
| FLEXFIELD_SEGMENT_CODE | Segment code of the accounting flexfield |
| SEGMENT_RULE_TYPE_CODE | |
| SEGMENT_RULE_CODE | Segment rule code |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| Subledger Accounting - XLA_SEG_RULES_B | The XLA_SEG_RULES_B table stores all account derivation. These account derivation rules are then attached to an accounting line type |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Internal id of the application |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| FLEX_VALUE_SET_ID | Stores the Flex value set id for a value set. |
| VERSION_NUM | Version number |
| UPDATED_FLAG | Indicate if the account derivation rule is updated |
| AMB_CONTEXT_CODE | Accounting methods builder context. |
| SEGMENT_RULE_TYPE_CODE | Segment rule type code |
| SEGMENT_RULE_CODE | Segment rule code |
| TRANSACTION_COA_ID | Chart of accounts of the transaction |
| ACCOUNTING_COA_ID | Chart of accounts for which the accounting is created |
| FLEXFIELD_ASSIGN_MODE_CODE | Indicates whether to account by accounting flexfield or by segment |
| FLEXFIELD_SEGMENT_CODE | Accounting flexfield segment name code |
| ENABLED_FLAG | Internal flag |
| CREATION_DATE | Standard who column - date when this row was created. |
| Subledger Accounting - XLA_SEG_RULES_TL | The XLA_SEG_RULES_TL table stores translated information about segment rules. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application Id |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| AMB_CONTEXT_CODE | Accounting methods builder context. |
| SEGMENT_RULE_TYPE_CODE | Segment rule type code |
| SEGMENT_RULE_CODE | Segment rule code |
| LANGUAGE | Standard Language Code |
| NAME | Segment rule name (Translatable) |
| DESCRIPTION | Segment rule description (Translatable) |
| SOURCE_LANG | Standard Source Language Code |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| Subledger Accounting - XLA_SEG_RULE_DETAILS | The XLA_SEG_RULE_DETAILS table store details for an account derivation rule. It defines the priority in which the rule should be applied if the conditions for that priority are met. |
|---|---|
| Column Name | Descritpion |
| SEGMENT_RULE_DETAIL_ID | Internal id |
| APPLICATION_ID | Internal id of the application |
| AMB_CONTEXT_CODE | Accounting methods builder context. |
| VALUE_TYPE_CODE | Source type code |
| VALUE_SOURCE_APPLICATION_ID | Value source application id |
| VALUE_SOURCE_TYPE_CODE | Value source type code |
| SEGMENT_RULE_TYPE_CODE | Segment rule type code |
| VALUE_SOURCE_CODE | Value source code |
| VALUE_CONSTANT | Constant |
| VALUE_CODE_COMBINATION_ID | |
| VALUE_MAPPING_SET_CODE | Mapping set code |
| VALUE_FLEXFIELD_SEGMENT_CODE | |
| INPUT_SOURCE_APPLICATION_ID | Input source application id |
| SEGMENT_RULE_CODE | Segment rule type code |
| INPUT_SOURCE_TYPE_CODE | Input source type code |
| INPUT_SOURCE_CODE | Input source code |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| VALUE_SEGMENT_RULE_APPL_ID | Attached segment rule application id |
| VALUE_SEGMENT_RULE_TYPE_CODE | Attached segment rule type code |
| VALUE_SEGMENT_RULE_CODE | Attached segment rule code |
| VALUE_ADR_VERSION_NUM | Version number of the value account derivation rule |
| USER_SEQUENCE | User sequence |
| Subledger Accounting - XLA_SOURCES_B | The XLA_SOURCES_B table stores all sub-ledgers sources and sources customized by user. These sources are used to create accounting rules and conditions |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Internal id of the application |
| ENABLED_FLAG | Internal flag |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| TRANSLATED_FLAG | |
| LOOKUP_TYPE | |
| VIEW_APPLICATION_ID | |
| KEY_FLEXFIELD_FLAG | Decides whether the nature of the source is Key Flexfield. |
| SOURCE_TYPE_CODE | Type of the source |
| SEGMENT_CODE | Stores one of the accounting flexfield qualifiers. |
| FLEXFIELD_APPLICATION_ID | Stores the flexfield application if the KEY_FLEXFIELD_FLAG is checked. |
| ID_FLEX_CODE | Stores the flexfield code for the key flexfield. |
| SOURCE_COLUMN_NAME | Source base column name. It could be different from the source_code. |
| SOURCE_TABLE_NAME | Source table name. Indicates the table from which source can be drived. |
| SOURCE_CODE | Source code |
| DATATYPE_CODE | Data type code for the source |
| PLSQL_FUNCTION_NAME | Name of the PL/SQL function. Not application for standard sources |
| FLEX_VALUE_SET_ID | Flex value set id |
| SUM_FLAG | Internal flag |
| VISIBLE_FLAG | Visible flag that indicated if the source shows up in the list of values |
| Subledger Accounting - XLA_SOURCES_TL | The XLA_SOURCES_TL table stores translated information about sources. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Internal id of the application |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| SOURCE_TYPE_CODE | Source type code |
| SOURCE_CODE | Source code |
| LANGUAGE | Standard Language Code |
| NAME | Source name |
| DESCRIPTION | Source description |
| SOURCE_LANG | Standard Source Language Code |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| Subledger Accounting - XLA_SOURCE_PARAMS | The XLA_SOURCE_PARAMS table stores all parameters used in the plsql function for a user-defined source. |
|---|---|
| Column Name | Descritpion |
| SOURCE_PARAM_ID | Internal id |
| REF_SOURCE_CODE | Ref Source code for the seeded source |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| APPLICATION_ID | Internal id of the application |
| SOURCE_TYPE_CODE | Source type code |
| SOURCE_CODE | Source code |
| USER_SEQUENCE | User entered sequence |
| PARAMETER_TYPE_CODE | Type of parameter |
| CONSTANT_VALUE | Value when parameter type is constant |
| REF_SOURCE_APPLICATION_ID | Ref to Application id for the seeded source |
| REF_SOURCE_TYPE_CODE | Ref Source type code for the seeded source |
| Subledger Accounting - XLA_STAGE_ACCTG_METHODS | The XLA_STAGE_ACCTG_METHODS table stores the subledger accounting methods imported from the data file to the staging area of an AMB context. |
|---|---|
| Column Name | Descritpion |
| STAGING_AMB_CONTEXT_CODE | AMB context code of the staging area |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| CREATION_DATE | Standard who column - date when this row was created. |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| PROGRAM_UPDATE_DATE | Concurrent Program who column - date when a program last updated this row). |
| PROGRAM_APPLICATION_ID | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). |
| PROGRAM_ID | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). |
| REQUEST_ID | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
| ACCOUNTING_METHOD_TYPE_CODE | Accounting method owner code. Possible value includes:S - Oracle C - Customer |
| ACCOUNTING_METHOD_CODE | Accounting method code |
| NAME | Accounting method name |
| DESCRIPTION | Accounting method description |
| TRANSACTION_COA_ID | Chart of accounts of the transaction |
| ACCOUNTING_COA_ID | Chart of accounts of for which the subledger journal is created |
| ENABLED_FLAG | Internal flag. Enabled accounting method can be assigned to ledgers. Possible values are Y and N. |
| OBJECT_VERSION_NUMBER | Standard WHO column |
| Subledger Accounting - XLA_STAGING_COMPONENTS_H | The XLA_STAGING_COMPONENTS_H table stores the history of the application accounting definitions and the non-application specific journal entry setups, i.e. analytical criteria and mapping sets, imported from the data file to the staging are |
|---|---|
| Column Name | Descritpion |
| STAGING_AMB_CONTEXT_CODE | AMB context code of the staging area |
| OBJECT_VERSION_NUMBER | Standard WHO column |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| PROGRAM_UPDATE_DATE | Concurrent Program who column - date when a program last updated this row). |
| PROGRAM_APPLICATION_ID | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). |
| PROGRAM_ID | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). |
| REQUEST_ID | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
| PRODUCT_RULE_VERSION | Application accounting definition version |
| COMPONENT_TYPE_CODE | AMB component type code. It can be:AADANALYTICAL_CRITERIONMAPPING_SET |
| COMPONENT_OWNER_CODE | Component owner code. Possible value includes:S - Oracle C - CustomerX - For journal entry setups that have no owner, e.g. mapping set, use 'X'. |
| COMPONENT_CODE | Component code |
| VERSION_NUM | Version number of the component |
| BASE_VERSION_NUM | The original version number of the component |
| APPLICATION_ID | Internal identifier of the application. Applicable only if the component type is AAD. |
| VERSION_COMMENT | Comment entered when the application accounting definition is exported. Applicable only if the COMPONENT_TYPE is 'AAD'. |
| LEAPFROG_FLAG | Indicates if the application accounting definition is a leapfrog. Applicable only if the COMPONENT_TYPE is 'AAD'. Possible values are Y or N. |
| Subledger Accounting - XLA_SUBLEDGERS | The XLA_SUBLEDGERS stores information that depend on the application. It includes a row for each application, standard or not, supported by XLA. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Internal id of the application |
| ALC_ENABLED_FLAG | Indicates if the application supports alternate currency feature. |
| CONTROL_ACCOUNT_SOURCE_CODE | No Longer Used |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| CONTROL_ACCOUNT_TYPE_CODE | Indicated the third party control account type the application supported |
| JE_SOURCE_NAME | General Ledger source name |
| VALUATION_METHOD_FLAG | |
| DRILLDOWN_PROCEDURE_NAME | |
| SECURITY_FUNCTION_NAME | |
| APPLICATION_TYPE_CODE | |
| CONTROL_ACCOUNT_ENABLED_FLAG | No Longer Used |
| DEFAULT_PARTY_TYPE_CODE | No Longer Used |
| Subledger Accounting - XLA_TAB_ACCT_DEFS_B | The XLA_TAB_ACCT_DEFS_B table stores all Transaction Account Definitions. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application identifier |
| PROGRAM_APPLICATION_ID | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). |
| PROGRAM_ID | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). |
| PROGRAM_UPDATE_DATE | Concurrent Program who column - date when a program last updated this row). |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| AMB_CONTEXT_CODE | Development Context |
| ACCOUNT_DEFINITION_CODE | Transaction account Definition code |
| ACCOUNT_DEFINITION_TYPE_CODE | Transaction account definition owner |
| CHART_OF_ACCOUNTS_ID | Chart of Accounts identifier |
| COMPILE_STATUS_CODE | Indicates the compilation status of the transaction account definition |
| LOCKING_STATUS_FLAG | Indicates the locking status of the transaction account definition |
| HASH_ID | Unique identifier assigned to the Transaction Account Definition the first time it is compiled. The numeric seed comes from the sequence xla_tab_acct_defs_b_s. |
| REQUEST_ID | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
| ENABLED_FLAG | Indicates whether the transaction account definition is enabled or disabled. The possible values are Y-Yes and N-No |
| Subledger Accounting - XLA_TAB_ACCT_DEFS_TL | The XLA_TAB_ACCT_DEFS_TL table stores translated name and description for Transaction Account Definitions. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application identifier |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| AMB_CONTEXT_CODE | Development Context |
| ACCOUNT_DEFINITION_CODE | Transaction account Definition code |
| ACCOUNT_DEFINITION_TYPE_CODE | Transaction account definition owner |
| NAME | Transaction Account Definition name |
| DESCRIPTION | Transaction Account Definition description |
| LANGUAGE | Standard source language code |
| SOURCE_LANG | Standard source language code |
| Subledger Accounting - XLA_TAB_ACCT_DEF_DETAILS | The XLA_TAB_ACCT_DEF_DETAILS table stores the intersection of Transaction Account Definitions, Transaction Account Types and Account Derivation Rules. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application identifier |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| AMB_CONTEXT_CODE | Development Context |
| ACCOUNT_DEFINITION_CODE | Transaction account Definition code |
| ACCOUNT_DEFINITION_TYPE_CODE | Transaction account definition owner |
| ACCOUNT_TYPE_CODE | Transaction Account Type code |
| FLEXFIELD_SEGMENT_CODE | Flexfield Segment |
| SEGMENT_RULE_TYPE_CODE | Owner of the Account Derivation Rule |
| SEGMENT_RULE_CODE | Account Derivation Rule Code |
| Subledger Accounting - XLA_TAB_ACCT_TYPES_B | The XLA_TAB_ACCT_TYPES_B table stores all Transaction Account Types. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application identifier |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| ACCOUNT_TYPE_CODE | Transaction Account Type Code |
| ENABLED_FLAG | Indicates whether the transaction account type is enabled or disabled. The possible values are Y-Yes and N-No |
| RULE_ASSIGNMENT_CODE | Indicates whether an account derivation rule must be assigned to a transaction account type. |
| OBJECT_NAME_AFFIX | Affix attached to the TAB API interface object names |
| COMPILE_STATUS_CODE | Compilation status of the Transaction Account Type |
| Subledger Accounting - XLA_TAB_ACCT_TYPES_TL | The XLA_TAB_ACCT_TYPES_TL table stores translated name and description for Transaction Account Types. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application identifier |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| ACCOUNT_TYPE_CODE | Transaction account type code |
| NAME | Transaction Account Type name |
| DESCRIPTION | Transaction Account Type description |
| LANGUAGE | Standard source language code |
| SOURCE_LANG | Standard source language code |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| Subledger Accounting - XLA_TAB_ACCT_TYPE_SRCS | The XLA_TAB_ACCT_TYPE_SRCS table stores all Transaction Account Type Sources. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application identifier |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| ACCOUNT_TYPE_CODE | Transaction account type code |
| SOURCE_APPLICATION_ID | Source Application Identifier |
| SOURCE_TYPE_CODE | Type of Source |
| SOURCE_CODE | Source Code |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| Subledger Accounting - XLA_TRANSFER_LEDGERS | The XLA_TRANSFER_LEDGERS table stores secondary ledgers processed by the transfer to GL batch. |
|---|---|
| Column Name | Descritpion |
| GROUP_ID | Journal import group identifier |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| PROGRAM_UPDATE_DATE | Concurrent Program who column - date when a program last updated this row). |
| PROGRAM_APPLICATION_ID | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). |
| PROGRAM_ID | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). |
| REQUEST_ID | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
| SECONDARY_LEDGER_ID | Secondary ledger internal identifier |
| PRIMARY_LEDGER_ID | Primary ledger internal identifier |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| Subledger Accounting - XLA_TRANSFER_LOGS | The XLA_TRANSFER_LOGS table stores the transfer to GL log information. This information is used to recover the failed transfer to GL requests. The log information is deleted once the transfer the batch is recovered or if the transfer requ |
|---|---|
| Column Name | Descritpion |
| GROUP_ID | Interface group identifying column |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| PROGRAM_UPDATE_DATE | Concurrent Program who column - date when a program last updated this row). |
| PROGRAM_APPLICATION_ID | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). |
| LEDGER_ID | Ledger internal identifier |
| PROGRAM_ID | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). |
| REQUEST_ID | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
| APPLICATION_ID | Internal id of the application |
| GLLEZL_REQUEST_ID | Journal Import request identifier |
| PARENT_GROUP_ID | Interface group identifier of the ledger for which the transfer request was submitted. If the transfer request is submitted for a primary ledger then it is the group identifier of the primary ledger journal import request. If the transfer |
| TRANSFER_STATUS_CODE | Transfer to GL status code. The possible values are 'I' - Incomplete. |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| Subledger Accounting - XLA_UPG_BATCHES | Upgrade batch information |
|---|---|
| Column Name | Descritpion |
| UPG_BATCH_ID | Upgrade batch identifier |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| PROGRAM_UPDATE_DATE | Concurrent Program who column - date when a program last updated this row). |
| PROGRAM_APPLICATION_ID | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). |
| PROGRAM_ID | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). |
| REQUEST_ID | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
| APPLICATION_ID | Internal identifier of the application |
| UPG_SOURCE_APPLICATION_ID | Internal identifier of the upgrading application |
| START_DATE | Start date of upgrade validation |
| END_DATE | End date of upgrade validation |
| VALIDATE_COMPLETE_FLAG | Flag to indicate if validation was successfully run |
| CRSEGVALS_COMPLETE_FLAG | Flag to indicate if create segment values procedure was successfully run |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| Subledger Accounting - XLA_UPG_ERRORS | Errors related to upgraded entries |
|---|---|
| Column Name | Descritpion |
| UPG_ERROR_ID | Error Id |
| TEMP_LINE_NUM | Line number of the distribution link |
| ERROR_MESSAGE_NAME | Error message name |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| PROGRAM_UPDATE_DATE | Concurrent Program who column - date when a program last updated this row). |
| PROGRAM_APPLICATION_ID | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). |
| PROGRAM_ID | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). |
| UPG_BATCH_ID | Upgrade batch identifier |
| REQUEST_ID | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
| UPG_SOURCE_APPLICATION_ID | Internal identifier of the upgrading application |
| APPLICATION_ID | Internal identifier of the application |
| ERROR_LEVEL | Error level |
| ENTITY_ID | Internal Id of the entity |
| EVENT_ID | Internal Id of the event |
| AE_HEADER_ID | Internal Id of the Accounting entry header |
| AE_LINE_NUM | Line number of the accounting entry line |
| Subledger Accounting - XLA_EVENT_CLASS_PREDECS | This table stores the predecessors of the event classes. |
|---|---|
| Column Name | Descritpion |
| EVENT_CLASS_CODE | Event class code |
| PRIOR_EVENT_CLASS_CODE | The code of the prior event class |
| OBJECT_VERSION_NUMBER | Standard OVN column |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| APPLICATION_ID | Internal id of the application |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| Subledger Accounting - XLA_REFERENCE_OBJECTS | This table sotores reference objects. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Application Id |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| LINKED_TO_REF_OBJ_APPL_ID | Linked to Reference Object Application Id |
| LINKED_TO_REF_OBJ_NAME | Linked to Reference Object Name |
| ENTITY_CODE | Entity code |
| EVENT_CLASS_CODE | Event class code |
| OBJECT_NAME | Table or View name |
| REFERENCE_OBJECT_APPL_ID | Reference object application Id |
| REFERENCE_OBJECT_NAME | Reference object name |
| ALWAYS_POPULATED_FLAG | Indicates if the extract object will always return a row for the extract header and all extract lines. The possible values are (Y)-The extract object will return a row for all extract lines. (N)- The extract object need not always return ro |
| JOIN_CONDITION | Join condition |
| CREATION_DATE | Standard who column - date when this row was created. |
| Subledger Accounting - XLA_ACCT_CLASS_ASSGNS | This table stores the accounting class assignments for the Post-Accounting Programs. |
|---|---|
| Column Name | Descritpion |
| PROGRAM_CODE | Language independent Program code. |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| PROGRAM_OWNER_CODE | Owner indicator. Possible values are: S(Oracle) or C(User). |
| ASSIGNMENT_CODE | Language independent assignment code. |
| ASSIGNMENT_OWNER_CODE | Owner indicator. Possible values are: S(Oracle) or C(User). |
| ACCOUNTING_CLASS_CODE | Accounting Class Code |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| Subledger Accounting - XLA_ASSIGNMENT_DEFNS_B | This table stores the ledger assignments for the Post-Accountng Programs. |
|---|---|
| Column Name | Descritpion |
| PROGRAM_CODE | Language independent Program code. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| PROGRAM_OWNER_CODE | Owner indicator. Possible values are: S(Oracle) or C(User). |
| ASSIGNMENT_CODE | Language independent assignment code. |
| ASSIGNMENT_OWNER_CODE | Owner indicator. Possible values are: S(Oracle) or C(User). |
| LEDGER_ID | Ledger internal identifier |
| ENABLED_FLAG | Flag indicating active assignment definition. Possible values are: Y/N. |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| Subledger Accounting - XLA_ASSIGNMENT_DEFNS_TL | This table stores the translated columns for accounting class ledger assignments. |
|---|---|
| Column Name | Descritpion |
| PROGRAM_CODE | Language independent Program code. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| PROGRAM_OWNER_CODE | Owner indicator. Possible values are: S(Oracle) or C(User). |
| ASSIGNMENT_CODE | Language independent assignment code. |
| ASSIGNMENT_OWNER_CODE | Owner indicator. Possible values are: S(Oracle) or C(User). |
| NAME | Program Name |
| LANGUAGE | Standard Language Code |
| SOURCE_LANG | Standard Source Language Code |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| Subledger Accounting - XLA_POST_ACCT_PROGS_B | This table stores the Post-Accounting Programs. |
|---|---|
| Column Name | Descritpion |
| PROGRAM_CODE | Language independent Program code. |
| PROGRAM_OWNER_CODE | Owner indicator. Possible values are: S(Oracle) or C(User). |
| APPLICATION_ID | Application identifier |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| Subledger Accounting - XLA_POST_ACCT_PROGS_TL | This table stores the translated columns for the Post-Accounting Programs. |
|---|---|
| Column Name | Descritpion |
| PROGRAM_CODE | Language independent Program code. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| PROGRAM_OWNER_CODE | Owner indicator. Possible values are: S(Oracle) or C(User). |
| NAME | Program Name |
| DESCRIPTION | Program Description |
| LANGUAGE | Standard Language Code |
| SOURCE_LANG | Standard Source Language Code |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| Subledger Accounting - XLA_MPA_HEADER_AC_ASSGNS | This table stores the analytical criteria assigned to a multiperiod header. |
|---|---|
| Column Name | Descritpion |
| AMB_CONTEXT_CODE | AMB context code |
| ANALYTICAL_CRITERION_CODE | Multiperiod header analytical criterion code |
| OBJECT_VERSION_NUMBER | Standard OVN column |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| APPLICATION_ID | Internal identifier of the application |
| EVENT_CLASS_CODE | Event class code |
| EVENT_TYPE_CODE | Event type code |
| LINE_DEFINITION_OWNER_CODE | Journal line definition owner code |
| LINE_DEFINITION_CODE | Journal line definition code |
| ACCOUNTING_LINE_TYPE_CODE | Journal Line type owner code |
| ACCOUNTING_LINE_CODE | Journal Line type code |
| ANALYTICAL_CRITERION_TYPE_CODE | Multiperiod header analytical criterion owner code |
| Subledger Accounting - XLA_MPA_JLT_AC_ASSGNS | This table stores the analytical criteria for a multiperiod journal line type. |
|---|---|
| Column Name | Descritpion |
| AMB_CONTEXT_CODE | AMB context code |
| MPA_ACCOUNTING_LINE_CODE | Multiperiod journal line code |
| ANALYTICAL_CRITERION_TYPE_CODE | Multiperiod journal line analytical criterion owner code |
| ANALYTICAL_CRITERION_CODE | Multiperiod journal line analytical criterion code |
| MPA_INHERIT_AC_FLAG | Decides whether the analytical criteria for the Multiperiod Accrual Journal Line is inherited from its parent Journal Line |
| OBJECT_VERSION_NUMBER | Standard OVN column |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| APPLICATION_ID | Internal identifier of the application |
| EVENT_CLASS_CODE | Event class code |
| EVENT_TYPE_CODE | Event type code |
| LINE_DEFINITION_OWNER_CODE | Journal line definition owner code |
| LINE_DEFINITION_CODE | Journal line definition code |
| ACCOUNTING_LINE_TYPE_CODE | Journal Line type owner code |
| ACCOUNTING_LINE_CODE | Journal Line type code |
| MPA_ACCOUNTING_LINE_TYPE_CODE | Multiperiod journal line owner code |
| Subledger Accounting - XLA_MPA_JLT_ADR_ASSGNS | This table stores the account derivation rules for a multiperiod journal line type. |
|---|---|
| Column Name | Descritpion |
| AMB_CONTEXT_CODE | AMB context code |
| MPA_ACCOUNTING_LINE_CODE | Multiperiod journal line code |
| FLEXFIELD_SEGMENT_CODE | Segment code of the accounting flexfield. |
| SEGMENT_RULE_TYPE_CODE | Accounting derivation rule owner code |
| SEGMENT_RULE_CODE | Accounting derivation rule code |
| SEGMENT_RULE_APPL_ID | Internal identifier of the application to which the accounting derivation rule belongs. |
| INHERIT_ADR_FLAG | Decides whether the account derivation rule will be inherited if the Multiperiod Journal Line Type assigned has a business flow method of Prior Entry. |
| OBJECT_VERSION_NUMBER | Standard OVN column |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| APPLICATION_ID | Internal identifier of the application |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| EVENT_CLASS_CODE | Event class code |
| EVENT_TYPE_CODE | Event type code |
| LINE_DEFINITION_OWNER_CODE | Journal line definition owner code |
| LINE_DEFINITION_CODE | Journal line definition code |
| ACCOUNTING_LINE_TYPE_CODE | Journal Line type owner code |
| ACCOUNTING_LINE_CODE | Journal Line type code |
| MPA_ACCOUNTING_LINE_TYPE_CODE | Multiperiod journal line owner code |
| Subledger Accounting - XLA_MPA_JLT_ASSGNS | This table stores the multiperiod journal line type assignments. |
|---|---|
| Column Name | Descritpion |
| AMB_CONTEXT_CODE | AMB context code |
| MPA_ACCOUNTING_LINE_CODE | Multiperiod journal line code |
| INHERIT_DESC_FLAG | Decides whether the journal entry description will be inherited if the Multiperiod Journal Line Type assigned has a business flow method of Prior Entry |
| DESCRIPTION_TYPE_CODE | Multiperiod journal line description owner code |
| DESCRIPTION_CODE | Multiperiod journal line description code |
| OBJECT_VERSION_NUMBER | Standard OVN column |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| APPLICATION_ID | Internal identifier of the application |
| EVENT_CLASS_CODE | Event class code |
| EVENT_TYPE_CODE | Event type code |
| LINE_DEFINITION_OWNER_CODE | Journal line definition owner code |
| LINE_DEFINITION_CODE | Journal line definition code |
| ACCOUNTING_LINE_TYPE_CODE | Journal Line type owner code |
| ACCOUNTING_LINE_CODE | Journal Line type code |
| MPA_ACCOUNTING_LINE_TYPE_CODE | Multiperiod journal line owner code |
| Subledger Accounting - XLA_RULE_DETAILS_T | Interface table to load ADR rule details into SLA. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | This is the application id. |
| VALUE_SOURCE_CODE | This is the code of the source used as a value. |
| VALUE_CONSTANT | This is the constant used as a value. |
| VALUE_CODE_COMBINATION_ID | This is the code combination id used as a value. |
| VALUE_MAPPING_SET_CODE | This is the mapping set code used as a value. |
| VALUE_FLEXFIELD_SEGMENT_CODE | This is the flexfield segment code used as a value. |
| INPUT_SOURCE_APPLICATION_ID | This is the application id of the source used as an input value. |
| INPUT_SOURCE_TYPE_CODE | This is the type code of the source used as an input value. |
| INPUT_SOURCE_CODE | This is the code of the source used as an input value. |
| VALUE_SEGMENT_RULE_APPL_ID | This is the application id of the associated segment rule. |
| VALUE_SEGMENT_RULE_TYPE_CODE | This is the type code of the associated segment rule used as a value. |
| AMB_CONTEXT_CODE | This is the context code associated to the account derivation rule. |
| VALUE_SEGMENT_RULE_CODE | This is the code of the associated segment rule used as a value. |
| VALUE_ADR_VERSION_NUM | This is the version number of the associated segment rule used as a value. |
| ERROR_VALUE | This indicates the error status of the row after processed by the ADR interface program. |
| SEGMENT_RULE_TYPE_CODE | This is the owner of the account derivation rule. |
| SEGMENT_RULE_CODE | This is the code of the account derivation rule. |
| SEGMENT_RULE_DETAIL_ID | This is the identifier of the detail. It must be unique for a given application. |
| USER_SEQUENCE | This is the user sequence (also called priority) of the detail. |
| VALUE_TYPE_CODE | This is the type of the value of the detail. |
| VALUE_SOURCE_APPLICATION_ID | This is the application id of the source used as a value. |
| VALUE_SOURCE_TYPE_CODE | This is type code of the source used as a value. |
| Subledger Accounting - XLA_RULES_T | Interface table to load ADR rules into SLA. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | This is the application id. |
| NAME | This is the name of the account derivation rule. |
| DESCRIPTION | This is the description of the account derivation rule. |
| ERROR_VALUE | This indicates the error status of the row after processed by the ADR interface program. |
| AMB_CONTEXT_CODE | This is the context code associated to the account derivation rule. |
| SEGMENT_RULE_TYPE_CODE | This is the owner of the account derivation rule. |
| SEGMENT_RULE_CODE | This is the code of the account derivation rule. |
| TRANSACTION_COA_ID | This is the identifier of the chart of accounts associated to the ledger in which the transaction has been created. |
| ACCOUNTING_COA_ID | This is the identifier of the chart of accounts associated to the ledger in which the journal entry will be created. |
| FLEXFIELD_ASSIGN_MODE_CODE | This is the output type of the account derivation rule. |
| FLEXFIELD_SEGMENT_CODE | This is the code of the segment. |
| ENABLED_FLAG | This indicates if the account derivation rule is enabled. |
| Subledger Accounting - XLA_LINE_ASSGNS_T | Interface table to load the assignments between ADR rules and journal line types. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | This is the application id. |
| SEGMENT_RULE_TYPE_CODE | This is the owner of the account derivation rule. |
| SEGMENT_RULE_CODE | This is the code of the account derivation rule. |
| ERROR_VALUE | This indicates the error status of the row after processed by the ADR interface program. |
| AMB_CONTEXT_CODE | This is the context code associated to the account derivation rule. |
| EVENT_CLASS_CODE | This is the code of the event class associated to the journal line definition. |
| EVENT_TYPE_CODE | This is the code of the event type associated to the journal line definition. |
| LINE_DEFINITION_OWNER_CODE | This is the code of the owner of the journal line definition. |
| LINE_DEFINITION_CODE | This is the code of the journal line definition. |
| ACCOUNTING_LINE_TYPE_CODE | This is the code of the owner of the journal line type. |
| ACCOUNTING_LINE_CODE | This is the code of the journal line type. |
| FLEXFIELD_SEGMENT_CODE | This is the type of account derivation rule. |
| Subledger Accounting - XLA_CONDITIONS_T | Interface table to load the conditions associated to the ADR rule details into SLA. |
|---|---|
| Column Name | Descritpion |
| CONDITION_ID | This is the identifier of the condition. |
| SOURCE_TYPE_CODE | This is the type code of the source. |
| SOURCE_CODE | This is the code of the source. |
| FLEXFIELD_SEGMENT_CODE | This is the code of the flexfield segment. |
| VALUE_FLEXFIELD_SEGMENT_CODE | This is the code of the flexfield segment used as a value. |
| VALUE_SOURCE_APPLICATION_ID | This is the application id of the source used as a value. |
| VALUE_SOURCE_TYPE_CODE | This is the type code of the source used as a value. |
| VALUE_SOURCE_CODE | This is the code of the source used as a value. |
| VALUE_CONSTANT | This is the constant used as a value. |
| LINE_OPERATOR_CODE | This is the code of the line operator. |
| LOGICAL_OPERATOR_CODE | This is the code of the logical operator. |
| APPLICATION_ID | This is the application id. |
| INDEPENDENT_VALUE_CONSTANT | This is the constant used as independent value. |
| ERROR_VALUE | This indicates the error status of the row after processed by the ADR interface program. |
| AMB_CONTEXT_CODE | This is the context code associated to the account derivation rule. |
| SEGMENT_RULE_DETAIL_ID | This is the identifier of the detail. |
| USER_SEQUENCE | This is the user sequence of the condition. |
| BRACKET_LEFT_CODE | This is the left bracket of the condition. |
| BRACKET_RIGHT_CODE | This is the right bracket of the condition. |
| VALUE_TYPE_CODE | This is the type of the value of the condition. |
| SOURCE_APPLICATION_ID | This is the application id of the source. |
| Subledger Accounting - XLA_MERGE_SEG_MAPS | This table stores the segment mapping for third party merge |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | This is the application id. |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| PROGRAM_UPDATE_DATE | Concurrent Program who column - date when a program last updated this row). |
| PROGRAM_APPLICATION_ID | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). |
| PROGRAM_ID | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). |
| REQUEST_ID | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
| EVENT_ID | This is the third party merge event id. |
| LEDGER_ID | This is the ledger identifier for which the segment mapping happens. |
| SEGMENT_CODE | This is the segment code name for which the segment mapping happens. |
| FROM_VALUE | This is the original value of the mapping segment code before mapping. |
| TO_VALUE | This is the new value of the mapping segment code after mapping. |
| CHART_OF_ACCOUNTS_ID | This is the chart of accounts identifier for which the segment mapping happen. |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| Subledger Accounting - XLA_PARTIAL_MERGE_TXNS | This table stores the transactions to be processed for a partial third party merge |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | This is the application id. |
| SOURCE_ID_CHAR_2 | This is the second source identifier for the transaction. |
| SOURCE_ID_CHAR_3 | This is the third source identifier for the transaction. |
| SOURCE_ID_CHAR_4 | This is the forth source identifier for the transaction. |
| VALUATION_METHOD | This is the valuation method for the transaction. |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| PROGRAM_UPDATE_DATE | Concurrent Program who column - date when a program last updated this row). |
| MERGE_EVENT_ID | This is the third party merge event id. |
| PROGRAM_APPLICATION_ID | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). |
| PROGRAM_ID | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). |
| REQUEST_ID | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
| ENTITY_ID | This is the entity id for the transaction. |
| ENTITY_CODE | This is the entity code for the transaction. |
| SOURCE_ID_INT_1 | This is the first source identifier for the transaction. |
| SOURCE_ID_INT_2 | This is the second source identifier for the transaction. |
| SOURCE_ID_INT_3 | This is the third source identifier for the transaction. |
| SOURCE_ID_INT_4 | This is the forth source identifier for the transaction. |
| SOURCE_ID_CHAR_1 | This is the first source identifier for the transaction. |
| Subledger Accounting - XLA_TB_DEF_SEG_RANGES | This tables stores segment ranges generated based on Open Account Balances Listing report definition details. |
|---|---|
| Column Name | Descritpion |
| DEFINITION_CODE | Definition code for the Open Account Balances Listing definition |
| SEGMENT4_TO | High value of the SEGMENT4 column |
| SEGMENT5_FROM | Low value of the SEGMENT5 column |
| SEGMENT5_TO | High value of the SEGMENT5 column |
| SEGMENT6_FROM | Low value of the SEGMENT6 column |
| SEGMENT6_TO | High value of the SEGMENT6 column |
| SEGMENT7_FROM | Low value of the SEGMENT7 column |
| SEGMENT7_TO | High value of the SEGMENT7 column |
| SEGMENT8_FROM | Low value of the SEGMENT8 column |
| SEGMENT8_TO | High value of the SEGMENT8 column |
| SEGMENT9_FROM | Low value of the SEGMENT9 column |
| LINE_NUM | Line number |
| SEGMENT9_TO | High value of the SEGMENT9 column |
| SEGMENT10_FROM | Low value of the SEGMENT10 column |
| SEGMENT10_TO | High value of the SEGMENT10 column |
| SEGMENT11_FROM | Low value of the SEGMENT11 column |
| SEGMENT11_TO | High value of the SEGMENT11 column |
| SEGMENT12_FROM | Low value of the SEGMENT12 column |
| SEGMENT12_TO | High value of the SEGMENT12 column |
| SEGMENT13_FROM | Low value of the SEGMENT13 column |
| SEGMENT13_TO | High value of the SEGMENT13 column |
| SEGMENT14_FROM | Low value of the SEGMENT14 column |
| SEGMENT1_FROM | Low value of the SEGMENT1 column |
| SEGMENT14_TO | High value of the SEGMENT14 column |
| SEGMENT15_FROM | Low value of the SEGMENT15 column |
| SEGMENT15_TO | High value of the SEGMENT15 column |
| SEGMENT16_FROM | Low value of the SEGMENT16 column |
| SEGMENT16_TO | High value of the SEGMENT16 column |
| SEGMENT17_FROM | Low value of the SEGMENT17 column |
| SEGMENT17_TO | High value of the SEGMENT17 column |
| SEGMENT18_FROM | Low value of the SEGMENT18 column |
| SEGMENT18_TO | High value of the SEGMENT18 column |
| SEGMENT19_FROM | Low value of the SEGMENT19 column |
| SEGMENT1_TO | High value of the SEGMENT1 column |
| SEGMENT19_TO | High value of the SEGMENT19 column |
| SEGMENT20_FROM | Low value of the SEGMENT20 column |
| SEGMENT20_TO | High value of the SEGMENT20 column |
| SEGMENT21_FROM | Low value of the SEGMENT21 column |
| SEGMENT21_TO | High value of the SEGMENT21 column |
| SEGMENT22_FROM | Low value of the SEGMENT22 column |
| SEGMENT22_TO | High value of the SEGMENT22 column |
| SEGMENT23_FROM | Low value of the SEGMENT23 column |
| SEGMENT23_TO | High value of the SEGMENT23 column |
| SEGMENT24_FROM | Low value of the SEGMENT24 column |
| SEGMENT2_FROM | Low value of the SEGMENT2 column |
| SEGMENT24_TO | High value of the SEGMENT24 column |
| SEGMENT25_FROM | Low value of the SEGMENT25 column |
| SEGMENT25_TO | High value of the SEGMENT25 column |
| SEGMENT26_FROM | Low value of the SEGMENT26 column |
| SEGMENT26_TO | High value of the SEGMENT26 column |
| SEGMENT27_FROM | Low value of the SEGMENT27 column |
| SEGMENT27_TO | High value of the SEGMENT27 column |
| SEGMENT28_FROM | Low value of the SEGMENT28 column |
| SEGMENT28_TO | High value of the SEGMENT28 column |
| SEGMENT29_FROM | Low value of the SEGMENT29 column |
| SEGMENT2_TO | High value of the SEGMENT2 column |
| SEGMENT29_TO | High value of the SEGMENT29 column |
| SEGMENT30_FROM | Low value of the SEGMENT30 column |
| SEGMENT30_TO | High value of the SEGMENT30 column |
| BALANCE_DATE | The date the initial balance is effective |
| OWNER_CODE | Identifies the owner of the report detail row for the purpose of preventing removal of that row from the definition. |
| SEGMENT3_FROM | Low value of the SEGMENT3 column |
| SEGMENT3_TO | High value of the SEGMENT3 column |
| SEGMENT4_FROM | Low value of the SEGMENT4 column |
| Subledger Accounting - XLA_TB_WORK_UNITS | This table serves as a work unit table to process open account balances data in parallel. Accounting entries are split into multiple units based on ledger setups. |
|---|---|
| Column Name | Descritpion |
| PARENT_REQUEST_ID | Parent request id |
| REQUEST_ID | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
| GROUP_ID | Group idenitifier |
| DEFINITION_CODE | Definition code for the Open Account Balances Listing definition. |
| JE_SOURCE_NAME | Journal source name |
| UPG_BATCH_ID | Upgrade batch identifier |
| FROM_HEADER_ID | Low value of Accounting entry header id for the work unit |
| TO_HEADER_ID | High value of Accounting entry header id for the work unit |
| STATUS_CODE | Status of the group id and definition code being processed |
| Subledger Accounting - XLA_TB_DEFINITIONS_TL | This table stores translated information of the Open Account Balances Listing report definitions. |
|---|---|
| Column Name | Descritpion |
| DEFINITION_CODE | Definition code for the Open Account Balances Listing report definition |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| NAME | Name of the report definition |
| DESCRIPTION | Description of the report definition |
| LANGUAGE | Standard language code |
| SOURCE_LANG | Standard source language code |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| Subledger Accounting - XLA_TB_USER_TRANS_VIEWS | This table stores user transaction view information. |
|---|---|
| Column Name | Descritpion |
| DEFINITION_CODE | Definition code for the Open Account Balances Listing definition |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| REQUEST_ID | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
| PROGRAM_APPLICATION_ID | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). |
| PROGRAM_ID | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). |
| PROGRAM_UPDATE_DATE | Concurrent Program who column - date when a program last updated this row). |
| APPLICATION_ID | Application identifier of the event. |
| EVENT_CLASS_CODE | Event class code |
| REPORTING_VIEW_NAME | Reporting view name |
| SELECT_STRING | Selected column names for reporting views |
| FROM_STRING | From clause for reporting views |
| WHERE_STRING | Join conditions between xla_transaction_entities and reporting views |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| Subledger Accounting - XLA_TB_DEFINITIONS_B | This table stores Open Account Balances Listing definitions. |
|---|---|
| Column Name | Descritpion |
| DEFINITION_CODE | Definition code for the Open Account Balances Listing report definition |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| REQUEST_ID | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
| PROGRAM_APPLICATION_ID | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). |
| PROGRAM_ID | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). |
| PROGRAM_UPDATE_DATE | Concurrent Program who column - date when a program last updated this row). |
| OWNER_CODE | Determines whether the definition is owned by Oracle (updates prevented) or the user. |
| OBJECT_VERSION_NUMBER | Object version number |
| LEDGER_ID | Ledger identifier against which the Open Account Balances Listing is generated |
| ENABLED_FLAG | "Y'' or ''N'' flag indicating whether the Open Account Balances Listing definition is enabled or not. |
| BALANCE_SIDE_CODE | Determines the side of the journal entry that originates the charge against the account being reported |
| DEFINED_BY_CODE | Determines the side of the journal entry that originates the charge against the account being reported. |
| DEFINITION_STATUS_CODE | Indicates whether the definition needs to be reloaded into the trial balance table:''NEW'', ''RELOAD'', and ''PROCESSED''. This is for internal purposes. |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| Subledger Accounting - XLA_TB_LOGS | This table tracks concurrent requests of the Open Account Balances Listing Data Manager. |
|---|---|
| Column Name | Descritpion |
| REQUEST_ID | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
| LEDGER_ID | Ledger identifier |
| GROUP_ID | Group identifier |
| PROCESS_MODE_CODE | Process mode code: DELETED, CHANGED, and NEW |
| DEFINITION_CODE | Definition code for the Open Account Balances Listing definition |
| JE_SOURCE_NAME | Journal source name |
| DEFINITION_STATUS_CODE | Report definition status code |
| REQUEST_STATUS_CODE | Concurrent request status code |
| Subledger Accounting - XLA_TB_DEFN_DETAILS | This table stores the Open Account Balances Listing report definition details |
|---|---|
| Column Name | Descritpion |
| DEFINITION_DETAIL_ID | Definition Details Identifier |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| OWNER_CODE | Identifies the owner of the report detail row for the purpose of preventing removal of that row from the definition. |
| BALANCE_DATE | Date the balance is effective |
| BALANCE_AMOUNT | The balance forward for the account as of the balance date. |
| OBJECT_VERSION_NUMBER | Object version number |
| DEFINITION_CODE | Definition code for the Open Account Balances Listing definition. |
| FLEXFIELD_SEGMENT_CODE | This column stores the name of the segment whose values will be tracked for reporting. If null, then the definition is defined by a CCID. |
| SEGMENT_VALUE_FROM | Low value for the segment corresponding to the value in the FLEXFIELD_SEGMENT_CODE column. |
| SEGMENT_VALUE_TO | High value for the segment corresponding to the value in the FLEXFIELD_SEGMENT_CODE column. |
| CODE_COMBINATION_ID | The CCID that will be reported by this report definition. Must be null if XLA_TB_DEFINITIONS.DEFINED_BY_CODE is ''SEGMENT''. |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| Subledger Accounting - XLA_TB_DEFN_JE_SOURCES | This table stores journal sources associated with the Open Account Balances Listing report definitions. |
|---|---|
| Column Name | Descritpion |
| JE_SOURCE_NAME | Journal source name |
| OBJECT_VERSION_NUMBER | Object version number |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| OWNER_CODE | Identifies the owner of the journal source row for the purpose of preventing removal of that row from the definition. |
| DEFINITION_CODE | Definition code for the Open Account Balances Listing report definition |
| Subledger Accounting - XLA_GL_LEDGERS | This table contains ledger information used by subledger accounting. |
|---|---|
| Column Name | Descritpion |
| OBJECT_VERSION_NUMBER | Object version number |
| WORK_UNIT | Work unit for parallel processing |
| NUM_OF_WORKERS | Number of child processes |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| LEDGER_ID | Ledger identifier |
| Subledger Accounting - XLA_TPM_WORKING_HDRS_T | The journal header identifiers to be processed by third party merge event. |
|---|---|
| Column Name | Descritpion |
| MERGE_EVENT_ID | This is the third party merge event id. |
| AE_HEADER_ID | This is the ae header id for journal entry to be processed. |
| REQUEST_ID | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
| PROCESS_TYPE_FLAG | This flag indicates the different process that will be applied to the journal entry. |
| Subledger Accounting - XLA_UPGRADE_DATES | For SLA upgrade: contains start and enddate for a ledger. |
|---|---|
| Column Name | Descritpion |
| START_DATE | Start date for the first period to be upgraded. |
| END_DATE | End date for the last period to be upgraded. |
| LEDGER_ID | Ledger to be upgraded based on its periods. |
| Subledger Accounting - XLA_AAD_SOURCES | XLA_AAD_SOURCES table stores a list of sources used by an Application Accounting Definition. The table captures sources used by each event class within the Application Accounting Definition. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Internal Id of the application. |
| EXTRACT_OBJECT_NAME | Extract Object Name. |
| EXTRACT_OBJECT_TYPE_CODE | Extract Object Type. |
| ALWAYS_POPULATED_FLAG | Extract Object populated flag. |
| COLUMN_DATATYPE_CODE | Data Type of the extract object column. |
| SOURCE_HASH_ID | Source Hash Id used by the compiler. |
| SOURCE_APPLICATION_ID | Source application Id. |
| REFERENCE_OBJECT_FLAG | Reference object flag. |
| JOIN_CONDITION | Describes a join condition between a transaction object and the reference object. |
| CREATION_DATE | Standard who column - date when this row was created. |
| CREATED_BY | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
| AMB_CONTEXT_CODE | Accounting Methods Builder context. |
| LAST_UPDATE_DATE | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| LAST_UPDATE_LOGIN | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
| PROGRAM_UPDATE_DATE | Concurrent Program who column - date when a program last updated this row). |
| PROGRAM_APPLICATION_ID | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). |
| PROGRAM_ID | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). |
| REQUEST_ID | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
| PRODUCT_RULE_TYPE_CODE | Application Accounting Definition type code |
| PRODUCT_RULE_CODE | Application Accounting Definition code |
| ENTITY_CODE | Entity Code. |
| EVENT_CLASS_CODE | Event Class Code. |
| SOURCE_CODE | Source Code. |
| SOURCE_DATATYPE_CODE | Data Type of the source. |
| SOURCE_LEVEL_CODE | Level of source. |
| Subledger Accounting - XLA_UPGRADE_REQUESTS | For SLA upgrade: stores the parameters for each post upgrade request. |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | The application for which the post upgrade request is submitted. |
| WORKER_ID | Worker id for the upgrade program. |
| WORKERS_NUM | Number of workers. |
| TABLE_NAME | Name of the table updated by the upgrade program. |
| SCRIPT_NAME | Name of the script of the upgrade program. |
| BATCH_SIZE | Size of the batch for the upgrade program. |
| BATCH_ID | Batch id for the upgrade program. |
| ORDER_NUM | Order of the upgrade program. |
| START_DATE | Start date of the upgrade request. |
| END_DATE | End date of the upgrade request. |
| CREATION_DATE | Standard who column. |
| REQUEST_CONTROL_ID | Request id for the request that upgrades the data. |
| CREATED_BY | Standard who column. |
| LAST_UPDATE_DATE | Standard who column. |
| LAST_UPDATED_BY | Standard who column. |
| LAST_UPDATE_LOGIN | Standard who column. |
| PARENT_REQUEST_CONTROL_ID | Request id of the SLA post upgrade program submitted by the user. |
| PHASE_NUM | Phase of the upgrade program. |
| PROGRAM_CODE | Program code of the upgrade program. |
| DESCRIPTION | Description of the upgrade program. |
| STATUS_CODE | Status of the upgrade program. |
| LEDGER_ID | Ledger to be upgraded. |
| PERIOD_NAME | Name of the period to be upgraded. |
| Subledger Accounting - XLA_BAL_AC_CTRBS_GT | |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | |
| AC3 | |
| AC4 | |
| AC5 | |
| PERIOD_NAME | |
| PERIOD_YEAR | |
| CONTRIBUTION_DR | |
| CONTRIBUTION_CR | |
| NET_CONTRIBUTION_DR | |
| NET_CONTRIBUTION_CR | |
| BALANCE_STATUS_EFF_PER_NUM | |
| LEDGER_ID | |
| ACCOUNT_TYPE | |
| EFFECTIVE_PERIOD_NUM | |
| CODE_COMBINATION_ID | |
| ANALYTICAL_CRITERION_CODE | |
| ANALYTICAL_CRITERION_TYPE_CODE | |
| AMB_CONTEXT_CODE | |
| AC1 | |
| AC2 |
| Subledger Accounting - XLA_AE_HEADERS_GT | |
|---|---|
| Column Name | Descritpion |
| AE_HEADER_ID | |
| ACCOUNTING_ENTRY_TYPE_CODE | |
| ANC_ID_76 | |
| ANC_ID_77 | |
| ANC_ID_78 | |
| ANC_ID_79 | |
| ANC_ID_80 | |
| ANC_ID_81 | |
| ANC_ID_82 | |
| ANC_ID_83 | |
| ANC_ID_84 | |
| ANC_ID_85 | |
| PRODUCT_RULE_TYPE_CODE | |
| ANC_ID_86 | |
| ANC_ID_87 | |
| ANC_ID_88 | |
| ANC_ID_89 | |
| ANC_ID_90 | |
| ANC_ID_91 | |
| ANC_ID_92 | |
| ANC_ID_93 | |
| ANC_ID_94 | |
| ANC_ID_95 | |
| PRODUCT_RULE_CODE | |
| ANC_ID_96 | |
| ANC_ID_97 | |
| ANC_ID_98 | |
| ANC_ID_99 | |
| ANC_ID_100 | |
| EVENT_STATUS_CODE | |
| EVENT_NUMBER | |
| HEADER_NUM | |
| PARENT_HEADER_ID | |
| PARENT_AE_LINE_NUM | |
| PRODUCT_RULE_VERSION | |
| ACC_REV_GL_DATE_OPTION | |
| FIRST_DAY_NEXT_GL_PERIOD | |
| PERIOD_START_DATE | |
| PERIOD_END_DATE | |
| ACCRUAL_REVERSAL_FLAG | |
| FUNDS_STATUS_CODE | |
| AMB_CONTEXT_CODE | |
| DESCRIPTION | |
| BALANCE_TYPE_CODE | |
| BUDGET_VERSION_ID | |
| ENCUMBRANCE_TYPE_ID | |
| DOC_SEQUENCE_ID | |
| LEDGER_ID | |
| DOC_SEQUENCE_VALUE | |
| DOC_CATEGORY_CODE | |
| PERIOD_YEAR | |
| PERIOD_CLOSING_STATUS | |
| GL_TRANSFER_STATUS_CODE | |
| ANC_ID_1 | |
| ANC_ID_2 | |
| ANC_ID_3 | |
| ANC_ID_4 | |
| ANC_ID_5 | |
| ENTITY_ID | |
| ANC_ID_6 | |
| ANC_ID_7 | |
| ANC_ID_8 | |
| ANC_ID_9 | |
| ANC_ID_10 | |
| ANC_ID_11 | |
| ANC_ID_12 | |
| ANC_ID_13 | |
| ANC_ID_14 | |
| ANC_ID_15 | |
| EVENT_ID | |
| ANC_ID_16 | |
| ANC_ID_17 | |
| ANC_ID_18 | |
| ANC_ID_19 | |
| ANC_ID_20 | |
| ANC_ID_21 | |
| ANC_ID_22 | |
| ANC_ID_23 | |
| ANC_ID_24 | |
| ANC_ID_25 | |
| EVENT_TYPE_CODE | |
| ANC_ID_26 | |
| ANC_ID_27 | |
| ANC_ID_28 | |
| ANC_ID_29 | |
| ANC_ID_30 | |
| ANC_ID_31 | |
| ANC_ID_32 | |
| ANC_ID_33 | |
| ANC_ID_34 | |
| ANC_ID_35 | |
| ACCOUNTING_DATE | |
| ANC_ID_36 | |
| ANC_ID_37 | |
| ANC_ID_38 | |
| ANC_ID_39 | |
| ANC_ID_40 | |
| ANC_ID_41 | |
| ANC_ID_42 | |
| ANC_ID_43 | |
| ANC_ID_44 | |
| ANC_ID_45 | |
| PERIOD_NAME | |
| ANC_ID_46 | |
| ANC_ID_47 | |
| ANC_ID_48 | |
| ANC_ID_49 | |
| ANC_ID_50 | |
| ANC_ID_51 | |
| ANC_ID_52 | |
| ANC_ID_53 | |
| ANC_ID_54 | |
| ANC_ID_55 | |
| JE_CATEGORY_NAME | |
| ANC_ID_56 | |
| ANC_ID_57 | |
| ANC_ID_58 | |
| ANC_ID_59 | |
| ANC_ID_60 | |
| ANC_ID_61 | |
| ANC_ID_62 | |
| ANC_ID_63 | |
| ANC_ID_64 | |
| ANC_ID_65 | |
| ACCOUNTING_ENTRY_STATUS_CODE | |
| ANC_ID_66 | |
| ANC_ID_67 | |
| ANC_ID_68 | |
| ANC_ID_69 | |
| ANC_ID_70 | |
| ANC_ID_71 | |
| ANC_ID_72 | |
| ANC_ID_73 | |
| ANC_ID_74 | |
| ANC_ID_75 |
| Subledger Accounting - XLA_AE_LINE_ACS | This table stores the relationship between the subledger journal entry lines and the analytical detail values. |
|---|---|
| Column Name | Descritpion |
| AE_HEADER_ID | Journal entry identifier |
| AC4 | Supporting reference detail value |
| AC5 | Supporting reference detail value |
| AE_LINE_NUM | Line number |
| ANALYTICAL_CRITERION_CODE | Supporting reference code |
| ANALYTICAL_CRITERION_TYPE_CODE | Supporting reference type code |
| AMB_CONTEXT_CODE | AMB context code |
| OBJECT_VERSION_NUMBER | Object version number |
| AC1 | Supporting reference detail value |
| AC2 | Supporting reference detail value |
| AC3 | Supporting reference detail value |
| Subledger Accounting - XLA_AC_BALANCES | |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | Internal Id of the application |
| AC4 | Supporting reference 4 |
| AC5 | Supporting reference 5 |
| PERIOD_NAME | Accounting period name |
| BEGINNING_BALANCE_DR | Begenning balance for the period (DR) |
| BEGINNING_BALANCE_CR | Begenning balance for the period (CR) |
| PERIOD_BALANCE_DR | Current balance for the period (DR): made up of the period activity |
| PERIOD_BALANCE_CR | Current balance for the period (CR): made up of the period activity |
| INITIAL_BALANCE_FLAG | Flag that shows if this is an initial balance: Y: initial balance N: non initial balance |
| FIRST_PERIOD_FLAG | This flag indicates if this is the first period in a fiscal year for which balances have been calculated for a given key: Y: first period in a fiscal year N: not first period in a fiscal year |
| PERIOD_YEAR | Fiscal year of the period |
| LEDGER_ID | Ledger id |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| PROGRAM_UPDATE_DATE | Standard Who column |
| PROGRAM_APPLICATION_ID | Standard Who column |
| PROGRAM_ID | Standard Who column |
| REQUEST_ID | |
| EFFECTIVE_PERIOD_NUM | |
| CODE_COMBINATION_ID | Code combination id |
| ANALYTICAL_CRITERION_CODE | Supporting reference code |
| ANALYTICAL_CRITERION_TYPE_CODE | Supporting reference type code |
| AMB_CONTEXT_CODE | AMB context code |
| AC1 | Supporting reference 1 |
| AC2 | Supporting reference 2 |
| AC3 | Supporting reference 3 |
| Subledger Accounting - XLA_AE_HEADER_ACS | This table stores the relationship between the subledger journal entry lines and the supporting reference detail values. |
|---|---|
| Column Name | Descritpion |
| AE_HEADER_ID | Journal entry identifier |
| AC5 | Supporting reference detail value |
| ANALYTICAL_CRITERION_CODE | Supporting reference code |
| ANALYTICAL_CRITERION_TYPE_CODE | Supporting reference type code |
| AMB_CONTEXT_CODE | AMB context code |
| OBJECT_VERSION_NUMBER | Object version number |
| AC1 | Supporting reference detail value |
| AC2 | Supporting reference detail value |
| AC3 | Supporting reference detail value |
| AC4 | Supporting reference detail value |
| Subledger Accounting - XLA_TRIAL_BALANCES_GT | |
|---|---|
| Column Name | Descritpion |
| DEFINITION_CODE | |
| APPLIED_TO_ENTITY_ID | |
| APPLIED_TO_APPLICATION_ID | |
| APPLIED_TO_ENTITY_CODE | |
| EVENT_CLASS_CODE | |
| TRANSACTION_NUMBER | |
| CODE_COMBINATION_ID | |
| GL_DATE | |
| TRX_CURRENCY_CODE | |
| ENTERED_UNROUNDED_ORIG_AMOUNT | |
| ENTERED_UNROUNDED_REM_AMOUNT | |
| LEDGER_ID | |
| ENTERED_ROUNDED_ORIG_AMOUNT | |
| ENTERED_ROUNDED_REM_AMOUNT | |
| ACCTD_UNROUNDED_ORIG_AMOUNT | |
| ACCTD_UNROUNDED_REM_AMOUNT | |
| ACCTD_ROUNDED_ORIG_AMOUNT | |
| ACCTD_ROUNDED_REM_AMOUNT | |
| THIRD_PARTY_NAME | |
| THIRD_PARTY_NUMBER | |
| THIRD_PARTY_TYPE_CODE | |
| THIRD_PARTY_TYPE | |
| LEDGER_NAME | |
| THIRD_PARTY_SITE_NAME | |
| THIRD_PARTY_ACCOUNT_NUMBER | |
| BALANCING_SEGMENT_VALUE | |
| NATURAL_ACCOUNT_SEGMENT_VALUE | |
| COST_CENTER_SEGMENT_VALUE | |
| INTERCOMPANY_SEGMENT_VALUE | |
| MANAGEMENT_SEGMENT_VALUE | |
| USER_TRX_IDENTIFIER_NAME_1 | |
| USER_TRX_IDENTIFIER_VALUE_1 | |
| USER_TRX_IDENTIFIER_NAME_2 | |
| LEDGER_SHORT_NAME | |
| USER_TRX_IDENTIFIER_VALUE_2 | |
| USER_TRX_IDENTIFIER_NAME_3 | |
| USER_TRX_IDENTIFIER_VALUE_3 | |
| USER_TRX_IDENTIFIER_NAME_4 | |
| USER_TRX_IDENTIFIER_VALUE_4 | |
| USER_TRX_IDENTIFIER_NAME_5 | |
| USER_TRX_IDENTIFIER_VALUE_5 | |
| USER_TRX_IDENTIFIER_NAME_6 | |
| USER_TRX_IDENTIFIER_VALUE_6 | |
| USER_TRX_IDENTIFIER_NAME_7 | |
| LEDGER_CURRENCY_CODE | |
| USER_TRX_IDENTIFIER_VALUE_7 | |
| USER_TRX_IDENTIFIER_NAME_8 | |
| USER_TRX_IDENTIFIER_VALUE_8 | |
| USER_TRX_IDENTIFIER_NAME_9 | |
| USER_TRX_IDENTIFIER_VALUE_9 | |
| USER_TRX_IDENTIFIER_NAME_10 | |
| USER_TRX_IDENTIFIER_VALUE_10 | |
| NON_AP_AMOUNT | |
| MANUAL_SLA_AMOUNT | |
| RECORD_TYPE_CODE | |
| SOURCE_ENTITY_ID | |
| SOURCE_APPLICATION_ID | |
| SOURCE_ENTITY_CODE |
| Subledger Accounting - XLA_AADS_GT | |
|---|---|
| Column Name | Descritpion |
| PRODUCT_RULE_CODE | |
| SEGMENT_RULE_CODE | |
| SOURCE_CODE | |
| DESCRIPTION_CODE | |
| ANALYTICAL_CRITERION_CODE | |
| ANALYTICAL_DETAIL_CODE | |
| TABLE_NAME | |
| ENTITY_CODE | |
| EVENT_CLASS_CODE | |
| EVENT_TYPE_CODE | |
| LINE_DEFINITION_CODE | |
| ACCOUNTING_ATTRIBUTE_CODE | |
| ACCOUNTING_LINE_CODE | |
| MPA_ACCOUNTING_LINE_CODE | |
| ACCOUNTING_CLASS_CODE |
| Subledger Accounting - XLA_BAL_CONCURRENCY_CONTROL | |
|---|---|
| Column Name | Descritpion |
| LEDGER_ID | |
| APPLICATION_ID | |
| CONCURRENCY_CLASS | |
| ACCOUNTING_BATCH_ID | |
| EXECUTION_MODE | |
| REQUEST_ID |
| Subledger Accounting - XLA_CTRL_BAL_INTERIM_GT | |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | |
| PERIOD_BALANCE_DR | |
| PERIOD_BALANCE_CR | |
| BEGINNING_BALANCE_DR | |
| BEGINNING_BALANCE_CR | |
| LEDGER_ID | |
| CODE_COMBINATION_ID | |
| PARTY_TYPE_CODE | |
| PARTY_ID | |
| PARTY_SITE_ID | |
| PERIOD_NAME | |
| EFFECTIVE_PERIOD_NUM | |
| PERIOD_YEAR |
| Subledger Accounting - XLA_AC_BAL_INTERIM_GT | |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | |
| AC4 | |
| AC5 | |
| PERIOD_NAME | |
| EFFECTIVE_PERIOD_NUM | |
| PERIOD_YEAR | |
| PERIOD_BALANCE_DR | |
| PERIOD_BALANCE_CR | |
| BEGINNING_BALANCE_DR | |
| BEGINNING_BALANCE_CR | |
| LEDGER_ID | |
| CODE_COMBINATION_ID | |
| ANALYTICAL_CRITERION_CODE | |
| ANALYTICAL_CRITERION_TYPE_CODE | |
| AMB_CONTEXT_CODE | |
| AC1 | |
| AC2 | |
| AC3 |
| Subledger Accounting - XLA_HISTORIC_CONTROL | |
|---|---|
| Column Name | Descritpion |
| PRIMARY_LEDGER | |
| NUM_WORKERS | |
| STATUS | |
| LEDGER_CATEGORY_CODE | |
| LAST_UPDATE_DATE | |
| PRIMARY_CURRENCY_CODE | |
| SEC_ALC_CURRENCY_CODE | |
| SEC_ALC_MAU | |
| SEC_ALC_PRECISION | |
| CONVERSION_OPTION | |
| CURRENCY_CONVERSION_TYPE | |
| SECONDARY_ALC_LEDGER | |
| CURRENCY_CONVERSION_DATE | |
| PRIMARY_SLAM | |
| PRIMARY_COA | |
| PRIMARY_SLAM_TYPE | |
| PRIMARY_AAD | |
| PRIMARY_AAD_OWNER | |
| SECONDARY_SLAM | |
| SECONDARY_COA | |
| SECONDARY_SLAM_TYPE | |
| SECONDARY_AAD | |
| APPLICATION_ID | |
| SECONDARY_AAD_OWNER | |
| MAPPING_RELATIONSHIP_ID | |
| COA_MAPPING_NAME | |
| PRIMARY_CAL_SET_NAME | |
| PRIMARY_CAL_PER_TYPE | |
| PRIMARY_SEC_ALC_SET_NAME | |
| PRIMARY_SEC_ALC_PER_TYPE | |
| DYNAMIC_INSERTS | |
| SEC_ALC_MIN_ACCTNG_BATCH_ID | |
| PARENT_REQUEST_ID | |
| UPGRADE_ID | |
| RELATIONSHIP_ID | |
| SCRIPT_NAME | |
| START_DATE | |
| END_DATE | |
| BATCH_SIZE |
| Subledger Accounting - XLA_HISTORIC_MAPPING_GT | |
|---|---|
| Column Name | Descritpion |
| PRIMARY_HEADER_ID | |
| NEW_HEADER_ID |
No hay comentarios:
Publicar un comentario