|
SELECT T1.LineNum,T0.CardCode, T0.CardName, T0.DocNum, T0.DocStatus, T0.TaxDate, T0.DocDueDate, T1.ItemCode, T1.Dscription, T1.Quantity, T1.PriceBefDi, T1.DiscPrcnt, T1.Price, T1.Currency,T1.OpenQty,T3.BaseRefFROM OINV T0INNER JOIN INV1 T1 ON T0.DocEntry = T1.DocEntry inner join ODLN T2 ON T1.BaseRef = T2.DocNum inner join DLN1 ... |
