/****** HR Analysis Object SQL ******/
DELETE FROM T_HRPTMC_ANALYSISOBJECT WHERE FID = 1945039541882619904;
INSERT INTO T_HRPTMC_ANALYSISOBJECT(FID,FVERSION,FPIVOTDIMVAL,FISSYSPRESET,FQUERYSCHEME,FISV,FPIVOTINDEX,FOBJECTTYPE,FDESCRIPTION,FISVIRTUALENTITY,FNUMBER,FNAME,FPIVOTDIM,FSTOREENTITY,FSIDEBAR,FSTORESTATUS,FCREATETIME,FENABLE,FMODIFIERID,FDATAFILTER,FMODIFYTIME,FCREATORID) VALUES (1945039541882619904,0,' ','1','0',' ',' ','multientity',' ','0','kdhr_stafforgreport','组织编制明细',' ',' ',' ',' ',{ts'2024-05-07  00:00:00'},'1',13466739,' ',{ts'2024-05-07  00:00:00'},13466739); 

DELETE FROM T_HRPTMC_ANALYSISOBJECT_L WHERE FPKID = '42XH9VWX9XLU';
INSERT INTO T_HRPTMC_ANALYSISOBJECT_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1945039541882619904,'42XH9VWX9XLU','zh_CN',' ','组织编制明细'); 

DELETE FROM T_HRPTMC_ANOBJJOINENTITY WHERE FID = 1945039542184609792;
INSERT INTO T_HRPTMC_ANOBJJOINENTITY(FID,FVERSION,FTYPE,FENTITYALIAS,FANOBJID,FISV,FENTITYNUMBER,FINDEX,FCREATETIME,FMODIFIERID,FMODIFYTIME,FCREATORID,FLONGNUMBER) VALUES (1945039542184609792,0,'main','haos_orgstaffreport',1945039541882619904,'kingdee','haos_orgstaffreport',0,{ts'2024-05-07  00:00:00'},13466739,{ts'2024-05-07  00:00:00'},0,'0'); 


DELETE FROM T_HRPTMC_ANOBJJOINCOND WHERE FID IN (SELECT FID FROM T_HRPTMC_ANOBJENTJOINREL WHERE FANOBJID IN (1945039541882619904));

DELETE FROM T_HRPTMC_VIRTUALENTITY WHERE FNUMBER IN (SELECT FENTITYNUMBER FROM T_HRPTMC_ANOBJJOINENTITY WHERE FANOBJID IN (1945039541882619904));

DELETE FROM T_HRPTMC_VIRTUALENTITY_L WHERE FID IN (SELECT FID FROM T_HRPTMC_VIRTUALENTITY WHERE FNUMBER IN (SELECT FENTITYNUMBER FROM T_HRPTMC_ANOBJJOINENTITY WHERE FANOBJID IN (1945039541882619904))) AND FLOCALEID='zh_CN';

DELETE FROM T_HRPTMC_VIRTUALSCENE WHERE FID IN (SELECT FID FROM T_HRPTMC_VIRTUALENTITY WHERE FNUMBER IN (SELECT FENTITYNUMBER FROM T_HRPTMC_ANOBJJOINENTITY WHERE FANOBJID IN (1945039541882619904)));

DELETE FROM T_HRPTMC_VIRTUALSCENE_L WHERE FENTRYID IN (SELECT FENTRYID FROM T_HRPTMC_VIRTUALSCENE WHERE FID IN (SELECT FID FROM T_HRPTMC_VIRTUALENTITY WHERE FNUMBER IN (SELECT FENTITYNUMBER FROM T_HRPTMC_ANOBJJOINENTITY WHERE FANOBJID IN (1945039541882619904)))) AND FLOCALEID='zh_CN';

DELETE FROM T_HRPTMC_VIRTUALFIELD WHERE FID IN (SELECT FID FROM T_HRPTMC_VIRTUALENTITY WHERE FNUMBER IN (SELECT FENTITYNUMBER FROM T_HRPTMC_ANOBJJOINENTITY WHERE FANOBJID IN (1945039541882619904)));

DELETE FROM T_HRPTMC_VIRTUALFIELD_L WHERE FENTRYID IN (SELECT FENTRYID FROM T_HRPTMC_VIRTUALFIELD WHERE FID IN (SELECT FID FROM T_HRPTMC_VIRTUALENTITY WHERE FNUMBER IN (SELECT FENTITYNUMBER FROM T_HRPTMC_ANOBJJOINENTITY WHERE FANOBJID IN (1945039541882619904)))) AND FLOCALEID='zh_CN';

