VIEW: XTR.XTR_DEAL_DATE_AMOUNTS#

Source

View Text - Preformatted

select ACCOUNT_NO ACCOUNT_NO, ACCRUAL_FROM ACCRUAL_FROM, ACCRUAL_TO ACCRUAL_TO, ACTION_CODE ACTION_CODE, ACTION_COMPLETED ACTION_COMPLETED, ACTUAL_SETTLEMENT_DATE ACTUAL_SETTLEMENT_DATE, AMOUNT AMOUNT, AMOUNT_DATE AMOUNT_DATE, AMOUNT_TYPE AMOUNT_TYPE, ARCHIVE_BY ARCHIVE_BY, ARCHIVE_DATE ARCHIVE_DATE, ATTACHMENT_EXISTS ATTACHMENT_EXISTS, AUDIT_INDICATOR AUDIT_INDICATOR, AUTHORISED AUTHORISED, BALANCE_SHEET_EXPOSURE BALANCE_SHEET_EXPOSURE, BENEFICIARY_ACCOUNT_NO BENEFICIARY_ACCOUNT_NO, BENEFICIARY_PARTY BENEFICIARY_PARTY, CASHFLOW_AMOUNT CASHFLOW_AMOUNT, CHQ_REQD CHQ_REQD, CLIENT_BROKER_CLRACCT CLIENT_BROKER_CLRACCT, CLIENT_CODE CLIENT_CODE, COMMENCE_DATE COMMENCE_DATE, COMMENTS COMMENTS, COMPANY_CODE COMPANY_CODE, CONTRACT_CODE CONTRACT_CODE, CPARTY_ACCOUNT_NO CPARTY_ACCOUNT_NO, CPARTY_CODE CPARTY_CODE, CURRENCY CURRENCY, CURRENCY_COMBINATION CURRENCY_COMBINATION, DATE_TYPE DATE_TYPE, DEALER_CODE DEALER_CODE, DEAL_NUMBER DEAL_NUMBER, DEAL_ORDERS DEAL_ORDERS, DEAL_SUBTYPE DEAL_SUBTYPE, DEAL_TYPE DEAL_TYPE, DIARY_CREATED_BY DIARY_CREATED_BY, DIARY_NOTE DIARY_NOTE, DIRECT_DEBIT DIRECT_DEBIT, DUAL_AUTHORISATION_BY DUAL_AUTHORISATION_BY, DUAL_AUTHORISATION_ON DUAL_AUTHORISATION_ON, EXPOSURE_REF_DATE EXPOSURE_REF_DATE, EXP_SETTLE_REQD EXP_SETTLE_REQD, EXTERNAL_COMMENTS EXTERNAL_COMMENTS, FIRST_ACCRUAL FIRST_ACCRUAL, FRA_DESCRIPTION FRA_DESCRIPTION, GENERAL_OR_PRIVATE_ACCESS GENERAL_OR_PRIVATE_ACCESS, CODE_COMBINATION_ID CODE_COMBINATION_ID, GOOD_VALUE_CLAIM GOOD_VALUE_CLAIM, HCE_AMOUNT HCE_AMOUNT, JOURNAL_CREATED JOURNAL_CREATED, LIMIT_CODE LIMIT_CODE, LIMIT_PARTY LIMIT_PARTY, MULTIPLE_REFERENCE_NUMBER MULTIPLE_REFERENCE_NUMBER, MULTIPLE_SETTLEMENTS MULTIPLE_SETTLEMENTS, NETOFF_GROUP_FLAG NETOFF_GROUP_FLAG, NETOFF_NUMBER NETOFF_NUMBER, PORTFOLIO_CODE PORTFOLIO_CODE, PRINTED_MATURITY_YN PRINTED_MATURITY_YN, PRODUCT_TYPE PRODUCT_TYPE, QUICK_INPUT QUICK_INPUT, RECONCILED_DAYS_ADJUST RECONCILED_DAYS_ADJUST, RECONCILED_PASS_CODE RECONCILED_PASS_CODE, RECONCILED_REFERENCE RECONCILED_REFERENCE, SERIAL_REFERENCE SERIAL_REFERENCE, SETTLE SETTLE, SETTLEMENT_ACTIONED SETTLEMENT_ACTIONED, SETTLEMENT_ACTIONED_FILE SETTLEMENT_ACTIONED_FILE, SETTLEMENT_AUTHORISED_BY SETTLEMENT_AUTHORISED_BY, SETTLEMENT_NUMBER SETTLEMENT_NUMBER, SETTLEMENT_PARTY SETTLEMENT_PARTY, STATUS_CODE STATUS_CODE, TRANSACTION_DATE TRANSACTION_DATE, TRANSACTION_NUMBER TRANSACTION_NUMBER, TRANSACTION_RATE TRANSACTION_RATE, TRANS_MTS TRANS_MTS, UPDATED_BY UPDATED_BY, UPDATED_ON UPDATED_ON, ORIGINAL_SETTLEMENT_CURRENCY ORIGINAL_SETTLEMENT_CURRENCY, ORIGINAL_SETTLEMENT_AMOUNT ORIGINAL_SETTLEMENT_AMOUNT, COMPANY_HCE_AMOUNT COMPANY_HCE_AMOUNT, CREATED_BY CREATED_BY, CREATED_ON CREATED_ON, BATCH_ID BATCH_ID, DEAL_DATE_AMOUNT_ID DEAL_DATE_AMOUNT_ID, COMPANY_ACCT_USE_ID COMPANY_ACCT_USE_ID, CPARTY_ACCT_USE_ID CPARTY_ACCT_USE_ID, BENEFECIARY_ACCT_USE_ID BENEFECIARY_ACCT_USE_ID from "XTR"."XTR_DEAL_DATE_AMOUNTS"

