-- rpa方案表头
DELETE FROM t_ar_rpascheme WHERE FID = 1743566836009539584;
INSERT INTO t_ar_rpascheme(FID,FCREATORID,FREMARK,FMODIFYTIME,FNAME,FCREATETIME,FNUMBER,FSTATUS,FMODIFIERID,FENABLE,FSHEDULEPLANID,FEXECUTERID,FMASTERID,FEXCEPLANDESC) VALUES (1743566836009539584,1,' ',{ts'2023-08-03  00:00:00'},'应收冲应付结算方案 （代垫）',{ts'2023-08-03  00:00:00'},'AR0001','A',1,'1',' ',1,1743566836009539584,' ');

-- rpa方案表头多语言
DELETE FROM t_ar_rpascheme_l WHERE FPKID = '3G59JLGAMIK3';
INSERT INTO t_ar_rpascheme_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1743566836009539584,'3G59JLGAMIK3','zh_CN','应收冲应付结算方案 （代垫）');
DELETE FROM t_ar_rpascheme_l WHERE FPKID = '3G59JLGAMIK4';
INSERT INTO t_ar_rpascheme_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1743566836009539584,'3G59JLGAMIK4','zh_TW','應收衝應付結算方案 （代墊）');

-- rpa方案适用组织
DELETE FROM t_ar_rpaschemeorgentry WHERE FENTRYID = 1743569978138826754;
INSERT INTO t_ar_rpaschemeorgentry(FID,FORGID,FENTRYID,FSEQ) VALUES (1743566836009539584,100000,1743569978138826754,1);

-- rpa方案执行规则
DELETE FROM t_ar_rpascheruleentry WHERE FENTRYID = 1743569978138827776;
INSERT INTO t_ar_rpascheruleentry(FID,FASSTACTMATCH,FMAINFILTER,FMAINFILTER_TAG,FENTRYID,FASSTDATESRC,FSEQ,FTIMEORDER,FASSTFILTER_TAG,FASSTFILTER,FASSTBILL,FMAINDATESRC,FCURRENCYMATCH,FSETTLERELATION,FDESCRIPTION,FMATCHFIELDINFO,FMAINBILL) VALUES (1743566836009539584,'0',' ',' ',1743569978138827776,'bizdate',1,'asc',' ',' ','ap_finapbill','bizdate','0','arapsettle','采购方代垫采购运费，扣除代垫费用给供应商付款','[{"splitsign":"","isnullmatch":false,"matchrelation":"0","asstfield":"org.number","mainfield":"org.number","preference":true},{"splitsign":"","isnullmatch":false,"matchrelation":"0","asstfield":"currency.number","mainfield":"currency.number","preference":true}]','ar_finarbill');





