SystemId, SystemCreatedBy, SystemCreatedOn etc. - SQL

eYeeYe Member Posts: 162
Has anyone found where the new system fields are actually stored in SQL?
Kind Regards,
Ewald Venter

Best Answer

  • eYeeYe Member Posts: 162
    Accepted Answer
    Looks like <= BC16 it was a join with "Integration Record" table
    Kind Regards,
    Ewald Venter

Answers

  • krikikriki Member, Moderator Posts: 8,956
    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]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
    NAV TechDays 2020: 19 & 20 November 2020, Antwerp (Belgium)
  • eYeeYe Member Posts: 162
    I only see $systemId :/
    dcpirxrnbt3b.png
    Kind Regards,
    Ewald Venter
  • irasoelbaksirasoelbaks Netherlands, theMember Posts: 80
    They can be found in the customer table for example. I used a BC17 database:

    h9x1r36p2qyr.png
  • benjasikbenjasik Member Posts: 7
    the CreatedBy and modifiedby are joins to which table - User?
  • irasoelbaksirasoelbaks Netherlands, theMember Posts: 80
    They are not joins. They are physical fields in SQL.
  • eYeeYe Member Posts: 162
    Accepted Answer
    Looks like <= BC16 it was a join with "Integration Record" table
    Kind Regards,
    Ewald Venter
Sign In or Register to comment.