gertjano
Member
Hi All,
I am building a relational model on top of JDE data. Main aim is to collect all Purchase orders and their corresponding links to the Agreements.
I struggle with the relation between the PO details F4311 and the link to the Agreement Quantities F38011.
The link is on F4311.PDDMCT = F38011.DFDMCT and F4311.PDDMCS = F38011.DFDMCS
But the issue is that the F38011 has an extra column in the primary key, DFSEQ Sequence Number
Anybody has a clue how to interpretate this Sequence Number ?
I am now not able to make the link unique due to this Sequence Number
Similar thing I have with table F38111 on DZUKID Unique Key ID (Internal)
All input is more than welcome/appreciated
I am building a relational model on top of JDE data. Main aim is to collect all Purchase orders and their corresponding links to the Agreements.
I struggle with the relation between the PO details F4311 and the link to the Agreement Quantities F38011.
The link is on F4311.PDDMCT = F38011.DFDMCT and F4311.PDDMCS = F38011.DFDMCS
But the issue is that the F38011 has an extra column in the primary key, DFSEQ Sequence Number
Anybody has a clue how to interpretate this Sequence Number ?
I am now not able to make the link unique due to this Sequence Number
Similar thing I have with table F38111 on DZUKID Unique Key ID (Internal)
All input is more than welcome/appreciated