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

[Heather Walters]

Is there a SQL table that will give me a cross reference of NAV Table No, NAV Table Name? Also, NAV Field No, NAV Field Name?

For instance, when I query the change log table, I only see references to [Table No_] and [Field No_], but no readable names. Several tables have these references.

I can get the readable name in the client or look it up manually in the Dev Environment, but I would like to join it in SQL. Does anyone know a spot where I can find this information?

Thanks!

——————————
Heather Walters
Apothecary Products
Burnsville MN
——————————

[Rick Tweedle]

The Object table has the table info you need 
select * from [Object]

Type = 1 for table

The field level data I’m not sure where it comes from though (other than the virtual field table in the object designer)

——————————
Rick Tweedle
BC/NAV Dev Manager
Columbus Global
Temecula CA
——————————
——————————————-

[Heather Walters]

That is just what I was looking for! Can’t believe I didn’t find that myself. Thanks!

——————————
Heather Walters
Apothecary Products
Burnsville MN
——————————
——————————————-