PortfolioScheduleDataRules

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

Id

int

4

null

TradeActionId

int

4

√

null

LegDataId

int

4

√

null

StartDate

date

6

√

null

EndDate

date

6

√

null

Tenor

varchar

8

√

null

Calendar

varchar

20

√

null

Convention

varchar

20

√

null

TypesBusinessDayConvention.value

FK_PortfolioScheduleDataRules_Convention R

TermConvention

varchar

20

√

null

TypesBusinessDayConvention.value

FK_PortfolioScheduleDataRules_TermConvention R

RuleName

varchar

20

√

null

TypesDateRule.value

FK_PortfolioScheduleDataRules_RuleName R

EndOfMonth

varchar

5

√

null

TypesBool.value

FK_PortfolioScheduleDataRules_EndOfMonth R

FirstDate

date

6

√

null

LastDate

date

6

√

null

Showing 1 to 13 of 13 entries

Table contained 138 rows

Indexes

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

Relationships

Close relationships within degrees of separation

One
Two degrees