Navision table schema

foolosofofoolosofo Member Posts: 73
Hello,

I'm working with Navision since 1 year ago. Nowadays, I've realised that it was very useful to have a Navision table schema of most important tables of Navision.

I know it's difficult to view a complete schema, but I'm interested just in main tables, main processes, etc...

Do you know some place where I can find this?

Thank you very much.

Comments

  • Miklos_HollenderMiklos_Hollender Member Posts: 1,598
    There isn't such a thing but after a while you will realize that naming conventions make this unnecessary.

    F.e. a non-standard example - if there would be a car renting solution there would be a master table called Car. It's primary key would be No. and it would have a Description field, maybe a Description 2 as well. It's movements were called Car Ledger Entry or Car Entry (Entry is for sure) and those entries were created by a Car Journal Line. Both would reference the car as Car No., would have Posting Date, Document No., Description, Quantity, the renting fee would be called Unit Something (f.e. Unit Fee) for one car and Something Amount (f.e. Fee Amount) for the whole line. If there were multiple lines in one transaction you would have a document like Car Renting Header and Car Renting Line and probably posted versions of the table as well. The header would either have No. or Document Type, No. as primary key and the line would reference it as Document Type, Document No., Line No. And so on.
  • idiotidiot Member Posts: 651
    I'm also interested in this, especially the links & relationships between forms & codeunits (or reports)
    eg onInsert -> codeunit to check permission....
    -> codeunit to check configuration

    Debug takes too long & cycles through too many places...
    NAV - Norton Anti Virus

    ERP Consultant (not just Navision) & Navision challenger
  • papvrepapvre Member Posts: 24
    In NDT you see relationships between objects
  • foolosofofoolosofo Member Posts: 73
    Hi again,

    I've seen that in http://www.navitools.com there are a lot of (non-free) resources. It's the kind of thing I want, but, if it's possible, free.
Sign In or Register to comment.