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