
--hpdi
-- 分录表
DELETE FROM t_hpdi_subapisetent WHERE FENTRYID = 1457362450709002253;
INSERT INTO t_hpdi_subapisetent(FID,FISCONVERTOBJECT,FENTRYID,FAPIDEPLOYID,FSEQ,FTARGETOBJECTID) VALUES (1457362450675447808,'0',1457362450709002253,1504977659711516672,15,' '); 
DELETE FROM t_hpdi_subapisetent WHERE FENTRYID = 1457363627177682957;
INSERT INTO t_hpdi_subapisetent(FID,FISCONVERTOBJECT,FENTRYID,FAPIDEPLOYID,FSEQ,FTARGETOBJECTID) VALUES (1457363626951190528,'0',1457363627177682957,1504977659711516672,14,' '); 
DELETE FROM t_hpdi_subapisetent WHERE FENTRYID = 1457380613874046989;
INSERT INTO t_hpdi_subapisetent(FID,FISCONVERTOBJECT,FENTRYID,FAPIDEPLOYID,FSEQ,FTARGETOBJECTID) VALUES (1457380613832103936,'0',1457380613874046989,1504977659711516672,14,' '); 
DELETE FROM t_hpdi_subapisetent WHERE FENTRYID = 1457362630116161549;
INSERT INTO t_hpdi_subapisetent(FID,FISCONVERTOBJECT,FENTRYID,FAPIDEPLOYID,FSEQ,FTARGETOBJECTID) VALUES (1457362630082607104,'0',1457362630116161549,1504977659711516672,14,' '); 
DELETE FROM t_hpdi_subapisetent WHERE FENTRYID = 1457974016982703114;
INSERT INTO t_hpdi_subapisetent(FID,FISCONVERTOBJECT,FENTRYID,FAPIDEPLOYID,FSEQ,FTARGETOBJECTID) VALUES (1457974016848485376,'0',1457974016982703114,1504977659711516672,11,' '); 
DELETE FROM t_hpdi_subapisetent WHERE FENTRYID = 1463657127330459658;
INSERT INTO t_hpdi_subapisetent(FID,FISCONVERTOBJECT,FENTRYID,FAPIDEPLOYID,FSEQ,FTARGETOBJECTID) VALUES (1463657127263350784,'0',1463657127330459658,1504977659711516672,11,' '); 
DELETE FROM t_hpdi_subapisetent WHERE FENTRYID = 1457362276033018894;
INSERT INTO t_hpdi_subapisetent(FID,FISCONVERTOBJECT,FENTRYID,FAPIDEPLOYID,FSEQ,FTARGETOBJECTID) VALUES (1457362275999464448,'0',1457362276033018894,1504977659711516672,15,' '); 

