DELETE FROM t_scmc_rpt_colmap WHERE FID = 1398604219438739456;
INSERT INTO t_scmc_rpt_colmap(FID,FREPORTENTITY,FMODIFYDATE,FMODIFIER,FMAPINFO,FMAPINFO_TAG,FSRCENTITY,FCREATEDATE,FSYSDATA,FCREATER,FNUMBER,FNAME) VALUES (1398604219438739456,'im_real_bal_repo',{ts'2022-09-16  00:00:00'},1,' ','{"repocol":["org","warehouse","location","ownertype","owner","keepertype","keeper","invstatus","invtype","materialgroup","material","auxpty","lotnumber","project","producedate","expirydate","baseunit","unit","unit2nd","baseqty","qty","qty2nd","tracknumber","configuredcode","qty_lock","qty2nd_lock","baseqty_lock","baseqty_avb","qty_avb","qty2nd_avb","id"],"fullsrccol":["org","warehouse","location","ownertype","owner","keepertype","keeper","invstatus","invtype","material.group","material","auxpty","lotnum","project","producedate","expirydate","baseunit","unit","unit2nd","baseqty","qty","qty2nd","tracknumber","configuredcode","lockqty","lockqty2nd","lockbaseqty","","","",""],"defval":["","","","","","","","","","","","","","","","","","","","","","","","","","","","0","0","0",""],"remark":["","","","","","","","","","","","","","","","","","","","","","","","","","","","可用量=库存量-锁库量","可用量=库存量-锁库量","可用量=库存量-锁库量",""],"srccol":["org","warehouse","location","ownertype","owner","keepertype","keeper","invstatus","invtype","material.group","material","auxpty","lotnum","project","producedate","expirydate","baseunit","unit","unit2nd","baseqty","qty","qty2nd","tracknumber","configuredcode","lockqty","lockqty2nd","lockbaseqty","","","",""]}','im_inv_realbalance',{ts'2022-04-28  00:00:00'},'1',1,'im_real_bal_im_inv_realbalance','即时库存报表字段映射配置'); 
