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 TypeLength
1REPORTOPTION_I SearchReport OptionSTR20String20
2REPORTINDEX_I SearchReport IndexDLR14Currency14
3ASKECHTM SearchAsk Each TimeCB_Ask_Each_TimeBoolean0
4SORTBY_I SearchsortbySTR_30String30
5TEXTREPTS_I SearchtextreptsCBBoolean0
6INCLGNDS SearchInclude LegendsCB_Include_LegendsBoolean0
7PRNTOFIL SearchPrint to FileCB_Print_to_FileBoolean0
8PRTOPRTR SearchPrint to PrinterCB_Print_to_PrinterBoolean0
9PRTOSCRN SearchPrint to ScreenCB_Print_to_ScreenBoolean0
10IFFILXST SearchIf File ExistingGBInteger0
11FILEXPNM SearchFile Export NameSTR255String255
12EXPTTYPE SearchExport TypeINTInteger0
13STARTPLANNAME_I SearchStart Plan NameSTR15String15
14ENDPLANNAME_I SearchEnd Plan NameSTR15String15
15STPLANDESC_I SearchStart Plan DescriptionSTR30String30
16ENDPLANDESCRIPTION_I SearchEnd Plan DescriptionSTR30String30
17STARTPLANSTARTDATE_I SearchStart Plan Start DateDateDate6
18ENDPLANSTARTDATE_I SearchEnd Plan Start DateDateDate6
19STARTPLANSPAN_I SearchStart Plan SpanDDL_Plan_SpanInteger0
20ENDPLANSPAN_I SearchEnd Plan SpanDDL_Plan_SpanInteger0
21STTUSRID SearchStart User IDSTR15_User_IDString15
22ENDUSRID SearchEnd User IDSTR15_User_IDString15
23STARTSFPLANNAME_I SearchStart SF Plan NameSTR15String15
24ENDSFPLANNAME_I SearchEnd SF Plan NameSTR15String15
25SYSDATEPLUS_I SearchsysdateplusINT5Integer4
26SYSDATEMINUS_I SearchsysdateminusINT5Integer4
27RSRCID SearchResource IDSTR30String30
28DEX_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.

Leave a Reply

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