Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ Work Tasks Extension and Connector for MES 7​.1

Sample add job test data and expected results

  • Last UpdatedJan 21, 2026
  • 1 minute read

Two sets of sample test data that could be entered in the form, and the expected results in the MES database, are listed in the following tables.

Control Name

Database Data Type

Data Input

Data Expected
in MES Database

Wo_ID

String80

Wo1

Wo1

Oper_Id

String80

Oper1

Oper1

Seq_No

Int32

12345

12345

Req_Finish_Time_Local

TDatetime

10/26/2012 15:16:17

10/26/2012 15:16:17

Init_Sched_Ent_Id

Int32

15

15

Target_Sched_Ent_Id

Int32

15

15

Qty_Reqd

TFloat

1234567890123.12345

1234567890123.12

Qty_At_Start

TFloat

1234567890123.12345

1234567890123.12

Rework

Logical

No (False)

False

Spare1

String80

Test Spare1

Test Spare1

Last_Edit_Comment

String254

Test Last Edit Comment

Test Last Edit Comment

Item

String80

QA-Case24

QA-Case24

Est_Prod_Rate

TFloat

1234567890123.12345

1234567890123.12

Column Name

Database Data Type

Data Input

Data Expected in MES Database

Wo_ID

String80

Wo1

Wo1

Oper_Id

String80

Oper2

Oper2

Seq_No

Int32

12345

12345

Req_Finish_Time_Local

TDatetime

10/29/2012 18:19:20

10/29/2012 18:19:20

Init_Sched_Ent_Id

Int32

15

15

Target_Sched_Ent_Id

Int32

15

15

Qty_Reqd

TFloat

987654321.987654

987654321.987654

Qty_At_Start

TFloat

987654321.987654

987654321.987654

Rework

Logical

Yes (True)

True

Spare1

String80

Test Spare1

Test Spare1

Last_Edit_Comment

String254

Test Last Edit Comment

Test Last Edit Comment

Item

String80

QA-Case24

QA-Case24

Est_Prod_Rate

TFloat

987654321.987654

987654321.987654

TitleResults for “How to create a CRG?”Also Available in