drop table temp_cb_gl
/
create table temp_cb_gl
    ( f_fypd          char(6)         NOT NULL
    , a_seq_n         int             NOT NULL
    , f_jv_n          char(10)            NULL
    , f_acct_x        char(30)            NULL
    , f_jvsrc_c       char(20)            NULL
    , f_jv_a          decimal(15,2)       NULL
    , f_jv_x          char(50)            NULL
    , f_jvent_d       char(6)             NULL
    , f_jv_d          char(3)             NULL
    , f_jv_t          char(4)             NULL
    , f_usrfld1_x     char(30)            NULL
    )
/
grant select on temp_cb_gl    to commbill_user
/
insert into temp_cb_gl
select * from t204_cb_gl
/
exit;
