Set up required fields in the work order table
- Last UpdatedSep 25, 2023
- 3 minute read
After you populate work order table fields, set up the three fields in the work order table that represent the required fields of the external work order table. The three required fields are:
-
Work order request number
-
Equipment ID
-
Originator ID
Work order request number
Because the work order request number is a unique number, you require a method to generate the number. The simplest way to do this is with the Expression Editor, but you can use other methods such as a lookup table or reference a code item. The following procedure uses the Expression Editor to generate the number.
Set up the field for work order request number
-
Display the properties of the field that the work order table uses for the work order request number.
-
Set the FieldType property to ID.
-
Set the FieldIDType property to Other.
-
In the Expression property, click Browse, and then use the Expression Editor to generate a random number with your own routine or a .NET predefined function.
Examples
Type
Formula
Result
String
"WOR"+System.Guid.NewGuid( ).ToString( ).ToUpper( )
A random GUID.
String
time.ToString("YYYYMMDDhhmmssffff")
Date and time in YYYYMMDDhhmmssffff format. There must be double quotation marks around the format token.
Long
time.Ticks
A large and unique number.
-
On the Project menu, click Save.
Equipment ID
When a work order request is created in AVEVA™ Production Management either automatically or manually, the field for equipment ID uses the equipment ID of the location where the work order request is created.
Set up the field for equipment ID
-
Display the properties of the field that the work order table uses for equipment ID.
-
Set the FieldType property to ID.
-
Set the FieldIDType property to EquipmentID.
-
On the Project menu, click Save.
-
Proceed to assign an equipment ID to a location.
Originator ID
The originator ID identifies the person who initiates the work order request. When a user creates a work order request in AVEVA™ Production Management, the software automatically populates the originator ID field with the identifier that you assign to the user.
Set up the field for originator ID
-
Display the properties of the field that the work order table uses for originator ID.
-
Set the FieldType property to UserCompany.
-
On the Project menu, click Save.
-
Proceed to Assign an originator ID to a user.