-- 业务类型 sys库

DELETE FROM t_bd_biztype WHERE fid in('989851541752212480','989852229525793792','990500657985463296');
insert into t_bd_biztype (FID, FNUMBER, FBIZCATEGORY, FISPRESET, FSTATUS, FENABLE, FCREATORID, FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE, FMASTERID, FISPURCHASE, FISSALE, FISINVENTORY, FDOMAIN, FNAME, FDESCRIPTION)
values ('989851541752212480', '4031', 'BZ', '1', 'C', '1', '1', {ts'2020-09-25 10:34:02'}, '1',{ts'2020-09-25 10:34:02'}, '0', null, '989851541752212480', '0', '0', '0', '1', '工序委外', ' ');

insert into t_bd_biztype (FID, FNUMBER, FBIZCATEGORY, FISPRESET, FSTATUS, FENABLE, FCREATORID, FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE, FMASTERID, FISPURCHASE, FISSALE, FISINVENTORY, FDOMAIN, FNAME, FDESCRIPTION)
values ('989852229525793792', '4041', 'BZ', '1', 'C', '1', '1', {ts'2020-09-25 10:34:02'}, '1', {ts'2020-09-25 10:34:02'}, '0', null, '989852229525793792', '0', '0', '0', '1', '工序委外退回', ' ');

insert into t_bd_biztype (FID, FNUMBER, FBIZCATEGORY, FISPRESET, FSTATUS, FENABLE, FCREATORID, FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE, FMASTERID, FISPURCHASE, FISSALE, FISINVENTORY, FDOMAIN, FNAME, FDESCRIPTION)
values ('990500657985463296', '4051', 'BZ', '1', 'C', '1', '1', {ts'2020-09-25 10:34:02'}, '1', {ts'2020-09-25 10:34:02'}, '0', null, '990500657985463296', '0', '0', '0', '1', '普通委外退货', ' ');


DELETE FROM t_bd_biztype_l WHERE fid in('989851541752212480','989852229525793792','990500657985463296');
insert into t_bd_biztype_l (FPKID, FID, FLOCALEID, FNAME, FDESCRIPTION)
values ('12K9H8AS1IH3', '989851541752212480', 'zh_CN', '工序委外', ' ');

insert into t_bd_biztype_l (FPKID, FID, FLOCALEID, FNAME, FDESCRIPTION)
values ('12K9H8AS1IH4', '989851541752212480', 'zh_TW', '工序委外', ' ');

insert into t_bd_biztype_l (FPKID, FID, FLOCALEID, FNAME, FDESCRIPTION)
values ('12K9M8SIF65Q', '989852229525793792', 'zh_CN', '工序委外退回', ' ');

insert into t_bd_biztype_l (FPKID, FID, FLOCALEID, FNAME, FDESCRIPTION)
values ('12K9M8SIF65R', '989852229525793792', 'zh_TW', '工序委外退回', ' ');

insert into t_bd_biztype_l (FPKID, FID, FLOCALEID, FNAME, FDESCRIPTION)
values ('12NCSB6CO+CR', '990500657985463296', 'zh_CN', '普通委外退货', ' ');

insert into t_bd_biztype_l (FPKID, FID, FLOCALEID, FNAME, FDESCRIPTION)
values ('12NCSB6CO+CS', '990500657985463296', 'zh_TW', '普通委外退貨', ' ');

-- 分录单据
--delete from t_sbd_biztypebillentity where FENTRYID ='990567752102208512';
--insert into t_sbd_biztypebillentity (FID, FENTRYID, FSEQ, FBILLFORM)
--values ('966651870204521472', '990567752102208512', '2', 'im_mdc_omproorder');

--delete from t_sbd_biztypebillentity where FENTRYID ='990567752102208513';
--insert into t_sbd_biztypebillentity (FID, FENTRYID, FSEQ, FBILLFORM)
--values ('966651870204521472', '990567752102208513', '3', 'im_mdc_omfeedorder');

delete from t_sbd_biztypebillentity where FENTRYID ='989851541768989696';
insert into t_sbd_biztypebillentity (FID, FENTRYID, FSEQ, FBILLFORM)
values ('989851541752212480', '989851541768989696', '1', 'im_mdc_opmproorder');

delete from t_sbd_biztypebillentity where FENTRYID ='989851541768989697';
insert into t_sbd_biztypebillentity (FID, FENTRYID, FSEQ, FBILLFORM)
values ('989851541752212480', '989851541768989697', '2', 'im_mdc_opmfeedorder');

delete from t_sbd_biztypebillentity where FENTRYID ='989852229525793793';
insert into t_sbd_biztypebillentity (FID, FENTRYID, FSEQ, FBILLFORM)
values ('989852229525793792', '989852229525793793', '1', 'im_mdc_opmreturnorder');

delete from t_sbd_biztypebillentity where FENTRYID ='990500658019017728';
insert into t_sbd_biztypebillentity (FID, FENTRYID, FSEQ, FBILLFORM)
values ('990500657985463296', '990500658019017728', '1', 'im_mdc_omreturnorder');

delete from t_sbd_biztypebillentity where FENTRYID ='1031989288147167232';
insert into T_SBD_BIZTYPEBILLENTITY (FID, FENTRYID, FSEQ, FBILLFORM)
values ('966651870204521472', '1031989288147167232', 2, 'im_mdc_omproorder');

delete from t_sbd_biztypebillentity where FENTRYID ='1031989288147167233';
insert into T_SBD_BIZTYPEBILLENTITY (FID, FENTRYID, FSEQ, FBILLFORM)
values ('966651870204521472', '1031989288147167233', 3, 'im_mdc_omfeedorder');


