Trying to figure out primary bin number PartWhse.PrimBinNum

Epicor ERP 10
1

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!

2

Do you know how to make a BAQ?

3

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.

11 Likes
4

Thanks @tsmith - I spent an hour yesterday trying to find it. Should have started here first.

1 Like
5

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?

1 Like
6

Thanks for the schema. I’m trying to figure out default warehouse which is elusive.

7

@tpynepeak PartPlant.PrimWhse is the Primary Warehouse for a Part. Default warehouse is in the site configuration.

8

Many thanks! I was able to pull that into a query for a DMT file =)