--BOM批量正反查模型的编码字段重设预设值

UPDATE t_mrp_bftransfer SET fnumber = 'report_bombatchforward_001_S' WHERE FID =  1754277959897726976;
UPDATE t_mrp_bftransfer SET fnumber = 'report_bombatchforward_002_S' WHERE FID =  1754278751874597888;
UPDATE t_mrp_bftransfer SET fnumber = 'report_bombatchforward_003_S' WHERE FID =  1754319862563357696;
UPDATE t_mrp_bftransfer SET fnumber = 'report_bombatchforward_004_S' WHERE FID =  1754277175437050880;

UPDATE t_mrp_bftransfer SET fnumber = 'report_bombatchforward_005_S' WHERE FID =  1759384113330041856;
UPDATE t_mrp_bftransfer SET fnumber = 'report_bombatchforward_006_S' WHERE FID =  1759385840468976640;
UPDATE t_mrp_bftransfer SET fnumber = 'report_bombatchforward_007_S' WHERE FID =  1759386671931024384;
UPDATE t_mrp_bftransfer SET fnumber = 'report_bombatchforward_008_S' WHERE FID =  1759387615859094528;


UPDATE t_msplan_reportextmodel SET fnumber = 'bomBatchForward_001_S' WHERE FID =  1754286130653578240;
UPDATE t_msplan_reportextmodel SET fnumber = 'bomBatchForward_002_S' WHERE FID =  1754285651630507008;
UPDATE t_msplan_reportextmodel SET fnumber = 'bomBatchForward_003_S' WHERE FID =  1759389934193566720;
UPDATE t_msplan_reportextmodel SET fnumber = 'bomBatchForward_004_S' WHERE FID =  1759389678651401216;


--插入默认实体字段映射的数据
IF NOT EXISTS (SELECT 1 FROM t_msplan_reportextmatch WHERE FID =  1754286130653578240 and FENTRYMATCHDIMENSIONS = 1754277959897726976) 
INSERT INTO t_msplan_reportextmatch(FID,FENTRYMATCHDIMENSIONS,FENTRYID,FSEQ) VALUES (1754286130653578240,1754277959897726976,2042310890614705152,1); 

IF NOT EXISTS (SELECT 1 FROM t_msplan_reportextmatch WHERE FID =  1754286130653578240 and FENTRYMATCHDIMENSIONS = 1754278751874597888) 
INSERT INTO t_msplan_reportextmatch(FID,FENTRYMATCHDIMENSIONS,FENTRYID,FSEQ) VALUES (1754286130653578240,1754278751874597888,2042310890614705153,2); 

IF NOT EXISTS (SELECT 1 FROM t_msplan_reportextmatch WHERE FID =  1754285651630507008 and FENTRYMATCHDIMENSIONS = 1754319862563357696) 
INSERT INTO t_msplan_reportextmatch(FID,FENTRYMATCHDIMENSIONS,FENTRYID,FSEQ) VALUES (1754285651630507008,1754319862563357696,2042311138313522176,1); 

IF NOT EXISTS (SELECT 1 FROM t_msplan_reportextmatch WHERE FID =  1754285651630507008 and FENTRYMATCHDIMENSIONS = 1754277175437050880) 
INSERT INTO t_msplan_reportextmatch(FID,FENTRYMATCHDIMENSIONS,FENTRYID,FSEQ) VALUES (1754285651630507008,1754277175437050880,2042311138313522177,2); 

IF NOT EXISTS (SELECT 1 FROM t_msplan_reportextmatch WHERE FID =  1759389934193566720 and FENTRYMATCHDIMENSIONS = 1759384113330041856) 
INSERT INTO t_msplan_reportextmatch(FID,FENTRYMATCHDIMENSIONS,FENTRYID,FSEQ) VALUES (1759389934193566720,1759384113330041856,2042311335873628160,1); 

IF NOT EXISTS (SELECT 1 FROM t_msplan_reportextmatch WHERE FID =  1759389934193566720 and FENTRYMATCHDIMENSIONS = 1759385840468976640) 
INSERT INTO t_msplan_reportextmatch(FID,FENTRYMATCHDIMENSIONS,FENTRYID,FSEQ) VALUES (1759389934193566720,1759385840468976640,2042311335873628161,2); 

IF NOT EXISTS (SELECT 1 FROM t_msplan_reportextmatch WHERE FID =  1759389678651401216 and FENTRYMATCHDIMENSIONS = 1759386671931024384) 
INSERT INTO t_msplan_reportextmatch(FID,FENTRYMATCHDIMENSIONS,FENTRYID,FSEQ) VALUES (1759389678651401216,1759386671931024384,2042311647560748032,1); 

IF NOT EXISTS (SELECT 1 FROM t_msplan_reportextmatch WHERE FID =  1759389678651401216 and FENTRYMATCHDIMENSIONS = 1759387615859094528) 
INSERT INTO t_msplan_reportextmatch(FID,FENTRYMATCHDIMENSIONS,FENTRYID,FSEQ) VALUES (1759389678651401216,1759387615859094528,2042311647560748033,2); 

IF NOT EXISTS (SELECT 1 FROM t_msplan_reportextmatch WHERE FID =  1879823060438136832 and FENTRYMATCHDIMENSIONS = 1892192201010587648) 
INSERT INTO t_msplan_reportextmatch(FID,FENTRYMATCHDIMENSIONS,FENTRYID,FSEQ) VALUES (1879823060438136832,1892192201010587648,2042313249566771200,1); 

IF NOT EXISTS (SELECT 1 FROM t_msplan_reportextmatch WHERE FID =  1879823060438136832 and FENTRYMATCHDIMENSIONS = 1892191013678622720) 
INSERT INTO t_msplan_reportextmatch(FID,FENTRYMATCHDIMENSIONS,FENTRYID,FSEQ) VALUES (1879823060438136832,1892191013678622720,2042313249566771201,2); 
