Anybody can help populate this data and where data is stored in the data base. Would like to have a BAQ with Site, Part, Whse and Primary BIn
Thanks!
Anybody can help populate this data and where data is stored in the data base. Would like to have a BAQ with Site, Part, Whse and Primary BIn
Thanks!
Do you know how to make a BAQ?
Primary bin is stored in Erp.PlantWhse.PrimBin. The business objects make it look like the field is in PartWhse, but the actual table (for SQL queries and BAQs) is PlantWhse.
Thanks @tsmith - I spent an hour yesterday trying to find it. Should have started here first.
Not sure where I got this but here is an PDF for part schema - V8.
Doesn’t have UOM Classes like newer version but otherwise about the same in E10, good enough for my use.
PartTables.pdf (59.5 KB)
Or if Epicor has any for E10?
I remember they had a really nice schema table for their old CRM package… made life a lot easier?
There also used to be some nice E9 schema in the file section of the old Yahoo Group. Created by DotNetIT - http://www.dotnetit.co.uk.
Now I wonder if they might have more current version, for public consumption?
Thanks for the schema. I’m trying to figure out default warehouse which is elusive.
@tpynepeak PartPlant.PrimWhse is the Primary Warehouse for a Part. Default warehouse is in the site configuration.
Many thanks! I was able to pull that into a query for a DMT file =)