U9C-SQL-调出单视图

U9C-SQL-调出单视图

SELECT
	doc.ID,
  doc.docno 单据号,
	doc.CreatedBy 创建人,
	CONVERT ( VARCHAR ( 10 ), doc.BusinessDate, 120 ) 送货日期 ,
  line.doclineno/10 序号,
	ite.code  物料编码,
	ite.Name 品名,
	ite.specs 物料规格,
	line.LotInfo_LotCode 批次号,
	line.StoreUOMQty 调入数量,
	uom.Name 单位,
	line.DescFlexSegments_PubDescSeg2 备注,
  wh.name 存储地点,
	bin.Bininfo_Name 调入库位,
	--obin.ID zl,
	okcw.BinInfo_Name 调出库位,
	pro.code 项目编码,
	pr.Name 项目名称
	
FROM
	InvDoc_TransferIn doc
	LEFT JOIN InvDoc_TransInLine line ON line.Transferin  = doc.id --库存调入单行
	LEFT JOIN CBO_ItemMaster ite ON line.ItemInfo_ItemID = ite.id
	LEFT JOIN CBO_Wh_trl Wh ON Wh.ID = line.TransinWh
	LEFT JOIN Base_UOM_Trl uom ON uom.ID= line.StoreUOM
	LEFT JOIN CBO_Customer cust ON cust.code= doc.DescFlexField_PrivateDescSeg6
	LEFT JOIN CBO_Customer_Trl cu ON cust.id= cu.id 
	LEFT JOIN InvDoc_TransInBin bin on bin.TransInLine=line.ID
	LEFT JOIN CBO_Project pro on pro.ID=line.Project
	LEFT JOIN CBO_Project_Trl pr on pr.ID=line.Project
	LEFT JOIN InvDoc_TransInSubLine obin on line.ID=obin.TransInLine
	LEFT JOIN InvDoc_TransInBin okcw on obin.ID=okcw.TransInSubLine
WHERE
	1 = 1 --and doc.DocNo='DR2024050014'