View Text - HTML Formatted

SELECT ACCOUNT_NO ACCOUNT_NO
, ACCRUAL_FROM ACCRUAL_FROM
, ACCRUAL_TO ACCRUAL_TO
, ACTION_CODE ACTION_CODE
, ACTION_COMPLETED ACTION_COMPLETED
, ACTUAL_SETTLEMENT_DATE ACTUAL_SETTLEMENT_DATE
, AMOUNT AMOUNT
, AMOUNT_DATE AMOUNT_DATE
, AMOUNT_TYPE AMOUNT_TYPE
, ARCHIVE_BY ARCHIVE_BY
, ARCHIVE_DATE ARCHIVE_DATE
, ATTACHMENT_EXISTS ATTACHMENT_EXISTS
, AUDIT_INDICATOR AUDIT_INDICATOR
, AUTHORISED AUTHORISED
, BALANCE_SHEET_EXPOSURE BALANCE_SHEET_EXPOSURE
, BENEFICIARY_ACCOUNT_NO BENEFICIARY_ACCOUNT_NO
, BENEFICIARY_PARTY BENEFICIARY_PARTY
, CASHFLOW_AMOUNT CASHFLOW_AMOUNT
, CHQ_REQD CHQ_REQD
, CLIENT_BROKER_CLRACCT CLIENT_BROKER_CLRACCT
, CLIENT_CODE CLIENT_CODE
, COMMENCE_DATE COMMENCE_DATE
, COMMENTS COMMENTS
, COMPANY_CODE COMPANY_CODE
, CONTRACT_CODE CONTRACT_CODE
, CPARTY_ACCOUNT_NO CPARTY_ACCOUNT_NO
, CPARTY_CODE CPARTY_CODE
, CURRENCY CURRENCY
, CURRENCY_COMBINATION CURRENCY_COMBINATION
, DATE_TYPE DATE_TYPE
, DEALER_CODE DEALER_CODE
, DEAL_NUMBER DEAL_NUMBER
, DEAL_ORDERS DEAL_ORDERS
, DEAL_SUBTYPE DEAL_SUBTYPE
, DEAL_TYPE DEAL_TYPE
, DIARY_CREATED_BY DIARY_CREATED_BY
, DIARY_NOTE DIARY_NOTE
, DIRECT_DEBIT DIRECT_DEBIT
, DUAL_AUTHORISATION_BY DUAL_AUTHORISATION_BY
, DUAL_AUTHORISATION_ON DUAL_AUTHORISATION_ON
, EXPOSURE_REF_DATE EXPOSURE_REF_DATE
, EXP_SETTLE_REQD EXP_SETTLE_REQD
, EXTERNAL_COMMENTS EXTERNAL_COMMENTS
, FIRST_ACCRUAL FIRST_ACCRUAL
, FRA_DESCRIPTION FRA_DESCRIPTION
, GENERAL_OR_PRIVATE_ACCESS GENERAL_OR_PRIVATE_ACCESS
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, GOOD_VALUE_CLAIM GOOD_VALUE_CLAIM
, HCE_AMOUNT HCE_AMOUNT
, JOURNAL_CREATED JOURNAL_CREATED
, LIMIT_CODE LIMIT_CODE
, LIMIT_PARTY LIMIT_PARTY
, MULTIPLE_REFERENCE_NUMBER MULTIPLE_REFERENCE_NUMBER
, MULTIPLE_SETTLEMENTS MULTIPLE_SETTLEMENTS
, NETOFF_GROUP_FLAG NETOFF_GROUP_FLAG
, NETOFF_NUMBER NETOFF_NUMBER
, PORTFOLIO_CODE PORTFOLIO_CODE
, PRINTED_MATURITY_YN PRINTED_MATURITY_YN
, PRODUCT_TYPE PRODUCT_TYPE
, QUICK_INPUT QUICK_INPUT
, RECONCILED_DAYS_ADJUST RECONCILED_DAYS_ADJUST
, RECONCILED_PASS_CODE RECONCILED_PASS_CODE
, RECONCILED_REFERENCE RECONCILED_REFERENCE
, SERIAL_REFERENCE SERIAL_REFERENCE
, SETTLE SETTLE
, SETTLEMENT_ACTIONED SETTLEMENT_ACTIONED
, SETTLEMENT_ACTIONED_FILE SETTLEMENT_ACTIONED_FILE
, SETTLEMENT_AUTHORISED_BY SETTLEMENT_AUTHORISED_BY
, SETTLEMENT_NUMBER SETTLEMENT_NUMBER
, SETTLEMENT_PARTY SETTLEMENT_PARTY
, STATUS_CODE STATUS_CODE
, TRANSACTION_DATE TRANSACTION_DATE
, TRANSACTION_NUMBER TRANSACTION_NUMBER
, TRANSACTION_RATE TRANSACTION_RATE
, TRANS_MTS TRANS_MTS
, UPDATED_BY UPDATED_BY
, UPDATED_ON UPDATED_ON
, ORIGINAL_SETTLEMENT_CURRENCY ORIGINAL_SETTLEMENT_CURRENCY
, ORIGINAL_SETTLEMENT_AMOUNT ORIGINAL_SETTLEMENT_AMOUNT
, COMPANY_HCE_AMOUNT COMPANY_HCE_AMOUNT
, CREATED_BY CREATED_BY
, CREATED_ON CREATED_ON
, BATCH_ID BATCH_ID
, DEAL_DATE_AMOUNT_ID DEAL_DATE_AMOUNT_ID
, COMPANY_ACCT_USE_ID COMPANY_ACCT_USE_ID
, CPARTY_ACCT_USE_ID CPARTY_ACCT_USE_ID
, BENEFECIARY_ACCT_USE_ID BENEFECIARY_ACCT_USE_ID
FROM "XTR"."XTR_DEAL_DATE_AMOUNTS"