drop table t204_tb_ccdata
/
create table t204_tb_ccdata
    ( f_fypd           char(06)        NOT NULL
    , a_ccard_n        char(10)        NOT NULL
    , f_call_n         char(12)            NULL
    , f_city_x         char(12)            NULL
    , f_call_d         char(10)            NULL
    , f_call_t         char(5)             NULL
    , f_cmin_n         decimal(5,0)        NULL
    , f_csec_n         decimal(5,0)        NULL
    , f_call_a         decimal(15,4)       NULL
    , f_from_n         char(12)            NULL
    , f_fcity_x        char(12)            NULL
    , a_uid_c          char(8)             NULL
    , a_badge_n        char(8)             NULL
    , a_uid_x          char(30)            NULL
    , f_loc_c          char(02)            NULL
    , f_div_c          char(02)            NULL
    , f_dpt_c          char(04)            NULL
    , f_billed_i       char(01)            NULL
    , db_upd_d         char(10)            NULL
    )
/
grant select on t204_tb_ccdata    to commbill_user
/
exit;
