/* ================================================================================ 档案代号:bwh_file 档案名称:年度保税原料结算资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table bwh_file ( bwh01 number(5) NOT NULL, /*年度 */ bwh02 varchar2(40) NOT NULL, /*料件编号 */ bwh03 number(15,3), /*期初保税结存数 */ bwh04 number(15,3), /*期初非保税结存数 */ bwh05 number(15,3), /*本期保税进货数 */ bwh06 number(15,3), /*本期非保税进货数 */ bwh07 number(15,3), /*本期外销使用数 */ bwh08 number(15,3), /*本期内销使用数 */ bwh09 number(15,3), /*本期外运数 */ bwh10 number(15,3), /*本期报废数 */ bwh11 number(15,3), /*本期盘存数 */ bwh12 number(15,3), /*本期盘盈亏数 */ bwh13 number(15,3), /*盘差容许数量 */ bwh14 number(15,3), /*本期盘差补税数 */ bwh15 number(15,3), /*期末应结转下期保税数 */ bwh16 number(15,3) /*期末应结转下期非保税数 */ ); create unique index bwh_pk on bwh_file (bwh01,bwh02); alter table bwh_file add constraint bwh_pk primary key (bwh01,bwh02) enable validate; grant select on bwh_file to public; grant index on bwh_file to public; grant update on bwh_file to public; grant delete on bwh_file to public; grant insert on bwh_file to public; |