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. | ||||||