-- 预置容差类型脚本
DELETE FROM t_ap_tolerancetype WHERE FID = 1928940693972073472;
INSERT INTO t_ap_tolerancetype(FID,FCONTROLITEMNAME,FISPREINSERT,FCONTRASTITEMNAME,FCONTRASTITEM,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FCONTROLLER,FMODIFIERID,FENABLE,FMODIFYTIME,FCONTROLITEM,FCONTRASTER,FDESCRIBE,FCREATORID) VALUES (1928940693972073472,'明细.金额(本位币)','1','明细.金额(本位币)','e_amountbase',1928940693972073472,'C','039_s','财务应付金额本位币微调差异',{ts'2024-04-15  00:00:00'},'ap_finapbill',13466739,'1',{ts'2024-04-15  00:00:00'},'e_amountbase','ap_finapbill',' ',13466739);
DELETE FROM t_ap_tolerancetype WHERE FID = 1928942186330603520;
INSERT INTO t_ap_tolerancetype(FID,FCONTROLITEMNAME,FISPREINSERT,FCONTRASTITEMNAME,FCONTRASTITEM,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FCONTROLLER,FMODIFIERID,FENABLE,FMODIFYTIME,FCONTROLITEM,FCONTRASTER,FDESCRIBE,FCREATORID) VALUES (1928942186330603520,'明细.税额(本位币)','1','明细.税额(本位币)','e_taxlocalamt',1928942186330603520,'C','043_s','财务应收税额本位币微调差异',{ts'2024-04-15  00:00:00'},'ar_finarbill',13466739,'1',{ts'2024-04-15  00:00:00'},'e_taxlocalamt','ar_finarbill',' ',13466739);
DELETE FROM t_ap_tolerancetype WHERE FID = 1928941821786865664;
INSERT INTO t_ap_tolerancetype(FID,FCONTROLITEMNAME,FISPREINSERT,FCONTRASTITEMNAME,FCONTRASTITEM,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FCONTROLLER,FMODIFIERID,FENABLE,FMODIFYTIME,FCONTROLITEM,FCONTRASTER,FDESCRIBE,FCREATORID) VALUES (1928941821786865664,'明细.金额(本位币)','1','明细.金额(本位币)','e_localamt',1928941821786865664,'C','042_s','财务应收金额本位币微调差异',{ts'2024-04-15  00:00:00'},'ar_finarbill',13466739,'1',{ts'2024-04-15  00:00:00'},'e_localamt','ar_finarbill',' ',13466739);
DELETE FROM t_ap_tolerancetype WHERE FID = 1928942519459003392;
INSERT INTO t_ap_tolerancetype(FID,FCONTROLITEMNAME,FISPREINSERT,FCONTRASTITEMNAME,FCONTRASTITEM,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FCONTROLLER,FMODIFIERID,FENABLE,FMODIFYTIME,FCONTROLITEM,FCONTRASTER,FDESCRIBE,FCREATORID) VALUES (1928942519459003392,'明细.应收金额(本位币)','1','明细.应收金额(本位币)','e_reclocalamt',1928942519459003392,'C','044_s','财务应收应收金额本位币微调差异',{ts'2024-04-15  00:00:00'},'ar_finarbill',13466739,'1',{ts'2024-04-15  00:00:00'},'e_reclocalamt','ar_finarbill',' ',13466739);
DELETE FROM t_ap_tolerancetype WHERE FID = 1928941566840290304;
INSERT INTO t_ap_tolerancetype(FID,FCONTROLITEMNAME,FISPREINSERT,FCONTRASTITEMNAME,FCONTRASTITEM,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FCONTROLLER,FMODIFIERID,FENABLE,FMODIFYTIME,FCONTROLITEM,FCONTRASTER,FDESCRIBE,FCREATORID) VALUES (1928941566840290304,'明细.应付金额(本位币)','1','明细.应付金额(本位币)','e_pricetaxtotalbase',1928941566840290304,'C','041_s','财务应付应付金额本位币微调差异',{ts'2024-04-15  00:00:00'},'ap_finapbill',13466739,'1',{ts'2024-04-15  00:00:00'},'e_pricetaxtotalbase','ap_finapbill',' ',13466739);
DELETE FROM t_ap_tolerancetype WHERE FID = 1928941313563048960;
INSERT INTO t_ap_tolerancetype(FID,FCONTROLITEMNAME,FISPREINSERT,FCONTRASTITEMNAME,FCONTRASTITEM,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FCONTROLLER,FMODIFIERID,FENABLE,FMODIFYTIME,FCONTROLITEM,FCONTRASTER,FDESCRIBE,FCREATORID) VALUES (1928941313563048960,'明细.税额(本位币)','1','明细.税额(本位币)','e_taxlocalamt',1928941313563048960,'C','040_s','财务应付税额本位币微调差异',{ts'2024-04-15  00:00:00'},'ap_finapbill',13466739,'1',{ts'2024-04-15  00:00:00'},'e_taxlocalamt','ap_finapbill',' ',13466739);

