
DELETE FROM T_BAS_BILLTYPEPARAMETER WHERE fformid = 'pom_mftorder';
insert into T_BAS_BILLTYPEPARAMETER(FFORMID, FBILLTYPEID, FDATA)
select fbillformid as FFORMID, fid as FBILLTYPEID, '{"biztype":{"number":"401","masterid":738166303168232448,"_Type_":"bd_biztype","multilanguagetext":[{"_Type_":"locale","pkid":"0VJ=540O6TS8","name":"Standard Production","description":"","localeid":"en_US"},{"_Type_":"locale","pkid":"0=NG672WP1ON","name":"標準生產","description":"","localeid":"zh_TW"},{"_Type_":"locale","pkid":"0=NG672WP1OM","name":"标准生产","description":"","localeid":"zh_CN"}],"name":{"zh_TW":"標準生產","en_US":"Standard Production","GLang":"标准生产","zh_CN":"标准生产"},"id":738166303168232448},"_Type_":"im_billtypeparameter","biztype_id":738166303168232448}' as FDATA from T_BAS_BILLTYPE
where fbillformid ='pom_mftorder';

DELETE FROM T_BAS_BILLTYPEPARAMETER WHERE fformid = 'pom_xmftorder';
insert into T_BAS_BILLTYPEPARAMETER(FFORMID, FBILLTYPEID, FDATA)
select fbillformid as FFORMID, fid as FBILLTYPEID, '{"biztype":{"number":"401","masterid":738166303168232448,"_Type_":"bd_biztype","multilanguagetext":[{"_Type_":"locale","pkid":"0VJ=540O6TS8","name":"Standard Production","description":"","localeid":"en_US"},{"_Type_":"locale","pkid":"0=NG672WP1ON","name":"標準生產","description":"","localeid":"zh_TW"},{"_Type_":"locale","pkid":"0=NG672WP1OM","name":"标准生产","description":"","localeid":"zh_CN"}],"name":{"zh_TW":"標準生產","en_US":"Standard Production","GLang":"标准生产","zh_CN":"标准生产"},"id":738166303168232448},"_Type_":"im_billtypeparameter","biztype_id":738166303168232448}' as FDATA from T_BAS_BILLTYPE
where fbillformid ='pom_xmftorder';


DELETE FROM T_BAS_BILLTYPEPARAMETER WHERE fformid = 'pom_mftstock';
insert into T_BAS_BILLTYPEPARAMETER(FFORMID, FBILLTYPEID, FDATA)
select fbillformid as FFORMID, fid as FBILLTYPEID, '{"biztype":{"number":"401","masterid":738166303168232448,"_Type_":"bd_biztype","multilanguagetext":[{"_Type_":"locale","pkid":"0VJ=540O6TS8","name":"Standard Production","description":"","localeid":"en_US"},{"_Type_":"locale","pkid":"0=NG672WP1ON","name":"標準生產","description":"","localeid":"zh_TW"},{"_Type_":"locale","pkid":"0=NG672WP1OM","name":"标准生产","description":"","localeid":"zh_CN"}],"name":{"zh_TW":"標準生產","en_US":"Standard Production","GLang":"标准生产","zh_CN":"标准生产"},"id":738166303168232448},"_Type_":"im_billtypeparameter","biztype_id":738166303168232448}' as FDATA from T_BAS_BILLTYPE
where fbillformid ='pom_mftstock';

DELETE FROM T_BAS_BILLTYPEPARAMETER WHERE fformid = 'pom_mftorderreport';
insert into T_BAS_BILLTYPEPARAMETER(FFORMID, FBILLTYPEID, FDATA)
select fbillformid as FFORMID, fid as FBILLTYPEID, '{"biztype":{"number":"401","masterid":738166303168232448,"_Type_":"bd_biztype","multilanguagetext":[{"_Type_":"locale","pkid":"0VJ=540O6TS8","name":"Standard Production","description":"","localeid":"en_US"},{"_Type_":"locale","pkid":"0=NG672WP1ON","name":"標準生產","description":"","localeid":"zh_TW"},{"_Type_":"locale","pkid":"0=NG672WP1OM","name":"标准生产","description":"","localeid":"zh_CN"}],"name":{"zh_TW":"標準生產","en_US":"Standard Production","GLang":"标准生产","zh_CN":"标准生产"},"id":738166303168232448},"_Type_":"im_billtypeparameter","biztype_id":738166303168232448}' as FDATA from T_BAS_BILLTYPE
where fbillformid ='pom_mftorderreport';

