[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 |