BOM卷算标准工时代码分享

栏目：云星空知识作者：金蝶来源：金蝶云社区发布：2024-09-16浏览：1

BOM卷算标准工时代码分享

select

(select isnull(sum(bom1activityqty),0.0) from t_YD_BomSelectOPRoute) as 标准加工总工时,

Bom0FMATERIALID as 父项物料内码,

Bom1FMATERIALID as 子项物料内码,

Bom0FMATERIALName as 父项物料名称,

Bom1FMATERIALName as 子项物料内码,

Bom0Leve as 父项BOM层级,

Bom1Leve as 子项BOM层级,

Bom1ACTIVITYQTY as 子项标准工时

from t_YD_BomSelectOPRoute

order by Bom0Leve , Bom0FMATERIALID,bom1leve

select dbo.func_getmaterialactivityqty(106379)

select * from T_BD_MATERIAL

本文2024-09-16 17:11:55发表“云星空知识”栏目。
本文链接：https://wenku.my7c.com/article/kingdee-k3cloud-14167.html

阅读排行