VIEW: XTR.XTR_A_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_DATE_STORED AUDIT_DATE_STORED, 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, DAY_COUNT_TYPE DAY_COUNT_TYPE, ROUNDING_TYPE ROUNDING_TYPE from "XTR"."XTR_A_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_DATE_STORED AUDIT_DATE_STORED
, 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
, DAY_COUNT_TYPE DAY_COUNT_TYPE
, ROUNDING_TYPE ROUNDING_TYPE
FROM "XTR"."XTR_A_INTERGROUP_TRANSFERS"