Discounts |
![]() |
Click here to see the rules for Discount Calculation.
Table tbl_discounts -- Discounts for products, discount classes, customers
Field name | Field description | Field type | Field size | key | required | default | Observation |
---|---|---|---|---|---|---|---|
code | Product code | VARCHAR | 100 | yes | yes | 0 | Linked to code from tbl_objects |
code_disc_class | Code article discount class | VARCHAR | 100 | yes | yes | 0 | Linked to code_disc_class from tbl_disc_class where type_class=o |
code_client_class | Code client discount class | VARCHAR | 100 | yes | yes | 0 | Linked to code_disc_class from tbl_disc_class where type_class=c |
cust_code | Customer code | VARCHAR | 20 | yes | yes | 0 | Linked to u_id/u_externalcode from tbl_users |
date_start | The start date to validate discount | DATE | yes | yes | 2000-01-01 | ||
date_end | The end date to validate discount | DATE | yes | 2100-01-01 | |||
qty_from | The start quantity to validate discount | DOUBLE | yes | yes | 0 | ||
qty_to | The end quantity to validate discount | DOUBLE | yes | 9999999999999 | |||
discount_1 | Discount 1 | DOUBLE | value between 0 and 100 | ||||
discount_2 | Discount 2 | DOUBLE | value between 0 and 100 | ||||
discount_3 | Discount 3 | DOUBLE | value between 0 and 100 | ||||
discount_4 | Discount 4 | DOUBLE | value between 0 and 100 | ||||
discount_5 | Discount 5 | DOUBLE | value between 0 and 100 | ||||
codtpro | Promotion code - feature not implemented | VARCHAR | 50 |
Table tbl_disc_class -- List of discount classes
Field name | Field description | Field type | Field size | key | required | default | Observation |
---|---|---|---|---|---|---|---|
code_disc_class | Code discount class | VARCHAR | 100 | yes | yes | 0 | |
type_class | Class type: o - article discount; c - client discount | CHAR | 1 | yes | yes | c | |
title_class | Class title | VARCHAR | 50 | yes | untitled | title, description, notes are only administrative information | |
descr_class | Class description | VARCHAR | 200 | ||||
notes_class | Class notes | VARCHAR | 255 | ||||
f_txt1 | -unused field; reserved for future implementations - | TEXT | |||||
f_txt2 | -unused field; reserved for future implementations - | TEXT | |||||
f_txt3 | -unused field; reserved for future implementations - | TEXT | |||||
f_int1 | -unused field; reserved for future implementations - | TINYINT | 3 | ||||
f_int2 | -unused field; reserved for future implementations - | TINYINT | 3 | ||||
f_txt3 | -unused field; reserved for future implementations - | TINYINT | 3 |