Configure Behavior properties

Action

Defines whether this field stores a value with each record or whether it retrieves a value from the Calendar when the record is accessed by AVEVA™ Production Management.

If the Action property is set to LookupCalendar, specify the ItemName in the Calendar

Store, LookupCalendar

CalendarItem

The ItemName in the Calendar table. AVEVA™ Production Management retrieves the item value based on the ItemName and ActiveDateTime pair.

This property is available only when the Action property is LookupCalendar.

Example

ItemName [ActiveDateTime, Item Value]

ItemName [ActiveDateTime, Item Value]

This directs AVEVA™ Production Management to lookup the value of ItemValue associated with specified ItemName in the dbo.Calendar table, based on ActiveDateTime.

ItemName in the dbo.Calendar table of project data SQL database.

CalculatedQualitySourceField

Browse to select the Calculated Quality source field for calculating this value.

See Add and configure a Calculated Inventory source field.

DataType

The data type for the field. This is an important value for storing and aggregating data correctly.

The correct data type is critical to the ability of Production Analyst to display and aggregate information in fields.

The type you select can cause different options to display in the Properties pane. If it is a numeric data type, you can optionally specify the Minimum and Maximum values under the Details Display category.

The data type is required information, however, sometimes can be supplied by the SourceField.

For more information, see Configure the Data Type property for fields.

Note: For Material Quality and Calculated Quality fields, there is Decimal data type, but no Double data type.

If the data type is String, set the String-related properties that determine text entry properties. See StringType property.

Boolean, Date, Double, Integer, Long, Single, String

DisplayFormat

This value specifies the formatting of numeric data types: Double, Integer, Long, and Single.

For each different numeric data type there is a default format; for example, 0.######. For more information, see Configure the Display Format property for fields.

0.######

Filterable

Specifies whether the field is filterable in the Production Analyst data results. Default value is False.

True, False

InventoryQuantity

This enables you to use an evaluated Calculated Inventory quantity instead of the existing quantity.

Click Browse (...) to select a configured Calculated Inventory evaluated field.

RefreshOnManualEntry

Specifies whether the expression is recalculated for the manual entry.

Select True to get new values for manual records, but not for automatic records.

For this property to be effective, set the CaptureValueForManualRecords property to True.

True, False

StringType

This property appears when DataType is set to String. It specifies the formatting type of the string data.

• PlainText - This option enables the user to enter plain text only.

• HyperLink - This option enables user to enter a linked Internet address.

For String Type, set the MaximumEditLength and VisibleRows properties under the Details Display category.

PlainText, HyperLink

Units

Any string value to use as the units in the display. Used for display purposes in AVEVA™ Production Management.

Any string value