DELETE FROM T_BAS_BILLTYPEPARAMETER WHERE fformid = 'sfc_manftech';
insert into T_BAS_BILLTYPEPARAMETER(FFORMID, FBILLTYPEID, FDATA)
select fbillformid as FFORMID, fid as FBILLTYPEID, '{"biztype":{"number":"401","masterid":738166303168232448,"_Type_":"bd_biztype","multilanguagetext":[{"_Type_":"locale","pkid":"0VJ=540O6TS8","name":"Standard Production","description":"","localeid":"en_US"},{"_Type_":"locale","pkid":"0=NG672WP1ON","name":"標準生產","description":"","localeid":"zh_TW"},{"_Type_":"locale","pkid":"0=NG672WP1OM","name":"标准生产","description":"","localeid":"zh_CN"}],"name":{"zh_TW":"標準生產","en_US":"Standard Production","GLang":"标准生产","zh_CN":"标准生产"},"id":738166303168232448},"_Type_":"im_billtypeparameter","biztype_id":738166303168232448}' as FDATA from T_BAS_BILLTYPE
where fbillformid ='sfc_manftech';

DELETE FROM T_BAS_BILLTYPEPARAMETER WHERE fformid = 'sfc_processreportbill';
insert into T_BAS_BILLTYPEPARAMETER(FFORMID, FBILLTYPEID, FDATA)
select fbillformid as FFORMID, fid as FBILLTYPEID, '{"biztype":{"number":"401","masterid":738166303168232448,"_Type_":"bd_biztype","multilanguagetext":[{"_Type_":"locale","pkid":"0VJ=540O6TS8","name":"Standard Production","description":"","localeid":"en_US"},{"_Type_":"locale","pkid":"0=NG672WP1ON","name":"標準生產","description":"","localeid":"zh_TW"},{"_Type_":"locale","pkid":"0=NG672WP1OM","name":"标准生产","description":"","localeid":"zh_CN"}],"name":{"zh_TW":"標準生產","en_US":"Standard Production","GLang":"标准生产","zh_CN":"标准生产"},"id":738166303168232448},"_Type_":"im_billtypeparameter","biztype_id":738166303168232448}' as FDATA from T_BAS_BILLTYPE
where fbillformid ='sfc_processreportbill';

DELETE FROM T_BAS_BILLTYPEPARAMETER WHERE fformid = 'sfc_reportresource_adjust';
insert into T_BAS_BILLTYPEPARAMETER(FFORMID, FBILLTYPEID, FDATA)
select fbillformid as FFORMID, fid as FBILLTYPEID, '{"biztype":{"number":"401","masterid":738166303168232448,"_Type_":"bd_biztype","multilanguagetext":[{"_Type_":"locale","pkid":"0VJ=540O6TS8","name":"Standard Production","description":"","localeid":"en_US"},{"_Type_":"locale","pkid":"0=NG672WP1ON","name":"標準生產","description":"","localeid":"zh_TW"},{"_Type_":"locale","pkid":"0=NG672WP1OM","name":"标准生产","description":"","localeid":"zh_CN"}],"name":{"zh_TW":"標準生產","en_US":"Standard Production","GLang":"标准生产","zh_CN":"标准生产"},"id":738166303168232448},"_Type_":"im_billtypeparameter","biztype_id":738166303168232448}' as FDATA from T_BAS_BILLTYPE
where fbillformid ='sfc_reportresource_adjust';


