This was a general question from a client, so I'm not sure what tables she's interested in updating. But, I already told her about all the existing category code update programs I know about:
1. R01490 (Global Category Code Update) - this one may only work on the address book records; I am a bit leery since one version says "obsolete - do not use".
2. R01050 (Copy Category Codes to Customer Master) - helps keep the cat codes in the address book and customer master in sync. Most of my clients keep these cat codes in sync.
3. R03012A (Update Date Effective Category Codes) - in about E1 8.9 and later, there is a table for date-sensitive cat codes for the customer.
4. R41803 (Global Reporting Code Update) - this updates cat codes on the items.
5. R41804 (Item Master Global Update) - this will change a value in a specified item master cat code from "A" to "B" (set up in the processing options).
If you know of anything else, please let me know. Thanks!