[Home] [Help]
View: XTR_BANK_BALANCES_V
View Text
SELECT COMPANY_CODE
, FIRST_BATCH_ID
, LAST_BATCH_ID
, EXCHANGE_RATE
, ACCOUNT_NUMBER
, BALANCE_DATE
, NO_OF_DAYS
, STATEMENT_BALANCE
, BALANCE_ADJUSTMENT
, BALANCE_CFLOW
, ACCUM_INT_BFWD
, INTEREST
, INTEREST_RATE
, INTEREST_SETTLED
, INTEREST_SETTLED_HCE
, ACCUM_INT_CFWD
, UPDATED_BY
, UPDATED_ON
, SETOFF
, AUDIT_INDICATOR
, LIMIT_CODE
, CREATED_BY
, CREATED_ON
, ACCRUAL_INTEREST
, AVERAGE_EXCHANGE_RATE
, ROUNDING_TYPE
, DAY_COUNT_TYPE
, ORIGINAL_AMOUNT
, ONE_DAY_FLOAT
, TWO_DAY_FLOAT
FROM XTR_BANK_BALANCES
Columns
Name |
COMPANY_CODE |
FIRST_BATCH_ID |
LAST_BATCH_ID |
EXCHANGE_RATE |
ACCOUNT_NUMBER |
BALANCE_DATE |
NO_OF_DAYS |
STATEMENT_BALANCE |
BALANCE_ADJUSTMENT |
BALANCE_CFLOW |
ACCUM_INT_BFWD |
INTEREST |
INTEREST_RATE |
INTEREST_SETTLED |
INTEREST_SETTLED_HCE |
ACCUM_INT_CFWD |
UPDATED_BY |
UPDATED_ON |
SETOFF |
AUDIT_INDICATOR |
LIMIT_CODE |
CREATED_BY |
CREATED_ON |
ACCRUAL_INTEREST |
AVERAGE_EXCHANGE_RATE |
ROUNDING_TYPE |
DAY_COUNT_TYPE |
ORIGINAL_AMOUNT |
ONE_DAY_FLOAT |
TWO_DAY_FLOAT |