-- 取数规则
DELETE FROM T_AI_RECDATARULE WHERE FID = 874515865658216448;
INSERT INTO T_AI_RECDATARULE(FID,FCREATEORGID,FORGID,FMASTERID,FAMOUNTTYPE,FSTATUS,FCTRLSTRATEGY,FNUMBER,FUSEORG,FCREATETIME,FMODIFIERID,FENABLE,FBIZAPP,FMODIFYTIME,FPRESET,FCREATORID) VALUES (874515865658216448,100000,100000,874515865658216448,0,'C','6',' ',100000,{ts'2020-04-21  14:23:10'},0,'1','/BBRH+122=39',{ts'2021-03-11  10:14:35'},'1',0); 


-- 对账维度
DELETE FROM t_ai_recdatarule_assist WHERE FPKID = 874515865792434176;
INSERT INTO t_ai_recdatarule_assist(FID,FBASEDATAID,FPKID) VALUES (874515865658216448,'bd_customer',874515865792434176); 
DELETE FROM t_ai_recdatarule_assist WHERE FPKID = 874515865792434177;
INSERT INTO t_ai_recdatarule_assist(FID,FBASEDATAID,FPKID) VALUES (874515865658216448,'bd_currency',874515865792434177); 


-- 取数规则多语言
DELETE FROM T_AI_RECDATARULE_L WHERE FPKID = '0QDPI4FJ7I77';
INSERT INTO T_AI_RECDATARULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES (874515865658216448,'0QDPI4FJ7I77','zh_CN','应收取数规则（预置）'); 
DELETE FROM T_AI_RECDATARULE_L WHERE FPKID = '0QDPI4FJ7I78';
INSERT INTO T_AI_RECDATARULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES (874515865658216448,'0QDPI4FJ7I78','zh_TW','應收取數規則（預置）'); 


