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.
