Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/WOUF0132
Product: Manufacturing (346)
Series: 3rd Party
Display Name: Manufacture Order Reporting Options Group Display Name: Manufacturing MOP
Physical Name: WOUF0132
Technical Name: MOP_Report_Options
Group Technical Name: Manufacturing MOP
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | REPORTINDEX_I  | Report Index | DLR14 | Currency | 14 | |
| 2 | REPORTOPTION_I | Report Option | STR20 | String | 20 | |
| 3 | SORTBY | Sort By | DDL_Sort_By | Integer | 0 | |
| 4 | ASKECHTM | Ask Each Time | CB_Ask_Each_Time | Boolean | 0 | |
| 5 | INCLGNDS | Include Legends | CB_Include_Legends | Boolean | 0 | |
| 6 | PRNTOFIL | Print to File | CB_Print_to_File | Boolean | 0 | |
| 7 | PRTOPRTR | Print to Printer | CB_Print_to_Printer | Boolean | 0 | |
| 8 | PRTOSCRN | Print to Screen | CB_Print_to_Screen | Boolean | 0 | |
| 9 | IFFILXST | If File Existing | GB | Integer | 0 | |
| 10 | FILEXPNM | File Export Name | STR255 | String | 255 | |
| 11 | EXPTTYPE | Export Type | INT | Integer | 0 | |
| 12 | MANORDERSTART_I | Manufacture Order Start | STR30_UC | String | 30 | |
| 13 | MANORDEREND_I | Manufacture Order End | STR30_UC | String | 30 | |
| 14 | STTITNUM | Start Item Number | STR30_Item_Number | String | 30 | |
| 15 | ENITMNBR | End Item Number | STR30_Item_Number | String | 30 | |
| 16 | ROUTINGNAMESTART_I | RoutingName Start | STR30_Item_Number | String | 30 | |
| 17 | ROUTINGNAMEEND_I | RoutingName End | STR30_Item_Number | String | 30 | |
| 18 | STRTDATE | Start Date | DT | Date | 8 | |
| 19 | ENDDATE | End Date | DT | Date | 8 | |
| 20 | RTSEQNUMSTART_I | rtseqnum Start | STR10 | String | 10 | |
| 21 | RTSEQNUMEND_I | rtseqnum End | STR10 | String | 10 | |
| 22 | START_MO_DESCRIPTION | Start MO Description | STR30 | String | 30 | |
| 23 | END_MO_DESCRIPTION | End MO Description | STR30 | String | 30 | |
| 24 | Start_MO_Status | Start MO Status | DDL_WO_Status | Integer | 0 | |
| 25 | End_MO_Status | End MO Status | DDL_WO_Status | Integer | 0 | |
| 26 | STARTWCID_I | Start WC ID | STR10_Location_Code | String | 10 | |
| 27 | ENDWCID_I | End WC ID | STR10_Location_Code | String | 10 | |
| 28 | STRTMCID | Start Machine ID | STR10_Location_Code | String | 10 | |
| 29 | ENDMACID | End Machine ID | STR10_Location_Code | String | 10 | |
| 30 | Start_MRP_Issue_Date | Start MRP Issue Date | DATE | Date | 6 | |
| 31 | End_MRP_Issue_Date | End MRP Issue Date | DATE | Date | 6 | |
| 32 | STVNDRID | Start Vendor ID | STR15_LBU | String | 15 | |
| 33 | ENDVNDID | End Vendor ID | STR15_LBU | String | 15 | |
| 34 | START_PICK_NUMBER | Start Pick Number | STR17_LBAU | String | 17 | |
| 35 | END_PICK_NUMBER | End Pick Number | STR17_LBAU | String | 17 | |
| 36 | STTUSRID | Start User ID | STR15_User_ID | String | 15 | |
| 37 | ENDUSRID | End User ID | STR15_User_ID | String | 15 | |
| 38 | STARTMORECEIPTNUMBER | Start MO Receipt Number | STR20_LBAU | String | 20 | |
| 39 | ENDMORECEIPTNUMBER | End MO Receipt Number | STR20_LBAU | String | 20 | |
| 40 | RSRCID | Resource ID | STR30 | String | 30 | |
| 41 | CB_I | CB | CB | Boolean | 0 | |
| 42 | VIEWTYPE | View Type | INT | Integer | 0 | |
| 43 | QTYTYPE | QTY Type | DDL_QTY_Type | Integer | 0 | |
| 44 | CALCMTHD | Calculation Method | Calculation_Method | Integer | 0 | |
| 45 | DEX_ROW_ID | int | int | 10 | ||
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. | ||||||