-- 取数规则分录
DELETE FROM T_AI_RECDATARULEENTRY WHERE FENTRYID = 874515865792435202;
INSERT INTO T_AI_RECDATARULEENTRY(FID,FAMOUNTEXP,FENTRYID,FDATATYPE,FBIZOBJ,FDETAILRULE,FAMOUNTTYPE,FAMOUNTEXP_TAG,FDATAFILTERDESC,FDATAFILTER,FDATAFILTER_TAG,FSEQ,FCOMMONFILTER,FAMOUNT) VALUES (874515865658216448,' ',874515865792435202,'0','ar_busbill',' ',874514201123509248,'recamount','是否期初 等于 是',' ','{"expression":"","exprTran":"是否期初 等于 是","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"1FD1TZV=3I2V","leftBracket":"","compareType":"105","fieldName":"isperiod","rightBracket":"","logic":"0","value":[{"id":"1FD1TZV=3HEL","value":"1"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"1FD1TZV=3I2V\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"isperiod\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"1FD1TZV=3HEL\",\"value\":\"1\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"是否期初 等于 是"},"exprDesc":"是否期初 等于 是"}',2,920154099578614784,'应收金额'); 
DELETE FROM T_AI_RECDATARULEENTRY WHERE FENTRYID = 1102313821332059136;
INSERT INTO T_AI_RECDATARULEENTRY(FID,FAMOUNTEXP,FENTRYID,FDATATYPE,FBIZOBJ,FDETAILRULE,FAMOUNTTYPE,FAMOUNTEXP_TAG,FDATAFILTERDESC,FDATAFILTER,FDATAFILTER_TAG,FSEQ,FCOMMONFILTER,FAMOUNT) VALUES (874515865658216448,' ',1102313821332059136,'0','ar_finarbill',' ',785345962716464128,'recamount','是否期初 等于 是',' ','{"expression":"","exprTran":"是否期初 等于 是","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"1FD1GXGK/W10","leftBracket":"","compareType":"105","fieldName":"isperiod","rightBracket":"","logic":"0","value":[{"id":"1FD1GXGK/VCS","value":"1"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"1FD1GXGK/W10\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"isperiod\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"1FD1GXGK/VCS\",\"value\":\"1\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"是否期初 等于 是"},"exprDesc":"是否期初 等于 是"}',1,793342889454222335,'应收金额'); 
DELETE FROM T_AI_RECDATARULEENTRY WHERE FENTRYID = 1102317283721728000;
INSERT INTO T_AI_RECDATARULEENTRY(FID,FAMOUNTEXP,FENTRYID,FDATATYPE,FBIZOBJ,FDETAILRULE,FAMOUNTTYPE,FAMOUNTEXP_TAG,FDATAFILTERDESC,FDATAFILTER,FDATAFILTER_TAG,FSEQ,FCOMMONFILTER,FAMOUNT) VALUES (874515865658216448,' ',1102317283721728000,'0','ar_receivedbill',' ',874519130848382976,'recamount','收款金额 不等于 0',' ','{"expression":"","exprTran":"收款金额 不等于 0","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"1G2A4BB3OR/R","leftBracket":"","compareType":"83","fieldName":"recamount","rightBracket":"","logic":"0","value":[{"id":"1G2A4BB3ORP/","value":"0"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"1G2A4BB3OR/R\",\"leftBracket\":\"\",\"compareType\":\"83\",\"fieldName\":\"recamount\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"1G2A4BB3ORP/\",\"value\":\"0\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"收款金额 不等于 0","localeExprTran":{"zh_CN":"收款金额 不等于 0"}}',3,1102316252107493376,'收款金额'); 
DELETE FROM T_AI_RECDATARULEENTRY WHERE FENTRYID = 1102319307129448448;
INSERT INTO T_AI_RECDATARULEENTRY(FID,FAMOUNTEXP,FENTRYID,FDATATYPE,FBIZOBJ,FDETAILRULE,FAMOUNTTYPE,FAMOUNTEXP_TAG,FDATAFILTERDESC,FDATAFILTER,FDATAFILTER_TAG,FSEQ,FCOMMONFILTER,FAMOUNT) VALUES (874515865658216448,' ',1102319307129448448,'1','ar_finarbill',' ',785345962716464128,'recamount','记账日期 <  开始日期 ',' ','{"expression":"bookdate <  con_startdate ","exprTran":"记账日期 <  开始日期 ","description":{"zh_CN":""},"filterCondition":{"filterRow":[],"forList":false},"filterString":"{\"filterRow\":[],\"forList\":false}","initialized":false,"exprDesc":"记账日期 <  开始日期 ","localeExprTran":{"zh_CN":"记账日期 <  开始日期 "}}',4,793342889454222335,'应收金额'); 
DELETE FROM T_AI_RECDATARULEENTRY WHERE FENTRYID = 1102324124556027904;
INSERT INTO T_AI_RECDATARULEENTRY(FID,FAMOUNTEXP,FENTRYID,FDATATYPE,FBIZOBJ,FDETAILRULE,FAMOUNTTYPE,FAMOUNTEXP_TAG,FDATAFILTERDESC,FDATAFILTER,FDATAFILTER_TAG,FSEQ,FCOMMONFILTER,FAMOUNT) VALUES (874515865658216448,' ',1102324124556027904,'1','ar_busbill',' ',874514201123509248,'recamount','记账日期 <  开始日期 ',' ','{"expression":"bookdate <  con_startdate ","exprTran":"记账日期 <  开始日期 ","description":{"zh_CN":""},"filterCondition":{"filterRow":[],"forList":false},"filterString":"{\"filterRow\":[],\"forList\":false}","initialized":false,"exprDesc":"记账日期 <  开始日期 ","localeExprTran":{"zh_CN":"记账日期 <  开始日期 "}}',5,920154099578614784,'应收金额'); 
DELETE FROM T_AI_RECDATARULEENTRY WHERE FENTRYID = 1102326233972092928;
INSERT INTO T_AI_RECDATARULEENTRY(FID,FAMOUNTEXP,FENTRYID,FDATATYPE,FBIZOBJ,FDETAILRULE,FAMOUNTTYPE,FAMOUNTEXP_TAG,FDATAFILTERDESC,FDATAFILTER,FDATAFILTER_TAG,FSEQ,FCOMMONFILTER,FAMOUNT) VALUES (874515865658216448,' ',1102326233972092928,'1','ar_settlerecord',' ',785345962716464128,' - totalsettleamt','结算关系 等于 应收收款结算   or    结算关系 等于 债权转移   or    结算关系 等于 应收冲应付   or    结算关系 等于 应收退款结算   or    结算关系 等于 未清项结算   or    结算关系 等于 坏账损失 且 结算日期 <  开始日期 ',' ','{"expression":"settledate <  con_startdate ","exprTran":"结算关系 等于 应收收款结算   or    结算关系 等于 债权转移   or    结算关系 等于 应收冲应付   or    结算关系 等于 应收退款结算   or    结算关系 等于 未清项结算   or    结算关系 等于 坏账损失 且 结算日期 <  开始日期 ","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"1FD3USPZ1O95","leftBracket":"","compareType":"105","fieldName":"settlerelation","rightBracket":"","logic":"1","value":[{"id":"1FD3USPZ23RU","value":"recsettle"}],"baseDataIds":[]},{"id":"1FD3USPZ1O96","leftBracket":"","compareType":"105","fieldName":"settlerelation","rightBracket":"","logic":"1","value":[{"id":"1FD3USPZ23RV","value":"artransfer"}],"baseDataIds":[]},{"id":"1FD3USPZ1O97","leftBracket":"","compareType":"105","fieldName":"settlerelation","rightBracket":"","logic":"1","value":[{"id":"1FD3USPZ23RW","value":"arapsettle"}],"baseDataIds":[]},{"id":"1FD3USPZ1O98","leftBracket":"","compareType":"105","fieldName":"settlerelation","rightBracket":"","logic":"1","value":[{"id":"1FD3USPZ23RX","value":"arpaysettle"}],"baseDataIds":[]},{"id":"1FD3USPZ1O99","leftBracket":"","compareType":"105","fieldName":"settlerelation","rightBracket":"","logic":"1","value":[{"id":"1FD3USPZ23RY","value":"arliqsettle"}],"baseDataIds":[]},{"id":"1FD3USPZ1O9=","leftBracket":"","compareType":"105","fieldName":"settlerelation","rightBracket":"","logic":"1","value":[{"id":"1FD3USPZ23RZ","value":"baddebtloss"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"1FD3USPZ1O95\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"settlerelation\",\"rightBracket\":\"\",\"logic\":\"1\",\"value\":[{\"id\":\"1FD3USPZ23RU\",\"value\":\"recsettle\"}],\"baseDataIds\":[]},{\"id\":\"1FD3USPZ1O96\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"settlerelation\",\"rightBracket\":\"\",\"logic\":\"1\",\"value\":[{\"id\":\"1FD3USPZ23RV\",\"value\":\"artransfer\"}],\"baseDataIds\":[]},{\"id\":\"1FD3USPZ1O97\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"settlerelation\",\"rightBracket\":\"\",\"logic\":\"1\",\"value\":[{\"id\":\"1FD3USPZ23RW\",\"value\":\"arapsettle\"}],\"baseDataIds\":[]},{\"id\":\"1FD3USPZ1O98\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"settlerelation\",\"rightBracket\":\"\",\"logic\":\"1\",\"value\":[{\"id\":\"1FD3USPZ23RX\",\"value\":\"arpaysettle\"}],\"baseDataIds\":[]},{\"id\":\"1FD3USPZ1O99\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"settlerelation\",\"rightBracket\":\"\",\"logic\":\"1\",\"value\":[{\"id\":\"1FD3USPZ23RY\",\"value\":\"arliqsettle\"}],\"baseDataIds\":[]},{\"id\":\"1FD3USPZ1O9=\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"settlerelation\",\"rightBracket\":\"\",\"logic\":\"1\",\"value\":[{\"id\":\"1FD3USPZ23RZ\",\"value\":\"baddebtloss\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"结算关系 等于 应收收款结算   or    结算关系 等于 债权转移   or    结算关系 等于 应收冲应付   or    结算关系 等于 应收退款结算   or    结算关系 等于 未清项结算   or    结算关系 等于 坏账损失 且 结算日期 <  开始日期 ","localeExprTran":{"zh_CN":"结算关系 等于 应收收款结算   or    结算关系 等于 债权转移   or    结算关系 等于 应收冲应付   or    结算关系 等于 应收退款结算   or    结算关系 等于 未清项结算   or    结算关系 等于 坏账损失 且 结算日期 <  开始日期 "}}',6,1102324724710625280,' - 本次结算金额'); 
DELETE FROM T_AI_RECDATARULEENTRY WHERE FENTRYID = 1102327231520270336;
INSERT INTO T_AI_RECDATARULEENTRY(FID,FAMOUNTEXP,FENTRYID,FDATATYPE,FBIZOBJ,FDETAILRULE,FAMOUNTTYPE,FAMOUNTEXP_TAG,FDATAFILTERDESC,FDATAFILTER,FDATAFILTER_TAG,FSEQ,FCOMMONFILTER,FAMOUNT) VALUES (874515865658216448,' ',1102327231520270336,'1','ar_receivedbill',' ',874519130848382976,'recamount','收款金额 不等于 0',' ','{"expression":"","exprTran":"收款金额 不等于 0","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"1G2A56C32G=3","leftBracket":"","compareType":"83","fieldName":"recamount","rightBracket":"","logic":"0","value":[{"id":"1G2A56C32FLV","value":"0"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"1G2A56C32G=3\",\"leftBracket\":\"\",\"compareType\":\"83\",\"fieldName\":\"recamount\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"1G2A56C32FLV\",\"value\":\"0\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"收款金额 不等于 0","localeExprTran":{"zh_CN":"收款金额 不等于 0"}}',8,1102316252107493376,'收款金额'); 
DELETE FROM T_AI_RECDATARULEENTRY WHERE FENTRYID = 1102329249995515904;
INSERT INTO T_AI_RECDATARULEENTRY(FID,FAMOUNTEXP,FENTRYID,FDATATYPE,FBIZOBJ,FDETAILRULE,FAMOUNTTYPE,FAMOUNTEXP_TAG,FDATAFILTERDESC,FDATAFILTER,FDATAFILTER_TAG,FSEQ,FCOMMONFILTER,FAMOUNT) VALUES (874515865658216448,' ',1102329249995515904,'1','cas_recbill',' ',874519130848382976,'e_receivableamt','收款类型.业务类型 等于 预收款 且  业务日期  <  开始日期 ',' ','{"expression":" bizdate  <  con_startdate ","exprTran":"收款类型.业务类型 等于 预收款 且  业务日期  <  开始日期 ","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"1FJ0Z1KQBXUY","leftBracket":"","compareType":"105","fieldName":"receivingtype.biztype","rightBracket":"","logic":"0","value":[{"id":"1FJ0Z1KQBYI6","value":"101"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"1FJ0Z1KQBXUY\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"receivingtype.biztype\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"1FJ0Z1KQBYI6\",\"value\":\"101\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"收款类型.业务类型 等于 预收款 且  业务日期  <  开始日期 "},"exprDesc":"收款类型.业务类型 等于 预收款 且  业务日期  <  开始日期 "}',9,874514579323900928,'应收金额');
DELETE FROM T_AI_RECDATARULEENTRY WHERE FENTRYID = 1102340322094075904;
INSERT INTO T_AI_RECDATARULEENTRY(FID,FAMOUNTEXP,FENTRYID,FDATATYPE,FBIZOBJ,FDETAILRULE,FAMOUNTTYPE,FAMOUNTEXP_TAG,FDATAFILTERDESC,FDATAFILTER,FDATAFILTER_TAG,FSEQ,FCOMMONFILTER,FAMOUNT) VALUES (874515865658216448,' ',1102340322094075904,'1','ar_settlerecord',' ',874519130848382976,' - settleamt ','结算关系 等于 应收收款结算   and    单据体.单据类型 等于 预收款 且 结算日期 <  开始日期 ',' ','{"expression":"settledate <  con_startdate ","exprTran":"结算关系 等于 应收收款结算   and    单据体.单据类型 等于 预收款 且 结算日期 <  开始日期 ","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"1FD6EWTNIPI9","leftBracket":"","compareType":"105","fieldName":"settlerelation","rightBracket":"","logic":"0","value":[{"id":"1FD6EWTNJ5/Y","value":"recsettle"}],"baseDataIds":[]},{"id":"1FD6EWTNIPI=","leftBracket":"","compareType":"105","fieldName":"billtype","rightBracket":"","logic":"0","value":[{"id":"1FD6EWTNJ5/Z","value":"advrec"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"1FD6EWTNIPI9\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"settlerelation\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"1FD6EWTNJ5/Y\",\"value\":\"recsettle\"}],\"baseDataIds\":[]},{\"id\":\"1FD6EWTNIPI=\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"billtype\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"1FD6EWTNJ5/Z\",\"value\":\"advrec\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"结算关系 等于 应收收款结算   and    单据体.单据类型 等于 预收款 且 结算日期 <  开始日期 ","localeExprTran":{"zh_CN":"结算关系 等于 应收收款结算   and    单据体.单据类型 等于 预收款 且 结算日期 <  开始日期 "}}',10,1103011200851015680,' - 本次结算金额 ');
DELETE FROM T_AI_RECDATARULEENTRY WHERE FENTRYID = 1102341052968298496;
INSERT INTO T_AI_RECDATARULEENTRY(FID,FAMOUNTEXP,FENTRYID,FDATATYPE,FBIZOBJ,FDETAILRULE,FAMOUNTTYPE,FAMOUNTEXP_TAG,FDATAFILTERDESC,FDATAFILTER,FDATAFILTER_TAG,FSEQ,FCOMMONFILTER,FAMOUNT) VALUES (874515865658216448,' ',1102341052968298496,'1','ar_settlerecord',' ',874519130848382976,' - totalsettleamt ','结算关系 等于 收款冲付款   and    单据类型 等于 预收款 且 结算日期 <  开始日期 ',' ','{"expression":"settledate <  con_startdate ","exprTran":"结算关系 等于 收款冲付款   and    单据类型 等于 预收款 且 结算日期 <  开始日期 ","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"1FD6LQ574PSW","leftBracket":"","compareType":"105","fieldName":"settlerelation","rightBracket":"","logic":"0","value":[{"id":"1FD6LQ574P3M","value":"recpaysettle"}],"baseDataIds":[]},{"id":"1FD6LQ574PSX","leftBracket":"","compareType":"105","fieldName":"mainbilltype","rightBracket":"","logic":"0","value":[{"id":"1FD6LQ574P3N","value":"advrec"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"1FD6LQ574PSW\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"settlerelation\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"1FD6LQ574P3M\",\"value\":\"recpaysettle\"}],\"baseDataIds\":[]},{\"id\":\"1FD6LQ574PSX\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"mainbilltype\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"1FD6LQ574P3N\",\"value\":\"advrec\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"结算关系 等于 收款冲付款   and    单据类型 等于 预收款 且 结算日期 <  开始日期 "},"exprDesc":"结算关系 等于 收款冲付款   and    单据类型 等于 预收款 且 结算日期 <  开始日期 "}',11,1102324724710625280,' - 本次结算金额 ');
DELETE FROM T_AI_RECDATARULEENTRY WHERE FENTRYID = 1102349829104848896;
INSERT INTO T_AI_RECDATARULEENTRY(FID,FAMOUNTEXP,FENTRYID,FDATATYPE,FBIZOBJ,FDETAILRULE,FAMOUNTTYPE,FAMOUNTEXP_TAG,FDATAFILTERDESC,FDATAFILTER,FDATAFILTER_TAG,FSEQ,FCOMMONFILTER,FAMOUNT) VALUES (874515865658216448,' ',1102349829104848896,'2','ar_finarbill',' ',785345962716464128,'recamount',' ',' ','{"expression":"","exprTran":"","description":{"zh_CN":""},"filterCondition":{"filterRow":[],"forList":false},"filterString":"{\"filterRow\":[],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":""},"exprDesc":""}',13,1102318327205816320,'应收金额');
DELETE FROM T_AI_RECDATARULEENTRY WHERE FENTRYID = 1102352579855134720;
INSERT INTO T_AI_RECDATARULEENTRY(FID,FAMOUNTEXP,FENTRYID,FDATATYPE,FBIZOBJ,FDETAILRULE,FAMOUNTTYPE,FAMOUNTEXP_TAG,FDATAFILTERDESC,FDATAFILTER,FDATAFILTER_TAG,FSEQ,FCOMMONFILTER,FAMOUNT) VALUES (874515865658216448,' ',1102352579855134720,'3','ar_settlerecord',' ',785345962716464128,'totalsettleamt','结算关系 等于 应收收款结算   or    结算关系 等于 债权转移   or    结算关系 等于 应收冲应付   or    结算关系 等于 应收退款结算   or    结算关系 等于 未清项结算   or    结算关系 等于 坏账损失',' ','{"expression":"","exprTran":"结算关系 等于 应收收款结算   or    结算关系 等于 债权转移   or    结算关系 等于 应收冲应付   or    结算关系 等于 应收退款结算   or    结算关系 等于 未清项结算   or    结算关系 等于 坏账损失","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"1FD8SBYIKFO+","leftBracket":"","compareType":"105","fieldName":"settlerelation","rightBracket":"","logic":"1","value":[{"id":"1FD8SBYIKX5N","value":"recsettle"}],"baseDataIds":[]},{"id":"1FD8SBYIKFO/","leftBracket":"","compareType":"105","fieldName":"settlerelation","rightBracket":"","logic":"1","value":[{"id":"1FD8SBYIKX5O","value":"artransfer"}],"baseDataIds":[]},{"id":"1FD8SBYIKFO0","leftBracket":"","compareType":"105","fieldName":"settlerelation","rightBracket":"","logic":"1","value":[{"id":"1FD8SBYIKX5P","value":"arapsettle"}],"baseDataIds":[]},{"id":"1FD8SBYIKFO1","leftBracket":"","compareType":"105","fieldName":"settlerelation","rightBracket":"","logic":"1","value":[{"id":"1FD8SBYIKX5Q","value":"arpaysettle"}],"baseDataIds":[]},{"id":"1FD8SBYIKFO2","leftBracket":"","compareType":"105","fieldName":"settlerelation","rightBracket":"","logic":"1","value":[{"id":"1FD8SBYIKX5R","value":"arliqsettle"}],"baseDataIds":[]},{"id":"1FD8SBYIKFO3","leftBracket":"","compareType":"105","fieldName":"settlerelation","rightBracket":"","logic":"1","value":[{"id":"1FD8SBYIKX5S","value":"baddebtloss"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"1FD8SBYIKFO+\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"settlerelation\",\"rightBracket\":\"\",\"logic\":\"1\",\"value\":[{\"id\":\"1FD8SBYIKX5N\",\"value\":\"recsettle\"}],\"baseDataIds\":[]},{\"id\":\"1FD8SBYIKFO/\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"settlerelation\",\"rightBracket\":\"\",\"logic\":\"1\",\"value\":[{\"id\":\"1FD8SBYIKX5O\",\"value\":\"artransfer\"}],\"baseDataIds\":[]},{\"id\":\"1FD8SBYIKFO0\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"settlerelation\",\"rightBracket\":\"\",\"logic\":\"1\",\"value\":[{\"id\":\"1FD8SBYIKX5P\",\"value\":\"arapsettle\"}],\"baseDataIds\":[]},{\"id\":\"1FD8SBYIKFO1\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"settlerelation\",\"rightBracket\":\"\",\"logic\":\"1\",\"value\":[{\"id\":\"1FD8SBYIKX5Q\",\"value\":\"arpaysettle\"}],\"baseDataIds\":[]},{\"id\":\"1FD8SBYIKFO2\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"settlerelation\",\"rightBracket\":\"\",\"logic\":\"1\",\"value\":[{\"id\":\"1FD8SBYIKX5R\",\"value\":\"arliqsettle\"}],\"baseDataIds\":[]},{\"id\":\"1FD8SBYIKFO3\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"settlerelation\",\"rightBracket\":\"\",\"logic\":\"1\",\"value\":[{\"id\":\"1FD8SBYIKX5S\",\"value\":\"baddebtloss\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"结算关系 等于 应收收款结算   or    结算关系 等于 债权转移   or    结算关系 等于 应收冲应付   or    结算关系 等于 应收退款结算   or    结算关系 等于 未清项结算   or    结算关系 等于 坏账损失","localeExprTran":{"zh_CN":"结算关系 等于 应收收款结算   or    结算关系 等于 债权转移   or    结算关系 等于 应收冲应付   or    结算关系 等于 应收退款结算   or    结算关系 等于 未清项结算   or    结算关系 等于 坏账损失"}}',14,1102350607718639616,'本次结算金额');
DELETE FROM T_AI_RECDATARULEENTRY WHERE FENTRYID = 1102354211422613504;
INSERT INTO T_AI_RECDATARULEENTRY(FID,FAMOUNTEXP,FENTRYID,FDATATYPE,FBIZOBJ,FDETAILRULE,FAMOUNTTYPE,FAMOUNTEXP_TAG,FDATAFILTERDESC,FDATAFILTER,FDATAFILTER_TAG,FSEQ,FCOMMONFILTER,FAMOUNT) VALUES (874515865658216448,' ',1102354211422613504,'2','ar_busbill',' ',874514201123509248,'recamount',' ',' ','{"expression":"","exprTran":"","description":{"zh_CN":""},"filterCondition":{"filterRow":[],"forList":false},"filterString":"{\"filterRow\":[],\"forList\":false}","initialized":false,"exprDesc":"","localeExprTran":{"zh_CN":""}}',16,1102353566841975808,'应收金额');
DELETE FROM T_AI_RECDATARULEENTRY WHERE FENTRYID = 1102355506724431872;
INSERT INTO T_AI_RECDATARULEENTRY(FID,FAMOUNTEXP,FENTRYID,FDATATYPE,FBIZOBJ,FDETAILRULE,FAMOUNTTYPE,FAMOUNTEXP_TAG,FDATAFILTERDESC,FDATAFILTER,FDATAFILTER_TAG,FSEQ,FCOMMONFILTER,FAMOUNT) VALUES (874515865658216448,' ',1102355506724431872,'3','cas_recbill',' ',874519130848382976,'e_receivableamt','收款类型.业务类型 等于 预收款',' ','{"expression":"","exprTran":"收款类型.业务类型 等于 预收款","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"1FD9ALC3C6R8","leftBracket":"","compareType":"105","fieldName":"receivingtype.biztype","rightBracket":"","logic":"0","value":[{"id":"1FD9ALC3BR8K","value":"101"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"1FD9ALC3C6R8\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"receivingtype.biztype\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"1FD9ALC3BR8K\",\"value\":\"101\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"收款类型.业务类型 等于 预收款","localeExprTran":{"zh_CN":"收款类型.业务类型 等于 预收款"}}',17,1102354837456040960,'应收金额');
DELETE FROM T_AI_RECDATARULEENTRY WHERE FENTRYID = 1102356195169022976;
INSERT INTO T_AI_RECDATARULEENTRY(FID,FAMOUNTEXP,FENTRYID,FDATATYPE,FBIZOBJ,FDETAILRULE,FAMOUNTTYPE,FAMOUNTEXP_TAG,FDATAFILTERDESC,FDATAFILTER,FDATAFILTER_TAG,FSEQ,FCOMMONFILTER,FAMOUNT) VALUES (874515865658216448,' ',1102356195169022976,'2','ar_settlerecord',' ',874519130848382976,'settleamt','结算关系 等于 应收收款结算   and    单据体.单据类型 等于 预收款',' ','{"expression":"","exprTran":"结算关系 等于 应收收款结算   and    单据体.单据类型 等于 预收款","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"1FD9F3=Z92W9","leftBracket":"","compareType":"105","fieldName":"settlerelation","rightBracket":"","logic":"0","value":[{"id":"1FD9F3=Z93JI","value":"recsettle"}],"baseDataIds":[]},{"id":"1FD9F3=Z92W=","leftBracket":"","compareType":"105","fieldName":"billtype","rightBracket":"","logic":"0","value":[{"id":"1FD9F3=Z93JJ","value":"advrec"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"1FD9F3=Z92W9\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"settlerelation\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"1FD9F3=Z93JI\",\"value\":\"recsettle\"}],\"baseDataIds\":[]},{\"id\":\"1FD9F3=Z92W=\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"billtype\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"1FD9F3=Z93JJ\",\"value\":\"advrec\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"结算关系 等于 应收收款结算   and    单据体.单据类型 等于 预收款","localeExprTran":{"zh_CN":"结算关系 等于 应收收款结算   and    单据体.单据类型 等于 预收款"}}',18,1103012088424462336,'本次结算金额'); 
DELETE FROM T_AI_RECDATARULEENTRY WHERE FENTRYID = 1102356980334343168;
INSERT INTO T_AI_RECDATARULEENTRY(FID,FAMOUNTEXP,FENTRYID,FDATATYPE,FBIZOBJ,FDETAILRULE,FAMOUNTTYPE,FAMOUNTEXP_TAG,FDATAFILTERDESC,FDATAFILTER,FDATAFILTER_TAG,FSEQ,FCOMMONFILTER,FAMOUNT) VALUES (874515865658216448,' ',1102356980334343168,'2','ar_settlerecord',' ',874519130848382976,'totalsettleamt','结算关系 等于 收款冲付款   and    单据类型 等于 预收款',' ','{"expression":"","exprTran":"结算关系 等于 收款冲付款   and    单据类型 等于 预收款","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"1FD9KXXID11D","leftBracket":"","compareType":"105","fieldName":"settlerelation","rightBracket":"","logic":"0","value":[{"id":"1FD9KXXIDHK1","value":"recpaysettle"}],"baseDataIds":[]},{"id":"1FD9KXXID11E","leftBracket":"","compareType":"105","fieldName":"mainbilltype","rightBracket":"","logic":"0","value":[{"id":"1FD9KXXIDHK2","value":"advrec"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"1FD9KXXID11D\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"settlerelation\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"1FD9KXXIDHK1\",\"value\":\"recpaysettle\"}],\"baseDataIds\":[]},{\"id\":\"1FD9KXXID11E\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"mainbilltype\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"1FD9KXXIDHK2\",\"value\":\"advrec\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"结算关系 等于 收款冲付款   and    单据类型 等于 预收款","localeExprTran":{"zh_CN":"结算关系 等于 收款冲付款   and    单据类型 等于 预收款"}}',19,1102350607718639616,'本次结算金额');
DELETE FROM T_AI_RECDATARULEENTRY WHERE FENTRYID = 1102928981922950144;
INSERT INTO T_AI_RECDATARULEENTRY(FID,FAMOUNTEXP,FENTRYID,FDATATYPE,FBIZOBJ,FDETAILRULE,FAMOUNTTYPE,FAMOUNTEXP_TAG,FDATAFILTERDESC,FDATAFILTER,FDATAFILTER_TAG,FSEQ,FCOMMONFILTER,FAMOUNT) VALUES (874515865658216448,' ',1102928981922950144,'1','ap_settlerecord',' ',785345962716464128,'- settleamt ','结算关系 等于 应付冲应收 且 结算日期 <  开始日期 ',' ','{"expression":"settledate <  con_startdate ","exprTran":"结算关系 等于 应付冲应收 且 结算日期 <  开始日期 ","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"1FG/GY7X2E56","leftBracket":"","compareType":"105","fieldName":"settlerelation","rightBracket":"","logic":"1","value":[{"id":"1FG/GY7X3YDR","value":"aparsettle"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"1FG/GY7X2E56\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"settlerelation\",\"rightBracket\":\"\",\"logic\":\"1\",\"value\":[{\"id\":\"1FG/GY7X3YDR\",\"value\":\"aparsettle\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"结算关系 等于 应付冲应收 且 结算日期 <  开始日期 "},"exprDesc":"结算关系 等于 应付冲应收 且 结算日期 <  开始日期 "}',7,1102927388305639424,'- 本次结算金额 '); 
DELETE FROM T_AI_RECDATARULEENTRY WHERE FENTRYID = 1103015310782397440;
INSERT INTO T_AI_RECDATARULEENTRY(FID,FAMOUNTEXP,FENTRYID,FDATATYPE,FBIZOBJ,FDETAILRULE,FAMOUNTTYPE,FAMOUNTEXP_TAG,FDATAFILTERDESC,FDATAFILTER,FDATAFILTER_TAG,FSEQ,FCOMMONFILTER,FAMOUNT) VALUES (874515865658216448,' ',1103015310782397440,'3','ap_settlerecord',' ',785345962716464128,'settleamt','结算关系 等于 应付冲应收',' ','{"expression":"","exprTran":"结算关系 等于 应付冲应收","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"1FGEJ8M2P4JL","leftBracket":"","compareType":"105","fieldName":"settlerelation","rightBracket":"","logic":"1","value":[{"id":"1FGEJ8M2P3WB","value":"aparsettle"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"1FGEJ8M2P4JL\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"settlerelation\",\"rightBracket\":\"\",\"logic\":\"1\",\"value\":[{\"id\":\"1FGEJ8M2P3WB\",\"value\":\"aparsettle\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"结算关系 等于 应付冲应收"},"exprDesc":"结算关系 等于 应付冲应收"}',15,1102927996320320512,'本次结算金额'); 
DELETE FROM T_AI_RECDATARULEENTRY WHERE FENTRYID = 1108628120845440000;
INSERT INTO T_AI_RECDATARULEENTRY(FID,FAMOUNTEXP,FENTRYID,FDATATYPE,FBIZOBJ,FDETAILRULE,FAMOUNTTYPE,FAMOUNTEXP_TAG,FDATAFILTERDESC,FDATAFILTER,FDATAFILTER_TAG,FSEQ,FCOMMONFILTER,FAMOUNT) VALUES (874515865658216448,' ',1108628120845440000,'1','ap_settlerecord',' ',874519130848382976,' - settleamt','( 结算关系 等于 应付退款结算   or    结算关系 等于 付款冲收款 )  and    单据体.单据类型 等于 预收款 且 结算日期 <  开始日期 ',' ','{"expression":"settledate <  con_startdate ","exprTran":"( 结算关系 等于 应付退款结算   or    结算关系 等于 付款冲收款 )  and    单据体.单据类型 等于 预收款 且 结算日期 <  开始日期 ","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"1G8/JL1ZKA5Y","leftBracket":"(","compareType":"105","fieldName":"settlerelation","rightBracket":"","logic":"1","value":[{"id":"1G8/JL1ZKC6P","value":"aprecsettle"}],"baseDataIds":[]},{"id":"1G8/JL1ZKA5Z","leftBracket":"","compareType":"105","fieldName":"settlerelation","rightBracket":")","logic":"0","value":[{"id":"1G8/JL1ZKC6Q","value":"payrecsettle"}],"baseDataIds":[]},{"id":"1G8/JL1ZKA6+","leftBracket":"","compareType":"105","fieldName":"billtype","rightBracket":"","logic":"0","value":[{"id":"1G8/JL1ZKC6R","value":"advrec"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"1G8/JL1ZKA5Y\",\"leftBracket\":\"(\",\"compareType\":\"105\",\"fieldName\":\"settlerelation\",\"rightBracket\":\"\",\"logic\":\"1\",\"value\":[{\"id\":\"1G8/JL1ZKC6P\",\"value\":\"aprecsettle\"}],\"baseDataIds\":[]},{\"id\":\"1G8/JL1ZKA5Z\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"settlerelation\",\"rightBracket\":\")\",\"logic\":\"0\",\"value\":[{\"id\":\"1G8/JL1ZKC6Q\",\"value\":\"payrecsettle\"}],\"baseDataIds\":[]},{\"id\":\"1G8/JL1ZKA6+\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"billtype\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"1G8/JL1ZKC6R\",\"value\":\"advrec\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"( 结算关系 等于 应付退款结算   or    结算关系 等于 付款冲收款 )  and    单据体.单据类型 等于 预收款 且 结算日期 <  开始日期 "},"exprDesc":"( 结算关系 等于 应付退款结算   or    结算关系 等于 付款冲收款 )  and    单据体.单据类型 等于 预收款 且 结算日期 <  开始日期 "}',12,1102927388305639424,' - 本次结算金额'); 
DELETE FROM T_AI_RECDATARULEENTRY WHERE FENTRYID = 1109191658588608512;
INSERT INTO T_AI_RECDATARULEENTRY(FID,FAMOUNTEXP,FENTRYID,FDATATYPE,FBIZOBJ,FDETAILRULE,FAMOUNTTYPE,FAMOUNTEXP_TAG,FDATAFILTERDESC,FDATAFILTER,FDATAFILTER_TAG,FSEQ,FCOMMONFILTER,FAMOUNT) VALUES (874515865658216448,' ',1109191658588608512,'2','ap_settlerecord',' ',874519130848382976,'settleamt','( 结算关系 等于 应付退款结算   or    结算关系 等于 付款冲收款 )  and    单据体.单据类型 等于 预收款',' ','{"expression":"","exprTran":"( 结算关系 等于 应付退款结算   or    结算关系 等于 付款冲收款 )  and    单据体.单据类型 等于 预收款","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"1G8/NG9TZ5T8","leftBracket":"(","compareType":"105","fieldName":"settlerelation","rightBracket":"","logic":"1","value":[{"id":"1G8/NG9TZ54+","value":"aprecsettle"}],"baseDataIds":[]},{"id":"1G8/NG9TZ5T9","leftBracket":"","compareType":"105","fieldName":"settlerelation","rightBracket":")","logic":"0","value":[{"id":"1G8/NG9TZ54/","value":"payrecsettle"}],"baseDataIds":[]},{"id":"1G8/NG9TZ5T=","leftBracket":"","compareType":"105","fieldName":"billtype","rightBracket":"","logic":"0","value":[{"id":"1G8/NG9TZ540","value":"advrec"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"1G8/NG9TZ5T8\",\"leftBracket\":\"(\",\"compareType\":\"105\",\"fieldName\":\"settlerelation\",\"rightBracket\":\"\",\"logic\":\"1\",\"value\":[{\"id\":\"1G8/NG9TZ54+\",\"value\":\"aprecsettle\"}],\"baseDataIds\":[]},{\"id\":\"1G8/NG9TZ5T9\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"settlerelation\",\"rightBracket\":\")\",\"logic\":\"0\",\"value\":[{\"id\":\"1G8/NG9TZ54/\",\"value\":\"payrecsettle\"}],\"baseDataIds\":[]},{\"id\":\"1G8/NG9TZ5T=\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"billtype\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"1G8/NG9TZ540\",\"value\":\"advrec\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"( 结算关系 等于 应付退款结算   or    结算关系 等于 付款冲收款 )  and    单据体.单据类型 等于 预收款","localeExprTran":{"zh_CN":"( 结算关系 等于 应付退款结算   or    结算关系 等于 付款冲收款 )  and    单据体.单据类型 等于 预收款"}}',20,1102927996320320512,'本次结算金额'); 