-- 预置容差类型多语言脚本
DELETE FROM t_ap_tolerancetype_l WHERE FPKID = '40YC9YIP6B=5';
INSERT INTO t_ap_tolerancetype_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1928940693972073472,'40YC9YIP6B=5','zh_CN','财务应付金额本位币微调差异');
DELETE FROM t_ap_tolerancetype_l WHERE FPKID = '40YC9YIP6B=6';
INSERT INTO t_ap_tolerancetype_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1928940693972073472,'40YC9YIP6B=6','zh_TW','財務應付金額本位幣微調差異');
DELETE FROM t_ap_tolerancetype_l WHERE FPKID = '40YCJPVT0DOW';
INSERT INTO t_ap_tolerancetype_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1928942186330603520,'40YCJPVT0DOW','zh_CN','财务应收税额本位币微调差异');
DELETE FROM t_ap_tolerancetype_l WHERE FPKID = '40YCJPVT0DOX';
INSERT INTO t_ap_tolerancetype_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1928942186330603520,'40YCJPVT0DOX','zh_TW','財務應收稅額本位幣微調差異');
DELETE FROM t_ap_tolerancetype_l WHERE FPKID = '40YCH19CM8=8';
INSERT INTO t_ap_tolerancetype_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1928941821786865664,'40YCH19CM8=8','zh_CN','财务应收金额本位币微调差异');
DELETE FROM t_ap_tolerancetype_l WHERE FPKID = '40YCH19CM8=9';
INSERT INTO t_ap_tolerancetype_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1928941821786865664,'40YCH19CM8=9','zh_TW','財務應收金額本位幣微調差異');
DELETE FROM t_ap_tolerancetype_l WHERE FPKID = '40YCM4J3L2IS';
INSERT INTO t_ap_tolerancetype_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1928942519459003392,'40YCM4J3L2IS','zh_CN','财务应收应收金额本位币微调差异');
DELETE FROM t_ap_tolerancetype_l WHERE FPKID = '40YCM4J3L2IT';
INSERT INTO t_ap_tolerancetype_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1928942519459003392,'40YCM4J3L2IT','zh_TW','財務應收應收金額本位幣微調差異');
DELETE FROM t_ap_tolerancetype_l WHERE FPKID = '40YCF6TKO75B';
INSERT INTO t_ap_tolerancetype_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1928941566840290304,'40YCF6TKO75B','zh_CN','财务应付应付金额本位币微调差异');
DELETE FROM t_ap_tolerancetype_l WHERE FPKID = '40YCF6TKO75C';
INSERT INTO t_ap_tolerancetype_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1928941566840290304,'40YCF6TKO75C','zh_TW','財務應付應付金額本位幣微調差異');
DELETE FROM t_ap_tolerancetype_l WHERE FPKID = '40YCDBXBZH15';
INSERT INTO t_ap_tolerancetype_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1928941313563048960,'40YCDBXBZH15','zh_CN','财务应付税额本位币微调差异');
DELETE FROM t_ap_tolerancetype_l WHERE FPKID = '40YCDBXBZH16';
INSERT INTO t_ap_tolerancetype_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1928941313563048960,'40YCDBXBZH16','zh_TW','財務應付稅額本位幣微調差異');


