AX1052
Axiom.FileGroups
The Axiom.FileGroups system table contains information about the defined file groups in your system.
Available columns
The following columns can be queried:
| Column | Description |
|---|---|
|
FileGroupID |
The database ID of the file group. |
|
FileGroupCode |
The file group code (for example, FG0001). |
|
FileGroupCategoryID |
The database ID of the file group's category (blank if no assigned category). |
|
FileGroupName |
The name of the file group. |
|
ScenarioName |
The scenario name, if the file group is a scenario (blank if not a scenario). The scenario name is returned without parentheses. |
|
DisplayName |
The display name of the file group. |
|
FileGroupYear |
The file group year of the file group (0 if not defined). |
|
Description |
The description of the file group. |
|
TemplateColumnName |
The column name of the designated template column (blank if no assigned column). |
|
ShowOnListColumnName |
The column name of the designated Show on List column (blank if no assigned column). |
|
TableName |
The name of the plan code table for the file group. |
|
KeyColumnName |
The column name of the key column for the plan code table. |
|
TabPrefix |
The tab prefix of the file group. |
|
SourceFileGroupID |
Deprecated. The database ID of the source file group, if the file group was cloned from another file group (either by using the File Group Clone feature or the File Group Scenario feature). Returns blank if inapplicable. This field is no longer active but may be present in older reports and may still return legacy values. |
|
IsDynamicAdd |
Whether the file group is an on-demand file group (True/False). |
|
IsScenario |
Whether the file group is a scenario (True/False). |
|
ScenarioParentID |
The ID of the parent file group for the scenario. Only applies to scenario file groups. Returns blank otherwise. |
|
DefaultTemplateName |
The name of the default template (blank if not defined). |
|
DefaultNotificationAddress |
The default notification email address for the file group (blank if not defined). |
|
NotificationAddressColumnName |
The column name of the designated notification column (blank if no assigned column). |
|
EnableFileAttachments |
Whether file attachments are enabled for the file group (True/False). |
|
RestrictSavesToRelatedTables |
Whether the file group is configured to restrict saves to related tables (True/False). |
|
IsPrototype |
Whether the file group is a prototype file group (True/False). This is only used by product systems. |
| IsWebFileGroup | Whether the file group is a web file group (True/False). This is only used by product systems. |
|
SourcePrototypeID |
The ID of the prototype file group used to create the file group. This is only used by product systems. |
|
CreatedByID |
The database ID of the user who created the file group. |
|
CreatedDTM |
The date/time the file group was created. |
|
ModifiedByID |
The database ID of the user who last modified the file group. |
|
ModifiedDTM |
The date/time the file group was last modified. |
Save Type 4 support
Axiom.FileGroups cannot be modified using Save Type 4.