-- 取数规则分录多语言（通用过滤描述）
DELETE FROM T_AI_RECDATARULEENTRY_l WHERE FPKID = '1FPJRCBHNZQU';
INSERT INTO T_AI_RECDATARULEENTRY_l(FID,FPKID,FLOCALEID,FENTRYID,FDESCRIPTION) VALUES (0,'1FPJRCBHNZQU','zh_CN',1102313821332059136,'初始化财务应收');
DELETE FROM T_AI_RECDATARULEENTRY_l WHERE FPKID = '1FPJRCBHNZQV';
INSERT INTO T_AI_RECDATARULEENTRY_l(FID,FPKID,FLOCALEID,FENTRYID,FDESCRIPTION) VALUES (0,'1FPJRCBHNZQV','zh_TW',1102313821332059136,'初始化財務應收');
DELETE FROM T_AI_RECDATARULEENTRY_l WHERE FPKID = '1FPJRCBHNZQY';
INSERT INTO T_AI_RECDATARULEENTRY_l(FID,FPKID,FLOCALEID,FENTRYID,FDESCRIPTION) VALUES (0,'1FPJRCBHNZQY','zh_CN',874515865792435202,'初始化暂估应收');
DELETE FROM T_AI_RECDATARULEENTRY_l WHERE FPKID = '1FPJRCBHNZQZ';
INSERT INTO T_AI_RECDATARULEENTRY_l(FID,FPKID,FLOCALEID,FENTRYID,FDESCRIPTION) VALUES (0,'1FPJRCBHNZQZ','zh_TW',874515865792435202,'初始化暫估應收');
DELETE FROM T_AI_RECDATARULEENTRY_l WHERE FPKID = '1FPJRCBHNZR0';
INSERT INTO T_AI_RECDATARULEENTRY_l(FID,FPKID,FLOCALEID,FENTRYID,FDESCRIPTION) VALUES (0,'1FPJRCBHNZR0','zh_CN',1102317283721728000,'初始化预收');
DELETE FROM T_AI_RECDATARULEENTRY_l WHERE FPKID = '1FPJRCBHNZR1';
INSERT INTO T_AI_RECDATARULEENTRY_l(FID,FPKID,FLOCALEID,FENTRYID,FDESCRIPTION) VALUES (0,'1FPJRCBHNZR1','zh_TW',1102317283721728000,'初始化預收');
DELETE FROM T_AI_RECDATARULEENTRY_l WHERE FPKID = '1FPJRCBHNZR4';
INSERT INTO T_AI_RECDATARULEENTRY_l(FID,FPKID,FLOCALEID,FENTRYID,FDESCRIPTION) VALUES (0,'1FPJRCBHNZR4','zh_CN',1102319307129448448,'期初财务应收增加');
DELETE FROM T_AI_RECDATARULEENTRY_l WHERE FPKID = '1FPJRCBHNZR5';
INSERT INTO T_AI_RECDATARULEENTRY_l(FID,FPKID,FLOCALEID,FENTRYID,FDESCRIPTION) VALUES (0,'1FPJRCBHNZR5','zh_TW',1102319307129448448,'期初財務應收增加');
DELETE FROM T_AI_RECDATARULEENTRY_l WHERE FPKID = '1FPJRCBHNZR8';
INSERT INTO T_AI_RECDATARULEENTRY_l(FID,FPKID,FLOCALEID,FENTRYID,FDESCRIPTION) VALUES (0,'1FPJRCBHNZR8','zh_CN',1102324124556027904,'期初暂估应收增加');
DELETE FROM T_AI_RECDATARULEENTRY_l WHERE FPKID = '1FPJRCBHNZR9';
INSERT INTO T_AI_RECDATARULEENTRY_l(FID,FPKID,FLOCALEID,FENTRYID,FDESCRIPTION) VALUES (0,'1FPJRCBHNZR9','zh_TW',1102324124556027904,'期初暫估應收增加');
DELETE FROM T_AI_RECDATARULEENTRY_l WHERE FPKID = '1FPJRCBHNZRB';
INSERT INTO T_AI_RECDATARULEENTRY_l(FID,FPKID,FLOCALEID,FENTRYID,FDESCRIPTION) VALUES (0,'1FPJRCBHNZRB','zh_CN',1102326233972092928,'期初财务应收减少');
DELETE FROM T_AI_RECDATARULEENTRY_l WHERE FPKID = '1FPJRCBHNZRC';
INSERT INTO T_AI_RECDATARULEENTRY_l(FID,FPKID,FLOCALEID,FENTRYID,FDESCRIPTION) VALUES (0,'1FPJRCBHNZRC','zh_TW',1102326233972092928,'期初財務應收減少');
DELETE FROM T_AI_RECDATARULEENTRY_l WHERE FPKID = '1FPJRCBHNZRF';
INSERT INTO T_AI_RECDATARULEENTRY_l(FID,FPKID,FLOCALEID,FENTRYID,FDESCRIPTION) VALUES (0,'1FPJRCBHNZRF','zh_CN',1102928981922950144,'期初财务应收减少');
DELETE FROM T_AI_RECDATARULEENTRY_l WHERE FPKID = '1FPJRCBHNZRG';
INSERT INTO T_AI_RECDATARULEENTRY_l(FID,FPKID,FLOCALEID,FENTRYID,FDESCRIPTION) VALUES (0,'1FPJRCBHNZRG','zh_TW',1102928981922950144,'期初財務應收減少');
DELETE FROM T_AI_RECDATARULEENTRY_l WHERE FPKID = '1FPJRCBHNZRJ';
INSERT INTO T_AI_RECDATARULEENTRY_l(FID,FPKID,FLOCALEID,FENTRYID,FDESCRIPTION) VALUES (0,'1FPJRCBHNZRJ','zh_CN',1102327231520270336,'期初预收增加');
DELETE FROM T_AI_RECDATARULEENTRY_l WHERE FPKID = '1FPJRCBHNZRK';
INSERT INTO T_AI_RECDATARULEENTRY_l(FID,FPKID,FLOCALEID,FENTRYID,FDESCRIPTION) VALUES (0,'1FPJRCBHNZRK','zh_TW',1102327231520270336,'期初預收增加');
DELETE FROM T_AI_RECDATARULEENTRY_l WHERE FPKID = '1FPJRCBHNZRN';
INSERT INTO T_AI_RECDATARULEENTRY_l(FID,FPKID,FLOCALEID,FENTRYID,FDESCRIPTION) VALUES (0,'1FPJRCBHNZRN','zh_CN',1102329249995515904,'期初预收增加');
DELETE FROM T_AI_RECDATARULEENTRY_l WHERE FPKID = '1FPJRCBHNZRO';
INSERT INTO T_AI_RECDATARULEENTRY_l(FID,FPKID,FLOCALEID,FENTRYID,FDESCRIPTION) VALUES (0,'1FPJRCBHNZRO','zh_TW',1102329249995515904,'期初預收增加');
DELETE FROM T_AI_RECDATARULEENTRY_l WHERE FPKID = '1FPJRCBHNZRR';
INSERT INTO T_AI_RECDATARULEENTRY_l(FID,FPKID,FLOCALEID,FENTRYID,FDESCRIPTION) VALUES (0,'1FPJRCBHNZRR','zh_CN',1102340322094075904,'期初预收减少');
DELETE FROM T_AI_RECDATARULEENTRY_l WHERE FPKID = '1FPJRCBHNZRS';
INSERT INTO T_AI_RECDATARULEENTRY_l(FID,FPKID,FLOCALEID,FENTRYID,FDESCRIPTION) VALUES (0,'1FPJRCBHNZRS','zh_TW',1102340322094075904,'期初預收減少');
DELETE FROM T_AI_RECDATARULEENTRY_l WHERE FPKID = '1FPJRCBHNZRV';
INSERT INTO T_AI_RECDATARULEENTRY_l(FID,FPKID,FLOCALEID,FENTRYID,FDESCRIPTION) VALUES (0,'1FPJRCBHNZRV','zh_CN',1102341052968298496,'期初预收减少');
DELETE FROM T_AI_RECDATARULEENTRY_l WHERE FPKID = '1FPJRCBHNZRW';
INSERT INTO T_AI_RECDATARULEENTRY_l(FID,FPKID,FLOCALEID,FENTRYID,FDESCRIPTION) VALUES (0,'1FPJRCBHNZRW','zh_TW',1102341052968298496,'期初預收減少');
DELETE FROM T_AI_RECDATARULEENTRY_l WHERE FPKID = '1FPJRCBHNZRZ';
INSERT INTO T_AI_RECDATARULEENTRY_l(FID,FPKID,FLOCALEID,FENTRYID,FDESCRIPTION) VALUES (0,'1FPJRCBHNZRZ','zh_CN',1102349829104848896,'日常财务应收增加');
DELETE FROM T_AI_RECDATARULEENTRY_l WHERE FPKID = '1FPJRCBHNZS+';
INSERT INTO T_AI_RECDATARULEENTRY_l(FID,FPKID,FLOCALEID,FENTRYID,FDESCRIPTION) VALUES (0,'1FPJRCBHNZS+','zh_TW',1102349829104848896,'日常財務應收增加');
DELETE FROM T_AI_RECDATARULEENTRY_l WHERE FPKID = '1FPJRCBHNZS=';
INSERT INTO T_AI_RECDATARULEENTRY_l(FID,FPKID,FLOCALEID,FENTRYID,FDESCRIPTION) VALUES (0,'1FPJRCBHNZS=','zh_TW',1102354211422613504,'日常暫估應收增加、減少');
DELETE FROM T_AI_RECDATARULEENTRY_l WHERE FPKID = '1FPJRCBHNZS1';
INSERT INTO T_AI_RECDATARULEENTRY_l(FID,FPKID,FLOCALEID,FENTRYID,FDESCRIPTION) VALUES (0,'1FPJRCBHNZS1','zh_CN',1102352579855134720,'日常财务应收减少');
DELETE FROM T_AI_RECDATARULEENTRY_l WHERE FPKID = '1FPJRCBHNZS2';
INSERT INTO T_AI_RECDATARULEENTRY_l(FID,FPKID,FLOCALEID,FENTRYID,FDESCRIPTION) VALUES (0,'1FPJRCBHNZS2','zh_TW',1102352579855134720,'日常財務應收減少');
DELETE FROM T_AI_RECDATARULEENTRY_l WHERE FPKID = '1FPJRCBHNZS5';
INSERT INTO T_AI_RECDATARULEENTRY_l(FID,FPKID,FLOCALEID,FENTRYID,FDESCRIPTION) VALUES (0,'1FPJRCBHNZS5','zh_CN',1103015310782397440,'日常财务应收减少');
DELETE FROM T_AI_RECDATARULEENTRY_l WHERE FPKID = '1FPJRCBHNZS6';
INSERT INTO T_AI_RECDATARULEENTRY_l(FID,FPKID,FLOCALEID,FENTRYID,FDESCRIPTION) VALUES (0,'1FPJRCBHNZS6','zh_TW',1103015310782397440,'日常財務應收減少');
DELETE FROM T_AI_RECDATARULEENTRY_l WHERE FPKID = '1FPJRCBHNZS9';
INSERT INTO T_AI_RECDATARULEENTRY_l(FID,FPKID,FLOCALEID,FENTRYID,FDESCRIPTION) VALUES (0,'1FPJRCBHNZS9','zh_CN',1102354211422613504,'日常暂估应收增加、减少');
DELETE FROM T_AI_RECDATARULEENTRY_l WHERE FPKID = '1FPJRCBHNZSC';
INSERT INTO T_AI_RECDATARULEENTRY_l(FID,FPKID,FLOCALEID,FENTRYID,FDESCRIPTION) VALUES (0,'1FPJRCBHNZSC','zh_CN',1102355506724431872,'日常预收增加');
DELETE FROM T_AI_RECDATARULEENTRY_l WHERE FPKID = '1FPJRCBHNZSD';
INSERT INTO T_AI_RECDATARULEENTRY_l(FID,FPKID,FLOCALEID,FENTRYID,FDESCRIPTION) VALUES (0,'1FPJRCBHNZSD','zh_TW',1102355506724431872,'日常預收增加');
DELETE FROM T_AI_RECDATARULEENTRY_l WHERE FPKID = '1FPJRCBHNZSG';
INSERT INTO T_AI_RECDATARULEENTRY_l(FID,FPKID,FLOCALEID,FENTRYID,FDESCRIPTION) VALUES (0,'1FPJRCBHNZSG','zh_CN',1102356195169022976,'日常预收减少');
DELETE FROM T_AI_RECDATARULEENTRY_l WHERE FPKID = '1FPJRCBHNZSH';
INSERT INTO T_AI_RECDATARULEENTRY_l(FID,FPKID,FLOCALEID,FENTRYID,FDESCRIPTION) VALUES (0,'1FPJRCBHNZSH','zh_TW',1102356195169022976,'日常預收減少');
DELETE FROM T_AI_RECDATARULEENTRY_l WHERE FPKID = '1FPJRCBHNZSK';
INSERT INTO T_AI_RECDATARULEENTRY_l(FID,FPKID,FLOCALEID,FENTRYID,FDESCRIPTION) VALUES (0,'1FPJRCBHNZSK','zh_CN',1102356980334343168,'日常预收减少');
DELETE FROM T_AI_RECDATARULEENTRY_l WHERE FPKID = '1FPJRCBHNZSL';
INSERT INTO T_AI_RECDATARULEENTRY_l(FID,FPKID,FLOCALEID,FENTRYID,FDESCRIPTION) VALUES (0,'1FPJRCBHNZSL','zh_TW',1102356980334343168,'日常預收減少');
DELETE FROM T_AI_RECDATARULEENTRY_l WHERE FPKID = '1G5AD4GZ0DFQ';
INSERT INTO T_AI_RECDATARULEENTRY_l(FID,FPKID,FLOCALEID,FENTRYID,FDESCRIPTION) VALUES (0,'1G5AD4GZ0DFQ','zh_TW',1108628120845440000,'期初預收減少');
DELETE FROM T_AI_RECDATARULEENTRY_l WHERE FPKID = '1G5AD4GZ0DFR';
INSERT INTO T_AI_RECDATARULEENTRY_l(FID,FPKID,FLOCALEID,FENTRYID,FDESCRIPTION) VALUES (0,'1G5AD4GZ0DFR','zh_CN',1108628120845440000,'期初预收减少');
DELETE FROM T_AI_RECDATARULEENTRY_l WHERE FPKID = '1G8/OML2IQKR';
INSERT INTO T_AI_RECDATARULEENTRY_l(FID,FPKID,FLOCALEID,FENTRYID,FDESCRIPTION) VALUES (0,'1G8/OML2IQKR','zh_TW',1109191658588608512,'日常預收減少');
DELETE FROM T_AI_RECDATARULEENTRY_l WHERE FPKID = '1G8/OML2IQKS';
INSERT INTO T_AI_RECDATARULEENTRY_l(FID,FPKID,FLOCALEID,FENTRYID,FDESCRIPTION) VALUES (0,'1G8/OML2IQKS','zh_CN',1109191658588608512,'日常预收减少');

