MOP_Sched_Interface_Report_Before (MOS03000)

azurecurveProductsManufacturing (346)3rd PartyMOP_Sched_Interface_Report_Before (MOS03000)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/MOS03000

Product: Manufacturing (346)
Series: 3rd Party

Display Name: MOP_Sched_Interface_Report_Before
Physical Name: MOS03000
Technical Name: MOP_Sched_Interface_Report_Before

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1MANUFACTUREORDER_I SearchManufacture OrderSTR30_UCString30
2STRTDATE SearchStart DateDTDate8
3STARTTIME_I SearchStart Time_ICTM6Time6
4ENDDATE SearchEnd DateDTDate8
5RTSEQNUM_I SearchrtseqnumSTR10String10
6SCHEDULESTARTDATE_I SearchScheduleStartDateDATEDate6
7SCHEDULESTARTTIME_I SearchScheduleStartTimeTMTime6
8SCHEDULEFINISHDATE_I SearchScheduleFinishDateDATEDate6
9WCID_I SearchWC IDSTR10_Location_CodeString10
10Machine_ID SearchMachine IDSTR15_Machine_IDString15
11DEX_ROW_ID Searchintint10

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurveProductsManufacturing (346)3rd PartyMOP_Sched_Interface_Report_Before (MOS03000)

Leave a Reply

Your email address will not be published. Required fields are marked *