/*
================================================================================
档案代号:bnz_file
档案名称:入库参数档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table bnz_file
(
bnz00       varchar2(1) NOT NULL,    /*KEY VALUE                              */
bnz01       varchar2(5),             /*入库单别不为                           */
bnz02       varchar2(5),             /*入库单别为进货单                       */
bnz03       varchar2(5),             /*出库单别为                             */
bnz04       varchar2(5)              /*抓放行单单别                           */
);

create unique index bnz_pk on bnz_file (bnz00);
alter table bnz_file add  constraint bnz_pk primary key  (bnz00) enable validate;
grant select on bnz_file to public;
grant index on bnz_file to public;
grant update on bnz_file to public;
grant delete on bnz_file to public;
grant insert on bnz_file to public;