-- 预置容差方案脚本
DELETE FROM t_ap_tolerancescheme WHERE FID = 1928944945746426880;
INSERT INTO t_ap_tolerancescheme(FID,FCREATORID,FMODIFYTIME,FNAME,FCREATETIME,FDESCRIBE,FNUMBER,FSTATUS,FMODIFIERID,FCONTRASTER,FENABLE,FCONTROLLER,FMASTERID,FISPREINSERT) VALUES (1928944945746426880,13466739,{ts'2024-04-15  00:00:00'},'财务应收微调本位币容差方案',{ts'2024-04-15  00:00:00'},' ','RC080','C',13466739,'ar_finarbill','1','ar_finarbill',1928944945746426880,'1');
DELETE FROM t_ap_tolerancescheme WHERE FID = 1928943464444084224;
INSERT INTO t_ap_tolerancescheme(FID,FCREATORID,FMODIFYTIME,FNAME,FCREATETIME,FDESCRIBE,FNUMBER,FSTATUS,FMODIFIERID,FCONTRASTER,FENABLE,FCONTROLLER,FMASTERID,FISPREINSERT) VALUES (1928943464444084224,13466739,{ts'2024-04-15  00:00:00'},'财务应付微调本位币容差方案',{ts'2024-04-15  00:00:00'},' ','RC079','C',13466739,'ap_finapbill','1','ap_finapbill',1928943464444084224,'1');

-- 预置容差方案多语言脚本
DELETE FROM t_ap_tolerancescheme_l WHERE FPKID = '40YD1U1OYUIX';
INSERT INTO t_ap_tolerancescheme_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1928944945746426880,'40YD1U1OYUIX','zh_CN','财务应收微调本位币容差方案');
DELETE FROM t_ap_tolerancescheme_l WHERE FPKID = '40YD1U1OYUIY';
INSERT INTO t_ap_tolerancescheme_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1928944945746426880,'40YD1U1OYUIY','zh_TW','財務應收微調本位幣容差方案');
DELETE FROM t_ap_tolerancescheme_l WHERE FPKID = '40YCT03P709W';
INSERT INTO t_ap_tolerancescheme_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1928943464444084224,'40YCT03P709W','zh_CN','财务应付微调本位币容差方案');
DELETE FROM t_ap_tolerancescheme_l WHERE FPKID = '40YCT03P709X';
INSERT INTO t_ap_tolerancescheme_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1928943464444084224,'40YCT03P709X','zh_TW','財務應付微調本位幣容差方案');

-- 预置容差方案规则脚本
DELETE FROM t_ap_toleranceruleentry WHERE FENTRYID = 1932000581505826816;
INSERT INTO t_ap_toleranceruleentry(FID,FTOLERANCEDIM,FISPREINSERT,FUPTOLERANCETYPE,FTOLERANCETYPEID,FLIMITTOLERANCETYPE,FENTRYID,FDIMENSIONMAP,FSEQ,FDIMENSIONMAP_TAG) VALUES (1928944945746426880,' ','1','numerical',1928941821786865664,'numerical',1932000581505826816,' ',1,' ');
DELETE FROM t_ap_toleranceruleentry WHERE FENTRYID = 1932000581505826817;
INSERT INTO t_ap_toleranceruleentry(FID,FTOLERANCEDIM,FISPREINSERT,FUPTOLERANCETYPE,FTOLERANCETYPEID,FLIMITTOLERANCETYPE,FENTRYID,FDIMENSIONMAP,FSEQ,FDIMENSIONMAP_TAG) VALUES (1928944945746426880,' ','1','numerical',1928942186330603520,'numerical',1932000581505826817,' ',2,' ');
DELETE FROM t_ap_toleranceruleentry WHERE FENTRYID = 1932000581505826818;
INSERT INTO t_ap_toleranceruleentry(FID,FTOLERANCEDIM,FISPREINSERT,FUPTOLERANCETYPE,FTOLERANCETYPEID,FLIMITTOLERANCETYPE,FENTRYID,FDIMENSIONMAP,FSEQ,FDIMENSIONMAP_TAG) VALUES (1928944945746426880,' ','1','numerical',1928942519459003392,'numerical',1932000581505826818,' ',3,' ');
DELETE FROM t_ap_toleranceruleentry WHERE FENTRYID = 1932000297945710592;
INSERT INTO t_ap_toleranceruleentry(FID,FTOLERANCEDIM,FISPREINSERT,FUPTOLERANCETYPE,FTOLERANCETYPEID,FLIMITTOLERANCETYPE,FENTRYID,FDIMENSIONMAP,FSEQ,FDIMENSIONMAP_TAG) VALUES (1928943464444084224,' ','1','numerical',1928940693972073472,'numerical',1932000297945710592,' ',1,' ');
DELETE FROM t_ap_toleranceruleentry WHERE FENTRYID = 1932000297945710593;
INSERT INTO t_ap_toleranceruleentry(FID,FTOLERANCEDIM,FISPREINSERT,FUPTOLERANCETYPE,FTOLERANCETYPEID,FLIMITTOLERANCETYPE,FENTRYID,FDIMENSIONMAP,FSEQ,FDIMENSIONMAP_TAG) VALUES (1928943464444084224,' ','1','numerical',1928941313563048960,'numerical',1932000297945710593,' ',2,' ');
DELETE FROM t_ap_toleranceruleentry WHERE FENTRYID = 1932000297945710594;
INSERT INTO t_ap_toleranceruleentry(FID,FTOLERANCEDIM,FISPREINSERT,FUPTOLERANCETYPE,FTOLERANCETYPEID,FLIMITTOLERANCETYPE,FENTRYID,FDIMENSIONMAP,FSEQ,FDIMENSIONMAP_TAG) VALUES (1928943464444084224,' ','1','numerical',1928941566840290304,'numerical',1932000297945710594,' ',3,' ');

