#日結算表添加商戶信息 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 '機構名稱';