DELETE FROM T_HRPTMC_VFIELDGROUP WHERE FID IN (SELECT FGROUP FROM T_HRPTMC_VIRTUALFIELD WHERE FID IN (SELECT FID FROM T_HRPTMC_VIRTUALENTITY WHERE FNUMBER IN (SELECT FENTITYNUMBER FROM T_HRPTMC_ANOBJJOINENTITY WHERE FANOBJID IN (1945039541882619904))));

DELETE FROM T_HRPTMC_VFIELDGROUP_L WHERE FID IN (SELECT FGROUP FROM T_HRPTMC_VIRTUALFIELD WHERE FID IN (SELECT FID FROM T_HRPTMC_VIRTUALENTITY WHERE FNUMBER IN (SELECT FENTITYNUMBER FROM T_HRPTMC_ANOBJJOINENTITY WHERE FANOBJID IN (1945039541882619904))))AND FLOCALEID='zh_CN';

DELETE FROM T_HRPTMC_VIRTENTITYCLASS WHERE FID IN (SELECT FCLASSPATH FROM T_HRPTMC_VIRTUALENTITY WHERE FNUMBER IN (SELECT FENTITYNUMBER FROM T_HRPTMC_ANOBJJOINENTITY WHERE FANOBJID IN (1945039541882619904)));

DELETE FROM T_HRPTMC_VIRTENTITYCLASS_L WHERE FID IN (SELECT FCLASSPATH FROM T_HRPTMC_VIRTUALENTITY WHERE FNUMBER IN (SELECT FENTITYNUMBER FROM T_HRPTMC_ANOBJJOINENTITY WHERE FANOBJID IN (1945039541882619904)))AND FLOCALEID='zh_CN';

