Unknown Tables

headley27headley27 Member Posts: 188
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

  • ShenpenShenpen 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.
  • headley27headley27 Member Posts: 188
    So that's where they are stored.

    Thank you, that solves it.

    headley
  • krikikriki Member, Moderator Posts: 9,118
    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!


  • headley27headley27 Member Posts: 188
    Absolutely.

    Thanks again.
Sign In or Register to comment.