生产任务清单

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"