OpenSync

Home Forums OpenSync should you include all the header in detail table?

This topic contains 0 replies, has 1 voice, and was last updated by  nguyen_uniz 5 months, 3 weeks ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #65489

    nguyen_uniz
    Participant

    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)

You must be logged in to reply to this topic.