Create a Lookup with table domain in Maximo 7.6

Example:
For each Qualification linked to a Labor we want to record a workorder number. It must be an existing workorder number so the user must select this number from a lookup. The workorder cannot be in status 'WAPPR' assigning it.
How to:Step 1 - Create Table domain
Go the Domains application (located in Sytem Configuration -> Platform Configuration) and click on the 'Add New Domain' button at the bottom right and choose 'Add New Table Domain'
In the 'Validation Where Clause' we state that the entered Workorder number (Will be stored in GNZ_LQWONUM, look below in this post for the configuration of this field) is compared to the workorder number in the workorder table.
WONUM=:GNZ_LQWONUM
In the list the user will get we only want to show workorders that do not have the status WAPPR. Therefor we we fill in the 'List Where Clause'
STATUS<>'WAPPR'

+++++