VATs |
![]() |
Click here to see the rules for VAT Calculation.
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 |