CON_CONTRACT.sql 2.14 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50
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
51 52 53 54 55 56 57 58
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
59 60 61 62 63
is '是否缩期';

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