Skip to content
[Home] [Help]
View: IBY_EXTERNAL_PAYEES_V
View Text
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.DEFAULT_PAYMENT_METHOD_CODE
, 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.INACTIVE_DATE
, PAYEE.PAYMENT_TEXT_MESSAGE1
, PAYEE.PAYMENT_TEXT_MESSAGE2
, PAYEE.PAYMENT_TEXT_MESSAGE3
, PAYEE.DELIVERY_CHANNEL_CODE
, PAYEE.PAYMENT_FORMAT_CODE
, PAYEE.SETTLEMENT_PRIORITY
FROM IBY_EXTERNAL_PAYEES_ALL PAYEE
Columns
| Name |
| EXT_PAYEE_ID |
| PAYEE_PARTY_ID |
| PAYMENT_FUNCTION |
| PARTY_SITE_ID |
| SUPPLIER_SITE_ID |
| ORG_ID |
| ORG_TYPE |
| EXCLUSIVE_PAYMENT_FLAG |
| DEFAULT_PAYMENT_METHOD_CODE |
| ECE_TP_LOCATION_CODE |
| BANK_CHARGE_BEARER |
| BANK_INSTRUCTION1_CODE |
| BANK_INSTRUCTION2_CODE |
| BANK_INSTRUCTION_DETAILS |
| PAYMENT_REASON_CODE |
| PAYMENT_REASON_COMMENTS |
| INACTIVE_DATE |
| PAYMENT_TEXT_MESSAGE1 |
| PAYMENT_TEXT_MESSAGE2 |
| PAYMENT_TEXT_MESSAGE3 |
| DELIVERY_CHANNEL_CODE |
| PAYMENT_FORMAT_CODE |
| SETTLEMENT_PRIORITY |