Manufacture Order Reporting Options (WOUF0132)

azurecurveProductsManufacturing (346)3rd PartyManufacture Order Reporting Options (WOUF0132)

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
Physical Name: WOUF0132
Technical Name: MOP_Report_Options

Group Display Name: Manufacturing MOP
Group Technical Name: Manufacturing MOP

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1REPORTINDEX_I SearchReport IndexDLR14Currency14
2REPORTOPTION_I SearchReport OptionSTR20String20
3SORTBY SearchSort ByDDL_Sort_ByInteger0
4ASKECHTM SearchAsk Each TimeCB_Ask_Each_TimeBoolean0
5INCLGNDS SearchInclude LegendsCB_Include_LegendsBoolean0
6PRNTOFIL SearchPrint to FileCB_Print_to_FileBoolean0
7PRTOPRTR SearchPrint to PrinterCB_Print_to_PrinterBoolean0
8PRTOSCRN SearchPrint to ScreenCB_Print_to_ScreenBoolean0
9IFFILXST SearchIf File ExistingGBInteger0
10FILEXPNM SearchFile Export NameSTR255String255
11EXPTTYPE SearchExport TypeINTInteger0
12MANORDERSTART_I SearchManufacture Order StartSTR30_UCString30
13MANORDEREND_I SearchManufacture Order EndSTR30_UCString30
14STTITNUM SearchStart Item NumberSTR30_Item_NumberString30
15ENITMNBR SearchEnd Item NumberSTR30_Item_NumberString30
16ROUTINGNAMESTART_I SearchRoutingName StartSTR30_Item_NumberString30
17ROUTINGNAMEEND_I SearchRoutingName EndSTR30_Item_NumberString30
18STRTDATE SearchStart DateDTDate8
19ENDDATE SearchEnd DateDTDate8
20RTSEQNUMSTART_I Searchrtseqnum StartSTR10String10
21RTSEQNUMEND_I Searchrtseqnum EndSTR10String10
22START_MO_DESCRIPTION SearchStart MO DescriptionSTR30String30
23END_MO_DESCRIPTION SearchEnd MO DescriptionSTR30String30
24Start_MO_Status SearchStart MO StatusDDL_WO_StatusInteger0
25End_MO_Status SearchEnd MO StatusDDL_WO_StatusInteger0
26STARTWCID_I SearchStart WC IDSTR10_Location_CodeString10
27ENDWCID_I SearchEnd WC IDSTR10_Location_CodeString10
28STRTMCID SearchStart Machine IDSTR10_Location_CodeString10
29ENDMACID SearchEnd Machine IDSTR10_Location_CodeString10
30Start_MRP_Issue_Date SearchStart MRP Issue DateDATEDate6
31End_MRP_Issue_Date SearchEnd MRP Issue DateDATEDate6
32STVNDRID SearchStart Vendor IDSTR15_LBUString15
33ENDVNDID SearchEnd Vendor IDSTR15_LBUString15
34START_PICK_NUMBER SearchStart Pick NumberSTR17_LBAUString17
35END_PICK_NUMBER SearchEnd Pick NumberSTR17_LBAUString17
36STTUSRID SearchStart User IDSTR15_User_IDString15
37ENDUSRID SearchEnd User IDSTR15_User_IDString15
38STARTMORECEIPTNUMBER SearchStart MO Receipt NumberSTR20_LBAUString20
39ENDMORECEIPTNUMBER SearchEnd MO Receipt NumberSTR20_LBAUString20
40RSRCID SearchResource IDSTR30String30
41CB_I SearchCBCBBoolean0
42VIEWTYPE SearchView TypeINTInteger0
43QTYTYPE SearchQTY TypeDDL_QTY_TypeInteger0
44CALCMTHD SearchCalculation MethodCalculation_MethodInteger0
45DEX_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 PartyManufacture Order Reporting Options (WOUF0132)

Leave a Reply

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