-- 业务属性预置脚本
DELETE FROM t_bd_serviceattribute WHERE fid = 1194029484878120960;
INSERT INTO t_bd_serviceattribute(fid,fdescription,fmasterid,fentity,fstatus,fname,fnumber,fcreatetime,fmodifierid,fenable,fispreset,fmodifytime,fcreatorid) 
VALUES (1194029484878120960,' ',1194029484878120960,'bd_material','C','物资','1001',{ts'2021-07-06  00:00:00'},403700558952663057,'1','1',{ts'2021-07-06  00:00:00'},403700558952663057); 
DELETE FROM t_bd_serviceattribute WHERE fid = 1194029708862343168;
INSERT INTO t_bd_serviceattribute(fid,fdescription,fmasterid,fentity,fstatus,fname,fnumber,fcreatetime,fmodifierid,fenable,fispreset,fmodifytime,fcreatorid) 
VALUES (1194029708862343168,' ',1194029708862343168,'bd_material','C','服务','2001',{ts'2021-07-06  00:00:00'},403700558952663057,'1','1',{ts'2021-07-06  00:00:00'},403700558952663057); 
DELETE FROM t_bd_serviceattribute WHERE fid = 1194029878949760000;
INSERT INTO t_bd_serviceattribute(fid,fdescription,fmasterid,fentity,fstatus,fname,fnumber,fcreatetime,fmodifierid,fenable,fispreset,fmodifytime,fcreatorid) 
VALUES (1194029878949760000,' ',1194029878949760000,'bd_material','C','费用','2002',{ts'2021-07-06  00:00:00'},403700558952663057,'1','1',{ts'2021-07-06  00:00:00'},403700558952663057); 
DELETE FROM t_bd_serviceattribute WHERE fid = 1194030110357899264;
INSERT INTO t_bd_serviceattribute(fid,fdescription,fmasterid,fentity,fstatus,fname,fnumber,fcreatetime,fmodifierid,fenable,fispreset,fmodifytime,fcreatorid) 
VALUES (1194030110357899264,' ',1194030110357899264,'bd_material','C','资产','2003',{ts'2021-07-06  00:00:00'},403700558952663057,'1','1',{ts'2021-07-06  00:00:00'},403700558952663057); 
DELETE FROM t_bd_serviceattribute WHERE fid = 1194030308689758208;
INSERT INTO t_bd_serviceattribute(fid,fdescription,fmasterid,fentity,fstatus,fname,fnumber,fcreatetime,fmodifierid,fenable,fispreset,fmodifytime,fcreatorid) 
VALUES (1194030308689758208,' ',1194030308689758208,'er_expenseitemedit','C','费用项目','3001',{ts'2021-07-06  00:00:00'},403700558952663057,'1','1',{ts'2021-07-06  00:00:00'},403700558952663057); 

DELETE FROM t_bd_serviceattribute_l WHERE FPKID = '1X29K4PGIZ3J';
INSERT INTO t_bd_serviceattribute_l(FPKID,FDESCRIPTION,FLOCALEID,FID,FNAME) VALUES ('1X29K4PGIZ3J',' ','zh_CN',1194029484878120960,'物资'); 
DELETE FROM t_bd_serviceattribute_l WHERE FPKID = '1X29KKBQ2WGY';
INSERT INTO t_bd_serviceattribute_l(FPKID,FDESCRIPTION,FLOCALEID,FID,FNAME) VALUES ('1X29KKBQ2WGY',' ','zh_CN',1194029708862343168,'服务'); 
DELETE FROM t_bd_serviceattribute_l WHERE FPKID = '1X29KYXENFIV';
INSERT INTO t_bd_serviceattribute_l(FPKID,FDESCRIPTION,FLOCALEID,FID,FNAME) VALUES ('1X29KYXENFIV',' ','zh_CN',1194029878949760000,'费用'); 
DELETE FROM t_bd_serviceattribute_l WHERE FPKID = '1X29L=P3+4QV';
INSERT INTO t_bd_serviceattribute_l(FPKID,FDESCRIPTION,FLOCALEID,FID,FNAME) VALUES ('1X29L=P3+4QV',' ','zh_CN',1194030110357899264,'资产'); 
DELETE FROM t_bd_serviceattribute_l WHERE FPKID = '1X29LR+BZIJG';
INSERT INTO t_bd_serviceattribute_l(FPKID,FDESCRIPTION,FLOCALEID,FID,FNAME) VALUES ('1X29LR+BZIJG',' ','zh_CN',1194030308689758208,'费用项目'); 


