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 TypeLength
1ORIGINGB SearchOrigins GBGBInteger0
2STRTYEAR SearchStart YearYearInteger4
3ENDYEAR SearchEnd YearYearInteger4
4STICID SearchStart Intercompany IDSTR5_IC_IDString5
5ENDICID SearchEnd Intercompany IDSTR5_IC_IDString5
6FINRPTNM SearchFinancial Report NameSTR30String30
7SJRNTPRT SearchShow Journals To PrintCB_Show_Journals_To_PrintBoolean0
8PRNTNOTS SearchPrint NotesCB_Print_NotesBoolean0
9PRNTTYPE SearchPrint TypeGBInteger0
10ASKECHTM SearchAsk Each TimeCB_Ask_Each_TimeBoolean0
11PRNTOFIL SearchPrint to FileCB_Print_to_FileBoolean0
12PRTOPRTR SearchPrint to PrinterCB_Print_to_PrinterBoolean0
13PRTOSCRN SearchPrint to ScreenCB_Print_to_ScreenBoolean0
14INCLGNDS SearchInclude LegendsCB_Include_LegendsBoolean0
15IFFILXST SearchIf File ExistingGBInteger0
16FILEXPNM SearchFile Export NameSTR255String255
17EXPTTYPE SearchExport TypeINTInteger0
18RPTGRIND SearchReport Group IndexINTInteger0
19RTPACHIN SearchReport Palette Choice IndexINTInteger0
20RTGRSBIN SearchReport Group Sub IndexDLR14Currency14
21SORTBY SearchSort ByDDL_Sort_ByInteger0
22STTLOCID SearchStart Location IDSTR15_Location_IDString15
23STTLOCNM SearchStart Location NameSTR30String30
24STADDCTT SearchStart Address ContactSTR60String60
25SSRCEDOC SearchStart Source DocumentSTR10_Source_DocumentString10
26SSDOCDSC SearchStart Source Document DescriptionSTR30String30
27STTSTATE SearchStart StateSTR30_StateString29
28STRTZPCD SearchStart Zip CodeSTR10String10
29STTFLSRS SearchStart File SeriesDDL_File_SeriesInteger0
30STARTSRS SearchStart SeriesDDL_SeriesInteger0
31STTRXSRC SearchStart Transaction SourceSTR25String25
32STTNOTNM SearchStart Note NameSTR45String45
33SRPTGRNM SearchStart Report Group NamesSTR20String20
34STTPALNM SearchStart Palette NameSTR30String30
35STTUSRID SearchStart User IDSTR15_User_IDString15
36STENDTYP SearchStart End TypeDDL_End_TypeInteger0
37STTCRDNM SearchStart Card NameSTR15_Card_NameString15
38STTPYTID SearchStart Payment Terms IDSTR20_Payment_Terms_IDString20
39STTSHMTH SearchStart Shipping MethodSTR15_Shipping_MethodString15
40SRTCOMSR SearchStart Comment SeriesComment SeriesInteger0
41SRTCOMID SearchStart Comment IDSTR15_Comment_IDString15
42ENDLOCID SearchEnd Location IDSTR15_Location_IDString15
43ENDLOCNM SearchEnd Location NameSTR30String30
44ENDADDCT SearchEnd Address ContactSTR60String60
45ENDSRCDC SearchEnd Source DocumentSTR10_Source_DocumentString10
46ENDSDDSC SearchEnd Source Document DescriptionSTR30String30
47ENDSTATE SearchEnd StateSTR30_StateString29
48ENDZIPCD SearchEnd Zip CodeSTR10String10
49ENDFLSRS SearchEnd File SeriesDDL_File_SeriesInteger0
50ENDSERIS SearchEnd SeriesDDL_SeriesInteger0
51ENDTRXSR SearchEnd Transaction SourceSTR25String25
52ENDNOTNM SearchEnd Note NameSTR45String45
53ENDRPGNM SearchEnd Report Group NamesSTR20String20
54ENDPALNM SearchEnd Palette NameSTR30String30
55ENDUSRID SearchEnd User IDSTR15_User_IDString15
56ENDENDTY SearchEnd End TypeDDL_End_TypeInteger0
57ENDCRDNM SearchEnd Card NameSTR15_Card_NameString15
58ENDPYTID SearchEnd Payment Terms IDSTR20_Payment_Terms_IDString20
59ENDSHMTH SearchEnd Shipping MethodSTR15_Shipping_MethodString15
60ENDCOMID SearchEnd Comment IDSTR15_Comment_IDString15
61ENDCOMSR SearchEnd Comment SeriesComment SeriesInteger0
62ENDNAME SearchEnd NameSTR64String64
63ENDID SearchEnd IDSTR15_LBAUString15
64STARTID SearchStart IDSTR15_LBAUString15
65STRTNAME SearchStart NameSTR64String64
66STRTCITY SearchStart CitySTR35String35
67ENDCITY SearchEnd CitySTR35String35
68ENDCNTRY SearchEnd CountrySTR60String60
69STTCNTRY SearchStart CountrySTR60String60
70LBLFRMAT SearchLabel FormatGBInteger0
71NUMOCPIS SearchNumber of CopiesINT3_U0Integer3
72NUMACROS SearchNumber AcrossDDLInteger0
73INCADADR SearchInclude Additional AddressesCB_Include_Additional_AddressesBoolean0
74INCCNTCT SearchInclude ContactCB_Include_ContactBoolean0
75FRCEUPCS SearchForce UppercaseCB_Force_UppercaseBoolean0
76YEAR1 SearchYearYearInteger4
77PRNTDTLD SearchPrint Detailed CBBoolean0
78ENTXDDSC SearchEnd Tax Detail DescriptionSTR30String30
79ETXDTLID SearchEnd Tax Detail IDSTR15_LBAUString15
80ETXSCHDS SearchEnd Tax Schedule DescriptionSTR30String30
81ETXSCHID SearchEnd Tax Schedule IDSTR15_LBAUString15
82STTXDDSC SearchStart Tax Detail DescriptionSTR30String30
83STTXDTID SearchStart Tax Detail IDSTR15_LBAUString15
84STXSCDSC SearchStart Tax Schedule DescriptionSTR30String30
85STXSCHID SearchStart Tax Schedule IDSTR15_LBAUString15
86ENDPEROD SearchEnd PeriodINT_STORAGEInteger0
87STPERIOD SearchStart PeriodINT_STORAGEInteger0
88STDTLTYP SearchStart Detail TypeDDL_Tax_Detail_TypeInteger0
89ENDETTYP SearchEnd Detail TypeDDL_Tax_Detail_TypeInteger0
90STXIDNUM SearchStart Tax ID NumberSTR15String15
91ETXIDNBR SearchEnd Tax ID NumberSTR15String15
92HISTTYPE SearchHistory TypeGBInteger0
93STBCHNUM SearchStart Batch NumberSTR15_LBAUString15
94STRTDATE SearchStart DateDTDate8
95STDOCNUM SearchStart Document NumberSTR20String20
96ENDBNMBR SearchEnd Batch NumberSTR15_LBAUString15
97ENDOCNUM SearchEnd Document NumberSTR20String20
98ENDDATE SearchEnd DateDTDate8
99PRNSHPTO SearchPrint Ship to AddressCB_Print_Ship_To_AddressesBoolean0
100PRTBLLTO SearchPrint Bill to AddressCB_Print_Bill_To_AddressBoolean0
101ARVLDEPART SearchArrival/Departure GBGBInteger0
102STCUSTID SearchStart Customer IDSTR15_RM_Customer_NumberString15
103ENCUSTID SearchEnd Customer IDSTR15_RM_Customer_NumberString15
104STSOPTYP SearchStart SOP TypeDDL_SOP_TypeInteger0
105EDSOPTYP SearchEnd SOP TypeDDL_SOP_TypeInteger0
106UPSIDNBR SearchUPS Identification NumberSTR15String15
107STTDOCDT SearchStart Document DateDTDate8
108ENDDOCDT SearchEnd Document DateDTDate8
109STDOCTYP SearchStart Document TypeINT1Integer1
110ENDOCTYP SearchEnd Document TypeINT1Integer1
111STVNDRID SearchStart Vendor IDSTR15_LBUString15
112ENDVNDID SearchEnd Vendor IDSTR15_LBUString15
113STRMTKDT SearchStart RM Token DateDDL_RM_Token_DatesInteger0
114ENRMTKDT SearchEnd RM Token DateDDL_RM_Token_DatesInteger0
115STTXUSR1 SearchStart Tax User Defined 1Tax User Defined1String20
116ENTXUSR1 SearchEnd Tax User Defined 1Tax User Defined1String20
117STTOKNDT SearchStart Token DateDDL_Start_DatesInteger0
118ENDTKNDT SearchEnd Token DateDDL_End_DatesInteger0
119STTXPYDT SearchStart Tax Payment DateDTDate8
120ENTXPYDT SearchEnd Tax Payment DateDTDate8
121STTPSTDT SearchStart Post DateDATEDate6
122ENDPSTDT SearchEnd Post DateDATEDate6
123STGENINT1 SearchStart Generic Integer1INTInteger0
124STDECLID SearchStart Declarant IDSTR15_Address_CodeString15
125ENDDECLID SearchEnd Declarant IDSTR15_Address_CodeString15
126STINTRSTTRTRNID SearchStart Intrastat Return IDSTR20_LBAUString20
127ENDINTRSTTRTRNID SearchEnd Intrastat Return IDSTR20_LBAUString20
128STTCC SearchStart Tax Commodity CodeSTR30_VATString30
129ENDTCC SearchEnd Tax Commodity CodeSTR30_VATString30
130STTXRGNNUM SearchStart Tax Registration NumberSTR25String25
131ENDTXRGNNUM SearchEnd Tax Registration NumberSTR25String25
132STRTAMNT SearchStart AmountDLR17_RBSO_STR$Currency17
133ENDAMNT SearchEnd AmountDLR17_RBSO_STR$Currency17
134GROUPBOX SearchGroup BoxGBInteger0
135GROUPBX2 SearchGroup Box 2GBInteger0
136EXCLVOID SearchExclude VoidedCB_Exclude_VoidedBoolean0
137PRNTCSV SearchPrint CSVCBBoolean0
138DEX_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 *