[Home] [Help]
View: 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 |