Vendor not appearing in AaaOrganization table

Vendor not appearing in AaaOrganization table

Hi Guys,
SD + version 9.1 build 9101.

I've been upgrading our Vendor List through Admin > Vendors and then running the following query to generate a report from this list.

SELECT name'Vendor Name',au.first_name 'Contact Person Name',aaapost.Door_No 'Door NO',aaapost.Street 'Street', aaapost.Location 'Location',aaapost.Landmark 'Landmark',aaapost.City 'City',aaapost.Postalcode 'PostalCode', aaapost.State 'State',aaapost.Country 'Country'
FROM VendorDefinition
left join aaaorganization sdorg on VendorDefinition.vendorid=sdorg.org_id
left join aaaorgpostaladdr apa on apa.org_id=sdorg.org_id
left join aaapostaladdress aaapost on apa.postaladdr_id=aaapost.postaladdr_id
left join aaaorgcontactuser aaoc on aaoc.org_id=sdorg.org_id
left join aaauser au on au.user_id=aaoc.user_id

The issue is when I'm creating a vendor it doesn't appear to be creating the entry in the aaaorganization table. Perhaps this is normal and I need to create it somewhere else first?

If so can you tell me where through the front end I need to do this.

Thanks kindly.

                  New to ADSelfService Plus?