AR_XCC_DIST_EXTRACT_V

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name

DATA_SET_ID SOURCE_HEADER_ID_1 SOURCE_HEADER_ID_2 SOURCE_LINE_ID_1 SOURCE_LINE_ID_2 SOURCE_LINE_ID_3 SOURCE_LINE_ID_4 SOURCE_LINE_ID_5 SOURCE_LINE_ID_6 TRANSACTION_NUMBER LINE_GROUP_CODE LINE_NUM LEDGER_ID BUSINESS_UNIT_ID DESTINATION_TYPE_CODE DOCUMENT_TYPE_CODE TRANSACTION_SOURCE_CODE TRANSACTION_SUBTYPE_CODE JE_SOURCE_CODE JE_CATEGORY_CODE BUDGET_DATE ACCOUNTING_DATE ENCUMBRANCE_TYPE_CODE ENTERED_CURRENCY UOM_CODE QUANTITY PRICE ENTERED_AMOUNT REVENUE_CODE_COMBINATION_ID CASH_CODE_COMBINATION_ID CONVERSION_TYPE_CODE CONVERSION_DATE LEDGER_AMOUNT LIQUIDATION_DATE LIQUIDATION_QUANTITY LIQUIDATION_AMOUNT LIQUIDATION_TRANS_TYPE_CODE LIQUIDATION_LINE_ID_1 LIQUIDATION_LINE_ID_2 LIQUIDATION_LINE_ID_3 LIQUIDATION_LINE_ID_4 LIQUIDATION_LINE_ID_5 LIQUIDATION_LINE_ID_6 STATISTICAL_AMOUNT BUDGET_CCID VENDOR_ID INVENTORY_ITEM_ID ORDER_TYPE_INFO CODE_COMBINATION_ID PJC_PROJECT_ID PJC_TASK_ID PJC_RESOURCE_ID PJC_CONTRACT_ID PJC_CONTRACT_LINE_ID PJC_FUNDING_ALLOCATION_ID PJC_BILLABLE_FLAG PJC_CAPITALIZABLE_FLAG PJC_EXPENDITURE_TYPE_ID PJC_EXPENDITURE_ITEM_DATE PJC_ORGANIZATION_ID PJC_WORK_TYPE_ID CONTROL_BUDGET_ID SOURCE_LINE_TYPE_CODE

Query

SQL_Statement

SELECT dlb.data_set_id data_set_id, TO_CHAR(dlb.cash_receipt_id) source_header_id_1, dlb.receipt_type_code source_header_id_2, TO_CHAR(dlb.cash_receipt_id) source_line_id_1, TO_CHAR(DECODE(dlb.receipt_type_code ,'MISC', dlb.application_reference_id, dlb.applied_payment_schedule_id)) source_line_id_2, TO_CHAR(DECODE(dlb.receipt_type_code ,'MISC', dlb.cust_trx_line_gl_dist_id, dlb.applied_customer_trx_id)) source_line_id_3, TO_CHAR(dlb.customer_trx_line_id) source_line_id_4, TO_CHAR(DECODE(dlb.receipt_type_code ,'MISC',NULL,dlb.cust_trx_line_gl_dist_id)) source_line_id_5, ' ' source_line_id_6, dlb.receipt_number transaction_number, NULL line_group_code, NULL line_num, dlb.ledger_id ledger_id, dlb.receipt_bu_id business_unit_id, NULL destination_type_code, NULL document_type_code, NULL transaction_source_code, 'BUDGET_AR_RECEIPT' transaction_subtype_code, NULL je_source_code, NULL je_category_code, dlb.apply_date budget_date, dlb.apply_date accounting_date, NULL encumbrance_type_code, dlb.receipt_currency_code entered_currency, NULL uom_code, NULL quantity, NULL price, dlb.budget_amount entered_amount, dlb.revenue_code_combination_id, dlb.cash_code_combination_id, NULL conversion_type_code, NULL conversion_date, NULL ledger_amount, NULL liquidation_date, NULL liquidation_quantity, NULL liquidation_amount, NULL liquidation_trans_type_code, NULL liquidation_line_id_1, NULL liquidation_line_id_2, NULL liquidation_line_id_3, NULL liquidation_line_id_4, NULL liquidation_line_id_5, NULL liquidation_line_id_6, NULL statistical_amount, NULL budget_ccid, NULL vendor_id, NULL inventory_item_id, NULL order_type_info, NULL code_combination_id, NULL pjc_project_id, NULL pjc_task_id, NULL pjc_resource_id, NULL pjc_contract_id, NULL pjc_contract_line_id, NULL pjc_funding_allocation_id, NULL pjc_billable_flag, NULL pjc_capitalizable_flag, NULL pjc_expenditure_type_id, NULL pjc_expenditure_item_date, NULL pjc_organization_id, NULL pjc_work_type_id, NULL control_budget_id, dlb.account_class source_line_type_code FROM AR_TRX_DIST_LINE_BALANCES_ALL dlb