Send Microsoft Dynamics 365 Business Central Data Anywhere

Microsoft Dynamics 365 Business Central

Source

Use Dataddo's Microsoft Dynamics 365 Business Central connector to explore any data available via the official API of Microsoft Dynamics 365 Business Central. Access hundreds of metrics and attributes, from basic to advanced. Build and blend custom datasets directly in Dataddo, then send them anywhere.

Create Integration

DATA FIELDS

Explore Data You Can Extract from Microsoft Dynamics 365 Business Central

Data Category

All Categories (Optional)

All Attributes (347)
Contacts (10)
Contacts (21)
Country/Region (5)
Currencies (7)
Currency Exchange Rates (7)
Customers (24)
Dimension Set Lines (11)
Dimension Values (5)
Dimensions (4)
General Ledger Entry (11)
General Ledger Setup (17)
General Product Posting Groups (6)
Inventory Posting Groups (3)
Item Categories (5)
Items (21)
Items Variants (5)
Opportunities (18)
Payment Terms (8)
Sales Invoices (51)
Sales Orders (50)
Sales Quotes (49)
Shipment Methods (4)
Tax Groups (5)

Need fields you don't see?

Let us know and we'll add them to the connector. Just send a request here..

Available Attributes (347)

Search data fields (Optional)

Attribute
id ID string
number Number string
displayName Display Name string
category Category string
subCategory Sub Category string
blocked Blocked integer
accountType Account Type string
directPosting Direct Posting integer
netChange Net Change float
lastModifiedDateTime Last Modified Date Time datetime
id ID string
number Number string
type Type string
displayName sensitive Display Name string
companyNumber Company Number string
companyName Company Name string
businessRelation Business Relation string
addressLine1 sensitive Address Line 1 string
addressLine2 sensitive Address Line 2 string
city City string
state State string
country Country string
postalCode sensitive Postal Code string
phoneNumber sensitive Phone Number string
mobilePhoneNumber sensitive Mobile Phone Number string
email sensitive Email string
website Website string
searchName Search Name string
privacyBlocked Privacy Blocked integer
lastInteractionDate Last Interaction Date datetime
lastModifiedDateTime Last Modified Date Time datetime
id ID string
code Code string
displayName Display Name string
addressFormat Address Format string
lastModifiedDateTime Last Modified Date Time datetime
id ID string
code Code string
displayName Display Name string
symbol Symbol string
amountDecimalPlaces Amount Decimal Places string
amountRoundingPrecision Amount Rounding Precision float
lastModifiedDateTime Last Modified Date Time datetime
id ID string
currencyCode Currency Code string
startingDate Starting Date datetime
exchangeRateAmount Exchange Rate Amount float
relationalCurrencyCode Relational Currency Code string
relationalExchangeRateAmount Relational Exchange Rate Amount float
lastModifiedDateTime Last Modified Date Time datetime
id ID string
number Number string
displayName sensitive Display Name string
type Type string
addressLine1 sensitive Address Line 1 string
addressLine2 sensitive Address Line 2 string
city City string
state State string
country Country string
postalCode sensitive Postal Code string
phoneNumber sensitive Phone Number string
email sensitive Email string
website Website string
taxLiable Tax Liable integer
taxAreaId Tax Area ID string
taxAreaDisplayName Tax Area Display Name string
taxRegistrationNumber Tax Registration Number string
currencyId Currency ID string
currencyCode Currency Code string
paymentTermsId Payment Terms ID string
shipmentMethodId Shipment Method ID string
paymentMethodId Payment Method ID string
blocked Blocked string
lastModifiedDateTime Last Modified Date Time datetime
ledgerEntryId ID string
fieldId ID string
fieldCode code string
fieldConsolidationCode Consolidation Code string
fieldParentId Parent ID string
fieldParentType Parent Type string
fieldDisplayName Display Name string
valueId Value Id string
valueCode Value Code string
valueConsolidationCode Value Consolidation Code string
valueDisplayName Value Display Name string
id ID string
code Code string
dimensionId Dimension ID string
displayName Display Name string
lastModifiedDateTime Last Modified Date Time datetime
id ID string
code Code string
displayName Display Name string
lastModifiedDateTime Last Modified Date Time datetime
id ID string
entryNumber Entry Number integer
postingDate Posting Date datetime
documentNumber Document Number string
documentType Document Type string
accountId Account ID string
accountNumber Account Number string
description Description string
debitAmount Debit Amount float
creditAmount Credit Amount float
lastModifiedDateTime Last Modified Date Time datetime
etag etag string
additionalReportingCurrency additionalReportingCurrency string
allowPostingFrom allowPostingFrom datetime
allowPostingTo allowPostingTo datetime
allowQueryFromConsolidation allowQueryFromConsolidation boolean
id id string
lastModifiedDateTime lastModifiedDateTime datetime
localCurrencyCode localCurrencyCode string
localCurrencySymbol localCurrencySymbol string
shortcutDimension1Code shortcutDimension1Code string
shortcutDimension2Code shortcutDimension2Code string
shortcutDimension3Code shortcutDimension3Code string
shortcutDimension4Code shortcutDimension4Code string
shortcutDimension5Code shortcutDimension5Code string
shortcutDimension6Code shortcutDimension6Code string
shortcutDimension7Code shortcutDimension7Code string
shortcutDimension8Code shortcutDimension8Code string
id ID string
code Code string
description Description string
defaultVATProductPostingGroup Default VAT Product Posting Group string
autoInsertDefault Auto Insert Default integer
lastModifiedDateTime Last Modified Date Time datetime
id ID string
code Code string
description Description string
id ID string
code Code string
displayName Display Name string
symbol Symbol string
lastModifiedDateTime Last Modified Date Time datetime
id ID string
number Number string
displayName Display Name string
type Type string
itemCategoryId Item Category ID string
itemCategoryCode Item Category Code string
blocked Blocked integer
gtin GTIN string
inventory Inventory integer
unitPrice Unit Price float
priceIncludesTax Price Includes Tax integer
unitCost Unit Cost float
taxGroupId Tax Group ID string
taxGroupCode Tax Group Code string
baseUnitOfMeasureId Base Unit of Measure ID string
baseUnitOfMeasureCode Base Unit of Measure Code string
generalProductPostingGroupId General Product Posting Group ID string
generalProductPostingGroupCode General Product Posting Group Code string
inventoryPostingGroupId Inventory Posting Group ID string
inventoryPostingGroupCode Inventory Posting Group Code string
lastModifiedDateTime Last Modified Date Time datetime
id ID string
itemId Item ID string
itemNumber Item Number string
code Code string
description Description string
id ID string
number Number string
contactNumber Contact Number string
contactName sensitive Contact Name string
contactCompanyName Contact Company Name string
salespersonCode Salesperson Code string
description Description string
status Status string
closed Closed integer
creationDate Creation Date datetime
dateClosed Date Closed datetime
calculatedCurrentValue Calculated Current Value float
chancesOfSuccessPrc Chances of Success (%) float
completedPrc Completed (%) float
estimatedClosingDate Estimated Closing Date datetime
estimatedValue Estimated Value integer
systemCreatedAt System Created At datetime
lastModifiedDateTime Last Modified DateTime datetime
id ID string
code Code string
displayName Display Name string
dueDateCalculation Due Date Calculation string
discountDateCalculation Discount Date Calculation string
discountPercent DiscountPercent float
calculateDiscountOnCreditMemos Calculate Discount On Credit Memos integer
lastModifiedDateTime Last Modified Date Time datetime
id ID string
number Number string
externalDocumentNumber External Document Number string
invoiceDate Invoice Date datetime
postingDate Posting Date datetime
dueDate Due Date datetime
customerPurchaseOrderReference Customer Purchase Order Reference string
customerId Customer ID string
customerNumber Customer Number string
customerName sensitive Customer Name string
billToName sensitive Bill To Name string
billToCustomerId Bill To Customer ID string
billToCustomerNumber Bill To Customer Number string
shipToName sensitive Ship To Name string
shipToContact sensitive Ship To Contact string
sellToAddressLine1 sensitive Sell To Address Line 1 string
sellToAddressLine2 sensitive Sell To Address Line 2 string
sellToCity Sell To City string
sellToCountry Sell To Country string
sellToState Sell To State string
sellToPostCode sensitive Sell To Post Code string
billToAddressLine1 sensitive Bill To Address Line 1 string
billToAddressLine2 sensitive Bill To Address Line 2 string
billToCity Bill To City string
billToCountry Bill To Country string
billToState Bill To State string
billToPostCode sensitive Bill To Post Code string
shipToAddressLine1 sensitive Ship To Address Line 1 string
shipToAddressLine2 sensitive Ship To Address Line 2 string
shipToCity Ship To City string
shipToCountry Ship To Country string
shipToState Ship To State string
shipToPostCode sensitive Ship To Post Code string
currencyId Currency ID string
currencyCode Currency Code string
orderId Order ID string
orderNumber Order Number string
paymentTermsId Payment Terms ID string
shipmentMethodId Shipment Method ID string
salesperson sensitive Salesperson string
pricesIncludeTax Prices Include Tax integer
remainingAmount Remaining Amount float
discountAmount Discount Amount float
discountAppliedBeforeTax Discount Applied Before Tax integer
totalAmountExcludingTax Total Amount Excluding Tax float
totalTaxAmount Total Tax Amount float
totalAmountIncludingTax Total Amount Including Tax float
status Status string
lastModifiedDateTime Last Modified DateTime datetime
phoneNumber sensitive Phone Number string
email sensitive Email string
id ID string
number Number string
externalDocumentNumber External Document Number string
orderDate Order Date datetime
postingDate Posting Date datetime
customerId Customer ID string
customerNumber Customer Number string
customerName sensitive Customer Name string
billToName sensitive Bill To Name string
billToCustomerId Bill To Customer ID string
billToCustomerNumber Bill To Customer Number string
shipToName sensitive Ship To Name string
shipToContact sensitive Ship To Contact string
sellToAddressLine1 sensitive Sell To Address Line 1 string
sellToAddressLine2 sensitive Sell To Address Line 2 string
sellToCity Sell To City string
sellToCountry Sell To Country string
sellToState Sell To State string
sellToPostCode sensitive Sell To Post Code string
billToAddressLine1 sensitive Bill To Address Line 1 string
billToAddressLine2 sensitive Bill To Address Line 2 string
billToCity Bill To City string
billToCountry Bill To Country string
billToState BillToState string
billToPostCode sensitive Bill To Post Code string
shipToAddressLine1 sensitive Ship To Address Line 1 string
shipToAddressLine2 sensitive Ship To Address Line 2 string
shipToCity Ship To City string
shipToCountry Ship To Country string
shipToState Ship To State string
shipToPostCode sensitive Ship To Post Code string
shortcutDimension1Code Shortcut Dimension 1 Code string
shortcutDimension2Code Shortcut Dimension 2 Code string
currencyId Currency ID string
currencyCode Currency Code string
paymentTermsId Payment Terms ID string
shipmentMethodId Shipment Method ID string
salesperson sensitive Salesperson string
partialShipping Partial Shipping integer
requestedDeliveryDate Requested Delivery Date datetime
discountAmount Discount Amount float
discountAppliedBeforeTax Discount Applied Before Tax integer
totalAmountExcludingTax Total Amount Excluding Tax float
totalTaxAmount Total Tax Amount float
totalAmountIncludingTax Total Amount Including Tax float
fullyShipped Fully Shipped integer
status Status string
lastModifiedDateTime Last Modified DateTime datetime
phoneNumber sensitive Phone Number string
email sensitive Email string
id ID string
number Number datetime
externalDocumentNumber External Document Number string
documentDate Document Date datetime
postingDate Posting Date datetime
dueDate Due Date datetime
customerId Customer ID string
customerNumber Customer Number string
customerName sensitive Customer Name string
billToName sensitive Bill To Name string
billToCustomerId Bill To Customer ID string
billToCustomerNumber Bill To Customer Number string
shipToName sensitive Ship To Name string
shipToContact sensitive Ship To Contact string
sellToAddressLine1 sensitive Sell To Address Line 1 string
sellToAddressLine2 sensitive Sell To Address Line 2 string
sellToCity Sell To City string
sellToCountry Sell To Country string
sellToState Sell To State string
sellToPostCode sensitive Sell To Post Code string
billToAddressLine1 sensitive Bill To Address Line 1 string
billToAddressLine2 sensitive Bill To Address Line 2 string
billToCity Bill To City string
billToCountry Bill To Country string
billToState BillToState string
billToPostCode sensitive Bill To Post Code string
shipToAddressLine1 sensitive Ship To Address Line 1 string
shipToAddressLine2 sensitive Ship To Address Line 2 string
shipToCity Ship To City string
shipToCountry Ship To Country string
shipToState Ship To State string
shipToPostCode sensitive Ship To Post Code string
currencyId Currency ID string
currencyCode Currency Code string
paymentTermsId Payment Terms ID string
shipmentMethodId Shipment Method ID string
shipmentMethod Shipment Method string
salesperson sensitive Salesperson string
discountAmount Discount Amount float
totalAmountExcludingTax Total Amount Excluding Tax float
totalTaxAmount Total Tax Amount float
totalAmountIncludingTax Total Amount Including Tax float
status Status string
sentDate Sent Date datetime
validUntilDate Valid Until Date datetime
acceptedDate Accepted Date datetime
lastModifiedDateTime Last Modified DateTime datetime
phoneNumber sensitive Phone Number string
email sensitive Email string
id ID string
code Code string
displayName Display Name string
lastModifiedDateTime Last Modified Date Time datetime
id ID string
code Code string
displayName Display Name string
taxType taxType string
lastModifiedDateTime Last Modified Date Time datetime

