MS Dynamics BC/NAV Pre-Mapped Data Warehouse Tables

Pre-mapped ETL+ tables available for Microsoft Dynamics BC / NAV (Business Central / Navision) as of 12/2022.

Subject to change without notice.

Source

Table

Source

Table

MS Dyn BC

Cust_ Ledger Entry

MS Dyn BC

Customer

MS Dyn BC

Customer Posting Group

MS Dyn BC

Default Dimension

MS Dyn BC

Detailed Cust_ Ledg_ Entry

MS Dyn BC

Dimension Set Entry

MS Dyn BC

G_L Account

MS Dyn BC

Inventory Posting Group

MS Dyn BC

Item

MS Dyn BC

Item Category

MS Dyn BC

Item Ledger Entry

MS Dyn BC

Location

MS Dyn BC

Payment Terms

MS Dyn BC

Product Group

MS Dyn BC

Purchase Header

MS Dyn BC

Purchase Line

MS Dyn BC

Sales Cr_Memo Header

MS Dyn BC

Sales Cr_Memo Line

MS Dyn BC

Sales Header

MS Dyn BC

Sales Header Archive

MS Dyn BC

Sales Invoice Header

MS Dyn BC

Sales Invoice Line

MS Dyn BC

Sales Line

MS Dyn BC

Sales Line Archive

MS Dyn BC

Sales Shipment Header

MS Dyn BC

Sales Shipment Line

MS Dyn BC

Salesperson_Purchaser

MS Dyn BC

Ship-to Address

MS Dyn BC

Territory

MS Dyn BC

Value Entry

MS Dyn BC

Vendor

Data Warehouse

4_Today

Data Warehouse

5_Date

Data Warehouse

6_DatePeriod

Data Warehouse

zEntity

Data Warehouse

_AR_Aging_Today

Data Warehouse

_Sales_Invoice

Data Warehouse

_Sales_Order

Data Warehouse

_Shipments

Notes:

  • Some of the above tables will only be deployed using customized SOWs or via services.

  • We only recommend extracting tables that are important for your reporting purposes.

Table Columns Example

DataSelf ETL+ templates include adjustments to table columns' data types and indexes. Click here to learn more.

The following is an example of BC table and its column names, indexes, and formatting in ETL+.

Delta Load Example

DataSelf ETL+ templates provide delta load configuration for popular large tables. This dramatically reduces the time to refresh the data warehouse. ETL+ Table Load Types.

The following is an example of Sales Invoice Line using the Replace feature. This example only updates the last 7-days worth of transactions.

Using table linking in the ETL SQL Statement, one can link header tables and use their fields for delta refreshes (ex. a date field from the Sales Invoice Header table).

Table Linking Example

The following is an example of how MS Dynamics BC _AR_Aging_Today tables are linked in DataSelf’s out-of-the-box templates. This linking applies the same way for Tableau data sources, Power BI data sets, Excel, and other reporting tools.

Â