-- 通用过滤
DELETE FROM T_AI_REC_COMMON_FILTER WHERE FID = 793342889454222335;
INSERT INTO T_AI_REC_COMMON_FILTER(FID,FCREATETIME,FMODIFIERID,FBIZORG,FMODIFYTIME,FBIZDATE,FPRESET,FORGID,FMASTERID,FENTITY,FPERIOD,FNUMBER) VALUES (793342889454222335,{ts'2019-12-31  14:30:17'},0,'org',{ts'2021-03-11  10:10:35'},' ','1',0,793342889454222335,'ar_finarbill',' ','ar_finarbill01');
DELETE FROM T_AI_REC_COMMON_FILTER WHERE FID = 874514579323900928;
INSERT INTO T_AI_REC_COMMON_FILTER(FID,FCREATETIME,FMODIFIERID,FBIZORG,FMODIFYTIME,FBIZDATE,FPRESET,FORGID,FMASTERID,FENTITY,FPERIOD,FNUMBER) VALUES (874514579323900928,{ts'2020-04-21  14:24:01'},0,'entry.e_settleorg',{ts'2021-03-11  10:13:04'},' ','1',0,874514579323900928,'cas_recbill',' ','cas_recbill01');
DELETE FROM T_AI_REC_COMMON_FILTER WHERE FID = 920154099578614784;
INSERT INTO T_AI_REC_COMMON_FILTER(FID,FCREATETIME,FMODIFIERID,FBIZORG,FMODIFYTIME,FBIZDATE,FPRESET,FORGID,FMASTERID,FENTITY,FPERIOD,FNUMBER) VALUES (920154099578614784,{ts'2020-06-23  13:40:51'},0,'org',{ts'2021-03-11  10:11:36'},' ','1',0,920154099578614784,'ar_busbill',' ','ar_busbill01');
DELETE FROM T_AI_REC_COMMON_FILTER WHERE FID = 1102316252107493376;
INSERT INTO T_AI_REC_COMMON_FILTER(FID,FCREATETIME,FMODIFIERID,FBIZORG,FMODIFYTIME,FBIZDATE,FPRESET,FORGID,FMASTERID,FENTITY,FPERIOD,FNUMBER) VALUES (1102316252107493376,{ts'2021-03-01  21:45:06'},0,'org',{ts'2021-03-11  10:12:10'},' ','1',0,1102316252107493376,'ar_receivedbill',' ','ar_receivedbill01');
DELETE FROM T_AI_REC_COMMON_FILTER WHERE FID = 1102318327205816320;
INSERT INTO T_AI_REC_COMMON_FILTER(FID,FCREATETIME,FMODIFIERID,FBIZORG,FMODIFYTIME,FBIZDATE,FPRESET,FORGID,FMASTERID,FENTITY,FPERIOD,FNUMBER) VALUES (1102318327205816320,{ts'2021-03-01  21:49:16'},0,'org',{ts'2021-03-11  10:10:49'},'bookdate','1',0,1102318327205816320,'ar_finarbill',' ','ar_finarbill02');
DELETE FROM T_AI_REC_COMMON_FILTER WHERE FID = 1102324724710625280;
INSERT INTO T_AI_REC_COMMON_FILTER(FID,FCREATETIME,FMODIFIERID,FBIZORG,FMODIFYTIME,FBIZDATE,FPRESET,FORGID,FMASTERID,FENTITY,FPERIOD,FNUMBER) VALUES (1102324724710625280,{ts'2021-03-01  22:01:53'},0,'org',{ts'2021-03-11  10:03:54'},' ','1',0,1102324724710625280,'ar_settlerecord',' ','ar_settlerecord01');
DELETE FROM T_AI_REC_COMMON_FILTER WHERE FID = 1102350607718639616;
INSERT INTO T_AI_REC_COMMON_FILTER(FID,FCREATETIME,FMODIFIERID,FBIZORG,FMODIFYTIME,FBIZDATE,FPRESET,FORGID,FMASTERID,FENTITY,FPERIOD,FNUMBER) VALUES (1102350607718639616,{ts'2021-03-01  22:53:11'},0,'org',{ts'2021-03-11  10:04:06'},'settledate','1',0,1102350607718639616,'ar_settlerecord',' ','ar_settlerecord02');
DELETE FROM T_AI_REC_COMMON_FILTER WHERE FID = 1102353566841975808;
INSERT INTO T_AI_REC_COMMON_FILTER(FID,FCREATETIME,FMODIFIERID,FBIZORG,FMODIFYTIME,FBIZDATE,FPRESET,FORGID,FMASTERID,FENTITY,FPERIOD,FNUMBER) VALUES (1102353566841975808,{ts'2021-03-01  22:59:17'},0,'org',{ts'2021-03-11  10:11:43'},'bookdate','1',0,1102353566841975808,'ar_busbill',' ','ar_busbill02');
DELETE FROM T_AI_REC_COMMON_FILTER WHERE FID = 1102354837456040960;
INSERT INTO T_AI_REC_COMMON_FILTER(FID,FCREATETIME,FMODIFIERID,FBIZORG,FMODIFYTIME,FBIZDATE,FPRESET,FORGID,FMASTERID,FENTITY,FPERIOD,FNUMBER) VALUES (1102354837456040960,{ts'2021-03-01  23:01:37'},0,'entry.e_settleorg',{ts'2021-03-11  10:13:14'},'bizdate','1',0,1102354837456040960,'cas_recbill',' ','cas_recbill02');
DELETE FROM T_AI_REC_COMMON_FILTER WHERE FID = 1102927388305639424;
INSERT INTO T_AI_REC_COMMON_FILTER(FID,FCREATETIME,FMODIFIERID,FBIZORG,FMODIFYTIME,FBIZDATE,FPRESET,FORGID,FMASTERID,FENTITY,FPERIOD,FNUMBER) VALUES (1102927388305639424,{ts'2021-03-02  17:58:56'},0,'org',{ts'2021-03-11  10:01:11'},' ','1',0,1102927388305639424,'ap_settlerecord',' ','ap_settlerecord05');
DELETE FROM T_AI_REC_COMMON_FILTER WHERE FID = 1102927996320320512;
INSERT INTO T_AI_REC_COMMON_FILTER(FID,FCREATETIME,FMODIFIERID,FBIZORG,FMODIFYTIME,FBIZDATE,FPRESET,FORGID,FMASTERID,FENTITY,FPERIOD,FNUMBER) VALUES (1102927996320320512,{ts'2021-03-02  18:00:33'},0,'org',{ts'2021-03-11  10:01:17'},'settledate','1',0,1102927996320320512,'ap_settlerecord',' ','ap_settlerecord06');
DELETE FROM T_AI_REC_COMMON_FILTER WHERE FID = 1103011200851015680;
INSERT INTO T_AI_REC_COMMON_FILTER(FID,FCREATETIME,FMODIFIERID,FBIZORG,FMODIFYTIME,FBIZDATE,FPRESET,FORGID,FMASTERID,FENTITY,FPERIOD,FNUMBER) VALUES (1103011200851015680,{ts'2021-03-02  20:45:04'},0,'org',{ts'2021-03-11  10:04:22'},' ','1',0,1103011200851015680,'ar_settlerecord',' ','ar_settlerecord05');
DELETE FROM T_AI_REC_COMMON_FILTER WHERE FID = 1103012088424462336;
INSERT INTO T_AI_REC_COMMON_FILTER(FID,FCREATETIME,FMODIFIERID,FBIZORG,FMODIFYTIME,FBIZDATE,FPRESET,FORGID,FMASTERID,FENTITY,FPERIOD,FNUMBER) VALUES (1103012088424462336,{ts'2021-03-02  20:47:22'},0,'org',{ts'2021-03-11  10:04:29'},'settledate','1',0,1103012088424462336,'ar_settlerecord',' ','ar_settlerecord06');


