VIEW: IBY.IBY_PAY_PAYMENTS#

Source

View Text - Preformatted

select PMT_BATCH_REQUEST_ID PMT_BATCH_REQUEST_ID, BATCH_ID BATCH_ID, PMT_TRXN_ID PMT_TRXN_ID, PMT_LOC_COUNTRY_CODE PMT_LOC_COUNTRY_CODE, PMT_PRIORITY PMT_PRIORITY, DEBIT_ACCTNO DEBIT_ACCTNO, 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, 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_ADDR_CITY BNF_ADDR_CITY, BNF_ADDR_STATE BNF_ADDR_STATE, BNF_ADDR_ZIP BNF_ADDR_ZIP, 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_ADDRESS BNF_BANK_ADDRESS, BNF_BANK_ADDR_STATE BNF_BANK_ADDR_STATE, BNF_BANK_ADDR_CITY BNF_BANK_ADDR_CITY, BNF_BANK_ADDR_ZIP BNF_BANK_ADDR_ZIP, BNF_BANK_BRANCH_NO BNF_BANK_BRANCH_NO, BNF_BANK_BRANCH_NAME BNF_BANK_BRANCH_NAME, BNF_BANK_BRANCH_TYPE BNF_BANK_BRANCH_TYPE, BNF_ACCTNO BNF_ACCTNO, BNF_BANK_ACCOUNT_NAME BNF_BANK_ACCOUNT_NAME, BNF_BANK_ACCT_TYPE BNF_BANK_ACCT_TYPE, BNF_ACCT_TYPE BNF_ACCT_TYPE, BNF_FAXNO_CABLEADDR BNF_FAXNO_CABLEADDR, BNF_SITE_CODE BNF_SITE_CODE, BNF_SWIFT_CODE BNF_SWIFT_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_BANKCODE INTRM_BANKCODE, INTRM_SWIFTCODE INTRM_SWIFTCODE, INTRM_BANKNAME INTRM_BANKNAME, 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, ERROR_LOCATION ERROR_LOCATION, BEP_CODE BEP_CODE, BEP_MESSAGE BEP_MESSAGE from "IBY"."IBY_PAY_PAYMENTS"

View Text - HTML Formatted

SELECT PMT_BATCH_REQUEST_ID PMT_BATCH_REQUEST_ID
, BATCH_ID BATCH_ID
, PMT_TRXN_ID PMT_TRXN_ID
, PMT_LOC_COUNTRY_CODE PMT_LOC_COUNTRY_CODE
, PMT_PRIORITY PMT_PRIORITY
, DEBIT_ACCTNO DEBIT_ACCTNO
, 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
, 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_ADDR_CITY BNF_ADDR_CITY
, BNF_ADDR_STATE BNF_ADDR_STATE
, BNF_ADDR_ZIP BNF_ADDR_ZIP
, 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_ADDRESS BNF_BANK_ADDRESS
, BNF_BANK_ADDR_STATE BNF_BANK_ADDR_STATE
, BNF_BANK_ADDR_CITY BNF_BANK_ADDR_CITY
, BNF_BANK_ADDR_ZIP BNF_BANK_ADDR_ZIP
, BNF_BANK_BRANCH_NO BNF_BANK_BRANCH_NO
, BNF_BANK_BRANCH_NAME BNF_BANK_BRANCH_NAME
, BNF_BANK_BRANCH_TYPE BNF_BANK_BRANCH_TYPE
, BNF_ACCTNO BNF_ACCTNO
, BNF_BANK_ACCOUNT_NAME BNF_BANK_ACCOUNT_NAME
, BNF_BANK_ACCT_TYPE BNF_BANK_ACCT_TYPE
, BNF_ACCT_TYPE BNF_ACCT_TYPE
, BNF_FAXNO_CABLEADDR BNF_FAXNO_CABLEADDR
, BNF_SITE_CODE BNF_SITE_CODE
, BNF_SWIFT_CODE BNF_SWIFT_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_BANKCODE INTRM_BANKCODE
, INTRM_SWIFTCODE INTRM_SWIFTCODE
, INTRM_BANKNAME INTRM_BANKNAME
, 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
, ERROR_LOCATION ERROR_LOCATION
, BEP_CODE BEP_CODE
, BEP_MESSAGE BEP_MESSAGE
FROM "IBY"."IBY_PAY_PAYMENTS"