SystemId, SystemCreatedBy, SystemCreatedOn etc. - SQL

eYe

Has anyone found where the new system fields are actually stored in SQL?

eYe

Looks like <= BC16 it was a join with "Integration Record" table

kriki

They are just normal fields in the tables.
eg.:
SELECT TOP (1000) [timestamp]
,[Currency Code]
,[Starting Date]
,[Exchange Rate Amount]
,[Adjustment Exch_ Rate Amount]
,[Relational Currency Code]
,[Relational Exch_ Rate Amount]
,[Fix Exchange Rate Amount]
,[Relational Adjmt Exch Rate Amt]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM [tenant].[dbo].[CRONUS UK Ltd_$Currency Exchange Rate$xxxxxxxxxxxxxxxxxxxxxxxx]

eYe

I only see $systemId

irasoelbaks

They can be found in the customer table for example. I used a BC17 database:

benjasik

the CreatedBy and modifiedby are joins to which table - User?

irasoelbaks

They are not joins. They are physical fields in SQL.

eYe

Looks like <= BC16 it was a join with "Integration Record" table