SBO采购入库单

采购入库单

SELECT T0."DocEntry", T0."DocNum",T1."U_Z20_SNAC", T0."CardCode", T0."CardName", 
T1."ItemCode", T1."Dscription",T2."U_Z20_SPEC",T2."U_CHXH",T0."DocDate" "收货日期" , t6."BinCode" "库位",T1."Quantity" "已入库", T1."OpenQty" "未开票" FROM OPDN T0  
INNER JOIN PDN1 T1 ON T0."DocEntry" = T1."DocEntry" 
INNER JOIN OITM T2 ON T1."ItemCode"=T2."ItemCode"
inner join OILM T4 ON T1."ItemCode" = T4."ItemCode" and t4."DocEntry"=T1."DocEntry"
 and T1."ObjType"=T4."TransType" and t4."ActionType" ='1' and t4."DocLineNum" =T1."LineNum"
inner join obtl t5 on t5."MessageID" =t4."MessageID" 
inner join OBIN t6 on t6."AbsEntry"  =t5."BinAbs" 
WHERE T0."CANCELED" = 'N'  ORDER BY T1."DocEntry"