_1548.sliding_fee_scale_breakpoint_values

Field Type Null Default Key Extra Comment
sfsbv_id int(11) NO PRI auto_increment
sfsbv_cus_id int(11) NO MUL Customer Id
sfsbv_cli_id int(11) NO MUL Client Id
sfsbv_sfs_id int(11) NO MUL Sliding Fee Scale Parent Id
sfsbv_value decimal(6,3) NO Breakpoint Value Percentage (Never > 999.9%, never < 100%)
sfsbv_discount_percentage decimal(4,3) NO Breakpoint Value Discount Percentage
sfsbv_discount_flat_fee varchar(10) NO Breakpoint Value Discount Flat Fee
sfsbv_disabled char(1) NO Disabled
sfsbv_modified datetime YES CURRENT_TIMESTAMP
sfsbv_created datetime YES CURRENT_TIMESTAMP
sfsbv_name varchar(20) NO user friendly name for break point

References

Local Column References