• thagg
  • New member
  • Offline
  • Registered: 11/16/2008
  • Posts: 1

Topic: repeated fields in invoice tax items

Hi,
I am reviewing the structure of the FA database tables to see if I can insert data from a timesheet and billlling program I wrote in Gambas.  I noticed the x_supp_invoice_tax_items table has fields of tax_type_id, tax_type_name, and rate.  Aren't these fields already in the x_tax_types table?  Wouldn't the normalized x_supp_invoice_tax_items table have just the _id field, or am I missing something?

Travis

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,085

Re: repeated fields in invoice tax items

Hello Travis,
You are an observant user. You are partly right. The items can have several tax exempts. Therefore this was done, however, just these sections were done before we took over the project.
We are going to check these items before next release.

Thanks for your contribution.

/Joe