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 TypeSQL DB LengthKeyable Length
1REPORTINDEX_I SearchReport IndexDLR14Currency1014
2REPORTOPTION_I SearchReport OptionSTR20String2220
3SORTBY SearchSort ByDDL_Sort_ByInteger20
4ASKECHTM SearchAsk Each TimeCB_Ask_Each_TimeBoolean20
5INCLGNDS SearchInclude LegendsCB_Include_LegendsBoolean20
6PRNTOFIL SearchPrint to FileCB_Print_to_FileBoolean20
7PRTOPRTR SearchPrint to PrinterCB_Print_to_PrinterBoolean20
8PRTOSCRN SearchPrint to ScreenCB_Print_to_ScreenBoolean20
9IFFILXST SearchIf File ExistingGBInteger20
10FILEXPNM SearchFile Export NameSTR255String256255
11EXPTTYPE SearchExport TypeINTInteger20
12MANORDERSTART_I SearchManufacture Order StartSTR30_UCString3230
13MANORDEREND_I SearchManufacture Order EndSTR30_UCString3230
14STTITNUM SearchStart Item NumberSTR30_Item_NumberString3230
15ENITMNBR SearchEnd Item NumberSTR30_Item_NumberString3230
16ROUTINGNAMESTART_I SearchRoutingName StartSTR30_Item_NumberString3230
17ROUTINGNAMEEND_I SearchRoutingName EndSTR30_Item_NumberString3230
18STRTDATE SearchStart DateDTDate48
19ENDDATE SearchEnd DateDTDate48
20RTSEQNUMSTART_I Searchrtseqnum StartSTR10String1210
21RTSEQNUMEND_I Searchrtseqnum EndSTR10String1210
22START_MO_DESCRIPTION SearchStart MO DescriptionSTR30String3230
23END_MO_DESCRIPTION SearchEnd MO DescriptionSTR30String3230
24Start_MO_Status SearchStart MO StatusDDL_WO_StatusInteger20
25End_MO_Status SearchEnd MO StatusDDL_WO_StatusInteger20
26STARTWCID_I SearchStart WC IDSTR10_Location_CodeString1210
27ENDWCID_I SearchEnd WC IDSTR10_Location_CodeString1210
28STRTMCID SearchStart Machine IDSTR10_Location_CodeString1210
29ENDMACID SearchEnd Machine IDSTR10_Location_CodeString1210
30Start_MRP_Issue_Date SearchStart MRP Issue DateDATEDate46
31End_MRP_Issue_Date SearchEnd MRP Issue DateDATEDate46
32STVNDRID SearchStart Vendor IDSTR15_LBUString1615
33ENDVNDID SearchEnd Vendor IDSTR15_LBUString1615
34START_PICK_NUMBER SearchStart Pick NumberSTR17_LBAUString1817
35END_PICK_NUMBER SearchEnd Pick NumberSTR17_LBAUString1817
36STTUSRID SearchStart User IDSTR15_User_IDString1615
37ENDUSRID SearchEnd User IDSTR15_User_IDString1615
38STARTMORECEIPTNUMBER SearchStart MO Receipt NumberSTR20_LBAUString2220
39ENDMORECEIPTNUMBER SearchEnd MO Receipt NumberSTR20_LBAUString2220
40RSRCID SearchResource IDSTR30String3230
41CB_I SearchCBCBBoolean20
42VIEWTYPE SearchView TypeINTInteger20
43QTYTYPE SearchQTY TypeDDL_QTY_TypeInteger20
44CALCMTHD SearchCalculation MethodCalculation_MethodInteger20
45DEX_ROW_ID Searchintint1010

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 *