--報表數據源配置字段映射--預留記錄
DELETE FROM t_scmc_rpt_colmap WHERE FID = 1503692510571269120;
INSERT INTO t_scmc_rpt_colmap(FID,FREPORTENTITY,FMODIFYDATE,FMODIFIER,FMAPINFO,FMAPINFO_TAG,FSRCENTITY,FCREATEDATE,FSYSDATA,FCREATER,FNAME,FNUMBER) VALUES (1503692510571269120,'im_real_bal_repo',{ts'2022-09-07  00:00:00'},13466739,' ','{"repocol":["org","warehouse","location","ownertype","owner","keepertype","keeper","invstatus","invtype","materialgroup","material","auxpty","lotnumber","project","baseunit","unit","unit2nd","baseqty","qty","qty2nd","tracknumber","configuredcode","baseqty_lock","qty_lock","qty2nd_lock","baseqty_avb","qty_avb","qty2nd_avb","producedate","expirydate","id"],"fullsrccol":["s_org","s_warehouse","s_location","s_owner_type","s_owner","s_keeper_type","s_keeper","s_invstatus","s_invtype","s_materiel.group","s_materiel","s_auxpty","s_lotnum","s_project","s_baseunit","s_unit","s_unit2nd","","","","","s_configuredcode","base_qty","qty","qty2nd","","","","","",""],"defval":["","","","","","","","","","","","","","","","","","0","0","0","","","","","","0","0","0","","",""],"remark":["","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""],"srccol":["s_org","s_warehouse","s_location","s_owner_type","s_owner","s_keeper_type","s_keeper","s_invstatus","s_invtype","s_materiel.group","s_materiel","s_auxpty","s_lotnum","s_project","s_baseunit","s_unit","s_unit2nd","","","","","s_configuredcode","base_qty","qty","qty2nd","","","","","",""]}','msmod_reserve_record',{ts'2022-09-06  00:00:00'},'1',1164445317291206656,'预留记录字段映射','msmod_msmod_reserverecord');

DELETE FROM t_scmc_rpt_colmap_L WHERE FPKID = '2PP0GL887LZH';
INSERT INTO t_scmc_rpt_colmap_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1503692510571269120,'2PP0GL887LZH','zh_CN','预留记录字段映射'); 
DELETE FROM t_scmc_rpt_colmap_L WHERE FPKID = '2PP0GL887LZI';
INSERT INTO t_scmc_rpt_colmap_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1503692510571269120,'2PP0GL887LZI','zh_TW','預留記錄字段映射'); 
--即时库存数据源数据增加预留记录数据查询
DELETE FROM T_SCMC_RPT_CF_DATA WHERE FENTRYID = 1503693015833906176;
INSERT INTO T_SCMC_RPT_CF_DATA(FID,FBLOCKSTATUS,FSRCTYPE,FDATAFS,FSRCENTITY,FENTRYID,FCOLMAP,FSEQ,FDATAFS_TAG,FBLOCKDESC) VALUES (1335323842436167680,'1','A',' ','msmod_reserve_record',1503693015833906176,1503692510571269120,2,'{"expression":"","exprTran":"供应ID 等于 0   and    供应对象.编码 等于 im_inv_realbalance","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2PP0JZK88R=S","leftBracket":"","compareType":"67","fieldName":"bal_id","rightBracket":"","logic":"0","value":[{"id":"2PP0JZK8=U2J","value":"0"}],"baseDataIds":[]},{"id":"2QDL/1OR91LG","leftBracket":"","compareType":"67","fieldName":"bal_obj.number","rightBracket":"","logic":"0","value":[{"id":"2QDL/1ORA51H","value":"im_inv_realbalance"}],"baseDataIds":[{"id":"2QDL/1OR91LH","value":"im_inv_realbalance"}]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2PP0JZK88R=S\",\"leftBracket\":\"\",\"compareType\":\"67\",\"fieldName\":\"bal_id\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2PP0JZK8=U2J\",\"value\":\"0\"}],\"baseDataIds\":[]},{\"id\":\"2QDL/1OR91LG\",\"leftBracket\":\"\",\"compareType\":\"67\",\"fieldName\":\"bal_obj.number\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2QDL/1ORA51H\",\"value\":\"im_inv_realbalance\"}],\"baseDataIds\":[{\"id\":\"2QDL/1OR91LH\",\"value\":\"im_inv_realbalance\"}]}],\"forList\":false}","initialized":false,"exprDesc":"供应ID 等于 0   and    供应对象.编码 等于 im_inv_realbalance","localeExprTran":{"zh_CN":"供应ID 等于 0   and    供应对象.编码 等于 im_inv_realbalance"}}','预留记录数据'); 
DELETE FROM T_SCMC_RPT_CF_DATA_L WHERE FPKID = '2PP0K9UA=OUP';
INSERT INTO T_SCMC_RPT_CF_DATA_L(FPKID,FLOCALEID,FENTRYID,FBLOCKDESC) VALUES ('2PP0K9UA=OUP','zh_CN',1503693015833906176,'预留记录数据'); 
DELETE FROM T_SCMC_RPT_CF_DATA_L WHERE FPKID = '2PP0K9UA=OUQ';
INSERT INTO T_SCMC_RPT_CF_DATA_L(FPKID,FLOCALEID,FENTRYID,FBLOCKDESC) VALUES ('2PP0K9UA=OUQ','zh_TW',1503693015833906176,'預留記錄數據'); 
