PDK70101 - PDK Report Options | Prospr - Dynamics GP Table Reference

PDK70101 - PDK Report Options

Query Builder

Select * from PDK70101

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
USERID	User ID	String	16	View
PDK_Start_Doc_No	PDK Start Doc No	String	32	View
PDK_End_Doc_No	PDK End Doc No	String	32	View
PASTPROJN	PA Start Project Number	String	16	View
PAENPROJN	PA End Project Number	String	16	View
Start_Contract_Number	Start Contract Number	String	12	View
End_Contract_Number	End Contract Number	String	12	View
PAStart_ID_Array_1	PA Start ID Array[1]	String	16	View
PAStart_ID_Array_2	PA Start ID Array[2]	String	16	View
PAStart_ID_Array_3	PA Start ID Array[3]	String	16	View
PAStart_ID_Array_4	PA Start ID Array[4]	String	16	View
PAStart_ID_Array_5	PA Start ID Array[5]	String	16	View
PAStart_ID_Array_6	PA Start ID Array[6]	String	16	View
PAStart_ID_Array_7	PA Start ID Array[7]	String	16	View
PAStart_ID_Array_8	PA Start ID Array[8]	String	16	View
PAStart_ID_Array_9	PA Start ID Array[9]	String	16	View
PAStart_ID_Array_10	PA Start ID Array[10]	String	16	View
PAEnd_ID_Array_1	PA End ID Array[1]	String	16	View
PAEnd_ID_Array_2	PA End ID Array[2]	String	16	View
PAEnd_ID_Array_3	PA End ID Array[3]	String	16	View
PAEnd_ID_Array_4	PA End ID Array[4]	String	16	View
PAEnd_ID_Array_5	PA End ID Array[5]	String	16	View
PAEnd_ID_Array_6	PA End ID Array[6]	String	16	View
PAEnd_ID_Array_7	PA End ID Array[7]	String	16	View
PAEnd_ID_Array_8	PA End ID Array[8]	String	16	View
PAEnd_ID_Array_9	PA End ID Array[9]	String	16	View
PAEnd_ID_Array_10	PA End ID Array[10]	String	16	View
PAStart_Name_Array_1	PA Start Name Array[1]	String	32	View
PAStart_Name_Array_2	PA Start Name Array[2]	String	32	View
PAStart_Name_Array_3	PA Start Name Array[3]	String	32	View
PAStart_Name_Array_4	PA Start Name Array[4]	String	32	View
PAStart_Name_Array_5	PA Start Name Array[5]	String	32	View
PAStart_Name_Array_6	PA Start Name Array[6]	String	32	View
PAStart_Name_Array_7	PA Start Name Array[7]	String	32	View
PAStart_Name_Array_8	PA Start Name Array[8]	String	32	View
PAStart_Name_Array_9	PA Start Name Array[9]	String	32	View
PAStart_Name_Array_10	PA Start Name Array[10]	String	32	View
PAEnd_Name_Array_1	PA End Name Array[1]	String	32	View
PAEnd_Name_Array_2	PA End Name Array[2]	String	32	View
PAEnd_Name_Array_3	PA End Name Array[3]	String	32	View
PAEnd_Name_Array_4	PA End Name Array[4]	String	32	View
PAEnd_Name_Array_5	PA End Name Array[5]	String	32	View
PAEnd_Name_Array_6	PA End Name Array[6]	String	32	View
PAEnd_Name_Array_7	PA End Name Array[7]	String	32	View
PAEnd_Name_Array_8	PA End Name Array[8]	String	32	View
PAEnd_Name_Array_9	PA End Name Array[9]	String	32	View
PAEnd_Name_Array_10	PA End Name Array[10]	String	32	View
STDATEIN	Start Date Incurred	Date	4	View
ENDATEIN	End Date Incurred	Date	4	View
PASTDOCT	PA Start Doc Type	Integer	2	View
PAENDOCT	PA End Doc Type	Integer	2	View
IFFILXST	If File Existing	Integer	2	View
FILEXPNM	File Export Name	String	256	View
EXPTTYPE	Export 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
PRNTTYPE	Print Type	Integer	2	View
RPTGRIND	Report Group Index	Integer	2	View
RTGRSBIN	Report Group Sub Index	Currency	10	View
RTPACHIN	Report Palette Choice Index	Integer	2	View
REPORTID	Report ID	Integer	2	View
RPTGRNMS	Report Group Names	String	22	View
PATU	PA Transaction Usage 1 = Timesheet 2 = Equipment Log 3 = Miscellaneous Log 4 = Purchases/Material 5 = Employee Expense	Integer	2	View
STRTNGDT	Starting Date	Date	4	View
ENDINGDT	Ending Date	Date	4	View
STTUDEF1	Start User Defined 1	String	22	View
ENUSRDF1	End User Defined 1	String	22	View
STTDOCDT	Start Document Date	Date	4	View
ENDDOCDT	End Document Date	Date	4	View
STTPSTDT	Start Post Date	Date	4	View
ENDPSTDT	End Post Date	Date	4	View
SORTBY	Sort By	Integer	2	View
PARange_By_Array_1	PA Range By Array[1]	Boolean	2	View
PARange_By_Array_2	PA Range By Array[2]	Boolean	2	View
PARange_By_Array_3	PA Range By Array[3]	Boolean	2	View
PARange_By_Array_4	PA Range By Array[4]	Boolean	2	View
PARange_By_Array_5	PA Range By Array[5]	Boolean	2	View
PARange_By_Array_6	PA Range By Array[6]	Boolean	2	View
PARange_By_Array_7	PA Range By Array[7]	Boolean	2	View
PARange_By_Array_8	PA Range By Array[8]	Boolean	2	View
PARange_By_Array_9	PA Range By Array[9]	Boolean	2	View
PARange_By_Array_10	PA Range By Array[10]	Boolean	2	View
PAExclude_Array_1	PA Exclude Array[1]	Boolean	2	View
PAExclude_Array_2	PA Exclude Array[2]	Boolean	2	View
PAExclude_Array_3	PA Exclude Array[3]	Boolean	2	View
PAExclude_Array_4	PA Exclude Array[4]	Boolean	2	View
PAExclude_Array_5	PA Exclude Array[5]	Boolean	2	View
PAExclude_Array_6	PA Exclude Array[6]	Boolean	2	View
PAExclude_Array_7	PA Exclude Array[7]	Boolean	2	View
PAExclude_Array_8	PA Exclude Array[8]	Boolean	2	View
PAExclude_Array_9	PA Exclude Array[9]	Boolean	2	View
PAExclude_Array_10	PA Exclude Array[10]	Boolean	2	View
RANGEBY	Range By	Integer	2	View
PAReport_Include	PA Report Include	Integer	2	View

PDK70101 - PDK Report Options

Query Builder

Customer Service

Information

My Account

Contact Us