#日结算表添加商户信息 t_daysettle alter table t_daysettle add source varchar2(2) DEFAULT 0; comment on column t_daysettle.source is '1是非支付结算中心，2是支付结算中心'; alter table t_daysettle add namechinese varchar2(200) DEFAULT null ; comment on column t_daysettle.namechinese is '商家名称'; alter table t_daysettle add settleaccountname varchar2(200) DEFAULT null ; comment on column t_daysettle.settleaccountname is '结算银行户名'; alter table t_daysettle add settlebank varchar2(200) DEFAULT null ; comment on column t_daysettle.settlebank is '结算银行'; alter table t_daysettle add settlebankname varchar2(200) DEFAULT null ; comment on column t_daysettle.settlebankname is '结算银行-支行'; alter table t_daysettle add settlebankid varchar2(200) DEFAULT null ; comment on column t_daysettle.settlebankid is '开户行'; alter table t_daysettle add tonbaojia_rakerate NUMBER(11,2) default 0; comment on column t_daysettle.tonbaojia_rakerate is '通宝+利率'; alter table t_daysettle add rakerate NUMBER(11,2) default 0; comment on column t_daysettle.rakerate is '利率'; alter table t_daysettle add servicerate NUMBER(11,2) default 0; comment on column t_daysettle.servicerate is '平台服务费'; alter table t_daysettle add nameenglish varchar2(200) DEFAULT null ; comment on column t_daysettle.nameenglish is '商户简称'; alter table t_daysettle add organization varchar2(200) DEFAULT null ; comment on column t_daysettle.organization is '机构名称'; #确定商家日结算同步信息表添加商户信息 t_finishsettle alter table t_finishsettle add source varchar2(2) DEFAULT null ; comment on column t_finishsettle .source is '1是非支付结算中心，2是支付结算中心'; alter table t_finishsettle add namechinese varchar2(200) DEFAULT null ; comment on column t_finishsettle.namechinese is '商家名称'; alter table t_finishsettle add settleaccountname varchar2(200) DEFAULT null ; comment on column t_finishsettle.settleaccountname is '结算银行户名'; alter table t_finishsettle add settlebank varchar2(200) DEFAULT null ; comment on column t_finishsettle.settlebank is '结算银行'; alter table t_finishsettle add settlebankname varchar2(200) DEFAULT null ; comment on column t_finishsettle.settlebankname is '结算银行-支行'; alter table t_finishsettle add settlebankid varchar2(200) DEFAULT null ; comment on column t_finishsettle.settlebankid is '开户行'; alter table t_finishsettle add nameenglish varchar2(200) DEFAULT null ; comment on column t_finishsettle.nameenglish is '商户简称'; alter table t_finishsettle add organization varchar2(200) DEFAULT null ; comment on column t_finishsettle.organization is '机构名称';