-- 通用过滤多语言
DELETE FROM T_AI_REC_COMMON_FILTER_L WHERE FPKID = '0GETP1+LRL==';
INSERT INTO T_AI_REC_COMMON_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (793342889454222335,'0GETP1+LRL==','zh_TW','初始、期初財務應收原幣'); 
DELETE FROM T_AI_REC_COMMON_FILTER_L WHERE FPKID = '0GETP1+LRL=9';
INSERT INTO T_AI_REC_COMMON_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (793342889454222335,'0GETP1+LRL=9','zh_CN','初始、期初财务应收原币'); 
DELETE FROM T_AI_REC_COMMON_FILTER_L WHERE FPKID = '0QDP9RWFT42I';
INSERT INTO T_AI_REC_COMMON_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (874514579323900928,'0QDP9RWFT42I','zh_CN','期初（预收）收款单原币'); 
DELETE FROM T_AI_REC_COMMON_FILTER_L WHERE FPKID = '0QDP9RWFT42J';
INSERT INTO T_AI_REC_COMMON_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (874514579323900928,'0QDP9RWFT42J','zh_TW','期初（預收）收款單原幣'); 
DELETE FROM T_AI_REC_COMMON_FILTER_L WHERE FPKID = '0W/BU5LM2WAE';
INSERT INTO T_AI_REC_COMMON_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (920154099578614784,'0W/BU5LM2WAE','zh_CN','初始、期初暂估应收原币'); 
DELETE FROM T_AI_REC_COMMON_FILTER_L WHERE FPKID = '0W/BU5LM2WAF';
INSERT INTO T_AI_REC_COMMON_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (920154099578614784,'0W/BU5LM2WAF','zh_TW','初始、期初暫估應收原幣'); 
DELETE FROM T_AI_REC_COMMON_FILTER_L WHERE FPKID = '1FD20NWG7O4U';
INSERT INTO T_AI_REC_COMMON_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1102316252107493376,'1FD20NWG7O4U','zh_CN','初始化预收原币'); 
DELETE FROM T_AI_REC_COMMON_FILTER_L WHERE FPKID = '1FD20NWG7O4V';
INSERT INTO T_AI_REC_COMMON_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1102316252107493376,'1FD20NWG7O4V','zh_TW','初始化預收原幣'); 
DELETE FROM T_AI_REC_COMMON_FILTER_L WHERE FPKID = '1FD2ESLU1IAE';
INSERT INTO T_AI_REC_COMMON_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1102318327205816320,'1FD2ESLU1IAE','zh_CN','日常财务应收原币'); 
DELETE FROM T_AI_REC_COMMON_FILTER_L WHERE FPKID = '1FD2ESLU1IAF';
INSERT INTO T_AI_REC_COMMON_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1102318327205816320,'1FD2ESLU1IAF','zh_TW','日常財務應收原幣'); 
DELETE FROM T_AI_REC_COMMON_FILTER_L WHERE FPKID = '1FD3MDR42AL=';
INSERT INTO T_AI_REC_COMMON_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1102324724710625280,'1FD3MDR42AL=','zh_CN','期初应收结算记录原币（主方）'); 
DELETE FROM T_AI_REC_COMMON_FILTER_L WHERE FPKID = '1FD3MDR42ALA';
INSERT INTO T_AI_REC_COMMON_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1102324724710625280,'1FD3MDR42ALA','zh_TW','期初應收結算記錄原幣（主方）'); 
DELETE FROM T_AI_REC_COMMON_FILTER_L WHERE FPKID = '1FD8G/H=AIF1';
INSERT INTO T_AI_REC_COMMON_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1102350607718639616,'1FD8G/H=AIF1','zh_CN','日常应收结算记录原币（主方）'); 
DELETE FROM T_AI_REC_COMMON_FILTER_L WHERE FPKID = '1FD8G/H=AIF2';
INSERT INTO T_AI_REC_COMMON_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1102350607718639616,'1FD8G/H=AIF2','zh_TW','日常應收結算記錄原幣（主方）'); 
DELETE FROM T_AI_REC_COMMON_FILTER_L WHERE FPKID = '1FD9/KEIKQCQ';
INSERT INTO T_AI_REC_COMMON_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1102353566841975808,'1FD9/KEIKQCQ','zh_CN','日常暂估应收原币'); 
DELETE FROM T_AI_REC_COMMON_FILTER_L WHERE FPKID = '1FD9/KEIKQCR';
INSERT INTO T_AI_REC_COMMON_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1102353566841975808,'1FD9/KEIKQCR','zh_TW','日常暫估應收原幣'); 
DELETE FROM T_AI_REC_COMMON_FILTER_L WHERE FPKID = '1FD98UJDPKYS';
INSERT INTO T_AI_REC_COMMON_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1102354837456040960,'1FD98UJDPKYS','zh_CN','日常预收款原币'); 
DELETE FROM T_AI_REC_COMMON_FILTER_L WHERE FPKID = '1FD98UJDPKYT';
INSERT INTO T_AI_REC_COMMON_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1102354837456040960,'1FD98UJDPKYT','zh_TW','日常預收款原幣'); 
DELETE FROM T_AI_REC_COMMON_FILTER_L WHERE FPKID = '1FG/8/3ADG=I';
INSERT INTO T_AI_REC_COMMON_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1102927388305639424,'1FG/8/3ADG=I','zh_CN','期初应付结算记录原币（辅方、客户）'); 
DELETE FROM T_AI_REC_COMMON_FILTER_L WHERE FPKID = '1FG/8/3ADG=J';
INSERT INTO T_AI_REC_COMMON_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1102927388305639424,'1FG/8/3ADG=J','zh_TW','期初應付結算記錄原幣（輔方、客戶）'); 
DELETE FROM T_AI_REC_COMMON_FILTER_L WHERE FPKID = '1FG/BEXX1D36';
INSERT INTO T_AI_REC_COMMON_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1102927996320320512,'1FG/BEXX1D36','zh_CN','日常应付结算记录原币（辅方、客户）'); 
DELETE FROM T_AI_REC_COMMON_FILTER_L WHERE FPKID = '1FG/BEXX1D37';
INSERT INTO T_AI_REC_COMMON_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1102927996320320512,'1FG/BEXX1D37','zh_TW','日常應付結算記錄原幣（輔方、客戶）'); 
DELETE FROM T_AI_REC_COMMON_FILTER_L WHERE FPKID = '1FGDWR/VPFMW';
INSERT INTO T_AI_REC_COMMON_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1103011200851015680,'1FGDWR/VPFMW','zh_CN','期初应收结算记录原币（辅方、客户）'); 
DELETE FROM T_AI_REC_COMMON_FILTER_L WHERE FPKID = '1FGDWR/VPFMX';
INSERT INTO T_AI_REC_COMMON_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1103011200851015680,'1FGDWR/VPFMX','zh_TW','期初應收結算記錄原幣（輔方、客戶）'); 
DELETE FROM T_AI_REC_COMMON_FILTER_L WHERE FPKID = '1FGE179GCX=X';
INSERT INTO T_AI_REC_COMMON_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1103012088424462336,'1FGE179GCX=X','zh_CN','日常应收结算记录原币（辅方、客户）'); 
DELETE FROM T_AI_REC_COMMON_FILTER_L WHERE FPKID = '1FGE179GCX=Y';
INSERT INTO T_AI_REC_COMMON_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1103012088424462336,'1FGE179GCX=Y','zh_TW','日常應收結算記錄原幣（輔方、客戶）');

