The Invoice Line Detail table has the detail lines of an invoice, but doesn’t have the header of invoice like Date, Customer Name, RefNumber. That will be convinience if those headers are included in the detail line table, no need to inner join to Invoice table.
For example, if I want to find what products were purchased by a specific customer type throughout a period, I have to inner join 3 tables: customer, invoice and invoicelinedetail.
same thing with Purchase Order table or Sales Order Table or Sales Receipt table.
Viewing 1 post (of 1 total)
The forum ‘OpenSync’ is closed to new topics and replies.