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 GBIntegerGB0
2STRTYEAR SearchStart YearIntegerYear4
3ENDYEAR SearchEnd YearIntegerYear4
4STICID SearchStart Intercompany IDStringSTR5_IC_ID5
5ENDICID SearchEnd Intercompany IDStringSTR5_IC_ID5
6FINRPTNM SearchFinancial Report NameStringSTR3030
7SJRNTPRT SearchShow Journals To PrintBooleanCB_Show_Journals_To_Print0
8PRNTNOTS SearchPrint NotesBooleanCB_Print_Notes0
9PRNTTYPE SearchPrint TypeIntegerGB0
10ASKECHTM SearchAsk Each TimeBooleanCB_Ask_Each_Time0
11PRNTOFIL SearchPrint to FileBooleanCB_Print_to_File0
12PRTOPRTR SearchPrint to PrinterBooleanCB_Print_to_Printer0
13PRTOSCRN SearchPrint to ScreenBooleanCB_Print_to_Screen0
14INCLGNDS SearchInclude LegendsBooleanCB_Include_Legends0
15IFFILXST SearchIf File ExistingIntegerGB0
16FILEXPNM SearchFile Export NameStringSTR255255
17EXPTTYPE SearchExport TypeIntegerINT0
18RPTGRIND SearchReport Group IndexIntegerINT0
19RTPACHIN SearchReport Palette Choice IndexIntegerINT0
20RTGRSBIN SearchReport Group Sub IndexCurrencyDLR1414
21SORTBY SearchSort ByIntegerDDL_Sort_By0
22STTLOCID SearchStart Location IDStringSTR15_Location_ID15
23STTLOCNM SearchStart Location NameStringSTR3030
24STADDCTT SearchStart Address ContactStringSTR6060
25SSRCEDOC SearchStart Source DocumentStringSTR10_Source_Document10
26SSDOCDSC SearchStart Source Document DescriptionStringSTR3030
27STTSTATE SearchStart StateStringSTR30_State29
28STRTZPCD SearchStart Zip CodeStringSTR1010
29STTFLSRS SearchStart File SeriesIntegerDDL_File_Series0
30STARTSRS SearchStart SeriesIntegerDDL_Series0
31STTRXSRC SearchStart Transaction SourceStringSTR2525
32STTNOTNM SearchStart Note NameStringSTR4545
33SRPTGRNM SearchStart Report Group NamesStringSTR2020
34STTPALNM SearchStart Palette NameStringSTR3030
35STTUSRID SearchStart User IDStringSTR15_User_ID15
36STENDTYP SearchStart End TypeIntegerDDL_End_Type0
37STTCRDNM SearchStart Card NameStringSTR15_Card_Name15
38STTPYTID SearchStart Payment Terms IDStringSTR20_Payment_Terms_ID20
39STTSHMTH SearchStart Shipping MethodStringSTR15_Shipping_Method15
40SRTCOMSR SearchStart Comment SeriesIntegerComment Series0
41SRTCOMID SearchStart Comment IDStringSTR15_Comment_ID15
42ENDLOCID SearchEnd Location IDStringSTR15_Location_ID15
43ENDLOCNM SearchEnd Location NameStringSTR3030
44ENDADDCT SearchEnd Address ContactStringSTR6060
45ENDSRCDC SearchEnd Source DocumentStringSTR10_Source_Document10
46ENDSDDSC SearchEnd Source Document DescriptionStringSTR3030
47ENDSTATE SearchEnd StateStringSTR30_State29
48ENDZIPCD SearchEnd Zip CodeStringSTR1010
49ENDFLSRS SearchEnd File SeriesIntegerDDL_File_Series0
50ENDSERIS SearchEnd SeriesIntegerDDL_Series0
51ENDTRXSR SearchEnd Transaction SourceStringSTR2525
52ENDNOTNM SearchEnd Note NameStringSTR4545
53ENDRPGNM SearchEnd Report Group NamesStringSTR2020
54ENDPALNM SearchEnd Palette NameStringSTR3030
55ENDUSRID SearchEnd User IDStringSTR15_User_ID15
56ENDENDTY SearchEnd End TypeIntegerDDL_End_Type0
57ENDCRDNM SearchEnd Card NameStringSTR15_Card_Name15
58ENDPYTID SearchEnd Payment Terms IDStringSTR20_Payment_Terms_ID20
59ENDSHMTH SearchEnd Shipping MethodStringSTR15_Shipping_Method15
60ENDCOMID SearchEnd Comment IDStringSTR15_Comment_ID15
61ENDCOMSR SearchEnd Comment SeriesIntegerComment Series0
62ENDNAME SearchEnd NameStringSTR6464
63ENDID SearchEnd IDStringSTR15_LBAU15
64STARTID SearchStart IDStringSTR15_LBAU15
65STRTNAME SearchStart NameStringSTR6464
66STRTCITY SearchStart CityStringSTR3535
67ENDCITY SearchEnd CityStringSTR3535
68ENDCNTRY SearchEnd CountryStringSTR6060
69STTCNTRY SearchStart CountryStringSTR6060
70LBLFRMAT SearchLabel FormatIntegerGB0
71NUMOCPIS SearchNumber of CopiesIntegerINT3_U03
72NUMACROS SearchNumber AcrossIntegerDDL0
73INCADADR SearchInclude Additional AddressesBooleanCB_Include_Additional_Addresses0
74INCCNTCT SearchInclude ContactBooleanCB_Include_Contact0
75FRCEUPCS SearchForce UppercaseBooleanCB_Force_Uppercase0
76YEAR1 SearchYearIntegerYear4
77PRNTDTLD SearchPrint Detailed BooleanCB0
78ENTXDDSC SearchEnd Tax Detail DescriptionStringSTR3030
79ETXDTLID SearchEnd Tax Detail IDStringSTR15_LBAU15
80ETXSCHDS SearchEnd Tax Schedule DescriptionStringSTR3030
81ETXSCHID SearchEnd Tax Schedule IDStringSTR15_LBAU15
82STTXDDSC SearchStart Tax Detail DescriptionStringSTR3030
83STTXDTID SearchStart Tax Detail IDStringSTR15_LBAU15
84STXSCDSC SearchStart Tax Schedule DescriptionStringSTR3030
85STXSCHID SearchStart Tax Schedule IDStringSTR15_LBAU15
86ENDPEROD SearchEnd PeriodIntegerINT_STORAGE0
87STPERIOD SearchStart PeriodIntegerINT_STORAGE0
88STDTLTYP SearchStart Detail TypeIntegerDDL_Tax_Detail_Type0
89ENDETTYP SearchEnd Detail TypeIntegerDDL_Tax_Detail_Type0
90STXIDNUM SearchStart Tax ID NumberStringSTR1515
91ETXIDNBR SearchEnd Tax ID NumberStringSTR1515
92HISTTYPE SearchHistory TypeIntegerGB0
93STBCHNUM SearchStart Batch NumberStringSTR15_LBAU15
94STRTDATE SearchStart DateDateDT8
95STDOCNUM SearchStart Document NumberStringSTR2020
96ENDBNMBR SearchEnd Batch NumberStringSTR15_LBAU15
97ENDOCNUM SearchEnd Document NumberStringSTR2020
98ENDDATE SearchEnd DateDateDT8
99PRNSHPTO SearchPrint Ship to AddressBooleanCB_Print_Ship_To_Addresses0
100PRTBLLTO SearchPrint Bill to AddressBooleanCB_Print_Bill_To_Address0
101ARVLDEPART SearchArrival/Departure GBIntegerGB0
102STCUSTID SearchStart Customer IDStringSTR15_RM_Customer_Number15
103ENCUSTID SearchEnd Customer IDStringSTR15_RM_Customer_Number15
104STSOPTYP SearchStart SOP TypeIntegerDDL_SOP_Type0
105EDSOPTYP SearchEnd SOP TypeIntegerDDL_SOP_Type0
106UPSIDNBR SearchUPS Identification NumberStringSTR1515
107STTDOCDT SearchStart Document DateDateDT8
108ENDDOCDT SearchEnd Document DateDateDT8
109STDOCTYP SearchStart Document TypeIntegerINT11
110ENDOCTYP SearchEnd Document TypeIntegerINT11
111STVNDRID SearchStart Vendor IDStringSTR15_LBU15
112ENDVNDID SearchEnd Vendor IDStringSTR15_LBU15
113STRMTKDT SearchStart RM Token DateIntegerDDL_RM_Token_Dates0
114ENRMTKDT SearchEnd RM Token DateIntegerDDL_RM_Token_Dates0
115STTXUSR1 SearchStart Tax User Defined 1StringTax User Defined120
116ENTXUSR1 SearchEnd Tax User Defined 1StringTax User Defined120
117STTOKNDT SearchStart Token DateIntegerDDL_Start_Dates0
118ENDTKNDT SearchEnd Token DateIntegerDDL_End_Dates0
119STTXPYDT SearchStart Tax Payment DateDateDT8
120ENTXPYDT SearchEnd Tax Payment DateDateDT8
121STTPSTDT SearchStart Post DateDateDATE6
122ENDPSTDT SearchEnd Post DateDateDATE6
123STGENINT1 SearchStart Generic Integer1IntegerINT0
124STDECLID SearchStart Declarant IDStringSTR15_Address_Code15
125ENDDECLID SearchEnd Declarant IDStringSTR15_Address_Code15
126STINTRSTTRTRNID SearchStart Intrastat Return IDStringSTR20_LBAU20
127ENDINTRSTTRTRNID SearchEnd Intrastat Return IDStringSTR20_LBAU20
128STTCC SearchStart Tax Commodity CodeStringSTR30_VAT30
129ENDTCC SearchEnd Tax Commodity CodeStringSTR30_VAT30
130STTXRGNNUM SearchStart Tax Registration NumberStringSTR2525
131ENDTXRGNNUM SearchEnd Tax Registration NumberStringSTR2525
132STRTAMNT SearchStart AmountCurrencyDLR17_RBSO_STR$17
133ENDAMNT SearchEnd AmountCurrencyDLR17_RBSO_STR$17
134GROUPBOX SearchGroup BoxIntegerGB0
135GROUPBX2 SearchGroup Box 2IntegerGB0
136EXCLVOID SearchExclude VoidedBooleanCB_Exclude_Voided0
137PRNTCSV SearchPrint CSVBooleanCB0

Leave a Reply

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