Company Report Options (SY70501)

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

Product: Microsoft Dynamics GP (0)
Series: Company

Display Name: Company Report Options
Physical Name: SY70501
Technical Name: SY_Comp_Options_ROPT

Group Display Name: Company Report Options
Group Technical Name: Company Report Options

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1ORIGINGB SearchOrigins GBGBInteger20
2STRTYEAR SearchStart YearYearInteger24
3ENDYEAR SearchEnd YearYearInteger24
4STICID SearchStart Intercompany IDSTR5_IC_IDString65
5ENDICID SearchEnd Intercompany IDSTR5_IC_IDString65
6FINRPTNM SearchFinancial Report NameSTR30String3230
7SJRNTPRT SearchShow Journals To PrintCB_Show_Journals_To_PrintBoolean20
8PRNTNOTS SearchPrint NotesCB_Print_NotesBoolean20
9PRNTTYPE SearchPrint TypeGBInteger20
10ASKECHTM SearchAsk Each TimeCB_Ask_Each_TimeBoolean20
11PRNTOFIL SearchPrint to FileCB_Print_to_FileBoolean20
12PRTOPRTR SearchPrint to PrinterCB_Print_to_PrinterBoolean20
13PRTOSCRN SearchPrint to ScreenCB_Print_to_ScreenBoolean20
14INCLGNDS SearchInclude LegendsCB_Include_LegendsBoolean20
15IFFILXST SearchIf File ExistingGBInteger20
16FILEXPNM SearchFile Export NameSTR255String256255
17EXPTTYPE SearchExport TypeINTInteger20
18RPTGRIND SearchReport Group IndexINTInteger20
19RTPACHIN SearchReport Palette Choice IndexINTInteger20
20RTGRSBIN SearchReport Group Sub IndexDLR14Currency1014
21SORTBY SearchSort ByDDL_Sort_ByInteger20
22STTLOCID SearchStart Location IDSTR15_Location_IDString1615
23STTLOCNM SearchStart Location NameSTR30String3230
24STADDCTT SearchStart Address ContactSTR60String6260
25SSRCEDOC SearchStart Source DocumentSTR10_Source_DocumentString1210
26SSDOCDSC SearchStart Source Document DescriptionSTR30String3230
27STTSTATE SearchStart StateSTR30_StateString3029
28STRTZPCD SearchStart Zip CodeSTR10String1210
29STTFLSRS SearchStart File SeriesDDL_File_SeriesInteger20
30STARTSRS SearchStart SeriesDDL_SeriesInteger20
31STTRXSRC SearchStart Transaction SourceSTR25String2625
32STTNOTNM SearchStart Note NameSTR45String4645
33SRPTGRNM SearchStart Report Group NamesSTR20String2220
34STTPALNM SearchStart Palette NameSTR30String3230
35STTUSRID SearchStart User IDSTR15_User_IDString1615
36STENDTYP SearchStart End TypeDDL_End_TypeInteger20
37STTCRDNM SearchStart Card NameSTR15_Card_NameString1615
38STTPYTID SearchStart Payment Terms IDSTR20_Payment_Terms_IDString2220
39STTSHMTH SearchStart Shipping MethodSTR15_Shipping_MethodString1615
40SRTCOMSR SearchStart Comment SeriesComment SeriesInteger20
41SRTCOMID SearchStart Comment IDSTR15_Comment_IDString1615
42ENDLOCID SearchEnd Location IDSTR15_Location_IDString1615
43ENDLOCNM SearchEnd Location NameSTR30String3230
44ENDADDCT SearchEnd Address ContactSTR60String6260
45ENDSRCDC SearchEnd Source DocumentSTR10_Source_DocumentString1210
46ENDSDDSC SearchEnd Source Document DescriptionSTR30String3230
47ENDSTATE SearchEnd StateSTR30_StateString3029
48ENDZIPCD SearchEnd Zip CodeSTR10String1210
49ENDFLSRS SearchEnd File SeriesDDL_File_SeriesInteger20
50ENDSERIS SearchEnd SeriesDDL_SeriesInteger20
51ENDTRXSR SearchEnd Transaction SourceSTR25String2625
52ENDNOTNM SearchEnd Note NameSTR45String4645
53ENDRPGNM SearchEnd Report Group NamesSTR20String2220
54ENDPALNM SearchEnd Palette NameSTR30String3230
55ENDUSRID SearchEnd User IDSTR15_User_IDString1615
56ENDENDTY SearchEnd End TypeDDL_End_TypeInteger20
57ENDCRDNM SearchEnd Card NameSTR15_Card_NameString1615
58ENDPYTID SearchEnd Payment Terms IDSTR20_Payment_Terms_IDString2220
59ENDSHMTH SearchEnd Shipping MethodSTR15_Shipping_MethodString1615
60ENDCOMID SearchEnd Comment IDSTR15_Comment_IDString1615
61ENDCOMSR SearchEnd Comment SeriesComment SeriesInteger20
62ENDNAME SearchEnd NameSTR64String6664
63ENDID SearchEnd IDSTR15_LBAUString1615
64STARTID SearchStart IDSTR15_LBAUString1615
65STRTNAME SearchStart NameSTR64String6664
66STRTCITY SearchStart CitySTR35String3635
67ENDCITY SearchEnd CitySTR35String3635
68ENDCNTRY SearchEnd CountrySTR60String6260
69STTCNTRY SearchStart CountrySTR60String6260
70LBLFRMAT SearchLabel FormatGBInteger20
71NUMOCPIS SearchNumber of CopiesINT3_U0Integer23
72NUMACROS SearchNumber AcrossDDLInteger20
73INCADADR SearchInclude Additional AddressesCB_Include_Additional_AddressesBoolean20
74INCCNTCT SearchInclude ContactCB_Include_ContactBoolean20
75FRCEUPCS SearchForce UppercaseCB_Force_UppercaseBoolean20
76YEAR1 SearchYearYearInteger24
77PRNTDTLD SearchPrint Detailed CBBoolean20
78ENTXDDSC SearchEnd Tax Detail DescriptionSTR30String3230
79ETXDTLID SearchEnd Tax Detail IDSTR15_LBAUString1615
80ETXSCHDS SearchEnd Tax Schedule DescriptionSTR30String3230
81ETXSCHID SearchEnd Tax Schedule IDSTR15_LBAUString1615
82STTXDDSC SearchStart Tax Detail DescriptionSTR30String3230
83STTXDTID SearchStart Tax Detail IDSTR15_LBAUString1615
84STXSCDSC SearchStart Tax Schedule DescriptionSTR30String3230
85STXSCHID SearchStart Tax Schedule IDSTR15_LBAUString1615
86ENDPEROD SearchEnd PeriodINT_STORAGEInteger20
87STPERIOD SearchStart PeriodINT_STORAGEInteger20
88STDTLTYP SearchStart Detail TypeDDL_Tax_Detail_TypeInteger20
89ENDETTYP SearchEnd Detail TypeDDL_Tax_Detail_TypeInteger20
90STXIDNUM SearchStart Tax ID NumberSTR15String1615
91ETXIDNBR SearchEnd Tax ID NumberSTR15String1615
92HISTTYPE SearchHistory TypeGBInteger20
93STBCHNUM SearchStart Batch NumberSTR15_LBAUString1615
94STRTDATE SearchStart DateDTDate48
95STDOCNUM SearchStart Document NumberSTR20String2220
96ENDBNMBR SearchEnd Batch NumberSTR15_LBAUString1615
97ENDOCNUM SearchEnd Document NumberSTR20String2220
98ENDDATE SearchEnd DateDTDate48
99PRNSHPTO SearchPrint Ship to AddressCB_Print_Ship_To_AddressesBoolean20
100PRTBLLTO SearchPrint Bill to AddressCB_Print_Bill_To_AddressBoolean20
101ARVLDEPART SearchArrival/Departure GBGBInteger20
102STCUSTID SearchStart Customer IDSTR15_RM_Customer_NumberString1615
103ENCUSTID SearchEnd Customer IDSTR15_RM_Customer_NumberString1615
104STSOPTYP SearchStart SOP TypeDDL_SOP_TypeInteger20
105EDSOPTYP SearchEnd SOP TypeDDL_SOP_TypeInteger20
106UPSIDNBR SearchUPS Identification NumberSTR15String1615
107STTDOCDT SearchStart Document DateDTDate48
108ENDDOCDT SearchEnd Document DateDTDate48
109STDOCTYP SearchStart Document TypeINT1Integer21
110ENDOCTYP SearchEnd Document TypeINT1Integer21
111STVNDRID SearchStart Vendor IDSTR15_LBUString1615
112ENDVNDID SearchEnd Vendor IDSTR15_LBUString1615
113STRMTKDT SearchStart RM Token DateDDL_RM_Token_DatesInteger20
114ENRMTKDT SearchEnd RM Token DateDDL_RM_Token_DatesInteger20
115STTXUSR1 SearchStart Tax User Defined 1Tax User Defined1String2220
116ENTXUSR1 SearchEnd Tax User Defined 1Tax User Defined1String2220
117STTOKNDT SearchStart Token DateDDL_Start_DatesInteger20
118ENDTKNDT SearchEnd Token DateDDL_End_DatesInteger20
119STTXPYDT SearchStart Tax Payment DateDTDate48
120ENTXPYDT SearchEnd Tax Payment DateDTDate48
121STTPSTDT SearchStart Post DateDATEDate46
122ENDPSTDT SearchEnd Post DateDATEDate46
123STGENINT1 SearchStart Generic Integer1INTInteger20
124STDECLID SearchStart Declarant IDSTR15_Address_CodeString1615
125ENDDECLID SearchEnd Declarant IDSTR15_Address_CodeString1615
126STINTRSTTRTRNID SearchStart Intrastat Return IDSTR20_LBAUString2220
127ENDINTRSTTRTRNID SearchEnd Intrastat Return IDSTR20_LBAUString2220
128STTCC SearchStart Tax Commodity CodeSTR30_VATString3230
129ENDTCC SearchEnd Tax Commodity CodeSTR30_VATString3230
130STTXRGNNUM SearchStart Tax Registration NumberSTR25String2625
131ENDTXRGNNUM SearchEnd Tax Registration NumberSTR25String2625
132STRTAMNT SearchStart AmountDLR17_RBSO_STR$Currency1017
133ENDAMNT SearchEnd AmountDLR17_RBSO_STR$Currency1017
134GROUPBOX SearchGroup BoxGBInteger20
135GROUPBX2 SearchGroup Box 2GBInteger20
136EXCLVOID SearchExclude VoidedCB_Exclude_VoidedBoolean20
137PRNTCSV SearchPrint CSVCBBoolean20
138DEX_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 *