AVEVA™ Production Management

Work order table properties

Save PDF

Work order table properties

Save PDF

Last UpdatedMar 14, 2025
1 minute read

Refer to the following tables for the key configurable properties of WorkOrderTable item.

Note: A shaded row in the properties table indicates that the property is not editable and is a display value only. The Update category in the properties table is not applicable to Maintenance.

Work Order properties

Property	Description	Valid values
WorkOrderTableName	The name of the external work order table. If you change the value for this property, AVEVA™ Production Management automatically updates the CommandText sub-property of the SelectCommand property, which is the SQL Select statement.	String

Property

Description

Valid values

WorkOrderTableName

The name of the external work order table.

If you change the value for this property, AVEVA™ Production Management automatically updates the CommandText sub-property of the SelectCommand property, which is the SQL Select statement.

Studio project hierarchy view highlighting the Work Order Table Name property in the Work Order section.

String

Read properties

Property	Description	Valid values
SelectCommand	Reference to the SQL statement or stored procedure name that AVEVA™ Production Management uses to read the database table. This command comprises the CommandText, CommandTimeOut, and Parameters properties.	A valid SQL statement
	CommandText - Defines the SQL Select statement that AVEVA Production Management uses to read the database table.	A valid SQL statement
	CommandTimeOut - The command timeout in seconds for the SQL statement. Its valid values are	Integers
	Parameters - This is a set of parameters for the SQL statement. Click Browse (...) to open the OleDbParameter Collection Editor dialog box.	Valid SQL parameters

AVEVA™ Production Management