Home >

AX1146

Axiom.ColumnSequenceItems

The Axiom.ColumnSequenceItems system table contains information about the individual columns in column sequences.

Each column that is assigned to a sequence generates a sequence item that holds the properties for that column assignment. For example, if 12 columns are assigned to a sequence, then that sequence will have 12 sequence items. If you want information about the column sequence properties instead, query the Axiom.ColumnSequences table.

Available columns

The following columns can be queried:

Column	Description
SequenceID	The database ID of the sequence.
SequenceName	The name of the sequence.
TableName	The name of the table where the sequence is defined.
SequenceItemID	The database ID of the sequence item.
ColumnDefinitionID	The database ID of the column assigned to the sequence item.
ColumnName	The name of the column assigned to the sequence item.
Period	The period of the sequence item, meaning its order in the sequence.
WeightFactor	The weight factor of the sequence item.
CreatedByID	The database ID of the user who created the sequence.
CreatedDTM	The date/time the sequence was created.
ModifiedByID	The database ID of the user who last modified the sequence.
ModifiedDTM	The date/time the sequence was last modified.

NOTE: The database IDs assigned to sequences and sequence items are not permanent. If you need to identify a particular sequence item, you should use the combination of TableName/SequenceName/ColumnName.

Save Type 4 support

Axiom.ColumnSequenceItems can be modified using Save Type 4. See Managing column sequence items using Save Type 4.