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

Source

View Text - Preformatted


select ACCOUNT_NUMBER ACCOUNT_NUMBER, ACCUM_INT_BFWD ACCUM_INT_BFWD, ACCUM_INT_CFWD ACCUM_INT_CFWD, 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, FIRST_BATCH_ID FIRST_BATCH_ID, LAST_BATCH_ID LAST_BATCH_ID, EXCHANGE_RATE EXCHANGE_RATE, AVERAGE_EXCHANGE_RATE AVERAGE_EXCHANGE_RATE, ROUNDING_TYPE ROUNDING_TYPE, DAY_COUNT_TYPE DAY_COUNT_TYPE, ORIGINAL_AMOUNT ORIGINAL_AMOUNT, ONE_DAY_FLOAT ONE_DAY_FLOAT, TWO_DAY_FLOAT TWO_DAY_FLOAT, BANK_ACCT_USE_ID BANK_ACCT_USE_ID, CE_BANK_ACCOUNT_BALANCE_ID CE_BANK_ACCOUNT_BALANCE_ID from "XTR"."XTR_BANK_BALANCES"

View Text - HTML Formatted

SELECT ACCOUNT_NUMBER ACCOUNT_NUMBER
, ACCUM_INT_BFWD ACCUM_INT_BFWD
, ACCUM_INT_CFWD ACCUM_INT_CFWD
, 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
, FIRST_BATCH_ID FIRST_BATCH_ID
, LAST_BATCH_ID LAST_BATCH_ID
, EXCHANGE_RATE EXCHANGE_RATE
, AVERAGE_EXCHANGE_RATE AVERAGE_EXCHANGE_RATE
, ROUNDING_TYPE ROUNDING_TYPE
, DAY_COUNT_TYPE DAY_COUNT_TYPE
, ORIGINAL_AMOUNT ORIGINAL_AMOUNT
, ONE_DAY_FLOAT ONE_DAY_FLOAT
, TWO_DAY_FLOAT TWO_DAY_FLOAT
, BANK_ACCT_USE_ID BANK_ACCT_USE_ID
, CE_BANK_ACCOUNT_BALANCE_ID CE_BANK_ACCOUNT_BALANCE_ID
FROM "XTR"."XTR_BANK_BALANCES"