Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Marco Villarreal]

Hi Everyone,

I am trying to write a stored procedure in SQL server that pulls information from the [Change Log Entry] table so we can easily keep track of what changes have been made in NAV. The only problem is that I cannot find a table that includes the [Table Name] and [Field Name] for the corresponding columns [Table No_] and [Field No_] in the [Change Log Entry] table. 

Where can I find Table Name and Field Name? Is this information in the database?

I am working with NAV 2016.

Thank you for your help!

——————————
Marco Villarreal
Farmers Investment Co
Sahuarita AZ
——————————

[Lewis Rosenberg]

?Table 2000000041 – Field

You won’t see it in Object Designer but it is available if you try to create a page or report using it.

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare
Chalfont PA

NAVUG Board of Advisors, Programming
NAVUG Programming Committee
NAVUG Membership Committee
——————————
——————————————-

[Franz Kalchmair]

actually the virtual tables within nav wont help you.
can only be used within nav, in the nav dev. client.

table names: stored invirtual tables AllObj, AllObjWithCaption
fields: stored in virtual table Field
these virtual tables can then be used in pages, reports, etc. 

in your case you need access in sql. it’s quite different. so …
to get the tables names you can use table dbo.Object.

to get the field names in sql you can use the sql system tables, e.g.

select COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS
where TABLE_CATALOG = <databasename>
and TABLE_NAME = <tablename>
— and ORDINAL_POSITION = <field no.>

——————————
Franz Kalchmair
Microsoft MVP
Senior Consultant
Austria, Europe
——————————
——————————————-