PM00100 - PM Class Master File
Dynamics GP table PM00100 (PM Class Master File) contains 52 columns including VNDCLSID, VNDCLDSC, DEFLTCLS....
SQL Query Builder
52 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| VNDCLSID | Vendor Class ID | String | 12 | ||
| VNDCLDSC | Vendor Class Description | String | 32 | ||
| DEFLTCLS | Default Class | Boolean | 2 | ||
| MXIAFVND | Maximum Invoice Amount For Vendors | Integer | 2 | ||
| MXINVAMT | Maximum Invoice Amount | Currency | 10 | ||
| WRITEOFF | Writeoff | Integer | 2 | ||
| CREDTLMT | Credit Limit | Integer | 2 | ||
Credit Limit Type values (3) 0 = No Credit1 = Unlimited2 = Amount (see CRLMTDLR) | |||||
| TEN99TYPE | 1099 Type1 – Not a 1099 vendor2 – Dividend3 – Interest4 - Miscellaneous | Integer | 2 | ||
1099 Type values (5) 1 = Not a 1099 Vendor2 = Dividend3 = Interest4 = Miscellaneous5 = Nonemployee Compensation | |||||
| PTCSHACF | Post To Cash Account From | Integer | 2 | ||
| MXWOFAMT | Maximum Write Off Amount | Currency | 10 | ||
| MINORDER | Minimum Order | Currency | 10 | ||
| CRLMTDLR | Credit Limit Dollar | Currency | 10 | ||
| PYMNTPRI | Payment Priority | String | 4 | ||
| SHIPMTHD | Shipping Method | String | 16 | ||
| PYMTRMID | Payment Terms ID | String | 22 | ||
| MINPYTYP | Minimum Payment Type | Integer | 2 | ||
| MINPYDLR | Minimum Payment Dollar | Currency | 10 | ||
| MINPYPCT | Minimum Payment Percent | Integer | 2 | ||
| CURNCYID | Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. | String | 16 | ||
| TAXSCHID | Tax Schedule ID | String | 16 | ||
| KPCALHST | Keep Calendar History | Boolean | 2 | ||
| KGLDSTHS | Keep GL Dist History | Boolean | 2 | ||
| KPERHIST | Keep Period History | Boolean | 2 | ||
| KPTRXHST | Keep Trx History | Boolean | 2 | ||
| TRDDISCT | Trade Discount | Integer | 2 | ||
| USERDEF1 | User Defined 1 | String | 22 | ||
| USERDEF2 | User Defined 2 | String | 22 | ||
| PMAPINDX | PM AP Index | Long Integer | 4 | ||
| PMCSHIDX | PM Cash Index | Long Integer | 4 | ||
| PMDAVIDX | PM Discount Available Index | Long Integer | 4 | ||
| PMDTKIDX | PM Discount Taken Index | Long Integer | 4 | ||
| PMFINIDX | PM Finance Charge Index | Long Integer | 4 | ||
| PMMSCHIX | PM Misc Charges Index | Long Integer | 4 | ||
| PMFRTIDX | PM Freight Index | Long Integer | 4 | ||
| PMTAXIDX | PM Tax Index | Long Integer | 4 | ||
| PMWRTIDX | PM Write Offs Index | Long Integer | 4 | ||
| PMPRCHIX | PM Purchases Index | Long Integer | 4 | ||
| PMRTNGIX | PM Retainage Index | Long Integer | 4 | ||
| PMTDSCIX | PM Trade Discount Index | Long Integer | 4 | ||
| ACPURIDX | Accrued Purchases Index | Long Integer | 4 | ||
| PURPVIDX | Purchase Price Variance Index | Long Integer | 4 | ||
| CHEKBKID | Checkbook ID | String | 16 | ||
| MODIFDT | Modified Date | Date | 4 | ||
| CREATDDT | Created Date | Date | 4 | ||
| RATETPID | Rate Type ID | String | 16 | ||
| Revalue_Vendor | Revalue Vendor | Boolean | 2 | ||
| Post_Results_To | Post Results To | Integer | 2 | ||
| FREEONBOARD | Free On Board | Integer | 2 | ||
| DISGRPER | Discount Grace Period | Integer | 2 | ||
| DUEGRPER | Due Date Grace Period | Integer | 2 | ||
| TaxInvRecvd | Tax Invoice Received | Boolean | 2 | ||
| CBVAT | Cash Based VAT | Boolean | 2 | ||
Related Tables
Tables that share columns with PM00100. Click "Join" to add to your query.