Your opinion about storing invoice line items as a list rather than records

[Das Goravani]

What’s your opinion about

Line items of an invoice

store them as a complete list in the invoice header, store a list with each invoice

or store them as small records, each line item is a record



only advantage I can see for line item records is that you can search up what invoices a certain product appeared on real fast, but that’s not that common of a search request


seems to me you can safely store the invoice line items in one list in the invoice header


das goravani