AX2647

Sequence properties

This topic is a reference for the properties available for column sequences. Column sequences are defined on the Sequences tab of the Edit Table dialog.

Property	Description
Sequence Name	The name of the sequence. The sequence name can be anything you like. It is only used when setting up other table features; end users do not see or interact with sequence names. The sequence name must be unique per table. However, multiple tables can use the same sequence name. For example, the GL2018 and the GL2019 tables can both have a sequence named "M" (for months).
Start Period	The starting period of the sequence. In most cases, the starting period is 1 and does not need to be changed. However, if the sequence is for a partial year of data (such as data that starts with period 7), you can specify the start period for the sequence.
Columns in Sequence	The columns that are included in the sequence. To add columns, select columns in the Available Columns list and then click Add. To remove columns, select columns in the Columns in Sequence list and then click Remove. The columns will be evaluated in the order listed. For example, if the sequence is used for a YTD calculation (year-to-date), and the current period is 4, the first four columns in the list would be included in that calculation. Use the Up and Down buttons to adjust the order as needed. The column Weight is used for weighted average calculations, such as the "daily weighted average" calculation for financial institutions (in which case the weight would be the number of days in that period). If you are not using weighted averages for this sequence, leave the weight at 1 for each column.

Property

Description

Sequence Name

The name of the sequence.

The sequence name can be anything you like. It is only used when setting up other table features; end users do not see or interact with sequence names.

The sequence name must be unique per table. However, multiple tables can use the same sequence name. For example, the GL2018 and the GL2019 tables can both have a sequence named "M" (for months).

Start Period

The starting period of the sequence.

In most cases, the starting period is 1 and does not need to be changed. However, if the sequence is for a partial year of data (such as data that starts with period 7), you can specify the start period for the sequence.

Columns in Sequence

The columns that are included in the sequence.

To add columns, select columns in the Available Columns list and then click Add.
To remove columns, select columns in the Columns in Sequence list and then click Remove.

The columns will be evaluated in the order listed. For example, if the sequence is used for a YTD calculation (year-to-date), and the current period is 4, the first four columns in the list would be included in that calculation. Use the Up and Down buttons to adjust the order as needed.

The column Weight is used for weighted average calculations, such as the "daily weighted average" calculation for financial institutions (in which case the weight would be the number of days in that period). If you are not using weighted averages for this sequence, leave the weight at 1 for each column.