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 NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
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
2HIESTBAL SearchHighest BalanceDLR17_RBS0_UTR$Currency1017
3CURRBLNC SearchCurrent BalanceDLR19_RBS0_STR$Currency1019
4NOINVYTD SearchNumber of Invoices YTDLI_9U0Long Integer49
5NOINVLIF SearchNumber of Invoices LIFELI_9U0Long Integer49
6NOINVLYR SearchNumber of Invoices LYRLI_9U0Long Integer49
7NOPINYTD SearchNumber of Paid Invoices YTDLI_9U0Long Integer49
8NOPILIFE SearchNumber of Paid Invoices LIFELI_9U0Long Integer49
9AMBLDTYD SearchAmount Billed YTDDLR19_RBS0_STR$Currency1019
10AMBLDLIF SearchAmount Billed LIFEDLR19_RBS0_STR$Currency1019
11AMBLDLYR SearchAmount Billed LYRDLR19_RBS0_STR$Currency1019
12AMTPDYTD SearchAmount Paid YTDDLR19_RBS0_STR$Currency1019
13AMTPDLIF SearchAmount Paid LIFEDLR19_RBS0_STR$Currency1019
14AMTPDLYR SearchAmount Paid LYRDLR19_RBS0_STR$Currency1019
15TEN99AYTD Search1099 Amount YTDDLR19_RBS0_STR$Currency1019
16TEN99ALIF Search1099 Amount LIFEDLR19_RBS0_STR$Currency1019
17TEN99ALYR Search1099 Amount LYRDLR19_RBS0_STR$Currency1019
18DISAVYTD SearchDiscount Available YTDDLR19_RBS0_STR$Currency1019
19DISAVLIF SearchDiscount Available LIFEDLR19_RBS0_STR$Currency1019
20DISAVLYR SearchDiscount Available LYRDLR19_RBS0_STR$Currency1019
21DISTKYTD SearchDiscount Taken YTDDLR19_RBS0_STR$Currency1019
22DISTKNLF SearchDiscount Taken LIFEDLR19_RBS0_STR$Currency1019
23DISTKLYR SearchDiscount Taken LYRDLR19_RBS0_STR$Currency1019
24DISLSYTD SearchDiscount Lost YTDDLR19_RBS0_STR$Currency1019
25DISLSTLF SearchDiscount Lost LIFEDLR19_RBS0_STR$Currency1019
26DISLSLYR SearchDiscount Lost LYRDLR19_RBS0_STR$Currency1019
27FINCHLIF SearchFinance Charge LIFEDLR19_RBS0_STR$Currency1019
28FINCHLYR SearchFinance Charge LYRDLR19_RBS0_STR$Currency1019
29FINCHYTD SearchFinance Charge YTDDLR19_RBS0_STR$Currency1019
30WROFSYTD SearchWrite Offs YTDDLR19_RBS0_STR$Currency1019
31WROFSLIF SearchWrite Offs LIFEDLR19_RBS0_STR$Currency1019
32WROFSLYR SearchWrite Offs LYRDLR19_RBS0_STR$Currency1019
33RTRNSYTD SearchReturns YTDDLR19_RBS0_STR$Currency1019
34RTRNSLIF SearchReturns LIFEDLR19_RBS0_STR$Currency1019
35RTRNSLYR SearchReturns LYRDLR19_RBS0_STR$Currency1019
36TRDTKLIF SearchTrade Discounts Taken LIFEDLR19_RBSO_STR$Currency1019
37TRDTLYR SearchTrade Discounts Taken LYRDLR19_RBSO_STR$Currency1019
38TRDTYTD SearchTrade Discounts Taken YTDDLR19_RBSO_STR$Currency1019
39NFNCHLIF SearchNumber of Finance Charges LIFELI_9U0Long Integer49
40NFNCHLYR SearchNumber of Finance Charges LYRLI_9U0Long Integer49
41NFNCHYTD SearchNumber of Finance Charges YTDLI_9U0Long Integer49
42RTNGOWED SearchRetainage OwedDLR17_RBS0_STR$Currency1017
43LSTCHNUM SearchLast Check NumberCheck_NumberString2220
44LSTCHKDT SearchLast Check DateDTDate48
45LSTCHAMT SearchLast Check AmountDLR17_RBS0_UTR$Currency1017
46LSTINNUM SearchLast Invoice NumberSTR20String2220
47LSTINVAM SearchLast Invoice AmountDLR17_RBS0_UTR$Currency1017
48LSTPURDT SearchLast Purchase DateDTDate48
49FSTPURDT SearchFirst Purchase DateDTDate48
50CURUNPBN SearchCurrent Unapplied Payment BalanceDLR17_RBS0_UTR$Currency1017
51UNPDFNCH SearchUnpaid Finance ChargesDLR17_RBS0_UTR$Currency1017
52DYCHTCLR SearchDays Checks To ClearINT3_U0Integer23
53AVGDTPYR SearchAverage Days To Pay - YearINT3_U0Integer23
54AVDTPLIF SearchAverage Days To Pay - LifeINT3_U0Integer23
55ACCRDINV SearchAccured InventoryDLR17_RBS0_STR$Currency1017
56ONORDAMT SearchOn Order AmountDLR19_RBS0_UTR$Currency1019
57WITHYTD SearchWithholding YTDDLR19_RBS0_STR$Currency1019
58WITHLYR SearchWithholding LYRDLR19_RBS0_STR$Currency1019
59Withholding_LIFE SearchWithholding LIFEDLR19_RBS0_STR$Currency1019
60PrepaymentAmount SearchPrepayment AmountDLR19_RBS0_UTR$Currency1019
61DEX_ROW_ID Searchintint1010

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.

Leave a Reply

Your email address will not be published. Required fields are marked *