-- 预置容差范围脚本
DELETE FROM t_ap_tolerancerange WHERE FDETAILID = 1932000581505827840;
INSERT INTO t_ap_tolerancerange(FDIMENSIONPK1,FDIMENSIONPK2,FDIMENSIONPK2_TAG,FDIMENSIONPK7,FDIMENSIONPK8,FDIMENSIONPK9,FDIMENSIONPK7_TAG,FDIMENSIONPK3,FUPTOLERANCE,FDIMENSIONPK4,FDIMENSIONPK5,FDIMENSIONPK6,FDETAILID,FDIMENSIONPK5_TAG,FDIMENSIONPK1_TAG,FDIMENSIONPK6_TAG,FSEQ,FDIMENSIONPK9_TAG,FDIMENSIONPK4_TAG,FLIMITTOLERANCE,FENTRYID,FDIMENSIONPK10,FDIMENSIONPK3_TAG,FDIMENSIONPK8_TAG,FDIMENSIONPK10_TAG) VALUES (' ',' ',' ',' ',' ',' ',' ',' ',0,' ',' ',' ',1932000581505827840,' ',' ',' ',1,' ',' ',0,1932000581505826816,' ',' ',' ',' ');
DELETE FROM t_ap_tolerancerange WHERE FDETAILID = 1932000581505827841;
INSERT INTO t_ap_tolerancerange(FDIMENSIONPK1,FDIMENSIONPK2,FDIMENSIONPK2_TAG,FDIMENSIONPK7,FDIMENSIONPK8,FDIMENSIONPK9,FDIMENSIONPK7_TAG,FDIMENSIONPK3,FUPTOLERANCE,FDIMENSIONPK4,FDIMENSIONPK5,FDIMENSIONPK6,FDETAILID,FDIMENSIONPK5_TAG,FDIMENSIONPK1_TAG,FDIMENSIONPK6_TAG,FSEQ,FDIMENSIONPK9_TAG,FDIMENSIONPK4_TAG,FLIMITTOLERANCE,FENTRYID,FDIMENSIONPK10,FDIMENSIONPK3_TAG,FDIMENSIONPK8_TAG,FDIMENSIONPK10_TAG) VALUES (' ',' ',' ',' ',' ',' ',' ',' ',0,' ',' ',' ',1932000581505827841,' ',' ',' ',1,' ',' ',0,1932000581505826817,' ',' ',' ',' ');
DELETE FROM t_ap_tolerancerange WHERE FDETAILID = 1932000581505827842;
INSERT INTO t_ap_tolerancerange(FDIMENSIONPK1,FDIMENSIONPK2,FDIMENSIONPK2_TAG,FDIMENSIONPK7,FDIMENSIONPK8,FDIMENSIONPK9,FDIMENSIONPK7_TAG,FDIMENSIONPK3,FUPTOLERANCE,FDIMENSIONPK4,FDIMENSIONPK5,FDIMENSIONPK6,FDETAILID,FDIMENSIONPK5_TAG,FDIMENSIONPK1_TAG,FDIMENSIONPK6_TAG,FSEQ,FDIMENSIONPK9_TAG,FDIMENSIONPK4_TAG,FLIMITTOLERANCE,FENTRYID,FDIMENSIONPK10,FDIMENSIONPK3_TAG,FDIMENSIONPK8_TAG,FDIMENSIONPK10_TAG) VALUES (' ',' ',' ',' ',' ',' ',' ',' ',0,' ',' ',' ',1932000581505827842,' ',' ',' ',1,' ',' ',0,1932000581505826818,' ',' ',' ',' ');
DELETE FROM t_ap_tolerancerange WHERE FDETAILID = 1932000297945711616;
INSERT INTO t_ap_tolerancerange(FDIMENSIONPK1,FDIMENSIONPK2,FDIMENSIONPK2_TAG,FDIMENSIONPK7,FDIMENSIONPK8,FDIMENSIONPK9,FDIMENSIONPK7_TAG,FDIMENSIONPK3,FUPTOLERANCE,FDIMENSIONPK4,FDIMENSIONPK5,FDIMENSIONPK6,FDETAILID,FDIMENSIONPK5_TAG,FDIMENSIONPK1_TAG,FDIMENSIONPK6_TAG,FSEQ,FDIMENSIONPK9_TAG,FDIMENSIONPK4_TAG,FLIMITTOLERANCE,FENTRYID,FDIMENSIONPK10,FDIMENSIONPK3_TAG,FDIMENSIONPK8_TAG,FDIMENSIONPK10_TAG) VALUES (' ',' ',' ',' ',' ',' ',' ',' ',0,' ',' ',' ',1932000297945711616,' ',' ',' ',1,' ',' ',0,1932000297945710592,' ',' ',' ',' ');
DELETE FROM t_ap_tolerancerange WHERE FDETAILID = 1932000297945711617;
INSERT INTO t_ap_tolerancerange(FDIMENSIONPK1,FDIMENSIONPK2,FDIMENSIONPK2_TAG,FDIMENSIONPK7,FDIMENSIONPK8,FDIMENSIONPK9,FDIMENSIONPK7_TAG,FDIMENSIONPK3,FUPTOLERANCE,FDIMENSIONPK4,FDIMENSIONPK5,FDIMENSIONPK6,FDETAILID,FDIMENSIONPK5_TAG,FDIMENSIONPK1_TAG,FDIMENSIONPK6_TAG,FSEQ,FDIMENSIONPK9_TAG,FDIMENSIONPK4_TAG,FLIMITTOLERANCE,FENTRYID,FDIMENSIONPK10,FDIMENSIONPK3_TAG,FDIMENSIONPK8_TAG,FDIMENSIONPK10_TAG) VALUES (' ',' ',' ',' ',' ',' ',' ',' ',0,' ',' ',' ',1932000297945711617,' ',' ',' ',1,' ',' ',0,1932000297945710593,' ',' ',' ',' ');
DELETE FROM t_ap_tolerancerange WHERE FDETAILID = 1932000297945711618;
INSERT INTO t_ap_tolerancerange(FDIMENSIONPK1,FDIMENSIONPK2,FDIMENSIONPK2_TAG,FDIMENSIONPK7,FDIMENSIONPK8,FDIMENSIONPK9,FDIMENSIONPK7_TAG,FDIMENSIONPK3,FUPTOLERANCE,FDIMENSIONPK4,FDIMENSIONPK5,FDIMENSIONPK6,FDETAILID,FDIMENSIONPK5_TAG,FDIMENSIONPK1_TAG,FDIMENSIONPK6_TAG,FSEQ,FDIMENSIONPK9_TAG,FDIMENSIONPK4_TAG,FLIMITTOLERANCE,FENTRYID,FDIMENSIONPK10,FDIMENSIONPK3_TAG,FDIMENSIONPK8_TAG,FDIMENSIONPK10_TAG) VALUES (' ',' ',' ',' ',' ',' ',' ',' ',0,' ',' ',' ',1932000297945711618,' ',' ',' ',1,' ',' ',0,1932000297945710594,' ',' ',' ',' ');





