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_STMT_TXNS_V

Product:	XTR - Treasury
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT STMT_TXN_NO
, ACCOUNT_NO
, TXN_STATUS
, FX_CODE
, TXN_TYPE
, TXN_REF_NO
, ACCOUNT_TYPE
, ACCOUNT_SUB_TYPE
, ALLOC_LIMIT_FLAG
, ALLOC_LIMIT_VAL
, ALLOC_VAL
, BRANCH
, DEPT
, TRUST_VAL
, TXN_DATE
, VAL
, ENTRY_DATE_TIME
, USER_ID
, BASE_VAL
, DETAILS
, BASE_FX_RATE
, SCRIP_TXN_NO
, SETT_DATE
, DIARY_REF_NO
, BOOKING_REF_NO
, PORTF_HOLD_TXN_NO
FROM XTR_STMT_TXNS

Columns

Name
STMT_TXN_NO
ACCOUNT_NO
TXN_STATUS
FX_CODE
TXN_TYPE
TXN_REF_NO
ACCOUNT_TYPE
ACCOUNT_SUB_TYPE
ALLOC_LIMIT_FLAG
ALLOC_LIMIT_VAL
ALLOC_VAL
BRANCH
DEPT
TRUST_VAL
TXN_DATE
VAL
ENTRY_DATE_TIME
USER_ID
BASE_VAL
DETAILS
BASE_FX_RATE
SCRIP_TXN_NO
SETT_DATE
DIARY_REF_NO
BOOKING_REF_NO
PORTF_HOLD_TXN_NO