PM00201 - PM Vendor Master Summary
Dynamics GP table PM00201 (PM Vendor Master Summary) contains 60 columns including VENDORID, HIESTBAL, CURRBLNC....
SQL Query Builder
60 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| VENDORID | Vendor ID | String | 16 | |
| HIESTBAL | Highest Balance | Currency | 10 | |
| CURRBLNC | Current Balance | Currency | 10 | |
| NOINVYTD | Number of Invoices YTD | Long Integer | 4 | |
| NOINVLIF | Number of Invoices LIFE | Long Integer | 4 | |
| NOINVLYR | Number of Invoices LYR | Long Integer | 4 | |
| NOPINYTD | Number of Paid Invoices YTD | Long Integer | 4 | |
| NOPILIFE | Number of Paid Invoices LIFE | Long Integer | 4 | |
| AMBLDTYD | Amount Billed YTD | Currency | 10 | |
| AMBLDLIF | Amount Billed LIFE | Currency | 10 | |
| AMBLDLYR | Amount Billed LYR | Currency | 10 | |
| AMTPDYTD | Amount Paid YTD | Currency | 10 | |
| AMTPDLIF | Amount Paid LIFE | Currency | 10 | |
| AMTPDLYR | Amount Paid LYR | Currency | 10 | |
| TEN99AYTD | 1099 Amount YTD | Currency | 10 | |
| TEN99ALIF | 1099 Amount LIFE | Currency | 10 | |
| TEN99ALYR | 1099 Amount LYR | Currency | 10 | |
| DISAVYTD | Discount Available YTD | Currency | 10 | |
| DISAVLIF | Discount Available LIFE | Currency | 10 | |
| DISAVLYR | Discount Available LYR | Currency | 10 | |
| DISTKYTD | Discount Taken YTD | Currency | 10 | |
| DISTKNLF | Discount Taken LIFE | Currency | 10 | |
| DISTKLYR | Discount Taken LYR | Currency | 10 | |
| DISLSYTD | Discount Lost YTD | Currency | 10 | |
| DISLSTLF | Discount Lost LIFE | Currency | 10 | |
| DISLSLYR | Discount Lost LYR | Currency | 10 | |
| FINCHLIF | Finance Charge LIFE | Currency | 10 | |
| FINCHLYR | Finance Charge LYR | Currency | 10 | |
| FINCHYTD | Finance Charge YTD | Currency | 10 | |
| WROFSYTD | Write Offs YTD | Currency | 10 | |
| WROFSLIF | Write Offs LIFE | Currency | 10 | |
| WROFSLYR | Write Offs LYR | Currency | 10 | |
| RTRNSYTD | Returns YTD | Currency | 10 | |
| RTRNSLIF | Returns LIFE | Currency | 10 | |
| RTRNSLYR | Returns LYR | Currency | 10 | |
| TRDTKLIF | Trade Discounts Taken LIFE | Currency | 10 | |
| TRDTLYR | Trade Discounts Taken LYR | Currency | 10 | |
| TRDTYTD | Trade Discounts Taken YTD | Currency | 10 | |
| NFNCHLIF | Number of Finance Charges LIFE | Long Integer | 4 | |
| NFNCHLYR | Number of Finance Charges LYR | Long Integer | 4 | |
| NFNCHYTD | Number of Finance Charges YTD | Long Integer | 4 | |
| RTNGOWED | Retainage Owed | Currency | 10 | |
| LSTCHNUM | Last Check Number | String | 22 | |
| LSTCHKDT | Last Check Date | Date | 4 | |
| LSTCHAMT | Last Check Amount | Currency | 10 | |
| LSTINNUM | Last Invoice Number | String | 22 | |
| LSTINVAM | Last Invoice Amount | Currency | 10 | |
| LSTPURDT | Last Purchase Date | Date | 4 | |
| FSTPURDT | First Purchase Date | Date | 4 | |
| CURUNPBN | Current Unapplied Payment Balance | Currency | 10 | |
| UNPDFNCH | Unpaid Finance Charges | Currency | 10 | |
| DYCHTCLR | Days Checks To Clear | Integer | 2 | |
| AVGDTPYR | Average Days To Pay - Year | Integer | 2 | |
| AVDTPLIF | Average Days To Pay - Life | Integer | 2 | |
| ACCRDINV | Accured Inventory | Currency | 10 | |
| ONORDAMT | On Order Amount | Currency | 10 | |
| WITHYTD | Withholding YTD | Currency | 10 | |
| WITHLYR | Withholding LYR | Currency | 10 | |
| Withholding_LIFE | Withholding LIFE | Currency | 10 | |
| PrepaymentAmount | Prepayment Amount | Currency | 10 |
Related Tables
Tables that share columns with PM00201. Click "Join" to add to your query.