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.

[Home] [Help]

VIEW: AP.JE_NL_EFT_BATCHES#

Source

View Text - Preformatted


select BATCH_ID BATCH_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CHECKRUN_NAME CHECKRUN_NAME, DATE_CREATED DATE_CREATED, BATCH_FORMAT BATCH_FORMAT, MEDIUM_ID MEDIUM_ID, MEDIUM_SEQNO MEDIUM_SEQNO, PAYER_BANK_ACCOUNT PAYER_BANK_ACCOUNT, TOT_BANK_ACCOUNTS TOT_BANK_ACCOUNTS, TOT_PAYMENT_AMOUNT TOT_PAYMENT_AMOUNT, TOT_PAYMENTS TOT_PAYMENTS, TOT_RECORDS TOT_RECORDS, NO_OF_CANCELLATIONS NO_OF_CANCELLATIONS, FIRST_PAYMENT_NUMBER FIRST_PAYMENT_NUMBER, LAST_PAYMENT_NUMBER LAST_PAYMENT_NUMBER, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "AP"."JE_NL_EFT_BATCHES"

View Text - HTML Formatted

SELECT BATCH_ID BATCH_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CHECKRUN_NAME CHECKRUN_NAME
, DATE_CREATED DATE_CREATED
, BATCH_FORMAT BATCH_FORMAT
, MEDIUM_ID MEDIUM_ID
, MEDIUM_SEQNO MEDIUM_SEQNO
, PAYER_BANK_ACCOUNT PAYER_BANK_ACCOUNT
, TOT_BANK_ACCOUNTS TOT_BANK_ACCOUNTS
, TOT_PAYMENT_AMOUNT TOT_PAYMENT_AMOUNT
, TOT_PAYMENTS TOT_PAYMENTS
, TOT_RECORDS TOT_RECORDS
, NO_OF_CANCELLATIONS NO_OF_CANCELLATIONS
, FIRST_PAYMENT_NUMBER FIRST_PAYMENT_NUMBER
, LAST_PAYMENT_NUMBER LAST_PAYMENT_NUMBER
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "AP"."JE_NL_EFT_BATCHES"