mibuso.com
Home› NAV Tips & Tricks

How to find table 2000000041 ("Field") in MS SQL?

UYAUYA Member Posts: 4
edited 2020-10-22 in NAV Tips & Tricks
People.
Tell me please
- where table 2000000041 ("Field") is stored in MS SQL.
- how to find table 2000000041 ("Field") in MS SQL.

Field numbers of the tables in view sys.columns do not match the actual field numbers in the tables.
Is there a way to get the actual field numbers?

Best Answer

Answers

  • Me_OntourMe_Ontour Member Posts: 11
    Hey UYA,

    Table 2000000041 is one off the virtual Tables in NAV.
    Therefore you cannot find a Reference in SQL

    The Normalfields you can find in the view sys.columns

    Cheers, Chris
  • UYAUYA Member Posts: 4
    Hi Me_Ontour.

    Many thanks.
    But the field numbers of the tables in view sys.columns do not match the actual field numbers in the tables.
    Is there a way to get the actual field numbers?


  • lubostlubost Member Posts: 628
    Create Page (form) with Table 2000000041 as a base table and run that page.
  • UYAUYA Member Posts: 4
    lubost wrote: »
    Create Page (form) with Table 2000000041 as a base table and run that page.

    Lubost.
    I need to get this information directly from SQL
  • UYAUYA Member Posts: 4
    Me_Ontour wrote: »
    Hey UYA,

    Table 2000000041 is one off the virtual Tables in NAV.
    Therefore you cannot find a Reference in SQL

    The Normalfields you can find in the view sys.columns

    Cheers, Chris

    Hi Me_Ontour.

    Many thanks.
    But the field numbers of the tables in view sys.columns do not match the actual field numbers in the tables.
    Is there a way to get the actual field numbers?
Sign In or Register to comment.