PM00201 - PM Vendor Master Summary | Prospr - Dynamics GP Table Reference

PM00201 - PM Vendor Master Summary

Query Builder

Select * from PM00201

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
VENDORID	Vendor ID	String	16	View
HIESTBAL	Highest Balance	Currency	10	View
CURRBLNC	Current Balance	Currency	10	View
NOINVYTD	Number of Invoices YTD	Long Integer	4	View
NOINVLIF	Number of Invoices LIFE	Long Integer	4	View
NOINVLYR	Number of Invoices LYR	Long Integer	4	View
NOPINYTD	Number of Paid Invoices YTD	Long Integer	4	View
NOPILIFE	Number of Paid Invoices LIFE	Long Integer	4	View
AMBLDTYD	Amount Billed YTD	Currency	10	View
AMBLDLIF	Amount Billed LIFE	Currency	10	View
AMBLDLYR	Amount Billed LYR	Currency	10	View
AMTPDYTD	Amount Paid YTD	Currency	10	View
AMTPDLIF	Amount Paid LIFE	Currency	10	View
AMTPDLYR	Amount Paid LYR	Currency	10	View
TEN99AYTD	1099 Amount YTD	Currency	10	View
TEN99ALIF	1099 Amount LIFE	Currency	10	View
TEN99ALYR	1099 Amount LYR	Currency	10	View
DISAVYTD	Discount Available YTD	Currency	10	View
DISAVLIF	Discount Available LIFE	Currency	10	View
DISAVLYR	Discount Available LYR	Currency	10	View
DISTKYTD	Discount Taken YTD	Currency	10	View
DISTKNLF	Discount Taken LIFE	Currency	10	View
DISTKLYR	Discount Taken LYR	Currency	10	View
DISLSYTD	Discount Lost YTD	Currency	10	View
DISLSTLF	Discount Lost LIFE	Currency	10	View
DISLSLYR	Discount Lost LYR	Currency	10	View
FINCHLIF	Finance Charge LIFE	Currency	10	View
FINCHLYR	Finance Charge LYR	Currency	10	View
FINCHYTD	Finance Charge YTD	Currency	10	View
WROFSYTD	Write Offs YTD	Currency	10	View
WROFSLIF	Write Offs LIFE	Currency	10	View
WROFSLYR	Write Offs LYR	Currency	10	View
RTRNSYTD	Returns YTD	Currency	10	View
RTRNSLIF	Returns LIFE	Currency	10	View
RTRNSLYR	Returns LYR	Currency	10	View
TRDTKLIF	Trade Discounts Taken LIFE	Currency	10	View
TRDTLYR	Trade Discounts Taken LYR	Currency	10	View
TRDTYTD	Trade Discounts Taken YTD	Currency	10	View
NFNCHLIF	Number of Finance Charges LIFE	Long Integer	4	View
NFNCHLYR	Number of Finance Charges LYR	Long Integer	4	View
NFNCHYTD	Number of Finance Charges YTD	Long Integer	4	View
RTNGOWED	Retainage Owed	Currency	10	View
LSTCHNUM	Last Check Number	String	22	View
LSTCHKDT	Last Check Date	Date	4	View
LSTCHAMT	Last Check Amount	Currency	10	View
LSTINNUM	Last Invoice Number	String	22	View
LSTINVAM	Last Invoice Amount	Currency	10	View
LSTPURDT	Last Purchase Date	Date	4	View
FSTPURDT	First Purchase Date	Date	4	View
CURUNPBN	Current Unapplied Payment Balance	Currency	10	View
UNPDFNCH	Unpaid Finance Charges	Currency	10	View
DYCHTCLR	Days Checks To Clear	Integer	2	View
AVGDTPYR	Average Days To Pay - Year	Integer	2	View
AVDTPLIF	Average Days To Pay - Life	Integer	2	View
ACCRDINV	Accured Inventory	Currency	10	View
ONORDAMT	On Order Amount	Currency	10	View
WITHYTD	Withholding YTD	Currency	10	View
WITHLYR	Withholding LYR	Currency	10	View
Withholding_LIFE	Withholding LIFE	Currency	10	View
PrepaymentAmount	Prepayment Amount	Currency	10	View

PM00201 - PM Vendor Master Summary

Query Builder

Customer Service

Information

My Account

Contact Us