Creating Custom Field Labels for User Defined Fields


Previous Page  Next Page

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.

 

Field

Data To Enter

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.

 

Module / Form

Source

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.