Description |
Please see iNet for Specifications: [http://inet.irelyserver.com/display/ID/Vendor+Location+Export+Specification] .
Include the filter in the sql queries for exporting data for vendor and vendor locations. Export only if terminal is checked.
#1
!pastedImage_d170140_0.png|height=686,width=960!
#2 Export the vendor locations only if supply points are added for it.
INNER JOIN tblEMEntityLocation B ON A.intEntityId = B.intEntityId
LEFT JOIN tblSMShipVia C ON B.intShipViaId = C.intEntityId
INNER JOIN tblTRSupplyPoint D ON B.intEntityLocationId = D.intEntityLocationId
|