PM40100 - PM Setup File | Prospr - Dynamics GP Table Reference

PM40100 - PM Setup File

Query Builder

Select * from PM40100

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
UNIQKEY	Key	String	2	View
ADUPINNM	Allow Duplicate Invoice Numbers	Integer	2	View
OVVCHNUM	Override Voucher Number	Boolean	2	View
TRKDISAV	Track Discounts Available	Boolean	2	View
PRTHATRB	Print Historical Aged Trial Balance	Boolean	2	View
AGEBY	Age By	Integer	2	View
APPLYBY	Apply By	Integer	2	View
RMVNDHPW	Remove Vendor Holds Password	String	12	View
RMVTRHPW	Remove Trx Hold Password	String	12	View
XCDMINPW	Exceed Max Invoice Password	String	12	View
WROFPSWD	Write Off Password	String	12	View
NTVCHNUM	Next Voucher Number	String	18	View
PMNPYNBR	PM Next Payment Number	String	22	View
NXTVNDID	Next Temporary Vendor ID	String	16	View
USRDFPR1	User Defined Prompt 1	String	16	View
USRDRPR2	User Defined Prompt 2	String	16	View
PMTRXDSC_1	PM Transaction Description[1]	String	22	View
PMTRXDSC_2	PM Transaction Description[2]	String	22	View
PMTRXDSC_3	PM Transaction Description[3]	String	22	View
PMTRXDSC_4	PM Transaction Description[4]	String	22	View
PMTRXDSC_5	PM Transaction Description[5]	String	22	View
PMTRXDSC_6	PM Transaction Description[6]	String	22	View
PMTRXDSC_7	PM Transaction Description[7]	String	22	View
PMTRXDSC_8	PM Transaction Description[8]	String	22	View
PMTRXABR_1	PM Transaction Abbreviation[1]	String	4	View
PMTRXABR_2	PM Transaction Abbreviation[2]	String	4	View
PMTRXABR_3	PM Transaction Abbreviation[3]	String	4	View
PMTRXABR_4	PM Transaction Abbreviation[4]	String	4	View
PMTRXABR_5	PM Transaction Abbreviation[5]	String	4	View
PMTRXABR_6	PM Transaction Abbreviation[6]	String	4	View
PMTRXABR_7	PM Transaction Abbreviation[7]	String	4	View
PMTRXABR_8	PM Transaction Abbreviation[8]	String	4	View
CHEKBKID	Checkbook ID	String	16	View
PCHSCHID	Purchase Schedule ID	String	16	View
FRTSCHID	Freight Schedule ID	String	16	View
MSCSCHID	Misc Schedule ID	String	16	View
LSTYECAL	Last Year End Calendar	Date	4	View
LSTYEFSC	Last Year End Fiscal	Date	4	View
Check_Format_Default	Check Format Default	Integer	2	View
Check_Stub_Default	Check Stub Default	Integer	2	View
PRNTPRVSLYAPPLDDCS	Print Previously Applied Docs	Boolean	2	View
DelUPDoc	Delete Unposted Printed Docs	Boolean	2	View
PrntTaxDetDoc	Print Tax Details On Documents	Boolean	2	View
DateSensitivitySumView	Date Sensitivity Summary View	Integer	2	View
PRNTDCUR	Print Dual Currencies	Boolean	2	View
AGEUNAPPLDCR	Age Unapplied Credit Amounts	Boolean	2	View
PMNXTSCHDNBR	PM Next Schedule Number	String	22	View
ExcludeExprdDiscntsPymnt	Exclude Expired Discounts from Payments	Boolean	2	View

PM40100 - PM Setup File

Query Builder

Customer Service

Information

My Account

Contact Us