生产订单清单
小于 1 分钟
代码示例
SELECT T0.[Status], T0.[DocNum] AS '生产单号', T0.[ItemCode], T0.[ProdName], T0.[PlannedQty]
, T0.[CmpltQty], T0.[StartDate], T0.[DueDate], T0.[CloseDate], T0.[Comments]
, T0.[SupplCode]
FROM OWOR T0
ORDER BY T0.[DocNum]
SELECT T0.[Status], T0.[DocNum] AS '生产单号', T0.[ItemCode], T0.[ProdName], T0.[PlannedQty]
, T0.[CmpltQty], T0.[StartDate], T0.[DueDate], T0.[CloseDate], T0.[Comments]
, T0.[SupplCode]
FROM OWOR T0
ORDER BY T0.[DocNum]