Is there a back end table for bpms written?

Epicor version: 9.05.701

Just curious to know if there is a table for a list of all the BPM’s written and maybe even customisations?

That would be really useful to know.

Thanks in advance.

Hey there. I am using Vantage and there are a few tables that are used for BPMs in our environment:

  • bpaction
  • bpactiondata
  • bpactiongroup
  • bpactionqueue
  • bpactionqueuedata
  • bpactionsrc
  • bparguement
  • bparguementtypedef
  • bpbaseprodirective …

There are about 22 in total (I think). I don’t know about customisation’s

Don’t know if this will help, but when I am looking for a certain field and don’t know which table it is in I use this query:

USE [database name here]
SELECT AS table_name,
SCHEMA_NAME(schema_id) AS schema_name, AS column_name
FROM sys.tables AS t
WHERE LIKE ‘%[Column to look for]%’
ORDER BY schema_name, table_name;

Maybe that could help you with what you’re looking for.

1 Like

I like to use the Solution Manager to quickly see all of my bpms, customizations, reports, etc. You need to make a new one and save it for it to populate the tabs.


Thanks for your help guys, sorry for the delay.

Just exported the data tables into excel and it seems theres quite a few to work through:

Hi Rowley:

There are 3 tables from that list that will give you what you are looking for ( BPM’s created in Epicor). the other tables are the methods, conditions and actions listing etc.

  1. BpBaseProcDirective
  2. BpPostProcDirective
  3. BpPreProcDirective