SF_Report_Options (SCUF0101)

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

Product: Manufacturing (346)
Series: 3rd Party

Display Name: SF_Report_Options
Physical Name: SCUF0101
Technical Name: SF_Report_Options

Group Display Name: Manufacturing Sales Fcst.
Group Technical Name: Manufacturing SFC

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
23STTLOCCD SearchStart Location CodeSTR10_Location_CodeString1210
24ENLOCNCD SearchEnd Location CodeSTR10_Location_CodeString1210
25STFORECASTSTDT_I SearchStart Forecast Start DateDateDate46
26ENDFORECASTSTDT_I SearchEnd Forecast Start DateDateDate46
27SYSDATEPLUS_I SearchsysdateplusINT5Integer24
28SYSDATEMINUS_I SearchsysdateminusINT5Integer24
29RSRCID SearchResource IDSTR30String3230
30DEX_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 *