aklast/ALTER TABLE AR_CALC_BONUS_BS CHANGE COLU.sql

ALTER TABLE AR_CALC_BONUS_BS CHANGE COLUMN ORI_BONUS_BU_YJ  ORI_BONUS_ABBR decimal(16,3) not null default 0.000 comment "蓝星业绩奖，原奖金";
ALTER TABLE AR_CALC_BONUS_BS CHANGE COLUMN ORI_BONUS_BU_YJKC  MANAGE_TAX_ABBR decimal(16,3) not null default 0.000 comment "蓝星业绩奖，管理费";
ALTER TABLE AR_CALC_BONUS_BS CHANGE COLUMN ORI_BONUS_BU_YJSF  AMOUNT_ABBR decimal(16,3) not null default 0.000 comment "蓝星业绩奖，实发奖金";
ALTER TABLE AR_CALC_BONUS_BS CHANGE COLUMN ORI_BONUS_BU_YJFX  ABBR_RECONSUME_POINTS decimal(16,3) not null default 0.000 comment "蓝星业绩奖，复效积分";
ALTER TABLE AR_CALC_BONUS_BS CHANGE COLUMN ORI_BONUS_BU_GL  ORI_BONUS_MNT decimal(16,3) not null default 0.000 comment "蓝星管理奖，原奖金";
ALTER TABLE AR_CALC_BONUS_BS CHANGE COLUMN ORI_BONUS_BU_GLKC  MANAGE_TAX_MNT decimal(16,3) not null default 0.000 comment "蓝星管理奖，管理费";
ALTER TABLE AR_CALC_BONUS_BS CHANGE COLUMN ORI_BONUS_BU_GLSF  AMOUNT_MNT decimal(16,3) not null default 0.000 comment "蓝星管理奖，实发奖金";
ALTER TABLE AR_CALC_BONUS_BS CHANGE COLUMN ORI_BONUS_BU_GLFX  MNT_RECONSUME_POINTS decimal(16,3) not null default 0.000 comment "蓝星管理奖，复效积分";
ALTER TABLE AR_CALC_BONUS_BS_DETAIL CHANGE COLUMN ORI_BONUS_BU_YJ  ORI_BONUS_ABBR decimal(16,3) not null default 0.000 comment "蓝星业绩奖，原奖金";
ALTER TABLE AR_CALC_BONUS_BS_DETAIL CHANGE COLUMN ORI_BONUS_BU_YJSF  AMOUNT_ABBR decimal(16,3) not null default 0.000 comment "蓝星业绩奖，实发奖金";
ALTER TABLE AR_CALC_BONUS_BS_DETAIL CHANGE COLUMN ORI_BONUS_BU_GL  ORI_BONUS_MNT decimal(16,3) not null default 0.000 comment "蓝星管理奖，原奖金";
ALTER TABLE AR_CALC_BONUS_BS_DETAIL CHANGE COLUMN ORI_BONUS_BU_GLSF  AMOUNT_MNT decimal(16,3) not null default 0.000 comment "蓝星管理奖，实发奖金";
ALTER TABLE AR_CALC_BONUS_BS_STAT CHANGE COLUMN BONUS_BU_YJ  BONUS_ABBR decimal(12,2) default 0.00 comment "蓝星业绩奖";
ALTER TABLE AR_CALC_BONUS_BS_STAT CHANGE COLUMN BONUS_BU_YJ_PERCENT  BONUS_ABBR_PERCENT decimal(12,2) default 0.00 comment "蓝星业绩奖，拨比";
ALTER TABLE AR_CALC_BONUS_BS_STAT CHANGE COLUMN BONUS_BU_GL  BONUS_MNT decimal(12,2) default 0.00 comment "蓝星管理奖";
ALTER TABLE AR_CALC_BONUS_BS_STAT CHANGE COLUMN BONUS_BU_GL_PERCENT  BONUS_MNT_PERCENT decimal(12,2) default 0.00 comment "蓝星管理奖，拨比";
ALTER TABLE AR_CALC_BONUS CHANGE COLUMN ORI_BONUS_BU_YJ  ORI_BONUS_ABBR decimal(16,3) not null default 0.000 comment "蓝星业绩奖，原奖金";
ALTER TABLE AR_CALC_BONUS CHANGE COLUMN ORI_BONUS_BU_YJSF  BONUS_ABBR decimal(16,3) not null default 0.000 comment "蓝星业绩奖，实发奖金";
ALTER TABLE AR_CALC_BONUS CHANGE COLUMN ORI_BONUS_BU_GL  ORI_BONUS_MNT decimal(16,3) not null default 0.000 comment "蓝星管理奖，原奖金";
ALTER TABLE AR_CALC_BONUS CHANGE COLUMN ORI_BONUS_BU_GLSF  BONUS_MNT decimal(16,3) not null default 0.000 comment "蓝星管理奖，实发奖金";





存储过程需改： 
CALCKEEP 
    32到39行修改 为: 
        ORI_BONUS_ABBR,
        MANAGE_TAX_ABBR,
        AMOUNT_ABBR,
        ABBR_RECONSUME_POINTS,
        ORI_BONUS_MNT,
        MANAGE_TAX_MNT,
        AMOUNT_MNT,
        MNT_RECONSUME_POINTS
    110到115行 修改为： 
        ORI_BONUS_ABBR,

        AMOUNT_ABBR,
        ORI_BONUS_MNT,

        AMOUNT_MNT

CALCSTAT
    31到34行修改
        BONUS_ABBR,
		BONUS_ABBR_PERCENT,
		BONUS_MNT,
		BONUS_MNT_PERCENT
    82到83行修改
        BONUS_ABBR_PERCENT = BONUS_ABBR / TOTAL_PV,
	    BONUS_MNT_PERCENT = BONUS_MNT /TOTAL_PV