FND Design Data [Home] [Help]

View: XTR_COST_OF_FUNDS_V

Product: XTR - Treasury
Description:
Implementation/DBA Data: ViewAPPS.XTR_COST_OF_FUNDS_V
View Text

SELECT AS_AT_DATE
, COMPANY_CODE
, CURRENCY
, DEAL_TYPE
, DEAL_SUBTYPE
, PARTY_CODE
, PORTFOLIO_CODE
, PRODUCT_TYPE
, GROSS_PRINCIPAL
, HCE_GROSS_PRINCIPAL
, WEIGHTED_AVG_PRINCIPAL
, AVG_INTEREST_RATE
, INTEREST
, HCE_INTEREST
, NO_OF_DAYS
, NO_OF_DEALS
, CONTRA_CCY
, CURRENCY_COMBINATION
, ACCOUNT_NO
, CREATED_ON
, COMMENCE_DATE
, AVG_BASE_RATE
, BASE_WEIGHTED_AVG_PRINCIPAL
, GROSS_BASE_AMOUNT
, GROSS_CONTRA_TRANS_AMOUNT
, GROSS_CONTRA_SPOT_AMOUNT
FROM XTR_COST_OF_FUNDS

Columns

Name
AS_AT_DATE
COMPANY_CODE
CURRENCY
DEAL_TYPE
DEAL_SUBTYPE
PARTY_CODE
PORTFOLIO_CODE
PRODUCT_TYPE
GROSS_PRINCIPAL
HCE_GROSS_PRINCIPAL
WEIGHTED_AVG_PRINCIPAL
AVG_INTEREST_RATE
INTEREST
HCE_INTEREST
NO_OF_DAYS
NO_OF_DEALS
CONTRA_CCY
CURRENCY_COMBINATION
ACCOUNT_NO
CREATED_ON
COMMENCE_DATE
AVG_BASE_RATE
BASE_WEIGHTED_AVG_PRINCIPAL
GROSS_BASE_AMOUNT
GROSS_CONTRA_TRANS_AMOUNT
GROSS_CONTRA_SPOT_AMOUNT