PM Vendor Master Summary (PM00201)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PM00201

Product: Microsoft Dynamics GP (0)
Series: Purchasing

Display Name: PM Vendor Master Summary
Physical Name: PM00201
Technical Name: PM_Vendor_MSTR_SUM

Group Display Name: Payables Vendor Master Logical File
Group Technical Name: PM_Vendor_Master_Logical_File

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	SQL DB Length	Keyable Length
1	VENDORID	Vendor ID	STR_15_Vendor_ID	String	16	15
	Key to the PM Vendor Master File (PM00200). Click to show/hide SELECT ['PM Vendor Master Summary'].VENDORID AS 'PM Vendor Master Summary-Vendor ID' ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID' FROM PM00201 AS ['PM Vendor Master Summary'] INNER JOIN PM00200 AS ['PM Vendor Master File'] ON ['PM Vendor Master Summary'].VENDORID = ['PM Vendor Master File'].VENDORID
2	HIESTBAL	Highest Balance	DLR17_RBS0_UTR$	Currency	10	17
3	CURRBLNC	Current Balance	DLR19_RBS0_STR$	Currency	10	19
4	NOINVYTD	Number of Invoices YTD	LI_9U0	Long Integer	4	9
5	NOINVLIF	Number of Invoices LIFE	LI_9U0	Long Integer	4	9
6	NOINVLYR	Number of Invoices LYR	LI_9U0	Long Integer	4	9
7	NOPINYTD	Number of Paid Invoices YTD	LI_9U0	Long Integer	4	9
8	NOPILIFE	Number of Paid Invoices LIFE	LI_9U0	Long Integer	4	9
9	AMBLDTYD	Amount Billed YTD	DLR19_RBS0_STR$	Currency	10	19
10	AMBLDLIF	Amount Billed LIFE	DLR19_RBS0_STR$	Currency	10	19
11	AMBLDLYR	Amount Billed LYR	DLR19_RBS0_STR$	Currency	10	19
12	AMTPDYTD	Amount Paid YTD	DLR19_RBS0_STR$	Currency	10	19
13	AMTPDLIF	Amount Paid LIFE	DLR19_RBS0_STR$	Currency	10	19
14	AMTPDLYR	Amount Paid LYR	DLR19_RBS0_STR$	Currency	10	19
15	TEN99AYTD	1099 Amount YTD	DLR19_RBS0_STR$	Currency	10	19
16	TEN99ALIF	1099 Amount LIFE	DLR19_RBS0_STR$	Currency	10	19
17	TEN99ALYR	1099 Amount LYR	DLR19_RBS0_STR$	Currency	10	19
18	DISAVYTD	Discount Available YTD	DLR19_RBS0_STR$	Currency	10	19
19	DISAVLIF	Discount Available LIFE	DLR19_RBS0_STR$	Currency	10	19
20	DISAVLYR	Discount Available LYR	DLR19_RBS0_STR$	Currency	10	19
21	DISTKYTD	Discount Taken YTD	DLR19_RBS0_STR$	Currency	10	19
22	DISTKNLF	Discount Taken LIFE	DLR19_RBS0_STR$	Currency	10	19
23	DISTKLYR	Discount Taken LYR	DLR19_RBS0_STR$	Currency	10	19
24	DISLSYTD	Discount Lost YTD	DLR19_RBS0_STR$	Currency	10	19
25	DISLSTLF	Discount Lost LIFE	DLR19_RBS0_STR$	Currency	10	19
26	DISLSLYR	Discount Lost LYR	DLR19_RBS0_STR$	Currency	10	19
27	FINCHLIF	Finance Charge LIFE	DLR19_RBS0_STR$	Currency	10	19
28	FINCHLYR	Finance Charge LYR	DLR19_RBS0_STR$	Currency	10	19
29	FINCHYTD	Finance Charge YTD	DLR19_RBS0_STR$	Currency	10	19
30	WROFSYTD	Write Offs YTD	DLR19_RBS0_STR$	Currency	10	19
31	WROFSLIF	Write Offs LIFE	DLR19_RBS0_STR$	Currency	10	19
32	WROFSLYR	Write Offs LYR	DLR19_RBS0_STR$	Currency	10	19
33	RTRNSYTD	Returns YTD	DLR19_RBS0_STR$	Currency	10	19
34	RTRNSLIF	Returns LIFE	DLR19_RBS0_STR$	Currency	10	19
35	RTRNSLYR	Returns LYR	DLR19_RBS0_STR$	Currency	10	19
36	TRDTKLIF	Trade Discounts Taken LIFE	DLR19_RBSO_STR$	Currency	10	19
37	TRDTLYR	Trade Discounts Taken LYR	DLR19_RBSO_STR$	Currency	10	19
38	TRDTYTD	Trade Discounts Taken YTD	DLR19_RBSO_STR$	Currency	10	19
39	NFNCHLIF	Number of Finance Charges LIFE	LI_9U0	Long Integer	4	9
40	NFNCHLYR	Number of Finance Charges LYR	LI_9U0	Long Integer	4	9
41	NFNCHYTD	Number of Finance Charges YTD	LI_9U0	Long Integer	4	9
42	RTNGOWED	Retainage Owed	DLR17_RBS0_STR$	Currency	10	17
43	LSTCHNUM	Last Check Number	Check_Number	String	22	20
44	LSTCHKDT	Last Check Date	DT	Date	4	8
45	LSTCHAMT	Last Check Amount	DLR17_RBS0_UTR$	Currency	10	17
46	LSTINNUM	Last Invoice Number	STR20	String	22	20
47	LSTINVAM	Last Invoice Amount	DLR17_RBS0_UTR$	Currency	10	17
48	LSTPURDT	Last Purchase Date	DT	Date	4	8
49	FSTPURDT	First Purchase Date	DT	Date	4	8
50	CURUNPBN	Current Unapplied Payment Balance	DLR17_RBS0_UTR$	Currency	10	17
51	UNPDFNCH	Unpaid Finance Charges	DLR17_RBS0_UTR$	Currency	10	17
52	DYCHTCLR	Days Checks To Clear	INT3_U0	Integer	2	3
53	AVGDTPYR	Average Days To Pay - Year	INT3_U0	Integer	2	3
54	AVDTPLIF	Average Days To Pay - Life	INT3_U0	Integer	2	3
55	ACCRDINV	Accured Inventory	DLR17_RBS0_STR$	Currency	10	17
56	ONORDAMT	On Order Amount	DLR19_RBS0_UTR$	Currency	10	19
57	WITHYTD	Withholding YTD	DLR19_RBS0_STR$	Currency	10	19
58	WITHLYR	Withholding LYR	DLR19_RBS0_STR$	Currency	10	19
59	Withholding_LIFE	Withholding LIFE	DLR19_RBS0_STR$	Currency	10	19
60	PrepaymentAmount	Prepayment Amount	DLR19_RBS0_UTR$	Currency	10	19
61	DEX_ROW_ID		int	int	10	10
	DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information. Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurve Products Microsoft Dynamics GP (0)PurchasingPM Vendor Master Summary (PM00201)

Click to show/hide

Leave a Reply Cancel reply