alter table yrbgmaster add membtype_level number(2);
alter table yrdivmaster add shop1 number(15,2);
alter table yrdivmaster add shop2 number(15,2);
alter table yrdivmaster add oil number(15,2);

alter table yrdivmaster add  shrbegin_amt number(10,2);   
alter table yrdivmaster add  intbegin_amt number(10,2);  

CREATE TABLE "YRLOANTYPE" ("CALAVG_FLAG" NUMBER(5,0), "LOANTYPE_CODE" VARCHAR2(10) NOT NULL, "AVGPERCENT_RATE" NUMBER(5,2)) ;
ALTER TABLE "YRLOANTYPE" ADD ( CONSTRAINT TTTYYYY55 PRIMARY KEY ( "LOANTYPE_CODE" )) ;