-- 通用过滤分录
DELETE FROM T_AI_REC_COMMON_ENTRY WHERE FENTRYID = 793342889781377026;
INSERT INTO T_AI_REC_COMMON_ENTRY(FID,FBIZASSIST6,FBIZASSIST7,FENTRYID,FSEQ,FBIZASSIST0,FBIZASSIST1,FBIZASSIST2,FBIZASSIST3,FBIZASSIST4,FBIZASSIST5) VALUES (793342889454222335,' ',' ',793342889781377026,1,'asstact','currency',' ',' ',' ',' '); 
DELETE FROM T_AI_REC_COMMON_ENTRY WHERE FENTRYID = 874514579458117634;
INSERT INTO T_AI_REC_COMMON_ENTRY(FID,FBIZASSIST6,FBIZASSIST7,FENTRYID,FSEQ,FBIZASSIST0,FBIZASSIST1,FBIZASSIST2,FBIZASSIST3,FBIZASSIST4,FBIZASSIST5) VALUES (874514579323900928,' ',' ',874514579458117634,1,'itempayer','currency',' ',' ',' ',' '); 
DELETE FROM T_AI_REC_COMMON_ENTRY WHERE FENTRYID = 920154099595390978;
INSERT INTO T_AI_REC_COMMON_ENTRY(FID,FBIZASSIST6,FBIZASSIST7,FENTRYID,FSEQ,FBIZASSIST0,FBIZASSIST1,FBIZASSIST2,FBIZASSIST3,FBIZASSIST4,FBIZASSIST5) VALUES (920154099578614784,' ',' ',920154099595390978,1,'asstact','currency',' ',' ',' ',' '); 
DELETE FROM T_AI_REC_COMMON_ENTRY WHERE FENTRYID = 1102316252468176898;
INSERT INTO T_AI_REC_COMMON_ENTRY(FID,FBIZASSIST6,FBIZASSIST7,FENTRYID,FSEQ,FBIZASSIST0,FBIZASSIST1,FBIZASSIST2,FBIZASSIST3,FBIZASSIST4,FBIZASSIST5) VALUES (1102316252107493376,' ',' ',1102316252468176898,1,'asstact','currency',' ',' ',' ',' '); 
DELETE FROM T_AI_REC_COMMON_ENTRY WHERE FENTRYID = 1102318327566553090;
INSERT INTO T_AI_REC_COMMON_ENTRY(FID,FBIZASSIST6,FBIZASSIST7,FENTRYID,FSEQ,FBIZASSIST0,FBIZASSIST1,FBIZASSIST2,FBIZASSIST3,FBIZASSIST4,FBIZASSIST5) VALUES (1102318327205816320,' ',' ',1102318327566553090,1,'asstact','currency',' ',' ',' ',' '); 
DELETE FROM T_AI_REC_COMMON_ENTRY WHERE FENTRYID = 1102324725121640450;
INSERT INTO T_AI_REC_COMMON_ENTRY(FID,FBIZASSIST6,FBIZASSIST7,FENTRYID,FSEQ,FBIZASSIST0,FBIZASSIST1,FBIZASSIST2,FBIZASSIST3,FBIZASSIST4,FBIZASSIST5) VALUES (1102324724710625280,' ',' ',1102324725121640450,1,'mainasstactid','maincurrency',' ',' ',' ',' '); 
DELETE FROM T_AI_REC_COMMON_ENTRY WHERE FENTRYID = 1102350608112930818;
INSERT INTO T_AI_REC_COMMON_ENTRY(FID,FBIZASSIST6,FBIZASSIST7,FENTRYID,FSEQ,FBIZASSIST0,FBIZASSIST1,FBIZASSIST2,FBIZASSIST3,FBIZASSIST4,FBIZASSIST5) VALUES (1102350607718639616,' ',' ',1102350608112930818,1,'mainasstactid','maincurrency',' ',' ',' ',' '); 
DELETE FROM T_AI_REC_COMMON_ENTRY WHERE FENTRYID = 1102353567127187458;
INSERT INTO T_AI_REC_COMMON_ENTRY(FID,FBIZASSIST6,FBIZASSIST7,FENTRYID,FSEQ,FBIZASSIST0,FBIZASSIST1,FBIZASSIST2,FBIZASSIST3,FBIZASSIST4,FBIZASSIST5) VALUES (1102353566841975808,' ',' ',1102353567127187458,1,'asstact','currency',' ',' ',' ',' '); 
DELETE FROM T_AI_REC_COMMON_ENTRY WHERE FENTRYID = 1102354837833527298;
INSERT INTO T_AI_REC_COMMON_ENTRY(FID,FBIZASSIST6,FBIZASSIST7,FENTRYID,FSEQ,FBIZASSIST0,FBIZASSIST1,FBIZASSIST2,FBIZASSIST3,FBIZASSIST4,FBIZASSIST5) VALUES (1102354837456040960,' ',' ',1102354837833527298,1,'itempayer','currency',' ',' ',' ',' '); 
DELETE FROM T_AI_REC_COMMON_ENTRY WHERE FENTRYID = 1102927388683127810;
INSERT INTO T_AI_REC_COMMON_ENTRY(FID,FBIZASSIST6,FBIZASSIST7,FENTRYID,FSEQ,FBIZASSIST0,FBIZASSIST1,FBIZASSIST2,FBIZASSIST3,FBIZASSIST4,FBIZASSIST5) VALUES (1102927388305639424,' ',' ',1102927388683127810,1,'entry.asstactid','maincurrency',' ',' ',' ',' '); 
DELETE FROM T_AI_REC_COMMON_ENTRY WHERE FENTRYID = 1102927996756438018;
INSERT INTO T_AI_REC_COMMON_ENTRY(FID,FBIZASSIST6,FBIZASSIST7,FENTRYID,FSEQ,FBIZASSIST0,FBIZASSIST1,FBIZASSIST2,FBIZASSIST3,FBIZASSIST4,FBIZASSIST5) VALUES (1102927996320320512,' ',' ',1102927996756438018,1,'entry.asstactid','maincurrency',' ',' ',' ',' '); 
DELETE FROM T_AI_REC_COMMON_ENTRY WHERE FENTRYID = 1103011201329167362;
INSERT INTO T_AI_REC_COMMON_ENTRY(FID,FBIZASSIST6,FBIZASSIST7,FENTRYID,FSEQ,FBIZASSIST0,FBIZASSIST1,FBIZASSIST2,FBIZASSIST3,FBIZASSIST4,FBIZASSIST5) VALUES (1103011200851015680,' ',' ',1103011201329167362,1,'entry.asstactid','maincurrency',' ',' ',' ',' '); 
DELETE FROM T_AI_REC_COMMON_ENTRY WHERE FENTRYID = 1103012088919391234;
INSERT INTO T_AI_REC_COMMON_ENTRY(FID,FBIZASSIST6,FBIZASSIST7,FENTRYID,FSEQ,FBIZASSIST0,FBIZASSIST1,FBIZASSIST2,FBIZASSIST3,FBIZASSIST4,FBIZASSIST5) VALUES (1103012088424462336,' ',' ',1103012088919391234,1,'entry.asstactid','maincurrency',' ',' ',' ',' '); 


