You have the ability to display a custom field label (caption) for user defined fields in many OrderStream modules The user defined labels for items is based on the category the item belongs to and the user defined labels for labour operations can be based on work cell OR the task that is assigned to the labour. This is designed to make it easier for the user to accurately interpret and apply the information stored in the user defined field.
You only need to setup the unique field labels for Categories, Work Cells, and Tasks that you wish to display unique field labels for. Field Labels which do not possess any Category, Work Cell, or Task information are considered default field labels and will be displayed for all Categories, Work Cells and Tasks that do not have unique fields set up against them.
To setup the unique user defined field labels, open your ActiveM database in SQL Server Managment Studio and browse to the UserDefinedFieldLabels table. Open the table to view the fields described in the following table.
|
|
Source
|
The module or form within a module containing UserDefined fields for which custom labels can be defined. See the table below to get the source to enter by module / form.
|
FieldIndex
|
The specific userdefined field to apply the label to. The fields are numbered in the order they appear; for example, to specify a custom label for the first user defined field in the group, enter 1.
|
FieldLabel
|
The unique label to be applied to the field.
|
Filter1
|
Use when applying labels by Category. Enter the ID of the relevant Category.
|
Filter2
|
Use when applying labels by Work Cell. Enter the ID of the relevant Work Cell.
|
Filter3
|
Use when applying labels by Task. Enter the ID of the relevant Task.
|
|
|
Inventory Adjustment
|
Adjustment
|
Inventory Transfer Inventory Details
|
TransferAlloc
|
Inventory On Hand
|
InvOnHand
|
Material Requisition
|
MatReq
|
Purchase Order
|
PO
|
Receiving Inventory Details
|
PO
|
Work Order Reallocation
|
Reallocation
|
Customer Ship To Maintenance
|
CustomerShipTo
|
Item Editor Edit Component Form
|
Bom
|
Item Editor Edit Operation Form
|
Ops
|
As an example, to specify user defined field labels on the Item Editor Edit Component form by Category enter the data into the relevant fields.
The next time you view the UserDefined fields of an item belonging to the designated category (CategoryID 38), the label you defined will be displayed.
|