SystemId, SystemCreatedBy, SystemCreatedOn etc. - SQL

eYe
eYe Member Posts: 169
in NAV Three Tier
Has anyone found where the new system fields are actually stored in SQL?
Kind Regards,
Ewald Venter

Best Answer

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

Answers

  • kriki
    kriki Member, Moderator Posts: 9,121
    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!

  • eYe
    eYe Member Posts: 169
    I only see $systemId :/
    dcpirxrnbt3b.png
    Kind Regards,
    Ewald Venter
  • irasoelbaks
    irasoelbaks Member Posts: 119
    They can be found in the customer table for example. I used a BC17 database:

    h9x1r36p2qyr.png
  • benjasik
    benjasik Member Posts: 9
    the CreatedBy and modifiedby are joins to which table - User?
  • irasoelbaks
    irasoelbaks Member Posts: 119
    They are not joins. They are physical fields in SQL.
  • eYe
    eYe Member Posts: 169
    Answer ✓
    Looks like <= BC16 it was a join with "Integration Record" table
    Kind Regards,
    Ewald Venter

Categories