Discounts
Index of tables:

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