-- 行类型预置脚本
DELETE FROM t_bd_linetype WHERE FID = 1246370111078543360;
INSERT INTO t_bd_linetype(FID,FCONTROLCRITERION,FRECEIVING,FSTORAGEOUT,FDESCRIPTION,FMASTERID,FACCEPTANCE,FSTATUS,FNUMBER,FNAME,FCREATETIME,FSHIPMENTS,FSERVICEATTRIBUTE,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FSTORAGE,FCREATORID) 
VALUES (1246370111078543360,'1','0','0',' ',1246370111078543360,'1','C','020-2','服务',{ts'2021-09-16  00:00:00'},'0',1194029708862343168,403700558952663057,'1','1',{ts'2021-09-16  00:00:00'},'0',403700558952663057); 
DELETE FROM t_bd_linetype WHERE FID = 1246371007980122112;
INSERT INTO t_bd_linetype(FID,FCONTROLCRITERION,FRECEIVING,FSTORAGEOUT,FDESCRIPTION,FMASTERID,FACCEPTANCE,FSTATUS,FNUMBER,FNAME,FCREATETIME,FSHIPMENTS,FSERVICEATTRIBUTE,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FSTORAGE,FCREATORID) 
VALUES (1246371007980122112,'1','0','0',' ',1246371007980122112,'1','C','030-1','费用',{ts'2021-09-16  00:00:00'},'0',1194029878949760000,403700558952663057,'1','1',{ts'2021-09-16  00:00:00'},'0',403700558952663057); 
DELETE FROM t_bd_linetype WHERE FID = 1194153085623127040;
INSERT INTO t_bd_linetype(FID,FCONTROLCRITERION,FRECEIVING,FSTORAGEOUT,FDESCRIPTION,FMASTERID,FACCEPTANCE,FSTATUS,FNUMBER,FNAME,FCREATETIME,FSHIPMENTS,FSERVICEATTRIBUTE,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FSTORAGE,FCREATORID) 
VALUES (1194153085623127040,'0','0','0',' ',1194153085623127040,'1','C','020','服务',{ts'2021-07-06  00:00:00'},'0',1194029708862343168,403700558952663057,'1','1',{ts'2021-10-18  00:00:00'},'0',403700558952663057); 
DELETE FROM t_bd_linetype WHERE FID = 1194154714137152512;
INSERT INTO t_bd_linetype(FID,FCONTROLCRITERION,FRECEIVING,FSTORAGEOUT,FDESCRIPTION,FMASTERID,FACCEPTANCE,FSTATUS,FNUMBER,FNAME,FCREATETIME,FSHIPMENTS,FSERVICEATTRIBUTE,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FSTORAGE,FCREATORID) 
VALUES (1194154714137152512,'0','0','0',' ',1194154714137152512,'1','C','030','费用',{ts'2021-07-06  00:00:00'},'0',1194029878949760000,403700558952663057,'1','1',{ts'2021-10-18  00:00:00'},'0',403700558952663057); 
DELETE FROM t_bd_linetype WHERE FID = 1194155267651062784;
INSERT INTO t_bd_linetype(FID,FCONTROLCRITERION,FRECEIVING,FSTORAGEOUT,FDESCRIPTION,FMASTERID,FACCEPTANCE,FSTATUS,FNUMBER,FNAME,FCREATETIME,FSHIPMENTS,FSERVICEATTRIBUTE,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FSTORAGE,FCREATORID) 
VALUES (1194155267651062784,'0','1','0',' ',1194155267651062784,'0','C','040','资产',{ts'2021-07-06  00:00:00'},'0',1194030110357899264,403700558952663057,'1','1',{ts'2021-10-18  00:00:00'},'0',403700558952663057); 
DELETE FROM t_bd_linetype WHERE FID = 1194156052984154112;
INSERT INTO t_bd_linetype(FID,FCONTROLCRITERION,FRECEIVING,FSTORAGEOUT,FDESCRIPTION,FMASTERID,FACCEPTANCE,FSTATUS,FNUMBER,FNAME,FCREATETIME,FSHIPMENTS,FSERVICEATTRIBUTE,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FSTORAGE,FCREATORID) 
VALUES (1194156052984154112,'0','0','0',' ',1194156052984154112,'0','C','050','费用项目',{ts'2021-07-06  00:00:00'},'0',1194030308689758208,403700558952663057,'1','1',{ts'2021-10-18  00:00:00'},'0',403700558952663057); 
DELETE FROM t_bd_linetype WHERE FID = 1194150915045641216;
INSERT INTO t_bd_linetype(FID,FCONTROLCRITERION,FRECEIVING,FSTORAGEOUT,FDESCRIPTION,FMASTERID,FACCEPTANCE,FSTATUS,FNUMBER,FNAME,FCREATETIME,FSHIPMENTS,FSERVICEATTRIBUTE,FMODIFIERID,FENABLE,FISPRESET,FMODIFYTIME,FSTORAGE,FCREATORID) 
VALUES (1194150915045641216,'0','1','1',' ',1194150915045641216,'0','C','010','物资',{ts'2021-07-06  00:00:00'},'1',1194029484878120960,403700558952663057,'1','1',{ts'2021-10-18  00:00:00'},'1',403700558952663057); 


DELETE FROM t_bd_linetype_l WHERE FPKID = '1X27N+6J4XOW';
INSERT INTO t_bd_linetype_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1194150915045641216,'1X27N+6J4XOW','zh_CN',' ','物资'); 
DELETE FROM t_bd_linetype_l WHERE FPKID = '1X27RL4=YWWK';
INSERT INTO t_bd_linetype_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1194153085623127040,'1X27RL4=YWWK','zh_CN',' ','服务'); 
DELETE FROM t_bd_linetype_l WHERE FPKID = '1X27WO2ONWN=';
INSERT INTO t_bd_linetype_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1246370111078543360,'1X27WO2ONWN=','zh_CN',' ','服务'); 
DELETE FROM t_bd_linetype_l WHERE FPKID = '1X27Y=XBMEYZ';
INSERT INTO t_bd_linetype_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1194154714137152512,'1X27Y=XBMEYZ','zh_CN',' ','费用'); 
DELETE FROM t_bd_linetype_l WHERE FPKID = '1X2817+OH0IK';
INSERT INTO t_bd_linetype_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1246371007980122112,'1X2817+OH0IK','zh_CN',' ','费用'); 
DELETE FROM t_bd_linetype_l WHERE FPKID = '1X282H8SG6OV';
INSERT INTO t_bd_linetype_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1194155267651062784,'1X282H8SG6OV','zh_CN',' ','资产'); 
DELETE FROM t_bd_linetype_l WHERE FPKID = '1X2848BESEZJ';
INSERT INTO t_bd_linetype_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1194156052984154112,'1X2848BESEZJ','zh_CN',' ','费用项目'); 
