-- 调拨退回流程   收发类型  3101   
DELETE FROM t_sbd_transceivertype WHERE FID = 1098472580572001280;
INSERT INTO t_sbd_transceivertype(FID,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FBIZDIRECTION,FENABLE,FMODIFIERID,FTRANSCEIVER,FISPRESET,FMODIFYTIME,FFORWARDTYPE,FCREATORID,FDISABLERID)
 VALUES (1098472580572001280,NULL,' ',1098472580572001280,'C','3101','调拨退回',{ts'2021-02-24  14:26:45'},'1','1',947706740454046720,'2','1',{ts'2021-02-24  14:28:55'},688326834949254144,947706740454046720,0); 
 
 DELETE FROM t_sbd_transceivertype_l WHERE FPKID = '1EXNVWWABFNK';
INSERT INTO t_sbd_transceivertype_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1098472580572001280,'1EXNVWWABFNK','zh_CN',' ','调拨退回'); 
DELETE FROM t_sbd_transceivertype_l WHERE FPKID = '1EXNVWWABFNL';
INSERT INTO t_sbd_transceivertype_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1098472580572001280,'1EXNVWWABFNL','zh_TW',' ','調撥退回'); 

 
 
 -- 3111
DELETE FROM t_sbd_transceivertype WHERE FID = 1098481879687902208;
INSERT INTO t_sbd_transceivertype(FID,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FBIZDIRECTION,FENABLE,FMODIFIERID,FTRANSCEIVER,FISPRESET,FMODIFYTIME,FFORWARDTYPE,FCREATORID,FDISABLERID) 
VALUES (1098481879687902208,NULL,' ',1098481879687902208,'C','3111','调出退回',{ts'2021-02-24  14:46:41'},'1','1',947706740454046720,'1','1',{ts'2021-02-24  14:47:24'},687618670800885760,947706740454046720,0); 

DELETE FROM t_sbd_transceivertype_l WHERE FPKID = '1EXPLNJ/BAO7';
INSERT INTO t_sbd_transceivertype_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1098481879687902208,'1EXPLNJ/BAO7','zh_CN',' ','调出退回'); 
DELETE FROM t_sbd_transceivertype_l WHERE FPKID = '1EXPLNJ/BAO8';
INSERT INTO t_sbd_transceivertype_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1098481879687902208,'1EXPLNJ/BAO8','zh_TW',' ','調出退回'); 


--  3121
DELETE FROM t_sbd_transceivertype WHERE FID = 1098484895459574784;
INSERT INTO t_sbd_transceivertype(FID,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FBIZDIRECTION,FENABLE,FMODIFIERID,FTRANSCEIVER,FISPRESET,FMODIFYTIME,FFORWARDTYPE,FCREATORID,FDISABLERID) 
VALUES (1098484895459574784,NULL,' ',1098484895459574784,'C','3121','调入退回',{ts'2021-02-24  14:52:56'},'1','1',947706740454046720,'0','1',{ts'2021-02-24  14:53:23'},687618512088422400,947706740454046720,0); 

DELETE FROM t_sbd_transceivertype_l WHERE FPKID = '1EXQ5ML7RAWV';
INSERT INTO t_sbd_transceivertype_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1098484895459574784,'1EXQ5ML7RAWV','zh_CN',' ','调入退回'); 
DELETE FROM t_sbd_transceivertype_l WHERE FPKID = '1EXQ5ML7RAWW';
INSERT INTO t_sbd_transceivertype_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1098484895459574784,'1EXQ5ML7RAWW','zh_TW',' ','調入退回'); 


--业务类型   3101
DELETE FROM t_bd_biztype WHERE FID = 1098492265111761920;
INSERT INTO t_bd_biztype(FID,FDISABLEDATE,FISPURCHASE,FISSALE,FDESCRIPTION,FMASTERID,FSTATUS,FISINVENTORY,FNUMBER,FNAME,FDOMAIN,FCREATETIME,FENABLE,FMODIFIERID,FISPRESET,FMODIFYTIME,FBIZCATEGORY,FCREATORID,FDISABLERID) 
VALUES (1098492265111761920,NULL,'0','0',' ',1098492265111761920,'C','0','3101','普通调拨退回','2',{ts'2021-02-24  14:56:21'},'1',947706740454046720,'1',{ts'2021-02-24  15:08:02'},'BZ',947706740454046720,0); 

DELETE FROM t_bd_biztype_l WHERE FPKID = '1EXRJB+ZBB9I';
INSERT INTO t_bd_biztype_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1098492265111761920,'1EXRJB+ZBB9I','zh_CN',' ','普通调拨退回'); 
DELETE FROM t_bd_biztype_l WHERE FPKID = '1EXRJB+ZBB9J';
INSERT INTO t_bd_biztype_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1098492265111761920,'1EXRJB+ZBB9J','zh_TW',' ','普通調撥退回'); 

-- 分录
DELETE FROM t_sbd_biztypebillentity WHERE FENTRYID = 1098492265128539136;
INSERT INTO t_sbd_biztypebillentity(FID,FENTRYID,FSEQ,FBILLFORM) VALUES (1098492265111761920,1098492265128539136,1,'im_transdirbill'); 
DELETE FROM t_sbd_biztypebillentity WHERE FENTRYID = 1098492265128539137;
INSERT INTO t_sbd_biztypebillentity(FID,FENTRYID,FSEQ,FBILLFORM) VALUES (1098492265111761920,1098492265128539137,2,'im_transoutbill'); 
DELETE FROM t_sbd_biztypebillentity WHERE FENTRYID = 1098492265128539138;
INSERT INTO t_sbd_biztypebillentity(FID,FENTRYID,FSEQ,FBILLFORM) VALUES (1098492265111761920,1098492265128539138,3,'im_transinbill'); 
