VIEW: XTR.XTR_INTERGROUP_TRANSFERS#

Source

View Text - Preformatted

select ACCT_REF ACCT_REF, ACCUM_INTEREST_BF ACCUM_INTEREST_BF, ACCUM_INTEREST_BF_HCE ACCUM_INTEREST_BF_HCE, AUDIT_INDICATOR AUDIT_INDICATOR, BALANCE_BF BALANCE_BF, BALANCE_BF_HCE BALANCE_BF_HCE, BALANCE_OUT BALANCE_OUT, BALANCE_OUT_HCE BALANCE_OUT_HCE, COMMENTS COMMENTS, COMPANY_ACCOUNT_NO COMPANY_ACCOUNT_NO, COMPANY_CODE COMPANY_CODE, CREATED_BY CREATED_BY, CREATED_ON CREATED_ON, CURRENCY CURRENCY, DEAL_NUMBER DEAL_NUMBER, DEAL_TYPE DEAL_TYPE, INTEREST INTEREST, INTEREST_HCE INTEREST_HCE, INTEREST_RATE INTEREST_RATE, INTEREST_SETTLED INTEREST_SETTLED, INTEREST_SETTLED_HCE INTEREST_SETTLED_HCE, LIMIT_CODE LIMIT_CODE, NO_OF_DAYS NO_OF_DAYS, PARTY_ACCOUNT_NO PARTY_ACCOUNT_NO, PARTY_CODE PARTY_CODE, PORTFOLIO PORTFOLIO, PRINCIPAL_ACTION PRINCIPAL_ACTION, PRINCIPAL_ADJUST PRINCIPAL_ADJUST, PRINCIPAL_ADJUST_HCE PRINCIPAL_ADJUST_HCE, PRODUCT_TYPE PRODUCT_TYPE, SETTLE_DATE SETTLE_DATE, TRANSACTION_NUMBER TRANSACTION_NUMBER, TRANSFER_DATE TRANSFER_DATE, UPDATED_BY UPDATED_BY, UPDATED_ON UPDATED_ON, ACCRUAL_INTEREST ACCRUAL_INTEREST, FIRST_BATCH_ID FIRST_BATCH_ID, LAST_BATCH_ID LAST_BATCH_ID, EXCHANGE_RATE EXCHANGE_RATE, AVERAGE_EXCHANGE_RATE AVERAGE_EXCHANGE_RATE, 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, INTEREST_ACTION INTEREST_ACTION, 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, LIMIT_CODE_INVEST LIMIT_CODE_INVEST, MIRROR_DEAL MIRROR_DEAL, MIRROR_DEAL_NUMBER MIRROR_DEAL_NUMBER, MIRROR_TRANSACTION_NUMBER MIRROR_TRANSACTION_NUMBER, ROUNDING_TYPE ROUNDING_TYPE, DAY_COUNT_TYPE DAY_COUNT_TYPE, ORIGINAL_AMOUNT ORIGINAL_AMOUNT, PRICING_MODEL PRICING_MODEL, COMPANY_ACCT_USE_ID COMPANY_ACCT_USE_ID, CPARTY_ACCT_USE_ID CPARTY_ACCT_USE_ID, DEAL_LINKING_CODE DEAL_LINKING_CODE, DEALER_CODE DEALER_CODE, EXTERNAL_SOURCE EXTERNAL_SOURCE from "XTR"."XTR_INTERGROUP_TRANSFERS"

View Text - HTML Formatted

SELECT ACCT_REF ACCT_REF
, ACCUM_INTEREST_BF ACCUM_INTEREST_BF
, ACCUM_INTEREST_BF_HCE ACCUM_INTEREST_BF_HCE
, AUDIT_INDICATOR AUDIT_INDICATOR
, BALANCE_BF BALANCE_BF
, BALANCE_BF_HCE BALANCE_BF_HCE
, BALANCE_OUT BALANCE_OUT
, BALANCE_OUT_HCE BALANCE_OUT_HCE
, COMMENTS COMMENTS
, COMPANY_ACCOUNT_NO COMPANY_ACCOUNT_NO
, COMPANY_CODE COMPANY_CODE
, CREATED_BY CREATED_BY
, CREATED_ON CREATED_ON
, CURRENCY CURRENCY
, DEAL_NUMBER DEAL_NUMBER
, DEAL_TYPE DEAL_TYPE
, INTEREST INTEREST
, INTEREST_HCE INTEREST_HCE
, INTEREST_RATE INTEREST_RATE
, INTEREST_SETTLED INTEREST_SETTLED
, INTEREST_SETTLED_HCE INTEREST_SETTLED_HCE
, LIMIT_CODE LIMIT_CODE
, NO_OF_DAYS NO_OF_DAYS
, PARTY_ACCOUNT_NO PARTY_ACCOUNT_NO
, PARTY_CODE PARTY_CODE
, PORTFOLIO PORTFOLIO
, PRINCIPAL_ACTION PRINCIPAL_ACTION
, PRINCIPAL_ADJUST PRINCIPAL_ADJUST
, PRINCIPAL_ADJUST_HCE PRINCIPAL_ADJUST_HCE
, PRODUCT_TYPE PRODUCT_TYPE
, SETTLE_DATE SETTLE_DATE
, TRANSACTION_NUMBER TRANSACTION_NUMBER
, TRANSFER_DATE TRANSFER_DATE
, UPDATED_BY UPDATED_BY
, UPDATED_ON UPDATED_ON
, ACCRUAL_INTEREST ACCRUAL_INTEREST
, FIRST_BATCH_ID FIRST_BATCH_ID
, LAST_BATCH_ID LAST_BATCH_ID
, EXCHANGE_RATE EXCHANGE_RATE
, AVERAGE_EXCHANGE_RATE AVERAGE_EXCHANGE_RATE
, 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
, INTEREST_ACTION INTEREST_ACTION
, 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
, LIMIT_CODE_INVEST LIMIT_CODE_INVEST
, MIRROR_DEAL MIRROR_DEAL
, MIRROR_DEAL_NUMBER MIRROR_DEAL_NUMBER
, MIRROR_TRANSACTION_NUMBER MIRROR_TRANSACTION_NUMBER
, ROUNDING_TYPE ROUNDING_TYPE
, DAY_COUNT_TYPE DAY_COUNT_TYPE
, ORIGINAL_AMOUNT ORIGINAL_AMOUNT
, PRICING_MODEL PRICING_MODEL
, COMPANY_ACCT_USE_ID COMPANY_ACCT_USE_ID
, CPARTY_ACCT_USE_ID CPARTY_ACCT_USE_ID
, DEAL_LINKING_CODE DEAL_LINKING_CODE
, DEALER_CODE DEALER_CODE
, EXTERNAL_SOURCE EXTERNAL_SOURCE
FROM "XTR"."XTR_INTERGROUP_TRANSFERS"