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: JA.JAI_AP_RGM_PAYMENTS#

Source

View Text - Preformatted


select PAYMENT_ID PAYMENT_ID, SETTLEMENT_ID SETTLEMENT_ID, CHECK_ID CHECK_ID, CHECK_DATE CHECK_DATE, CHECK_NUMBER CHECK_NUMBER, ORG_TAN_NO ORG_TAN_NO, BANK_BRANCH_ID BANK_BRANCH_ID, TCS_AMOUNT TCS_AMOUNT, SURCHARGE_AMOUNT SURCHARGE_AMOUNT, CESS_AMOUNT CESS_AMOUNT, CHECK_DEPOSIT_DATE CHECK_DEPOSIT_DATE, CHALLAN_NO CHALLAN_NO, TAX_AUTHORITY_ID TAX_AUTHORITY_ID, TAX_AUTHORITY_SITE_ID TAX_AUTHORITY_SITE_ID, VOUCHER_NUMBER VOUCHER_NUMBER, BOOK_ENTRY_DEPOSITED BOOK_ENTRY_DEPOSITED, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, BSR_CODE BSR_CODE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, SH_CESS_AMOUNT SH_CESS_AMOUNT from "JA"."JAI_AP_RGM_PAYMENTS"

View Text - HTML Formatted

SELECT PAYMENT_ID PAYMENT_ID
, SETTLEMENT_ID SETTLEMENT_ID
, CHECK_ID CHECK_ID
, CHECK_DATE CHECK_DATE
, CHECK_NUMBER CHECK_NUMBER
, ORG_TAN_NO ORG_TAN_NO
, BANK_BRANCH_ID BANK_BRANCH_ID
, TCS_AMOUNT TCS_AMOUNT
, SURCHARGE_AMOUNT SURCHARGE_AMOUNT
, CESS_AMOUNT CESS_AMOUNT
, CHECK_DEPOSIT_DATE CHECK_DEPOSIT_DATE
, CHALLAN_NO CHALLAN_NO
, TAX_AUTHORITY_ID TAX_AUTHORITY_ID
, TAX_AUTHORITY_SITE_ID TAX_AUTHORITY_SITE_ID
, VOUCHER_NUMBER VOUCHER_NUMBER
, BOOK_ENTRY_DEPOSITED BOOK_ENTRY_DEPOSITED
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, BSR_CODE BSR_CODE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SH_CESS_AMOUNT SH_CESS_AMOUNT
FROM "JA"."JAI_AP_RGM_PAYMENTS"