drop table tf_vndr_c
/
create table tf_vndr_c
     ( f_vndr_c           char(10)              not null
     , f_vndr_i           char(10)              not null
     , f_vndr_x           char(30)              not null
     , f_loc_c            char(02)              not null
     , f_div_c            char(02)              not null
     , f_dpt_c            char(04)              not null
     , f_jv_x             char(04)              not null
     , f_vndr_p           decimal(3,2)          not null
     , f_vndr_a           decimal(15,2)         not null
     , f_dsn_x            char(25)              not null
     , f_batch_i          char(01)              not null
     )
/
grant all on tf_vndr_c to commbill_user
/
exit;
