I figured it out. I had to take a step back from the existing model supplied to me by EDA consultants (f_Purchasing).
Instead, I went back to the basics and identified what fields I needed, established the granularity and then built out a model using an ER diagram tool. Starting simple was the key.
