济南用友财务软件,济南财务软件，济南用友www.jinanyonyou.com select SO_SOMain.cSOCode AS [订单号],SO_SOMain.dDate AS [订单日期],SO_SOMain.cCusName AS [客户名称],    SO_SOMain.cBusType AS [业务类型],Inventory .cInvCCode AS [存货分类编码],InventoryClass .cInvCName AS [存货分类名称],    SO_SODetails.cInvCode AS [存货编码],Inventory.cInvDefine1 AS [最小包装],Inventory.cInvDefine4 AS [产品单净重],Inventory.cInvDefine5 [每箱数量],Inventory.cInvDefine6 AS [每箱毛重],SO_SODetails.iQuantity AS [订单数量],ComputationUnit.cComUnitName AS [单位],CurrentStock.iQuantity AS [库存数量],    SO_SODetails.iFHQuantity AS [累计发货数量],SO_SODetails.fOutQuantity AS [出库数量],SO_SODetails.cSCloser AS [关闭人]    from SO_SOMain  INNER JOIN SO_SODetails  ON SO_SOMain.cSOCode =SO_SODetails.cSOCode     INNER JOIN Inventory  ON SO_SODetails.cInvCode =Inventory.cInvCode    INNER JOIN ComputationUnit  ON ComputationUnit.cComUnitCode = Inventory.cComUnitCode    LEFT JOIN InventoryClass   ON  Inventory.cInvCCode = InventoryClass .cInvCCode  INNER JOIN CurrentStock  ON SO_SODetails.cInvCode =CurrentStock.cInvCode where cwhcode='01'