-- 预置存货分类
DELETE FROM T_BD_MATCATEGORY_GROUP WHERE FID = 2076973805741283328;
INSERT INTO T_BD_MATCATEGORY_GROUP(FID,FENABLE,FISPRESET,FREMARK,FMASTERID,FNUMBER,FNAME) VALUES (2076973805741283328,'1','1',' ',2076973805741283328,'CHJZFL01-SYS','原材料');
DELETE FROM T_BD_MATCATEGORY_GROUP WHERE FID = 2076973916252806144;
INSERT INTO T_BD_MATCATEGORY_GROUP(FID,FENABLE,FISPRESET,FREMARK,FMASTERID,FNUMBER,FNAME) VALUES (2076973916252806144,'1','1',' ',2076973916252806144,'CHJZFL02-SYS','辅料');
DELETE FROM T_BD_MATCATEGORY_GROUP WHERE FID = 2076974123879241728;
INSERT INTO T_BD_MATCATEGORY_GROUP(FID,FENABLE,FISPRESET,FREMARK,FMASTERID,FNUMBER,FNAME) VALUES (2076974123879241728,'1','1',' ',2076974123879241728,'CHJZFL03-SYS','自制半成品');
DELETE FROM T_BD_MATCATEGORY_GROUP WHERE FID = 2076974203621350400;
INSERT INTO T_BD_MATCATEGORY_GROUP(FID,FENABLE,FISPRESET,FREMARK,FMASTERID,FNUMBER,FNAME) VALUES (2076974203621350400,'1','1',' ',2076974203621350400,'CHJZFL04-SYS','委外半成品');
DELETE FROM T_BD_MATCATEGORY_GROUP WHERE FID = 2076974351193741312;
INSERT INTO T_BD_MATCATEGORY_GROUP(FID,FENABLE,FISPRESET,FREMARK,FMASTERID,FNUMBER,FNAME) VALUES (2076974351193741312,'1','1',' ',2076974351193741312,'CHJZFL05-SYS','产成品');
DELETE FROM T_BD_MATCATEGORY_GROUP WHERE FID = 2076974544089783296;
INSERT INTO T_BD_MATCATEGORY_GROUP(FID,FENABLE,FISPRESET,FREMARK,FMASTERID,FNUMBER,FNAME) VALUES (2076974544089783296,'1','1',' ',2076974544089783296,'CHJZFL06-SYS','库存商品');
DELETE FROM T_BD_MATCATEGORY_GROUP WHERE FID = 2076974824898435072;
INSERT INTO T_BD_MATCATEGORY_GROUP(FID,FENABLE,FISPRESET,FREMARK,FMASTERID,FNUMBER,FNAME) VALUES (2076974824898435072,'1','1',' ',2076974824898435072,'CHJZFL07-SYS','资产');
DELETE FROM T_BD_MATCATEGORY_GROUP_L WHERE FPKID = '4I3KML6QMJWU';
INSERT INTO T_BD_MATCATEGORY_GROUP_L(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (2076973805741283328,'4I3KML6QMJWU','zh_CN',' ','原材料');

DELETE FROM T_BD_MATCATEGORY_GROUP_L WHERE FPKID = '4I3KNDLOKR7+';
INSERT INTO T_BD_MATCATEGORY_GROUP_L(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (2076973916252806144,'4I3KNDLOKR7+','zh_CN',' ','辅料');

DELETE FROM T_BD_MATCATEGORY_GROUP_L WHERE FPKID = '4I3KOXLTUVMJ';
INSERT INTO T_BD_MATCATEGORY_GROUP_L(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (2076974123879241728,'4I3KOXLTUVMJ','zh_CN',' ','自制半成品');

DELETE FROM T_BD_MATCATEGORY_GROUP_L WHERE FPKID = '4I3KPH9MWP55';
INSERT INTO T_BD_MATCATEGORY_GROUP_L(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (2076974203621350400,'4I3KPH9MWP55','zh_CN',' ','委外半成品');

DELETE FROM T_BD_MATCATEGORY_GROUP_L WHERE FPKID = '4I3KQK79/UOZ';
INSERT INTO T_BD_MATCATEGORY_GROUP_L(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (2076974351193741312,'4I3KQK79/UOZ','zh_CN',' ','产成品');

DELETE FROM T_BD_MATCATEGORY_GROUP_L WHERE FPKID = '4I3KS+07L8P/';
INSERT INTO T_BD_MATCATEGORY_GROUP_L(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (2076974544089783296,'4I3KS+07L8P/','zh_CN',' ','库存商品');

DELETE FROM T_BD_MATCATEGORY_GROUP_L WHERE FPKID = '4I3KU/UJZYVY';
INSERT INTO T_BD_MATCATEGORY_GROUP_L(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (2076974824898435072,'4I3KU/UJZYVY','zh_CN',' ','资产');


-- 更新存货类别 的存货分类
UPDATE  T_BD_MATERIALCATEGORY SET FGROUP = 2076973805741283328 WHERE FID = 1477417827609611264;
UPDATE  T_BD_MATERIALCATEGORY SET FGROUP = 2076973916252806144 WHERE FID = 1474911538065180672;
UPDATE  T_BD_MATERIALCATEGORY SET FGROUP = 2076974123879241728 WHERE FID = 1477417939924682752;
UPDATE  T_BD_MATERIALCATEGORY SET FGROUP = 2076974203621350400 WHERE FID = 1477418081650215936;
UPDATE  T_BD_MATERIALCATEGORY SET FGROUP = 2076974351193741312 WHERE FID = 1477418197832435712;
UPDATE  T_BD_MATERIALCATEGORY SET FGROUP = 2076974544089783296 WHERE FID = 1477418329785240576;
UPDATE  T_BD_MATERIALCATEGORY SET FGROUP = 2076974824898435072 WHERE FID = 1477418432193366016;

