【问题】: (FAQ)物料分类明细缺失物料基本分类记录
版本: 7.5
模块: 主数据
【答复】:
执行以下脚本批量补全物料分类明细数据 insert into T_BD_MaterialGroupDetial (FID, FMaterialID, FMaterialGroupStandardID, FMaterialGroupID) select newbosid('B9B5052C') as fid,m.fid as fmaterialid,'dR8lnQEPEADgAAWKwKgSxZeb4R8=' as groupstandard,m.fmaterialgroupid from T_BD_Material m left join T_BD_MaterialGroupDetial d on d.FMaterialID = m.fid and d.FMaterialGroupID = m.FMaterialGroupID where d.fid is null

执行以下脚本批量补全物料分类明细数据 insert into T_BD_MaterialGroupDetial (FID, FMaterialID, FMaterialGroupStandardID, FMaterialGroupID) select newbosid('B9B5052C') as fid,m.fid as fmaterialid,'dR8lnQEPEADgAAWKwKgSxZeb4R8=' as groupstandard,m.fmaterialgroupid from T_BD_Material m left join T_BD_MaterialGroupDetial d on d.FMaterialID = m.fid and d.FMaterialGroupID = m.FMaterialGroupID where d.fid is null