FND Design Data [Home] [Help]

View: XTR_EXPOSURE_TRANSACTIONS_V

Product: XTR - Treasury
Description:
Implementation/DBA Data: ViewAPPS.XTR_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
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, EXTERNAL_COMMENTS
, INTERNAL_COMMENTS
, DEAL_LINK_CODE
, CPARTY_ACCOUNT_NO
, DUAL_AUTHORISATION_BY
, DUAL_AUTHORISATION_ON
, CASH_POSITION_EXPOSURE
FROM XTR_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
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
EXTERNAL_COMMENTS
INTERNAL_COMMENTS
DEAL_LINK_CODE
CPARTY_ACCOUNT_NO
DUAL_AUTHORISATION_BY
DUAL_AUTHORISATION_ON
CASH_POSITION_EXPOSURE