Kay,
JobBin is not a table in Epicor. It is a 'special' table used in the RDD for the Crystal Report. It looks like they are using this 'table' as away to link PartBin or PartBinInfo with a Job. Honestly, I don't understand why they are doing it, it looks like a Job Pick List could be developed without such weirdness. I thought perhaps it has something to do with Job Allocations, but I don't see any evidence of that since I would think the PartAlloc table could be used for that. I'm sure they have their reasons, but I'm sure you can develop what you need without it.
-Rick Bird
IT Software Administrator
Rowmark, LLC.
JobBin is not a table in Epicor. It is a 'special' table used in the RDD for the Crystal Report. It looks like they are using this 'table' as away to link PartBin or PartBinInfo with a Job. Honestly, I don't understand why they are doing it, it looks like a Job Pick List could be developed without such weirdness. I thought perhaps it has something to do with Job Allocations, but I don't see any evidence of that since I would think the PartAlloc table could be used for that. I'm sure they have their reasons, but I'm sure you can develop what you need without it.
-Rick Bird
IT Software Administrator
Rowmark, LLC.
--- In vantage@yahoogroups.com, "kayd.indaco" <kay.d@...> wrote:
>
> I'm trying to write a BAQ but can't find all of the information needed.
>
> Vantage has a JOB PICK LIST report that is pulling information from JobAsmbl, JobMtl, and JobBin. The information we need comes from what they're calling "JobBin" but I can't find it in the Data Dictionary. It has the lot's on hand quantity and the lot number.
>
> Can anyone tell me what JobBin is or where to get this information?
>
> Thanks in advance for any help.
>
> Kay Doolin
> Indaco Metals LLC
>