-- 添加模板场景的预插数据
-- number即场景编码一旦写入 调用消息接口中传入tplScene=number即可
-- entityNumber 为业务对象编码 用于场景分类
DELETE FROM T_MSG_TPLSCENE WHERE  FID = '768029784910474240';
Insert into T_MSG_TPLSCENE ( FID,FNUMBER,FENTITYNUMBER) values (768029784910474240,'purinstockquery','pur_instock');
DELETE FROM T_MSG_TPLSCENE WHERE  FID = '768029125305847808';
Insert into T_MSG_TPLSCENE ( FID,FNUMBER,FENTITYNUMBER) values (768029125305847808,'purorderconfirm','pur_order');
DELETE FROM T_MSG_TPLSCENE WHERE  FID = '768026532152224768';
Insert into T_MSG_TPLSCENE ( FID,FNUMBER,FENTITYNUMBER) values (768026532152224768,'purorderalterconfirm','pur_ordchange');
DELETE FROM T_MSG_TPLSCENE WHERE  FID = '768029971380850688';
Insert into T_MSG_TPLSCENE ( FID,FNUMBER,FENTITYNUMBER) values (768029971380850688,'purreceiptquery','pur_receipt');
DELETE FROM T_MSG_TPLSCENE WHERE  FID = '768030250956378112';
Insert into T_MSG_TPLSCENE ( FID,FNUMBER,FENTITYNUMBER) values (768030250956378112,'purreceiptreturnquery','pur_receipt_return');
DELETE FROM T_MSG_TPLSCENE WHERE  FID = '768030445270084608';
Insert into T_MSG_TPLSCENE ( FID,FNUMBER,FENTITYNUMBER) values (768030445270084608,'purreturnquery','pur_return');
DELETE FROM T_MSG_TPLSCENE WHERE  FID = '768030671980604416';
Insert into T_MSG_TPLSCENE ( FID,FNUMBER,FENTITYNUMBER) values (768030671980604416,'purcheckconfirm','pur_check');
DELETE FROM T_MSG_TPLSCENE WHERE  FID = '768030848275590144';
Insert into T_MSG_TPLSCENE ( FID,FNUMBER,FENTITYNUMBER) values (768030848275590144,'purcheckquery','pur_check');
DELETE FROM T_MSG_TPLSCENE WHERE  FID = '768031073048350720';
Insert into T_MSG_TPLSCENE ( FID,FNUMBER,FENTITYNUMBER) values (768031073048350720,'purpayquery','pur_pay');
DELETE FROM T_MSG_TPLSCENE WHERE  FID = '768031308113924096';
Insert into T_MSG_TPLSCENE ( FID,FNUMBER,FENTITYNUMBER) values (768031308113924096,'purpayapplyquery','pur_payapply');
DELETE FROM T_MSG_TPLSCENE WHERE  FID = '769687477895218176';
Insert into T_MSG_TPLSCENE ( FID,FNUMBER,FENTITYNUMBER) values (769687477895218176,'scpcheckconfirm','scp_check');
DELETE FROM T_MSG_TPLSCENE WHERE  FID = '769687780329751552';
Insert into T_MSG_TPLSCENE ( FID,FNUMBER,FENTITYNUMBER) values (769687780329751552,'scpcheckquery','scp_check');

