eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: IBY.IBY_ACK_PMT_ALL#

Source

View Text - Preformatted


select ACK_PMT_ID ACK_PMT_ID, PAYMENT_REF_NUMBER PAYMENT_REF_NUMBER, PAYMENT_INSTRUCTION_REF_NUMBER PAYMENT_INSTRUCTION_REF_NUMBER, BANK_STATUS_CODE BANK_STATUS_CODE, PAYMENT_ACK_STATUS PAYMENT_ACK_STATUS, ACKNOWLEDGEMENT_DATE ACKNOWLEDGEMENT_DATE, BANK_ASSIGNED_REF_CODE1 BANK_ASSIGNED_REF_CODE1, BANK_ASSIGNED_REF_CODE2 BANK_ASSIGNED_REF_CODE2, PAYER_NAME PAYER_NAME, PAYER_BANK_NAME PAYER_BANK_NAME, PAYER_BANK_BRANCH_NAME PAYER_BANK_BRANCH_NAME, PAYER_BANK_SWIFT_CODE PAYER_BANK_SWIFT_CODE, PAYER_BANK_ACCOUNT_NUMBER PAYER_BANK_ACCOUNT_NUMBER, PAYER_BANK_IBAN_NUMBER PAYER_BANK_IBAN_NUMBER, PAYEE_NAME PAYEE_NAME, PAYEE_BANK_NAME PAYEE_BANK_NAME, PAYEE_BANK_BRANCH_NAME PAYEE_BANK_BRANCH_NAME, PAYEE_BANK_SWIFT_CODE PAYEE_BANK_SWIFT_CODE, PAYEE_BANK_ACCOUNT_NUMBER PAYEE_BANK_ACCOUNT_NUMBER, PAYEE_BANK_IBAN_NUMBER PAYEE_BANK_IBAN_NUMBER, PAYMENT_AMOUNT PAYMENT_AMOUNT, BANK_CHARGE_AMOUNT BANK_CHARGE_AMOUNT, PAYMENT_CURRENCY_CODE PAYMENT_CURRENCY_CODE, EXCHANGE_RATE EXCHANGE_RATE, CALCULATED_PAYMENT_AMOUNT CALCULATED_PAYMENT_AMOUNT, CALCULATED_BANK_CHARGE_AMOUNT CALCULATED_BANK_CHARGE_AMOUNT, VALUE_DATE VALUE_DATE, REQUESTED_EXECUTION_DATE REQUESTED_EXECUTION_DATE, 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 from "IBY"."IBY_ACK_PMT_ALL"

View Text - HTML Formatted

SELECT ACK_PMT_ID ACK_PMT_ID
, PAYMENT_REF_NUMBER PAYMENT_REF_NUMBER
, PAYMENT_INSTRUCTION_REF_NUMBER PAYMENT_INSTRUCTION_REF_NUMBER
, BANK_STATUS_CODE BANK_STATUS_CODE
, PAYMENT_ACK_STATUS PAYMENT_ACK_STATUS
, ACKNOWLEDGEMENT_DATE ACKNOWLEDGEMENT_DATE
, BANK_ASSIGNED_REF_CODE1 BANK_ASSIGNED_REF_CODE1
, BANK_ASSIGNED_REF_CODE2 BANK_ASSIGNED_REF_CODE2
, PAYER_NAME PAYER_NAME
, PAYER_BANK_NAME PAYER_BANK_NAME
, PAYER_BANK_BRANCH_NAME PAYER_BANK_BRANCH_NAME
, PAYER_BANK_SWIFT_CODE PAYER_BANK_SWIFT_CODE
, PAYER_BANK_ACCOUNT_NUMBER PAYER_BANK_ACCOUNT_NUMBER
, PAYER_BANK_IBAN_NUMBER PAYER_BANK_IBAN_NUMBER
, PAYEE_NAME PAYEE_NAME
, PAYEE_BANK_NAME PAYEE_BANK_NAME
, PAYEE_BANK_BRANCH_NAME PAYEE_BANK_BRANCH_NAME
, PAYEE_BANK_SWIFT_CODE PAYEE_BANK_SWIFT_CODE
, PAYEE_BANK_ACCOUNT_NUMBER PAYEE_BANK_ACCOUNT_NUMBER
, PAYEE_BANK_IBAN_NUMBER PAYEE_BANK_IBAN_NUMBER
, PAYMENT_AMOUNT PAYMENT_AMOUNT
, BANK_CHARGE_AMOUNT BANK_CHARGE_AMOUNT
, PAYMENT_CURRENCY_CODE PAYMENT_CURRENCY_CODE
, EXCHANGE_RATE EXCHANGE_RATE
, CALCULATED_PAYMENT_AMOUNT CALCULATED_PAYMENT_AMOUNT
, CALCULATED_BANK_CHARGE_AMOUNT CALCULATED_BANK_CHARGE_AMOUNT
, VALUE_DATE VALUE_DATE
, REQUESTED_EXECUTION_DATE REQUESTED_EXECUTION_DATE
, 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
FROM "IBY"."IBY_ACK_PMT_ALL"