Don't See the Connector You Need?

Let us know and we'll build it for you!

Request Connector

Pricing

See all Dataddo plans

Compare Dataddo's flow-based pricing tiers side by side and start your 14-day free trial.

View pricing

One Platform to Connect All Your Data

Why Dataddo?

One Ingestion Layer for SaaS, Databases, and Files

Most teams use multiple tools and “spaghetti code” for ingestion, depending on the type of sources and loading patterns. Dataddo brings this under one control plane and one predictable pricing structure. 400+ connectors included.

Built for Cloud and On-Premise Environments

Run Dataddo in both cloud and hybrid on-prem configurations. The control plane stays in the cloud; your data never leaves your perimeter. Supports segmented and private networks, and legacy systems including DB2, Informix, and Sybase.

Full API Control - No UI Required

Dataddo is built API-first. Use the UI when you want it; bypass it entirely when you don’t and orchestrate your pipelines programmatically.

Managed Ingestion Operations. We Own the Reliability.

Dataddo takes operational responsibility for your ingestion layer. We manage connector maintenance, handle API changes from source systems, monitor pipelines proactively, and execute backfills and recovery. Your engineering team doesn’t have to.

Full Visibility Into Every Data Flow

Dataddo gives you complete observability across your ingestion layer: pipeline logs, run histories, data lineage, and audit trails. Know what moved, when it moved, what changed, and why. Built for environments where explainability and accountability are not optional.

