drop table t204_ool_history
/
create table t204_ool_history
     ( f_fypd              char(06)              not null
     , a_phone_n           char(12)              not null
     , a_phone_i           char(04)              not null
     , a_badge_n           char(10)              not null
     , a_uid_x             char(40)              not null
     , f_ser_n             char(18)              not null
     , f_inv_n             char(25)              not null
     , f_mod_n             char(08)              not null
     , f_srv_d             char(08)              not null
     , f_rtn_d             char(08)              not null
     , f_cctr_c            char(06)              not null
     , f_ba_c              char(04)              not null
     , a_sapid_n           char(08)              not null
     , f_cmnt_x            char(50)              not null
     , f_loc_c             char(02)              null
     , f_div_c             char(02)              null
     , f_dpt_c             char(04)              null
     )
/
grant select on t204_ool_history to commbill_user
/
exit;
