/*
================================================================================
档案代号:bwe_file
档案名称:保税盘点折合资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table bwe_file
(
bwe00       varchar2(1) NOT NULL,    /*类别                                   */
                                     /* P:委外工单    #FUN-6A0007             */
                                     /* S:库存盘点: bwa_file                  */
                                     /*W:工单盘点: bwb_file, bwc_file         */
bwe01       varchar2(16) NOT NULL,   /*标签编号                               */
bwe02       number(5) NOT NULL,      /*序号                                   */
bwe03       varchar2(40),            /*料件编号                               */
bwe031      number(20,8),            /*单位用量                               */
bwe04       number(15,4),            /*折合数量                               */
                                     /*库存单位                               */
bwe05       varchar2(1),             /*区分                                   */
                                     /*区分:本栏位仅在类别为W时使用           */
                                     /*         若下阶用料为原料时='1'        */
                                     /*         若是由半成品往下展时='2'      */
                                     /*         本栏位供汇总bwf_file时使用    */
bwe011      number(5) NOT NULL       /*年度                                   */
);

create unique index bwe_pk on bwe_file (bwe00,bwe01,bwe02,bwe011);
alter table bwe_file add  constraint bwe_pk primary key  (bwe00,bwe01,bwe02,bwe011) enable validate;
grant select on bwe_file to public;
grant index on bwe_file to public;
grant update on bwe_file to public;
grant delete on bwe_file to public;
grant insert on bwe_file to public;