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: XTR.XTR_A_BANK_BALANCES#

Source

View Text - Preformatted


select ACCOUNT_NUMBER ACCOUNT_NUMBER, ACCUM_INT_BFWD ACCUM_INT_BFWD, ACCUM_INT_CFWD ACCUM_INT_CFWD, AUDIT_DATE_STORED AUDIT_DATE_STORED, AUDIT_INDICATOR AUDIT_INDICATOR, BALANCE_ADJUSTMENT BALANCE_ADJUSTMENT, BALANCE_CFLOW BALANCE_CFLOW, BALANCE_DATE BALANCE_DATE, COMPANY_CODE COMPANY_CODE, INTEREST INTEREST, INTEREST_RATE INTEREST_RATE, INTEREST_SETTLED INTEREST_SETTLED, INTEREST_SETTLED_HCE INTEREST_SETTLED_HCE, NO_OF_DAYS NO_OF_DAYS, SETOFF SETOFF, STATEMENT_BALANCE STATEMENT_BALANCE, UPDATED_BY UPDATED_BY, UPDATED_ON UPDATED_ON, LIMIT_CODE LIMIT_CODE, CREATED_BY CREATED_BY, CREATED_ON CREATED_ON, ACCRUAL_INTEREST ACCRUAL_INTEREST from "XTR"."XTR_A_BANK_BALANCES"

View Text - HTML Formatted

SELECT ACCOUNT_NUMBER ACCOUNT_NUMBER
, ACCUM_INT_BFWD ACCUM_INT_BFWD
, ACCUM_INT_CFWD ACCUM_INT_CFWD
, AUDIT_DATE_STORED AUDIT_DATE_STORED
, AUDIT_INDICATOR AUDIT_INDICATOR
, BALANCE_ADJUSTMENT BALANCE_ADJUSTMENT
, BALANCE_CFLOW BALANCE_CFLOW
, BALANCE_DATE BALANCE_DATE
, COMPANY_CODE COMPANY_CODE
, INTEREST INTEREST
, INTEREST_RATE INTEREST_RATE
, INTEREST_SETTLED INTEREST_SETTLED
, INTEREST_SETTLED_HCE INTEREST_SETTLED_HCE
, NO_OF_DAYS NO_OF_DAYS
, SETOFF SETOFF
, STATEMENT_BALANCE STATEMENT_BALANCE
, UPDATED_BY UPDATED_BY
, UPDATED_ON UPDATED_ON
, LIMIT_CODE LIMIT_CODE
, CREATED_BY CREATED_BY
, CREATED_ON CREATED_ON
, ACCRUAL_INTEREST ACCRUAL_INTEREST
FROM "XTR"."XTR_A_BANK_BALANCES"