PrimBin Field Table

StephenW · October 7, 2024, 5:36pm

Hi All,

For the life of me I canot find what table the primbin field is in for Part-Sites-Warehouse-Primary Bin.

I’ve looked in Partwhse, partbin, partbininfo, partplant, and more, could please tell me where it is?

bruce6s · October 7, 2024, 5:40pm

Try PlantWhse.

JMPCONJ · October 7, 2024, 5:43pm

Winner winner chicken dinner. Data dictionary even explains why it’s in it’s own table.

StephenW · October 7, 2024, 5:46pm

Yes, field help was telling me it was under partwhse…

JMPCONJ · October 7, 2024, 5:48pm

Probably was/is in a previous version - maybe before they added multisite/plant support?

saundersn · October 7, 2024, 7:01pm

DataViews in Application Studio have a tendency to pull stuff in from many tables and then calculate fields that sometimes seem like they would exist somewhere like partbin, but they do not. I have this problem sometimes myself.