VATs
Index of tables:

Click here to see the rules for VAT Calculation.

Table tbl_vat -- VAT values

Field name Field description Field type Field size key required default Observation
vat_categcode Code of VAT category VARCHAR 10 yes yes   Linked to vatc_code from tbl_vatcateg; if you fill this field, let vat_custcode=''
vat_custcode Customer code VARCHAR 20 yes yes   Linked to u_id/u_externalcode from tbl_users; if you fill this field, let vat_categcode=''
vat_prodcode Product code VARCHAR 50 yes yes   Linked to code from tbl_objects
vat_value VAT value DOUBLE     yes 0  

Table tbl_vatcateg -- VAT categories

Field name Field description Field type Field size key required default Observation
vatc_code Code of VAT category VARCHAR 10 yes yes    
vatc_title Name of VAT category VARCHAR 255        
vatc_note Aditional note about the VAT category TEXT