Does it matter? I've never seen this, nor has it been a problem. Could it be that data was dumped/loaded from company ID to another?

COMPANYID is used by inter company transactions.

Thanks for the information.
- No we did not dump and load from another company. - it loads random company ID's - in the same GL batch it can contain several different other company ID's.
- I have now checked at three different clients and multiple companies and found that they all have the same problem.
- I realise that it is causing no damage / problems, but am just curious as to why this is happening as it is not right. (they are either V2012 or V2014 clients and are not using Inter company transactions).
Thanks anyway.

I think it's a strange bug. I just picked a largish 2014 client at random, with 5.5 million records in GLJED.

There are four different values in COMPANYID, even thought they don't use intercompany, and haven't dump/loaded in 5 years. The first two values are xxxDAT (3.5M/63.9%) and blank (2.0M/35.6%), but the other two (10K/<.1%) are curious: xxxDEV and xxxTST, the development and test companies. There's no way that a DEV process should update DAT. In face, DAT is regularly copied to DEV and TST, so it should be the other way around.

Note that 100% of the DEV and TST transactions were generated by IC day-end.

I think it's a strange bug. I just picked a largish 2014 client at random, with 5.5 million records in GLJED.

There are four different values in COMPANYID, even thought they don't use intercompany, and haven't dump/loaded in 5 years. The first two values are xxxDAT (3.5M/63.9%) and blank (2.0M/35.6%), but the other two (10K/<.1%) are curious: xxxDEV and xxxTST, the development and test companies. There's no way that a DEV process should update DAT. In face, DAT is regularly copied to DEV and TST, so it should be the other way around.

Note that 100% of the DEV and TST transactions were generated by IC day-end.

We also found the same issue in our database, there are total 11.3 Million Records in GLJED.

CompanyID	Count
	7751433	???
ATST1D	3253470	Live
ATST2D	240147	Demo2
ATST3D	72273	Demo3
ATST1D	37839	???
AHINTD	150	Demo1
A	24	???

68% Records have Blank value in COMPANYID column

28% Records have Live Database name (ATST1D) in COMPANYID column

less than 3% Records have different Demo database name(ATST2D,ATST3D,AHINTD) in COMPANYID column

also there are .33 % records having value ATST1D

and

0.000211% records have value A

we don't have any database with name A and ATST1D

NOTE: we are not using intercompany and never load demo data in live.

correction:

the 0.33% have ATST1D(with Arrow-special character)

Well at least it is not just me that has this problem.
I have been trying to report this to Sage, but the ticket system is so slow it does not let me in at the moment.