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

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 *