15
This might be a weird question but is there a report that can be run of all available class IDs with their field information? We have over a thousand and really want to do a deep clean, but it will be brutal to just go into them one at a time.
Thank you!
Using SSMS, this will get you a list of vendors and their class IDs.
SELECT [VENDORID],[VENDNAME],[VNDCLSID] FROM [dbo].[PM00200] ORDER BY VENDORID
This will get you a list of class IDs.
SELECT [VNDCLSID],[VNDCLDSC] FROM [dbo].[PM00100] ORDER BY VNDCLSID
These are vendor class IDs.
You can always make your own report.
Which Class ID?
User, Item, Vendor, Customer, etc.
Regards
David
#1
André Arnaud de Cal...
294,351
Super User 2025 Season 1
#2
Martin Dráb
233,029
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
