-- 修改委外入库单的报表配置
DELETE FROM t_scmc_rpt_colmap WHERE FID = 1452898469218880512;
INSERT INTO t_scmc_rpt_colmap(FID,FREPORTENTITY,FMODIFYDATE,FMODIFIER,FMAPINFO,FMAPINFO_TAG,FSRCENTITY,FCREATEDATE,FSYSDATA,FCREATER,FNUMBER,FNAME) VALUES (1452898469218880512,'im_sum_repo',{ts'2023-05-16  00:00:00'},13466739,' ','{"repocol":["transceivertype","expirydate","producedate","project","unit2nd","datatype","invstatus","qty2nd","biztime","auxpty","owner","org","baseunit","isupdatebal","keeper","baseqty","warehouse","unit","invtype","material","keepertype","ownertype","lotnumber","qty","location","billno","status","materialgroup","islogisticsbill","isvirtualbill","materialmasterid","configuredcode","noupdateinvfields","tracknumber"],"fullsrccol":["invscheme.transceivertype","billentry.expirydate","billentry.producedate","billentry.project","billentry.unit2nd","","billentry.outinvstatus","billentry.qtyunit2nd","bookdate","billentry.auxpty","billentry.outowner","org","billentry.baseunit","invscheme.isnotupdate","billentry.outkeeper","billentry.baseqty","billentry.outwarehouse","billentry.unit","billentry.outinvtype","billentry.material.masterid","billentry.outkeepertype","billentry.outownertype","billentry.lotnumber","billentry.qty","billentry.outlocation","billno","billstatus","billentry.material.masterid.group","billentry.logisticsbill","isvirtualbill","billentry.materialmasterid","billentry.configuredcode","billentry.noupdateinvfields","billentry.tracknumber"],"defval":["","","","","","1","","","","","","","","","","","","","","","","","","","","","","","","","","","",""],"remark":["","","","","","0：收入，1：发出，2：期初","","","","","","","","","","","","","","","","","","","","","","","","","","","",""],"srccol":["invscheme.transceivertype","expirydate","producedate","project","unit2nd","","outinvstatus","qtyunit2nd","bookdate","auxpty","outowner","org","baseunit","invscheme.isnotupdate","outkeeper","baseqty","outwarehouse","unit","outinvtype","material.masterid","outkeepertype","outownertype","lotnumber","qty","outlocation","billno","billstatus","material.masterid.group","logisticsbill","isvirtualbill","materialmasterid","configuredcode","noupdateinvfields","tracknumber"]}','im_ospurinbill',{ts'2022-06-28  00:00:00'},'1',13466739,'im_sum_im_ospurinbill_out','物料收发汇总—委外采购入库（发出）');

