K3 12.3表说明

[ICStockBill] AS [出入库单据表],

                      (FsupplyID)供应商ID  (FItemID)材料ID
[t_Supplier] AS [供应商表] ,
[t_ICItem] AS [物料表]   [t_ICItemCore] 

            ([物料表].[FModel]) AS [规格型号],    
            ([物料表].[FFullName]) AS [全名]

 

 以下是查询外购入库与物料与供应商.最后一次送货的单价表

SELECT 物料表.FFullName AS 全名, 物料表.FModel AS 规格型号, 出入库单据分录表.FPrice AS 单价, 供应商表.FName as 供应商 , MAX(出入库单据表.FDate) AS MaxDate
FROM t_ICItem AS 物料表 RIGHT OUTER JOIN
ICStockBill AS 出入库单据表 RIGHT OUTER JOIN
ICStockBillEntry AS 出入库单据分录表 ON 出入库单据表.FInterID = 出入库单据分录表.FInterID LEFT OUTER JOIN
t_Supplier AS 供应商表 ON 出入库单据表.FSupplyID = 供应商表.FItemID ON 物料表.FItemID = 出入库单据分录表.FItemID
GROUP BY 物料表.FFullName, 出入库单据分录表.FEntrySupply, 出入库单据分录表.FPrice, 物料表.FModel, 供应商表.FName
ORDER BY 全名, 规格型号

转载于:https://www.cnblogs.com/51yi/p/6761751.html