Table fields for who and when a Part was entered

Epicor ERP 10
1

Anyone knows what table fields store the info for who and when a Part was entered by or last modified by.

Thanks.

2

The Data Dictionary is your friend. It has all the fields. Search for it on the Menu.

Mark W.

3

Yes, PartAudit table has the info, but it doesn’t record info for all the parts.

4

Part Table - ChangedOn, CreatedOn, CreatedBy?

5

Are there those fields in Table Part. I can not find/see them.

6

Yes, they are in the Part table.

Depending on how parts got into the system, they might not always be populated though.

7

Below is what I saw. There is no those fields you mentioned. We created all the parts manually

image
image.png2399×1600 935 KB

8

I wonder what version you are on?
Or if you might have some security getting in the way?

image
image.png913×408 21 KB

9

Looking through the schema changes, it says they added those fields to PartRev in 10.2.100. I can’t find anywhere that mentions that part table, but clearly, it must have been added between 10.1.500 and 10.2.xxx

10

Thanks a lot. I can’t see the fields on my version10.500.7

11

I would just set up the change log then. That should get whatever you need.

12

Thanks again. It would be greatly appreciated if you tell me how to set up the change log. Also would it affect Epicor performance?

13

It’s laid out very clearly in the help files.

And yes, adding too many change logs will slow down Epicor, but usually not too badly. It’s about trade offs. Don’t go wild and you should be fine.

14

The change logs can be hard to report against. You may consider creating a BPM that runs when a new part is created to populate two user defined fields - created by and created date. I did this on 10.0.700.x and 10.1.500.x. It was an enhancement request that made it into the product in 10.2.