/*
================================================================================
档案代号:bwc_file
档案名称:保税工单盘点单身资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table bwc_file
(
bwc01       varchar2(10) NOT NULL,   /*标签编号                               */
bwc02       number(5) NOT NULL,      /*序号　　　　　　　　　                 */
bwc03       varchar2(40),            /*料件编号                               */
bwc04       number(5),               /*作业序号                               */
bwc05       number(15,3),            /*盘存数量                               */
                                     /*库存单位                               */
bwc011      number(5) NOT NULL       /*盘点年度                               */
);

create unique index bwc_pk on bwc_file (bwc01,bwc011,bwc02);
alter table bwc_file add  constraint bwc_pk primary key  (bwc01,bwc011,bwc02) enable validate;
grant select on bwc_file to public;
grant index on bwc_file to public;
grant update on bwc_file to public;
grant delete on bwc_file to public;
grant insert on bwc_file to public;