注意:當(dāng)前為視頻教學(xué),文本教學(xué)可在視頻下方查看!
復(fù)制粘貼以下內(nèi)容到自定義字段覆蓋:
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表創(chuàng)建日期
ym00308:BOM表審核日期
ym00503:生產(chǎn)計(jì)劃開(kāi)始日期
ym00603:下達(dá)加工單日期