eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: XTR.XTR_COST_OF_FUNDS

Object Details

Object Name:	XTR_COST_OF_FUNDS
Object Type:	TABLE
Owner:	XTR
FND Design Data:	XTR.XTR_COST_OF_FUNDS
Subobject Name:
Status:	VALID

XTR_COST_OF_FUNDS contains the daily summarized amount and average rate information from XTR_POSITION_HISTORY. Each row corresponds to a cost of funds summary for a specific combination of the following factors: date, company, counterparty, deal type, deal subtype, product type, portfolio, currency, and currency combination. The XTR_POSITION HISTORY table triggers an update of XTR_COST_OF_FUNDS when a company?s position history information changes.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XTR_COST_OF_FUNDS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AS_AT_DATE COMPANY_CODE DEAL_TYPE
XTR_COST_OF_FUNDS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DEAL_TYPE
XTR_COST_OF_FUNDS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CURRENCY
XTR_COST_OF_FUNDS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DEAL_SUBTYPE

Columns

Name	Datatype	Length	Mandatory	Comments
ACCOUNT_NO	VARCHAR2	(20)		Alpha-numeric reference to financial accounts of Treasury parties
AS_AT_DATE	DATE		Yes	As of date
AVG_INTEREST_RATE	NUMBER			Average interest rate
COMMENCE_DATE	DATE			Not currently used
COMPANY_CODE	VARCHAR2	(7)	Yes	Company code
CONTRA_CCY	VARCHAR2	(15)		Contra currency in a foreign exchange currency quote
CREATED_ON	DATE			Date this record was created
CURRENCY	VARCHAR2	(15)	Yes	Currency code
CURRENCY_COMBINATION	VARCHAR2	(31)		Currency quotations which combine a base and a contra currency
DEAL_SUBTYPE	VARCHAR2	(7)		Code for deal executions permissible within a deal type
DEAL_TYPE	VARCHAR2	(7)	Yes	Code for high level deals
GROSS_PRINCIPAL	NUMBER			Gross principal amount
HCE_GROSS_PRINCIPAL	NUMBER			Gross principal in reporting currency equivalent
HCE_INTEREST	NUMBER			Interest amount in reporting currency equivalent
INTEREST	NUMBER			Interest amount
NO_OF_DAYS	NUMBER			Not currently used
NO_OF_DEALS	NUMBER			Number of deals
PARTY_CODE	VARCHAR2	(7)		Party code
PORTFOLIO_CODE	VARCHAR2	(7)		Code for grouping deals under a single portfolio
PRODUCT_TYPE	VARCHAR2	(10)		Code for products used in a deal type
WEIGHTED_AVG_PRINCIPAL	NUMBER			Gross principal of face value amount times transaction rate
AVG_BASE_RATE	NUMBER			Average base currency exchange rate
BASE_WEIGHTED_AVG_PRINCIPAL	NUMBER			Gross principal of face value amount times base rate
GROSS_BASE_AMOUNT	NUMBER			sum of absolute value of base currency amount
GROSS_CONTRA_TRANS_AMOUNT	NUMBER			sum of absolute value of contra currency amount in terms of transactions rate
GROSS_CONTRA_SPOT_AMOUNT	NUMBER			sum of absolute value of contra currency amount in terms of spot rate

Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

XTR.XTR_COST_OF_FUNDS does not reference any database object

XTR.XTR_COST_OF_FUNDS is referenced by following:

XTR: XTR_COST_OF_FUNDS#