Table CASHFLOW_PATTERN_DIMENSION

DescriptionCashflow pattern dimension identifies the different cash flow patterns defined in the system.

Columns
CASHFLOW_PATTERN_DIMENSION_IDCASHFLOW_PATTERN_DIMENSION_ID
DESCRIPTIONDESCRIPTION
IMAGE_URLIMAGE_URL

Primary Key
CASHFLOW_PATTERN_DIMENSION_PKCASHFLOW_PATTERN_DIMENSION_PK

Indexes
CASHFLOW_PATTERN_DIMENSION_PKCASHFLOW_PATTERN_DIMENSION_PK

Column Details

 CASHFLOW_PATTERN_DIMENSION_ID
DescriptionThe unique identifier of the cash flow pattern dimension.
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identitytrue
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DESCRIPTION
DescriptionDescription identifies the name of the cash flow pattern.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 IMAGE_URL
DescriptionImage URL identifies the sample image of the cash flow pattern.
Data TypeVARCHAR(2000)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Primary Key Details

 CASHFLOW_PATTERN_DIMENSION_PK
DescriptionThe unique identifier of the cash flow pattern dimension.
MemberCASHFLOW_PATTERN_DIMENSION_ID [BIGINT]

Index Details

 CASHFLOW_PATTERN_DIMENSION_PK
Is Uniquetrue
Is Clusteredfalse
MemberCASHFLOW_PATTERN_DIMENSION_ID [BIGINT] Ascending