How to Join "Ledger Entry Dimension" table and "Value Entry" table

Business Central/NAV User Forum
1

I would like to obtain data from these two NAV2009 tables

Ledger Entry Dimension and Value Entry

Which field can be used to join these two tables?

Also, is there documentation available which illustrates the relationships between NAV 2009 tables.

Thanks,

Brad

2

Item Ledger Entry No. is the field on Value Entry table which reflects the relationship between the two.

There is no documentation available on table relationship.

3

Value Entry is considered a “Leder Entry” as far as Dimensions go. The field names in the Ledger Entry Dimension table are pretty self explanatory, though. There’s a Table Number, an Entry Number, a Dimension Code, and a Dimension Value. You’ll use the first two as the link between the tables.

4

Matt,

Thanks for the help.

In the “Value Entry” table I see two fields…

“Entry No” and “Item Ledger Entry No”

I am confused as to which of these I should use to link to the “Ledger Entry Dimension” table.

Thanks,

Brad

5

You should use the Entry No. That is the primary key of the Value Entry table. Value Entries have a one to many relationship with Item Ledger Entries. If you can, design the Ledger Entry Dimension table. Look at the table relationship for the Entry No. field. You’ll find all of the relationships.

6

Matt,

Thanks for the info.

I really appreciate your assistance.

Sincerely,

Brad Marks