-- T_MSG_TPLSCENE_L 模板场景多语言表
DELETE FROM T_MSG_TPLSCENE_L WHERE  FID = '768029125305847808';
Insert into T_MSG_TPLSCENE_L (FPKID, FID,FLOCALEID,FNAME) values ('0DAIY26ORKKB',768029125305847808,'zh_CN','采购订单确认');
Insert into T_MSG_TPLSCENE_L (FPKID, FID,FLOCALEID,FNAME) values ('0DAIY26ORKKC',768029125305847808,'zh_TW','采購訂單確認');
DELETE FROM T_MSG_TPLSCENE_L WHERE  FID = '768029784910474240';
Insert into T_MSG_TPLSCENE_L (FPKID, FID,FLOCALEID,FNAME) values ('0DAJ0WNE6+U8',768029784910474240,'zh_CN','采购入库查询');
Insert into T_MSG_TPLSCENE_L (FPKID, FID,FLOCALEID,FNAME) values ('0DAJ0WNE6+U9',768029784910474240,'zh_TW','采購入庫查詢');
DELETE FROM T_MSG_TPLSCENE_L WHERE  FID = '768026532152224768';
Insert into T_MSG_TPLSCENE_L (FPKID, FID,FLOCALEID,FNAME) values ('0DAIF68G52AG',768026532152224768,'zh_CN','采购订单变更确认');
Insert into T_MSG_TPLSCENE_L (FPKID, FID,FLOCALEID,FNAME) values ('0DAIF68G52AH',768026532152224768,'zh_TW','采購訂單變更確認');
DELETE FROM T_MSG_TPLSCENE_L WHERE  FID = '768029971380850688';
Insert into T_MSG_TPLSCENE_L (FPKID, FID,FLOCALEID,FNAME) values ('0DAJ28N577WE',768029971380850688,'zh_CN','采购收货查询');
Insert into T_MSG_TPLSCENE_L (FPKID, FID,FLOCALEID,FNAME) values ('0DAJ28N577WF',768029971380850688,'zh_TW','采購收貨查詢');
DELETE FROM T_MSG_TPLSCENE_L WHERE  FID = '768030250956378112';
Insert into T_MSG_TPLSCENE_L (FPKID, FID,FLOCALEID,FNAME) values ('0DAJ4=2UJW1P',768030250956378112,'zh_CN','采购收货退货');
Insert into T_MSG_TPLSCENE_L (FPKID, FID,FLOCALEID,FNAME) values ('0DAJ4=2UJW1Q',768030250956378112,'zh_TW','采購收貨退貨');
DELETE FROM T_MSG_TPLSCENE_L WHERE  FID = '768030445270084608';
Insert into T_MSG_TPLSCENE_L (FPKID, FID,FLOCALEID,FNAME) values ('0DAJ5PAHYMC+',768030445270084608,'zh_CN','采购入库退货查询');
Insert into T_MSG_TPLSCENE_L (FPKID, FID,FLOCALEID,FNAME) values ('0DAJ5PAHYMC/',768030445270084608,'zh_TW','采購入庫退貨查詢');
DELETE FROM T_MSG_TPLSCENE_L WHERE  FID = '768030671980604416';
Insert into T_MSG_TPLSCENE_L (FPKID, FID,FLOCALEID,FNAME) values ('0DAJ7BR90PJG',768030671980604416,'zh_CN','采购对账确认');
Insert into T_MSG_TPLSCENE_L (FPKID, FID,FLOCALEID,FNAME) values ('0DAJ7BR90PJH',768030671980604416,'zh_TW','采購對賬確認');
DELETE FROM T_MSG_TPLSCENE_L WHERE  FID = '768030848275590144';
Insert into T_MSG_TPLSCENE_L (FPKID, FID,FLOCALEID,FNAME) values ('0DAJ8MV7PG+X',768030848275590144,'zh_CN','采购对账查询');
Insert into T_MSG_TPLSCENE_L (FPKID, FID,FLOCALEID,FNAME) values ('0DAJ8MV7PG+Y',768030848275590144,'zh_TW','采購對賬查詢');
DELETE FROM T_MSG_TPLSCENE_L WHERE  FID = '768031073048350720';
Insert into T_MSG_TPLSCENE_L (FPKID, FID,FLOCALEID,FNAME) values ('0DAJ=9QH6GMM',768031073048350720,'zh_CN','采购付款查询');
Insert into T_MSG_TPLSCENE_L (FPKID, FID,FLOCALEID,FNAME) values ('0DAJ=9QH6GMN',768031073048350720,'zh_TW','采購付款查詢');
DELETE FROM T_MSG_TPLSCENE_L WHERE  FID = '768031308113924096';
Insert into T_MSG_TPLSCENE_L (FPKID, FID,FLOCALEID,FNAME) values ('0DAJB+IUU2OW',768031308113924096,'zh_CN','付款申请查询');
Insert into T_MSG_TPLSCENE_L (FPKID, FID,FLOCALEID,FNAME) values ('0DAJB+IUU2OX',768031308113924096,'zh_TW','付款申請查詢');
DELETE FROM T_MSG_TPLSCENE_L WHERE  FID = '769687477895218176';
Insert into T_MSG_TPLSCENE_L (FPKID, FID,FLOCALEID,FNAME) values ('0DIGSG=9M76U',769687477895218176,'zh_CN','协同对账确认');
Insert into T_MSG_TPLSCENE_L (FPKID, FID,FLOCALEID,FNAME) values ('0DIGSG=9M76V',769687477895218176,'zh_TW','協同對賬確認');
DELETE FROM T_MSG_TPLSCENE_L WHERE  FID = '769687780329751552';
Insert into T_MSG_TPLSCENE_L (FPKID, FID,FLOCALEID,FNAME) values ('0DIGUO8=WF/8',769687780329751552,'zh_CN','协同对账查询');
Insert into T_MSG_TPLSCENE_L (FPKID, FID,FLOCALEID,FNAME) values ('0DIGUO8=WF/9',769687780329751552,'zh_TW','協同對賬查詢');