VIEW: XTR.XTR_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_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, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, EXTERNAL_COMMENTS EXTERNAL_COMMENTS, INTERNAL_COMMENTS INTERNAL_COMMENTS, DEAL_LINK_CODE DEAL_LINK_CODE, EXTERNAL_DEAL_ID EXTERNAL_DEAL_ID, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, CPARTY_ACCOUNT_NO CPARTY_ACCOUNT_NO, COMPANY_ACCT_USE_ID COMPANY_ACCT_USE_ID, CPARTY_ACCT_USE_ID CPARTY_ACCT_USE_ID, DUAL_AUTHORISATION_BY DUAL_AUTHORISATION_BY, DUAL_AUTHORISATION_ON DUAL_AUTHORISATION_ON, CASH_POSITION_EXPOSURE CASH_POSITION_EXPOSURE from "XTR"."XTR_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_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
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, EXTERNAL_COMMENTS EXTERNAL_COMMENTS
, INTERNAL_COMMENTS INTERNAL_COMMENTS
, DEAL_LINK_CODE DEAL_LINK_CODE
, EXTERNAL_DEAL_ID EXTERNAL_DEAL_ID
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CPARTY_ACCOUNT_NO CPARTY_ACCOUNT_NO
, COMPANY_ACCT_USE_ID COMPANY_ACCT_USE_ID
, CPARTY_ACCT_USE_ID CPARTY_ACCT_USE_ID
, DUAL_AUTHORISATION_BY DUAL_AUTHORISATION_BY
, DUAL_AUTHORISATION_ON DUAL_AUTHORISATION_ON
, CASH_POSITION_EXPOSURE CASH_POSITION_EXPOSURE
FROM "XTR"."XTR_EXPOSURE_TRANSACTIONS"