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 "蓝星管理奖，实发奖金";