drop table t204_tb_dtbill
/
create table t204_tb_dtbill
   ( f_fypd           char(06)        NOT NULL 
   , a_phone_n        char(10)        NOT NULL 
   , a_auth_c         char(06)            NULL 
   , f_call_n         char(16)            NULL 
   , f_clen_n         decimal(5,0)        NULL 
   , f_call_d         char(08)            NULL 
   , f_call_t         char(06)            NULL 
   , f_chh_n          char(02)            NULL 
   , f_cmm_n          char(02)            NULL 
   , f_css_n          char(02)            NULL 
   , f_cdur_n         decimal(5,0)        NULL 
   , f_ctrunk_c       char(04)            NULL 
   , f_ac_i           char(02)            NULL 
   , f_call_x         char(12)            NULL 
   , f_city_x         char(20)            NULL 
   , f_st_c           char(02)            NULL 
   , f_call_a         decimal(15,2)       NULL 
   , f_loc_c          char(02)            NULL 
   , f_div_c          char(02)            NULL 
   , f_dpt_c          char(04)            NULL 
   , a_uid_c          char(08)            NULL 
   , a_badge_n        char(08)            NULL 
   , a_uid_x          char(30)            NULL 
   , f_from_n         char(16)            NULL 
   , f_call_i         char(1)             NULL 
   )

/
grant select on t204_tb_dtbill    to commbill_user
/
exit;
