-- 单据类型 sys库
DELETE FROM T_BAS_BILLTYPE WHERE fid in('989893678929551360','989894784262873088','989895204624432128','988376671919052800','989633164802705408','989633630873884672');

insert into T_BAS_BILLTYPE (FID, FNUMBER, FBILLFORMID, FISDEFAULT, FBILLCODERULEID, FCREATORID, FCREATETIME, FMODIFIERID, FMODIFYTIME, FCONTROLPRINTCOUNT, FMAXPRINTCOUNT, FPRINTAFTERAUDIT, FDOCUMENTSTATUS, FDEFPRINTTEMPLATE, FISSYSPRESET, FLAYOUTSOLUTION, FDEFWNREPORTTEMPLATE, FSTATUS, FENABLE, FMASTERID, FPARASETTINGXML, FBILLINITSETTING)
values ('989893678929551360', 'im_mdc_opmproorder_BT_S', 'im_mdc_opmproorder', '1', ' ', '1', {ts'2020-09-25 10:34:02'}, '1', {ts'2020-09-25 10:34:02'}, '0', '1', '1', '0', ' ', '0', '12J9/90TTPD4', null, 'C', '1', '989893678929551360', null, ' ');

insert into T_BAS_BILLTYPE (FID, FNUMBER, FBILLFORMID, FISDEFAULT, FBILLCODERULEID, FCREATORID, FCREATETIME, FMODIFIERID, FMODIFYTIME, FCONTROLPRINTCOUNT, FMAXPRINTCOUNT, FPRINTAFTERAUDIT, FDOCUMENTSTATUS, FDEFPRINTTEMPLATE, FISSYSPRESET, FLAYOUTSOLUTION, FDEFWNREPORTTEMPLATE, FSTATUS, FENABLE, FMASTERID, FPARASETTINGXML, FBILLINITSETTING)
values ('989894784262873088', 'im_mdc_opmreturnorder_BT_S', 'im_mdc_opmreturnorder', '1', ' ', '1', {ts'2020-09-25 10:34:02'}, '1', {ts'2020-09-25 10:34:02'}, '0', '1', '1', '0', ' ', '0', '12J9NA+/=COB', null, 'C', '1', '989894784262873088', null, ' ');

insert into T_BAS_BILLTYPE (FID, FNUMBER, FBILLFORMID, FISDEFAULT, FBILLCODERULEID, FCREATORID, FCREATETIME, FMODIFIERID, FMODIFYTIME, FCONTROLPRINTCOUNT, FMAXPRINTCOUNT, FPRINTAFTERAUDIT, FDOCUMENTSTATUS, FDEFPRINTTEMPLATE, FISSYSPRESET, FLAYOUTSOLUTION, FDEFWNREPORTTEMPLATE, FSTATUS, FENABLE, FMASTERID, FPARASETTINGXML, FBILLINITSETTING)
values ('989895204624432128', 'im_mdc_opmfeedorder_BT_S', 'im_mdc_opmfeedorder', '1', ' ', '1', {ts'2020-09-25 10:34:02'}, '1', {ts'2020-09-25 10:34:02'}, '0', '1', '1', '0', ' ', '0', '12J9S8HKV1+O', null, 'C', '1', '989895204624432128', null, ' ');

insert into T_BAS_BILLTYPE (FID, FNUMBER, FBILLFORMID, FISDEFAULT, FBILLCODERULEID, FCREATORID, FCREATETIME, FMODIFIERID, FMODIFYTIME, FCONTROLPRINTCOUNT, FMAXPRINTCOUNT, FPRINTAFTERAUDIT, FDOCUMENTSTATUS, FDEFPRINTTEMPLATE, FISSYSPRESET, FLAYOUTSOLUTION, FDEFWNREPORTTEMPLATE, FSTATUS, FENABLE, FMASTERID, FPARASETTINGXML, FBILLINITSETTING)
values ('988376671919052800', 'im_mdc_omproorder_BT_S', 'im_mdc_omproorder', '1', ' ', '1', {ts'2020-09-25 10:34:02'}, '1', {ts'2020-09-25 10:34:02'}, '0', '1', '1', '0', ' ', '0', '12CVY2NQ/PKB', null, 'C', '1', '988376671919052800', null, ' ');

