[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 |