-- 子分录表输入参数
DELETE FROM t_hpdi_subapisetindetail WHERE FDETAILID = 1463657127330504701;
INSERT INTO t_hpdi_subapisetindetail(FDETAILID,FENTRYID,FFIELDKEY,FSEQ,FFIELDTYPE,FFIELDSOURCE,FFIELDNAME) VALUES (1463657127330504701,1457362450709002253,'depEmpId',1,'long','depempId','组织人ID'); 
DELETE FROM t_hpdi_subapisetindetail WHERE FDETAILID = 1463657127330504700;
INSERT INTO t_hpdi_subapisetindetail(FDETAILID,FENTRYID,FFIELDKEY,FSEQ,FFIELDTYPE,FFIELDSOURCE,FFIELDNAME) VALUES (1463657127330504700,1457362450709002253,'effectTime',2,'java.util.Date','effectTime','生效日期'); 
DELETE FROM t_hpdi_subapisetindetail WHERE FDETAILID = 1463657127330504698;
INSERT INTO t_hpdi_subapisetindetail(FDETAILID,FENTRYID,FFIELDKEY,FSEQ,FFIELDTYPE,FFIELDSOURCE,FFIELDNAME) VALUES (1463657127330504698,1457363627177682957,'depEmpId',1,'long','depempId','组织人ID'); 
DELETE FROM t_hpdi_subapisetindetail WHERE FDETAILID = 1463657127330504699;
INSERT INTO t_hpdi_subapisetindetail(FDETAILID,FENTRYID,FFIELDKEY,FSEQ,FFIELDTYPE,FFIELDSOURCE,FFIELDNAME) VALUES (1463657127330504699,1457363627177682957,'effectTime',2,'java.util.Date','effectTime','生效日期'); 
DELETE FROM t_hpdi_subapisetindetail WHERE FDETAILID = 1463657127330504696;
INSERT INTO t_hpdi_subapisetindetail(FDETAILID,FENTRYID,FFIELDKEY,FSEQ,FFIELDTYPE,FFIELDSOURCE,FFIELDNAME) VALUES (1463657127330504696,1457380613874046989,'depEmpId',1,'long','depempId','组织人ID'); 
DELETE FROM t_hpdi_subapisetindetail WHERE FDETAILID = 1463657127330504697;
INSERT INTO t_hpdi_subapisetindetail(FDETAILID,FENTRYID,FFIELDKEY,FSEQ,FFIELDTYPE,FFIELDSOURCE,FFIELDNAME) VALUES (1463657127330504697,1457380613874046989,'effectTime',2,'java.util.Date','effectTime','生效日期'); 
DELETE FROM t_hpdi_subapisetindetail WHERE FDETAILID = 1463657127330504694;
INSERT INTO t_hpdi_subapisetindetail(FDETAILID,FENTRYID,FFIELDKEY,FSEQ,FFIELDTYPE,FFIELDSOURCE,FFIELDNAME) VALUES (1463657127330504694,1457362630116161549,'depEmpId',1,'long','depempId','组织人ID'); 
DELETE FROM t_hpdi_subapisetindetail WHERE FDETAILID = 1463657127330504695;
INSERT INTO t_hpdi_subapisetindetail(FDETAILID,FENTRYID,FFIELDKEY,FSEQ,FFIELDTYPE,FFIELDSOURCE,FFIELDNAME) VALUES (1463657127330504695,1457362630116161549,'effectTime',2,'java.util.Date','effectTime','生效日期'); 
DELETE FROM t_hpdi_subapisetindetail WHERE FDETAILID = 1463657127330504692;
INSERT INTO t_hpdi_subapisetindetail(FDETAILID,FENTRYID,FFIELDKEY,FSEQ,FFIELDTYPE,FFIELDSOURCE,FFIELDNAME) VALUES (1463657127330504692,1457974016982703114,'depEmpId',1,'long','depempId','组织人ID'); 
DELETE FROM t_hpdi_subapisetindetail WHERE FDETAILID = 1463657127330504693;
INSERT INTO t_hpdi_subapisetindetail(FDETAILID,FENTRYID,FFIELDKEY,FSEQ,FFIELDTYPE,FFIELDSOURCE,FFIELDNAME) VALUES (1463657127330504693,1457974016982703114,'effectTime',2,'java.util.Date','effectTime','生效日期'); 
DELETE FROM t_hpdi_subapisetindetail WHERE FDETAILID = 1463657127330504690;
INSERT INTO t_hpdi_subapisetindetail(FDETAILID,FENTRYID,FFIELDKEY,FSEQ,FFIELDTYPE,FFIELDSOURCE,FFIELDNAME) VALUES (1463657127330504690,1463657127330459658,'depEmpId',1,'long','depempId','组织人ID'); 
DELETE FROM t_hpdi_subapisetindetail WHERE FDETAILID = 1463657127330504691;
INSERT INTO t_hpdi_subapisetindetail(FDETAILID,FENTRYID,FFIELDKEY,FSEQ,FFIELDTYPE,FFIELDSOURCE,FFIELDNAME) VALUES (1463657127330504691,1463657127330459658,'effectTime',2,'java.util.Date','effectTime','生效日期'); 
DELETE FROM t_hpdi_subapisetindetail WHERE FDETAILID = 1463657127330504688;
INSERT INTO t_hpdi_subapisetindetail(FDETAILID,FENTRYID,FFIELDKEY,FSEQ,FFIELDTYPE,FFIELDSOURCE,FFIELDNAME) VALUES (1463657127330504688,1457362276033018894,'depEmpId',1,'long','depempId','组织人ID'); 
DELETE FROM t_hpdi_subapisetindetail WHERE FDETAILID = 1463657127330504689;
INSERT INTO t_hpdi_subapisetindetail(FDETAILID,FENTRYID,FFIELDKEY,FSEQ,FFIELDTYPE,FFIELDSOURCE,FFIELDNAME) VALUES (1463657127330504689,1457362276033018894,'effectTime',2,'java.util.Date','effectTime','生效日期'); 

