I need to know when a sale was the result of an affiliate. I believe the data resides in the amember_payments table within the data field. I see a string containing AFF_ID in there but don't want to make wrong assumptions about how to use the data? Can someone explain this? Thanks.
When user will signup through affiliate link, aMember will set amember_members.aff_id field. So all following orders of that user will be assigned to affiliate as well.