DELETE FROM t_tsrbd_msgtempfldscm WHERE FID = 1010;
INSERT INTO t_tsrbd_msgtempfldscm(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FTEMPTYPE,FINDEX,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FSALARYDETTYPE,FCREATORID,FDISABLERID) VALUES (1010,'1',NULL,' ','适用薪酬定薪的Offer Letter模板可选字段方案',1010,'C','P001','Offer Letter模板可选字段方案（薪酬定薪）',1010,0,{ts'1900-01-01  00:00:00'},'1',1,{ts'1900-01-01  00:00:00'},'2',1,0); 
DELETE FROM t_tsrbd_msgtempfldscm WHERE FID = 1020;
INSERT INTO t_tsrbd_msgtempfldscm(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FTEMPTYPE,FINDEX,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FSALARYDETTYPE,FCREATORID,FDISABLERID) VALUES (1020,'1',NULL,' ','适用招聘定薪的Offer Letter模板可选字段方案',1020,'C','P002','Offer Letter模板可选字段方案（招聘定薪）',1010,0,{ts'1900-01-01  00:00:00'},'1',1,{ts'1900-01-01  00:00:00'},'1',1,0); 
DELETE FROM t_tsrbd_msgtempfldscm_L WHERE FPKID = '2WR96FPODBNK';
INSERT INTO t_tsrbd_msgtempfldscm_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1010,'2WR96FPODBNK','zh_CN',' ','适用薪酬定薪的Offer Letter模板可选字段方案','Offer Letter模板可选字段方案（薪酬定薪）'); 
DELETE FROM t_tsrbd_msgtempfldscm_L WHERE FPKID = '2WR96FPODBNL';
--INSERT INTO t_tsrbd_msgtempfldscm_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1010,'2WR96FPODBNL','zh_TW',' ','適用薪酬定薪的Offer Letter模板可选字段方案','Offer Letter模板可選字段方案（薪酬定薪）'); 
DELETE FROM t_tsrbd_msgtempfldscm_L WHERE FPKID = '2YWTV/VVADIQ';
INSERT INTO t_tsrbd_msgtempfldscm_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1020,'2YWTV/VVADIQ','zh_CN',' ','适用招聘定薪的Offer Letter模板可选字段方案','Offer Letter模板可选字段方案（招聘定薪）'); 
DELETE FROM t_tsrbd_msgtempfldscm_L WHERE FPKID = '2YWTV/VVADIR';
--INSERT INTO t_tsrbd_msgtempfldscm_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1020,'2YWTV/VVADIR','zh_TW',' ','適用招聘定薪的Offer Letter模板可选字段方案','Offer Letter模板可選字段方案（招聘定薪）'); 
-- 清除分录表
DELETE FROM t_tsrbd_fldscmentry;
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1583428834257058816;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FISSYSPRESET,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1010,'0','1',1583428834257058816,1287622810700622848,1); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1583428834257058817;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FISSYSPRESET,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1010,'0','1',1583428834257058817,1287622982516114432,2); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1583428834257058818;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FISSYSPRESET,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1010,'0','1',1583428834257058818,1287619924272907264,3); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1583428834257058819;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FISSYSPRESET,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1010,'0','1',1583428834257058819,1287620140925463552,4); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1583428834257058820;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FISSYSPRESET,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1010,'0','1',1583428834257058820,1287620263524992000,5); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1583428834257058821;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FISSYSPRESET,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1010,'0','1',1583428834257058821,1287620475698031616,6); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1583428834257058822;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FISSYSPRESET,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1010,'0','1',1583428834257058822,1287620633789760512,7); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1583428834257058823;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FISSYSPRESET,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1010,'0','1',1583428834257058823,1287620793148146688,8); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1583428834257058824;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FISSYSPRESET,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1010,'0','1',1583428834257058824,1315255962348565504,9); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1583428834257058825;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FISSYSPRESET,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1010,'0','1',1583428834257058825,1287620997461060608,10); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1583428834257058826;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FISSYSPRESET,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1010,'0','1',1583428834257058826,1287621548601017344,11); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1583428834257058827;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FISSYSPRESET,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1010,'0','1',1583428834257058827,1287621766990038016,12); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1583428834257058828;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FISSYSPRESET,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1010,'0','1',1583428834257058828,1287621990068268032,13); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1583428834257058829;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FISSYSPRESET,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1010,'0','1',1583428834257058829,1287622177201357824,14); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1583428834257058830;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FISSYSPRESET,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1010,'0','1',1583428834257058830,1581219460524557312,15); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1583429728952433664;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FISSYSPRESET,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1020,'0','1',1583429728952433664,1287622810700622848,1); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1583429728952433665;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FISSYSPRESET,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1020,'0','1',1583429728952433665,1287622982516114432,2); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1583429728952433666;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FISSYSPRESET,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1020,'0','1',1583429728952433666,1287619924272907264,3); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1583429728952433667;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FISSYSPRESET,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1020,'0','1',1583429728952433667,1315255962348565504,4); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1583429728952433668;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FISSYSPRESET,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1020,'0','1',1583429728952433668,1287620633789760512,5); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1583429728952433669;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FISSYSPRESET,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1020,'0','1',1583429728952433669,1287620793148146688,6); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1583429728952433670;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FISSYSPRESET,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1020,'0','1',1583429728952433670,1287620997461060608,7); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1583429728952433671;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FISSYSPRESET,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1020,'0','1',1583429728952433671,1287621548601017344,8); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1583429728952433672;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FISSYSPRESET,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1020,'0','1',1583429728952433672,1287621766990038016,9); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1583429728952433673;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FISSYSPRESET,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1020,'0','1',1583429728952433673,1287621990068268032,10); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1583429728952433674;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FISSYSPRESET,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1020,'0','1',1583429728952433674,1287620140925463552,11); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1583429728952433675;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FISSYSPRESET,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1020,'0','1',1583429728952433675,1287620263524992000,12); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1583429728952433676;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FISSYSPRESET,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1020,'0','1',1583429728952433676,1287620475698031616,13); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1583429728952433677;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FISSYSPRESET,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1020,'0','1',1583429728952433677,1287622177201357824,14); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1583429728952433678;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FISSYSPRESET,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1020,'0','1',1583429728952433678,1581219460524557312,15); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1583429728952433679;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FISSYSPRESET,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1020,'0','1',1583429728952433679,1287621371173547008,16); 
DELETE FROM t_tsrbd_fldscmentry WHERE FENTRYID = 1583429728952433680;
INSERT INTO t_tsrbd_fldscmentry(FID,FISENCRYPTION,FISSYSPRESET,FENTRYID,FOFFERFIELD,FSEQ) VALUES (1020,'0','1',1583429728952433680,1287621217284555776,17); 
