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_PAY_BATCHES#

Source

View Text - Preformatted


select PMT_BATCH_REQUEST_ID PMT_BATCH_REQUEST_ID, BATCH_ID BATCH_ID, ECAPP_ID ECAPP_ID, BEP_ID BEP_ID, PMT_SYSTEM_IDENTIFIER PMT_SYSTEM_IDENTIFIER, CUST_ID CUST_ID, CUST_NAME CUST_NAME, CUST_ADDR1 CUST_ADDR1, CUST_ADDR2 CUST_ADDR2, CUST_ADDR3 CUST_ADDR3, ORIG_BANK_NAME ORIG_BANK_NAME, ORIG_BANK_BRANCH_NAME ORIG_BANK_BRANCH_NAME, ORIG_BANK_ACCOUNT_NAME ORIG_BANK_ACCOUNT_NAME, ORIG_BANK_ACCT_NUMBER ORIG_BANK_ACCT_NUMBER, ORIG_BANK_ACCT_TYPE ORIG_BANK_ACCT_TYPE, ORIG_COUNTRY_CODE ORIG_COUNTRY_CODE, PMT_METHOD PMT_METHOD, CURRENCY_CODE CURRENCY_CODE, REF_CURRENCY_CODE REF_CURRENCY_CODE, DOC_ORDER_LOOKUP_CODE DOC_ORDER_LOOKUP_CODE, NUM_OF_TRXNS NUM_OF_TRXNS, BATCH_TOTAL BATCH_TOTAL, BATCH_STATUS BATCH_STATUS, REQUEST_DATE REQUEST_DATE, PMT_BATCH_NAME PMT_BATCH_NAME, PMT_BATCH_SET_ID PMT_BATCH_SET_ID, 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_BATCHES"

View Text - HTML Formatted

SELECT PMT_BATCH_REQUEST_ID PMT_BATCH_REQUEST_ID
, BATCH_ID BATCH_ID
, ECAPP_ID ECAPP_ID
, BEP_ID BEP_ID
, PMT_SYSTEM_IDENTIFIER PMT_SYSTEM_IDENTIFIER
, CUST_ID CUST_ID
, CUST_NAME CUST_NAME
, CUST_ADDR1 CUST_ADDR1
, CUST_ADDR2 CUST_ADDR2
, CUST_ADDR3 CUST_ADDR3
, ORIG_BANK_NAME ORIG_BANK_NAME
, ORIG_BANK_BRANCH_NAME ORIG_BANK_BRANCH_NAME
, ORIG_BANK_ACCOUNT_NAME ORIG_BANK_ACCOUNT_NAME
, ORIG_BANK_ACCT_NUMBER ORIG_BANK_ACCT_NUMBER
, ORIG_BANK_ACCT_TYPE ORIG_BANK_ACCT_TYPE
, ORIG_COUNTRY_CODE ORIG_COUNTRY_CODE
, PMT_METHOD PMT_METHOD
, CURRENCY_CODE CURRENCY_CODE
, REF_CURRENCY_CODE REF_CURRENCY_CODE
, DOC_ORDER_LOOKUP_CODE DOC_ORDER_LOOKUP_CODE
, NUM_OF_TRXNS NUM_OF_TRXNS
, BATCH_TOTAL BATCH_TOTAL
, BATCH_STATUS BATCH_STATUS
, REQUEST_DATE REQUEST_DATE
, PMT_BATCH_NAME PMT_BATCH_NAME
, PMT_BATCH_SET_ID PMT_BATCH_SET_ID
, 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_BATCHES"