-- 通用过滤核算维度
DELETE FROM T_AI_REC_COMMON_ASSIST WHERE FPKID = 885962815641280512;
INSERT INTO T_AI_REC_COMMON_ASSIST(FID,FBASEDATAID,FPKID) VALUES (793342889454222335,'bd_customer',885962815641280512); 
DELETE FROM T_AI_REC_COMMON_ASSIST WHERE FPKID = 885962815641280513;
INSERT INTO T_AI_REC_COMMON_ASSIST(FID,FBASEDATAID,FPKID) VALUES (793342889454222335,'bd_currency',885962815641280513); 
DELETE FROM T_AI_REC_COMMON_ASSIST WHERE FPKID = 920154099595392000;
INSERT INTO T_AI_REC_COMMON_ASSIST(FID,FBASEDATAID,FPKID) VALUES (920154099578614784,'bd_customer',920154099595392000); 
DELETE FROM T_AI_REC_COMMON_ASSIST WHERE FPKID = 920154099595392001;
INSERT INTO T_AI_REC_COMMON_ASSIST(FID,FBASEDATAID,FPKID) VALUES (920154099578614784,'bd_currency',920154099595392001); 
DELETE FROM T_AI_REC_COMMON_ASSIST WHERE FPKID = 1102316252468203520;
INSERT INTO T_AI_REC_COMMON_ASSIST(FID,FBASEDATAID,FPKID) VALUES (1102316252107493376,'bd_customer',1102316252468203520); 
DELETE FROM T_AI_REC_COMMON_ASSIST WHERE FPKID = 1102316252468203521;
INSERT INTO T_AI_REC_COMMON_ASSIST(FID,FBASEDATAID,FPKID) VALUES (1102316252107493376,'bd_currency',1102316252468203521); 
DELETE FROM T_AI_REC_COMMON_ASSIST WHERE FPKID = 1102318327566526464;
INSERT INTO T_AI_REC_COMMON_ASSIST(FID,FBASEDATAID,FPKID) VALUES (1102318327205816320,'bd_customer',1102318327566526464); 
DELETE FROM T_AI_REC_COMMON_ASSIST WHERE FPKID = 1102318327566526465;
INSERT INTO T_AI_REC_COMMON_ASSIST(FID,FBASEDATAID,FPKID) VALUES (1102318327205816320,'bd_currency',1102318327566526465); 
DELETE FROM T_AI_REC_COMMON_ASSIST WHERE FPKID = 1102324725121667072;
INSERT INTO T_AI_REC_COMMON_ASSIST(FID,FBASEDATAID,FPKID) VALUES (1102324724710625280,'bd_customer',1102324725121667072); 
DELETE FROM T_AI_REC_COMMON_ASSIST WHERE FPKID = 1102324725121667073;
INSERT INTO T_AI_REC_COMMON_ASSIST(FID,FBASEDATAID,FPKID) VALUES (1102324724710625280,'bd_currency',1102324725121667073); 
DELETE FROM T_AI_REC_COMMON_ASSIST WHERE FPKID = 1102327989682582528;
INSERT INTO T_AI_REC_COMMON_ASSIST(FID,FBASEDATAID,FPKID) VALUES (874514579323900928,'bd_customer',1102327989682582528); 
DELETE FROM T_AI_REC_COMMON_ASSIST WHERE FPKID = 1102327989682582529;
INSERT INTO T_AI_REC_COMMON_ASSIST(FID,FBASEDATAID,FPKID) VALUES (874514579323900928,'bd_currency',1102327989682582529); 
DELETE FROM T_AI_REC_COMMON_ASSIST WHERE FPKID = 1102350608112904192;
INSERT INTO T_AI_REC_COMMON_ASSIST(FID,FBASEDATAID,FPKID) VALUES (1102350607718639616,'bd_customer',1102350608112904192); 
DELETE FROM T_AI_REC_COMMON_ASSIST WHERE FPKID = 1102350608112904193;
INSERT INTO T_AI_REC_COMMON_ASSIST(FID,FBASEDATAID,FPKID) VALUES (1102350607718639616,'bd_currency',1102350608112904193); 
DELETE FROM T_AI_REC_COMMON_ASSIST WHERE FPKID = 1102353567127188480;
INSERT INTO T_AI_REC_COMMON_ASSIST(FID,FBASEDATAID,FPKID) VALUES (1102353566841975808,'bd_customer',1102353567127188480); 
DELETE FROM T_AI_REC_COMMON_ASSIST WHERE FPKID = 1102353567127188481;
INSERT INTO T_AI_REC_COMMON_ASSIST(FID,FBASEDATAID,FPKID) VALUES (1102353566841975808,'bd_currency',1102353567127188481); 
DELETE FROM T_AI_REC_COMMON_ASSIST WHERE FPKID = 1102354837833528320;
INSERT INTO T_AI_REC_COMMON_ASSIST(FID,FBASEDATAID,FPKID) VALUES (1102354837456040960,'bd_customer',1102354837833528320); 
DELETE FROM T_AI_REC_COMMON_ASSIST WHERE FPKID = 1102354837833528321;
INSERT INTO T_AI_REC_COMMON_ASSIST(FID,FBASEDATAID,FPKID) VALUES (1102354837456040960,'bd_currency',1102354837833528321); 
DELETE FROM T_AI_REC_COMMON_ASSIST WHERE FPKID = 1102927388683126784;
INSERT INTO T_AI_REC_COMMON_ASSIST(FID,FBASEDATAID,FPKID) VALUES (1102927388305639424,'bd_customer',1102927388683126784); 
DELETE FROM T_AI_REC_COMMON_ASSIST WHERE FPKID = 1102927388683126785;
INSERT INTO T_AI_REC_COMMON_ASSIST(FID,FBASEDATAID,FPKID) VALUES (1102927388305639424,'bd_currency',1102927388683126785); 
DELETE FROM T_AI_REC_COMMON_ASSIST WHERE FPKID = 1102927996756528128;
INSERT INTO T_AI_REC_COMMON_ASSIST(FID,FBASEDATAID,FPKID) VALUES (1102927996320320512,'bd_customer',1102927996756528128); 
DELETE FROM T_AI_REC_COMMON_ASSIST WHERE FPKID = 1102927996756528129;
INSERT INTO T_AI_REC_COMMON_ASSIST(FID,FBASEDATAID,FPKID) VALUES (1102927996320320512,'bd_currency',1102927996756528129); 
DELETE FROM T_AI_REC_COMMON_ASSIST WHERE FPKID = 1103011201329166336;
INSERT INTO T_AI_REC_COMMON_ASSIST(FID,FBASEDATAID,FPKID) VALUES (1103011200851015680,'bd_customer',1103011201329166336); 
DELETE FROM T_AI_REC_COMMON_ASSIST WHERE FPKID = 1103011201329166337;
INSERT INTO T_AI_REC_COMMON_ASSIST(FID,FBASEDATAID,FPKID) VALUES (1103011200851015680,'bd_currency',1103011201329166337); 
DELETE FROM T_AI_REC_COMMON_ASSIST WHERE FPKID = 1103012088919390208;
INSERT INTO T_AI_REC_COMMON_ASSIST(FID,FBASEDATAID,FPKID) VALUES (1103012088424462336,'bd_customer',1103012088919390208); 
DELETE FROM T_AI_REC_COMMON_ASSIST WHERE FPKID = 1103012088919390209;
INSERT INTO T_AI_REC_COMMON_ASSIST(FID,FBASEDATAID,FPKID) VALUES (1103012088424462336,'bd_currency',1103012088919390209); 


