物料类别代码.txt

仓储系统

insert into materielclass(mclass_no,mclass_name) values('101','元器件')
insert into materielclass(mclass_no,mclass_name) values('102','金属')
insert into materielclass(mclass_no,mclass_name) values('103','塑胶材料')
insert into materielclass(mclass_no,mclass_name) values('104','电镀材料')
insert into materielclass(mclass_no,mclass_name) values('105','油漆材料')
insert into materielclass(mclass_no,mclass_name) values('106','包装材料')
insert into materielclass(mclass_no,mclass_name) values('107','辅助材料')


insert into materielclass(mclass_no,mclass_name) values('201','日用品')
insert into materielclass(mclass_no,mclass_name) values('202','防护品')
insert into materielclass(mclass_no,mclass_name) values('203','其他劳保')

insert into materielclass(mclass_no,mclass_name) values('301','印刷品')
insert into materielclass(mclass_no,mclass_name) values('302','文具')
insert into materielclass(mclass_no,mclass_name) values('303','办公家具')

insert into materielclass(mclass_no,mclass_name) values('401','工具类')
insert into materielclass(mclass_no,mclass_name) values('402','量具类')
insert into materielclass(mclass_no,mclass_name) values('403','夹具类')

--delete from materielclassateriel_cl'工具类'
--delete from materielclassateriel_cl'量具类'
--delete from materielclassateriel_cl'夹具类'

insert into materielclass(mclass_no,mclass_name) values('501','机械设备')
insert into materielclass(mclass_no,mclass_name) values('502','测量设备')
insert into materielclass(mclass_no,mclass_name) values('503','电器设备')
insert into materielclass(mclass_no,mclass_name) values('501','运输设备')

insert into materielclass(mclass_no,mclass_name) values('601','电工类')
insert into materielclass(mclass_no,mclass_name) values('602','生产类')
insert into materielclass(mclass_no,mclass_name) values('603','杂件类')