MF_Report_Options (MFUF0101)

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

Product: Manufacturing (346)
Series: 3rd Party

Display Name: MF_Report_Options
Physical Name: MFUF0101
Technical Name: MF_Report_Options

Group Display Name: Manufacturing MPS
Group Technical Name: Manufacturing MPS

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1REPORTOPTION_I SearchReport OptionSTR20String2220
2REPORTINDEX_I SearchReport IndexDLR14Currency1014
3ASKECHTM SearchAsk Each TimeCB_Ask_Each_TimeBoolean20
4SORTBY_I SearchsortbySTR_30String3230
5TEXTREPTS_I SearchtextreptsCBBoolean20
6INCLGNDS SearchInclude LegendsCB_Include_LegendsBoolean20
7PRNTOFIL SearchPrint to FileCB_Print_to_FileBoolean20
8PRTOPRTR SearchPrint to PrinterCB_Print_to_PrinterBoolean20
9PRTOSCRN SearchPrint to ScreenCB_Print_to_ScreenBoolean20
10IFFILXST SearchIf File ExistingGBInteger20
11FILEXPNM SearchFile Export NameSTR255String256255
12EXPTTYPE SearchExport TypeINTInteger20
13STARTPLANNAME_I SearchStart Plan NameSTR15String1615
14ENDPLANNAME_I SearchEnd Plan NameSTR15String1615
15STPLANDESC_I SearchStart Plan DescriptionSTR30String3230
16ENDPLANDESCRIPTION_I SearchEnd Plan DescriptionSTR30String3230
17STARTPLANSTARTDATE_I SearchStart Plan Start DateDateDate46
18ENDPLANSTARTDATE_I SearchEnd Plan Start DateDateDate46
19STARTPLANSPAN_I SearchStart Plan SpanDDL_Plan_SpanInteger20
20ENDPLANSPAN_I SearchEnd Plan SpanDDL_Plan_SpanInteger20
21STTUSRID SearchStart User IDSTR15_User_IDString1615
22ENDUSRID SearchEnd User IDSTR15_User_IDString1615
23STARTSFPLANNAME_I SearchStart SF Plan NameSTR15String1615
24ENDSFPLANNAME_I SearchEnd SF Plan NameSTR15String1615
25SYSDATEPLUS_I SearchsysdateplusINT5Integer24
26SYSDATEMINUS_I SearchsysdateminusINT5Integer24
27RSRCID SearchResource IDSTR30String3230
28DEX_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.

Leave a Reply

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