PM00100 - PM Class Master File | Prospr - Dynamics GP Table Reference

PM00100 - PM Class Master File

Query Builder

Select * from PM00100

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
VNDCLSID	Vendor Class ID	String	12	View
VNDCLDSC	Vendor Class Description	String	32	View
DEFLTCLS	Default Class	Boolean	2	View
MXIAFVND	Maximum Invoice Amount For Vendors	Integer	2	View
MXINVAMT	Maximum Invoice Amount	Currency	10	View
WRITEOFF	Writeoff	Integer	2	View
CREDTLMT	Credit Limit	Integer	2	View
TEN99TYPE	1099 Type 1 – Not a 1099 vendor 2 – Dividend 3 – Interest 4 - Miscellaneous	Integer	2	View
PTCSHACF	Post To Cash Account From	Integer	2	View
MXWOFAMT	Maximum Write Off Amount	Currency	10	View
MINORDER	Minimum Order	Currency	10	View
CRLMTDLR	Credit Limit Dollar	Currency	10	View
PYMNTPRI	Payment Priority	String	4	View
SHIPMTHD	Shipping Method	String	16	View
PYMTRMID	Payment Terms ID	String	22	View
MINPYTYP	Minimum Payment Type	Integer	2	View
MINPYDLR	Minimum Payment Dollar	Currency	10	View
MINPYPCT	Minimum Payment Percent	Integer	2	View
CURNCYID	Currency ID	String	16	View
TAXSCHID	Tax Schedule ID	String	16	View
KPCALHST	Keep Calendar History	Boolean	2	View
KGLDSTHS	Keep GL Dist History	Boolean	2	View
KPERHIST	Keep Period History	Boolean	2	View
KPTRXHST	Keep Trx History	Boolean	2	View
TRDDISCT	Trade Discount	Integer	2	View
USERDEF1	User Defined 1	String	22	View
USERDEF2	User Defined 2	String	22	View
PMAPINDX	PM AP Index	Long Integer	4	View
PMCSHIDX	PM Cash Index	Long Integer	4	View
PMDAVIDX	PM Discount Available Index	Long Integer	4	View
PMDTKIDX	PM Discount Taken Index	Long Integer	4	View
PMFINIDX	PM Finance Charge Index	Long Integer	4	View
PMMSCHIX	PM Misc Charges Index	Long Integer	4	View
PMFRTIDX	PM Freight Index	Long Integer	4	View
PMTAXIDX	PM Tax Index	Long Integer	4	View
PMWRTIDX	PM Write Offs Index	Long Integer	4	View
PMPRCHIX	PM Purchases Index	Long Integer	4	View
PMRTNGIX	PM Retainage Index	Long Integer	4	View
PMTDSCIX	PM Trade Discount Index	Long Integer	4	View
ACPURIDX	Accrued Purchases Index	Long Integer	4	View
PURPVIDX	Purchase Price Variance Index	Long Integer	4	View
CHEKBKID	Checkbook ID	String	16	View
MODIFDT	Modified Date	Date	4	View
CREATDDT	Created Date	Date	4	View
RATETPID	Rate Type ID	String	16	View
Revalue_Vendor	Revalue Vendor	Boolean	2	View
Post_Results_To	Post Results To	Integer	2	View
FREEONBOARD	Free On Board	Integer	2	View
DISGRPER	Discount Grace Period	Integer	2	View
DUEGRPER	Due Date Grace Period	Integer	2	View
TaxInvRecvd	Tax Invoice Received	Boolean	2	View
CBVAT	Cash Based VAT	Boolean	2	View

PM00100 - PM Class Master File

Query Builder

Customer Service

Information

My Account

Contact Us