DELETE FROM T_HRPTMC_ANOBJQUERYFIELD WHERE FID = 1945039542302156802;
INSERT INTO T_HRPTMC_ANOBJQUERYFIELD(FID,FVERSION,FISVIRTUALFIELD,FANOBJID,FCOMPLEXTYPE,FISV,FCONTROLTYPE,FENTITYNUMBER,FFIELDALIAS,FVALUETYPE,FCREATETIME,FMODIFIERID,FMODIFYTIME,FFIELDPATH,FSTOREFIELD,FFIELDNAME,FCREATORID) VALUES (1945039542302156802,0,'0',1945039541882619904,'adminorg','kingdee','BasedataField','haos_orgstaffreport','adminorg.id','long',{ts'2024-05-07  00:00:00'},13466739,{ts'2024-05-07  00:00:00'},'adminorg.id',' ','行政组织',0); 
DELETE FROM T_HRPTMC_ANOBJQUERYFIELD WHERE FID = 1945039542302156805;
INSERT INTO T_HRPTMC_ANOBJQUERYFIELD(FID,FVERSION,FISVIRTUALFIELD,FANOBJID,FCOMPLEXTYPE,FISV,FCONTROLTYPE,FENTITYNUMBER,FFIELDALIAS,FVALUETYPE,FCREATETIME,FMODIFIERID,FMODIFYTIME,FFIELDPATH,FSTOREFIELD,FFIELDNAME,FCREATORID) VALUES (1945039542302156805,0,'0',1945039541882619904,'adminorg','kingdee','BasedataField','haos_orgstaffreport','adminorg.company.id','long',{ts'2024-05-07  00:00:00'},13466739,{ts'2024-05-07  00:00:00'},'adminorg.company.id',' ','行政组织所属公司',0); 
DELETE FROM T_HRPTMC_ANOBJQUERYFIELD WHERE FID = 1945039542302156808;
INSERT INTO T_HRPTMC_ANOBJQUERYFIELD(FID,FVERSION,FISVIRTUALFIELD,FANOBJID,FCOMPLEXTYPE,FISV,FCONTROLTYPE,FENTITYNUMBER,FFIELDALIAS,FVALUETYPE,FCREATETIME,FMODIFIERID,FMODIFYTIME,FFIELDPATH,FSTOREFIELD,FFIELDNAME,FCREATORID) VALUES (1945039542302156808,0,'0',1945039541882619904,'normal','kingdee','IntegerField','haos_orgstaffreport','staffcount','integer',{ts'2024-05-07  00:00:00'},13466739,{ts'2024-05-07  00:00:00'},'staffcount',' ','直属编制人数',0); 
DELETE FROM T_HRPTMC_ANOBJQUERYFIELD WHERE FID = 1945039542302156809;
INSERT INTO T_HRPTMC_ANOBJQUERYFIELD(FID,FVERSION,FISVIRTUALFIELD,FANOBJID,FCOMPLEXTYPE,FISV,FCONTROLTYPE,FENTITYNUMBER,FFIELDALIAS,FVALUETYPE,FCREATETIME,FMODIFIERID,FMODIFYTIME,FFIELDPATH,FSTOREFIELD,FFIELDNAME,FCREATORID) VALUES (1945039542302156809,0,'0',1945039541882619904,'normal','kingdee','IntegerField','haos_orgstaffreport','staffcountwithsub','integer',{ts'2024-05-07  00:00:00'},13466739,{ts'2024-05-07  00:00:00'},'staffcountwithsub',' ','含下级编制人数',0); 
DELETE FROM T_HRPTMC_ANOBJQUERYFIELD WHERE FID = 1945039542302156807;
INSERT INTO T_HRPTMC_ANOBJQUERYFIELD(FID,FVERSION,FISVIRTUALFIELD,FANOBJID,FCOMPLEXTYPE,FISV,FCONTROLTYPE,FENTITYNUMBER,FFIELDALIAS,FVALUETYPE,FCREATETIME,FMODIFIERID,FMODIFYTIME,FFIELDPATH,FSTOREFIELD,FFIELDNAME,FCREATORID) VALUES (1945039542302156807,0,'0',1945039541882619904,'adminorg','kingdee','MuliLangTextField','haos_orgstaffreport','adminorg.company.name','string',{ts'2024-05-07  00:00:00'},13466739,{ts'2024-05-07  00:00:00'},'adminorg.company.name',' ','行政组织所属公司行政组织名称',0); 
DELETE FROM T_HRPTMC_ANOBJQUERYFIELD WHERE FID = 1945039542302156800;
INSERT INTO T_HRPTMC_ANOBJQUERYFIELD(FID,FVERSION,FISVIRTUALFIELD,FANOBJID,FCOMPLEXTYPE,FISV,FCONTROLTYPE,FENTITYNUMBER,FFIELDALIAS,FVALUETYPE,FCREATETIME,FMODIFIERID,FMODIFYTIME,FFIELDPATH,FSTOREFIELD,FFIELDNAME,FCREATORID) VALUES (1945039542302156800,0,'0',1945039541882619904,'normal','kingdee','DateTimeField','haos_orgstaffreport','year','datetime',{ts'2024-05-07  00:00:00'},13466739,{ts'2024-05-07  00:00:00'},'year',' ','编制年份',0); 
DELETE FROM T_HRPTMC_ANOBJQUERYFIELD WHERE FID = 1945039542302156804;
INSERT INTO T_HRPTMC_ANOBJQUERYFIELD(FID,FVERSION,FISVIRTUALFIELD,FANOBJID,FCOMPLEXTYPE,FISV,FCONTROLTYPE,FENTITYNUMBER,FFIELDALIAS,FVALUETYPE,FCREATETIME,FMODIFIERID,FMODIFYTIME,FFIELDPATH,FSTOREFIELD,FFIELDNAME,FCREATORID) VALUES (1945039542302156804,0,'0',1945039541882619904,'adminorg','kingdee','MuliLangTextField','haos_orgstaffreport','adminorg.name','string',{ts'2024-05-07  00:00:00'},13466739,{ts'2024-05-07  00:00:00'},'adminorg.name',' ','行政组织名称',0); 
DELETE FROM T_HRPTMC_ANOBJQUERYFIELD WHERE FID = 1945039542302156806;
INSERT INTO T_HRPTMC_ANOBJQUERYFIELD(FID,FVERSION,FISVIRTUALFIELD,FANOBJID,FCOMPLEXTYPE,FISV,FCONTROLTYPE,FENTITYNUMBER,FFIELDALIAS,FVALUETYPE,FCREATETIME,FMODIFIERID,FMODIFYTIME,FFIELDPATH,FSTOREFIELD,FFIELDNAME,FCREATORID) VALUES (1945039542302156806,0,'0',1945039541882619904,'adminorg','kingdee','TextField','haos_orgstaffreport','adminorg.company.number','string',{ts'2024-05-07  00:00:00'},13466739,{ts'2024-05-07  00:00:00'},'adminorg.company.number',' ','行政组织所属公司行政组织编码',0); 
DELETE FROM T_HRPTMC_ANOBJQUERYFIELD WHERE FID = 1945039542302156801;
INSERT INTO T_HRPTMC_ANOBJQUERYFIELD(FID,FVERSION,FISVIRTUALFIELD,FANOBJID,FCOMPLEXTYPE,FISV,FCONTROLTYPE,FENTITYNUMBER,FFIELDALIAS,FVALUETYPE,FCREATETIME,FMODIFIERID,FMODIFYTIME,FFIELDPATH,FSTOREFIELD,FFIELDNAME,FCREATORID) VALUES (1945039542302156801,0,'0',1945039541882619904,'normal','kingdee','DateTimeField','haos_orgstaffreport','month','datetime',{ts'2024-05-07  00:00:00'},13466739,{ts'2024-05-07  00:00:00'},'month',' ','编制月份',0); 
DELETE FROM T_HRPTMC_ANOBJQUERYFIELD WHERE FID = 1945039542302156803;
INSERT INTO T_HRPTMC_ANOBJQUERYFIELD(FID,FVERSION,FISVIRTUALFIELD,FANOBJID,FCOMPLEXTYPE,FISV,FCONTROLTYPE,FENTITYNUMBER,FFIELDALIAS,FVALUETYPE,FCREATETIME,FMODIFIERID,FMODIFYTIME,FFIELDPATH,FSTOREFIELD,FFIELDNAME,FCREATORID) VALUES (1945039542302156803,0,'0',1945039541882619904,'adminorg','kingdee','TextField','haos_orgstaffreport','adminorg.number','string',{ts'2024-05-07  00:00:00'},13466739,{ts'2024-05-07  00:00:00'},'adminorg.number',' ','行政组织编码',0); 

