In the Job Status Report Data Definition a data source is called “JCR40”. What is this? It is not mentioned in the Data Dictionary, nor can I find it anywhere in the DB.
Reason I ask, the part description being printed on our Job Status Report does not line up with the part description listed in the job. The stock report references this JCR40 table, but beyond that I have no clue what this is.
Adam,
I heard back from Epicor support. JCR40 is a temp table. It can’t be modified. It’s apparently used specifically for the Job Status Report. I tried using that RDD with other tables and fields added. I haven’t been able to make it work correctly, but apparently should be able to do it.
I think I am going to just redo the report the way I want it from scratch.