I need some help understanding PartDtl.
Ultimately, I’m trying to see demand for subassembly part numbers (which isn’t natively available in Time Phase). When running a BAQ against PartDtl, I receive practically no “JA” SourceFile records (4 out of 8000 resulting rows).
Looking at a particular job, we’re making the top level part (assembly) and it has (10) subassemblies. Only (5) of these show up in my “wide open” BAQ query against PartDtl (no filters/criteria)… and they only show up as “Sub” types because they contain sub-contract operations against them. The other (5) don’t show up at all because they don’t have subcontract operations.
I’ve been trying to scrutinize the (4) resulting rows which DO come from the JobAsmbl SourceFile to see what is different about them, but I can’t see anything blatant. Even looking at those, one is on a job with 5 other subassemblies, but it is the only one that hit this “JA” SourceFile.
Does anybody have any insight on how this all works?
I’ve seen a lot of older posts on here with people trying to re-create Time Phase in a BAQ. I don’t really need that… I just want to see demand for parts being produced as subassemblies on jobs, but they won’t come in from the JA SourceFile. I’m trying to figure out how that is populated and why some parts/jobs/methods would hit it an not others.