VIEW: XTR.XTR_A_EXPOSURE_TRANSACTIONS#

Source

View Text - Preformatted

select ACCOUNT_NO ACCOUNT_NO, ACTION_CODE ACTION_CODE, AMOUNT AMOUNT, AMOUNT_HCE AMOUNT_HCE, AMOUNT_TYPE AMOUNT_TYPE, ARCHIVE_BY ARCHIVE_BY, ARCHIVE_DATE ARCHIVE_DATE, AUDIT_DATE_STORED AUDIT_DATE_STORED, AUDIT_INDICATOR AUDIT_INDICATOR, AVG_RATE AVG_RATE, BALANCE BALANCE, BENEFICIARY_CODE BENEFICIARY_CODE, COMMENTS COMMENTS, COMPANY_CODE COMPANY_CODE, CONTRA_NZD_AMOUNT CONTRA_NZD_AMOUNT, COVERED_BY_FX_CONTRACT COVERED_BY_FX_CONTRACT, CPARTY_CODE CPARTY_CODE, CPARTY_REF CPARTY_REF, CREATED_BY CREATED_BY, CREATED_ON CREATED_ON, CURRENCY CURRENCY, DEAL_STATUS DEAL_STATUS, DEAL_SUBTYPE DEAL_SUBTYPE, DEAL_TYPE DEAL_TYPE, ESTIMATE_AMOUNT ESTIMATE_AMOUNT, ESTIMATE_DATE ESTIMATE_DATE, EXPOSURE_TYPE EXPOSURE_TYPE, FIS_FOB FIS_FOB, INTERMEDIARY_BANK_DETAILS INTERMEDIARY_BANK_DETAILS, NZD_AMOUNT NZD_AMOUNT, PAYMENT_AMOUNT PAYMENT_AMOUNT, PAYMENT_STATUS PAYMENT_STATUS, PORTFOLIO_CODE PORTFOLIO_CODE, PROFIT_LOSS PROFIT_LOSS, PURCHASING_MODULE PURCHASING_MODULE, SELECT_ACTION SELECT_ACTION, SELECT_REFERENCE SELECT_REFERENCE, SETTLE_ACTION_REQD SETTLE_ACTION_REQD, STATUS_CODE STATUS_CODE, SUBSIDIARY_REF SUBSIDIARY_REF, TAX_BROKERAGE_TYPE TAX_BROKERAGE_TYPE, THIRDPARTY_CODE THIRDPARTY_CODE, TRANSACTION_NUMBER TRANSACTION_NUMBER, UPDATED_BY UPDATED_BY, UPDATED_ON UPDATED_ON, VALUE_DATE VALUE_DATE, WHOLESALE_REFERENCE WHOLESALE_REFERENCE from "XTR"."XTR_A_EXPOSURE_TRANSACTIONS"

View Text - HTML Formatted

SELECT ACCOUNT_NO ACCOUNT_NO
, ACTION_CODE ACTION_CODE
, AMOUNT AMOUNT
, AMOUNT_HCE AMOUNT_HCE
, AMOUNT_TYPE AMOUNT_TYPE
, ARCHIVE_BY ARCHIVE_BY
, ARCHIVE_DATE ARCHIVE_DATE
, AUDIT_DATE_STORED AUDIT_DATE_STORED
, AUDIT_INDICATOR AUDIT_INDICATOR
, AVG_RATE AVG_RATE
, BALANCE BALANCE
, BENEFICIARY_CODE BENEFICIARY_CODE
, COMMENTS COMMENTS
, COMPANY_CODE COMPANY_CODE
, CONTRA_NZD_AMOUNT CONTRA_NZD_AMOUNT
, COVERED_BY_FX_CONTRACT COVERED_BY_FX_CONTRACT
, CPARTY_CODE CPARTY_CODE
, CPARTY_REF CPARTY_REF
, CREATED_BY CREATED_BY
, CREATED_ON CREATED_ON
, CURRENCY CURRENCY
, DEAL_STATUS DEAL_STATUS
, DEAL_SUBTYPE DEAL_SUBTYPE
, DEAL_TYPE DEAL_TYPE
, ESTIMATE_AMOUNT ESTIMATE_AMOUNT
, ESTIMATE_DATE ESTIMATE_DATE
, EXPOSURE_TYPE EXPOSURE_TYPE
, FIS_FOB FIS_FOB
, INTERMEDIARY_BANK_DETAILS INTERMEDIARY_BANK_DETAILS
, NZD_AMOUNT NZD_AMOUNT
, PAYMENT_AMOUNT PAYMENT_AMOUNT
, PAYMENT_STATUS PAYMENT_STATUS
, PORTFOLIO_CODE PORTFOLIO_CODE
, PROFIT_LOSS PROFIT_LOSS
, PURCHASING_MODULE PURCHASING_MODULE
, SELECT_ACTION SELECT_ACTION
, SELECT_REFERENCE SELECT_REFERENCE
, SETTLE_ACTION_REQD SETTLE_ACTION_REQD
, STATUS_CODE STATUS_CODE
, SUBSIDIARY_REF SUBSIDIARY_REF
, TAX_BROKERAGE_TYPE TAX_BROKERAGE_TYPE
, THIRDPARTY_CODE THIRDPARTY_CODE
, TRANSACTION_NUMBER TRANSACTION_NUMBER
, UPDATED_BY UPDATED_BY
, UPDATED_ON UPDATED_ON
, VALUE_DATE VALUE_DATE
, WHOLESALE_REFERENCE WHOLESALE_REFERENCE
FROM "XTR"."XTR_A_EXPOSURE_TRANSACTIONS"