insert into T_BAS_BILLTYPE (FID, FNUMBER, FBILLFORMID, FISDEFAULT, FBILLCODERULEID, FCREATORID, FCREATETIME, FMODIFIERID, FMODIFYTIME, FCONTROLPRINTCOUNT, FMAXPRINTCOUNT, FPRINTAFTERAUDIT, FDOCUMENTSTATUS, FDEFPRINTTEMPLATE, FISSYSPRESET, FLAYOUTSOLUTION, FDEFWNREPORTTEMPLATE, FSTATUS, FENABLE, FMASTERID, FPARASETTINGXML, FBILLINITSETTING)
values ('989633164802705408', 'im_mdc_omreturnorder_BT_S', 'im_mdc_omreturnorder', '1', ' ', '1', {ts'2020-09-25 10:34:02'}, '1', {ts'2020-09-25 10:34:02'}, '0', '1', '1', '0', ' ', '0', '12D7+MWJ0U/2', null, 'C', '1', '989633164802705408', null, ' ');

insert into T_BAS_BILLTYPE (FID, FNUMBER, FBILLFORMID, FISDEFAULT, FBILLCODERULEID, FCREATORID, FCREATETIME, FMODIFIERID, FMODIFYTIME, FCONTROLPRINTCOUNT, FMAXPRINTCOUNT, FPRINTAFTERAUDIT, FDOCUMENTSTATUS, FDEFPRINTTEMPLATE, FISSYSPRESET, FLAYOUTSOLUTION, FDEFWNREPORTTEMPLATE, FSTATUS, FENABLE, FMASTERID, FPARASETTINGXML, FBILLINITSETTING)
values ('989633630873884672', 'im_mdc_omfeedorder_BT_S', 'im_mdc_omfeedorder', '1', ' ', '1', {ts'2020-09-25 10:34:02'}, '1', {ts'2020-09-25 10:34:02'}, '0', '1', '1', '0', ' ', '0', '12J4M6/JN3K5', null, 'C', '1', '989633630873884672', null, ' ');


delete from T_BAS_BILLTYPE_l where fid in('989893678929551360','989894784262873088','989895204624432128','988376671919052800','989633164802705408','989633630873884672');
insert into T_BAS_BILLTYPE_l (FPKID, FID, FLOCALEID, FNAME, FDESCRIPTION)
values ('12D6XWMS6+OA', '988376671919052800', 'zh_CN', '委外领料单', ' ');

insert into T_BAS_BILLTYPE_l (FPKID, FID, FLOCALEID, FNAME, FDESCRIPTION)
values ('12D6XWMS6+OB', '988376671919052800', 'zh_TW', '委外領料單', ' ');

insert into T_BAS_BILLTYPE_l (FPKID, FID, FLOCALEID, FNAME, FDESCRIPTION)
values ('12J7OY9TXEG1', '989633164802705408', 'zh_CN', '委外退料单', ' ');

insert into T_BAS_BILLTYPE_l (FPKID, FID, FLOCALEID, FNAME, FDESCRIPTION)
values ('12J7OY9TXEG2', '989633164802705408', 'zh_TW', '委外退料單', ' ');

insert into T_BAS_BILLTYPE_l (FPKID, FID, FLOCALEID, FNAME, FDESCRIPTION)
values ('12J7SAQ88FO2', '989633630873884672', 'zh_CN', '委外补料单', ' ');

insert into T_BAS_BILLTYPE_l (FPKID, FID, FLOCALEID, FNAME, FDESCRIPTION)
values ('12J7SAQ88FO3', '989633630873884672', 'zh_TW', '委外補料單', ' ');

insert into T_BAS_BILLTYPE_l (FPKID, FID, FLOCALEID, FNAME, FDESCRIPTION)
values ('12KGC=D7G2RN', '989893678929551360', 'zh_CN', '工序委外领料单', ' ');

insert into T_BAS_BILLTYPE_l (FPKID, FID, FLOCALEID, FNAME, FDESCRIPTION)
values ('12KGC=D7G2RO', '989893678929551360', 'zh_TW', '工序委外領料單', ' ');

insert into T_BAS_BILLTYPE_l (FPKID, FID, FLOCALEID, FNAME, FDESCRIPTION)
values ('12KGKBI+RZ=Y', '989894784262873088', 'zh_CN', '工序委外退料单', ' ');

insert into T_BAS_BILLTYPE_l (FPKID, FID, FLOCALEID, FNAME, FDESCRIPTION)
values ('12KGKBI+RZ=Z', '989894784262873088', 'zh_TW', '工序委外退料單', ' ');

insert into T_BAS_BILLTYPE_l (FPKID, FID, FLOCALEID, FNAME, FDESCRIPTION)
values ('12KGNE+5DV7H', '989895204624432128', 'zh_CN', '工序委外补料单', ' ');

insert into T_BAS_BILLTYPE_l (FPKID, FID, FLOCALEID, FNAME, FDESCRIPTION)
values ('12KGNE+5DV7I', '989895204624432128', 'zh_TW', '工序委外補料單', ' ');

