Summary Types

The caption field in the SummaryType table is an nvarchar data type with a maximum length of 64 characters and is used to store a brief description of the summary type.

The Description field in the SummaryType table is an nvarchar data type which has a maximum length of 128 characters. This field is meant to give a brief description associated with the type, such as for describing a class, item, etc.

Miscellaneous notes and information for the entry or record.

The field named “Filter” in the SummaryType table is used to refine searches and store extra information about a certain SummaryType row. It is a data type nvarchar and has a maximum length of 256. It can contain any character, including Unicode characters, however any text longer than the specified maximum length 256 will be truncated.

AggregateOperatorId is an nvarchar field in the SummaryType table which stores an identification code of up to 32 characters associated with an aggregate operator. This identifier is used to link to the aggregate operator table and identify the necessary calculations associated with the summary type.