MS Dynamics BC/NAV Pre-Mapped Data Warehouse Tables
- Cortlandt _
Pre-mapped ETL+ tables available for Microsoft Dynamics BC / NAV (Business Central / Navision) as of 12/2022.
Subject to change without notice.
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.
Â