VIEW: IBY.IBY_PAY_PAYMENTS_ALL#

Source

View Text - Preformatted

select ECAPP_ID ECAPP_ID, PAYER_ID PAYER_ID, BATCH_ID BATCH_ID, PMT_TRXN_ID PMT_TRXN_ID, PMT_PRIORITY PMT_PRIORITY, DEBIT_ACCT_NUMBER DEBIT_ACCT_NUMBER, FAX_MAIL_TO_NAME FAX_MAIL_TO_NAME, MAIL_ADDRESS1 MAIL_ADDRESS1, MAIL_ADDRESS2 MAIL_ADDRESS2, MAIL_ADDRESS3 MAIL_ADDRESS3, MAIL_ADDR_CITY MAIL_ADDR_CITY, MAIL_ADDR_STATE MAIL_ADDR_STATE, MAIL_ADDR_ZIP MAIL_ADDR_ZIP, PMT_LOC_COUNTRY_CODE PMT_LOC_COUNTRY_CODE, VALUE_AMOUNT VALUE_AMOUNT, REF_AMOUNT REF_AMOUNT, VALUE_DATE VALUE_DATE, CHARGE_DETAILS CHARGE_DETAILS, VAT_AMOUNT VAT_AMOUNT, WHT_AMOUNT WHT_AMOUNT, PMT_DETAILS_1 PMT_DETAILS_1, PMT_DETAILS_2 PMT_DETAILS_2, PMT_DETAILS_3 PMT_DETAILS_3, PMT_DETAILS_4 PMT_DETAILS_4, TRXN_CODE_CLRID TRXN_CODE_CLRID, BNF_NAME BNF_NAME, BNF_ID BNF_ID, BNF_ADDRESS_LINE1 BNF_ADDRESS_LINE1, BNF_ADDRESS_LINE2 BNF_ADDRESS_LINE2, BNF_ADDRESS_LINE3 BNF_ADDRESS_LINE3, BNF_ADDR_CITY BNF_ADDR_CITY, BNF_ADDR_STATE BNF_ADDR_STATE, BNF_ADDR_ZIP BNF_ADDR_ZIP, BNF_ADDR_COUNTRY BNF_ADDR_COUNTRY, BNF_ADDR_PHONE BNF_ADDR_PHONE, BNF_REMARKS BNF_REMARKS, BNF_CHARGE_AMT BNF_CHARGE_AMT, BNF_ADJUSTMENT_AMT BNF_ADJUSTMENT_AMT, BNF_BANK_NAME BNF_BANK_NAME, BNF_BANK_NUM BNF_BANK_NUM, BNF_BANK_ADDRESS BNF_BANK_ADDRESS, BNF_BANK_ADDR_CITY BNF_BANK_ADDR_CITY, BNF_BANK_ADDR_STATE BNF_BANK_ADDR_STATE, BNF_BANK_ADDR_ZIP BNF_BANK_ADDR_ZIP, BNF_BANK_ADDR_COUNTRY BNF_BANK_ADDR_COUNTRY, BNF_BANK_BRANCH_NAME BNF_BANK_BRANCH_NAME, BNF_BANK_BRANCH_NUM BNF_BANK_BRANCH_NUM, BNF_BANK_BRANCH_TYPE BNF_BANK_BRANCH_TYPE, BNF_BANK_SWIFT_CODE BNF_BANK_SWIFT_CODE, BNF_BANK_ACCOUNT_NAME BNF_BANK_ACCOUNT_NAME, BNF_BANK_ACCT_NUMBER BNF_BANK_ACCT_NUMBER, BNF_BANK_ACCT_CHECK_DIGITS BNF_BANK_ACCT_CHECK_DIGITS, BNF_BANK_ACCT_IBAN_NUMBER BNF_BANK_ACCT_IBAN_NUMBER, BNF_BANK_ACCT_TYPE BNF_BANK_ACCT_TYPE, BNF_FAXNO_CABLEADDR BNF_FAXNO_CABLEADDR, BNF_SITE_CODE BNF_SITE_CODE, BNF_BANK_CLEARING_MTD BNF_BANK_CLEARING_MTD, BNF_TAXPAYER_ID BNF_TAXPAYER_ID, FUTURE_PAY_DUE_DATE FUTURE_PAY_DUE_DATE, CUST_REF CUST_REF, INTRM_BANK_CODE INTRM_BANK_CODE, INTRM_SWIFT_CODE INTRM_SWIFT_CODE, INTRM_BANK_NAME INTRM_BANK_NAME, INTRM_BANK_FAXNO_CBL INTRM_BANK_FAXNO_CBL, PMT_STATUS PMT_STATUS, PMT_APPROVAL_STATUS PMT_APPROVAL_STATUS, UPDATE_DATE UPDATE_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ORG_ID ORG_ID, ERROR_LOCATION ERROR_LOCATION, BEP_CODE BEP_CODE, BEP_MESSAGE BEP_MESSAGE from "IBY"."IBY_PAY_PAYMENTS_ALL"

View Text - HTML Formatted

