/*
================================================================================
档案代号:bha_file
档案名称:费用项目提拨单头档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table bha_file
(
bha01       varchar2(10) NOT NULL,   /*版本                                   */
bha02       number(5) NOT NULL,      /*年度                                   */
bha03       varchar2(6) NOT NULL,    /*费用项目                               */
bha04       number(5),               /*转换月基数                             */
bha05       number(20,6),            /*提拨后金额                             */
bhaacti     varchar2(1),             /*资料有效码                             */
bhauser     varchar2(10),            /*资料所有者                             */
bhagrup     varchar2(10),            /*资料所有部门                           */
bhamodu     varchar2(10),            /*资料修改者                             */
bhadate     date                     /*最近修改日                             */
);

create unique index bha_pk on bha_file (bha01,bha02,bha03);
alter table bha_file add  constraint bha_pk primary key  (bha01,bha02,bha03) enable validate;
grant select on bha_file to public;
grant index on bha_file to public;
grant update on bha_file to public;
grant delete on bha_file to public;
grant insert on bha_file to public;