[Home] [Help]
View: XTR_R_EXPOSURE_TRANSACTIONS_V
View Text
SELECT TRANSACTION_NUMBER
, COMPANY_CODE
, DEAL_TYPE
, DEAL_SUBTYPE
, EXPOSURE_TYPE
, CURRENCY
, VALUE_DATE
, AMOUNT
, SETTLE_ACTION_REQD
, AMOUNT_HCE
, CREATED_BY
, CREATED_ON
, UPDATED_BY
, UPDATED_ON
, THIRDPARTY_CODE
, ACTION_CODE
, AMOUNT_TYPE
, ACCOUNT_NO
, COMMENTS
, CPARTY_REF
, PORTFOLIO_CODE
, TAX_BROKERAGE_TYPE
, ARCHIVE_DATE
, ARCHIVE_BY
, PURCHASING_MODULE
, BENEFICIARY_CODE
, NZD_AMOUNT
, FIS_FOB
, SUBSIDIARY_REF
, INTERMEDIARY_BANK_DETAILS
, DEAL_STATUS
, WHOLESALE_REFERENCE
, SELECT_REFERENCE
, PROFIT_LOSS
, SELECT_ACTION
, PAYMENT_AMOUNT
, BALANCE
, AVG_RATE
, CONTRA_NZD_AMOUNT
, CPARTY_CODE
, PAYMENT_STATUS
, AUDIT_INDICATOR
, ESTIMATE_DATE
, ESTIMATE_AMOUNT
, COVERED_BY_FX_CONTRACT
, STATUS_CODE
FROM XTR_R_EXPOSURE_TRANSACTIONS
Columns
Name |
TRANSACTION_NUMBER |
COMPANY_CODE |
DEAL_TYPE |
DEAL_SUBTYPE |
EXPOSURE_TYPE |
CURRENCY |
VALUE_DATE |
AMOUNT |
SETTLE_ACTION_REQD |
AMOUNT_HCE |
CREATED_BY |
CREATED_ON |
UPDATED_BY |
UPDATED_ON |
THIRDPARTY_CODE |
ACTION_CODE |
AMOUNT_TYPE |
ACCOUNT_NO |
COMMENTS |
CPARTY_REF |
PORTFOLIO_CODE |
TAX_BROKERAGE_TYPE |
ARCHIVE_DATE |
ARCHIVE_BY |
PURCHASING_MODULE |
BENEFICIARY_CODE |
NZD_AMOUNT |
FIS_FOB |
SUBSIDIARY_REF |
INTERMEDIARY_BANK_DETAILS |
DEAL_STATUS |
WHOLESALE_REFERENCE |
SELECT_REFERENCE |
PROFIT_LOSS |
SELECT_ACTION |
PAYMENT_AMOUNT |
BALANCE |
AVG_RATE |
CONTRA_NZD_AMOUNT |
CPARTY_CODE |
PAYMENT_STATUS |
AUDIT_INDICATOR |
ESTIMATE_DATE |
ESTIMATE_AMOUNT |
COVERED_BY_FX_CONTRACT |
STATUS_CODE |