IBY_EXTERNAL_PAYEES_V

Details

• Schema: FUSION

• Object owner: IBY

• Object type: VIEW

Columns

Name

EXT_PAYEE_ID PAYEE_PARTY_ID PAYMENT_FUNCTION PARTY_SITE_ID SUPPLIER_SITE_ID ORG_ID ORG_TYPE EXCLUSIVE_PAYMENT_FLAG ECE_TP_LOCATION_CODE BANK_CHARGE_BEARER BANK_INSTRUCTION1_CODE BANK_INSTRUCTION2_CODE BANK_INSTRUCTION_DETAILS PAYMENT_REASON_CODE PAYMENT_REASON_COMMENTS PAYMENT_TEXT_MESSAGE1 PAYMENT_TEXT_MESSAGE2 PAYMENT_TEXT_MESSAGE3 DELIVERY_CHANNEL_CODE LOCAL_INSTRUMENT_CODE PAYMENT_FORMAT_CODE SETTLEMENT_PRIORITY START_DATE END_DATE

Query

SQL_Statement

SELECT PAYEE.EXT_PAYEE_ID, PAYEE.PAYEE_PARTY_ID, PAYEE.PAYMENT_FUNCTION, PAYEE.PARTY_SITE_ID, PAYEE.SUPPLIER_SITE_ID, PAYEE.ORG_ID, PAYEE.ORG_TYPE, PAYEE.EXCLUSIVE_PAYMENT_FLAG, PAYEE.ECE_TP_LOCATION_CODE, PAYEE.BANK_CHARGE_BEARER, PAYEE.BANK_INSTRUCTION1_CODE, PAYEE.BANK_INSTRUCTION2_CODE, PAYEE.BANK_INSTRUCTION_DETAILS, PAYEE.PAYMENT_REASON_CODE, PAYEE.PAYMENT_REASON_COMMENTS, PAYEE.PAYMENT_TEXT_MESSAGE1, PAYEE.PAYMENT_TEXT_MESSAGE2, PAYEE.PAYMENT_TEXT_MESSAGE3, PAYEE.DELIVERY_CHANNEL_CODE, PAYEE.LOCAL_INSTRUMENT_CODE, PAYEE.PAYMENT_FORMAT_CODE, PAYEE.SETTLEMENT_PRIORITY, START_DATE, END_DATE FROM IBY_EXTERNAL_PAYEES_ALL PAYEE