--供应商预置西域
IF NOT EXISTS (SELECT 1 FROM t_bd_supplier WHERE FID = 1046997738056736768)
INSERT INTO t_bd_supplier(FADMINORGID,FAPPROVEDATE,FTYPE,FSUPPLIERSTATUS,FPURCHASEDEPTID,FCREATEORGID,FMASTERID,FEMPLOYEE,FENABLEVMI,FLOGO,FSIMPLEPINYIN,FCREATETIME,FBUSINESSTERM,FPURCHASEHOLD,FLINKMAN,FISSUPPCOLLA,FSETTLEMENTTYPEID,FDISABLERID,FSIMPLENAME,FBLOCSUPPLIER,FORGID,FPAYMENTCONDID,FDELIVERSUPPLIERID,FNAME,FREGCAPITAL,FINVOICESUPPLIERID,FMODIFIERID,FINVOICEADDRESS,FPAYHOLD,FTAXTYPE,FRECEIVINGSUPPLIERID,FBIZFUNCTION,FADDRESS,FAPPROVERID,FARTIFICIALPERSON,FPAYMENTUNIT,FTAXRATEID,FMATCHINGRULE,FINVOICEHOLD,FBIZPARTNERID,FCTRLSTRATEGY,FENABLE,FINVOICETYPE,FPAYMENTCURRENCY,FMALLSTATUS,FID,FBILLADDRESS,FINVOICECATEGORY,FPURCHASERID,FDISABLEDATE,FSTATUS,FMALLDATE,FBUSINESSSCOPE,FSETTLEMENTCYID,FNUMBER,FGROUPID,FMODIFYTIME,FCREATORID) VALUES (0,NULL,'1',880835462149703680,0,100000,1046997738056736768,0,'0',' ','xy',{ts'2020-12-15  13:57:10'},' ','0',' ','1',0,0,' ',0,100000,0,1046997738056736768,' ',' ',1046997738056736768,13466739,0,'0',' ',1046997738056736768,',1,2,3,',' ',NULL,' ','1',0,' ','0',968563372075276288,'5','1',' ',0,'B',1046997738056736768,0,0,0,NULL,'C',{ts'2021-02-01  11:15:11'},' ',0,'XY',1,{ts'2020-12-15  13:57:56'},13466739); 

IF NOT EXISTS (SELECT 1 FROM T_BD_Supplier_l WHERE FPKID = '19L1/NR174JT')
INSERT INTO T_BD_Supplier_l(FID,FREGCAPITAL,FPKID,FLOCALEID,FBUSINESSTERM,FLINKMAN,FSIMPLENAME,FADDRESS,FBUSINESSSCOPE,FNAME,FARTIFICIALPERSON) VALUES (1046997738056736768,' ','19L1/NR174JT','zh_CN',' ',' ',' ',' ',' ','西域商城',' '); 

IF NOT EXISTS (SELECT 1 FROM T_BD_Supplier_l WHERE FPKID = '19L1/NR174JU')
INSERT INTO T_BD_Supplier_l(FID,FREGCAPITAL,FPKID,FLOCALEID,FBUSINESSTERM,FLINKMAN,FSIMPLENAME,FADDRESS,FBUSINESSSCOPE,FNAME,FARTIFICIALPERSON) VALUES (1046997738056736768,' ','19L1/NR174JU','zh_TW',' ',' ',' ',' ',' ','西域商城',' '); 

DELETE FROM t_bd_suppliergroupdetail WHERE FID = 1046997904729989120;
INSERT INTO t_bd_suppliergroupdetail(FID,FCREATEORGID,FSUPPLIERID,FSTANDARDID,FGROUPID) VALUES (1046997904729989120,100000,1046997738056736768,716529547008326656,1); 