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

UYA
UYA 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_Ontour
    Me_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
  • UYA
    UYA 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?


  • lubost
    lubost Member Posts: 633
    Create Page (form) with Table 2000000041 as a base table and run that page.
  • UYA
    UYA 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
  • UYA
    UYA 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?

Categories