库存转储明细查询

代码示例

SELECT T1.[DocNum] AS '单据编号', T1.[DocDate] AS '过账日期', T1.[TaxDate] AS '单据日期', T1.[Filler] AS '出库仓库', T1.[U_YWLX] AS '业务类型'
	, T1.[U_SCDDH] AS '生产订单号', T1.[U_SCPH] AS '生产批号', T1.[U_ZDR] AS '制单人', T1.[U_MDYFDJ] AS '每吨运费单价', T0.[ItemCode] AS '物料代码'
	, T0.[Dscription] AS '物料/服务描述', T0.[WhsCode] AS '仓库代码', T0.[Quantity] AS '数量', T0.[unitMsr] AS '单位', T0.[Price] AS '材料成本'
FROM [dbo].[WTR1] T0
	INNER JOIN [dbo].[OWTR] T1 ON T1.[DocEntry] = T0.[DocEntry]