SVC70500 - Service Report Options | Prospr - Dynamics GP Table Reference

SVC70500 - Service Report Options

Query Builder

Select * from SVC70500

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
PRTBYSIT	Print by Site	Integer	2	View
PRNTOPTN	Print Option	Integer	2	View
STTGNDSC	Start Generic Description	String	12	View
ENGENDSC	End Generic Description	String	12	View
ENUSRCAT_1	End User Category[1]	String	12	View
ENUSRCAT_2	End User Category[2]	String	12	View
ENUSRCAT_3	End User Category[3]	String	12	View
ENUSRCAT_4	End User Category[4]	String	12	View
ENUSRCAT_5	End User Category[5]	String	12	View
ENUSRCAT_6	End User Category[6]	String	12	View
STRTUCAT_1	Start User Category[1]	String	12	View
STRTUCAT_2	Start User Category[2]	String	12	View
STRTUCAT_3	Start User Category[3]	String	12	View
STRTUCAT_4	Start User Category[4]	String	12	View
STRTUCAT_5	Start User Category[5]	String	12	View
STRTUCAT_6	Start User Category[6]	String	12	View
CALLNBST	Start Service Call Number	String	12	View
CALLNMEN	End Service Call Number	String	12	View
CONTNBRS	Start Contract Number	String	12	View
CONTNBRE	End Contract Number	String	12	View
SRLNBRST	Start Serial Number	String	22	View
SRLNBREN	End Serial Number	String	22	View
PMDTLIDS	Start PM_DTL_ID	String	10	View
PMDTLIDE	End PM_DTL_ID	String	10	View
STCUSTID	Start Customer ID	String	16	View
ENCUSTID	End Customer ID	String	16	View
STTECHID	Start Tech ID	String	12	View
ENTECHID	End Tech ID	String	12	View
STOFFID	Start Office ID	String	12	View
ENOFFID	End Office ID	String	12	View
SVCOPT1	Start SVC Option1	String	16	View
ENDSVCO1	End SVC Option1	String	16	View
STSVCOP1	Start SVC Option2	String	22	View
ENSVCOP2	End SVC Option2	String	22	View
STSVCOPT3	Start SVC Option3	String	22	View
ENSVCOP3	End SVC Option3	String	22	View
STSVCOP4	Start SVC Option4	String	32	View
ENSVCOP4	End SVC Option4	String	32	View
STSVCOP5	Start SVC Option5	Boolean	2	View
ENSVCOP5	End SVC Option5	Boolean	2	View
STSVCOP6	Start SVC Option6	String	12	View
ENSVCOP6	End SVC Option6	String	12	View
STSVCOP7	Start SVC Option7	String	12	View
ENSVCOP7	End SVC Option7	String	12	View
STSVCOP8	Start SVC Option8	String	22	View
ENSVCOP8	End SVC Option8	String	22	View
STSVCOP9	Start SVC Option9	Integer	2	View
ENSVCOP9	End SVC Option9	Integer	2	View
STSVCO10	Start SVC Option10	Integer	2	View
ENSVCO10	End SVC Option10	Integer	2	View
STTITNUM	Start Item Number	String	32	View
ENITMNBR	End Item Number	String	32	View
SRVRECTYPE	Service Record Type	Integer	2	View
CONSTS	Contract Record Type	Integer	2	View
PRVDRINF	Print Vendor Information	Integer	2	View
PRTDSCNT	Print Discontinued	Boolean	2	View
PRTSVCHS	Print SVC History	Boolean	2	View
SVCRPTNM	SVC Report Name	String	32	View
PRNTNOTS	Print Notes	Boolean	2	View
PRNTTYPE	Print Type	Integer	2	View
ASKECHTM	Ask Each Time	Boolean	2	View
INCLGNDS	Include Legends	Boolean	2	View
PRNTOFIL	Print to File	Boolean	2	View
PRTOPRTR	Print to Printer	Boolean	2	View
PRTOSCRN	Print to Screen	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
STTCLASS	Start Class	String	12	View
ENDCLASS	End Class	String	12	View
STRTDSCR	Start Description	String	52	View
ENDDESCR	End Description	String	52	View
STTSCHED	Start Schedule	String	12	View
ENSCHDUL	End Schedule	String	12	View
STTLOCCD	Start Location Code	String	12	View
ENLOCNCD	End Location Code	String	12	View
STTLOTTY	Start Lot Type	String	12	View
ENLOTTYP	End Lot Type	String	12	View
STRTNGDT	Starting Date	Date	4	View
ENDINGDT	Ending Date	Date	4	View
ENDTKNDT	End Token Date	Integer	2	View
STTOKNDT	Start Token Date	Integer	2	View
STRCTNUM	Start Receipt Number	String	22	View
ENRCTNBR	End Receipt Number	String	22	View
RTPACHIN	Report Palette Choice Index	Integer	2	View
RTGRSBIN	Report Group Sub Index	Currency	10	View
SORTBY	Sort By	Integer	2	View
PRTSRLOT	Print Serial Lot	Boolean	2	View
INZROQTY	Include Zero QTY	Boolean	2	View
PRTITQTY	Print Item Quantities	Boolean	2	View
STTBINUM	Start Bin Number	String	22	View
ENBINNBR	End Bin Number	String	22	View
STDOCNUM	Start Document Number	String	22	View
ENDOCNUM	End Document Number	String	22	View
STDOCTYP	Start Document Type	Integer	2	View
ENDOCTYP	End Document Type	Integer	2	View
STTMODUL	Start Module	String	4	View
ENDMODUL	End Module	String	4	View
STRXSRC	Start TRX Source	String	14	View
ENTRXSRC	End TRX Source	String	14	View
STBCHSRC	Start Batch Source	String	16	View
ENBCHSRC	End Batch Source	String	16	View
STBCHNUM	Start Batch Number	String	16	View
ENDBNMBR	End Batch Number	String	16	View
STVNDRID	Start Vendor ID	String	16	View
ENDVNDID	End Vendor ID	String	16	View
INQTYREQ	Include QTY Requisitioned	Boolean	2	View
INZRORLV	Include Zero Reorder Level	Boolean	2	View
CALSGQTY	Calc Suggested QTYS	Integer	2	View
RCPTOPTS	Receipt Options	Integer	2	View
VENDROPT	Vendor Options	Integer	2	View
SEGSRTBY	Segment Sort By	Integer	2	View
SEGMNTRG	Using Segment Range	Integer	2	View
Start_PriceLevel	Start PriceLevel	String	12	View
End_PriceLevel	End PriceLevel	String	12	View
Start_RMA_Number	Start RMA Number	String	16	View
End_RMA_Number	End RMA Number	String	16	View
Start_Required_Date	Start Required Date	Date	4	View
End_Required_Date	End Required Date	Date	4	View
SVC_Print_Open	SVC Print Open	Boolean	2	View
INCMCINF	Include Multicurrency Info	Boolean	2	View
PRTCURIN	Print Currency In	Integer	2	View

SVC70500 - Service Report Options

Query Builder

Customer Service

Information

My Account

Contact Us