君泽-生产现存量查询济南用友软件

发布时间：2014-12-22 01:23 文章来源：未知被浏览次数：次

SELECT UFDATA_001_2009.DBO.CurrentStock.cWhCode AS [仓库编码],UFDATA_001_2009.DBO.Warehouse.cWhName AS [仓库名称],UFDATA_001_2009.DBO.Inventory .cInvCCode AS [存货分类编码],

UFDATA_001_2009.DBO.InventoryClass .cInvCName AS [存货分类名称],UFDATA_001_2009.DBO.CurrentStock.cInvCode AS [存货编码],

UFDATA_001_2009.DBO.Inventory.cInvStd AS [规格型号],UFDATA_001_2009.DBO.CurrentStock.iQuantity AS [结存数量],

UFDATA_001_2009.DBO.Inventory.cComUnitCode AS [主计量单位编码],UFDATA_001_2009.DBO.ComputationUnit.cComUnitName AS [单位],

UFDATA_001_2009.DBO.CurrentStock.fOutQuantity AS [待发货数量], UFDATA_001_2009.DBO.CurrentStock.fInQuantity AS [待入库数量],

UFDATA_001_2009.DBO.CurrentStock.fTransInQuantity AS [调拨在途数量],UFDATA_001_2009.DBO.CurrentStock.fTransOutQuantity AS [调拨待发数量],

UFDATA_001_2009.DBO.CurrentStock.fAvaQuantity AS [可用数量] from UFDATA_001_2009.DBO.CurrentStock

INNER JOIN UFDATA_001_2009.DBO.Warehouse ON UFDATA_001_2009.DBO.CurrentStock.cWhCode = UFDATA_001_2009.DBO.Warehouse.cWhCode

LEFT JOIN UFDATA_001_2009.DBO.Inventory ON UFDATA_001_2009.DBO.CurrentStock.cInvCode = UFDATA_001_2009.DBO.Inventory .cInvCode

LEFT JOIN UFDATA_001_2009.DBO.InventoryClass ON UFDATA_001_2009.DBO.Inventory.cInvCCode = UFDATA_001_2009.DBO.InventoryClass .cInvCCode

INNER JOIN UFDATA_001_2009.DBO.ComputationUnit ON UFDATA_001_2009.DBO.ComputationUnit.cComUnitCode = UFDATA_001_2009.DBO.Inventory.cComUnitCode

分享到：更多

◆ 相关内容

最新动态

最新动态

媒体报道

产品资讯

君泽-生产现存量查询济南用友软件

最新动态

最新动态

媒体报道

产品资讯

君泽-生产现存量查询 济南用友软件

君泽-生产现存量查询济南用友软件