SELECT T0."DocEntry",T0."DocNum" "生产订单号",T1."DocEntry" "销售订单号",case when T0."Status"='P' then '已计划' when T0."Status"='R' then '已批准' when T0."Status"='L' then '已结算' end "工单状态", T1."NumAtCard" "合同号", T0."ItemCode",
T2."U_EJFL", T2."U_SJFL", T2."U_Z20_SPEC", T2."U_CHXH"
, cast(T0."PlannedQty" as int) "计划数量" FROM OWOR T0
INNER JOIN ORDR T1 ON T0."OriginNum"=T1."DocNum"
INNER JOIN OITM t2 on t0."ItemCode"=t2."ItemCode"
where T0."Status"<>'C'
ORDER by T0."DocNum"
生产任务清单
最新推荐文章于 2024-08-18 22:05:18 发布