System Report Options (SY70500)

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

Product: Microsoft Dynamics GP (0)
Series: Company

Display Name: System Report Options
Physical Name: SY70500
Technical Name: SY_Options_ROPT

Group Display Name: System Report Options
Group Technical Name: System Report Options

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1STDPSSRS SearchStart DPS SeriesDDL_DPS_SeriesInteger20
2ENDPSERS SearchEnd DPS SeriesDDL_DPS_SeriesInteger20
3STSERVID SearchStart Server IDSTR80String8280
4ENDSRVID SearchEnd Server IDSTR80String8280
5FINRPTNM SearchFinancial Report NameSTR30String3230
6PRNTNOTS SearchPrint NotesCB_Print_NotesBoolean20
7PRNTTYPE SearchPrint TypeGBInteger20
8STRTCMNM SearchStart Company NameSTR64_Company_NameString6664
9STRTZPCD SearchStart Zip CodeSTR10String1210
10STWSTNTY SearchStart Work Station TypeSTR15_LBAUString1615
11STTCATEG SearchStart CategoryINT2_U0Integer22
12ENDCATEG SearchEnd CategoryINT2_U0Integer22
13ENDCMPNM SearchEnd Company NameSTR64_Company_NameString6664
14ENDZIPCD SearchEnd Zip CodeSTR10String1210
15ENDWSTYP SearchEnd Work Station TypeSTR15_LBAUString1615
16ASKECHTM SearchAsk Each TimeCB_Ask_Each_TimeBoolean20
17INCLGNDS SearchInclude LegendsCB_Include_LegendsBoolean20
18PRNTOFIL SearchPrint to FileCB_Print_to_FileBoolean20
19PRTOPRTR SearchPrint to PrinterCB_Print_to_PrinterBoolean20
20PRTOSCRN SearchPrint to ScreenCB_Print_to_ScreenBoolean20
21IFFILXST SearchIf File ExistingGBInteger20
22FILEXPNM SearchFile Export NameSTR255String256255
23EXPTTYPE SearchExport TypeINTInteger20
24RPTGRIND SearchReport Group IndexINTInteger20
25RTPACHIN SearchReport Palette Choice IndexINTInteger20
26RTGRSBIN SearchReport Group Sub IndexDLR14Currency1014
27SORTBY SearchSort ByDDL_Sort_ByInteger20
28RPTYPSEC SearchReport Type SecurityGBInteger20
29ENDUSRID SearchEnd User IDSTR15_User_IDString1615
30ENDUSRNM SearchEnd User NameSTR30String3230
31ENDUSRCL SearchEnd User ClassSTR15_User_ClassString1615
32ENDINGDT SearchEnding DateDTDate48
33ENDTKNDT SearchEnd Token DateDDL_End_DatesInteger20
34ENDFRSRS SearchEnd Form SeriesDDL_Form_Series_W_SMInteger20
35STTUSRID SearchStart User IDSTR15_User_IDString1615
36STTUSRNM SearchStart User NameSTR30String3230
37STTUSRCL SearchStart User ClassSTR15_User_ClassString1615
38STRTNGDT SearchStarting DateDTDate48
39STTOKNDT SearchStart Token DateDDL_Start_DatesInteger20
40STTFMSRS SearchStart Form SeriesDDL_Form_Series_W_SMInteger20
41STCURRID SearchStart Currency IDSTR15_Currency_IDString1615
42ENDCURID SearchEnd Currency IDSTR15_Currency_IDString1615
43STCURRDESC SearchStart Currency DescriptionSTR30_Currency_DescriptionString3230
44ENDCURRDESC SearchEnd Currency DescriptionSTR30_Currency_DescriptionString3230
45STEXTABID SearchStart Exchange Table IDSTR15_Exchange_Table_IDString1615
46ENDEXTABID SearchEnd Exchange Table IDSTR15_Exchange_Table_IDString1615
47STEXTABDESC SearchStart Exchange Table DescriptionSTR30_Exchange_Table_DescriptionString3230
48ENDEXTABDESC SearchEnd Exchange Table DescriptionSTR30_Exchange_Table_DescriptionString3230
49STICID SearchStart Intercompany IDSTR5_IC_IDString65
50ENDICID SearchEnd Intercompany IDSTR5_IC_IDString65
51STSECMODALTID SearchStart Security ModAlt Forms IDSecurityIDString2625
52STSECROLEID SearchStart Security Role IDSecurityIDString2625
53STSECTASKCAT SearchStart Security Task CategorySecurity Task CategoryInteger20
54STSECTASKID SearchStart Security Task IDSecurityIDString2625
55ENDSECMODALTID SearchEnd Security ModAlt Forms IDSecurityIDString2625
56ENDSECROLEID SearchEnd Security Role IDSecurityIDString2625
57ENDSECTASKCAT SearchEnd Security Task CategorySecurity Task CategoryInteger20
58ENDSECTASKID SearchEnd Security Task IDSecurityIDString2625
59IncludeInactiveUsers SearchIncludeInactiveUsersIncludeInactiveUsersCBBoolean20
60DEX_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 *