AX2473
Axiom.CalculatedFields
The Axiom.CalculatedFields system table contains information about the defined calculated fields in your system.
NOTE: This table stores the calculated fields defined for your tables, such as CYATOT. If you want to return the list of calculation types that are available to be used within calculated fields, query the Axiom.Calculations table.
Available columns
The following columns can be queried:
| Column | Description |
|---|---|
|
ColumnName |
The name of the calculated field. |
|
ColumnID |
The database ID of the calculated field. |
|
TableName |
The name of the table. |
|
QualifiedName |
The fully qualified name of the calculated field (Table.Column). |
|
DataType |
The data type of the calculated field. This is always numeric. |
|
SequenceName |
The name of the assigned sequence for the calculated field. |
|
CalculationTypeName |
The name of the assigned calculation type for the calculated field. |
|
CreatedByID |
The database ID of the user who created the field. |
|
ModifiedByID |
The database ID of the user who last modified the field. |
|
CreatedDTM |
The date/time the field was created. |
|
ModifiedDTM |
The date/time the field was last modified. |
Save Type 4 support
Axiom.CalculatedFields can be modified using Save Type 4. See Managing calculated fields using Save Type 4.
