MS Dynamics 365 NAV Data Warehouse Pre-mapped Tables

Home/MS Dynamics 365 NAV Data Warehouse Pre-mapped Tables

List of pre-mapped Microsoft Dynamics 365 NAV tables available as of 05/05/2018:

Company Information
Contact
Cust_ Ledger Entry
Customer
Default Dimension
Detailed Cust_ Ledg_ Entry
Dimension Value
G_L Account
Gen_ Business Posting Group
Gen_ Product Posting Group
General Ledger Setup
Inventory Posting Group
Item
Item Category
Item Ledger Entry
Location
Payment Terms
Posted Document Dimension
Product Group
Purch_ Inv_ Line
Purchase Header
Purchase Line
Reason Code
Resource
Sales Cr_Memo Header
Sales Cr_Memo Line
Sales Header
Sales Invoice Header
Sales Invoice Line
Sales Line
Salesperson_Purchaser
Ship-to Address
Territory
Transaction Type
Value Entry
Value Entry for Inventory OH Today
Vendor

Only the most popular fields for reporting purposes are pre-mapped out of the box. It’s simple to import additional fields from pre-mapped tables.