="SELECT
T1.ActTranQty,
T1.AsOfDate,
T1.AssemblySeq,
T1.AssetNum,
T1.BurUnitCost,
T1.Calc_DocNum,
T1.Calc_InvoiceNum,
T5.ReceiptDate,
T1.Calc_LineNum, T1.Calc_PrintedBy, T1.Calc_SNList, T1.Calc_VendorAddrList,
T1.Calc_VendorID, T1.Calc_WareHouseDesc, T1.Company, T1.EmpID, T1.ExtCost, T1.InvAdjReason,
T1.JobNum2, T1.JobSeq2, T1.LotNum2, T1.OrderLine, T1.OrderNum, T1.PackLine, T1.PackNum, T1.PackSlip,
T1.PBInvNum, T1.PORelNum, T1.POUnitCost, T1.ProjProcessed, T1.SubUnitCost, T1.SysDate, T1.SysTime,
T1.TranDocTypeID, T1.TranNum, T1.TranQty, T1.WareHouse2, T1.AdditionNum, T1.AsOfSeq, T1.AssemblySeq2,
T1.BinNum, T1.BinNum2, T1.BinType, T1.Calc_Bin2Description, T1.Calc_BinDescription, T1.Calc_EntryPerson,
T1.Calc_InvoiceDate, T1.Calc_ReasonDescription, T1.Calc_WareHouse2Desc, T1.Calc_Weight, T1.DisposalNum,
T1.EntryPerson, T1.InvAdjSrc, T1.JobNum, T1.JobSeq, T1.LbrUnitCost, T1.LegalNumber, T1.LoanFlag, T1.LotNum,
T1.MscNum, T1.MtlUnitCost, T1.OrderRelNum, T1.PartDescription, T1.PartNum, T1.Plant, T1.Plant2, T1.POLine,
T1.PONum, T1.POReceiptQty, T1.PurPoint, T1.TranDate, T1.TranReference, T1.TranType, T1.UM, T1.WareHouseCode,
T1.RptLanguageID, T1.MtlBurUnitCost, T2.ShipName, T2.ShipAddress1, T2.ShipAddress2, T2.ShipCity,
T2.ShipState, T2.ShipZip, T2.ShipCountry, T3.BTOOrderNum, T3.BTOOrderLine, T2.CommentText, T4.JobNum as JobNum3
FROM PartTran_" + Parameters!TableGuid.Value + " T1
Left Outer Join POHeader_" + Parameters!TableGuid.Value + " T2
On T1.Company = T2.Company
Left Outer Join PODetail_" + Parameters!TableGuid.Value + " T3
on T1.POLine = T3.POLine and T1.PONum = T3.PONUM and T1.TranNum = T3.Calc_TranNum
Left Outer Join RcvHead_" + Parameters!TableGuid.Value + " T5
on T1.Company = T5.Company and T1.PONum = T5.PONum and T1.PackSlip = T5.PackSlip
left outer join
(
select
a1.JobNum,
a1.PONum,
a1.POLine
from erp10.erp.PORel a1
where a1.JobNum <> ‘’
group by
a1.JobNum,
a1.PONum,
a1.POLine
) T4
on T1.POLine = T4.POLine and T1.PONum = T4.PONUM"