Add and configure a work order table

Before you add the work order table, do the following:

• Verify that the external work order table is correctly set up

• Add the data source

• Add the data connection

To add the work order table

1. In Project Explorer, right-click the data source, point to Add Item, point to Tables, and then click Work Order Table.

   

   An item appears with the name WorkOrderTable, and it contains a subfolder named Fields.

   

   The name of the WorkOrderTable item becomes the default value for the WorkOrderTableName property, which specifies the name of the table in the external database.

   

2. On the Project menu, click Save.

3. Right-click the work order table, and then click Execute Query. If AVEVA™ Production Management is connected to the external work order table, the Studio Query Result dialog box appears and displays data.

   Select Close, and then proceed to the next step. If AVEVA™ Production Management is not connected to the table, a message appears that alerts you to a situation that requires resolution before you can continue.

4. Configure the properties. For guidance in configuring the properties, see Work order table properties.

Related topics

• Overview of Maintenance

• How to set up Maintenance

• About work order table fields

• Add and configure an OLE-DB data source

• Add and configure an OLE-DB data connection