drop table t204_ap_detail  
/
create table t204_ap_detail  
( f_vndr_x                 char(20)       not null
, f_po_n                   char(09)       not null
, f_fypd                   char(06)       not null
, f_vndr_n                 char(09)       not null
, f_doc_n                  char(10)       not null
, f_loc_c                  char(02)       not null
, f_div_c                  char(02)       not null
, f_prmacct_c              char(04)       not null
, f_subacct_c              char(03)       not null
, f_dpt_c                  char(04)       not null
, f_txn_a                  decimal(15,2)  not null
)
/
grant select on t204_ap_detail to commbill_user;
/
exit;
