ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 885D3A8197686BFBE0530100007F2A57Y select fav.application_name, fav.application_short_name, xeim.application_id, xeim.entity_code, lower(xeim.xte_column) xte_column, lower(xeim.transaction_column) transaction_column, case when xeim.application_id=140 and xeim.entity_code='DEFERRED_DEPRECIATION' then 'fa_deprn_summary' when xeim.application_id=140 and xeim.entity_code='DEPRECIATION' then 'fa_deprn_summary' when xeim.application_id=140 and xeim.entity_code='INTER_ASSET_TRANSACTIONS' then 'fa_trx_references' when xeim.application_id=140 and xeim.entity_code='TRANSACTIONS' then 'fa_transaction_headers' when xeim.application_id=260 and xeim.entity_code='CE_CASHFLOWS' then 'ce_cashflows' when xeim.application_id=8407 and xeim.entity_code='CC_CONTRACTS' then 'igc_cc_headers_all' when xeim.application_id=8407 and xeim.entity_code='CC_PROJECTS' then 'igc_cc_headers_all' when xeim.application_id=8407 and xeim.entity_code='CC_PURCHASE_ORDERS' then 'igc_cc_headers_all' when xeim.application_id=8407 and xeim.entity_code='CC_REQUISITIONS' then 'igc_cc_headers_all' when xeim.application_id=20065 and xeim.entity_code='DEPOSITS' then '' when xeim.application_id=20065 and xeim.entity_code='INVESTMENTS' then '' when xeim.application_id=20065 and xeim.entity_code='LINESOFCREDIT' then '' when xeim.application_id=20065 and xeim.entity_code='LOANS' then '' when xeim.application_id=707 and xeim.entity_code='MTL_ACCOUNTING_EVENTS' then 'mtl_material_transactions' when xeim.application_id=707 and xeim.entity_code='RCV_ACCOUNTING_EVENTS' then 'rcv_transactions' when xeim.application_id=707 and xeim.entity_code='WIP_ACCOUNTING_EVENTS' then 'wip_transactions' when xeim.application_id=707 and xeim.entity_code='WO_ACCOUNTING_EVENTS' then 'cst_write_offs' when xeim.application_id=8901 and xeim.entity_code='BE_RPR_TRANSACTIONS' then 'fv_be_rpr_transactions' when xeim.application_id=8901 and xeim.entity_code='BE_TRANSACTIONS' then 'fv_be_trx_hdrs' when xeim.application_id=8901 and xeim.entity_code='TREASURY_CONFIRMATION' then 'fv_treasury_confirmations_all' when xeim.application_id=20066 and xeim.entity_code='INSURANCE' then '' when xeim.application_id=20066 and xeim.entity_code='INTERESTRATESWAPS' then '' when xeim.application_id=20066 and xeim.entity_code='INVESTMENTS' then '' when xeim.application_id=540 and xeim.entity_code='AM_QUOTES' then 'okl_trx_quotes_all_b' when xeim.application_id=540 and xeim.entity_code='ASSETS' then 'okl_trx_assets' when xeim.application_id=540 and xeim.entity_code='CONTRACTS' then 'okl_trx_contracts_all' when xeim.application_id=540 and xeim.entity_code='INVESTOR_AGREEMENTS' then 'okl_trx_contracts_all' when xeim.application_id=540 and xeim.entity_code='SALES_QUOTES' then 'okl_trx_quotes_all_b' when xeim.application_id=540 and xeim.entity_code='TAX_SCHEDULE_REQUESTS' then 'okl_trx_requests' when xeim.application_id=540 and xeim.entity_code='TRANSACTIONS' then 'okl_trx_contracts_all' when xeim.application_id=206 and xeim.entity_code='LOANS' then 'lns_loan_headers_all' when xeim.application_id=9000 and xeim.entity_code='CLAIM_SETTLEMENT' then 'dpp_transaction_headers_all' when xeim.application_id=9000 and xeim.entity_code='COST_UPDATE' then 'dpp_transaction_headers_all' when xeim.application_id=200 and xeim.entity_code='AP_INVOICES' then 'ap_invoices_all' when xeim.application_id=200 and xeim.entity_code='AP_PAYMENTS' then 'ap_checks_all' when xeim.application_id=801 and xeim.entity_code='ASSIGNMENTS' then 'pay_assignment_actions' when xeim.application_id=555 and xeim.entity_code='INVENTORY' then 'gmf_xla_extract_headers (mtl_material_transactions)' when xeim.application_id=555 and xeim.entity_code='ORDERMANAGEMENT' then 'gmf_xla_extract_headers (mtl_material_transactions)' when xeim.application_id=555 and xeim.entity_code='PRODUCTION' then 'gmf_xla_extract_headers (gme_batch_header/mtl_material_transactions)' when xeim.application_id=555 and xeim.entity_code='PURCHASING' then 'gmf_xla_extract_headers (rcv_transactions/mtl_material_transactions)' when xeim.application_id=555 and xeim.entity_code='REVALUATION' then 'gmf_xla_extract_headers (gmf_period_balances/cm_adjs_dtl/gmf_lot_cost_adjustments)' when xeim.application_id=275 and xeim.entity_code='BUDGETS' then 'pa_budget_versions' when xeim.application_id=275 and xeim.entity_code='EXPENDITURES' then 'pa_expenditure_items_all' when xeim.application_id=275 and xeim.entity_code='REVENUE' then 'pa_draft_revenues_all' when xeim.application_id=240 and xeim.entity_code='LEASE CONTRACT' then 'pn_acct_trx_headers_all' when xeim.application_id=240 and xeim.entity_code='TRANSACTION' then 'pn_payment_items_all' when xeim.application_id=201 and xeim.entity_code='PURCHASE_ORDER' then 'po_headers_all' when xeim.application_id=201 and xeim.entity_code='RELEASE' then 'po_releases_all' when xeim.application_id=201 and xeim.entity_code='REQUISITION' then 'po_requisition_headers_all' when xeim.application_id=222 and xeim.entity_code='ADJUSTMENTS' then 'ar_adjustments_all' when xeim.application_id=222 and xeim.entity_code='BILLS_RECEIVABLE' then 'ra_customer_trx_all' when xeim.application_id=222 and xeim.entity_code='JL_BR_AR_COLL_DOC_OCCS' then 'jl_br_ar_collection_docs_all' when xeim.application_id=222 and xeim.entity_code='RECEIPTS' then 'ar_cash_receipts_all' when xeim.application_id=222 and xeim.entity_code='TRANSACTIONS' then 'ra_customer_trx_all' when xeim.application_id=682 and xeim.entity_code='ACCRUAL' then 'ozf_funds_utilized_all_b' when xeim.application_id=682 and xeim.entity_code='CLAIM_SETTLEMENT' then 'ozf_claims_all' end transaction_table from ( select 1 seq_num, xeim.application_id, xeim.entity_code, xeim.source_id_col_name_1 xte_column, xeim.transaction_id_col_name_1 transaction_column from xla_entity_id_mappings xeim where xeim.source_id_col_name_1 is not null union all select 2 seq_num, xeim.application_id, xeim.entity_code, xeim.source_id_col_name_2 xte_column, xeim.transaction_id_col_name_2 transaction_column from xla_entity_id_mappings xeim where xeim.source_id_col_name_2 is not null union all select 3 seq_num, xeim.application_id, xeim.entity_code, xeim.source_id_col_name_3 xte_column, xeim.transaction_id_col_name_3 transaction_column from xla_entity_id_mappings xeim where xeim.source_id_col_name_3 is not null union all select 4 seq_num, xeim.application_id, xeim.entity_code, xeim.source_id_col_name_4 xte_column, xeim.transaction_id_col_name_4 transaction_column from xla_entity_id_mappings xeim where xeim.source_id_col_name_4 is not null ) xeim, fnd_application_vl fav where xeim.application_id=fav.application_id order by fav.application_name, xeim.entity_code, xeim.seq_num AR XLA Entity ID Mappings يُظهر ارتباط العمود بين الجدول xla_transaction_entities وجداول مصدر دفتر الأستاذ الفرعي مثل AP invoice_id أو AR customer_trx_id ، والتي تُستخدم عند كتابة استعلامات تربط GL بدفتر الأستاذ الفرعي مثل تقرير تحليل حساب GL www.enginatics.com/reports/gl-account-analysis/ D XLA Entity ID Mappings Zeigt die Spaltenverknüpfung zwischen der Tabelle xla_transaction_entities und den Quelltabellen der Nebenbuchhaltung an, wie z. B. AP invoice_id oder AR customer_trx_id, die beim Schreiben von Abfragen zur Verknüpfung von GL und Nebenbuchhaltung verwendet wird, wie z. B. der GL-Kontenanalysebericht www.enginatics.com/reports/gl-account-analysis/ E XLA Entity ID Mappings Muestra el enlace de la columna entre la tabla xla_transaction_entities y las tablas de origen del libro mayor, como y AP invoice_id o AR customer_trx_id, que se utiliza cuando se escriben consultas que enlazan el libro mayor con el libro mayor, como el informe de análisis de cuentas del libro mayor www.enginatics.com/reports/gl-account-analysis/ F XLA Entity ID Mappings Montre le lien de colonne entre la table xla_transaction_entities et les tables sources du livre auxiliaire telles que et AP invoice_id ou AR customer_trx_id, utilisées lors de la rédaction des requêtes reliant GL au livre auxiliaire, comme le rapport d'analyse des comptes GL www.enginatics.com/reports/gl-account-analysis/ I XLA Entity ID Mappings Mostra il collegamento di colonna tra la tabella xla_transaction_entities e le tabelle di origine subledger come AP invoice_id o AR customer_trx_id, usato quando si scrivono query che collegano GL a subledger come il rapporto GL Account Analysis www.enginatics.com/reports/gl-account-analysis/ JA XLA Entity ID Mappings GL アカウント分析レポート www.enginatics.com/reports/gl-account-analysis/ のように GL をサブレガーにリンクするクエリを作成する際に使用される、xla_transaction_entities テーブルと AP invoice_id や AR customer_trx_id などのサブレガーのソーステーブル間のカラムリンクを表示します。 KO XLA Entity ID Mappings GL 계정 분석 보고서 www.enginatics.com/reports/gl-account-analysis/와 같이 GL을 보조 원장에 연결하는 질의를 작성할 때 사용되는 xla_transaction_entities 테이블과 AP invoice_id 또는 AR customer_trx_id와 같은 보조 원장 소스 테이블 간의 열 링크를 표시합니다. PTB XLA Entity ID Mappings Mostra o link da coluna entre a tabela xla_transaction_entities e as tabelas de origem do subledger, tais como e a tabela AP invoice_id ou AR customer_trx_id, usada ao escrever consultas que ligam a GL ao subledger, tais como o relatório de análise de conta da GL www.enginatics.com/reports/gl-account-analysis/ RU XLA Entity ID Mappings Показывает связь столбца между таблицей xla_transaction_entities и исходными таблицами подуровня, такими как и AP invoice_id или AR customer_trx_id, используемую при написании запросов, связывающих GL с подуровнем, например, отчет по анализу счетов GL www.enginatics.com/reports/gl-account-analysis/. S XLA Entity ID Mappings Visar kolumnlänken mellan tabellen xla_transaction_entities och källtabellerna för underledare såsom och AP invoice_id eller AR customer_trx_id, som används när du skriver frågor som länkar GL till underledare såsom GL Account Analysis-rapporten www.enginatics.com/reports/gl-account-analysis/ TR XLA Entity ID Mappings Xla_transaction_entities tablosu ile alt defter kaynak tabloları arasındaki sütun bağlantısını gösterir AP invoice_id veya AR customer_trx_id, GL'yi GL Hesap Analizi raporu www.enginatics.com/reports/gl-account-analysis/ gibi alt deftere bağlayan sorgular yazarken kullanılır US XLA Entity ID Mappings Shows the column link between table xla_transaction_entities and subledger source tables such as and AP invoice_id or AR customer_trx_id, used when writing queries linking GL to subledger such as the GL Account Analysis report www.enginatics.com/reports/gl-account-analysis/ ZHS XLA Entity ID Mappings 显示表xla_transaction_entities和子账源表（如和AP invoice_id或AR customer_trx_id）之间的列链接，用于编写连接GL和子账的查询，如GL账户分析报告www.enginatics.com/reports/gl-account-analysis/。 Enginatics R12 only