Notifications
Clear all

Invoice Line item


Posts: 8
Topic starter
(@cornepotgieter)
Active Member
Joined: 1 year ago

Hi all

I know a variation of this question has been asked before, but I would like to get some clarity on all the different approaches and whether they are valid from a DV2 perspective. Perhaps PROS and CONS.

If one has an Invoice with a line item, as well as a Customer on the Invoice (so basically at header level). 

The link exists on Invoice (HUB invoice) as well as Customer (HUB Customer), so I would think that in this case you need to create the Link between HUB_INVOICE and HUB_CUSTOMER, however the descriptive information about the sale (lets say quantity) is at Invoice line item level. 

Which one of these options is most suited?

Can I create a satellite with Invoice line item as "sub-sequence"? I.e. additional primary key on satellite whilst keeping the business key as Invoice?

OR 

Should one create a link between Invoice and Customer with Line item as dependent child, even though the grain is not at line item level?

OR

Are there other alternatives? 

 

Thanks

Reply
5 Replies