/* ================================================================================ 档案代号: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; |