DELETE FROM t_scmc_rpt_colmap WHERE FID = 1452904897233030144;
INSERT INTO t_scmc_rpt_colmap(FID,FREPORTENTITY,FMODIFYDATE,FMODIFIER,FMAPINFO,FMAPINFO_TAG,FSRCENTITY,FCREATEDATE,FSYSDATA,FCREATER,FNUMBER,FNAME) VALUES (1452904897233030144,'im_dull_repo',{ts'2023-05-16  00:00:00'},13466739,' ','{"repocol":["transceivertype","expirydate","producedate","project","unit2nd","datatype","invstatus","qty2nd","biztime","auxpty","owner","org","baseunit","isupdatebal","keeper","baseqty","warehouse","unit","invtype","material","keepertype","ownertype","lotnumber","qty","location","status","materialgroup","islogisticsbill","isvirtualbill","materialmasterid","configuredcode","noupdateinvfields","tracknumber","invscheme"],"fullsrccol":["invscheme.transceivertype","billentry.expirydate","billentry.producedate","billentry.project","billentry.unit2nd","","billentry.outinvstatus","billentry.qtyunit2nd","bookdate","billentry.auxpty","billentry.outowner","org","billentry.baseunit","invscheme.isnotupdate","billentry.outkeeper","billentry.baseqty","billentry.outwarehouse","billentry.unit","billentry.outinvtype","billentry.material.masterid","billentry.outkeepertype","billentry.outownertype","billentry.lotnumber","billentry.qty","billentry.outlocation","billstatus","billentry.material.masterid.group","billentry.logisticsbill","isvirtualbill","billentry.materialmasterid","billentry.configuredcode","billentry.noupdateinvfields","billentry.tracknumber","invscheme"],"defval":["","","","","","1","","","","","","","","","","","","","","","","","","","","","","","","","","","",""],"remark":["","","","","","0：收入，1：发出，2：期初","","","","","","","","","","","","","","","","","","","","","","","","","","","",""],"srccol":["invscheme.transceivertype","expirydate","producedate","project","unit2nd","","outinvstatus","qtyunit2nd","bookdate","auxpty","outowner","org","baseunit","invscheme.isnotupdate","outkeeper","baseqty","outwarehouse","unit","outinvtype","material.masterid","outkeepertype","outownertype","lotnumber","qty","outlocation","billstatus","material.masterid.group","logisticsbill","isvirtualbill","materialmasterid","configuredcode","noupdateinvfields","tracknumber","invscheme"]}','im_ospurinbill',{ts'2022-06-28  00:00:00'},'1',13466739,'im_dull_im_ospurinbill_out','库存呆滞料—委外采购入库（发出）');


DELETE FROM t_scmc_rpt_colmap WHERE FID = 1452790862940473344;
INSERT INTO t_scmc_rpt_colmap(FID,FREPORTENTITY,FMODIFYDATE,FMODIFIER,FMAPINFO,FMAPINFO_TAG,FSRCENTITY,FCREATEDATE,FSYSDATA,FCREATER,FNUMBER,FNAME) VALUES (1452790862940473344,'im_age_repo',{ts'2023-05-16  00:00:00'},13466739,' ','{"repocol":["transceivertype","expirydate","producedate","project","unit2nd","datatype","invstatus","qty2nd","biztime","auxpty","owner","org","baseunit","isupdatebal","keeper","baseqty","warehouse","unit","invtype","material","keepertype","ownertype","lotnumber","qty","location","status","materialgroup","islogisticsbill","isvirtualbill","materialmasterid","configuredcode","noupdateinvfields","tracknumber"],"fullsrccol":["invscheme.transceivertype","billentry.expirydate","billentry.producedate","billentry.project","billentry.unit2nd","","billentry.outinvstatus","billentry.qtyunit2nd","bookdate","billentry.auxpty","billentry.outowner","org","billentry.baseunit","invscheme.isnotupdate","billentry.outkeeper","billentry.baseqty","billentry.outwarehouse","billentry.unit","billentry.outinvtype","billentry.material.masterid","billentry.outkeepertype","billentry.outownertype","billentry.lotnumber","billentry.qty","billentry.outlocation","billstatus","billentry.material.masterid.group","billentry.logisticsbill","isvirtualbill","billentry.materialmasterid","billentry.configuredcode","billentry.noupdateinvfields","billentry.tracknumber"],"defval":["","","","","","1","","","","","","","","","","","","","","","","","","","","","","","","","","",""],"remark":["","","","","","0：收入，1：发出，2：期初","","","","","","","","","","","","","","","","","","","","","","","","","","",""],"srccol":["invscheme.transceivertype","expirydate","producedate","project","unit2nd","","outinvstatus","qtyunit2nd","bookdate","auxpty","outowner","org","baseunit","invscheme.isnotupdate","outkeeper","baseqty","outwarehouse","unit","outinvtype","material.masterid","outkeepertype","outownertype","lotnumber","qty","outlocation","billstatus","material.masterid.group","logisticsbill","isvirtualbill","materialmasterid","configuredcode","noupdateinvfields","tracknumber"]}','im_ospurinbill',{ts'2022-06-28  00:00:00'},'1',13466739,'im_age_im_ospurinbill_out','库存账龄—委外采购入库（发出）');

