Axiom.Tables

The name of the table.

Product systems may also use CustomerTableName and PreferredName. CustomerTableName returns the original defined name of the table. PreferredName returns the preferred name of the table, if defined. Preferred names are only available if the table is configured as variable by product development. If a preferred name is defined, TableName also returns the preferred name.

The database ID of the table.

The description of the table.

The table classification: Data, LargeData, Reference, DocumentBasedReference.

NOTES:

• Picklist tables are reference tables. The IsPicklist field specifies whether a reference table is a picklist table.
• KPI tables are reference tables. The IsKPITable field specifies whether a reference table is a picklist table.

Whether the table is a picklist table (True/False). Only reference tables can be picklist tables.

Whether the table is a KPI table (True/False). Only reference tables can be KPI tables.

The table type that the table is assigned to.

The folder that the table is organized under.

Whether the table structure is fixed (True/False).

Whether changes to the table's data are audited (True/False).

Whether the table is read-only (True/False).

The name of the source document for the table, if the table is a document reference table (created via Save Type 3). Returns blank if the table isn't a document reference table.

The current period for the table. This is the system current period unless a current period has been explicitly defined for the table.

The database ID of the rate table to be used when converting the data in the table. Only applies if data conversion is configured for the table.

The database ID of the column that holds the "from" values for data conversions. Only applies if data conversion is configured for the table.

The database ID of the column that holds the "to" values for data conversions. Only applies if data conversion is configured for the table.

The database ID of the column that holds the type values for data conversions. Only applies if data conversion is configured for the table.

The database ID of the column that holds the scenario values for data conversions. Only applies if data conversion is configured for the table.

The "From" conversion value for the table. Only applies if data conversion is configured for the table.

The lookup column that holds the conversion values for the table. Only applies if data conversion is configured for the table.

The conversion type for the table. Only applies if data conversion is configured for the table.

The lookup column that holds the conversion types for the table. Only applies if data conversion is configured for the table.

The scenario for the table. Only applies if data conversion is configured for the table.

The file group the table is associated with, if the table was created using the file group scenarios feature.

The source table that this table was cloned from, if the table was created using the file group scenarios feature.

Whether the table is a prototype table (True/False). This is only used in product systems, and can only be configured by product development.

Whether the table is variable (True/False) to allow preferred names. This is only used in product systems, and can only be configured by product development.

The database ID of the user who created the table.

The date/time the table was created.

The database ID of the user who last modified the table.