-- 分录参数
delete from  T_BAS_BILLTYPEPARAMETER where FBILLTYPEID in('989893678929551360','989894784262873088','989895204624432128','988376671919052800','989633164802705408','989633630873884672');
insert into T_BAS_BILLTYPEPARAMETER (FFORMID, FBILLTYPEID, FDATA)
values ('im_mdc_omproorder', '988376671919052800', '{"biztype":{"number":"4011","masterid":966651870204521472,"_Type_":"bd_biztype","multilanguagetext":[{"_Type_":"locale","pkid":"1/Q3QMIUP=+F","name":"普通委外","description":"普通委外","localeid":"zh_CN"},{"_Type_":"locale","pkid":"1/Q3QMIUP=+G","name":"普通委外","description":"普通委外","localeid":"zh_TW"}],"name":{"zh_TW":"普通委外","zh_CN":"普通委外"},"id":966651870204521472},"_Type_":"im_billtypeparameter","biztype_id":966651870204521472}');

insert into T_BAS_BILLTYPEPARAMETER (FFORMID, FBILLTYPEID, FDATA)
values ('im_mdc_omreturnorder', '989633164802705408', '{"biztype":{"number":"4051","masterid":990500657985463296,"_Type_":"bd_biztype","multilanguagetext":[{"_Type_":"locale","pkid":"12NCSB6CO+CR","name":"普通委外退货","description":"","localeid":"zh_CN"},{"_Type_":"locale","pkid":"12NCSB6CO+CS","name":"普通委外退貨","description":"","localeid":"zh_TW"}],"name":{"zh_TW":"普通委外退貨","zh_CN":"普通委外退货"},"id":990500657985463296},"_Type_":"im_billtypeparameter","biztype_id":990500657985463296}');

insert into T_BAS_BILLTYPEPARAMETER (FFORMID, FBILLTYPEID, FDATA)
values ('im_mdc_omfeedorder', '989633630873884672', '{"biztype":{"number":"4011","masterid":966651870204521472,"_Type_":"bd_biztype","multilanguagetext":[{"_Type_":"locale","pkid":"1/Q3QMIUP=+F","name":"普通委外","description":"普通委外","localeid":"zh_CN"},{"_Type_":"locale","pkid":"1/Q3QMIUP=+G","name":"普通委外","description":"普通委外","localeid":"zh_TW"}],"name":{"zh_TW":"普通委外","zh_CN":"普通委外"},"id":966651870204521472},"_Type_":"im_billtypeparameter","biztype_id":966651870204521472}');

insert into T_BAS_BILLTYPEPARAMETER (FFORMID, FBILLTYPEID, FDATA)
values ('im_mdc_opmproorder', '989893678929551360', '{"biztype":{"number":"4031","masterid":989851541752212480,"_Type_":"bd_biztype","multilanguagetext":[{"_Type_":"locale","pkid":"12K9H8AS1IH3","name":"工序委外","description":"","localeid":"zh_CN"},{"_Type_":"locale","pkid":"12K9H8AS1IH4","name":"工序委外","description":"","localeid":"zh_TW"}],"name":{"zh_TW":"工序委外","zh_CN":"工序委外"},"id":989851541752212480},"_Type_":"im_billtypeparameter","biztype_id":989851541752212480}');

insert into T_BAS_BILLTYPEPARAMETER (FFORMID, FBILLTYPEID, FDATA)
values ('im_mdc_opmreturnorder', '989894784262873088', '{"biztype":{"number":"4041","masterid":989852229525793792,"_Type_":"bd_biztype","multilanguagetext":[{"_Type_":"locale","pkid":"12K9M8SIF65Q","name":"工序委外退回","description":"","localeid":"zh_CN"},{"_Type_":"locale","pkid":"12K9M8SIF65R","name":"工序委外退回","description":"","localeid":"zh_TW"}],"name":{"zh_TW":"工序委外退回","zh_CN":"工序委外退回"},"id":989852229525793792},"_Type_":"im_billtypeparameter","biztype_id":989852229525793792}');

insert into T_BAS_BILLTYPEPARAMETER (FFORMID, FBILLTYPEID, FDATA)
values ('im_mdc_opmfeedorder', '989895204624432128', '{"biztype":{"number":"4031","masterid":989851541752212480,"_Type_":"bd_biztype","multilanguagetext":[{"_Type_":"locale","pkid":"12K9H8AS1IH3","name":"工序委外","description":"","localeid":"zh_CN"},{"_Type_":"locale","pkid":"12K9H8AS1IH4","name":"工序委外","description":"","localeid":"zh_TW"}],"name":{"zh_TW":"工序委外","zh_CN":"工序委外"},"id":989851541752212480},"_Type_":"im_billtypeparameter","biztype_id":989851541752212480}');
