hasokeric
8/20/2017 - 9:47 AM

BarTender Receiving Label Custom SQL E10.1

BarTender Receiving Label Custom SQL E10.1

SELECT "RcvDtl"."PackSlip", "RcvDtl"."PartNum", "RcvDtl"."BinNum", "RcvDtl"."IUM", "RcvDtl"."PONum", "RcvDtl"."VenPartNum", "RcvDtl"."LotNum", "RcvDtl"."Number01", "RcvDtl"."Number02", "RcvDtl"."ShortChar02", "RcvDtl"."InspectionPending", "RcvDtl"."InspectedDate", "RcvDtl"."InspectedBy", "RcvDtl"."InspectionReq", "Vendor"."Name", "PartTran"."TranNum" FROM "RcvDtl" , "Vendor" , "PartTran" WHERE "RcvDtl"."VendorNum" = "Vendor"."VendorNum" AND "RcvDtl"."PONum" = "PartTran"."PONum" AND ("RcvDtl"."PONum" = N'?PONum' AND ("RcvDtl"."Character09" IS NOT NULL AND "RcvDtl"."Character09" <> '""') AND ("PartTran"."PONum" = "RcvDtl"."PONum" AND "PartTran"."PackSlip" = "RcvDtl"."PackSlip"))