DELETE FROM t_scmc_rpt_colmap WHERE FID = 1452793630006709248;
INSERT INTO t_scmc_rpt_colmap(FID,FREPORTENTITY,FMODIFYDATE,FMODIFIER,FMAPINFO,FMAPINFO_TAG,FSRCENTITY,FCREATEDATE,FSYSDATA,FCREATER,FNUMBER,FNAME) VALUES (1452793630006709248,'im_detail_repo',{ts'2023-05-16  00:00:00'},13466739,' ','{"repocol":["transceivertype","project","unit2nd","datatype","invstatus","qty2nd","biztime","auxpty","owner","org","baseunit","isupdatebal","keeper","baseqty","warehouse","unit","invtype","material","keepertype","ownertype","lotnumber","qty","location","billno","status","materialgroup","islogisticsbill","isvirtualbill","materialmasterid","configuredcode","invscheme","auditdate","billtype","bookdate","mainbillnumber","creator","auditor","biztype","tracknumber","perioddate","noupdateinvfields","expirydate","producedate"],"fullsrccol":["invscheme.transceivertype","billentry.project","billentry.unit2nd","","billentry.outinvstatus","billentry.qtyunit2nd","bookdate","billentry.auxpty","billentry.outowner","org","billentry.baseunit","invscheme.isnotupdate","billentry.outkeeper","billentry.baseqty","billentry.outwarehouse","billentry.unit","billentry.outinvtype","billentry.material.masterid","billentry.outkeepertype","billentry.outownertype","billentry.lotnumber","billentry.qty","billentry.outlocation","billno","billstatus","billentry.material.masterid.group","billentry.logisticsbill","isvirtualbill","billentry.materialmasterid","billentry.configuredcode","invscheme","auditdate","billtype","bookdate","billentry.mainbillnumber","creator","auditor","biztype","billentry.tracknumber","bookdate","billentry.noupdateinvfields","billentry.expirydate","billentry.producedate"],"defval":["","","","1","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""],"remark":["","","","0：收入，1：发出，2：期初","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""],"srccol":["invscheme.transceivertype","project","unit2nd","","outinvstatus","qtyunit2nd","bookdate","auxpty","outowner","org","baseunit","invscheme.isnotupdate","outkeeper","baseqty","outwarehouse","unit","outinvtype","material.masterid","outkeepertype","outownertype","lotnumber","qty","outlocation","billno","billstatus","material.masterid.group","logisticsbill","isvirtualbill","materialmasterid","configuredcode","invscheme","auditdate","billtype","bookdate","mainbillnumber","creator","auditor","biztype","tracknumber","bookdate","noupdateinvfields","expirydate","producedate"]}','im_ospurinbill',{ts'2022-06-28  00:00:00'},'1',13466739,'im_detail_im_ospurinbill_out','物料收发明细—委外采购入库（发出）');


DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1686164999141188608;
INSERT INTO T_SBS_BILLFIELDMAP_E(FID,FTARGETOBJCOL,FTARGETOBJCOLNO,FSOURCEBILLCOLNO,FENTRYID,FSEQ,FSOURCEBILLCOL) VALUES (1447660447942575104,'outwarehouse','出库仓库','物料明细.出库仓库',1686164999141188608,34,'billentry.outwarehouse');
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1686164999141188609;
INSERT INTO T_SBS_BILLFIELDMAP_E(FID,FTARGETOBJCOL,FTARGETOBJCOLNO,FSOURCEBILLCOLNO,FENTRYID,FSEQ,FSOURCEBILLCOL) VALUES (1447660447942575104,'outlocation','出库仓位','物料明细.出库仓位',1686164999141188609,35,'billentry.outlocation');
