Item Classes

Classes group Settings, User-defined Fields and Checklists.

Data Types can also be linked to a Class. See Data Types for more information.

Description and Note fields can automatically be updated using User-defined Fields or linked data models using Tags or SQL. The formatting priority is SQL > Tags > None.

Navigation Example

Main Menu > Items > Items > Menu (button) > Edit Classes > Classes (tab)

List View

Buttons Explained

Button Description
NewCreates a new Class.
Menu

Fields Explained

Field Description
Field Chooser (*)Add or remove columns.
IDA system-generated number allocated to the class.
NameThe user-defined Class Name.
Data TypeThe Data Type selected for the class.
Auto Description/NoteA checkbox. If checked, the description is automatically created.
Input FieldsA checkbox. If checked, input fields are created for the class.
ChecklistA checkbox. If checked, a checklist is created for the class.
MenuClick the button or right-click an Item Class for these options:
  • Edit: Edit the Class.
  • Copy: Copy the class to create a new Class.
  • Delete: Delete the Class.

Edit View

Buttons Explained

Button Description
ArrowsArrows let you navigate to the next or previous class.
NewCreate a class.
CopyCopy a class to create a class.
DeleteDelete a class.
SaveSaves any changes.
Edit Input FieldsCreate or edit any input fields (e.g. additional information about a product).
Edit ChecklistCreate or edit a checklist (e.g. checks that users fill in certain fields).
Edit buttons next to headingsAllows those fields to be edited.

Fields Explained

Field Description
NameEnter a name for the class.
Data TypeChoose one of these options:
  • Standard
  • Assets
  • Flexo – Machine
  • Fasteners
Auto Description/SpecificationCheckbox. If checked, the description and specification is created from the name. These fields are unavailable:
  • Description (Tag)
  • Specification (Tag)
  • Description (SQL)
  • Specification (SQL)
Description (Tag)Enter a Tag Description. Tags provide more information about a product (e.g. dimensions, type of material, services required).
Specification (Tag)Enter detailed information about the tag. You can click in the box and edit the information or click Edit (button) to open a text editor.
Description (SQL)Opens an SQL Editor from which you can add or remove data fields to include in the Description.
Specification (SQL)Opens an SQL Editor from which you can add or remove data fields to include in the Specification.
Warning (SQL)Opens an SQL Editor from which you can add or remove data fields to include as Warnings.

Edit Class: SQL Editor

Buttons Explained

Button Description
TemplateCreates a Template for the field.
ClearDeletes the information entered.
CancelDiscards the changes.
SaveSaves the changes.

Tables Lookup List

The list of available tables identified by their data names (e.g. abbreviated names of reports).

Fields Lookup List

  • All the fields available on each table that you can select (double-click) to include in the template (e.g. columns available when viewing a report).
  • This lookup list will change when a different table is selected.

Edit Class: Edit Input Fields

Buttons Explained

Button Description
NewCreates a new Input Field (adds a line at the bottom of the table).
DeleteDeletes an input field.
SaveSaves any changes.
PreviewPreview the changes.
Menu > Create Selectable Store ProcedureCopies the Input Fields as SQL for you to paste into an SQL Editor.

Fields Explained

Info

Fields marked in blue (✎) can be edited.

Field Description
Field Chooser (*)Add or remove columns.
IDA system-generated number allocated to the Input Field.
NameThe Database Name for the Input Field.
CaptionThe Input Field's name shown to Users.
EditorThe expected input. In edit mode, you can select an option from this dropdown list:
  • Checkbox: A yes/no checkbox is created.
  • ComboBox (Fixed list): A lookup list is created. You must select one of the entries.
  • ComboBox (Editable): A lookup list is created. You can select an entry or enter something else.
  • Customer: You must select a customer from a dropdown list of customers.
  • Date: A date must be selected.
  • Date (Read-only): A date is prefilled and cannot be edited.
  • Filename: The name of a file is entered.
  • Group Header: The applicable Group Header is filled in.
  • Image: The field requires an image.
  • Item: You must select an item from a dropdown list of items.
  • Memo: You can type a memo.
  • Number: A number must be entered.
  • Number (Read-only): A specific number appears.
  • Supplier: You must select a supplier from a dropdown list of suppliers.
  • Text: You can input text.
  • Text (Read-only): Specific text appears.
  • Time: You can select a time from a time field.
  • Timestamp: You can select a date and time from the calendar and time fields.
  • Caption: The caption appears.
  • Lookup (SQL): SQL creates a lookup list.
LayoutWhere the Input Field should be positioned. In edit mode, you can select Below, Right and Column from the dropdown list.
WidthThe Width of the Input Field (only applicable to custom fields). You can type a number.
DecimalThe number of decimal places that are allowed in the Input Field.
Order IDThe order of the Input Field in the input hierarchy. The hierarchy is changed using the Menu options (see below).
MenuClick the button or right-click an input field for these options:
  • Insert: Inserts a new line.
  • Edit Lookup List: Only appears when an applicable option is selected in the Editor column (e.g. ComboBox). Enter the entries that should appear in the option chosen (e.g. entries used to create a dropdown list in the ComboBox).
  • Move Up: Moves the line up one line in the hierarchy.
  • Move Down: Moves the line down one line in the hierarchy.
  • Delete: Deletes the input field.

Edit Class: Edit Checklist

Buttons Explained

Button Description
ArrowsArrows let you navigate to the next or previous item.
EditChanges the fields from read-only to be editable.
AddAdds a line at the bottom of the table.
SaveSaves any changes.

Fields Explained

Info

Fields marked in blue (✎) can be edited.

Field Description
Field Chooser (*)Add or remove columns.
DescriptionThe user-defined Description for the checklist item.
CodeA short description (Code) for the checklist item.
TypeSelect Manual, Auto or Override.
Updated byThe name of the user who last updated the entry.
UpdatedThe date on which the entry was last updated.
MenuClick the button or right-click a checklist entry for these options:
  • Edit SQL: Option only applies if Type = Auto or Override. Edit the SQL (See Edit Class: SQL Editor above).
  • Delete: Deletes the specific entry.
  • Move Up: Moves the entry one line up.
  • Move Down: Moves the entry one line down.
Technical Information: Class Fields
Field Description
DescriptionUsed in the Class lookup on Item Categories.
Data TypeThe lookup is populated from the Data Types that are enabled in General Settings.
Description (SQL)Input MATUNITID; Output DESCRIPTION.
Description (Tags)A list of available Tags is provided.
Note (SQL)Input MATUNITID; Output NOTE.
Note (Tags)A list of available Tags is provided.

Report an issue with this page

For more useful feedback, select the text on the page you're reporting about, then click Feedback again — or continue without selecting anything.