/*
================================================================================
档案代号:bhe_file
档案名称:会计科目维护作业
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table bhe_file
(
bhe00       varchar2(1) NOT NULL,    /*性质                                   */
                                     /*性质 1产品别 2.客户 3.厂商             */
bhe01       varchar2(40) NOT NULL,   /*产品别/客户/厂商                       */
bhe02       varchar2(24),            /*销货收入科目                           */
bhe03       varchar2(24),            /*销货成本科目                           */
bhe04       varchar2(24),            /*存货科目科目                           */
bhe05       varchar2(24),            /*No Use                                 */
bhe06       varchar2(24)             /*应付/应收帐款科目                      */
);

create unique index bhe_pk on bhe_file (bhe00,bhe01);
alter table bhe_file add  constraint bhe_pk primary key  (bhe00,bhe01) enable validate;
grant select on bhe_file to public;
grant index on bhe_file to public;
grant update on bhe_file to public;
grant delete on bhe_file to public;
grant insert on bhe_file to public;