PM Vendor Master Summary (PM00201)

azurecurve Products Microsoft Dynamics GP (0)PurchasingPM 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	Length
1	VENDORID	Vendor ID	String	STR_15_Vendor_ID	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	Currency	DLR17_RBS0_UTR$	17
3	CURRBLNC	Current Balance	Currency	DLR19_RBS0_STR$	19
4	NOINVYTD	Number of Invoices YTD	Long Integer	LI_9U0	9
5	NOINVLIF	Number of Invoices LIFE	Long Integer	LI_9U0	9
6	NOINVLYR	Number of Invoices LYR	Long Integer	LI_9U0	9
7	NOPINYTD	Number of Paid Invoices YTD	Long Integer	LI_9U0	9
8	NOPILIFE	Number of Paid Invoices LIFE	Long Integer	LI_9U0	9
9	AMBLDTYD	Amount Billed YTD	Currency	DLR19_RBS0_STR$	19
10	AMBLDLIF	Amount Billed LIFE	Currency	DLR19_RBS0_STR$	19
11	AMBLDLYR	Amount Billed LYR	Currency	DLR19_RBS0_STR$	19
12	AMTPDYTD	Amount Paid YTD	Currency	DLR19_RBS0_STR$	19
13	AMTPDLIF	Amount Paid LIFE	Currency	DLR19_RBS0_STR$	19
14	AMTPDLYR	Amount Paid LYR	Currency	DLR19_RBS0_STR$	19
15	TEN99AYTD	1099 Amount YTD	Currency	DLR19_RBS0_STR$	19
16	TEN99ALIF	1099 Amount LIFE	Currency	DLR19_RBS0_STR$	19
17	TEN99ALYR	1099 Amount LYR	Currency	DLR19_RBS0_STR$	19
18	DISAVYTD	Discount Available YTD	Currency	DLR19_RBS0_STR$	19
19	DISAVLIF	Discount Available LIFE	Currency	DLR19_RBS0_STR$	19
20	DISAVLYR	Discount Available LYR	Currency	DLR19_RBS0_STR$	19
21	DISTKYTD	Discount Taken YTD	Currency	DLR19_RBS0_STR$	19
22	DISTKNLF	Discount Taken LIFE	Currency	DLR19_RBS0_STR$	19
23	DISTKLYR	Discount Taken LYR	Currency	DLR19_RBS0_STR$	19
24	DISLSYTD	Discount Lost YTD	Currency	DLR19_RBS0_STR$	19
25	DISLSTLF	Discount Lost LIFE	Currency	DLR19_RBS0_STR$	19
26	DISLSLYR	Discount Lost LYR	Currency	DLR19_RBS0_STR$	19
27	FINCHLIF	Finance Charge LIFE	Currency	DLR19_RBS0_STR$	19
28	FINCHLYR	Finance Charge LYR	Currency	DLR19_RBS0_STR$	19
29	FINCHYTD	Finance Charge YTD	Currency	DLR19_RBS0_STR$	19
30	WROFSYTD	Write Offs YTD	Currency	DLR19_RBS0_STR$	19
31	WROFSLIF	Write Offs LIFE	Currency	DLR19_RBS0_STR$	19
32	WROFSLYR	Write Offs LYR	Currency	DLR19_RBS0_STR$	19
33	RTRNSYTD	Returns YTD	Currency	DLR19_RBS0_STR$	19
34	RTRNSLIF	Returns LIFE	Currency	DLR19_RBS0_STR$	19
35	RTRNSLYR	Returns LYR	Currency	DLR19_RBS0_STR$	19
36	TRDTKLIF	Trade Discounts Taken LIFE	Currency	DLR19_RBSO_STR$	19
37	TRDTLYR	Trade Discounts Taken LYR	Currency	DLR19_RBSO_STR$	19
38	TRDTYTD	Trade Discounts Taken YTD	Currency	DLR19_RBSO_STR$	19
39	NFNCHLIF	Number of Finance Charges LIFE	Long Integer	LI_9U0	9
40	NFNCHLYR	Number of Finance Charges LYR	Long Integer	LI_9U0	9
41	NFNCHYTD	Number of Finance Charges YTD	Long Integer	LI_9U0	9
42	RTNGOWED	Retainage Owed	Currency	DLR17_RBS0_STR$	17
43	LSTCHNUM	Last Check Number	String	Check_Number	20
44	LSTCHKDT	Last Check Date	Date	DT	8
45	LSTCHAMT	Last Check Amount	Currency	DLR17_RBS0_UTR$	17
46	LSTINNUM	Last Invoice Number	String	STR20	20
47	LSTINVAM	Last Invoice Amount	Currency	DLR17_RBS0_UTR$	17
48	LSTPURDT	Last Purchase Date	Date	DT	8
49	FSTPURDT	First Purchase Date	Date	DT	8
50	CURUNPBN	Current Unapplied Payment Balance	Currency	DLR17_RBS0_UTR$	17
51	UNPDFNCH	Unpaid Finance Charges	Currency	DLR17_RBS0_UTR$	17
52	DYCHTCLR	Days Checks To Clear	Integer	INT3_U0	3
53	AVGDTPYR	Average Days To Pay - Year	Integer	INT3_U0	3
54	AVDTPLIF	Average Days To Pay - Life	Integer	INT3_U0	3
55	ACCRDINV	Accured Inventory	Currency	DLR17_RBS0_STR$	17
56	ONORDAMT	On Order Amount	Currency	DLR19_RBS0_UTR$	19
57	WITHYTD	Withholding YTD	Currency	DLR19_RBS0_STR$	19
58	WITHLYR	Withholding LYR	Currency	DLR19_RBS0_STR$	19
59	Withholding_LIFE	Withholding LIFE	Currency	DLR19_RBS0_STR$	19
60	PrepaymentAmount	Prepayment Amount	Currency	DLR19_RBS0_UTR$	19

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

Click to show/hide

Leave a Reply Cancel reply