The Data Foundation Your AI Needs

Enterprise AI depends on a governed, secure data layer. Dataddo consolidates SaaS, database, and file data into a unified managed pipeline, delivering to vector databases, feature stores, and data lakes, with native sensitive data hashing.

See All Platform Benefits

Case Studies

See What Other Organizations Have Achieved with Dataddo

80%

less

pipeline
maintenance

FTE saved

full-time equivalent
saved

Faster

data
collection

How Boldr Optimized 177 Pipelines for Reliable Internal Reporting

Talent Outsourcing

How KAARISMA Optimizes its AI Strategy by Eliminating Manual Data Management

Recruitment

How Ringside.ai Builds a Data Product Better and Faster Using Dataddo

Marketing

Testimonials

Our Customers Love Us

4.8 out of 5

4.5 out of 5

Amalia Bornstein

Global Social Content and Marketing Data Analyst

Uber Eats

“The data team at Uber Eats appreciates Dataddo's user-friendly interface that is designed for operation by non-technical team members in an order to minimalize the need for excessive training to support efficient project delivery.”

Andrew Hart

Chief Operations Officer

Sat 7

“Working with Dataddo has greatly simplified our reporting and given us access to trend data and insights that we were previously unable to generate.”

Vahan Petrosayan

Director of IT & Infrastructure

Search Engine Journal

“With Dataddo, all of my questions get answered faster …[and it's] fun to play with data now.”

Michael Guntenaar

CTO

ID&T Group

“Dataddo opens up gates and takes away the hurdles of working with data.”

Laurent Partouche

CPO

FoodChéri & Seazon

“We chose Dataddo for its user-friendliness, automatic transformations, clear pricing policy, and the quality of the human relationship that was established from our first exchanges.”

Natheer Maloon

Technology Solutions Manager

Boldr

“Dataddo support proved immensely valuable throughout the implementation phase. 9.5 out of 10.”

Zdeněk Hejnak

Data Development Team Leader

Livesport

“We save about 70% of the time it would otherwise take to ingest all our data, or 3-4 full-time equivalents, and spend this much more time on data analytics and activation. We only have one full-time data engineer, who does more than just collect data, while our BI team consists of 11 members.”

Greg Senior

Business Operations Manager

Farm Focus

“Appreciate all the help and support for us. A refreshing level of service from a tech company! Thank you!”

Dataddo Reviews