SY70501 - Company Report Options | Prospr - Dynamics GP Table Reference

SY70501 - Company Report Options

Query Builder

Select * from SY70501

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
ORIGINGB	Origins GB	Integer	2	View
STRTYEAR	Start Year	Integer	2	View
ENDYEAR	End Year	Integer	2	View
STICID	Start Intercompany ID	String	6	View
ENDICID	End Intercompany ID	String	6	View
FINRPTNM	Financial Report Name	String	32	View
SJRNTPRT	Show Journals To Print	Boolean	2	View
PRNTNOTS	Print Notes	Boolean	2	View
PRNTTYPE	Print Type	Integer	2	View
ASKECHTM	Ask Each Time	Boolean	2	View
PRNTOFIL	Print to File	Boolean	2	View
PRTOPRTR	Print to Printer	Boolean	2	View
PRTOSCRN	Print to Screen	Boolean	2	View
INCLGNDS	Include Legends	Boolean	2	View
IFFILXST	If File Existing	Integer	2	View
FILEXPNM	File Export Name	String	256	View
EXPTTYPE	Export Type	Integer	2	View
RPTGRIND	Report Group Index	Integer	2	View
RTPACHIN	Report Palette Choice Index	Integer	2	View
RTGRSBIN	Report Group Sub Index	Currency	10	View
SORTBY	Sort By	Integer	2	View
STTLOCID	Start Location ID	String	16	View
STTLOCNM	Start Location Name	String	32	View
STADDCTT	Start Address Contact	String	62	View
SSRCEDOC	Start Source Document	String	12	View
SSDOCDSC	Start Source Document Description	String	32	View
STTSTATE	Start State	String	30	View
STRTZPCD	Start Zip Code	String	12	View
STTFLSRS	Start File Series	Integer	2	View
STARTSRS	Start Series	Integer	2	View
STTRXSRC	Start Transaction Source	String	26	View
STTNOTNM	Start Note Name	String	46	View
SRPTGRNM	Start Report Group Names	String	22	View
STTPALNM	Start Palette Name	String	32	View
STTUSRID	Start User ID	String	16	View
STENDTYP	Start End Type	Integer	2	View
STTCRDNM	Start Card Name	String	16	View
STTPYTID	Start Payment Terms ID	String	22	View
STTSHMTH	Start Shipping Method	String	16	View
SRTCOMSR	Start Comment Series	Integer	2	View
SRTCOMID	Start Comment ID	String	16	View
ENDLOCID	End Location ID	String	16	View
ENDLOCNM	End Location Name	String	32	View
ENDADDCT	End Address Contact	String	62	View
ENDSRCDC	End Source Document	String	12	View
ENDSDDSC	End Source Document Description	String	32	View
ENDSTATE	End State	String	30	View
ENDZIPCD	End Zip Code	String	12	View
ENDFLSRS	End File Series	Integer	2	View
ENDSERIS	End Series	Integer	2	View
ENDTRXSR	End Transaction Source	String	26	View
ENDNOTNM	End Note Name	String	46	View
ENDRPGNM	End Report Group Names	String	22	View
ENDPALNM	End Palette Name	String	32	View
ENDUSRID	End User ID	String	16	View
ENDENDTY	End End Type	Integer	2	View
ENDCRDNM	End Card Name	String	16	View
ENDPYTID	End Payment Terms ID	String	22	View
ENDSHMTH	End Shipping Method	String	16	View
ENDCOMID	End Comment ID	String	16	View
ENDCOMSR	End Comment Series	Integer	2	View
ENDNAME	End Name	String	66	View
ENDID	End ID	String	16	View
STARTID	Start ID	String	16	View
STRTNAME	Start Name	String	66	View
STRTCITY	Start City	String	36	View
ENDCITY	End City	String	36	View
ENDCNTRY	End Country	String	62	View
STTCNTRY	Start Country	String	62	View
LBLFRMAT	Label Format	Integer	2	View
NUMOCPIS	Number of Copies	Integer	2	View
NUMACROS	Number Across	Integer	2	View
INCADADR	Include Additional Addresses	Boolean	2	View
INCCNTCT	Include Contact	Boolean	2	View
FRCEUPCS	Force Uppercase	Boolean	2	View
YEAR1	Year	Integer	2	View
PRNTDTLD	Print Detailed	Boolean	2	View
ENTXDDSC	End Tax Detail Description	String	32	View
ETXDTLID	End Tax Detail ID	String	16	View
ETXSCHDS	End Tax Schedule Description	String	32	View
ETXSCHID	End Tax Schedule ID	String	16	View
STTXDDSC	Start Tax Detail Description	String	32	View
STTXDTID	Start Tax Detail ID	String	16	View
STXSCDSC	Start Tax Schedule Description	String	32	View
STXSCHID	Start Tax Schedule ID	String	16	View
ENDPEROD	End Period	Integer	2	View
STPERIOD	Start Period	Integer	2	View
STDTLTYP	Start Detail Type	Integer	2	View
ENDETTYP	End Detail Type	Integer	2	View
STXIDNUM	Start Tax ID Number	String	16	View
ETXIDNBR	End Tax ID Number	String	16	View
HISTTYPE	History Type	Integer	2	View
STBCHNUM	Start Batch Number	String	16	View
STRTDATE	Start Date	Date	4	View
STDOCNUM	Start Document Number	String	22	View
ENDBNMBR	End Batch Number	String	16	View
ENDOCNUM	End Document Number	String	22	View
ENDDATE	End Date	Date	4	View
PRNSHPTO	Print Ship to Address	Boolean	2	View
PRTBLLTO	Print Bill to Address	Boolean	2	View
ARVLDEPART	Arrival/Departure GB	Integer	2	View
STCUSTID	Start Customer ID	String	16	View
ENCUSTID	End Customer ID	String	16	View
STSOPTYP	Start SOP Type	Integer	2	View
EDSOPTYP	End SOP Type	Integer	2	View
UPSIDNBR	UPS Identification Number	String	16	View
STTDOCDT	Start Document Date	Date	4	View
ENDDOCDT	End Document Date	Date	4	View
STDOCTYP	Start Document Type	Integer	2	View
ENDOCTYP	End Document Type	Integer	2	View
STVNDRID	Start Vendor ID	String	16	View
ENDVNDID	End Vendor ID	String	16	View
STRMTKDT	Start RM Token Date	Integer	2	View
ENRMTKDT	End RM Token Date	Integer	2	View
STTXUSR1	Start Tax User Defined 1	String	22	View
ENTXUSR1	End Tax User Defined 1	String	22	View
STTOKNDT	Start Token Date	Integer	2	View
ENDTKNDT	End Token Date	Integer	2	View
STTXPYDT	Start Tax Payment Date	Date	4	View
ENTXPYDT	End Tax Payment Date	Date	4	View
STTPSTDT	Start Post Date	Date	4	View
ENDPSTDT	End Post Date	Date	4	View
STGENINT1	Start Generic Integer1	Integer	2	View
STDECLID	Start Declarant ID	String	16	View
ENDDECLID	End Declarant ID	String	16	View
STINTRSTTRTRNID	Start Intrastat Return ID	String	22	View
ENDINTRSTTRTRNID	End Intrastat Return ID	String	22	View
STTCC	Start Tax Commodity Code	String	32	View
ENDTCC	End Tax Commodity Code	String	32	View
STTXRGNNUM	Start Tax Registration Number	String	26	View
ENDTXRGNNUM	End Tax Registration Number	String	26	View
STRTAMNT	Start Amount	Currency	10	View
ENDAMNT	End Amount	Currency	10	View
GROUPBOX	Group Box	Integer	2	View
GROUPBX2	Group Box 2	Integer	2	View
EXCLVOID	Exclude Voided	Boolean	2	View
PRNTCSV	Print CSV	Boolean	2	View

SY70501 - Company Report Options

Query Builder

Customer Service

Information

My Account

Contact Us