Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The Company ID can be added to the Control Account from Control Table - Control Accounts.

SQL -

To 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.