...
transfer data to ERP-Iowa-Staging table. If you are not using conversion tables then use original tables; for instance use Glacct instead of GlAccountConversion, Vendors instead of VendorConversion in scripts below and adjust to appropriate columns in joins.
SELECT DISTINCT Vendor FROM [CMC-IOWA].dbo.APBegBalance a
LEFT JOIN ERP_Iowa_Staging.dbo.VendorConversion v
ON v.OldVendorCode = a.Vendor
WHERE v.VendorConversionID IS NULL
...