...
1. To add the Company Id in SQL, you will need to go to the COMPDTL table and find the CMP_RECORDID for the Company. This is the company ID.
2. Then in the CONACCT table, add the CMP_RECORDID to the CON_COMPANYID field for the Control Account.
...