SELECT ECAPP_ID ECAPP_ID
, PAYER_ID PAYER_ID
, BATCH_ID BATCH_ID
, PMT_TRXN_ID PMT_TRXN_ID
, PMT_PRIORITY PMT_PRIORITY
, DEBIT_ACCT_NUMBER DEBIT_ACCT_NUMBER
, FAX_MAIL_TO_NAME FAX_MAIL_TO_NAME
, MAIL_ADDRESS1 MAIL_ADDRESS1
, MAIL_ADDRESS2 MAIL_ADDRESS2
, MAIL_ADDRESS3 MAIL_ADDRESS3
, MAIL_ADDR_CITY MAIL_ADDR_CITY
, MAIL_ADDR_STATE MAIL_ADDR_STATE
, MAIL_ADDR_ZIP MAIL_ADDR_ZIP
, PMT_LOC_COUNTRY_CODE PMT_LOC_COUNTRY_CODE
, VALUE_AMOUNT VALUE_AMOUNT
, REF_AMOUNT REF_AMOUNT
, VALUE_DATE VALUE_DATE
, CHARGE_DETAILS CHARGE_DETAILS
, VAT_AMOUNT VAT_AMOUNT
, WHT_AMOUNT WHT_AMOUNT
, PMT_DETAILS_1 PMT_DETAILS_1
, PMT_DETAILS_2 PMT_DETAILS_2
, PMT_DETAILS_3 PMT_DETAILS_3
, PMT_DETAILS_4 PMT_DETAILS_4
, TRXN_CODE_CLRID TRXN_CODE_CLRID
, BNF_NAME BNF_NAME
, BNF_ID BNF_ID
, BNF_ADDRESS_LINE1 BNF_ADDRESS_LINE1
, BNF_ADDRESS_LINE2 BNF_ADDRESS_LINE2
, BNF_ADDRESS_LINE3 BNF_ADDRESS_LINE3
, BNF_ADDR_CITY BNF_ADDR_CITY
, BNF_ADDR_STATE BNF_ADDR_STATE
, BNF_ADDR_ZIP BNF_ADDR_ZIP
, BNF_ADDR_COUNTRY BNF_ADDR_COUNTRY
, BNF_ADDR_PHONE BNF_ADDR_PHONE
, BNF_REMARKS BNF_REMARKS
, BNF_CHARGE_AMT BNF_CHARGE_AMT
, BNF_ADJUSTMENT_AMT BNF_ADJUSTMENT_AMT
, BNF_BANK_NAME BNF_BANK_NAME
, BNF_BANK_NUM BNF_BANK_NUM
, BNF_BANK_ADDRESS BNF_BANK_ADDRESS
, BNF_BANK_ADDR_CITY BNF_BANK_ADDR_CITY
, BNF_BANK_ADDR_STATE BNF_BANK_ADDR_STATE
, BNF_BANK_ADDR_ZIP BNF_BANK_ADDR_ZIP
, BNF_BANK_ADDR_COUNTRY BNF_BANK_ADDR_COUNTRY
, BNF_BANK_BRANCH_NAME BNF_BANK_BRANCH_NAME
, BNF_BANK_BRANCH_NUM BNF_BANK_BRANCH_NUM
, BNF_BANK_BRANCH_TYPE BNF_BANK_BRANCH_TYPE
, BNF_BANK_SWIFT_CODE BNF_BANK_SWIFT_CODE
, BNF_BANK_ACCOUNT_NAME BNF_BANK_ACCOUNT_NAME
, BNF_BANK_ACCT_NUMBER BNF_BANK_ACCT_NUMBER
, BNF_BANK_ACCT_CHECK_DIGITS BNF_BANK_ACCT_CHECK_DIGITS
, BNF_BANK_ACCT_IBAN_NUMBER BNF_BANK_ACCT_IBAN_NUMBER
, BNF_BANK_ACCT_TYPE BNF_BANK_ACCT_TYPE
, BNF_FAXNO_CABLEADDR BNF_FAXNO_CABLEADDR
, BNF_SITE_CODE BNF_SITE_CODE
, BNF_BANK_CLEARING_MTD BNF_BANK_CLEARING_MTD
, BNF_TAXPAYER_ID BNF_TAXPAYER_ID
, FUTURE_PAY_DUE_DATE FUTURE_PAY_DUE_DATE
, CUST_REF CUST_REF
, INTRM_BANK_CODE INTRM_BANK_CODE
, INTRM_SWIFT_CODE INTRM_SWIFT_CODE
, INTRM_BANK_NAME INTRM_BANK_NAME
, INTRM_BANK_FAXNO_CBL INTRM_BANK_FAXNO_CBL
, PMT_STATUS PMT_STATUS
, PMT_APPROVAL_STATUS PMT_APPROVAL_STATUS
, UPDATE_DATE UPDATE_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ORG_ID ORG_ID
, ERROR_LOCATION ERROR_LOCATION
, BEP_CODE BEP_CODE
, BEP_MESSAGE BEP_MESSAGE
FROM "IBY"."IBY_PAY_PAYMENTS_ALL"