Unknown Tables

headley27
headley27 Member Posts: 188
edited 2006-02-24 in NAV/Navision Classic Client
We are using the SQL Server Database version of Navision (3.70.A).

There are a number of tables named as follows:

[Company Name]$x...$y...

x... represents a string of numbers 2 to 8 characters in length
y... represents a string of numbers 1 or 2 characters in length

What are these tables and what purpose do they serve?
Some contain data and some do not.

Thank you very much,

headley

Comments

  • Shenpen
    Shenpen Member Posts: 386
    These are auxiliary tables, they contain sums of values of (generally) Entry tables in order to calculate flowfields.
    Do It Yourself is they key. Standard code might work - your code surely works.
  • headley27
    headley27 Member Posts: 188
    So that's where they are stored.

    Thank you, that solves it.

    headley
  • kriki
    kriki Member, Moderator Posts: 9,121
    And like always:NEVER try to change something in those tables from SQL. Let Navision handly the tables and it's records!
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • headley27
    headley27 Member Posts: 188
    Absolutely.

    Thanks again.

Categories