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 '承租人变更日';