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