-- 分录动态基础资料的数据对应
DELETE FROM t_ai_acctfieldmapentry WHERE FENTRYID = 1109214189164959744;
INSERT INTO t_ai_acctfieldmapentry(FID,FENTITYID,FENTRYID,FDATATYPE,FFIELDKEY,FSEQ,FFIELDNAME) VALUES (793342889454222335,'bd_customer',1109214189164959744,'1','basedata0',1,'客户'); 
DELETE FROM t_ai_acctfieldmapentry WHERE FENTRYID = 1109214189164959745;
INSERT INTO t_ai_acctfieldmapentry(FID,FENTITYID,FENTRYID,FDATATYPE,FFIELDKEY,FSEQ,FFIELDNAME) VALUES (793342889454222335,'bd_currency',1109214189164959745,'1','basedata1',2,'币别'); 
DELETE FROM t_ai_acctfieldmapentry WHERE FENTRYID = 1109215436802624512;
INSERT INTO t_ai_acctfieldmapentry(FID,FENTITYID,FENTRYID,FDATATYPE,FFIELDKEY,FSEQ,FFIELDNAME) VALUES (874514579323900928,'bd_customer',1109215436802624512,'1','basedata0',1,'客户'); 
DELETE FROM t_ai_acctfieldmapentry WHERE FENTRYID = 1109215436802624513;
INSERT INTO t_ai_acctfieldmapentry(FID,FENTITYID,FENTRYID,FDATATYPE,FFIELDKEY,FSEQ,FFIELDNAME) VALUES (874514579323900928,'bd_currency',1109215436802624513,'1','basedata1',2,'币别'); 
DELETE FROM t_ai_acctfieldmapentry WHERE FENTRYID = 1109214695409060864;
INSERT INTO t_ai_acctfieldmapentry(FID,FENTITYID,FENTRYID,FDATATYPE,FFIELDKEY,FSEQ,FFIELDNAME) VALUES (920154099578614784,'bd_customer',1109214695409060864,'1','basedata0',1,'客户'); 
DELETE FROM t_ai_acctfieldmapentry WHERE FENTRYID = 1109214695409060865;
INSERT INTO t_ai_acctfieldmapentry(FID,FENTITYID,FENTRYID,FDATATYPE,FFIELDKEY,FSEQ,FFIELDNAME) VALUES (920154099578614784,'bd_currency',1109214695409060865,'1','basedata1',2,'币别'); 
DELETE FROM t_ai_acctfieldmapentry WHERE FENTRYID = 1109214985864615936;
INSERT INTO t_ai_acctfieldmapentry(FID,FENTITYID,FENTRYID,FDATATYPE,FFIELDKEY,FSEQ,FFIELDNAME) VALUES (1102316252107493376,'bd_customer',1109214985864615936,'1','basedata0',1,'客户'); 
DELETE FROM t_ai_acctfieldmapentry WHERE FENTRYID = 1109214985864615937;
INSERT INTO t_ai_acctfieldmapentry(FID,FENTITYID,FENTRYID,FDATATYPE,FFIELDKEY,FSEQ,FFIELDNAME) VALUES (1102316252107493376,'bd_currency',1109214985864615937,'1','basedata1',2,'币别'); 
DELETE FROM t_ai_acctfieldmapentry WHERE FENTRYID = 1109214304365710336;
INSERT INTO t_ai_acctfieldmapentry(FID,FENTITYID,FENTRYID,FDATATYPE,FFIELDKEY,FSEQ,FFIELDNAME) VALUES (1102318327205816320,'bd_customer',1109214304365710336,'1','basedata0',1,'客户'); 
DELETE FROM t_ai_acctfieldmapentry WHERE FENTRYID = 1109214304365710337;
INSERT INTO t_ai_acctfieldmapentry(FID,FENTITYID,FENTRYID,FDATATYPE,FFIELDKEY,FSEQ,FFIELDNAME) VALUES (1102318327205816320,'bd_currency',1109214304365710337,'1','basedata1',2,'币别'); 
DELETE FROM t_ai_acctfieldmapentry WHERE FENTRYID = 1109210821373728768;
INSERT INTO t_ai_acctfieldmapentry(FID,FENTITYID,FENTRYID,FDATATYPE,FFIELDKEY,FSEQ,FFIELDNAME) VALUES (1102324724710625280,'bd_customer',1109210821373728768,'1','basedata0',1,'客户'); 
DELETE FROM t_ai_acctfieldmapentry WHERE FENTRYID = 1109210821373728769;
INSERT INTO t_ai_acctfieldmapentry(FID,FENTITYID,FENTRYID,FDATATYPE,FFIELDKEY,FSEQ,FFIELDNAME) VALUES (1102324724710625280,'bd_currency',1109210821373728769,'1','basedata1',2,'币别'); 
DELETE FROM t_ai_acctfieldmapentry WHERE FENTRYID = 1109210918312482816;
INSERT INTO t_ai_acctfieldmapentry(FID,FENTITYID,FENTRYID,FDATATYPE,FFIELDKEY,FSEQ,FFIELDNAME) VALUES (1102350607718639616,'bd_customer',1109210918312482816,'1','basedata0',1,'客户'); 
DELETE FROM t_ai_acctfieldmapentry WHERE FENTRYID = 1109210918312482817;
INSERT INTO t_ai_acctfieldmapentry(FID,FENTITYID,FENTRYID,FDATATYPE,FFIELDKEY,FSEQ,FFIELDNAME) VALUES (1102350607718639616,'bd_currency',1109210918312482817,'1','basedata1',2,'币别'); 
DELETE FROM t_ai_acctfieldmapentry WHERE FENTRYID = 1109214754523584512;
INSERT INTO t_ai_acctfieldmapentry(FID,FENTITYID,FENTRYID,FDATATYPE,FFIELDKEY,FSEQ,FFIELDNAME) VALUES (1102353566841975808,'bd_customer',1109214754523584512,'1','basedata0',1,'客户'); 
DELETE FROM t_ai_acctfieldmapentry WHERE FENTRYID = 1109214754523584513;
INSERT INTO t_ai_acctfieldmapentry(FID,FENTITYID,FENTRYID,FDATATYPE,FFIELDKEY,FSEQ,FFIELDNAME) VALUES (1102353566841975808,'bd_currency',1109214754523584513,'1','basedata1',2,'币别'); 
DELETE FROM t_ai_acctfieldmapentry WHERE FENTRYID = 1109215515059948544;
INSERT INTO t_ai_acctfieldmapentry(FID,FENTITYID,FENTRYID,FDATATYPE,FFIELDKEY,FSEQ,FFIELDNAME) VALUES (1102354837456040960,'bd_customer',1109215515059948544,'1','basedata0',1,'客户'); 
DELETE FROM t_ai_acctfieldmapentry WHERE FENTRYID = 1109215515059948545;
INSERT INTO t_ai_acctfieldmapentry(FID,FENTITYID,FENTRYID,FDATATYPE,FFIELDKEY,FSEQ,FFIELDNAME) VALUES (1102354837456040960,'bd_currency',1109215515059948545,'1','basedata1',2,'币别'); 
DELETE FROM t_ai_acctfieldmapentry WHERE FENTRYID = 1109209457738389504;
INSERT INTO t_ai_acctfieldmapentry(FID,FENTITYID,FENTRYID,FDATATYPE,FFIELDKEY,FSEQ,FFIELDNAME) VALUES (1102927388305639424,'bd_customer',1109209457738389504,'1','basedata0',1,'客户'); 
DELETE FROM t_ai_acctfieldmapentry WHERE FENTRYID = 1109209457738389505;
INSERT INTO t_ai_acctfieldmapentry(FID,FENTITYID,FENTRYID,FDATATYPE,FFIELDKEY,FSEQ,FFIELDNAME) VALUES (1102927388305639424,'bd_currency',1109209457738389505,'1','basedata1',2,'币别'); 
DELETE FROM t_ai_acctfieldmapentry WHERE FENTRYID = 1109209501610806272;
INSERT INTO t_ai_acctfieldmapentry(FID,FENTITYID,FENTRYID,FDATATYPE,FFIELDKEY,FSEQ,FFIELDNAME) VALUES (1102927996320320512,'bd_customer',1109209501610806272,'1','basedata0',1,'客户'); 
DELETE FROM t_ai_acctfieldmapentry WHERE FENTRYID = 1109209501610806273;
INSERT INTO t_ai_acctfieldmapentry(FID,FENTITYID,FENTRYID,FDATATYPE,FFIELDKEY,FSEQ,FFIELDNAME) VALUES (1102927996320320512,'bd_currency',1109209501610806273,'1','basedata1',2,'币别'); 
DELETE FROM t_ai_acctfieldmapentry WHERE FENTRYID = 1109211056489630720;
INSERT INTO t_ai_acctfieldmapentry(FID,FENTITYID,FENTRYID,FDATATYPE,FFIELDKEY,FSEQ,FFIELDNAME) VALUES (1103011200851015680,'bd_customer',1109211056489630720,'1','basedata0',1,'客户'); 
DELETE FROM t_ai_acctfieldmapentry WHERE FENTRYID = 1109211056489630721;
INSERT INTO t_ai_acctfieldmapentry(FID,FENTITYID,FENTRYID,FDATATYPE,FFIELDKEY,FSEQ,FFIELDNAME) VALUES (1103011200851015680,'bd_currency',1109211056489630721,'1','basedata1',2,'币别'); 
DELETE FROM t_ai_acctfieldmapentry WHERE FENTRYID = 1109211116342348800;
INSERT INTO t_ai_acctfieldmapentry(FID,FENTITYID,FENTRYID,FDATATYPE,FFIELDKEY,FSEQ,FFIELDNAME) VALUES (1103012088424462336,'bd_customer',1109211116342348800,'1','basedata0',1,'客户'); 
DELETE FROM t_ai_acctfieldmapentry WHERE FENTRYID = 1109211116342348801;
INSERT INTO t_ai_acctfieldmapentry(FID,FENTITYID,FENTRYID,FDATATYPE,FFIELDKEY,FSEQ,FFIELDNAME) VALUES (1103012088424462336,'bd_currency',1109211116342348801,'1','basedata1',2,'币别'); 


-- 金额类别分录
DELETE FROM T_AI_AMOUNTTYPEENTRY WHERE FENTRYID = 785345962716464128;
INSERT INTO T_AI_AMOUNTTYPEENTRY(FID,FCREATETIME,FMODIFIERID,FBIZAPP,FENTRYID,FSEQ,FMODIFYTIME,FORGID,FMASTERID,FNUMBER) VALUES (785345962406063104,NULL,0,' ',785345962716464128,1,NULL,0,0,'AR001'); 
DELETE FROM T_AI_AMOUNTTYPEENTRY WHERE FENTRYID = 874514201123509248;
INSERT INTO T_AI_AMOUNTTYPEENTRY(FID,FCREATETIME,FMODIFIERID,FBIZAPP,FENTRYID,FSEQ,FMODIFYTIME,FORGID,FMASTERID,FNUMBER) VALUES (785345962406063104,NULL,0,' ',874514201123509248,2,NULL,0,0,'AR002'); 
DELETE FROM T_AI_AMOUNTTYPEENTRY WHERE FENTRYID = 874519130848382976;
INSERT INTO T_AI_AMOUNTTYPEENTRY(FID,FCREATETIME,FMODIFIERID,FBIZAPP,FENTRYID,FSEQ,FMODIFYTIME,FORGID,FMASTERID,FNUMBER) VALUES (785345962406063104,NULL,0,' ',874519130848382976,3,NULL,0,0,'AR003'); 


-- 金额类别分录多语言
DELETE FROM T_AI_AMOUNTTYPEENTRY_L WHERE FPKID = '0FFHHKMGGVX4';
INSERT INTO T_AI_AMOUNTTYPEENTRY_L(FPKID,FLOCALEID,FENTRYID,FNAME) VALUES ('0FFHHKMGGVX4','zh_CN',785345962716464128,'明细应收账款'); 
DELETE FROM T_AI_AMOUNTTYPEENTRY_L WHERE FPKID = '0FFHHKMGGVX5';
INSERT INTO T_AI_AMOUNTTYPEENTRY_L(FPKID,FLOCALEID,FENTRYID,FNAME) VALUES ('0FFHHKMGGVX5','zh_TW',785345962716464128,'明細應收賬款'); 
DELETE FROM T_AI_AMOUNTTYPEENTRY_L WHERE FPKID = '0QDP7/C66D+T';
INSERT INTO T_AI_AMOUNTTYPEENTRY_L(FPKID,FLOCALEID,FENTRYID,FNAME) VALUES ('0QDP7/C66D+T','zh_CN',874514201123509248,'暂估应收款'); 
DELETE FROM T_AI_AMOUNTTYPEENTRY_L WHERE FPKID = '0QDP7/C66D+U';
INSERT INTO T_AI_AMOUNTTYPEENTRY_L(FPKID,FLOCALEID,FENTRYID,FNAME) VALUES ('0QDP7/C66D+U','zh_TW',874514201123509248,'暫估應收款'); 
DELETE FROM T_AI_AMOUNTTYPEENTRY_L WHERE FPKID = '0QDQ3YBT/33S';
INSERT INTO T_AI_AMOUNTTYPEENTRY_L(FPKID,FLOCALEID,FENTRYID,FNAME) VALUES ('0QDQ3YBT/33S','zh_CN',874519130848382976,'预收款'); 
DELETE FROM T_AI_AMOUNTTYPEENTRY_L WHERE FPKID = '0QDQ3YBT/33T';
INSERT INTO T_AI_AMOUNTTYPEENTRY_L(FPKID,FLOCALEID,FENTRYID,FNAME) VALUES ('0QDQ3YBT/33T','zh_TW',874519130848382976,'預收款'); 


-- 金额类别
DELETE FROM T_AI_AMOUNTTYPE WHERE FID = 785345962406063104;
INSERT INTO T_AI_AMOUNTTYPE(FID,FCREATETIME,FMODIFIERID,FBIZAPP,FMODIFYTIME,FORGID,FMASTERID,FNUMBER) VALUES (785345962406063104,{ts'2019-12-20  13:42:08'},0,'/BBRH+122=39',{ts'2021-03-11  10:09:46'},0,785345962406063104,' '); 

-- 金额类别多语言
