/*
================================================================================
档案代号:bhc_file
档案名称:分摊基础设定档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table bhc_file
(
bhc01       varchar2(10) NOT NULL,   /*部门                                   */
bhc02       varchar2(6) NOT NULL,    /*分摊类别                               */
bhc03       number(5) NOT NULL,      /*项次                                   */
bhc04       varchar2(24) NOT NULL,   /*会计科目                               */
bhc05       varchar2(10) NOT NULL,   /*被分摊部门                             */
bhc06       varchar2(1),             /*No Use                                 */
bhc07       number(15,3)             /*分摊基础                               */
);

create unique index bhc_pk on bhc_file (bhc01,bhc02,bhc03,bhc04,bhc05);
alter table bhc_file add  constraint bhc_pk primary key  (bhc01,bhc02,bhc03,bhc04,bhc05) enable validate;
grant select on bhc_file to public;
grant index on bhc_file to public;
grant update on bhc_file to public;
grant delete on bhc_file to public;
grant insert on bhc_file to public;