Microsoft Dynamics 365 Business Central Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business Central

Fuente

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.

CAMPOS DE DATOS

Explora los datos que puedes extraer de Microsoft Dynamics 365 Business Central

Categoría de datos

¿Necesita campos que no ve?

Háganoslo saber y los agregaremos al conector. Envíenos una solicitud aquí..

Atributos disponibles (347)

Atributo
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 sensible

Display Name

string
companyNumber

Company Number

string
companyName

Company Name

string
businessRelation

Business Relation

string
addressLine1 sensible

Address Line 1

string
addressLine2 sensible

Address Line 2

string
city

City

string
state

State

string
country

Country

string
postalCode sensible

Postal Code

string
phoneNumber sensible

Phone Number

string
mobilePhoneNumber sensible

Mobile Phone Number

string
email sensible

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 sensible

Display Name

string
type

Type

string
addressLine1 sensible

Address Line 1

string
addressLine2 sensible

Address Line 2

string
city

City

string
state

State

string
country

Country

string
postalCode sensible

Postal Code

string
phoneNumber sensible

Phone Number

string
email sensible

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 sensible

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 sensible

Customer Name

string
billToName sensible

Bill To Name

string
billToCustomerId

Bill To Customer ID

string
billToCustomerNumber

Bill To Customer Number

string
shipToName sensible

Ship To Name

string
shipToContact sensible

Ship To Contact

string
sellToAddressLine1 sensible

Sell To Address Line 1

string
sellToAddressLine2 sensible

Sell To Address Line 2

string
sellToCity

Sell To City

string
sellToCountry

Sell To Country

string
sellToState

Sell To State

string
sellToPostCode sensible

Sell To Post Code

string
billToAddressLine1 sensible

Bill To Address Line 1

string
billToAddressLine2 sensible

Bill To Address Line 2

string
billToCity

Bill To City

string
billToCountry

Bill To Country

string
billToState

Bill To State

string
billToPostCode sensible

Bill To Post Code

string
shipToAddressLine1 sensible

Ship To Address Line 1

string
shipToAddressLine2 sensible

Ship To Address Line 2

string
shipToCity

Ship To City

string
shipToCountry

Ship To Country

string
shipToState

Ship To State

string
shipToPostCode sensible

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 sensible

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 sensible

Phone Number

string
email sensible

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 sensible

Customer Name

string
billToName sensible

Bill To Name

string
billToCustomerId

Bill To Customer ID

string
billToCustomerNumber

Bill To Customer Number

string
shipToName sensible

Ship To Name

string
shipToContact sensible

Ship To Contact

string
sellToAddressLine1 sensible

Sell To Address Line 1

string
sellToAddressLine2 sensible

Sell To Address Line 2

string
sellToCity

Sell To City

string
sellToCountry

Sell To Country

string
sellToState

Sell To State

string
sellToPostCode sensible

Sell To Post Code

string
billToAddressLine1 sensible

Bill To Address Line 1

string
billToAddressLine2 sensible

Bill To Address Line 2

string
billToCity

Bill To City

string
billToCountry

Bill To Country

string
billToState

BillToState

string
billToPostCode sensible

Bill To Post Code

string
shipToAddressLine1 sensible

Ship To Address Line 1

string
shipToAddressLine2 sensible

Ship To Address Line 2

string
shipToCity

Ship To City

string
shipToCountry

Ship To Country

string
shipToState

Ship To State

string
shipToPostCode sensible

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 sensible

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 sensible

Phone Number

string
email sensible

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 sensible

Customer Name

string
billToName sensible

Bill To Name

string
billToCustomerId

Bill To Customer ID

string
billToCustomerNumber

Bill To Customer Number

string
shipToName sensible

Ship To Name

string
shipToContact sensible

Ship To Contact

string
sellToAddressLine1 sensible

Sell To Address Line 1

string
sellToAddressLine2 sensible

Sell To Address Line 2

string
sellToCity

Sell To City

string
sellToCountry

Sell To Country

string
sellToState

Sell To State

string
sellToPostCode sensible

Sell To Post Code

string
billToAddressLine1 sensible

Bill To Address Line 1

string
billToAddressLine2 sensible

Bill To Address Line 2

string
billToCity

Bill To City

string
billToCountry

Bill To Country

string
billToState

BillToState

string
billToPostCode sensible

Bill To Post Code

string
shipToAddressLine1 sensible

Ship To Address Line 1

string
shipToAddressLine2 sensible

Ship To Address Line 2

string
shipToCity

Ship To City

string
shipToCountry

Ship To Country

string
shipToState

Ship To State

string
shipToPostCode sensible

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 sensible

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 sensible

Phone Number

string
email sensible

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
¿No Encuentras el Conector que Necesitas?

¿No Encuentras el Conector que Necesitas?

¡Díganos y lo construiremos para usted!

Solicitar conector

Precios

Vea todos los planes de Dataddo

Compare los niveles de precios basados en flujos de Dataddo en paralelo y comience su prueba gratuita de 14 días.

Ver precios
Una plataforma para conectar todos sus datos

