alter table CON_CONTRACT add DEPOIST_REMAINING_AMOUNT number;
comment on column CON_CONTRACT.DEPOIST_REMAINING_AMOUNT
is '保证金余额';

alter table CON_CONTRACT add REPURCHASE_TATAL_AMOUNT number;
comment on column CON_CONTRACT.REPURCHASE_TATAL_AMOUNT
is '回购价款总额';

alter table CON_CONTRACT add REPURCHASE_COUNT_AMOUNT number;
comment on column CON_CONTRACT.REPURCHASE_COUNT_AMOUNT
is '回购价款计算基数';

alter table CON_CONTRACT add REPURCHASE_SERVICE_CHARGES number;
comment on column CON_CONTRACT.REPURCHASE_SERVICE_CHARGES
is '回购手续费';

alter table CON_CONTRACT add FUND_POSSESSION_COST number;
comment on column CON_CONTRACT.FUND_POSSESSION_COST
is '资金占用费';

alter table CON_CONTRACT add REPURCHASE_INTEREST_RATE number;
comment on column CON_CONTRACT.REPURCHASE_INTEREST_RATE
is '回购利率';

alter table CON_CONTRACT add DEPOIST_OFFSET_FLAG varchar2(1);
comment on column CON_CONTRACT.DEPOIST_OFFSET_FLAG
is '保证金是否冲抵';

alter table CON_CONTRACT add PAYMENT_FREQUENCY varchar2(30);
comment on column CON_CONTRACT.PAYMENT_FREQUENCY
is '回购支付频率';

alter table CON_CONTRACT add PAYMENT_PERIOD varchar2(30);
comment on column CON_CONTRACT.PAYMENT_PERIOD
is '回购支付期数';

alter table CON_CONTRACT add SUM_RECEIVED_RENT_AMOUNT number;
comment on column CON_CONTRACT.SUM_RECEIVED_RENT_AMOUNT
is '已回收租金(回购)';

alter table CON_CONTRACT add SUM_UNRECEIVED_RENT_AMOUNT number;
comment on column CON_CONTRACT.SUM_UNRECEIVED_RENT_AMOUNT
is '剩余租金(回购)';

alter table CON_CONTRACT add SUM_OVERDUE_AMOUNT number;
comment on column CON_CONTRACT.SUM_OVERDUE_AMOUNT
is '逾期租金(回购)';

alter table CON_CONTRACT add SUM_UNRECEIVED_PRINCIPAL number;
comment on column CON_CONTRACT.SUM_UNRECEIVED_PRINCIPAL
is '剩余本金(回购)';

alter table CON_CONTRACT add extend_flag varchar2(1);
comment on column CON_CONTRACT.extend_flag
is '是否展期';

alter table CON_CONTRACT add deflation_flag varchar2(1);
comment on column CON_CONTRACT.deflation_flag
is '是否缩期';

alter table CON_CONTRACT add ccr_lease_date date;
comment on column CON_CONTRACT.ccr_lease_date
is '承租人变更日';