GBRSPEC & GBRLINK

Wes_D

Well Known Member
I joined F58740 (GBRLINK) and F58741 (GBRSPEC) by ELEVSK and ESEVSK. I'm getting over 340,000 records where the a record in F58741 doesn't have associated record in F58740. Is this normal or do I have orphaned records?

Thanks, Wes
 
I haven't done a similar test, but I think this is normal. NER Business functions header specs are not in the GBRLINK, but are instead in the JDEBLC. Therefore there will be detail NER BSFN records in the GBRSPEC, without a corresponding GBRLINK record. If you want to test this out, take the records that dont have a match and try to tie them out to the JDEBLC.

Aaron
 
Back
Top