DELETE FROM T_HRPTMC_ANOBJQUERYFIELD_L WHERE FPKID = '42XH9W0/NZ6N';
INSERT INTO T_HRPTMC_ANOBJQUERYFIELD_L(FID,FPKID,FLOCALEID,FFIELDNAME) VALUES (1945039542302156802,'42XH9W0/NZ6N','zh_CN','行政组织'); 
DELETE FROM T_HRPTMC_ANOBJQUERYFIELD_L WHERE FPKID = '42XH9W0/NZ6W';
INSERT INTO T_HRPTMC_ANOBJQUERYFIELD_L(FID,FPKID,FLOCALEID,FFIELDNAME) VALUES (1945039542302156805,'42XH9W0/NZ6W','zh_CN','行政组织所属公司'); 
DELETE FROM T_HRPTMC_ANOBJQUERYFIELD_L WHERE FPKID = '42XH9W0/NZ79';
INSERT INTO T_HRPTMC_ANOBJQUERYFIELD_L(FID,FPKID,FLOCALEID,FFIELDNAME) VALUES (1945039542302156808,'42XH9W0/NZ79','zh_CN','直属编制人数'); 
DELETE FROM T_HRPTMC_ANOBJQUERYFIELD_L WHERE FPKID = '42XH9W0/NZ7C';
INSERT INTO T_HRPTMC_ANOBJQUERYFIELD_L(FID,FPKID,FLOCALEID,FFIELDNAME) VALUES (1945039542302156809,'42XH9W0/NZ7C','zh_CN','含下级编制人数'); 
DELETE FROM T_HRPTMC_ANOBJQUERYFIELD_L WHERE FPKID = '42XH9W0/NZ72';
INSERT INTO T_HRPTMC_ANOBJQUERYFIELD_L(FID,FPKID,FLOCALEID,FFIELDNAME) VALUES (1945039542302156807,'42XH9W0/NZ72','zh_CN','行政组织所属公司行政组织名称'); 
DELETE FROM T_HRPTMC_ANOBJQUERYFIELD_L WHERE FPKID = '42XH9W0/NZ6F';
INSERT INTO T_HRPTMC_ANOBJQUERYFIELD_L(FID,FPKID,FLOCALEID,FFIELDNAME) VALUES (1945039542302156800,'42XH9W0/NZ6F','zh_CN','编制年份'); 
DELETE FROM T_HRPTMC_ANOBJQUERYFIELD_L WHERE FPKID = '42XH9W0/NZ6S';
INSERT INTO T_HRPTMC_ANOBJQUERYFIELD_L(FID,FPKID,FLOCALEID,FFIELDNAME) VALUES (1945039542302156804,'42XH9W0/NZ6S','zh_CN','行政组织名称'); 
DELETE FROM T_HRPTMC_ANOBJQUERYFIELD_L WHERE FPKID = '42XH9W0/NZ7+';
INSERT INTO T_HRPTMC_ANOBJQUERYFIELD_L(FID,FPKID,FLOCALEID,FFIELDNAME) VALUES (1945039542302156806,'42XH9W0/NZ7+','zh_CN','行政组织所属公司行政组织编码'); 
DELETE FROM T_HRPTMC_ANOBJQUERYFIELD_L WHERE FPKID = '42XH9W0/NZ6J';
INSERT INTO T_HRPTMC_ANOBJQUERYFIELD_L(FID,FPKID,FLOCALEID,FFIELDNAME) VALUES (1945039542302156801,'42XH9W0/NZ6J','zh_CN','编制月份'); 
DELETE FROM T_HRPTMC_ANOBJQUERYFIELD_L WHERE FPKID = '42XH9W0/NZ6O';
INSERT INTO T_HRPTMC_ANOBJQUERYFIELD_L(FID,FPKID,FLOCALEID,FFIELDNAME) VALUES (1945039542302156803,'42XH9W0/NZ6O','zh_CN','行政组织编码'); 











