# Classification Code Change Track and Associated GLaccount for Division

**URL:** <https://community.cdata.com/t/classification-code-change-track-and-associated-glaccount-for-division/1005>\
**Category:** CData Connect AI\
**Tags:** glschemecode, exact-online, question\
**Created:** [January 28, 2025, 9:13am UTC](https://community.cdata.com/t/classification-code-change-track-and-associated-glaccount-for-division/1005 "2025-01-28T09:13:14Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![muthuEOL](https://avatars.discourse-cdn.com/v4/letter/m/cc9497/32.png) [@muthuEOL](https://community.cdata.com/u/muthuEOL)\
**Post date:** [January 28, 2025, 9:13am UTC](https://community.cdata.com/t/classification-code-change-track-and-associated-glaccount-for-division/1005/1 "2025-01-28T09:13:15Z")

</div>

I am using CDATA Connect AI with a virtual SQL server to connect to Exact Online. I have two requirements related to data tracking and retrieval:

1. **Tracking Classification Code Changes:**  
I need to track any changes or modifications made to the Classification Codes in Exact Online. Specifically, I want to retrieve all rows where changes have occurred in the Classification Codes.

2. **Retrieving Division-Associated GL Account Codes:**  
I need to retrieve the GL Account Codes associated with each Division in Exact Online.

---

<div class="post-metadata">

**Author:** ![anonymous](https://avatars.discourse-cdn.com/v4/letter/a/8491ac/32.png) [@anonymous](https://community.cdata.com/u/anonymous)\
**Post date:** [January 31, 2025, 9:34pm UTC](https://community.cdata.com/t/classification-code-change-track-and-associated-glaccount-for-division/1005/2 "2025-01-31T21:34:51Z")

</div>

Hi Muthu!

Based on what you described, it sounds like you’re using the CData Connect AI&nbsp;tool. If that’s the case, then you should be able to use the built in query builder to query the data you’re looking for instead of specific SQL statements.

As for the data you’re looking for itself, you should be able to find the relevant GL Account Codes data on the GLAccounts table:&nbsp;[CData Cloud - CData Cloud](https://cdn.cdata.com/help/DYJ/cloud/default.htm#pg_table-glaccounts)

…and the Classification Codes should be available on the GLAccountClassificationMappings table:&nbsp;[CData Cloud - CData Cloud](https://cdn.cdata.com/help/DYJ/cloud/default.htm#pg_table-glaccounts)

The data model documentation covers everything that the tool has access to, so I’d highly recommend making use of it in regards to any questions as to what data is accessible.