PortfolioLegData


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int 4 null
TradeId varchar 180 null
PortfolioTrades.Id FK_PortfolioLegData_TradeId R
Payer varchar 5 √ null
TypesBool.value FK_PortfolioLegData_Payer R
LegType varchar 20 √ null
TypesLegType.value FK_PortfolioLegData_LegType R
Currency varchar 7 √ null
TypesCurrencyCode.value FK_PortfolioLegData_Currency R
PaymentConvention varchar 20 √ null
TypesBusinessDayConvention.value FK_PortfolioLegData_PaymentConvention R
DayCounter varchar 30 √ null
TypesDayCounter.value FK_PortfolioLegData_DayCounter R
NotionalInitialExchange varchar 5 √ null
TypesBool.value FK_PortfolioLegData_NotionalInitialExchange R
NotionalFinalExchange varchar 5 √ null
TypesBool.value FK_PortfolioLegData_NotionalFinalExchange R
NotionalAmortizingExchange varchar 5 √ null
TypesBool.value FK_PortfolioLegData_NotionalAmortizingExchange R
FXResetForeignCurrency varchar 7 √ null
TypesCurrencyCode.value FK_PortfolioLegData_FXResetForeignCurrency R
FXResetForeignAmount decimal 20,3 √ null
FXResetFXIndex varchar 30 √ null
TypesIndexName.value FK_PortfolioLegData_FXResetFXIndex R
FXResetFixingDays int 4 √ null
FloatingLegIndexName varchar 30 √ null
TypesIndexName.value FK_PortfolioLegData_FloatingLegIndexName R
FloatingLegIsInArrears varchar 5 √ null
TypesBool.value FK_PortfolioLegData_FloatingLegIsInArrears R
FloatingLegFixingDays int 4 √ null
FloatingLegIsAveraged varchar 5 √ null
TypesBool.value FK_PortfolioLegData_FloatingLegIsAveraged R
FloatingLegIsNotResettingXCCY varchar 5 √ null
TypesBool.value FK_PortfolioLegData_FloatingLegIsNotResettingXCCY R
FloatingLegNakedOption varchar 5 √ null
TypesBool.value FK_PortfolioLegData_FloatingLegNakedOption R
CPILegIndexName varchar 30 √ null
TypesIndexName.value FK_PortfolioLegData_CPILegIndexName R
CPILegBaseCPI decimal 20,10 √ null
CPILegObservationLag varchar 5 √ null
CPILegInterpolated varchar 5 √ null
TypesBool.value FK_PortfolioLegData_CPILegInterpolated R
CPILegSubtractInflationNotional varchar 5 √ null
TypesBool.value FK_PortfolioLegData_CPILegSubtractInflationNotional R
YYLegIndexName varchar 30 √ null
TypesIndexName.value FK_PortfolioLegData_YYLegIndexName R
YYLegFixingDays int 4 √ null
YYLegObservationLag varchar 5 √ null
YYLegInterpolated varchar 5 √ null
TypesBool.value FK_PortfolioLegData_YYLegInterpolated R

Table contained 136 rows

Indexes

Constraint Name Type Sort Column(s)
PK_PortfolioLegData Primary key Asc Id

Relationships

Close relationships within degrees of separation