--子分录表输出参数
DELETE FROM t_hpdi_subapisetotdetail WHERE FDETAILID = 1463657127330459650;
INSERT INTO t_hpdi_subapisetotdetail(FMAPFIELDKEY,FDETAILID,FAPIFIELDNAME,FENTRYID,FSEQ,FAPIFIELDTYPE,FMAPBASEDATAID,FAPIFIELDKEY,FENTITYNAME) VALUES ('isSalaryExist',1463657127330459650,'是否存在档案',1457362450709002253,0,'boolean',' ','isSalaryExist',' '); 
DELETE FROM t_hpdi_subapisetotdetail WHERE FDETAILID = 1463657127330459649;
INSERT INTO t_hpdi_subapisetotdetail(FMAPFIELDKEY,FDETAILID,FAPIFIELDNAME,FENTRYID,FSEQ,FAPIFIELDTYPE,FMAPBASEDATAID,FAPIFIELDKEY,FENTITYNAME) VALUES ('isSalaryExist',1463657127330459649,'是否存在档案',1457363627177682957,0,'boolean',' ','isSalaryExist',' '); 
DELETE FROM t_hpdi_subapisetotdetail WHERE FDETAILID = 1463657127330459648;
INSERT INTO t_hpdi_subapisetotdetail(FMAPFIELDKEY,FDETAILID,FAPIFIELDNAME,FENTRYID,FSEQ,FAPIFIELDTYPE,FMAPBASEDATAID,FAPIFIELDKEY,FENTITYNAME) VALUES ('isSalaryExist',1463657127330459648,'是否存在档案',1457380613874046989,0,'boolean',' ','isSalaryExist',' '); 
DELETE FROM t_hpdi_subapisetotdetail WHERE FDETAILID = 1463657127330459647;
INSERT INTO t_hpdi_subapisetotdetail(FMAPFIELDKEY,FDETAILID,FAPIFIELDNAME,FENTRYID,FSEQ,FAPIFIELDTYPE,FMAPBASEDATAID,FAPIFIELDKEY,FENTITYNAME) VALUES ('isSalaryExist',1463657127330459647,'是否存在档案',1457362630116161549,0,'boolean',' ','isSalaryExist',' '); 
DELETE FROM t_hpdi_subapisetotdetail WHERE FDETAILID = 1463657127330459646;
INSERT INTO t_hpdi_subapisetotdetail(FMAPFIELDKEY,FDETAILID,FAPIFIELDNAME,FENTRYID,FSEQ,FAPIFIELDTYPE,FMAPBASEDATAID,FAPIFIELDKEY,FENTITYNAME) VALUES ('isSalaryExist',1463657127330459646,'是否存在档案',1457974016982703114,0,'boolean',' ','isSalaryExist',' '); 
DELETE FROM t_hpdi_subapisetotdetail WHERE FDETAILID = 1463657127330459645;
INSERT INTO t_hpdi_subapisetotdetail(FMAPFIELDKEY,FDETAILID,FAPIFIELDNAME,FENTRYID,FSEQ,FAPIFIELDTYPE,FMAPBASEDATAID,FAPIFIELDKEY,FENTITYNAME) VALUES ('isSalaryExist',1463657127330459645,'是否存在档案',1463657127330459658,0,'boolean',' ','isSalaryExist',' '); 
DELETE FROM t_hpdi_subapisetotdetail WHERE FDETAILID = 1463657127330459644;
INSERT INTO t_hpdi_subapisetotdetail(FMAPFIELDKEY,FDETAILID,FAPIFIELDNAME,FENTRYID,FSEQ,FAPIFIELDTYPE,FMAPBASEDATAID,FAPIFIELDKEY,FENTITYNAME) VALUES ('isSalaryExist',1463657127330459644,'是否存在档案',1457362276033018894,0,'boolean',' ','isSalaryExist',' '); 
