注意:当前为视频教学,文本教学可在视频下方查看!
复制粘贴以下内容到自定义字段覆盖:
ym00503=(select top 1 ym00503 from sdym005 where ym00507=bs01601),ym00603=(select top 1 ym00603 from sdym006 left join sdym005 on ym00604=ym00501 where ym00507=bs01601 order by ym00603 desc),ym00305=(select top 1 ym00305 from sdym003 where ym00302=bs01603),ym00308=(select top 1 ym00308 from sdym003 where ym00302=bs01603)
ym00305:BOM表创建日期
ym00308:BOM表审核日期
ym00503:生产计划开始日期
ym00603:下达加工单日期