PM00202 - PM Vendor Master Period Summary
Dynamics GP table PM00202 (PM Vendor Master Period Summary) contains 17 columns including VENDORID, PERIODID, YEAR1....
SQL Query Builder
17 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| VENDORID | Vendor ID | String | 16 | |
| PERIODID | Period ID | Integer | 2 | |
| YEAR1 | Year | Integer | 2 | |
| HISTTYPE | History Type | Integer | 2 | |
| AMBLDLIF | Amount Billed LIFE | Currency | 10 | |
| AMTPDLIF | Amount Paid LIFE | Currency | 10 | |
| TEN99ALIF | 1099 Amount LIFE | Currency | 10 | |
| DISAVLIF | Discount Available LIFE | Currency | 10 | |
| DISTKNLF | Discount Taken LIFE | Currency | 10 | |
| DISLSTLF | Discount Lost LIFE | Currency | 10 | |
| FINCHLIF | Finance Charge LIFE | Currency | 10 | |
| WROFSLIF | Write Offs LIFE | Currency | 10 | |
| RTRNSLIF | Returns LIFE | Currency | 10 | |
| TRDTKLIF | Trade Discounts Taken LIFE | Currency | 10 | |
| NFNCHLIF | Number of Finance Charges LIFE | Long Integer | 4 | |
| NOINVLIF | Number of Invoices LIFE | Long Integer | 4 | |
| Withholding_LIFE | Withholding LIFE | Currency | 10 |
Related Tables
Tables that share columns with PM00202. Click "Join" to add to your query.