antissoft / lvqianmeiye_ERP

添加健康师工资表升单人头数和提成金额字段.sql 775 Bytes
1 2 3 4 5 6 7 8 9 10 11 12 13 14 
-- 在健康师工资表中添加升单人头数、新客业绩提成金额、升单业绩提成金额字段

-- 添加升单人头数字段（放在F_NewCustomerPoint字段后面）
ALTER TABLE `lq_salary_statistics` 
ADD COLUMN `F_UpgradeCustomerCount` DECIMAL(18,2) DEFAULT 0.00 COMMENT '升单人头数' AFTER `F_NewCustomerPoint`;

-- 添加新客业绩提成金额字段
ALTER TABLE `lq_salary_statistics` 
ADD COLUMN `F_NewCustomerPerformanceCommission` DECIMAL(18,2) DEFAULT 0.00 COMMENT '新客业绩提成金额' AFTER `F_UpgradePoint`;

-- 添加升单业绩提成金额字段
ALTER TABLE `lq_salary_statistics` 
ADD COLUMN `F_UpgradePerformanceCommission` DECIMAL(18,2) DEFAULT 0.00 COMMENT '升单业绩提成金额' AFTER `F_NewCustomerPerformanceCommission`;