PM70500 - Purchasing Report Options | Prospr - Dynamics GP Table Reference

PM70500 - Purchasing Report Options

Query Builder

Select * from PM70500

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
RPTGRIND	Report Group Index	Integer	2	View
RTPACHIN	Report Palette Choice Index	Integer	2	View
RTGRSBIN	Report Group Sub Index	Currency	10	View
ASKECHTM	Ask Each Time	Boolean	2	View
EXPTTYPE	Export Type	Integer	2	View
FILEXPNM	File Export Name	String	256	View
IFFILXST	If File Existing	Integer	2	View
FINRPTNM	Financial Report Name	String	32	View
PRNTOFIL	Print to File	Boolean	2	View
PRTOPRTR	Print to Printer	Boolean	2	View
PRTOSCRN	Print to Screen	Boolean	2	View
SORTBY	Sort By	Integer	2	View
SORTBY2	Sort By 2	Integer	2	View
HISTTYPE	History Type	Integer	2	View
PYMNTDAT	Payment Date	Date	4	View
VOIDONLY	Voided Only	Boolean	2	View
EXCLVOID	Exclude Voided	Boolean	2	View
Include_Canceled	Include Canceled	Boolean	2	View
DATEOVERDUE	Date Overdue	Date	4	View
Days_Overdue	Days Overdue	Boolean	2	View
POP_Date_Selection	POP_Date_Selection	Integer	2	View
Include_Closed	Include Closed	Boolean	2	View
Include_Released	Include Released	Boolean	2	View
AGEBY	Age By	Integer	2	View
COMPTYPE	Compare Type	Integer	2	View
STVNDRID	Start Vendor ID	String	16	View
STVNDNAM	Start Vendor Name	String	66	View
STVNDCLS	Start Vendor Class	String	12	View
STTSTATE	Start State	String	30	View
STRTZPCD	Start Zip Code	String	12	View
STRTPHON	Start Phone	String	22	View
STRTUDEF	Start User Defined	String	22	View
STTCNTCT	Start Contact	String	62	View
Start_PO_Date	Start PO Date	Date	4	View
STTSHNAM	Start Short Name	String	16	View
STTLOCID	Start Location ID	String	16	View
Start_Promised_Date	Start Promised Date	Date	4	View
Start_Required_Date	Start Required Date	Date	4	View
STVNSTUS	Start Vendor Status	Integer	2	View
STT1099T	Start 1099 Type	Integer	2	View
STPERIOD	Start Period	Integer	2	View
STRTYEAR	Start Year	Integer	2	View
STTABYTD	Start Amount Billed YTD	Currency	10	View
STRTPRTY	Start Priority	String	4	View
STTDUEDT	Start Due Date	Date	4	View
STDISCDT	Start Discount Date	Date	4	View
ALORANGE	All Or Range	Integer	2	View
STTACNCD	Start Audit Control Code	String	14	View
STDOCNUM	Start Document Number	String	22	View
STTDOCDT	Start Document Date	Date	4	View
STDOCTYP	Start Document Type	Integer	2	View
STVCHNUM	Start Voucher Number	String	22	View
STTITNUM	Start Item Number	String	32	View
STCHKNUM	Start Check Number	String	22	View
STTCHKDT	Start Check Date	Date	4	View
STCHBKID	Start Checkbook ID	String	16	View
STBCHSRC	Start Batch Source	String	16	View
STBCHNUM	Start Batch Number	String	16	View
STPSTDDT	Start Posted Date	Date	4	View
STCLSDSC	Start Class Description	String	32	View
ENDVNDID	End Vendor ID	String	16	View
ENDVNDNM	End Vendor Name	String	66	View
ENDVNCLS	End Vendor Class	String	12	View
ENDSTATE	End State	String	30	View
ENDZIPCD	End Zip Code	String	12	View
ENPHONBR	End Phone Number	String	22	View
End_PO_Date	End PO Date	Date	4	View
ENUSRDEF	End User Defined	String	22	View
ENDLOCID	End Location ID	String	16	View
ENITMNBR	End Item Number	String	32	View
End_Required_Date	End Required Date	Date	4	View
End_Promised_Date	End Promised Date	Date	4	View
ENDVNDCT	End Vendor Contact	String	62	View
ENDSHNAM	End Short Name	String	16	View
ENVNSTTS	End Vendor Status	Integer	2	View
E1099TYP	End 1099 Type	Integer	2	View
ENDPEROD	End Period	Integer	2	View
ENDYEAR	End Year	Integer	2	View
ENAMBYTD	End Amount Billed YTD	Currency	10	View
ENPRYRTY	End Priority	String	4	View
ENDDUEDT	End Due Date	Date	4	View
ENDISCDT	End Discount Date	Date	4	View
ALORNGE2	All Or Range2	Integer	2	View
ENAUCNCD	End Audit Control Code	String	14	View
ENDOCNUM	End Document Number	String	22	View
ENDDOCDT	End Document Date	Date	4	View
ENDOCTYP	End Document Type	Integer	2	View
ENVCHNUM	End Voucher Number	String	22	View
ENCHKNUM	End Check Number	String	22	View
ENDCHKDT	End Check Date	Date	4	View
ENCHBKID	End Checkbook ID	String	16	View
ENBCHSRC	End Batch Source	String	16	View
ENDBNMBR	End Batch Number	String	16	View
ENPSTDDT	End Posted Date	Date	4	View
ENCLDSCR	End Class Description	String	32	View
AGNGDATE	Aging Date	Date	4	View
PBSDCDTK	Payables Start Document Date Token	Integer	2	View
PBSDUDTK	Payables Start Due Date Token	Integer	2	View
PBSDSDTK	Payables Start Discount Date Token	Integer	2	View
PBSCHDTK	Payables Start Check Date Token	Integer	2	View
PBSPTDTK	Payables Start Posted Date Token	Integer	2	View
PBEDCDTK	Payables End Document Date Token	Integer	2	View
PBEDUDTK	Payables End Due Date Token	Integer	2	View
PBEDSDTK	Payables End Discount Date Token	Integer	2	View
PBECHDTK	Payables End Check Date Token	Integer	2	View
PBEPDTKN	Payables End Posted Date Token	Integer	2	View
PBCDTTKN	Payables Complete Date Tokens	Integer	2	View
DETLDRPT	Detailed Report	Boolean	2	View
SINGACT	Single Account	Boolean	2	View
STTACNUM_1	Start Account Number:Account_Segment_Pool1	String	10	View
STTACNUM_2	Start Account Number:Account_Segment_Pool2	String	10	View
STTACNUM_3	Start Account Number:Account_Segment_Pool3	String	10	View
STTACNUM_4	Start Account Number:Account_Segment_Pool4	String	10	View
STTACNUM_5	Start Account Number:Account_Segment_Pool5	String	10	View
EACCNBR_1	End Account Number:Account_Segment_Pool1	String	10	View
EACCNBR_2	End Account Number:Account_Segment_Pool2	String	10	View
EACCNBR_3	End Account Number:Account_Segment_Pool3	String	10	View
EACCNBR_4	End Account Number:Account_Segment_Pool4	String	10	View
EACCNBR_5	End Account Number:Account_Segment_Pool5	String	10	View
STRPONUM	Start PO Number	String	18	View
ENDPONUM	End PO Number	String	18	View
EndPOPRcptNum	End POP Receipt Number	String	18	View
StartPOPRcptNum	Start POP Receipt Number	String	18	View
STRCREAT	Start Created By	String	16	View
STRCTDT	Start Receipt Date	Date	4	View
ENRCTDT	End Receipt Date	Date	4	View
STRCTNUM	Start Receipt Number	String	22	View
ENRCTNBR	End Receipt Number	String	22	View
ENDCREATE	End Created By	String	16	View
STRPOSTA	Start PO Status	Integer	2	View
ENDPOSTA	End PO Status	Integer	2	View
INCRCPTS	Include Receipts	Boolean	2	View
DISSRLOT	Display Serial/Lot Number	Boolean	2	View
STRXSRC	Start TRX Source	String	14	View
ENTRXSRC	End TRX Source	String	14	View
CRBLNCCB	Credit Balance CB	Boolean	2	View
FLLYPDCB	Fully Paid CB	Boolean	2	View
ZROBALCB	Zero Balance CB	Boolean	2	View
EXCLZBAL	Exclude Zero Balance	Boolean	2	View
NOACTVCB	No Activity CB	Boolean	2	View
Unposted_Applied_CR_Docs	Unposted Applied Credit Documents CB	Boolean	2	View
Multicurrency_Information	Multicurrency Information CB	Boolean	2	View
Include_Distribution_Typ	Include Distribution Type	Long Integer	4	View
RPTXRATE	Reporting Exchange Rate	Currency (Variable)	10	View
RPRTCLMD	Reporting Rate Calculation Method	Integer	2	View
PRTCURIN	Print Currency In	Integer	2	View
INCLFUNC	Include Functional Currency	Boolean	2	View
STARTLINEORIGIN	Start Line Origin	Integer	2	View
ENDLINEORIGIN	End Line Origin	Integer	2	View
STARTBUYERID	Start Buyer ID	String	16	View
ENDBUYERID	End Buyer ID	String	16	View
INCLUDEHOLDPO	Include Hold PO	Boolean	2	View
INCLUDEHOLDPOONLY	Include Hold PO Only	Boolean	2	View
STARTRELEASEBYDATE	Start Release By Date	Date	4	View
ENDRELEASEBYDATE	End Release By Date	Date	4	View
Include_New	Include New	Boolean	2	View
Include_Change_Order	Include Change Order	Boolean	2	View
Include_Received	Include Received	Boolean	2	View
SummaryYear	Summary Year	Integer	2	View
DateSensitivitySumSelect	Date Sensitivity Summary Select	Integer	2	View
StartProjNum	Start Project Number	String	16	View
EndProjNum	End Project Number	String	16	View
StartCostCatID	Start Cost Category ID	String	16	View
EndCostCatID	End Cost Category ID	String	16	View
IncludeApprovedPOsOnly	Include Approved POs Only	Boolean	2	View
MISC	Misc	Boolean	2	View
INTEREST	Interest	Boolean	2	View
DIVIDEND	Dividend	Boolean	2	View

PM70500 - Purchasing Report Options

Query Builder

Customer Service

Information

My Account

Contact Us