IBY_XML_FD_AMEX_PMT_1_0_V

Details

• Schema: FUSION

• Object owner: IBY

• Object type: VIEW

Columns

Name
DOCS_AGG PAYMENT_INSTRUCTION_ID INTERNAL_BANK_ACCOUNT_ID LEGAL_ENTITY_ID PAYMENT_ID PAYMENT_REFERENCE_NUMBER PAYMENT_STATUS PAYMENT_SERVICE_REQUEST_ID

Query

SQL_Statement

SELECT iby_fd_extract_gen_pvt.get_pmt_docpayableagg(pmt.payment_id) DOCS_AGG, pmt.payment_instruction_id PAYMENT_INSTRUCTION_ID, pmt.internal_bank_account_id INTERNAL_BANK_ACCOUNT_ID, pmt.legal_entity_id LEGAL_ENTITY_ID, pmt.payment_id PAYMENT_ID, pmt.payment_reference_number PAYMENT_REFERENCE_NUMBER, pmt.payment_status PAYMENT_STATUS, pmt.payment_service_request_id PAYMENT_SERVICE_REQUEST_ID FROM iby_ext_fd_pmt_1_0_v pmt