/*
================================================================================
档案代号:bnj_file
档案名称:委外工单年度结存档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table bnj_file
(
bnj01       varchar2(16) NOT NULL,   /*工单号码                               */
bnj02       number(15,3) NOT NULL    /*生产数量-结存入库量                    */
);

create unique index bnj_pk on bnj_file (bnj01);
alter table bnj_file add  constraint bnj_pk primary key  (bnj01) enable validate;
grant select on bnj_file to public;
grant index on bnj_file to public;
grant update on bnj_file to public;
grant delete on bnj_file to public;
grant insert on bnj_file to public;