¿Por qué Dataddo?

Una capa de ingestión para SaaS, bases de datos y archivos

Una capa de ingestión para SaaS, bases de datos y archivos

La mayoría de los equipos utilizan múltiples herramientas y “código espagueti” para la ingestión, según el tipo de fuentes y los patrones de carga. Dataddo reúne todo esto bajo un único plano de control y una estructura de precios predecible. Más de 400+ conectores incluidos.

Diseñado para entornos cloud y on-premise

Diseñado para entornos cloud y on-premise

Ejecuta Dataddo tanto en la nube como en configuraciones híbridas on-premise. El plano de control permanece en la nube; tus datos nunca salen de tu perímetro. Compatible con redes segmentadas y privadas, y sistemas legacy como DB2, Informix y Sybase.

Control total vía API – sin necesidad de UI

Control total vía API – sin necesidad de UI

Dataddo está construido con enfoque API-first. Usa la interfaz cuando quieras; omítela por completo cuando no la necesites y orquesta tus pipelines de forma programática.

Operaciones de ingestión gestionadas. Nosotros garantizamos la fiabilidad.

Operaciones de ingestión gestionadas. Nosotros garantizamos la fiabilidad.

Dataddo asume la responsabilidad operativa de tu capa de ingestión. Gestionamos el mantenimiento de conectores, manejamos los cambios de API de los sistemas fuente, monitorizamos pipelines de forma proactiva y ejecutamos backfills y recuperación. Tu equipo de ingeniería no tiene que hacerlo.

Visibilidad total de cada flujo de datos

Visibilidad total de cada flujo de datos

Dataddo te ofrece observabilidad completa en toda tu capa de ingestión: logs de pipelines, historiales de ejecuciones, linaje de datos y auditorías. Sabe qué se movió, cuándo, qué cambió y por qué. Diseñado para entornos donde la explicabilidad y la responsabilidad no son opcionales.

La base de datos que tu IA necesita

La base de datos que tu IA necesita

La IA empresarial depende de una capa de datos gobernada y segura. Dataddo consolida datos de SaaS, bases de datos y archivos en un pipeline gestionado unificado, entregando a bases de datos vectoriales, feature stores y data lakes, con hashing nativo de datos sensibles.

Ver todos los beneficios de la plataforma
Estudios de caso

Vea lo que otras organizaciones han logrado con Dataddo

80%

menos

mantenimiento
de pipelines

1

ETC ahorrado

equivalente a tiempo completo
ahorrado

3x

más rápido

recopilación
de datos

Testimonios

Nuestros clientes nos aman

G2 Implementation Winter 2025

Amalia Bornstein

Global Social Content and Marketing Data Analyst

Uber Eats

“El equipo de datos de Uber Eats aprecia la interfaz fácil de usar de Dataddo, que está diseñada para ser operada por miembros del equipo no técnicos con el fin de minimizar la necesidad de capacitación excesiva para respaldar la entrega eficiente de proyectos.”

G2 Implementation Winter 2025

Andrew Hart

Chief Operations Officer

Sat 7

“Trabajar con Dataddo ha simplificado enormemente nuestros informes y nos ha dado acceso a datos de tendencias e información que antes no podíamos generar.”

G2 Implementation Winter 2025

Vahan Petrosayan

Director of IT & Infrastructure

Search Engine Journal

“Con Dataddo, todas mis preguntas obtienen respuesta más rápido... [y es] divertido jugar con datos ahora.”

G2 Implementation Winter 2025

Michael Guntenaar

CTO

ID&T Group

“Dataddo abre puertas y elimina los obstáculos de trabajar con datos.”

G2 Implementation Winter 2025

Laurent Partouche

CPO

FoodChéri & Seazon

“Elegimos Dataddo por su facilidad de uso, transformaciones automáticas, política de precios clara y la calidad de la relación humana que se estableció desde nuestros primeros intercambios.”

G2 Implementation Winter 2025

Natheer Maloon

Technology Solutions Manager

Boldr

“El soporte de Dataddo resultó inmensamente valioso durante toda la fase de implementación. 9,5 sobre 10.”

G2 Implementation Winter 2025

Zdeněk Hejnak

Data Development Team Leader

Livesport

“Ahorramos alrededor del 70 % del tiempo que de otro modo nos llevaría ingerir todos nuestros datos, o entre 3 y 4 equivalentes de tiempo completo, y dedicamos mucho más tiempo al análisis y la activación de datos. Solo contamos con un ingeniero de datos a tiempo completo, que hace más que simplemente recopilar datos, mientras que nuestro equipo de BI consta de 11 miembros.”

G2 Implementation Winter 2025

Greg Senior

Business Operations Manager

Farm Focus

“Agradecemos toda la ayuda y apoyo para nosotros. ¡Un refrescante nivel de servicio de una empresa de tecnología! ¡Gracias!”

G2 Implementation Winter 2025 G2 Performer Winter 2025 Google Cloud Partner Tableau Technology Partner AWS Partner Network Gartner Cool Vendor