Responsables comerciales y personal de finanzas consultan en Teams el estado de las facturas, los cobros pendientes y la caja por vencer mediante un agente de Copilot que lee sus cifras de Exact Online.
¿Qué clientes tienen más dinero atascado en el tramo más antiguo de cuentas por cobrar?
CopilotRespuesta · Exact Online
Van Dijk Bouw es quien más acumula en el tramo más antiguo: 14.200 € de un total pendiente de 31.500 €. Entre estas tres cuentas, hay 24.950 € en Age Group 4.
Account Name
Total Amount
Age Group 1 Amount
Age Group 4 Amount
Van Dijk BouwFinancial - Aging Receivables List
31.500 €
9.800 €
14.200 €
Kessler LogistikFinancial - Aging Receivables List
18.750 €
6.300 €
6.450 €
Maas RetailFinancial - Aging Receivables List
12.900 €
8.600 €
4.300 €
Leído de la lista de antigüedad actual, que vuelve a cargar todas las partidas abiertas en cada ejecución. El significado de cada tramo procede de los campos Age Group Description.
fuente
Exact Online · a lun 06:40 UTC
periodo
Partidas abiertas al 28 sep 2026
Pregunte a Copilot sobre sus datos de Exact Online...
Respuesta de ejemplo · cuenta y cifras ficticias
Exact Online en Copilot
Preguntas que Copilot puede responder con sus datos de Exact Online
Exact Online es un software empresarial en la nube para contabilidad y gestión financiera. Dataddo extrae sus datos de antigüedad de cuentas por cobrar, cuentas por pagar, facturas de venta, presupuestos y pérdidas y ganancias.
Estado de facturas antes de una llamada de renovación
Pregunte a Copilot
@Exact Finance Desk ¿Hay alguna Sales - Invoices con Invoice To Name Kessler Logistik que haya superado su Due Date? Muestre Invoice Number y Amount DC.
Los gestores de cuenta mencionan al agente de finanzas en su canal de Teams para ver si un cliente ha pagado, en lugar de escribir al contable y esperar una respuesta.
Posición de caja a treinta días
Pregunte a Copilot
@Exact Finance Desk Sume el Amount DC de Receivables con una Due Date en los próximos 30 días frente a los Payments que vencen en el mismo periodo, y dé el neto.
El responsable de finanzas pregunta en Microsoft 365 Copilot por las entradas frente a las salidas de caja del próximo mes y copia el resumen en la actualización semanal de tesorería.
Mapeo de tipos de cambio en VS Code
Pregunte a Copilot
Use las herramientas de dataddo para describir Exchange Rates y luego enumere Source currency, Target currency, Rate y Start date para nuestro módulo de conversión.
Un desarrollador del pipeline de informes pide a GitHub Copilot en Agent mode los campos reales de tipos de cambio, para que el código de conversión de moneda use los nombres de Exact Online en lugar de suposiciones.
Data to AI™ es gratuito durante la versión preliminar privada. Incorporamos equipos por oleadas y damos forma al producto con sus comentarios. En el lanzamiento, se cobrará como los asistentes de IA que tu equipo ya utiliza. ¿Necesitas contratos a medida o precios por volumen? Habla con nosotros sobre Enterprise.
Data to AITM
Entrega datos de negocio gobernados a Claude, ChatGPT y otras herramientas de IA mediante MCP.
Versión preliminar privada
Gratis durante la versión preliminar
Enterprise
Implemente Dataddo de manera flexible en cualquier entorno híbrido o de nube.
Los gestores de cuenta escriben al contable para preguntar si un cliente ha pagado, y el contable lo busca a mano en Exact Online.
Un agente de Copilot Studio publicado en Teams responde a partir de Sales - Invoices, así el gestor de cuenta lo menciona en el canal y obtiene el estado.
Menos consultas de estado a finanzas
Cuándo llama el agente a Dataddo
Un chat genérico de Copilot responde a preguntas financieras con conocimiento general, sin nada que lo vincule a su administración.
La descripción del servidor indica al agente que las facturas, los cobros y los pagos están en Dataddo, así que esas preguntas activan una consulta.
Consultas en las preguntas adecuadas
Varias divisiones
Cada división se exporta por separado y se pega en el chat, así que los totales del grupo dependen de quién recopiló cada archivo.
La extracción multicuenta recoge un dataset de todas las entidades a las que tiene acceso, y el agente desglosa las cifras por el campo Division.
Todas las divisiones en un solo agente
Desarrolladores y datos financieros
Los desarrolladores piden a finanzas exportaciones de muestra para conocer los nombres de campo de Exchange Rates y de las líneas de transacción.
GitHub Copilot en VS Code describe las entidades a través de .vscode/mcp.json, así que el código sigue los campos reales de Exact Online.
Sin exportaciones de muestra
Consumo de tokens
Copilot gasta tokens explorando columnas sin procesar de Exact Online, muestreando filas y reintentando hasta entender los datos.
Las definiciones de campos y las relaciones se entregan de antemano, así que el modelo se salta la exploración y va directo a la respuesta.
Menos tokens por respuesta
Calidad de las respuestas
Propenso a uniones incorrectas, campos inventados y cifras difíciles de comprobar.
Respuestas basadas en campos definidos. En el benchmark de Dataddo se respondió correctamente el 78,5 % de las preguntas, frente al 65,5 % con archivos CSV simples.
Mejores respuestas
Datasets
Datasets de Exact Online que puede usar en Copilot
Los datasets de Exact Online que más usan los equipos de finanzas y RevOps, con sus nombres de campo reales. Copilot los consulta por su nombre a través de la capa semántica de Dataddo.
Lista de datasets curados
EntryIDPrimary keyEntryID
string
BankEntryLinesCollection of linesBankEntryLines
string
BankStatementDocumentReference to document with bank statementBankStatementDocument
sensiblestring
BankStatementDocumentNumberDocument number of document with bank statementBankStatementDocumentNumber
sensibleinteger
BankStatementDocumentSubjectSubject of document with bank statementBankStatementDocumentSubject
string
ClosingBalanceFCClosing balance in the currency of the transactionClosingBalanceFC
float
CreatedCreation dateCreated
datetime
CurrencyCurrency codeCurrency
string
CustomFieldCustom field endpointCustomField
string
Division codeDivision
integer
EntryNumberEntry numberEntryNumber
integer
FinancialPeriodThe period of the transaction lines. The period should exist in the period date tableFinancialPeriod
integer
FinancialYearThe financial year to which the entry belongs. The financial year should exist in the period date tableFinancialYear
integer
JournalCodeCode of JournalJournalCode
string
JournalDescriptionDescription of JournalJournalDescription
string
ModifiedLast modified dateModified
datetime
OpeningBalanceFCOpening balance in the currency of the transactionOpeningBalanceFC
float
StatusStatus: 20 = Open, 50 = ProcessedStatus
integer
StatusDescriptionDescription of StatusStatusDescription
string
IDPrimary keyID
string
AccountReference to AccountAccount
string
AccountCodeCode of AccountAccountCode
string
AccountNameName of AccountAccountName
string
AmountDCAmount in the default currency of the companyAmountDC
float
AmountFCAmount in the currency of the transactionAmountFC
float
AmountVATFCVat amount in the currency of the transactionAmountVATFC
float
AssetReference to an assetAsset
string
AssetCodeCode of AssetAssetCode
string
AssetDescriptionDescription of AssetAssetDescription
string
CostCenterReference to a cost centerCostCenter
string
CostCenterDescriptionDescription of CostCenterCostCenterDescription
string
CostUnitReference to a cost unitCostUnit
string
CostUnitDescriptionDescription of CostUnitCostUnitDescription
string
CreatedCreation dateCreated
datetime
CreatorUser ID of creatorCreator
string
CreatorFullNameName of creatorCreatorFullName
sensiblestring
CustomFieldCustom field endpointCustomField
string
DateDate of the statement lineDate
datetime
DescriptionDescriptionDescription
string
Division codeDivision
integer
DocumentReference to a documentDocument
string
DocumentNumberNumber of DocumentDocumentNumber
sensibleinteger
DocumentSubjectSubject of DocumentDocumentSubject
string
EntryIDReference to the headerEntryID
sensiblestring
EntryNumberEntry number of the headerEntryNumber
sensibleinteger
ExchangeRateExchange rateExchangeRate
float
GLAccountGeneral ledger accountGLAccount
string
GLAccountCodeCode of GLAccountGLAccountCode
string
GLAccountDescriptionDescription of GLAccountGLAccountDescription
string
LineNumberLine numberLineNumber
sensibleinteger
ModifiedLast modified dateModified
datetime
ModifierUser ID of modifierModifier
string
ModifierFullNameName of modifierModifierFullName
sensiblestring
NotesExtra remarksNotes
string
OffsetIDReference to offset lineOffsetID
string
OurRefInvoice numberOurRef
integer
ProjectReference to a projectProject
string
ProjectCodeCode of ProjectProjectCode
string
ProjectDescriptionDescription of ProjectProjectDescription
string
ProjectWBSReference to Project WBSProjectWBS
string
ProjectWBSDescriptionDescription of Project WBSProjectWBSDescription
string
QuantityQuantityQuantity
float
VATCodeReference to vat code. If this property is not filled, it will use the default VAT code of the G/L account propertyVATCode
string
VATCodeDescriptionDescription of VATCodeVATCodeDescription
string
VATPercentageVat code percentageVATPercentage
float
VATTypeType of vat codeVATType
string
IDPrimary keyID
string
CodeBudget scenario codeCode
sensiblestring
CreatedCreation dateCreated
datetime
CreatorUser ID of creatorCreator
string
CreatorFullNameName of creatorCreatorFullName
sensiblestring
DescriptionBudget scenario descriptionDescription
string
Division codeDivision
integer
FromYearFrom yearFromYear
integer
ModifiedLast modified dateModified
datetime
ModifierUser ID of modifierModifier
string
ModifierFullNameName of modifierModifierFullName
sensiblestring
ToYearTo yearToYear
integer
IDPrimary keyID
string
AmountDCBudget amount (always in the default currency of the company)AmountDC
float
Budget ScenarioBudget scenarioBudgetScenario
string
Budget Scenario CodeCode of BudgetScenarioBudgetScenarioCode
string
BudgetScenario DescriptionDescription of BudgetScenarioBudgetScenarioDescription
string
CostcenterUsed for cost center-specific budgets - NULL otherwiseCostcenter
string
Costcenter DescriptionDescription of CostcenterCostcenterDescription
string
CostunitUsed for cost unit-specific budgets - NULL otherwiseCostunit
string
Costunit DescriptionDescription of CostunitCostunitDescription
string
CreatedCreation dateCreated
datetime
CreatorUser ID of creatorCreator
string
Creator FullNameName of creatorCreatorFullName
sensiblestring
Division codeDivision
integer
G/L accountGLAccount
string
GLAccountCodeCode of GLAccountGLAccountCode
string
GLAccount DescriptionDescription of GLAccountGLAccountDescription
string
HIDNumerical ID. Never displayed to the user, but it may have its use for performance reasonsHID
float
ItemUsed for item-specific budgets - NULL otherwiseItem
string
Item CodeCode of ItemItemCode
string
Item DescriptionDescription of ItemItemDescription
string
ModifiedLast modified dateModified
datetime
ModifierUser ID of modifierModifier
string
Modifier FullNameName of modifierModifierFullName
sensiblestring
Reporting PeriodPeriod (combined with financial year)ReportingPeriod
integer
Reporting YearFinancial yearReportingYear
integer
IDPrimary keyID
string
ID of the accountancy office account linked to this accountAccountant
string
Account ManagerUser ID of the account managerAccountManager
string
Account Manager Full NameFull name of the account managerAccountManagerFullName
sensiblestring
Account Manager HIDHuman-readable ID (HID) of the account managerAccountManagerHID
integer
Activity SectorSector code of the account's main activityActivitySector
string
Activity Sub SectorSub-sector code of the account's main activityActivitySubSector
string
Address Line 1First line of the addressAddressLine1
sensiblestring
Address Line 2Second line of the addressAddressLine2
sensiblestring
Address Line 3Third line of the addressAddressLine3
sensiblestring
Automatic Process Proposed EntryIndicates whether proposed entries are processed automaticallyAutomaticProcessProposedEntry
boolean
BlockedIndicates whether the account is blockedBlocked
boolean
BRINBRIN number (education institution registration number, NL)BRIN
sensiblestring
BSNSocial security number (Burgerservicenummer, NL)BSN
sensiblestring
Business TypeBusiness type code of the accountBusinessType
string
Can Drop ShipIndicates whether the account allows drop shippingCanDropShip
boolean
Chamber Of CommerceChamber of Commerce registration numberChamberOfCommerce
Bank AccountsCollection of bank accounts linked to the account (expanded navigation property, not a scalar field)BankAccounts
json
IDPrimary keyID
string
AccountThe supplier to which the payment has to be done.Account
string
AccountBankAccountIDThe bank account of the supplier, to which the payment has to be done.AccountBankAccountID
sensiblestring
AccountBankAccountNumberThe bank account number of the supplier, to which the payment has to be done.AccountBankAccountNumber
sensiblestring
AccountCodeThe code of the supplier to which the payment has to be done.AccountCode
sensiblestring
AccountContactContact person copied from the purchase invoice linked to the related purchase entry. Used as prefered contact when sending reminders.AccountContact
string
AccountContactNameName of the contact person of the supplier.AccountContactName
sensiblestring
AccountNameName of the supplier.AccountName
sensiblestring
AmountDCThe amount in default currency (division currency). Payments are matched on this amount.AmountDC
float
AmountDiscountDCThe amount of the discount in the default currency.AmountDiscountDC
float
AmountDiscountFCThe amount of the discount. This is in the amount of the selected currency.AmountDiscountFC
float
AmountFCThe amount of the payment. This is in the amount of the selected currency.AmountFC
float
BankAccountIDOwn bank account from which the payment must be done.BankAccountID
sensiblestring
BankAccountNumberOwn bank account number from which the payment must be done.BankAccountNumber
sensiblestring
CashflowTransactionBatchCodeWhen processing payments, all payments with the same processing data are put in a batch. This field contains the code of that batch.CashflowTransactionBatchCode
string
CreatedCreation date.Created
datetime
CreatorUser ID of the creator.Creator
string
CreatorFullNameName of the creator.CreatorFullName
sensiblestring
CurrencyThe currency of the payment. This currency can only deviate from the division currency if the module Currency is in the license.Currency
string
DescriptionExtra description for the payment that may be included in the bank export file.Description
string
DiscountDueDateDate before which the payment must be done to be eligible for discount.DiscountDueDate
datetime
Division codeDivision
float
DocumentDocument that is created when processing payments. The bank export file is attached to the document.Document
sensiblestring
DocumentNumberNumber of the document.DocumentNumber
sensibleinteger
DocumentSubjectSubject of the document.DocumentSubject
string
DueDateDate before which the payment must be done.DueDate
datetime
EndDateDate since when the payment is no longer an outstanding item. This is the highest invoice date of all matched payments.EndDate
datetime
EndPeriodPeriod since when the payment is no longer an outstanding item. This is the highest period of all matched payments.EndPeriod
integer
EndYearYear (of period) since when the payment is no longer an outstanding item. This is the highest year of all matched payments. Used in combination with EndPeriod.EndYear
integer
EntryDateProcessing date of the payment.EntryDate
datetime
EntryIDThe unique identifier for a set of payments. A payment can be split so that one part is paid on a different date. In that case the two records get a different EntryID.EntryID
sensiblestring
EntryNumberEntry number of the linked transaction.EntryNumber
sensibleinteger
GLAccountG/L account of the payment. Must be of type 22 (Accounts payable).GLAccount
string
GLAccountCodeCode of the G/L account.GLAccountCode
sensiblestring
GLAccountDescriptionDescription of the G/L account.GLAccountDescription
string
InvoiceDateInvoice date of the linked transaction.InvoiceDate
datetime
InvoiceNumberInvoice number of the linked transaction.InvoiceNumber
sensibleinteger
IsBatchBookingBoolean indicating whether the payment is part of a batch booking.IsBatchBooking
boolean
JournalJournal of the linked transaction.Journal
string
JournalDescriptionDescription of the journal.JournalDescription
string
ModifiedLast modified date.Modified
datetime
ModifierUser ID of modifier.Modifier
string
ModifierFullNameName of modifier.ModifierFullName
sensiblestring
PaymentBatchNumberNumber assigned during the of processing payments. When payments are processed a bank export file is created. This file contains one or more batches that contain one or more payments. Each batch gets a sequence number that is stored for each payment in that batch.PaymentBatchNumber
sensibleinteger
PaymentConditionPayment condition of the linked transaction.PaymentCondition
string
PaymentConditionDescriptionDescription of the payment condition.PaymentConditionDescription
string
PaymentDaysNumber of days between invoice date and due date.PaymentDays
integer
PaymentDaysDiscountNumber of days between invoice date and due date of the discount.PaymentDaysDiscount
PaymentMethodMethod of payment. B = On credit (default) I = Collection K = Cash V = Credit card.PaymentMethod
string
PaymentReferencePayment reference for the payment that may be included in the bank export file.PaymentReference
string
PaymentSelectedDate and time since when the payment is selected to be paid.PaymentSelected
datetime
PaymentSelectorUser who selected the payment to be paid.PaymentSelector
string
PaymentSelectorFullNameName of the payment selector.PaymentSelectorFullName
sensiblestring
RateFCExchange rate from payment currency to division currency. AmountFC * RateFC = AmountDC.RateFC
float
SourceThe source of the payment.Source
integer
StatusThe status of the payment. 20 = open 30 = selected - payment is selected to be paid 40 = processed - payment has been done 50 = matched - payment is matched with one or more other outstanding items or financial statement linesStatus
integer
TransactionAmountDCTotal amount of the linked transaction in default currency (division currency).TransactionAmountDC
float
TransactionAmountFCTotal amount of the linked transaction in the selected currency.TransactionAmountFC
float
TransactionDueDateDue date of the linked transaction.TransactionDueDate
datetime
TransactionEntryIDLinked transaction. Use this as reference to PurchaseEntries.TransactionEntryID
sensiblestring
TransactionIDLinked transaction line. Use this as reference to PurchaseEntryLinesTransactionID
sensiblestring
TransactionIsReversalIndicates if the linked transaction is a reversal entry.TransactionIsReversal
boolean
TransactionReportingPeriodPeriod of the linked transaction.TransactionReportingPeriod
integer
TransactionReportingYearYear of the linked transaction.TransactionReportingYear
integer
TransactionStatusStatus of the linked transaction.TransactionStatus
integer
TransactionTypeType of the linked transaction.TransactionType
integer
YourRefInvoice number of the supplier. In case the payment belongs to a bank entry line and is matched with one invoice, YourRef is filled with the YourRef of this invoice.YourRef
string
IDPrimary keyID
string
AccountReference to accountAccount
string
Account CodeCode of the AccountAccountCode
string
Account NameName of the AccountAccountName
string
Amount DCAmount in the default currency of the companyAmountDC
float
Amount FCAmount in the currency of the transactionAmountFC
float
Amount VAT Base FCVAT base amount in the currency of the transactionAmountVATBaseFC
float
Amount VAT FCVAT amount in the currency of the transactionAmountVATFC
float
AssetReference to assetAsset
string
Asset CodeCode of AssetAssetCode
string
Asset DescriptionDescription of AssetAssetDescription
string
Cost CenterReference to cost centerCostCenter
string
Cost Center DescriptionDescription of CostCenterCostCenterDescription
string
Cost UnitReference to cost unitCostUnit
string
Cost Unit DescriptionDescription of CostUnitCostUnitDescription
string
CreatedCreation dateCreated
datetime
CreatorUser ID of creatorCreator
string
Creator Full NameName of creatorCreatorFullName
sensiblestring
CurrencyCurrencyCurrency
string
Custom FieldCustom field endpointCustomField
string
DateEntry dateDate
datetime
DescriptionDescriptionDescription
string
Division codeDivision
float
DocumentReference to documentDocument
string
Document NumberNumber of the documentDocumentNumber
float
Document SubjectSubject of the documentDocumentSubject
string
Due DateDate that payment should be doneDueDate
datetime
Entry IDThe transaction lines that make up a financial entry share the same EntryIDEntryID
string
Entry NumberEntry number of the headerEntryNumber
float
Exchange RateExchange rateExchangeRate
float
External Link DescriptionDescription of ExternalLinkExternalLinkDescription
string
External Link ReferenceExternal linkExternalLinkReference
string
Extra Duty Amount FCExtra duty amountExtraDutyAmountFC
float
Extra Duty PercentageExtra duty percentageExtraDutyPercentage
float
Financial PeriodFinancial periodFinancialPeriod
float
Financial YearFinancial yearFinancialYear
float
General ledger accountGLAccount
string
GL Account CodeCode of GLAccountGLAccountCode
string
GL Account DescriptionDescription of GLAccountGLAccountDescription
string
Invoice NumberInvoice numberInvoiceNumber
float
ItemReference to itemItem
string
Item CodeCode of ItemItemCode
string
Item DescriptionDescription of ItemItemDescription
Start DateIndicates in combination with the end date if the account is activeStartDate
datetime
StatusIf the status field is filled this means the account is a customer. The value indicates the customer status.Status
string
Trade NameTrade name can be registered and shown with the client (for all legislations)TradeName
string
TypeAccount type: Values: A = Relation, D = DivisionType
string
VAT LiabilityIndicates the VAT status of an account to be able to identify the relation that should be selected in the VAT debtor listing in BelgiumVATLiability
string
VAT NumberThe number under which the account is known at the Value Added Tax collection agencyVATNumber
string
WebsiteWebsite of the accountWebsite
string
ModifiedLast modified dateModified
datetime
Is AccountantIndicates whether the account is an accountant.IsAccountant
boolean
Is AgencyIndicates whether the account is an agencyIsAgency
boolean
Is AnonymisedIndicates whether the account is anonymisedIsAnonymised
boolean
Is CompetitorIndicates whether the account is a competitorIsCompetitor
boolean
Is Extra DutyIndicates whether a customer is eligible for extra dutyIsExtraDuty
boolean
Is MailingIndicates if the account is excluded from mailing marketing informationIsMailing
boolean
Is Pilot Indicates whether the account is a pilot accountIsPilot
boolean
Is ResellerIndicates whether the account is a resellerIsReseller
boolean
Is SalesIndicates whether the account is a salesIsSales
boolean
Is SupplierIndicates whether the account is a supplierIsSupplier
boolean
IDPrimary keyID
string
Account Classification NameReference to Account classification nameAccountClassificationName
string
Account Classification Name DescriptionDescription of AccountClassificationNameAccountClassificationNameDescription
string
CodeAccount classification codeCode
string
CreatedCreation dateCreated
datetime
CreatorUser ID of creatorCreator
string
ModifiedLast modified dateModified
datetime
DescriptionDescriptionDescription
string
IDPrimary keyID
string
CodeUnique code identifierCode
sensiblestring
DescriptionDetailed descriptionDescription
string
IDPrimary keyID
string
AccountLead to which the opportunity appliesAccount
string
AccountantAccountant linked to the opportunityAccountant
string
AccountantCodeCode of the AccountantAccountantCode
string
AccountantNameName of the AccountantAccountantName
string
AccountCodeCode of AccountAccountCode
string
AccountNameName of AccountAccountName
string
ActionDateIndicates the date before/on the NextAction is supposed to be doneActionDate
datetime
AmountDCAmount in the default currency of the company. AmountDC = AmountFC * RateFCAmountDC
float
AmountFCAmount in the currency of the transactionAmountFC
float
CampaignReference to the campaign opportunity is related toCampaign
string
CampaignDescriptionDescription of CampaignCampaignDescription
string
ChannelReference to the channel opportunity is related toChannel
integer
ChannelDescriptionDescription of ChannelChannelDescription
string
CloseDateThe date when the opportunity is expected to be closedCloseDate
datetime
ContactContact ID of main contact personContact
string
ContactFullNameName of the main contact personContactFullName
sensiblestring
CreatedCreation dateCreated
datetime
CreatorUser ID of creatorCreator
string
CreatorFullNameName of the creatorCreatorFullName
sensiblestring
CurrencyCurrency codeCurrency
string
CustomFieldCustom field endpoint. Provided only for the Exact Online Premium users.CustomField
string
Division codeDivision
integer
LeadSourceThe source of the lead/opportunityLeadSource
string
LeadSourceDescriptionDescription of LeadSourceLeadSourceDescription
string
ModifiedLast modified dateModified
datetime
ModifierUser ID of modifierModifier
string
ModifierFullNameName of the last modifierModifierFullName
sensiblestring
NameName of the opportunityName
string
NextActionIndicates what follow up action is to be undertaken to move the opportunity towards a deal. Is used in combination with ActionDateNextAction
string
NotesNotes of the opportunityNotes
string
NumberInternal number of the opportunityNumber
integer
OpportunityDepartmentCodeCode of Opportunity DepartmentOpportunityDepartmentCode
integer
OpportunityDepartmentDescriptionDescription of Opportunity DepartmentOpportunityDepartmentDescription
string
OpportunityStageThe stage of the opportunity. This is a list defined by the userOpportunityStage
string
OpportunityStageDescriptionDescription of OpportunityStageOpportunityStageDescription
OpportunityTypeCode of Opportunity TypeOpportunityType
integer
OpportunityTypeDescriptionDescription of Opportunity TypeOpportunityTypeDescription
string
OwnerThe resource who owns the opportunity and is responsible to close the opportunity (either won or lost)Owner
string
OwnerFullNameName of OwnerOwnerFullName
sensiblestring
ProbabilityThe chance that the opportunity will be closed and won. The default for the probability depends on the default from the opportunity stageProbability
float
ProjectReference to projectProject
string
ProjectCodeCode of ProjectProjectCode
string
ProjectDescriptionDescription of ProjectProjectDescription
string
RateFCExchange rate from original to division currencyRateFC
float
ReasonCodeIndicates the reason why the opportunity was lost.ReasonCode
string
ReasonCodeDescriptionDescription of ReasonCodeReasonCodeDescription
string
ResellerReseller linked to the opportunityReseller
string
ResellerCodeCode of the ResellerResellerCode
string
ResellerNameName of the ResellerResellerName
string
SalesTypeReference to Sales typeSalesType
string
SalesTypeDescriptionDescription of SalesTypeSalesTypeDescription
string
QuotationIDIdentifier of the quotationQuotationID
string
AmountDCAmount in the default currency of the companyAmountDC
float
AmountDiscountDiscount Amount in the currency of the transactionAmountDiscount
float
AmountDiscountExclVatDiscount Amount excluding VAT in the currency of the transactionAmountDiscountExclVat
float
AmountFCAmount in the currency of the transactionAmountFC
float
CloseDateDate on which the customer accepted or rejected the quotation versionCloseDate
datetime
ClosingDateDate on which you expect to close/win the dealClosingDate
datetime
CreatedDate and time on which the quotation was createdCreated
datetime
CreatorUser ID of the creatorCreator
string
CreatorFullNameName of the creatorCreatorFullName
sensiblestring
CurrencyThe currency of the quotationCurrency
string
DeliveryAccountThe account where the items should deliveredDeliveryAccount
string
DeliveryAccountCodeThe code of the delivery accountDeliveryAccountCode
string
DeliveryAccountContactThe contact person of the delivery accountDeliveryAccountContact
string
DeliveryAccountContactFullNameFull name of the delivery account contact personDeliveryAccountContactFullName
sensiblestring
DeliveryAccountNameThe name of the delivery accountDeliveryAccountName
string
DeliveryAddressThe id of the delivery addressDeliveryAddress
string
DeliveryDateThe date of the deliveryDeliveryDate
datetime
DescriptionThe description of the quotationDescription
string
Division codeDivision
integer
DocumentDocument linked to the quotationDocument
string
DocumentSubjectThe subject of the documentDocumentSubject
string
DueDateDate after which the quotation is no longer validDueDate
datetime
IncotermAddressAddress of IncotermIncotermAddress
string
IncotermCodeCode of IncotermIncotermCode
string
IncotermVersionVersion of Incoterm Supported version for Incoterms : 2010, 2020IncotermVersion
integer
InvoiceAccountThe account to which the invoice is sentInvoiceAccount
string
InvoiceAccountCodeThe code of the invoice accountInvoiceAccountCode
string
InvoiceAccountContactThe contact person of the invoice accountInvoiceAccountContact
string
InvoiceAccountContactFullNameFull name of the invoice account contact personInvoiceAccountContactFullName
sensiblestring
InvoiceAccountNameThe name of the invoice accountInvoiceAccountName
string
ModifiedDate and time on which the quotation was last modifiedModified
datetime
ModifierUser ID of the modifierModifier
string
ModifierFullNameName of the modifierModifierFullName
sensiblestring
OpportunityOpportunity linked to the quotationOpportunity
string
OpportunityNameThe name of the opportunityOpportunityName
string
OrderAccountThe account that requested the quotationOrderAccount
string
OrderAccountCodeThe code of the order accountOrderAccountCode
string
OrderAccountContactThe contact person of the order accountOrderAccountContact
string
OrderAccountContactFullNameFull name of the order account contact personOrderAccountContactFullName
sensiblestring
OrderAccountNameThe name of the order accountOrderAccountName
PaymentDaysNumber of days to be included in the due date calculation. Example: invoice date = 17/01 PaymentEndOfMonths = 2 => 31/03 PaymentDays = 15 => 15/04PaymentDays
integer
PaymentDiscountTypeType of payment discount. Values: B = Settlement discount, K = Credit surchargePaymentDiscountType
string
PaymentEndOfMonthsNumber of month endings to be included in the due date calculationPaymentEndOfMonths
integer
PaymentMethodMethod of payment. Values: B = On credit, I = Collection, K = Cash, Q = PSP CollectionPaymentMethod
string
PercentagePercentage (stored as fraction) of total invoice amountPercentage
float
VATCalculationIndicates how the VAT amount is calculated Values: E = Excluding discount, I = Including discountVATCalculation
string
The balance sheet accountGLAccount
string
Division codeDivision
integer
Reporting YearThe reporting year of the opening balanceReportingYear
integer
AmountThe opening balance amount of the G/L accountAmount
float
Balance SideIndicates whether the G/L account is a debit or credit accountBalanceSide
string
G/L Account CodeThe code of the G/L accountGLAccountCode
string
G/L Account DescriptionThe description of the G/L accountGLAccountDescription
string
Division codeDivision
integer
Entity KeyEntity keyEntityKey
string
Entity TypeEntity TypeEntityType
integer
IDPrimary keyID
string
TimestampTimestampTimestamp
integer
CodeDepartment codeCode
string
Cost centerCost center codeCostcenter
string
Cost Center DescriptionCost center descriptionCostcenterDescription
string
CreatedCreation dateCreated
datetime
CreatorUser ID of creatorCreator
string
Creator Full NameName of creatorCreatorFullName
sensiblestring
DescriptionDepartment descriptionDescription
string
Division codeDivision
integer
IDPrimary keyID
string
ModifiedLast modified dateModified
datetime
ModifierUser ID of modifierModifier
string
Modifier Full NameName of modifierModifierFullName
sensiblestring
NotesExplanation or extra information can be stored in the notesNotes
string
CodeDivision CodeCode
integer
CustomerOwner account of the divisionCustomer
string
Customer CodeOwner account code of the divisionCustomerCode
string
Customer NameOwner account name of the divisionCustomerName
string
DescriptionDescriptionDescription
string
OB NumberThe soletrader VAT number used for official returns to tax authorityOBNumber
string
Siret NumberSiret Number of the division (France)SiretNumber
string
Tax Office NumberNumber of your local tax authority (Germany)TaxOfficeNumber
string
Tax Reference NumberLocal tax reference number (Germany)TaxReferenceNumber
string
VAT numberVAT numberVATNumber
string
EmailEmail address of the userEmail
sensiblestring
CreatedCreation dateCreated
datetime
ModifiedModified dateModified
datetime
CreatorUser ID of creatorCreator
string
ModifierUser ID of modifierModifier
string
IDPrimary keyID
string
DocumentReference to the DocumentDocument
string
File NameFilename of the attachmentFileName
string
File SizeSize of the attachmentFileSize
float
UrlURL to retrieve the attachmentUrl
string
TimestampTimestampTimestamp
integer
Division codeDivision
integer
CreatedCreation dateCreated
datetime
CreatorUser ID of creatorCreator
string
Creator full nameName of creatorCreatorFullName
sensiblestring
Division codeDivision
integer
IDPrimary keyID
string
ModifiedLast modified dateModified
datetime
ModifierUser ID of modifierModifier
string
Modifier full nameName of modifierModifierFullName
sensiblestring
RateThe exchange rate is stored as 1 TARGET CURRENCY = x SOURCE CURRENCYRate
float
Source currencyThe foreign currencySourceCurrency
string
Source currency descriptionDescription of the foreign currencySourceCurrencyDescription
string
Start dateThe date as of which the rate is valid. The rate is valid until a next rate is definedStartDate
datetime
Target currencyThe default currency of the divisionTargetCurrency
string
Target currency descriptionDescription of the default currencyTargetCurrencyDescription
string
Account IdAccountId
string
Account CodeAccountCode
string
Account NameAccountName
string
Total AmountTotalAmount
float
Age Group 1AgeGroup1
integer
Age Group 1 DescriptionAgeGroup1Description
string
Age Group 1 AmountAgeGroup1Amount
float
Age Group 2AgeGroup2
integer
Age Group 2 DescriptionAgeGroup2Description
string
Age Group 2 AmountAgeGroup2Amount
float
Age Group 3AgeGroup3
integer
Age Group 3 DescriptionAgeGroup3Description
string
Age Group 3 AmountAgeGroup3Amount
float
Age Group 4AgeGroup4
integer
Age Group 4 DescriptionAgeGroup4Description
string
Age Group 4 AmountAgeGroup4Amount
float
Currency CodeCurrencyCode
string
IDPrimary keyID
string
Balance SideThe following values are supported: D (Debit) C (Credit)BalanceSide
string
Balance TypeThe following values are supported: B (Balance Sheet) W (Profit & Loss)BalanceType
string
Belcotax TypeSupports webhook Indentify the kind of rewarding for the G/L account.BelcotaxType
float
CodeUnique Code of the G/L account Code
string
CompressIndicate if this G/L account should be shown as compressed without the details in the CRW report of G/L history Compress
boolean
CostcenterCost Center linked to the G/L accountCostcenter
string
Costcenter DescriptionDescription of CostcenterCostcenterDescription
string
CostunitCost Unit linked to the G/L account Costunit
string
Costunit DescriptionDescription of CostunitCostunitDescription
string
CreatedCreation dateCreated
datetime
CreatorUser ID of creatorCreator
string
Creator Full NameName of creatorCreatorFullName
sensiblestring
DescriptionName of the G/L account.Description
string
Division codeDivision
integer
Exclude VAT ListingGeneral ledger transactions on this G/L account should not appear on the VAT listingExcludeVATListing
float
Expense Non Deductible PercentageExpenses on this G/L account can not be used to reduce the incomesExpenseNonDeductiblePercentage
float
Is BlockedWhether the account is blockedIsBlocked
boolean
MatchingAllow entries on this general ledger account to be matched via the G/L account cardMatching
boolean
ModifierUser ID of modifierModifier
string
Modifier Full NameName of modifierModifierFullName
sensiblestring
Private G/L AccountWhether the account is privatePrivateGLAccount
string
Private PercentageSpecify the percentage of the cost that should be re-invoiced to the owner of the company as private use of the costsPrivatePercentage
float
Reporting CodeUsed in the export of yearly reportReportingCode
string
Revalue CurrencyIndicates if the amounts booked on this general ledger account will be recalculated when currency revaluation is doneRevalueCurrency
boolean
Search CodeSearch CodeSearchCode
string
TypeThe type of the G/L accountType
string
Type DescriptionDescription of TypeTypeDescription
string
Use CostcenterIndicates if cost centers can be used when using this general ledger accountUseCostcenter
float
Use CostunitIndicates if cost units can be used when using this general ledger accountUseCostunit
float
VAT CodeSupports webhook VAT Code linked to the G/L account VATCode
string
VAT DescriptionDescription of VATVATDescription
string
VAT G/L Account TypeSpecify the kind of purchase this G/L account is used forVATGLAccountType
string
VAT Non Deductible G/L AccountIf you use a percentage of non deductible VAT, you can specify another G/L account that will be used for the non deductible part of the VAT amountVATNonDeductibleGLAccount
string
VAT Non Deductible PercentageIf not the full amount of the VAT is deductible, you can indicate a percentage for the non decuctible partVATNonDeductiblePercentage
float
VAT SystemThe following values are supported: I (Invoice) C (Cash) (France)VATSystem
string
Year End Cost G/L AccountIndicates the costing account for year end calculationsYearEndCostGLAccount
string
Year End Reflection G/L AccountIndicates the reflection account that is used by year end applicationYearEndReflectionGLAccount
string
ModifiedLast modified dateModified
datetime
IDPrimary KeyID
string
AllowVariableCurrencyIndicates if the journal allows variable currencyAllowVariableCurrency
boolean
AllowVariableExchangeRateIndicates if the journal allows the exchange rate of the currency of the amounts in the journal entry to be changedAllowVariableExchangeRate
boolean
AllowVATIndicates if the journal allows the use of VAT in the financial entry. Applicable only for General JournalsAllowVAT
boolean
AutoSaveIndicates if the journal automatically saves the entries when the amount is in balance with the entry lines. Applicable for all types except cash. In the UI is called 'Exit Automatically'AutoSave
boolean
BankReference to bank account. Only Bank journal type will have a valueBank
sensiblestring
BankAccountBICCodeBIC code of the bank where the bank account is held. Only Bank journal type will have a valueBankAccountBICCode
sensiblestring
BankAccountCountryCountry of bank account. Only Bank journal type will have a valueBankAccountCountry
string
BankAccountDescriptionDescription of BankAccount. Only Bank journal type will have a valueBankAccountDescription
string
BankAccountIBANIBAN of the bank account. Only Bank journal type will have a valueBankAccountIBAN
sensiblestring
BankAccountIDReference to the Bank Account linked to the Journal. Only Bank journal type will have a valueBankAccountID
sensiblestring
BankAccountIncludingMaskBank account number. Is mandatory for Journals that have Type = BankBankAccountIncludingMask
string
BankAccountUseSEPAObsolete. Whether or not use SEPA for the bank accountBankAccountUseSEPA
boolean
BankAccountUseSepaDirectDebitObsolete. Whether or not use SEPA direct debit for the bank accountBankAccountUseSepaDirectDebit
boolean
BankNameName of bank account. Only Bank journal type will have a valueBankName
string
CodePrimary keyCode
sensiblestring
CreatedCreation dateCreated
datetime
CreatorUser ID of creatorCreator
string
CreatorFullNameName of creatorCreatorFullName
sensiblestring
CurrencyDefault Currency of the Journal. If AllowVariableCurrency is false this is the only currency that can be usedCurrency
string
CurrencyDescriptionDescription of CurrencyCurrencyDescription
string
CustomFieldCustom field endpointCustomField
string
DescriptionName of the JournalDescription
string
Division codeDivision
integer
GLAccountSuspense general ledger accountGLAccount
string
GLAccountCodeCode of GLAccountGLAccountCode
sensiblestring
GLAccountDescriptionDescription of GLAccountGLAccountDescription
string
GLAccountTypeType of GLAccountGLAccountType
integer
IsBlockedIndicates whether the journal is blocked or not.IsBlocked
boolean
ModifiedLast modified dateModified
datetime
ModifierUser ID of modifierModifier
string
ModifierFullNameName of modifierModifierFullName
sensiblestring
PaymentInTransitAccountGeneral ledger account for payment in transitPaymentInTransitAccount
string
PaymentServiceAccountIdentifierIdentifier detail of the Payment service account. Ex. EmailID for Paypal type of Payment service accountPaymentServiceAccountIdentifier
sensiblestring
PaymentServiceProviderType of Payment service provider. The following values are supported: 1 (Adyen), 2 (Paypal), 3 (Stripe). Is mandatory for Journals of Type 16 (Payment service)PaymentServiceProvider
integer
PaymentServiceProviderNameName of the Payment service providerPaymentServiceProviderName
sensiblestring
TypeType of Journal. The following values are supported: 10 (Cash) 12 (Bank) 16 (Payment service) 20 (Sales) 21 (Return invoice) 22 (Purchase) 23 (Received return invoice) 90 (General journal)Type
integer
Currency CodeThe currency codeCurrencyCode
string
Outstanding Payable Invoice AmountTotal invoice amount to be paidOutstandingPayableInvoiceAmount
float
Outstanding Payable Invoice CountNumber of invoices to be paidOutstandingPayableInvoiceCount
float
Outstanding Receivable Invoice AmountTotal invoice amount to be receivedOutstandingReceivableInvoiceAmount
float
Outstanding Receivable Invoice CountNumber of invoices to be receivedOutstandingReceivableInvoiceCount
float
Overdue Payable Invoice AmountTotal payable invoice amount that is overdueOverduePayableInvoiceAmount
float
Overdue Payable Invoice CountNumber of payable invoices that are overdueOverduePayableInvoiceCount
float
Overdue Receivable Invoice AmountTotal receivable invoice amount that is overdueOverdueReceivableInvoiceAmount
float
Overdue Receivable Invoice CountNumber of receivable invoices that are overdueOverdueReceivableInvoiceCount
float
Account CodeCode of AccountAccountCode
string
Reference to the accountAccountId
string
Account NameName of AccountAccountName
string
AmountAmountAmount
float
Amount In TransitAmount in transit - The amount that you have requested your bank to payAmountInTransit
float
Approval StatusApproval statusApprovalStatus
integer
Currency CodeCode of CurrencyCurrencyCode
string
DescriptionDescriptionDescription
string
Due DateDate the invoice is dueDueDate
datetime
Entry NumberThe entry number of this payment term corresponding purchase/cashflow entryEntryNumber
integer
Invoice DateThe date of the invoice or the date when money is paid to the supplierInvoiceDate
datetime
Invoice NumberFor purchase entry, it would be the entrynumber. For the cashflow entry, it will be entrynumber of an invoice which this payment is for.InvoiceNumber
integer
Journal CodeCode of JournalJournalCode
string
Journal DescriptionDescription of JournalJournalDescription
string
Your RefPurchase invoice Your Reference number. Will be null if it is a cashflow entry.YourRef
string
CreatedDate when the financial period record was createdCreated
datetime
CreatorUser ID of the creatorCreator
string
Creator Full NameFull name of the creatorCreatorFullName
sensiblestring
DivisionAdministration division codeDivision
integer
End DateEnd date of the financial periodEndDate
datetime
Financial PeriodFinancial period numberFinPeriod
integer
Financial YearFinancial year numberFinYear
integer
IDUnique identifier of the financial periodID
string
ModifiedDate when the financial period record was last modifiedModified
datetime
ModifierUser ID of the last modifying userModifier
string
Modifier Full NameFull name of the last modifying userModifierFullName
sensiblestring
Start DateStart date of the financial periodStartDate
datetime
Current YearCurrent yearCurrentYear
integer
Costs Current PeriodTotal cost for the current year and periodCostsCurrentPeriod
float
Costs Current YearTotal cost for the current yearCostsCurrentYear
float
Costs Previous YearTotal cost for the previous yearCostsPreviousYear
float
Costs Previous Year PeriodTotal cost for the previous year and periodCostsPreviousYearPeriod
float
Currency CodeCurrency codeCurrencyCode
string
Current PeriodCurrent periodCurrentPeriod
integer
Previous YearPrevious yearPreviousYear
integer
Previous Year PeriodPeriod in previous yearPreviousYearPeriod
integer
Result Current PeriodResults of current year and periodResultCurrentPeriod
float
Result Current YearResults of current yearResultCurrentYear
float
Result Previous YearResults of previous yearResultPreviousYear
float
Result Previous Year PeriodResults of previous year and periodResultPreviousYearPeriod
float
Revenue Current PeriodTotal revenue for the current year and periodRevenueCurrentPeriod
float
Revenue Current YearTotal revenue for the current yearRevenueCurrentYear
float
Revenue Previous YearTotal revenue for the previous yearRevenuePreviousYear
float
Revenue Previous Year PeriodTotal revenue for the previous year and periodRevenuePreviousYearPeriod
float
HIDPrimary key, human readable IDHID
string
Account CodeCode of AccountAccountCode
string
Reference to the accountAccountId
string
Account NameName of AccountAccountName
string
AmountAmountAmount
float
Amount In TransitAmount in transit - The amount that you have requested your bank to payAmountInTransit
float
Currency CodeCode of CurrencyCurrencyCode
string
DescriptionDescriptionDescription
string
Due DateDate the invoice is dueDueDate
datetime
Entry NumberThe entry number of this payment term corresponding sales/cashflow entryEntryNumber
integer
Invoice DateThe date of the invoice or the date when money is collected from the customerInvoiceDate
datetime
Invoice NumberFor sales entry, it would be the entrynumber. For the cashflow entry, it will be entrynumber of an invoice which this collection is for.InvoiceNumber
integer
Journal CodeCode of JournalJournalCode
string
Journal DescriptionDescription of JournalJournalDescription
string
Your RefSales invoice Your Reference number. Will be null if it is a cashflow entry.YourRef
string
IDRecord IDID
string
AmountThe sum of the amounts of all transactions in the groupingAmount
float
Amount of CreditThe sum of the amounts of all credit transactions in the groupingAmountCredit
float
Amount of DebitThe sum of the amounts of all debit transactions in the groupingAmountDebit
float
Balance TypeBalance type of the G/L account: B = Balance Sheet, W = Profit & Loss.BalanceType
string
Cost Center CodeThe code of the cost centerCostCenterCode
string
Cost Center DescriptionThe description of the cost centerCostCenterDescription
string
Cost Unit CodeThe code of the cost unitCostUnitCode
string
Cost Unit DescriptionThe description of the cost unitCostUnitDescription
string
CountThe number of transactions in the groupingCount
integer
Division codeDivision
integer
G/L accountGLAccount
string
GL Account CodeThe code of the G/L accountGLAccountCode
string
GL Account DescriptionThe description of the G/L accountGLAccountDescription
string
Reporting PeriodThe reporting period of the transactions in the groupingReportingPeriod
integer
Reporting YearThe reporting year of the transactions in the groupingReportingYear
integer
StatusStatus: 20 = Open, 50 = ProcessedStatus
integer
TypeThe type of the transactions in the groupingType
integer
IDPrimary keyID
string
ClassificationID of the classificationClassification
string
Classification CodeCode of the classificationClassificationCode
string
Classification DescriptionDescription of the classificationClassificationDescription
string
Division codeDivision
integer
ID of the general ledger accountGLAccount
string
G/L Account CodeCode of the general ledger accountGLAccountCode
string
G/L Account DescriptionDescription of the general ledger accountGLAccountDescription
string
G/L Scheme CodeCode of the general ledger schemeGLSchemeCode
string
G/L Scheme DescriptionDescription of the general ledger schemeGLSchemeDescription
string
G/L Scheme IDGeneral ledger scheme ID of the elementGLSchemeID
string
IDPrimary keyID
string
AbstractAbstract elements are only used in presentation linkbases to group other elements. They are not supposed to be used in instance documents.Abstract
boolean
BalanceOnly used for amount concepts: in that case either 'debit' or 'credit'.Balance
string
CodeThe Code is unique.Code
string
CreatedCreation date.Created
datetime
CreatorUser ID of creator.Creator
string
Creator FullNameName of creator.CreatorFullName
sensiblestring
DescriptionDescription of the element.Description
string
Division codeDivision
integer
Is Tuple SubElementObsolete.IsTupleSubElement
boolean
ModifiedLast modified date.Modified
datetime
ModifierUser ID of modifier.Modifier
string
Modifier FullNameName of modifierModifierFullName
sensiblestring
NameThe Name is unique in the namespace.Name
string
NillableDetermines whether usage of the element is mandatory in an instance document.Nillable
boolean
ParentParent element for reporting schemes.Parent
string
Period TypeOnly used for item concepts:either 'instant' or 'duration'. 'instant' is used for balance types of concepts, 'duration' is used for P&L types of concepts.PeriodType
string
Substitution GroupMostly import sutstitutiongroup is xbrli:tuple, which makes the element a tuple concept. The default substitutiongroup for item concepts is xbrli:item.SubstitutionGroup
string
TaxonomyNamespaceNamespace of the element.TaxonomyNamespace
string
TaxonomyNamespace DescriptionDescription of TaxonomyNamespace.TaxonomyNamespaceDescription
string
TypeType of the element.Type
string
CurrencyCurrency codeCurrency
string
Custom FieldCustom field endpointCustomField
string
Division codeDivision
integer
Entry IDPrimary keyEntryID
string
CreatedCreated dateCreated
datetime
Entry NumberEntry numberEntryNumber
integer
Exchange RateExchange rateExchangeRate
float
Financial YearThe financial year to which the entry belongs. The financial year should exist in the period date tableFinancialYear
integer
Journal CodeCode of JournalJournalCode
string
Journal DescriptionDescription of JournalJournalDescription
string
TypeType: 10 = Opening balance, 90 = OtherType
integer
Financial PeriodThe period of the transaction lines. The period should exist in the period date tableFinancialPeriod
integer
Status DescriptionDescription of StatusStatusDescription
ReversalIndicates that amounts are reversed, reversal allows to create correction entries with negative amounts on same side (debit/credit) as the original entry.Reversal
boolean
Type DescriptionDescription of TypeTypeDescription
string
NotesExtra remarksNotes
string
ModifierUser ID of modifierModifier
string
General ledger accountGLAccount
string
VAT TypeThe VAT type determines what the values are in relation to VAT returnsVATType
string
Cost UnitReference to cost unitCostUnit
string
Reference to projectProject
string
Entry NumberEntry number of the headerEntryNumber
string
VAT Code DescriptionDescription of VATCodeVATCodeDescription
string
DescriptionDescriptionDescription
string
IDPrimary keyID
string
VAT Base Amount FCVAT base amount in the currency of the transactionVATBaseAmountFC
string
Asset CodeCode of AssetAssetCode
string
DocumentReference to documentDocument
string
QuantityQuantityQuantity
float
Account NameName of AccountAccountName
string
Cost Center DescriptionDescription of CostCenterCostCenterDescription
string
Offset IDOffsetID - The GUID of the entryline which contain the off set amount of this entryOffsetID
string
AccountReference to accountAccount
string
DateEntry dateDate
datetime
Project DescriptionDescription of ProjectProjectDescription
string
Entry IDReference to header of the entryEntryID
string
Creator Full NameName of creatorCreatorFullName
sensiblestring
Modifier Full NameName of modifierModifierFullName
sensiblestring
Division codeDivision
integer
GL Account DescriptionDescription of GL AccountGLAccountDescription
string
CreatedCreation dateCreated
datetime
AssetReference to assetAsset
string
Line NumberLine numberLineNumber
integer
ModifiedLast modified dateModified
datetime
GL Account CodeCode of GLAccountGLAccountCode
string
Account CodeCode of AccountAccountCode
string
Our RefOur ref of general journal entryOurRef
string
Document NumberDocument numberDocumentNumber
integer
Document SubjectDocument subjectDocumentSubject
string
Cost CenterReference to cost centerCostCenter
string
VAT Base Amount DCVAT base amount in the default currency of the companyVATBaseAmountDC
float
Custom FieldCustom field endpointCustomField
string
CreatorUser ID of creatorCreator
string
Amount FCAmount in the currency of the transaction. If an 'Including' VAT code is used this amount includes the VAT amount.AmountFC
float
Amount VAT DCVat amount in the default currency of the company.AmountVATDC
float
Cost Unit DescriptionDescription of CostUnitCostUnitDescription
string
Project CodeCode of ProjectProjectCode
string
Amount DCAmount in the default currency of the company, If an 'Including' VAT code is used this amount includes the VAT amount.AmountDC
float
Amount VAT FCVat amount in the currency of the transaction. If you want to set this in a POST you have to specify VATCode as well.
AmountVATFC
float
Asset DescriptionDescription of AssetAssetDescription
string
VAT PercentageVat percentageVATPercentage
float
VAT CodeVATCode can only be used if the general journal has VAT enabled. VAT Lines will be automatically created if the VATCode is specified when creating a new general journal entry. If this property is not filled, it will use the default VAT code of the G/L account propertyVATCode
string
IDPrimary keyID
string
CauseAbsence cause, only supported for the Netherland legislationCause
integer
Cause CodeCode for the absence cause, only supported for the Netherland legislationCauseCode
string
Cause DescriptionDescription for the absence cause, only supported for the Netherland legislationCauseDescription
sensiblestring
CreatedCreation dateCreated
datetime
CreatorUser ID of creatorCreator
string
Creator Full NameName of creatorCreatorFullName
sensiblestring
Division codeDivision
integer
Employee linked to the absenceEmployee
string
Employee Full NameEmployee full nameEmployeeFullName
sensiblestring
Employee HIDNumeric ID of the employeeEmployeeHID
string
KindAbsence kind, only supported for the Netherland legislationKind
integer
Kind CodeCode for the absence kind, only supported for the Netherland legislationKindCode
string
Kind DescriptionDescription for the absence kind, only supported for the Netherland legislationKindDescription
sensiblestring
NotesExtra information for absenceNotes
string
Transaction CreatedCreation date of absence registration transactionTransactionCreated
datetime
Transaction End TimeEnd time on the last day of absence stored as DateTime, and the date should be ignoredTransactionEndTime
datetime
Transaction Expected End DateExpected end date of absenceTransactionExpectedEndDate
datetime
Transaction HoursDifferentiation of absence hours of the absence registration transaction between previous and current statusTransactionHours
float
Transaction First DayHours of absence on the first dayTransactionFirstDay
float
Transaction Hours Last DayHours of absence on the last dayTransactionHoursLastDay
float
Transaction Notification MomentNotification moment of absenceTransactionNotificationMoment
string
Transaction Start DateStart date of absenceTransactionStartDate
datetime
StatusStatus of absence, 0 = Open, 1 = RecoveredStatus
string
IDPrimary keyID
string
ActiveIndicates if the cost center is activeActive
boolean
CodeCode (user-defined ID)Code
string
CreatedCreation dateCreated
datetime
CreatorUser ID of creatorCreator
string
Creator Full NameName of creatorCreatorFullName
sensiblestring
DescriptionDescription (text)Description
string
Division codeDivision
integer
End DateThe end date by which the cost center has to be inactiveEndDate
datetime
ModifiedLast modified dateModified
datetime
ModifierUser ID of modifierModifier
string
Modifier Full NameName of modifierModifierFullName
sensiblestring
IDPrimary keyID
string
BatchNumbersThe collection of batch numbers that belong to the items included in this stock countBatchNumbers
string
CostPriceCost price of the item that is used to create the stock countCostPrice
float
CountedByCounted byCountedBy
string
CreatedCreation dateCreated
datetime
CreatorUser ID of creatorCreator
string
CreatorFullNameName of creatorCreatorFullName
sensiblestring
Division codeDivision
integer
ItemReference to the item for which the stock is countedItem
ItemDivisableIndicates if fractional quantities of the item can be used, for example quantity = 0.4ItemDivisable
boolean
LineNumberLine numberLineNumber
sensibleinteger
ModifiedLast modified dateModified
datetime
ModifierUser ID of modifierModifier
string
ModifierFullNameName of modifierModifierFullName
sensiblestring
QuantityDifferenceThe difference between the current quantity in stock and the new quantity in stock. For example specify -1 for this field to correct the quantity if one item in stock is broken.QuantityDifference
float
QuantityInStockThe current quantity available in stockQuantityInStock
float
QuantityNewThe new quantity in stock. Use this field to correct the quantity when the items in stock are physically counted.QuantityNew
float
ReasonCodeReason code for logisticsReasonCode
string
ReasonCodeDescriptionReason code for logistics descriptionReasonCodeDescription
string
ReasonCodeIDReason code for logistics idReasonCodeID
sensiblestring
SerialNumbersThe collection of serial numbers that belong to the items included in this stock countSerialNumbers
StockCountIDIdentifies the stock count. All the lines of a stock count have the same StockCountIDStockCountID
sensiblestring
StockKeepingUnitStock item's unit descriptionStockKeepingUnit
string
StorageLocationThis property is package specific (Stock count can have multiple lines for the same item only if it is for multiple storage locations).StorageLocation
StockCountLinesCollection of stock count linesStockCountLines
string
StockCountNumberHuman readable id of the stock countStockCountNumber
sensibleinteger
WarehouseWarehouseWarehouse
string
WarehouseCodeCode of WarehouseWarehouseCode
sensiblestring
WarehouseDescriptionDescription of WarehouseWarehouseDescription
string
IDPrimary key. A guid that is the unique identifier of the warehouseID
string
CodeCode of the warehouseCode
string
CreatedCreation dateCreated
datetime
CreatorUser ID of creatorCreator
string
CreatorFullNameName of creatorCreatorFullName
sensiblestring
DefaultStorageLocationThe default storage location of this warehouse. Warehouses can have a default storage location in packages Manufacturing Professional & Premium or Wholesale Professional & PremiumDefaultStorageLocation
DescriptionThe description of the warehouseDescription
string
Division codeDivision
integer
EMailEmail addressEMail
string
MainIndicates if this is the main warehouse. There's always exactly one main warehouse per administrationMain
string
ManagerUserUser responsible for the warehouseManagerUser
string
ModifiedLast modified dateModified
datetime
ModifierUser ID of modifierModifier
string
ModifierFullNameName of modifierModifierFullName
sensiblestring
UseStorageLocationsIndicates if this warehouse is using storage locations. The storage locations will not be removed when when this is deactivatedUseStorageLocations
string
IDA guid that is the unique identifier of the linkage between item and warehouseID
string
Counting CycleIndicates the number of days for next cycle count.CountingCycle
integer
CreatedCreation dateCreated
datetime
CreatorUser ID of creatorCreator
string
Creator Full NameName of creatorCreatorFullName
sensiblestring
Current StockQuantity that is currently in stock, included the stock committed to sales orderCurrentStock
float
Default Storage LocationThis is a default storage locationDefaultStorageLocation
Reserved StockThe quantity in a back to back order process which is already received from the purchase order, but not yet delivered for the sales order.ReservedStock
float
Safety StockMinimum quantity of items you must have in stockSafetyStock
float
Storage Location Sequence NumberSequence number of the item (Premium Only)StorageLocationSequenceNumber
integer
Storage Location URLURL pointing to details of which storage locations this ItemWarehouse's stock is locatedStorageLocationUrl
string
WarehouseWarehouse IDWarehouse
string
Warehouse CodeCode of warehouseWarehouseCode
string
Warehouse DescriptionDescription of warehouseWarehouseDescription
string
TimestampTimestampTimestamp
integer
CurrentStockNumber of items in stockCurrentStock
float
Division codeDivision
integer
FreeStockQuantity of available stockFreeStock
float
IDPrimary KeyID
string
ItemCodeCode of the itemItemCode
string
ItemDescriptionDescription of the itemItemDescription
string
ItemIdA guid that is the unique identifier of the itemItemId
string
PlanningInNumber of items that are planned to come inPlanningIn
float
PlanningOutNumber of items that are planned to go outPlanningOut
float
ProjectedStockThe quantity of stock projected given all planned future stock changesProjectedStock
float
ReorderPointQuantity of items as an indication of when you need to reorder more stock for the warehouseReorderPoint
float
ReservedStockStock stored in the warehouse that is already reservedReservedStock
float
UnitCodeCode of item unitUnitCode
string
UnitDescriptionDescription of the item unitUnitDescription
string
WarehouseA guid that is the unique identifier of the warehouseWarehouse
string
WarehouseCodeCode of warehouseWarehouseCode
string
WarehouseDescriptionDescription of warehouseWarehouseDescription
string
IDPrimary key. Id of PropertyID
string
CodeCode of propertyCode
string
DescriptionDescription of propertyDescription
string
Division codeDivision
integer
Item Assortment CodeCost center descriptionItemAssortmentCode
Status DescriptionDescription of StatusStatusDescription
string
YearFinancial yearYear
integer
PeriodFinancial periodPeriod
integer
Journal DescriptionDescription of JournalJournalDescription
string
Journal Type DescriptionDescription of JournalTypeJournalTypeDescription
string
StatusJournal status for this year and period 0=open, 1=closedStatus
integer
IDPrimary key. ID of ItemAssortmentID
string
CodeCode of ItemAssortmentCode
sensibleinteger
DescriptionDescription of ItemAssortmentDescription
string
Division codeDivision
integer
PropertiesProperties of this ItemAssortmentProperties
string
IDPrimary key. A guid that is the unique identifier of the item groupID
string
CodeCode of the item groupCode
sensiblestring
CreatedCreation dateCreated
datetime
CreatorUser ID of creatorCreator
string
CreatorFullNameName of creatorCreatorFullName
sensiblestring
DescriptionDescription of the item groupDescription
string
Division codeDivision
integer
GLCostsGL account on which the costs of items of this group will be bookedGLCosts
string
GLCostsCodeCode of GLCostsGLCostsCode
string
GLCostsDescriptionDescription of GLCostsGLCostsDescription
string
GLCostsWorkInProgressGL account on which the work in progress project costs of items of this group will be bookedGLCostsWorkInProgress
string
GLCostsWorkInProgressCodeCode of GLCosts Work In ProgressGLCostsWorkInProgressCode
string
GLCostsWorkInProgressDescriptionDescription of GLCosts Work In ProgressGLCostsWorkInProgressDescription
string
GLPurchaseAccountGL Purchase account for purchase invoicing according to (non-) perpetual inventory methodGLPurchaseAccount
string
GLPurchaseAccountCodeCode of GLPurchaseGLPurchaseAccountCode
string
GLPurchaseAccountDescriptionDescription of GLPurchaseAccountGLPurchaseAccountDescription
string
GLPurchasePriceDifferenceGL account that will be used for the 'Standard cost price' valuation method to balance the difference between purchase price and cost priceGLPurchasePriceDifference
string
GLPurchasePriceDifferenceCodeCode of GLPurchasePriceDifferenceGLPurchasePriceDifferenceCode
string
GLPurchasePriceDifferenceDescrDescription of GLPurchasePriceDifferenceGLPurchasePriceDifferenceDescr
string
GLRevenueGL account on which the revenue for items of this group will be bookedGLRevenue
string
GLRevenueCodeCode of GLRevenueGLRevenueCode
sensiblestring
GLRevenueDescriptionDescription of GLRevenueGLRevenueDescription
string
GLRevenueWorkInProgressGL account on which the work in progress project revenue of items of this group will be bookedGLRevenueWorkInProgress
string
GLRevenueWorkInProgressCodeCode of GLRevenue WorkInProgressGLRevenueWorkInProgressCode
sensiblestring
GLRevenueWorkInProgressDescriptionDescription of GLRevenue WorkInProgressGLRevenueWorkInProgressDescription
string
GLStockGL account on which stock entries will be booked for items of this groupGLStock
string
GLStockCodeCode of GLStockGLStockCode
sensiblestring
GLStockDescriptionDescription of GLStockGLStockDescription
string
GLStockVarianceGL stock variance account for perpetual inventoryGLStockVariance
string
GLStockVarianceCodeCode of GLStockVarianceGLStockVarianceCode
sensiblestring
GLStockVarianceDescriptionDescription of GLStockVarianceGLStockVarianceDescription
string
IsDefaultIndicates if this is the default item group that will be assigned when a new item is createdIsDefault
string
ModifiedLast modified dateModified
datetime
ModifierUser ID of modifierModifier
string
ModifierFullNameName of modifierModifierFullName
sensiblestring
NotesNotesNotes
string
IDA guid that is the unique identifier of the itemID
string
Average CostThe current average cost priceAverageCost
float
BarcodeBarcode of the itemBarcode
string
Class 1Item class code referring to ItemClasses with ClassID 1Class_01
string
Class 2Item class code referring to ItemClasses with ClassID 2Class_02
string
Class 3Item class code referring to ItemClasses with ClassID 3Class_03
string
Class 4Item class code referring to ItemClasses with ClassID 4Class_04
string
Class 5Item class code referring to ItemClasses with ClassID 5Class_05
string
Class 6Item class code referring to ItemClasses with ClassID 6Class_06
string
Class 7Item class code referring to ItemClasses with ClassID 7Class_07
string
Class 8Item class code referring to ItemClasses with ClassID 8Class_08
string
Class 9Item class code referring to ItemClasses with ClassID 9Class_09
string
Class 10Item class code referring to ItemClasses with ClassID 10Class_10
string
Item codeItem codeCode
string
Copy RemarksCopy sales remarks to sales linesCopyRemarks
string
Cost Price CurrencyThe currency of the current and proposed cost priceCostPriceCurrency
string
Cost Price NewProposed cost priceCostPriceNew
float
Cost Price StandardThe current standard cost priceCostPriceStandard
float
Creation dateCreation dateCreated
datetime
CreatorUser ID of creatorCreator
string
Creator Full NameName of creatorCreatorFullName
sensiblestring
DescriptionDescription of the itemDescription
string
Division codeDivision
integer
End DateTogether with StartDate this determines if the item is activeEndDate
datetime
Extra DescriptionExtra description text, slightly longer than the regular descriptionExtraDescription
string
GL CostsGL account the cost entries will be booked onGLCosts
string
GL Costs CodeCode of GL account for costsGLCostsCode
string
GL Costs DescriptionDescription of GLCostsGLCostsDescription
string
GL RevenueGL account the revenue will be booked onGLRevenue
string
GL Revenue CodeCode of GLRevenueGLRevenueCode
string
GL Revenue DescriptionDescription of GLRevenueGLRevenueDescription
string
GL StockGL account the stock entries will be booked onGLStock
string
GL Stock CodeCode of GL account for stockGLStockCode
string
GL Stock DescriptionDescription of GLStockGLStockDescription
string
Gross WeightGross weight for international goods shipmentsGrossWeight
float
Item GroupGuid of Item group of the itemItemGroup
string
Item Group CodeCode of ItemGroupItemGroupCode
string
Item Group DescriptionDescription of ItemGroupItemGroupDescription
string
ModifiedLast modified dateModified
datetime
ModifierUser ID of modifierModifier
string
Modifier Full NameName of modifierModifierFullName
sensiblestring
Net WeightNet weight for international goods shipmentsNetWeight
float
Net Weight UnitNet Weight unit for international goods shipment, only available in manufacturing packagesNetWeightUnit
string
NotesNotesNotes
string
Picture NameFile name of picturePictureName
string
Picture Thumbnail URLURL where thumbnail picture can be retrievedPictureThumbnailUrl
string
Picture URLURL where picture can be retrievedPictureUrl
string
Sales Vat CodeCode of SalesVatSalesVatCode
string
Sales Vat Code DescriptionDescription of SalesVatCodeSalesVatCodeDescription
Start DateTogether with EndDate this determines if the item is activeStartDate
datetime
StockQuantity that is in stockStock
float
UnitThe standard unit of this itemUnit
string
Unit DescriptionDescription of UnitUnitDescription
string
Unit TypeType of unit: A=Area, L=Length, O=Other, T=Time, V=Volume, W=WeightUnitType
string
IDPrimary keyID
string
ActiveActiveActive
string
CodeCode of the selection codeCode
sensiblestring
CreatedCreation dateCreated
datetime
CreatorUser ID of creatorCreator
string
CreatorFullNameName of creatorCreatorFullName
sensiblestring
DescriptionDescription of selection codeDescription
string
Division codeDivision
integer
ModifiedLast modified dateModified
datetime
ModifierUser ID of modifierModifier
string
ModifierFullNameName of modifierModifierFullName
sensiblestring
NotesNotesNotes
string
IDPrimary keyID
string
CAD Drawing URLURL to CAD Drawing Specified on General tab shoporderCADDrawingURL
string
CostcenterThe cost center linked to the shop orderCostcenter
string
Costcenter DescriptionDescription of CostcenterCostcenterDescription
string
CostunitThe cost unit linked to the shop orderCostunit
string
Costunit DescriptionDescription of CostunitCostunitDescription
string
CreatedCreation dateCreated
datetime
CreatorUser ID of creatorCreator
string
Creator Full NameName of creatorCreatorFullName
sensiblestring
DescriptionDescription of the shop orderDescription
string
Division codeDivision
integer
Entry DateDate on which the shop order was enteredEntryDate
datetime
Is BatchIndicates if the item created by this shoporder is a batch item or notIsBatch
integer
Is Fraction Allowed ItemIndicates if fractions (for example 0.35) are allowed for quantities of the item created by this shoporderIsFractionAllowedItem
integer
Is In PlanningIndicator that Shop order is in planningIsInPlanning
integer
Is On HoldIndicator if the Shop order is on holdIsOnHold
integer
Is ReleasedIndicator that the Shop order has been released to productionIsReleased
integer
Is SerialDoes the material plan's item use serial numbersIsSerial
integer
ItemReference to the item created by this shoporderItem
string
Item CodeCode of the item created by this shop orderItemCode
string
Item DescriptionDescription of the item created by this shop orderItemDescription
string
Item VersionReference to ItemVersionItemVersion
string
Item Version DescriptionDescription of Item VersionItemVersionDescription
string
ModifiedLast modified dateModified
datetime
ModifierUser ID of modifierModifier
string
Modifier Full NameName of modifierModifierFullName
sensiblestring
NotesNotes - only viewed internallyNotes
string
Planned DatePlanned end date of this shop orderPlannedDate
datetime
Planned QuantityPlanned quantityPlannedQuantity
float
Planned Start DatePlanned start date of this shop orderPlannedStartDate
datetime
Produced QuantityQuantity finishedProducedQuantity
float
Production Lead DaysProduction lead daysProductionLeadDays
float
Reference to ProjectProject
string
Project DescriptionDescription of ProjectProjectDescription
string
Ready To Ship QuantityQuantity ready to shipReadyToShipQuantity
float
Sales Order Line CountNumber of sales orders linked to this shop orderSalesOrderLineCount
integer
Selection CodeID of selection codeSelectionCode
string
Selection Code CodeCode of Selection codeSelectionCodeCode
string
Selection Code DescriptionDescription of Selection codeSelectionCodeDescription
string
Shop Order By Product Plan Backflush CountNumber of shop order by-product plans, which are backflushed, for this shop orderShopOrderByProductPlanBackflushCount
float
Shop Order By Product Plan CountNumber of shop order by-product plans for this shop orderShopOrderByProductPlanCount
float
Shop Order MainShop order mainShopOrderMain
string
Shop Order Main NumberShop order main numberShopOrderMainNumber
float
Shop Order Material Plan Backflush CountNumber of shop order material plans, which are backflushed, for this shop orderShopOrderMaterialPlanBackflushCount
float
Shop Order Material Plan CountNumber of shop order material plans for this shop orderShopOrderMaterialPlanCount
float
Shop Order NumberUnique number to indentify the shop orderShopOrderNumber
integer
Shop Order ParentShop order parentShopOrderParent
string
Shop Order Parent NumberShop order parent numberShopOrderParentNumber
float
Shop Order Routing Step Plan CountNumber of shop order routing step plans for this shop orderShopOrderRoutingStepPlanCount
float
StatusIndicates the status of the Shop Order: 10 Open, 20 In process, 30 Finished, 40 CompletedStatus
integer
Sub Shop Order CountThe count of material lines of this shop order, which have been linked to a sub orderSubShopOrderCount
float
TypeType of shoporder: always 9040 RegularType
float
UnitUnit of the item created by this shop orderUnit
string
Unit DescriptionUnit description of the unit of the item created by this shop orderUnitDescription
string
WarehouseReference to the Warehouse associated with the Shop orderWarehouse
string
Your RefYour referenceYourRef
string
IDIdentifier of the payment.ID
string
Account CodeThe code of the supplier to which the payment has to be doneAccountCode
string
The supplier to which the payment has to be doneAccount
string
Account NameName of the supplierAccountName
string
Account ContactContact person copied from the purchase invoice linked to the related purchase entryAccountContact
string
Account Contact NameName of the contact person of the supplierAccountContactName
sensiblestring
Account Bank Account NumberThe bank account of the supplier, to which the payment has to be doneAccountBankAccountID
string
Account Bank Account NumberThe bank account number of the supplier, to which the payment has to be doneAccountBankAccountNumber
string
Amount Discount DCThe amount of the discount in the default currencyAmountDiscountDC
float
Amount Discount FCThe amount of the discount in the amount of the selected currency.AmountDiscountFC
float
Amount DCThe amount in default currency (division currency)AmountDC
float
Amount FCThe amount of the payment in the amount of the selected currencyAmountFC
float
Bank AccountIDOwn bank account from which the payment must be doneBankAccountID
string
Bank Account NumberOwn bank account number from which the payment must be doneBankAccountNumber
string
Payment Due DateDate before which the payment must be doneDueDate
datetime
Division codeDivision
integer
Creation dateCreation dateCreated
datetime
CreatorUser ID of the creatorCreator
string
Creator Full NameName of the creatorCreatorFullName
sensiblestring
End DateDate since when the payment is no longer an outstanding itemEndDate
datetime
CurrencyThe currency of the paymentCurrency
string
DescriptionExtra description for the payment that may be included in the bank export fileDescription
string
G/L account of the paymentGLAccount
string
G/L Account CodeCode of the G/L accountGLAccountCode
integer
G/L Account DescriptionDescription of the G/L accountGLAccountDescription
string
Invoice DateInvoice date of the linked transactionInvoiceDate
datetime
Invoice NumberInvoice number of the linked transactionInvoiceNumber
string
JournalJournal of the linked transactionJournal
string
Journal DescriptionDescription of the journalJournalDescription
string
ModifiedLast modified dateModified
datetime
ModifierUser ID of modifierModifier
string
Payment ConditionPayment condition of the linked transactionPaymentCondition
string
Payment Condition DescriptionDescription of the payment conditionPaymentConditionDescription
string
Payment DaysNumber of days between invoice date and due datePaymentDays
float
Payment Days DiscountNumber of days between invoice date and due date of the discountPaymentDaysDiscount
CreateAutoCorrectionConfirmation: Create Auto CorrectionWhen the 'payroll run' already finalized and the update is made to the employment contract start date, the system will first block the PUT action with the message below. With the 'PayrollCorrection' right, the error message below will be thrown: This change will lead to a recalculation of previous periods. A correction request will be created with the following data: Activation date: 01-01-2019 Payroll year: 2019 Period: 1 If you are confirmed want to proceed, set the [CreateAutoCorrection] to True and re-submit the request. Without the 'PayrollCorrection' right, the error message below will be thrown: You do not have rights to change data that can influence processed payroll transactions. Note : If you delete this contract in an already calculated period, auto corrections will be created for this employee.CreateAutoCorrection
boolean
CreatedCreation dateCreated
datetime
CreatePredecessorsForLinkedAgenciesConfirmation: Create Predecessors For Linked AgenciesThe system will block the POST/PUT action when one of the condition below fulfilled: When create (POST) a new successor, the employment contract successor start date is set to an earlier payroll year. When update (PUT) the existing employment contract start date to an earlier payroll year. The error message below will be thrown: Attention: If you change the start date to an earlier payroll year, predecessors will be created for linked agencies. You will have to check if the data of the predecessors is correct. If you are confirmed want to proceed, set the [CreatePredecessorsForLinkedAgencies] to True and re-submit the request.CreatePredecessorsForLinkedAgencies
boolean
CreatorUser ID of creatorCreator
string
CreatorFullNameName of creatorCreatorFullName
sensiblestring
Division codeDivision
integer
DocumentDocument ID of the employment contractDocument
StartDateStart date of employment contractNote : Be aware that for PUT, when you use a start date in the past it will also update years in service to this date.StartDate
WarehouseID of warehouse to receive the returning itemsWarehouse
string
WarehouseCodeCode of warehouse to receive the returning itemsWarehouseCode
string
WarehouseDescriptionDescription of warehouse to receive the returning itemsWarehouseDescription
string
The balance sheet accountGLAccount
string
Division codeDivision
integer
Reporting YearThe reporting year of the opening balanceReportingYear
integer
AmountThe opening balance amount of the G/L accountAmount
float
Balance SideIndicates whether the G/L account is a debit or credit accountBalanceSide
string
G/L Account CodeThe code of the G/L accountGLAccountCode
string
G/L Account DescriptionThe description of the G/L accountGLAccountDescription
string
Item IDGUID id of the item that is linked to the projectItemId
string
ItemDescriptionDescription of the item that is linked to the projectItemDescription
string
IDPrimary keyID
string
AmountAmount in the currency of the transactionAmount
float
CreatedDate and time when the invoice term was createdCreated
datetime
CreatorID of user that created the invoice termCreator
string
Creator FullNameFull name of user that created the recordCreatorFullName
sensiblestring
DeliverableWBS's deliverable linked to the invoice termDeliverable
string
DescriptionDescription of invoice termDescription
string
Division codeDivision
integer
Execution From DateExecution date: From of invoice termExecutionFromDate
datetime
Execution To DateExecution date: To of invoice termExecutionToDate
datetime
Invoice DateInvoice date of invoice termInvoiceDate
datetime
ID of sales invoiceInvoiceId
string
Invoice StatusThe invoice status of the invoice term. E.g: 10 = Draft, 20 = Open, 30 = Processing..., 50 = ProcessedInvoiceStatus
integer
ItemItem that linked to the invoice termItem
string
Item DescriptionDescription of item that linked to the invoice termItemDescription
string
ModifiedLast modified date of invoice termModified
datetime
ModifierID of user that modified the recordModifier
string
Modifier FullNameFull name of user that modified the recordModifierFullName
sensiblestring
NotesNotes linked to the invoice term for providing additional informationNotes
string
PercentagePercentage of amount per project's budgeted amountPercentage
string
ID of project that linked to the invoice termProject
string
Project DescriptionProject description that linked to the invoice termProjectDescription
string
VAT CodeVAT code that used in the invoice termVATCode
string
VAT Code DescriptionDescription of VAT code that used in the invoice termVATCodeDescription
string
VAT PercentagePercentage of VAT code that used in the invoice termVATPercentage
float
WBSID of WBS that linked to the invoice termWBS
string
IDPrimary keyID
string
AccountGuid ID of account that is linked to the projectAccount
string
Account NameName of account that is linked to the projectAccountName
string
ActivityGuid ID of activity that is linked to project WBS (work breakdown structure)Activity
string
Activity DescriptionName of activity that is linked to project WBS (work breakdown structure)ActivityDescription
string
Amount FCCalculated amount of the transaction based on (Quantity * PriceFC)AmountFC
float
AttachmentAttachment linked to the transactionAttachment
string
CreatedDate and time the transaction was createdCreated
datetime
CreatorThe Guid ID of user that created the transactionCreator
string
Creator Full NameThe full name of the user that created the recordCreatorFullName
sensiblestring
CurrencyCurrency of amount FCCurrency
string
DateDate and time the time transaction was doneDate
datetime
Division codeDivision
integer
Division DescriptionDescription of DivisionDivisionDescription
string
Guid ID of the employee that is linked to the time transactionEmployee
string
Entry NumberNumber that represents the grouping of time transactionsEntryNumber
float
Error TextTo determine which transaction has an errorErrorText
string
Hour StatusStatus of the transaction: 1 = Draft, 2 = Rejected, 10 = Submitted, 11 = Failed on approval, 14 = Processing, 16 = Processing, 19 = Failed while undoing approval, 20 = FinalHourStatus
float
ItemItem that is linked to the transaction, which provides the time informationItem
string
Item DescriptionDescription of the item that is linked to the transactionItemDescription
string
Item DivisableIndicates if fractional quantities of the item can be used, for example quantity = 0.4ItemDivisable
boolean
ModifiedThe date and time transaction record was modifiedModified
datetime
ModifierThe Guid ID of the user that modified the recordsModifier
string
Modifier Full NameThe full name of the user that modified the recordModifierFullName
sensiblestring
NotesNotes linked to the transaction for providing additional informationNotes
string
Price FCFor use in AmountFC (Quantiy * Price FC)PriceFC
float
ProjectGuid ID of project that is linked to the transactionProject
string
Project AccountProject account ID that is linked to the transactionProjectAccount
string
Project Account CodeProject account code that is linked to the transactionProjectAccountCode
string
Project Account NameProject account name that is linked to the transactionProjectAccountName
string
Project CodeProject code that is linked to the transactionProjectCode
string
Project DescriptionProject description that is linked to the transactionProjectDescription
string
QuantityQuantity of the item that is linked to the transactionQuantity
float
TypeThe type of transactionType
float
IDPrimary keyID
string
BudgetNumber of hours to be budgeted to a projectBudget
float
CreatedDate and time when the project hour budget was createdCreated
datetime
Division codeDivision
integer
ItemId of hour type of budgetItem
string
ItemcodeCode of hour typeItemCode
string
ItemdescriptionDescription of hour typeItemDescription
string
ModifiedLast modified date of project hour budgetModified
datetime
ProjectProject ID that the budgeted hours is referenced toProject
string
ProjectcodeProject code that the budgeted hours is referenced toProjectCode
string
ProjectdescriptionProject description that the budgeted hours is referenced toProjectDescription
string
IdPrimary keyID
string
AccountGuid ID of account that is linked to the projectAccount
string
Account NameName of account that is linked to the projectAccountName
string
AmountFCCalculated amount of the transaction based on (Quantity * PriceFC)AmountFC
float
DateDate and time the cost transaction was doneDate
datetime
ExpenseProjectWBS (work breakdown structure) type 3Expense
string
Expense DescriptionDescription of ProjectWBS ExpenseExpenseDescription
string
Hour StatusStatus of the transactionHourStatus
integer
Item DescriptionDescription of the item that is linked to the transactionItemDescription
string
NotesNotes linked to the transaction for providing additional informationNotes
string
PriceFCFor use in AmountFC (Quantiy * Price FC)PriceFC
float
ProjectProject that is linked to the transactionProject
string
Project AccountProject account ID that is linked to the transaction (not mandatory)ProjectAccount
string
Project Account NameProject account name that is linked to the transactionProjectAccountName
string
ProjectDescriptionProject description that is linked to the transactionProjectDescription
string
QuantityQuantity of the item that is linked to the transactionQuantity
float
TypeThe type of transaction. E.g: Time = 1, Cost = 2Type
integer
IDPrimary keyID
string
AccountThe account for this projectAccount
string
Account CodeCode of AccountAccountCode
string
Account NameName of AccountAccountName
string
BGTStatusStatus of the background task for project planning, 1 = To be processed, 2 = Processed, 3 = FailedBGTStatus
boolean
Communication Error StatusStatus of the external calender linked to project planning, 0 = No error, 1 = Credentials error, 2 = Technical error, 3 = Both credentials & technical errors, 4 = In progressCommunicationErrorStatus
float
CreatedDate and time the record was createdCreated
datetime
CreatorThe GUID ID of the user that created the project planningCreator
string
Creator Full NameThe full name of the user that created the project planningCreatorFullName
sensiblestring
DescriptionThe description of the project planningDescription
string
Division codeDivision
integer
EmployeeThe GUID ID of the employee that is linked to the project planningEmployee
string
EmployeeCodeThe code of the employee that is linked to the project planningEmployeeCode
string
Employee HIDThe numeric ID of the employee that is linked to the project planningEmployeeHID
string
HoursHours planned for the employeeHours
float
Hour TypeThe type of hours entered for the project planning, item with 'Time' typeHourType
string
Hour Type CodeThe code of the item with 'Time' type that is used in project planning, can be used for searching for hour typeHourTypeCode
string
Hour Type DescriptionThe description of the item with 'Time' type that is used in project planningHourTypeDescription
string
Is Broken RecurrenceIndicates whether the project planning is separated from the recurring planningIsBrokenRecurrence
boolean
ModifiedDate the project planning record was modifiedModified
datetime
ModifierThe ID of the user that modified the project planning recordsModifier
string
Modifier Full NameThe full name of the user that modified the project planning recordModifierFullName
sensiblestring
NotesAdditional information on this project planning recordNotes
string
Over AllocateIndicates whether the entries can have over allocated planning hoursOverAllocate
boolean
Start DateStart date of the project planningStartDate
datetime
Project ID that is linked to the planningProject
string
Project CodeProject code that is linked to the planningProjectCode
string
Project DescriptionProject description that is linked to the planningProjectDescription
string
Project Planning RecurringRecurring planning linked to project planningProjectPlanningRecurring
string
Project WBSReferenced project work break down structure ID that is linked to the project planningProjectWBS
string
Project WBS DescriptionReferenced project work break down structure description that is linked to the project planningProjectWBSDescription
string
StatusStatus of the project planning, 1 = Reserved, 2 = PlannedStatus
integer
TypeType of project planning, it will always be 4 for employeeType
integer
End DateThe end date of the project planning, this is to indicate when the planning ends. E.g: End of a projectEndDate
datetime
CreatedDate and time when the project restriction was createdCreated
datetime
CreatorID of user that created the project restrictionCreator
string
Creator Full NameFull name of user that created the project restrictionCreatorFullName
sensiblestring
Division codeDivision
integer
IDIDID
string
ModifiedSLast date when the project restriction was modifiedModified
datetime
ModifierID of user that modified the project restrictionModifier
string
Modifier Full NameFull name of user that modified the project restrictionModifierFullName
sensiblestring
Project ID that the restriction is referenced toProject
string
Project CodeProject code that the restriction is referenced toProjectCode
string
Project DescriptionProject description that the restriction is referenced toProjectDescription
string
The guid ID of the employee restricted to the project for hour entryEmployee
string
Employee Full NameThe full name in string of the employee restricted to the project for hour entryEmployeeFullName
sensiblestring
Employee HIDThe HID of the employee restricted to the project for hour entryEmployeeHID
integer
IDPrimary keyID
string
AccountThe account for this projectAccount
string
Account CodeCode of AccountAccountCode
string
Account ContactContact person of AccountAccountContact
string
Account NameName of AccountAccountName
string
Allow Additional InvoicingIndicates if additional invoice is allowed for projectAllowAdditionalInvoicing
Budget Type DescriptionBudget type descriptionBudgetTypeDescription
string
Budgeted AmountBudgeted amount of sales in the default currency of the companyBudgetedAmount
float
Budgeted CostsBudgeted amount of costs in the default currency of the companyBudgetedCosts
float
Budgeted RevenueBudgeted amount of revenue in the default currency of the companyBudgetedRevenue
float
ClassificationUsed only for PSA to link a project classification to the projectClassification
string
Classification DescriptionDescription of ClassificationClassificationDescription
string
CodeCodeCode
string
Costs Amount FCUsed only for PSA to store the budgetted costs of a projectCostsAmountFC
float
CreatedCreation dateCreated
datetime
CreatorUser ID of creatorCreator
string
Creator Full NameName of creatorCreatorFullName
sensiblestring
Customer PO numberUsed only for PSA to store the customer's PO numberCustomerPOnumber
string
DescriptionDescription of the projectDescription
string
Division codeDivision
integer
Division NameName of DivisionDivisionName
string
Fixed Price ItemItem used for fixed price invoicing. To be defined per project. If empty the functionality relies on the setting.FixedPriceItem
string
Fixed Price Item DescriptionDescription of FixedPriceItemFixedPriceItemDescription
string
Internal NotesInternal notes not to be printed in invoiceInternalNotes
string
Invoice As QuotedIndicates whether the project is invoice as quotedInvoiceAsQuoted
boolean
ManagerResponsible person for this projectManager
string
Manager Full NameName of ManagerManagerFullname
sensiblestring
Prepaid ItemUsed only for PSA. This item is used for prepaid invoicing.PrepaidItem
float
Prepaid Item DescriptionDescription of PrepaidItemPrepaidItemDescription
string
Prepaid TypePrepaidType: 1-Retainer, 2-Hour type bundlePrepaidType
float
Prepaid Type DescriptionDescription of PrepaidTypePrepaidTypeDescription
string
Sales Time QuantityBudgeted time. Total number of hours estimated for the fixed price project.SalesTimeQuantity
float
Source QuotationSource quotationSourceQuotation
string
Start DateStart date of a projectStartDate
datetime
Time Quantity To AlertAlert when exceeding (Hours)TimeQuantityToAlert
string
TypeReference to ProjectTypesType
float
Type DescriptionDescription of TypeTypeDescription
string
Use Billing MilestonesIndicates whether the Project is using billing milestonesUseBillingMilestones
boolean
End DateEnd date of the projectEndDate
datetime
IDA guid that uniquely identifies the purchase invoice lineID
string
ModifiedThe date and time the invoice line was last modifiedModified
datetime
AmountThe amount including VAT in the currency of the invoiceAmount
float
Cost CenterThe code of the cost center that is linked to this invoice lineCostCenter
string
Cost UnitThe code of the cost unit that is linked to this invoice lineCostUnit
string
CurrencyThe currency of the line amount. The total invoice amount and all individual line amounts are in the same currencyCurrency
string
DescriptionDescription of the invoice lineDescription
string
DiscountThe discount given on the default price. A value of 0.1 translates to 10% discountDiscount
float
ExpenseExpense related to the Work Breakdown Structure of the selected project. Only available with a professional service licenseExpense
string
Expense DescriptionDescription of expense. Only available with a professional service licenseExpenseDescription
string
Invoice IDThe unique identifier of the purchase invoice this line belongs toInvoiceId
string
ItemGuid that identifies the purchase itemItem
string
Item UnitThe default unit of the purchased itemItemUnit
string
Line NumberThe sequence number of the lineLineNumber
integer
Net PriceThe net price that has to be paid per unit. NetPrice = UnitPrice * (1.0 - Discount)NetPrice
float
The project linked to the purchase invoice lineProject
string
QuantityThe number of purchased items in purchase unitsQuantity
float
Quantity in Default UnitsThe number of purchased items in default unitsQuantityInDefaultUnits
float
RebillIndicates whether the purchase invoice line needs to be rebilledRebill
integer
Purchase Order LineGuid that identifies the purchase order line that is being invoicedPurchaseOrderLine
string
UnitThe code of the unit in which the item is purchasedUnit
string
Unit PriceThe default purchase price per unitUnitPrice
float
VAT AmountThe VAT amount of the invoice lineVATAmount
float
VAT CodeThe VAT code used for the invoice line.VATCode
string
VAT percentageThe VAT percentageVATPercentage
float
IDA guid that is the unique identifier of the purchase invoiceID
string
AmountThe amount including VAT in the currency of the invoiceAmount
float
Invoice DateThe date on which the supplier entered the invoiceInvoiceDate
datetime
Due DateThe date before which the invoice has to be paidDueDate
datetime
ModifiedLast modified dateModified
datetime
Contact PersonGuid identifying the contact person of the supplierContactPerson
string
CurrencyThe code of the currency of the invoiced amountCurrency
string
DescriptionThe description of the invoiceDescription
string
DocumentGuid identifying a document that is attached to the invoiceDocument
string
Entry NumberThe unique number of the purchase invoiceEntryNumber
integer
Exchange RateThe exchange rate between the invoice currency and the default currency of the divisionExchangeRate
float
Financial PeriodThe financial period in which the invoice is enteredFinancialPeriod
integer
Financial YearThe financial year in which the invoice is enteredFinancialYear
integer
JournalThe code of the purchase journal in which the invoice is enteredJournal
string
Payment ConditionThe code of the payment condition that is used to calculate the due date and discountPaymentCondition
string
Payment ReferenceUnique reference to match payments and invoicesPaymentReference
string
RemarksThe user can enter remarks related to the invoice hereRemarks
string
SourceIndicates the origin of the invoiceSource
string
StatusThe status of the invoiceStatus
integer
SupplierGuid that identifies the supplierSupplier
string
TypeIndicates the type of the purchase invoiceType
integer
VAT AmountThe total VAT amount of the purchase invoiceVATAmount
float
WarehouseGuid that identifies the warehouse that will receive the purchased goodsWarehouse
string
IDPrimary Key. The unique identifier of a stock transaction for a goods receipt line. A goods receipt line can be split into multiple storage locations. In this case, multiple storage locations will have the same stock transaction ID.ID
string
BatchNumbersCollection of batch numbersBatchNumbers
string
CreatedCreation dateCreated
datetime
CreatorUser ID of the creatorCreator
string
CreatorFullNameName of the creatorCreatorFullName
sensiblestring
DescriptionGoods receipt line descriptionDescription
string
Division codeDivision
integer
ExpenseExpense related to the Work Breakdown Structure of the selected project. Only available with a professional service licenseExpense
string
ExpenseDescriptionDescription of expense. Only available with a professional service licenseExpenseDescription
string
GoodsReceiptIDAll the lines of a goods receipt have the same GoodsReceiptIDGoodsReceiptID
sensiblestring
ItemID of the received itemItem
sensiblestring
ItemCodeCode of the received itemItemCode
sensiblestring
ItemDescriptionItem descriptionItemDescription
string
ItemUnitCodeUnit code of the purchaseItemUnitCode
sensiblestring
LineNumberLine numberLineNumber
sensibleinteger
LocationID of the storage location in the warehouse where the item is receivedLocation
string
LocationCodeCode of the storage location in the warehouse where the item is receivedLocationCode
sensiblestring
LocationDescriptionDescription of the storage location in the warehouse where the item is receivedLocationDescription
string
ModifiedLast modified dateModified
datetime
ModifierUser ID of the last modifierModifier
string
ModifierFullNameName of the last modifierModifierFullName
DescriptionDescription of the goods receiptDescription
string
Division codeDivision
integer
DocumentDocument that is linked to the goods receiptDocument
sensiblestring
DocumentSubjectDocument subjectDocumentSubject
string
EntryNumberEntry number of the resulting stock entryEntryNumber
sensibleinteger
GoodsReceiptLineCountTotal row count of linesGoodsReceiptLineCount
integer
GoodsReceiptLinesCollection of receipt linesGoodsReceiptLines
string
ModifiedLast modified dateModified
datetime
ModifierUser ID of the last modifierModifier
string
ModifierFullNameName of the last modifierModifierFullName
sensiblestring
ReceiptDateDate of the goods receiptReceiptDate
datetime
ReceiptNumberReceipt numberReceiptNumber
sensibleinteger
RemarksReceipt noteRemarks
string
SupplierAccount ID of the supplierSupplier
string
SupplierCodeSupplier codeSupplierCode
string
SupplierContactID of the contact person at the supplierSupplierContact
sensiblestring
SupplierContactFullNameName of the contact person at the supplierSupplierContactFullName
sensiblestring
SupplierNameSupplier nameSupplierName
sensiblestring
WarehouseWarehouse IDWarehouse
string
WarehouseCodeWarehouse codeWarehouseCode
string
WarehouseDescriptionDescription of the warehouseWarehouseDescription
string
YourRefThe purchase invoice number provided by the supplierYourRef
string
IDPrimary keyID
string
AmountDCAmount in the default currency of the companyAmountDC
float
AmountFCAmount in the currency of the transactionAmountFC
float
CostCenterReference to Cost centerCostCenter
string
CostCenterDescriptionDescription of CostCenterCostCenterDescription
string
CostUnitReference to Cost unitCostUnit
string
CostUnitDescriptionDescription of CostUnitCostUnitDescription
string
CreatedCreation dateCreated
datetime
CreatorUser ID of creatorCreator
string
CreatorFullNameName of creatorCreatorFullName
sensiblestring
CustomFieldCustom field endpoint. Provided only for the Exact Online Premium users.CustomField
string
DescriptionDescription of the purchase order lineDescription
string
DiscountDiscount in percentage for itemDiscount
float
Division codeDivision
integer
ExpenseExpense related to the Work Breakdown Structure of the selected project. Only available with a professional service licenseExpense
string
ExpenseDescriptionDescription of expense. Only available with a professional service licenseExpenseDescription
string
InStockThe current stock level of items shown in stock unit. The information is displayed only for items with the stock property selected.InStock
float
InvoicedQuantityQuantity of item that has been invoicedInvoicedQuantity
float
IsBatchNumberItemIndicates that an Item is an batch itemIsBatchNumberItem
string
IsSerialNumberItemIndicates that an Item is an serial itemIsSerialNumberItem
string
ItemReference to the item for purchase orderItem
string
ItemBarcodeBarcode of the item (numeric string)ItemBarcode
sensiblestring
ItemBarcodeAdditionalThis is the barcode for the unit other than standard unit of the item. Only supported by the Premium for Wholesale & Distribution and ManufacturingItemBarcodeAdditional
string
ItemCodeItem codeItemCode
sensiblestring
ItemDescriptionDescription of itemItemDescription
string
ItemDivisableIndicates if fractional quantities of the item can be used, for example quantity = 0.4ItemDivisable
boolean
LineNumberLine numberLineNumber
sensibleinteger
ModifiedLast modified dateModified
datetime
ModifierUser ID of modifierModifier
string
ModifierFullNameName of modifierModifierFullName
sensiblestring
NetPriceThe net price is the unit price (VAT code taken into account) with any discount appliedNetPrice
float
NotesNotesNotes
string
ProjectReference to project. Only available with a professional service licenseProject
string
ProjectCodeProject code. Only available with a professional service licenseProjectCode
sensiblestring
ProjectDescriptionDescription of the project. Only available with a professional service licenseProjectDescription
string
ProjectedStockThe current stock level + the planned quantity to be received - the planned quantity to deliver shown in stock unit.ProjectedStock
float
PurchaseOrderIDIdentifies the purchase order. All the lines of a purchase order have the same PurchaseOrderIDPurchaseOrderID
sensiblestring
QuantityQuantity in item unitsQuantity
float
QuantityInPurchaseUnitsQuantity in purchase units. Use this field when creating a purchase orderQuantityInPurchaseUnits
float
RebillIndicates whether the purchase order line needs to be rebilled. Only available with a professional service licenseRebill
boolean
ReceiptDateDate the goods are expected to be receivedReceiptDate
datetime
ReceivedQuantityQuantity of goods receivedReceivedQuantity
float
SalesOrderSales order that is linked to a back to back sales order in purchase order. Show NULL if more than one sales order is linked to the purchase order line.SalesOrder
string
SalesOrderLineSales order line of the sales order that Is linked to a back to back sales order in purchase order. Show NULL if more than one sales order is linked to the purchase order line.SalesOrderLine
string
SalesOrderLineNumberNumber of the sales order line. Show NULL if more than one sales order is linked to the purchase order line.SalesOrderLineNumber
sensibleinteger
SalesOrderNumberNumber of the sales order. Show NULL if more than one sales order is linked to the purchase order line.SalesOrderNumber
sensibleinteger
ShopOrderObsolete. Please use "ShopOrderMaterialPlans" or "ShopOrderRoutingStepPlans" property.ShopOrder
string
ShopOrderMaterialPlanObsolete. Please use "ShopOrderMaterialPlans" property.ShopOrderMaterialPlan
string
ShopOrderMaterialPlanLineNumberObsolete. Please use "ShopOrderMaterialPlans" property.ShopOrderMaterialPlanLineNumber
sensibleinteger
ShopOrderMaterialPlansCollection of Shop order Material plansShopOrderMaterialPlans
string
ShopOrderNumberObsolete. Please use "ShopOrderMaterialPlans" or "ShopOrderRoutingStepPlans" property.ShopOrderNumber
sensibleinteger
ShopOrderRoutingStepPlanObsolete. Please use "ShopOrderRoutingStepPlans" property.ShopOrderRoutingStepPlan
string
ShopOrderRoutingStepPlanLineNumberObsolete. Please use "ShopOrderRoutingStepPlans" property.ShopOrderRoutingStepPlanLineNumber
sensibleinteger
ShopOrderRoutingStepPlansCollection of Shop order Routing step plansShopOrderRoutingStepPlans
string
SupplierItemCodeCode the supplier uses for this itemSupplierItemCode
sensiblestring
SupplierItemCopyRemarksIndicate if the notes content should be copied from SupplierItem's remarks. The default follows the CopyRemarks value from SupplierItem. Values: 0 = Do not copy remark, 1 = Copy remarkSupplierItemCopyRemarks
string
UnitCode of item unitUnit
sensiblestring
UnitDescriptionDescription of unitUnitDescription
string
UnitPriceItem price per purchase unitUnitPrice
float
VATAmountAmount of VAT charges calculated from total amount and vat percentageVATAmount
float
VATCodeThe VAT code used when the invoice was registeredVATCode
sensiblestring
VATDescriptionDescription of vat codeVATDescription
string
VATPercentageThe VAT percentage of the VAT code. This is the percentage at the moment the invoice is created. It's also used by the default calculation of VAT amounts and VAT base amountsVATPercentage
float
IDPrimary keyID
string
BatchNumbersCollection of batch numbersBatchNumbers
string
CreateCreditCredit noteCreateCredit
boolean
CreatedCreation dateCreated
datetime
CreatorUser ID of the creatorCreator
string
CreatorFullNameName of the creatorCreatorFullName
sensiblestring
Division codeDivision
integer
EntryIDEntryID identifies the purchase return. All the lines of purchase return have the same Entry IDEntryID
sensiblestring
ExpenseExpense related to the Work Breakdown Structure of the selected project. Only available with a professional service licenseExpense
string
ExpenseDescriptionDescription of expense. Only available with a professional service licenseExpenseDescription
string
GoodsReceiptLineIDID of the goods receipts lineGoodsReceiptLineID
sensiblestring
ItemThe unique identifier of the item being returnedItem
string
ItemCodeCode of the returned itemItemCode
sensiblestring
ItemDescriptionItem DescriptionItemDescription
string
LineNumberLineNumberLineNumber
sensibleinteger
LocationID of the storage location in the warehouse where the item is returnedLocation
string
LocationCodeCode of the storage location in the warehouse where the item is returnedLocationCode
sensiblestring
LocationDescriptionDescription of the storage location in the warehouse where the item is returnedLocationDescription
string
ModifiedLast modified dateModified
datetime
ModifierUser ID of the last modifierModifier
string
ModifierFullNameName of the last modifierModifierFullName
sensiblestring
NotesNotes related to the returnNotes
string
ProjectReference to project. Only available with a professional service licenseProject
string
ProjectCodeProject code. Only available with a professional service licenseProjectCode
sensiblestring
ProjectDescriptionDescription of the project. Only available with a professional service licenseProjectDescription
string
PurchaseOrderLineIDID of the purchase order line that is returnedPurchaseOrderLineID
sensiblestring
PurchaseOrderNumberOrder number of the purchase order that is returnedPurchaseOrderNumber
sensibleinteger
RebillIndicates whether the purchase order line needs to be rebilled. Only available with a professional service licenseRebill
boolean
ReceiptNumberReceipt number of the returnReceiptNumber
sensibleinteger
ReceivedQuantityQuantity receivedReceivedQuantity
float
ReturnQuantityQuantity returnedReturnQuantity
float
ReturnReasonCodeDescriptionDescription of ReasonCodeReturnReasonCodeDescription
string
ReturnReasonCodeIDIndicates the reason why the purchase was returnedReturnReasonCodeID
sensiblestring
SerialNumbersCollection of serial numbersSerialNumbers
Starter Sales Invoice Status DescriptionDescription of StarterSalesInvoiceStatusStarterSalesInvoiceStatusDescription
string
StatusThe status of the entryStatus
integer
Status DescriptionDescription of StatusStatusDescription
string
TypeIndicates the type of invoiceType
integer
Type DescriptionDescription of the typeTypeDescription
string
VAT Amount DCTotal VAT amount in the default currency of the companyVATAmountDC
float
VAT Amount FCTotal VAT amount in the currency of the transactionVATAmountFC
float
WarehouseMandatory for direct sales invoice/credit note, cannot be set for normal sales invoice/credit noteWarehouse
string
Withholding Tax Amount FCWithholding tax amount applied to sales invoice. Not supported in The Netherlands.WithholdingTaxAmountFC
float
Withholding Tax Base AmountWithholding tax base amount to calculate withholding amount. Not supported in The Netherlands.WithholdingTaxBaseAmount
float
Your ReferenceThe invoice number of the customerYourRef
string
IDPrimary keyID
string
ActiveActiveActive
boolean
CodeCode of the sales channelCode
string
CreatedCreation dateCreated
datetime
CreatorUser ID of creatorCreator
string
CreatorFullNameName of creatorCreatorFullName
sensiblestring
DescriptionDescription of sales channelDescription
string
Division codeDivision
integer
ModifiedLast modified dateModified
datetime
ModifierUser ID of modifierModifier
string
ModifierFullNameName of modifierModifierFullName
sensiblestring
NotesNotesNotes
string
IDPrimary key. Price list IDID
string
CodePrice list codeCode
string
CreatedCreation dateCreated
datetime
CreatorUser ID of creatorCreator
string
CreatorFullNameName of creatorCreatorFullName
sensiblestring
CurrencyAll prices in the price list are stored in this currencyCurrency
string
DescriptionPrice list descriptionDescription
string
Division codeDivision
integer
EntityIndicates the entity (1 - Item, 2 - Item group) on which this price list is basedEntity
integer
ModifiedLast modified dateModified
datetime
ModifierUser ID of modifierModifier
string
ModifierFullNameName of modifierModifierFullName
sensiblestring
NotesExplanation or extra information can be stored in the notesNotes
string
TypeIndicates the type (1 - Customer, 2 - Standard) on which this price list appliesType
integer
IDPrimary keyID
string
TimestampTimestampTimestamp
integer
Amount DCAmount in the default currency of the company. For almost all lines this can be calculated like: AmountDC = AmountFC * RateFCAmountDC
float
Amount DiscountDiscount amount in the default currency of the company. Only supported for headerAmountDiscount
float
Amount Discount Excl VatDiscount amount exclude VAT in the default currency of the company. Only supported for headerAmountDiscountExclVat
float
Amount FCFor normal lines it's the amount excluding VATAmountFC
float
Amount FC Excl VatSum of all lines, excluding VAT. Only supported for headerAmountFCExclVat
float
Cost CenterReference to Cost centerCostCenter
string
Cost Center DescriptionDescription of CostCenterCostCenterDescription
string
Cost UnitReference to Cost unitCostUnit
string
Cost Unit DescriptionDescription of CostUnitCostUnitDescription
string
CreatedCreation dateCreated
datetime
CreatorUser ID of creatorCreator
string
Creator Full NameName of creatorCreatorFullName
sensiblestring
CurrencyCurrency for the invoice. Default this is the currency of the administrationCurrency
string
Customer Item CodeCode the customer uses for this itemCustomerItemCode
string
Custom FieldCustom field endpoint. Provided only for the Exact Online Premium users.CustomField
string
Deliver ToDelivery account for invoiceDeliverTo
string
Deliver To AddressAddress of delivery as per invoice delivery accountDeliverToAddress
string
Deliver To Contact PersonDelivery account person for invoiceDeliverToContactPerson
string
Deliver To Contact Person Full NameName of delivery account's contact person as per invoiceDeliverToContactPersonFullName
sensiblestring
Deliver To NameName of the delivery account's customer as per invoiceDeliverToName
string
Delivery DateDelivery date of an item in a sales invoice. This is used for VAT on prepayments, only if sales order is not used in the license.DeliveryDate
datetime
DescriptionDescription. Can be different for header and linesDescription
string
DiscountDiscount given on the default price. Discount = (DefaultPrice of Item - PriceItem in line) / DefaultPrice of ItemDiscount
float
Discount TypeLeading field of total discount. 1=Discount percentage, 2=Discount amount excl. VAT, 3=Discount amount incl. VAT, 4=Total amount excl. VAT, 5=Total amount incl. VATDiscountType
integer
Division codeDivision
integer
DocumentDocument that is manually linked to the invoiceDocument
string
Document NumberNumber of the documentDocumentNumber
integer
Document SubjectSubject of the documentDocumentSubject
string
Due DateThe due date for payments. This date is calculated based on the EntryDate and the PaymentconditionDueDate
datetime
EmployeeLink to Employee originating from time and cost transactionsEmployee
string
Employee Full NameName of employeeEmployeeFullName
sensiblestring
End TimeEndTime is used to store the last date of a period. EndTime is used in combination with StartTimeEndTime
datetime
Extra Duty Amount FCExtra duty amount in the currency of the transaction. Both extra duty amount and VAT amount need to be specified in order to differ this property from automatically calculated.ExtraDutyAmountFC
float
Extra Duty PercentageExtra duty percentageExtraDutyPercentage
float
G Account Amount FCA positive value of the amount indicates that the amount is to be paid by the customer to your G bank account.In case of a credit invoice the amount should have negative value when retrieved or posted to Exact.GAccountAmountFC
float
GL AccountThe GL Account of the sales invoice line. This field is mandatory. This field is generated based on the revenue account of the item (or the related item group). G/L Account is also used to determine whether the costcenter / costunit is mandatoryGLAccount
string
GL Account DescriptionDescription of GLAccountGLAccountDescription
string
Incoterm AddressAddress of IncotermIncotermAddress
string
Incoterm CodeNo description availableIncotermCode
string
Incoterm VersionVersion of Incoterm. Supported version for Incoterms : 2010, 2020IncotermVersion
integer
Invoice DateOfficial date for the invoice. When the invoice is entered it's equal to the field 'EntryDate'. During the printing process the invoice date can be entered.InvoiceDate
datetime
Invoice IDThe InvoiceID identifies the sales invoice. All the lines of a sales invoice have the same InvoiceIDInvoiceID
string
Invoice NumberAssigned at entry or at printing depending on setting. The number assigned is based on the freenumbers as defined for the Journal. When printing the field InvoiceNumber is copied to the fields EntryNumber and InvoiceNumber of the sales entry.InvoiceNumber
integer
Invoice ToReference to the Customer who will receive the invoiceInvoiceTo
string
Invoice To Contact PersonReference to the Contact person of the customer who will receive the invoiceInvoiceToContactPerson
string
Invoice To Contact Person Full NameName of the contact person of the customer who will receive the invoiceInvoiceToContactPersonFullName
sensiblestring
Invoice To NameName of the customer who will receive the invoiceInvoiceToName
string
Is Extra DutyIndicates whether the invoice has extra dutyIsExtraDuty
boolean
ItemNo description availableItem
string
Item CodeNo description availableItemCode
string
Item DescriptionReference to the item that is sold in this sales invoice lineItemDescription
string
JournalThe journal code. Every invoice should be linked to a sales journal.Journal
string
Journal DescriptionDescription of JournalJournalDescription
string
Line NumberIndicates the sequence of the lines within one invoiceLineNumber
integer
ModifiedLast modified dateModified
datetime
ModifierUser ID of modifierModifier
string
Modifier Full NameName of modifierModifierFullName
sensiblestring
Net PriceNet price of the sales invoice lineNetPrice
float
NotesExtra notesNotes
string
Order DateOrder dateOrderDate
datetime
Ordered ByCustomer who ordered the invoiceOrderedBy
string
Ordered By Contact PersonContact person of customer who ordered the invoiceOrderedByContactPerson
string
Ordered By Contact Person Full NameName of contact person of customer who ordered the invoiceOrderedByContactPersonFullName
sensiblestring
Ordered By NameName of customer who ordered the invoiceOrderedByName
string
Order NumberNumber to identify the order. By default the number is based on a setting for the first free number, but you can post your own number.OrderNumber
integer
Payment ConditionThe payment condition used for due date and discount calculationPaymentCondition
string
Payment Condition DescriptionDescription of PaymentConditionPaymentConditionDescription
string
Payment ReferencePayment reference for sales invoicePaymentReference
string
PricelistPrice listPricelist
string
Pricelist DescriptionDescription of PricelistPricelistDescription
string
ProjectThe project to which the sales transaction line is linked. The project can be different per line. Sometimes also the project in the header is filled although this is not really usedProject
string
Project DescriptionDescription of ProjectProjectDescription
string
Project WBSWBS linked to the sales invoiceProjectWBS
string
Project WBS DescriptionDescription of WBSProjectWBSDescription
string
QuantityThe number of items sold in default units. The quantity shown in the entry screen is Quantity * UnitFactorQuantity
float
RemarksExtra remarksRemarks
string
Sales ChannelID of Sales channel.SalesChannel
string
Sales Channel CodeCode of Sales channel.SalesChannelCode
string
Sales Channel DescriptionDescription of Sales channel.SalesChannelDescription
string
Sales OrderIdentifies the sales order this invoice line is based onSalesOrder
string
Sales Order LineIdentifies the sales order line this sales invoice line is based onSalesOrderLine
string
Sales Order Line NumberThen line number of the sales order line on which this invoice line is based onSalesOrderLineNumber
integer
Sales Order NumberThe order number of the sales order on which this invoice line is based oSalesOrderNumber
integer
SalespersonSales representativeSalesperson
string
Salesperson Full NameName of sales representativeSalespersonFullName
sensiblestring
Starter Sales Invoice StatusStarter Sales invoice status (for starter functionality)StarterSalesInvoiceStatus
integer
Starter Sales Invoice Status DescriptionDescription of StarterSalesInvoiceStatusStarterSalesInvoiceStatusDescription
string
Start TimeStartTime is used to store the first date of a period. StartTime is used in combination with EndTimeStartTime
datetime
StatusThe status of the entry. 10 = draft. During the creation of an invoice draft records occur in the draft modus if during an invoice a new page with lines is triggered. If the user leaves the invoice in an abnormal way the draft invoices can be recovered. Draft invoices are not included in financial reports, balances etc. 20 = open. Open invoices can be changed. New invoices get the status open by default. 50 = processed. Processed invoices can't be changed anymore. Processing is done via printing. Processed invoices can't be reopenedStatus
integer
Status DescriptionDescription of StatusStatusDescription
string
SubscriptionWhen generating invoices from subscriptions, this field records the link between invoice lines and subscription linesSubscription
string
Subscription DescriptionDescription of subscription lineSubscriptionDescription
TypeIndicates the type of invoice Values: 8020 - Sales invoices, 8021 - Sales credit note, 8023 - Direct sales invoice, 8024 - Direct credit note. Type 8023 and 8024 are only supported by the Plus, Professional and Premium for Wholesale & Distribution and ManufacturingType
integer
Type DescriptionDescription of the typeTypeDescription
string
Unit CodeCode of UnitUnitCode
string
Unit DescriptionDescription of UnitUnitDescription
string
Unit PricePrice per unitUnitPrice
float
VAT Amount DCVAT amount in the default currency of the companyVATAmountDC
float
VAT Amount FCVAT amount in the currency of the transactionVATAmountFC
float
VAT CodeThe VAT code that is used when the invoice is registeredVATCode
string
VAT Code DescriptionDescription of VATCodeVATCodeDescription
string
VAT PercentageThe vat percentage of the VAT code. This is the percentage at the moment the invoice is created. It's also used for the default calculation of VAT amounts and VAT base amountsVATPercentage
float
WarehouseMandatory for direct sales invoice/credit note, cannot be set for normal sales invoice/credit note.Warehouse
string
Withholding Tax Amount FCWithholding tax amount applied to sales invoice. Not supported in The Netherlands.WithholdingTaxAmountFC
float
Withholding Tax Base AmountWithholding tax base amount to calculate withholding amount. Not supported in The Netherlands.WithholdingTaxBaseAmount
float
Withholding Tax PercentageWithholding tax percentage applied to sales invoice. Not supported in The Netherlands.WithholdingTaxPercentage
float
Your RefThe invoice number of the customerYourRef
string
Amount DCAmount in the default currency of the companyAmountDC
float
Amount FCAmount in the currency of the transactionAmountFC
float
Cost CenterReference to cost centerCostCenter
string
Cost Center DescriptionDescription of costcenterCostCenterDescription
string
Cost Price FCItem cost priceCostPriceFC
float
Cost UnitReference to cost unitCostUnit
string
Cost Unit DescriptionDescription of costunitCostUnitDescription
string
Customer Item CodeCode the customer uses for this itemCustomerItemCode
string
Delivery DateDelivery date of this lineDeliveryDate
datetime
DescriptionDescriptionDescription
string
DiscountDiscount given on the default price. discount = (defaultprice of item - priceitem in line) / defaultprice of itemDiscount
float
Division codeDivision
integer
IDPrimary keyID
string
Order IDThe orderid identifies the sales order. all the lines of a sales order have the same orderidOrderID
string
ItemReference to the item that is sold in this sales order lineItem
string
Item DescriptionDescription of itemItemDescription
string
Item CodeCode of itemItemCode
string
Item VersionItem versionItemVersion
string
Item Version DescriptionDescription of item versionItemVersionDescription
string
Line NumberLine numberLineNumber
integer
Net PriceNet price of the sales order lineNetPrice
float
NotesExtra notesNotes
string
Order NumberNumber of sales orderOrderNumber
integer
Price ListPrice listPricelist
string
Price List DescriptionDescription of pricelistPricelistDescription
string
The project to which the sales order line is linked. the project can be different per line. sometimes also the project in the header is filled although this is not really usedProject
string
Project DescriptionDescription of projectProjectDescription
string
Purchase OrderPurchase order that is linked to the sales orderPurchaseOrder
string
Purchase Order LinePurchase order line of the purchase order that is linked to the sales orderPurchaseOrderLine
string
Purchase Order LinenumberNumber of the purchase order linePurchaseOrderLineNumber
integer
Purchase Order NumberNumber of the purchase orderPurchaseOrderNumber
integer
QuantityThe number of items sold in default units. the quantity shown in the entry screen is quantity * unitfactorQuantity
float
Shop OrderReference to shoporderShopOrder
string
Unit CodeCode of item unitUnitCode
string
Unit DescriptionDescription of unitUnitDescription
string
Unit PricePrice per unit in the currency of the transactionUnitPrice
float
Use DropshipmentIndicates if drop shipment is used (delivery directly to customer, invoice to wholesaler)UseDropShipment
float
VAT amountVat amount in the currency of the transactionVATAmount
float
VAtcodeVat codeVATCode
string
VAT Code DescriptionDescription of vatcodeVATCodeDescription
string
VAT PercentageThe vat percentage of the vat code. this is the percentage at the moment the sales order is created. it's also used for the default calculation of vat amounts and vat base amountsVATPercentage
float
IDPrimary keyID
string
TimestampTimestampTimestamp
integer
Amount DCAmount in the default currency of the companyAmountDC
float
Amount FCAmount in the currency of the transactionAmountFC
float
Cost CenterReference to Cost centerCostCenter
string
Cost Center DescriptionDescription of CostCenterCostCenterDescription
string
Cost Price FCItem cost priceCostPriceFC
float
Cost UnitReference to Cost unitCostUnit
string
Cost Unit DescriptionDescription of CostUnitCostUnitDescription
string
CreatedCreation dateCreated
datetime
CreatorUser ID of creatorCreator
string
Creator Full NameName of creatorCreatorFullName
sensiblestring
Customer Item CodeCode the customer uses for this itemCustomerItemCode
string
Custom FieldCustom field endpoint. Provided only for the Exact Online Premium users.CustomField
string
Delivery DateDelivery date of this lineDeliveryDate
datetime
Delivery StatusShipping status of the sales order line. 12=Open, 20=Partial, 21=Complete, 45=CancelledDeliveryStatus
integer
Delivery Status DescriptionDescription of DeliveryStatusDeliveryStatusDescription
string
DescriptionDescriptionDescription
string
DiscountDiscount given on the default price. Discount = (DefaultPrice of Item - PriceItem in line) / DefaultPrice of ItemDiscount
float
Division codeDivision
integer
Invoice StatusInvoice status of the sales order line. 12=Open, 20=Partial, 21=Complete, 45=CancelledInvoiceStatus
integer
Invoice Status DescriptionDescription of InvoiceStatusInvoiceStatusDescription
string
ItemReference to the item that is sold in this sales order lineItem
string
Item CodeCode of ItemItemCode
string
Item DescriptionDescription of ItemItemDescription
string
Item VersionItem VersionItemVersion
string
Item Version DescriptionDescription of Item VersionItemVersionDescription
string
Line NumberLine numberLineNumber
integer
MarginSales margin of the sales order lineMargin
float
ModifiedLast modified dateModified
datetime
ModifierUser ID of modifierModifier
string
Modifier Full NameName of modifierModifierFullName
sensiblestring
Net PriceNet price of the sales order lineNetPrice
float
NotesExtra notesNotes
string
Order IDThe OrderID identifies the sales order. All the lines of a sales order have the same OrderIDOrderID
string
Order NumberNumber of sales orderOrderNumber
integer
Price ListPrice listPricelist
string
Price List DescriptionDescription of PricelistPricelistDescription
string
ProjectThe project to which the sales order line is linked. The project can be different per line. Sometimes also the project in the header is filled although this is not really usedProject
string
Project CodeCode of ProjectProjectCode
string
Project DescriptionDescription of ProjectProjectDescription
string
Purchase OrderPurchase order that is linked to the sales orderPurchaseOrder
string
Purchase Order LinePurchase order line of the purchase order that is linked to the sales orderPurchaseOrderLine
string
Purchase Order Line NumberNumber of the purchase order linePurchaseOrderLineNumber
integer
Purchase Order NumberNumber of the purchase orderPurchaseOrderNumber
integer
QuantityThe number of items sold in default units. The quantity shown in the entry screen is Quantity * UnitFactor.Positive quantity = Sales order lines, Negative quantity = Trade-in lines.Quantity
float
Quantity DeliveredThe number of items deliveredQuantityDelivered
float
Quantity InvoicedThe number of items invoicedQuantityInvoiced
float
Shop OrderReference to ShopOrderShopOrder
string
Shop Order NumberNumber of shop orderShopOrderNumber
integer
StatusThe status of the sales order line. 12 = Open, 20 = Partial, 21 = Complete, 45 = Cancelled.Status
integer
Status DescriptionDescription of StatusStatusDescription
string
Unit CodeCode of item unitUnitCode
string
Unit DescriptionDescription of UnitUnitDescription
string
Unit PricePrice per unit in the currency of the transactionUnitPrice
float
Use Drop ShipmentIndicates if drop shipment is used (delivery directly to customer, invoice to wholesaler)UseDropShipment
string
VAT AmountVAT amount in the currency of the transactionVATAmount
float
VAT CodeVAT codeVATCode
string
VAT Code DescriptionDescription of VATCodeVATCodeDescription
string
VAT PercentageThe vat percentage of the VAT code. This is the percentage at the moment the sales order is created. It's also used for the default calculation of VAT amounts and VAT base amountsVATPercentage
Average HoursAverage hours per week in a scheduleAverageHours
float
CodeSchedule codeCode
string
CreatedCreation dateCreated
datetime
CreatorID of creatorCreator
string
Creator Full NameName of the creatorCreatorFullName
sensiblestring
DaysAverage days per week in the scheduleDays
float
DescriptionDescription of the scheduleDescription
string
Division codeDivision
integer
EmploymentEmployment ID for scheduleEmployment
string
Employment HIDEmployment numberEmploymentHID
string
End DateEnd date of the scheduleEndDate
datetime
HoursNumber of hours per week in a cla for which the schedule is builtHours
float
IDPrimary keyID
string
Leave Hours CompensationNumber of hours which are built up each week for later leaveLeaveHoursCompensation
float
MainIndication if the schedule is a main schedule for a cla. 1 = yes, 0 = noMain
string
ModifiedLast modified dateModified
datetime
ModifierId of modifierModifier
string
Modifier Full NameName of the modifierModifierFullName
sensiblestring
Payment Part Time FactorPart-time factor for payroll calculation. value between 0 and 1PaymentParttimeFactor
string
Schedule TypeType of schedule. 1 = hours and average days, 2 = hours and specific days, 3 = hours per day, 4 = time frames per dayScheduleType
string
Schedule Type DescriptionDescription of the schedule typeScheduleTypeDescription
string
Start DateWeek in the schedule which is used to start with. by default the number will be 1.StartDate
datetime
Start WeekWeek to start the schedule from for an employeeStartWeek
integer
In StockNumber of items in stock.InStock
string
Item IdPrimary key, item.ItemId
string
Planning InNumber of items that are planned to come in.PlanningIn
string
Planning OutNumber of items that are planned to go out.PlanningOut
string
IDPrimary keyID
string
Amount DCAmount in the default currency of the companyAmountDC
float
Amount FCAmount in the currency of the transactionAmountFC
float
CostcenterCost center linked to the subscription lineCostcenter
string
CostunitCost unit linked to the subscription lineCostunit
string
DescriptionDescription of the subscription lineDescription
string
DiscountDiscount percentage of the subscription lineDiscount
float
Division codeDivision
integer
Entry IDEntry ID referencing to the entry in sales invoiceEntryID
string
From DateThe date which the subscription line startsFromDate
datetime
ItemThe item that is used by the subscription line for sales detailsItem
string
Item DescriptionDescription of Item used by the subscription lineItemDescription
string
Line NumberLine number of the subscription line per subscriptionLineNumber
integer
Line Type DescriptionDescription of LineTypeLineTypeDescription
string
ModifiedDate and time when the subscription line has been modifiedModified
datetime
Net PriceNet price in the currency of the transactionNetPrice
float
NotesTo add or retrieve additional information in the subscription lineNotes
string
QuantityQuantity of item used in the subscription lineQuantity
float
To DateThe date the subscription line endsToDate
datetime
Unit CodeThe code of the unit used in the subscription lineUnitCode
string
Unit DescriptionDescription of Unit used in the subscription lineUnitDescription
string
Unit PriceUnit price in the currency of the transaction (price * unit factor)UnitPrice
float
VAT Amount FCVat Amount in the currency of the transactionVATAmountFC
float
VAT CodeVAT code that is used in the subscription lineVATCode
string
VAT Code DescriptionDescription of VAT code that is used in the subscription lineVATCodeDescription
string
Entry IDPrimary keyEntryID
string
Block EntryIndicates if subscription is blocked for time cost entryBlockEntry
boolean
Cancellation DateDate of cancellationCancellationDate
datetime
ClassificationGuid ID of classificationClassification
string
Classification CodeCode of classificationClassificationCode
string
Classification DescriptionDescription of classificationClassificationDescription
string
CreatedDate when the subscription was createdCreated
datetime
CreatorThe Guid ID of the user that created the subscriptionCreator
string
Creator Full NameThe full name of the user that created the subscriptionCreatorFullName
sensiblestring
CurrencyCurrency code used in the transactionsCurrency
string
Customer PO NumberPurchase order number of that is linked to customerCustomerPONumber
string
DescriptionDescription of the subscriptionDescription
string
Division codeDivision
integer
End DateThe date and time when the subscription endsEndDate
datetime
Invoice DayThe day number of the month when the invoice of the subscription is sentInvoiceDay
float
Invoice ToThe account which the subsciption is invoiced toInvoiceTo
string
Invoice To Contact PersonThe ID of the contact person that is linked to the account the subscription is invoice toInvoiceToContactPerson
string
Invoice To Contact Person Full NameThe name of the contact person that is linked to the account the subscription is invoice toInvoiceToContactPersonFullName
sensiblestring
Invoice To NameName of the account to invoice toInvoiceToName
string
Invoiced ToThe date when the invoice of the subscription is sentInvoicedTo
datetime
Invoicing Start DateDate to start invoicing the accountInvoicingStartDate
datetime
ModifiedDate and time when the subscription has been modifiedModified
datetime
ModifierThe ID of the user that modified the subscriptionModifier
string
Modifier Full NameThe name of the user that modified the subscriptionModifierFullName
sensiblestring
NotesFor additional information regarding the subscriptionNotes
string
NumberSubscription number of the companyNumber
float
Ordered ByReference to order account, GUID ID of the subscriberOrderedBy
string
Ordered By Contact PersonReference of contact person of order account, displays the contact name of the subscriberOrderedByContactPerson
string
Ordered By Contact Person Full NameName of contact person of order account, displays the full contact name of the subscriberOrderedByContactPersonFullName
sensiblestring
Ordered By NameName of order account, displays the name of the subscriberOrderedByName
string
Payment ConditionCode of subscriptions payment conditionPaymentCondition
string
Payment Condition DescriptionDescription of subscriptions payment conditionPaymentConditionDescription
string
PrintedIndicates if subscription has been printedPrinted
boolean
The Guid ID of the projectProject
string
Reason CancelledGuid ID of the reason of cancellation record linked to the subscriptionReasonCancelled
string
Reason Cancelled CodeCode of the reason of cancellation record linked to the subscriptionReasonCancelledCode
string
Reason Cancelled DescriptionDescription of the reason of cancellation record linked to the subscriptionReasonCancelledDescription
string
Start DateStart date of the subscriptionStartDate
datetime
Subscription TypeThe GUID ID of the subscription conditionSubscriptionType
string
Subscription Type CodeThe code of the subscription condition recordSubscriptionTypeCode
string
Subscription Type DescriptionThe code of the subscription condition descriptionSubscriptionTypeDescription
string
IDPrimary keyID
string
TimestampTimestampTimestamp
integer
AccountReference to accountAccount
string
Account CodeCode of the AccountAccountCode
string
Account NameName of the AccountAccountName
string
Amount DCAmount in the default currency of the companyAmountDC
float
Amount FCAmount in the currency of the transactionAmountFC
float
Amount VAT Base FCVAT base amount in the currency of the transactionAmountVATBaseFC
float
Amount VAT FCVAT amount in the currency of the transactionAmountVATFC
float
AssetReference to assetAsset
string
Asset CodeCode of AssetAssetCode
string
Asset DescriptionDescription of AssetAssetDescription
string
Cost CenterReference to cost centerCostCenter
string
Cost Center DescriptionDescription of CostCenterCostCenterDescription
string
Cost UnitReference to cost unitCostUnit
string
Cost Unit DescriptionDescription of CostUnitCostUnitDescription
string
CreatedCreation dateCreated
datetime
CreatorUser ID of creatorCreator
string
Creator Full NameName of creatorCreatorFullName
sensiblestring
CurrencyCurrencyCurrency
string
Custom FieldCustom field endpointCustomField
string
DateEntry dateDate
datetime
DescriptionDescriptionDescription
string
Division codeDivision
float
DocumentReference to documentDocument
string
Document NumberNumber of the documentDocumentNumber
float
Document SubjectSubject of the documentDocumentSubject
string
Due DateDate that payment should be doneDueDate
datetime
Entry IDThe transaction lines that make up a financial entry share the same EntryIDEntryID
string
Entry NumberEntry number of the headerEntryNumber
float
Exchange RateExchange rateExchangeRate
float
External Link DescriptionDescription of ExternalLinkExternalLinkDescription
string
External Link ReferenceExternal linkExternalLinkReference
string
Extra Duty Amount FCExtra duty amountExtraDutyAmountFC
float
Extra Duty PercentageExtra duty percentageExtraDutyPercentage
float
Financial PeriodFinancial periodFinancialPeriod
float
Financial YearFinancial yearFinancialYear
float
General ledger accountGLAccount
string
GL Account CodeCode of GLAccountGLAccountCode
string
GL Account DescriptionDescription of GLAccountGLAccountDescription
string
Invoice NumberInvoice numberInvoiceNumber
float
ItemReference to itemItem
string
Item CodeCode of ItemItemCode
string
Item DescriptionDescription of ItemItemDescription
CodeUnique key, fixed length numeric string with leading spaces, length 18. IMPORTANT: When you use OData $filter on this field you have to make sure the filter parameter contains the leading spacesCode
string
Code At SupplierCode under which your own company is known at the accountCodeAtSupplier
string
Company SizeReference to Company size of the accountCompanySize
string
Consolidation ScenarioConsolidation scenario (Time & Billing). Values: 0 = No consolidation, 1 = Item, 2 = Item + Project, 3 = Item + Employee, 4 = Item + Employee + Project, 5 = Project + WBS + Item, 6 = Project + WBS + Item + Employee. Item means in this case including Unit and Price, these also have to be the same to consolidateConsolidationScenario
string
Controlled DateDate of the latest control of account data with external web serviceControlledDate
datetime
Cost CenterObsoleteCostcenter
string
Cost Center DescriptionObsoleteCostcenterDescription
string
Cost PaidObsoleteCostPaid
string
CountryCountry codeCountry
string
Country NameCountry nameCountryName
string
CreatedCreation dateCreated
datetime
CreatorUser ID of creatorCreator
string
Creator Full NameName of creatorCreatorFullName
sensiblestring
Credit Line PurchaseMaximum amount of credit for Purchase. If no value has been defined, there is no credit limitCreditLinePurchase
float
Credit Line SalesMaximum amount of credit for sales. If no value has been defined, there is no credit limitCreditLineSales
float
CurrencyObsoleteCurrency
string
Customer SinceObsoleteCustomerSince
datetime
Custom FieldCustom field endpoint. Provided only for the Exact Online Premium users.CustomField
string
Datev Creditor CodeDATEV creditor code for Germany legislationDatevCreditorCode
string
Datev Debtor CodeDATEV debtor code for Germany legislationDatevDebtorCode
string
Delivery AdviceAllows a customer to do goods delivery based on setting complete, partial or partial no back order. Values: 0 = Partial, 1 = Complete, 2 = PartialNoBackOrderDeliveryAdvice
string
Discount PurchaseDefault discount percentage for purchase. This is stored as a fraction. ie 5.5% is stored as .055DiscountPurchase
float
Discount SalesDefault discount percentage for sales. This is stored as a fraction. ie 5.5% is stored as .055DiscountSales
float
Division codeDivision
integer
DocumentObsoleteDocument
string
Duns NumberObsoleteDunsNumber
string
EmailE-Mail address of the accountEmail
string
Enable Sales Payment LinkIndicates whether payment link is activated for salesEnableSalesPaymentLink
boolean
End DateDetermines in combination with the start date if the account is active. If the current date is > end date the account is inactiveEndDate
datetime
EORI NumberEORI numberEORINumber
string
Established DateRegistrationDateEstablishedDate
datetime
FaxFax numberFax
string
GLAccount PurchaseDefault (corporate) GL offset account for purchase (cost)GLAccountPurchase
string
GLAccount SalesDefault (corporate) GL offset account for sales (revenue)GLAccountSales
string
GLAPDefault GL account for Accounts PayableGLAP
string
GLARDefault GL account for Accounts ReceivableGLAR
string
Gln NumberGlobal Location Number can be used by companies to identify their locations, giving them complete flexibility to identify any type or level of location requiredGlnNumber
string
Has Withholding Tax SalesIndicates whether a customer has withholding tax on salesHasWithholdingTaxSales
boolean
Ignore Datev Warning MessageSuppressed warning message when there is duplication on the DATEV codeIgnoreDatevWarningMessage
boolean
Incoterm Address PurchaseAddress of Incoterm for PurchaseIncotermAddressPurchase
string
Incoterm Address SalesAddress of Incoterm for SalesIncotermAddressSales
string
Incoterm Code PurchaseCode of Incoterm for PurchaseIncotermCodePurchase
string
Incoterm Code SalesCode of Incoterm for SalesIncotermCodeSales
string
Incoterm Version PurchaseVersion of Incoterm for Purchase Supported version for Incoterms : 2010, 2020IncotermVersionPurchase
integer
Incoterm Version SalesVersion of Incoterm for Sales Supported version for Incoterms : 2010, 2020IncotermVersionSales
integer
Intra Stat AreaIntrastat AreaIntraStatArea
string
Intra Stat Delivery TermIntrastat delivery methodIntraStatDeliveryTerm
string
Intra Stat SystemSystem for IntrastatIntraStatSystem
string
Intra Stat Transaction ATransaction type A for IntrastatIntraStatTransactionA
string
Intra Stat Transaction BTransaction type B for IntrastatIntraStatTransactionB
string
Intra Stat Transport MethodTransport method for IntrastatIntraStatTransportMethod
string
Invoice AccountID of account to be invoiced instead of this accountInvoiceAccount
string
Invoice Account CodeCode of InvoiceAccountInvoiceAccountCode
string
Invoice Account NameName of InvoiceAccountInvoiceAccountName
string
Invoice Attachment TypeIndicates which attachment types should be sent when a sales invoice is printed. Only values in related table with Invoice=1 are allowedInvoiceAttachmentType
integer
Invoicing MethodMethod of sending for sales invoices. Values: 1: Paper, 2: EMail, 4: Mailbox (electronic exchange), 8: Send and trackTake notes: To use the '4 - Mailbox (electronic exchange)' option, the 'Mailbox' feature set is required in the licence.InvoicingMethod
integer
Is AccountantIndicates whether the account is an accountant. Values: 0 = No accountant, 1 = True, but accountant doesn't want his name to be published in the list of accountants, 2 = True, and accountant is published in the list of accountantsIsAccountant
string
Is AgencyIndicates whether the accounti is an agencyIsAgency
string
Is AnonymisedIndicates whtether the account is anonymised.IsAnonymised
string
Is BankObsoleteIsBank
boolean
Is CompetitorIndicates whether the account is a competitorIsCompetitor
string
Is Extra DutyIndicates whether a customer is eligible for extra dutyIsExtraDuty
boolean
Is MailingIndicates if the account is excluded from mailing marketing informationIsMailing
string
Is MemberObsoleteIsMember
boolean
Is PilotIndicates whether the account is a pilot accountIsPilot
boolean
Is PurchaseObsoleteIsPurchase
boolean
Is ResellerIndicates whether the account is a resellerIsReseller
boolean
Is SalesIndicates whether the account is allowed for salesIsSales
boolean
Is SupplierIndicates whether the account is a supplierIsSupplier
boolean
LanguageLanguage codeLanguage
string
Language DescriptionLanguage descriptionLanguageDescription
string
LatitudeLatitude (used by Google maps)Latitude
float
Lead PurposeReference to Lead purpose of an accountLeadPurpose
string
Lead SourceReference to Lead source of an accountLeadSource
string
Logo File NameThe file name (without path, but with extension) of the imageLogoFileName
string
Logo Thumbnail UrlThumbnail url of the logoLogoThumbnailUrl
string
Logo UrlUrl to retrieve the logoLogoUrl
string
LongitudeLongitude (used by Google maps)Longitude
float
Main ContactReference to main contact personMainContact
string
ModifiedLast modified dateModified
datetime
ModifierUser ID of modifierModifier
string
Modifier Full NameName of modifierModifierFullName
sensiblestring
NameAccount nameName
string
OIN NumberDutch government identification numberOINNumber
string
ParentID of the parent accountParent
string
Pay As You EarnIndicates the loan repayment plan for UK legislationPayAsYouEarn
string
Payment Condition PurchaseCode of default payment condition for purchasePaymentConditionPurchase
string
Payment Condition Purchase DescriptionDescription of PaymentConditionPurchasePaymentConditionPurchaseDescription
string
Payment Condition SalesCode of default payment condition for salesPaymentConditionSales
string
Payment Condition Sales DescriptionDescription of PaymentConditionSalesPaymentConditionSalesDescription
string
Peppol IdentifierPeppol identifier user entered manually, corresponds to picked peppol adressPeppolIdentifier
string
Peppol Identifier TypePeppol identifier type that user picked manually - GLN, COC, etcPeppolIdentifierType
integer
PhonePhone numberPhone
string
Phone ExtensionPhone number extentionPhoneExtension
string
Post codeVisit address postcodePostcode
string
Price ListDefault sales price list for accountPriceList
string
Purchase CurrencyCurrency of purchaseTake notes: If the currency code input is not in the active currencies, the value will be set to empty.PurchaseCurrency
string
Purchase Currency DescriptionDescription of PurchaseCurrencyPurchaseCurrencyDescription
string
Purchase Lead DaysIndicates number of days required to receive a purchase. Acts as a defaultPurchaseLeadDays
integer
Purchase VAT CodeDefault VAT code used for purchase entriesPurchaseVATCode
string
Purchase VAT Code DescriptionDescription of PurchaseVATCodePurchaseVATCodeDescription
string
Recepient Of CommissionsDefine the relation that should be taken in the official document of the rewarding fiscal fiches BelcotaxRecepientOfCommissions
boolean
RemarksRemarksRemarks
string
ResellerID of the reseller account. Conditions: the target account must have the property IsReseller turned onReseller
string
Reseller CodeCode of ResellerResellerCode
string
Reseller NameName of ResellerResellerName
string
RSINFiscal number for NL legislationRSIN
string
Sales CurrencyCurrency of Sales used for Time & BillingTake notes: If the currency code input is not in the active currencies, the value will be set to empty.SalesCurrency
string
Sales Currency DescriptionDescription of SalesCurrencySalesCurrencyDescription
Separate Inv Per ProjectSeparate invoice per project (Time & Billing)SeparateInvPerProject
string
Separate Inv Per SubscriptionIndicates how invoices are generated from subscriptions. 0 = subscriptions belonging to the same customer are combined in a single invoice. 1 = each subscription results in one invoice. In both cases, each individual subscription line results in one invoice lineSeparateInvPerSubscription
string
Shipping Lead DaysIndicates the number of days it takes to send goods to the customer. Acts as a defaultShippingLeadDays
Show Remark For SalesIndicates whether to display Ordered by account's remarks when creating a new sales orderShowRemarkForSales
boolean
SourceCRM creation sourceSource
string
Start DateIndicates in combination with the end date if the account is activeStartDate
datetime
StateState/Province/County code When changing the Country and the State is filled, the State must be assigned with a valid value from the selected country or set to emptyState
string
State NameName of StateStateName
string
StatusIf the status field is filled this means the account is a customer. The value indicates the customer status. Possible values: A=None, S=Suspect, P=Prospect, C=CustomerStatus
string
Status SinceObsoleteStatusSince
datetime
Trade NameTrade name can be registered and shown with the client (for all legislations)TradeName
string
TypeAccount type: Values: A = Relation, D = DivisionType
string
Unique Taxpayer ReferenceUnique taxpayer reference for UK legislationUniqueTaxpayerReference
string
VAT LiabilityIndicates the VAT status of an account to be able to identify the relation that should be selected in the VAT debtor listing in BelgiumVATLiability
string
VAT NumberThe number under which the account is known at the Value Added Tax collection agencyVATNumber
string
WebsiteWebsite of the accountWebsite
string
IDPrimary keyID
string
TimestampTimestampTimestamp
integer
AmountDCAmount in the default currency of the companyAmountDC
float
AmountDiscountDiscount amount in the currency of the transactionAmountDiscount
float
AmountDiscountExclVatDiscount amount excluding VAT in the currency of the transactionAmountDiscountExclVat
float
AmountFCAmount in the currency of the transactionAmountFC
float
CloseDateDate on which the customer accepted or rejected the quotation versionCloseDate
datetime
ClosingDateDate on which you expect to close/win the dealClosingDate
datetime
CreatedDate and time on which the quotation was createdCreated
datetime
CreatorUser ID of the creatorCreator
string
CreatorFullNameName of the creatorCreatorFullName
sensiblestring
CurrencyThe currency of the quotationCurrency
string
DeliveryAccountThe account where the items should deliveredDeliveryAccount
string
DeliveryAccountCodeThe code of the delivery accountDeliveryAccountCode
string
DeliveryAccountContactThe contact person of the delivery accountDeliveryAccountContact
string
DeliveryAccountContactFullNameFull name of the delivery account contact personDeliveryAccountContactFullName
sensiblestring
DeliveryAccountNameThe name of the delivery accountDeliveryAccountName
string
DeliveryAddressThe id of the delivery addressDeliveryAddress
string
DeliveryDateThe date of the deliveryDeliveryDate
datetime
DescriptionBy default this contains the item descriptionDescription
string
DiscountDiscount given on the default price. This is stored as a fraction. ie 5.5% is stored as .055Discount
float
Division codeDivision
integer
DocumentDocument linked to the quotationDocument
string
DocumentSubjectThe subject of the documentDocumentSubject
string
DueDateDate after which the quotation is no longer validDueDate
datetime
IncotermAddressAddress of IncotermIncotermAddress
string
IncotermCodeCode of IncotermIncotermCode
string
IncotermVersionVersion of Incoterm Supported version for Incoterms : 2010, 2020IncotermVersion
integer
InvoiceAccountThe account to which the invoice is sentInvoiceAccount
string
InvoiceAccountCodeThe code of the invoice accountInvoiceAccountCode
string
InvoiceAccountContactThe contact person of the invoice accountInvoiceAccountContact
string
InvoiceAccountContactFullNameFull name of the invoice account contact personInvoiceAccountContactFullName
sensiblestring
InvoiceAccountNameThe name of the invoice accountInvoiceAccountName
string
ModifiedDate and time on which the quotation was last modifiedModified
datetime
ModifierUser ID of the modifierModifier
string
ModifierFullNameName of the modifierModifierFullName
sensiblestring
NotesExtra notesNotes
string
OpportunityOpportunity linked to the quotationOpportunity
string
OpportunityNameThe name of the opportunityOpportunityName
string
OrderAccountThe account that requested the quotationOrderAccount
string
OrderAccountCodeThe code of the order accountOrderAccountCode
string
OrderAccountContactThe contact person of the order accountOrderAccountContact
string
OrderAccountContactFullNameFull name of the order account contact personOrderAccountContactFullName
sensiblestring
OrderAccountNameThe name of the order accountOrderAccountName
StatusThe status of the quotation version. 5 = Rejected, 6 = Reviewed and closed, 10 = Recovery, 20 = Draft, 25 = Open, 35 = Processing... , 40 = Printed, 50 = AcceptedStatus
integer
StatusDescriptionThe description of the statusStatusDescription
string
VersionNumberNumber indicating the different reviews which are made for the quotationVersionNumber
integer
YourRefThe number by which this quotation is identified by the order accountYourRef
string
IDPrimary keyID
string
TimestampTimestampTimestamp
integer
AmountDCAmount in the default currency of the companyAmountDC
float
AmountDiscountDiscount amount in the currency of the transactionAmountDiscount
float
AmountDiscountExclVatDiscount amount excluding VAT in the currency of the transactionAmountDiscountExclVat
float
AmountFCAmount in the currency of the transactionAmountFC
float
CostCenterReference to Cost centerCostCenter
string
CostCenterDescriptionDescription of CostCenterCostCenterDescription
string
CostUnitReference to Cost unitCostUnit
string
CostUnitDescriptionDescription of CostUnitCostUnitDescription
string
CreatedDate and time on which the quotation was createdCreated
datetime
CreatorUser ID of the creatorCreator
string
CreatorFullNameName of the creatorCreatorFullName
sensiblestring
CustomerItemCodeCode the customer uses for this itemCustomerItemCode
string
CustomFieldCustom field endpointCustomField
string
DescriptionBy default this contains the item descriptionDescription
string
DiscountDiscount given on the default price. This is stored as a fraction. ie 5.5% is stored as .055Discount
float
Division codeDivision
integer
ItemReference to the item that is sold in this quotation lineItem
string
ItemDescriptionDescription of the itemItemDescription
string
LineNumberIndicates the sequence of the lines within one quotationLineNumber
integer
ModifiedDate and time on which the quotation was last modifiedModified
datetime
ModifierUser ID of the modifierModifier
string
ModifierFullNameName of the modifierModifierFullName
sensiblestring
NetPriceNet price of the quotation lineNetPrice
float
NotesExtra notesNotes
string
OptionalIndicates the optional lineOptional
boolean
QuantityThe number of items sold in default units. The quantity shown in the entry screen is Quantity * UnitFactorQuantity
float
QuotationIDIdentifies the quotation. All the lines of a quotation have the same QuotationIDQuotationID
string
QuotationNumberUnique number to indentify the quotation. By default this number is based on the setting for first available numberQuotationNumber
integer
UnitCodeCode of the item unitUnitCode
string
UnitDescriptionDescription of the item unitUnitDescription
string
UnitPricePrice per item unitUnitPrice
float
VATAmountFCVAT amount of the line in the currency of the transactionVATAmountFC
float
VATCodeThe VAT code that is used when the quotation is invoicedVATCode
string
VATDescriptionDescription of the VAT codeVATDescription
string
VATPercentageThe VAT percentage of the VAT codeVATPercentage
float
TimestampTimestampTimestamp
integer
AccountAccount linked to the addressAccount
string
AccountIsSupplierIndicates if the account is a supplierAccountIsSupplier
boolean
AccountNameName of the accountAccountName
string
AddressLine1First address lineAddressLine1
sensiblestring
AddressLine2Second address lineAddressLine2
sensiblestring
AddressLine3Third address lineAddressLine3
sensiblestring
CityCityCity
string
ContactContact linked to AddressContact
string
ContactNameContact nameContactName
sensiblestring
CountryCountry codeCountry
string
CountryNameCountry nameCountryName
string
CreatedCreation dateCreated
datetime
CreatorUser ID of creatorCreator
string
CreatorFullNameName of creatorCreatorFullName
sensiblestring
CustomFieldCustom field endpoint. Provided only for the Exact Online Premium users.CustomField
string
Division codeDivision
integer
FaxFax numberFax
sensiblestring
FreeBoolField_01Free boolean field 1FreeBoolField_01
boolean
FreeBoolField_02Free boolean field 2FreeBoolField_02
boolean
FreeBoolField_03Free boolean field 3FreeBoolField_03
boolean
FreeBoolField_04Free boolean field 4FreeBoolField_04
boolean
FreeBoolField_05Free boolean field 5FreeBoolField_05
boolean
FreeDateField_01Free date field 1FreeDateField_01
datetime
FreeDateField_02Free date field 2FreeDateField_02
datetime
FreeDateField_03Free date field 3FreeDateField_03
datetime
FreeDateField_04Free date field 4FreeDateField_04
datetime
FreeDateField_05Free date field 5FreeDateField_05
datetime
FreeNumberField_01Free number field 1FreeNumberField_01
float
FreeNumberField_02Free number field 2FreeNumberField_02
float
FreeNumberField_03Free number field 3FreeNumberField_03
float
FreeNumberField_04Free number field 4FreeNumberField_04
float
FreeNumberField_05Free number field 5FreeNumberField_05
float
FreeTextField_01Free text field 1FreeTextField_01
string
FreeTextField_02Free text field 2FreeTextField_02
string
FreeTextField_03Free text field 3FreeTextField_03
string
FreeTextField_04Free text field 4FreeTextField_04
string
FreeTextField_05Free text field 5FreeTextField_05
string
IDPrimary keyID
string
MailboxMailboxTake notes: The 'Mailbox' functionality required the Mailbox feature set in the licence.Mailbox
sensiblestring
MainIndicates if the address is the main address for this typeMain
boolean
ModifiedLast modified dateModified
datetime
ModifierUser ID of modifierModifier
string
ModifierFullNameName of modifierModifierFullName
sensiblestring
NicNumberLast 5 digits of SIRET number which is an intern sequential number of 4 digits representing the identification of the localization of the officeNicNumber
string
NotesNotes for an addressNotes
string
PhonePhone numberPhone
sensiblestring
PhoneExtensionPhone extensionPhoneExtension
string
PostcodePostcodePostcode
sensiblestring
SourceCRM creation sourceSource
string
StateStateState
string
StateDescriptionName of the StateStateDescription
string
TypeThe type of address. Visit=1, Postal=2, Invoice=3, Delivery=4Type
integer
WarehouseThe warehouse linked to the address, if a warehouse is linked the account will be empty. Can only be filled for type=DeliveryWarehouse
string
WarehouseCodeCode of the warehoudeWarehouseCode
string
WarehouseDescriptionDescription of the warehouseWarehouseDescription
string
IDPrimary keyID
string
TimestampTimestampTimestamp
integer
Counting CycleIndicates the number of days for next cycle countCountingCycle
integer
CreatedCreation dateCreated
datetime
CreatorUser ID of creatorCreator
string
CreatorFullNameName of creatorCreatorFullName
sensiblestring
Default Storage LocationThis is a default storage locationDefaultStorageLocation
Reserved StockThe quantity in a back to back order process which is already received from the purchase order, but not yet delivered for the sales order.ReservedStock
float
Safety StockMinimum quantity of items you must have in stockSafetyStock
float
Storage Location Sequence NumberSequence number of the item (Premium Only)StorageLocationSequenceNumber
integer
WarehouseWarehouse IDWarehouse
string
Warehouse CodeCode of warehouseWarehouseCode
string
Warehouse DescriptionDescription of warehouseWarehouseDescription
string
IDA guid that is the unique identifier of the itemID
string
TimestampTimestampTimestamp
integer
AssembledLeadDaysAssembly lead daysAssembledLeadDays
integer
AverageCostThe current average cost priceAverageCost
float
BarcodeBarcode of the item (numeric string)Barcode
string
BatchQuantityBatch quantityBatchQuantity
float
Class_01Item class code referring to ItemClasses with ClassID 1Class_01
string
Class_02Item class code referring to ItemClasses with ClassID 2Class_02
string
Class_03Item class code referring to ItemClasses with ClassID 3Class_03
string
Class_04Item class code referring to ItemClasses with ClassID 4Class_04
string
Class_05Item class code referring to ItemClasses with ClassID 5Class_05
string
Class_06Item class code referring to ItemClasses with ClassID 6Class_06
string
Class_07Item class code referring to ItemClasses with ClassID 7Class_07
string
Class_08Item class code referring to ItemClasses with ClassID 8Class_08
string
Class_09Item class code referring to ItemClasses with ClassID 9Class_09
string
Class_10Item class code referring to ItemClasses with ClassID 10Class_10
string
CodeItem codeCode
string
CopyRemarksCopy sales remarks to sales linesCopyRemarks
string
CostPriceCurrencyThe currency of the current and proposed cost priceCostPriceCurrency
string
CostPriceNewProposed cost priceCostPriceNew
float
CostPriceStandardThe current standard cost priceCostPriceStandard
float
CreatedCreation dateCreated
datetime
CreatorUser ID of creatorCreator
string
CreatorFullNameName of creatorCreatorFullName
sensiblestring
CustomFieldCustom field endpoint. Provided only for the Exact Online Premium users.CustomField
string
DescriptionDescription of the itemDescription
string
Division codeDivision
integer
EndDateTogether with StartDate this determines if the item is activeEndDate
datetime
ExtraDescriptionExtra description text, slightly longer than the regular description (255 instead of 60)ExtraDescription
string
FreeBoolField_01Free boolean field 1FreeBoolField_01
boolean
FreeBoolField_02Free boolean field 2FreeBoolField_02
boolean
FreeBoolField_03Free boolean field 3FreeBoolField_03
boolean
FreeBoolField_04Free boolean field 4FreeBoolField_04
boolean
FreeBoolField_05Free boolean field 5FreeBoolField_05
boolean
FreeDateField_01Free date field 1FreeDateField_01
datetime
FreeDateField_02Free date field 2FreeDateField_02
datetime
FreeDateField_03Free date field 3FreeDateField_03
datetime
FreeDateField_04Free date field 4FreeDateField_04
datetime
FreeDateField_05Free date field 5FreeDateField_05
datetime
FreeNumberField_01Free numeric field 1FreeNumberField_01
float
FreeNumberField_02Free numeric field 2FreeNumberField_02
float
FreeNumberField_03Free numeric field 3FreeNumberField_03
float
FreeNumberField_04Free numeric field 4FreeNumberField_04
float
FreeNumberField_05Free numeric field 5FreeNumberField_05
float
FreeNumberField_06Free numeric field 6FreeNumberField_06
float
FreeNumberField_07Free numeric field 7FreeNumberField_07
float
FreeNumberField_08Free numeric field 8FreeNumberField_08
float
FreeTextField_01Free text field 1FreeTextField_01
string
FreeTextField_02Free text field 2FreeTextField_02
string
FreeTextField_03Free text field 3FreeTextField_03
string
FreeTextField_04Free text field 4FreeTextField_04
string
FreeTextField_05Free text field 5FreeTextField_05
string
FreeTextField_06Free text field 6FreeTextField_06
string
FreeTextField_07Free text field 7FreeTextField_07
string
FreeTextField_08Free text field 8FreeTextField_08
string
FreeTextField_09Free text field 9FreeTextField_09
string
FreeTextField_10Free text field 10FreeTextField_10
string
GLCostsGL account the cost entries will be booked on. This overrules the GL account from the item group. If the license contains 'Intuit integration' this property overrides the value in Settings, not the item group.GLCosts
string
GLCostsCodeCode of GL account for costsGLCostsCode
string
GLCostsDescriptionDescription of GLCostsGLCostsDescription
string
GLCostsWorkInProgressGL account the work in progress project cost entries will be booked on. This overrules the GL account from the item group.GLCostsWorkInProgress
string
GLCostsWorkInProgressCodeCode of GL account for costs Work In ProgressGLCostsWorkInProgressCode
string
GLCostsWorkInProgressDescriptionDescription of GLCosts Work In ProgressGLCostsWorkInProgressDescription
string
GLRevenueGL account the revenue will be booked on. This overrules the GL account from the item group. If the license contains 'Intuit integration' this property overrides the value in Settings, not the item group.GLRevenue
string
GLRevenueCodeCode of GLRevenueGLRevenueCode
string
GLRevenueDescriptionDescription of GLRevenueGLRevenueDescription
string
GLRevenueWorkInProgressGL account the work in progress project revenue entries will be booked on. This overrules the GL account from the item group.GLRevenueWorkInProgress
string
GLRevenueWorkInProgressCodeCode of GLRevenue Work In ProgressGLRevenueWorkInProgressCode
string
GLRevenueWorkInProgressDescriptionDescription of GLRevenue Work In ProgressGLRevenueWorkInProgressDescription
string
GLStockGL account the stock entries will be booked on. This overrules the GL account from the item group. If the license contains 'Intuit integration' this property overrides the value in Settings, not the item group.GLStock
string
GLStockCodeCode of GL account for stockGLStockCode
string
GLStockDescriptionDescription of GLStockGLStockDescription
string
GrossWeightGross weight for international goods shipmentsGrossWeight
float
IsBatchItemIndicates if batches are used for this itemIsBatchItem
string
IsFractionAllowedItemIndicates if fractions (for example 0.35) are allowed for quantities of this itemIsFractionAllowedItem
boolean
IsMakeItemIndicates that an Item is produced to Inventory, not purchasedIsMakeItem
string
IsNewContractOnly used for packages (IsPackageItem=1). To indicate if this package is a new contract type packageIsNewContract
string
IsOnDemandItemIs On demand ItemIsOnDemandItem
string
IsPackageItemIndicates if the item is a package item. Can only be created in the hosting administrationIsPackageItem
boolean
IsPurchaseItemIndicates if the item can be purchasedIsPurchaseItem
boolean
IsRegistrationCodeItemIndicated if the item is used in voucher functionalityIsRegistrationCodeItem
string
IsSalesItemIndicates if the item can be soldIsSalesItem
boolean
IsSerialItemIndicates that serial numbers are used for this itemIsSerialItem
boolean
IsStockItemIf you have the Trade or Manufacturing license and you check this property the item will be shown in the stock positions overview, stock counts and transaction lists. If you have the Invoice module and you check this property you will get a general journal entry based on the Stock and Costs G/L accounts of the item group. If you don’t want the general journal entry to be created you should change the Stock/Costs G/L account on the Item group page to the type Costs instead of Inventory. If you have the CRM Standalone license, the item will not be available.IsStockItem
boolean
IsSubcontractedItemIndicates if the item is provided by an outside supplierIsSubcontractedItem
boolean
IsTaxableItemIndicates if tax needs to be calculated for this itemIsTaxableItem
string
IsTimeIndicates if the item is a time unit item (for example a labor hour item)IsTime
string
IsWebshopItemIndicates if the item can be exported to a web shop. If you have the CRM Standalone license, the item will not be available.IsWebshopItem
string
ItemGroupGUID of Item group of the itemItemGroup
string
ItemGroupCodeCode of ItemGroupItemGroupCode
string
ItemGroupDescriptionDescription of ItemGroupItemGroupDescription
string
ModifiedLast modified dateModified
datetime
ModifierUser ID of modifierModifier
string
ModifierFullNameName of modifierModifierFullName
sensiblestring
NetWeightNet weight for international goods shipmentsNetWeight
float
NetWeightUnitNet Weight unit for international goods shipment, only available in manufacturing packagesNetWeightUnit
string
NotesNotesNotes
string
PictureThis field is write-only. The picture can be downloaded through PictureUrl and PictureThumbnailUrl.Picture
string
PictureNameFile name of picturePictureName
string
PictureThumbnailUrlUrl where thumbnail picture can be retrievedPictureThumbnailUrl
string
PictureUrlUrl where picture can be retrievedPictureUrl
string
SalesVatCodeCode of SalesVatSalesVatCode
string
SalesVatCodeDescriptionDescription of SalesVatCodeSalesVatCodeDescription
StartDateTogether with EndDate this determines if the item is activeStartDate
datetime
StatisticalCodeStatistical codeStatisticalCode
string
StatisticalNetWeightStatistical net weightStatisticalNetWeight
float
StatisticalUnitsStatistical unitsStatisticalUnits
float
StatisticalValueStatistical valueStatisticalValue
float
StockQuantity that is in stockStock
float
UnitThe standard unit of this itemUnit
string
UnitDescriptionDescription of UnitUnitDescription
string
UnitTypeType of unit: A=Area, L=Length, O=Other, T=Time, V=Volume, W=WeightUnitType
string
UseExplosionAssemble at deliveryUseExplosion
string
TimestampTimestampTimestamp
integer
AccountID of the supplierAccount
string
AccountNameName of the supplier accountAccountName
string
BarcodeThis is the barcode for the unit other than standard unit of the item. Only supported by the Premium for Wholesale & Distribution and ManufacturingBarcode
string
CreatedCreation dateCreated
datetime
CreatorUser ID of creatorCreator
string
CreatorFullNameName of creatorCreatorFullName
sensiblestring
CurrencyThe currency of the priceCurrency
string
DefaultItemUnitThe default unit of the itemDefaultItemUnit
string
DefaultItemUnitDescriptionThe description of the default item unitDefaultItemUnitDescription
string
Division codeDivision
integer
EndDateTogether with StartDate this determines whether the price is activeEndDate
datetime
IDPrimary keyID
string
ItemItem IDItem
string
ItemCodeCode of ItemItemCode
string
ItemDescriptionDescription of ItemItemDescription
string
ModifiedLast modified dateModified
datetime
ModifierUser ID of modifierModifier
string
ModifierFullNameName of modifierModifierFullName
sensiblestring
NumberOfItemsPerUnitThis is the multiplication factor when going from default item unit to the unit of this price.For example if the default item unit is 'gram' and the price unit is 'kilogram' then the value of this property is 1000.NumberOfItemsPerUnit
float
PriceThe actual price of this purchase itemPrice
float
QuantityMinimum quantity to which the price is applicableQuantity
float
StartDateTogether with EndDate this determines whether the price is activeStartDate
datetime
UnitThe unit code of the priceUnit
string
UnitDescriptionDescription of the price unitUnitDescription
string
IDPrimary keyID
string
TimestampTimestampTimestamp
integer
AccountID of the customerAccount
string
AccountNameName of the customer accountAccountName
string
BarcodeThis is the barcode for the unit other than standard unit of the item. Only supported by the Premium for Wholesale & Distribution and ManufacturingBarcode
string
CreatedCreation dateCreated
datetime
CreatorUser ID of creatorCreator
string
CreatorFullNameName of creatorCreatorFullName
sensiblestring
CurrencyThe currency of the priceCurrency
string
DefaultItemUnitThe default unit of the itemDefaultItemUnit
string
DefaultItemUnitDescriptionThe description of the default item unitDefaultItemUnitDescription
string
Division codeDivision
integer
EmployeeID of the employee that is linked to sales item priceEmployee
string
EndDateTogether with StartDate this determines whether the price is activeEndDate
datetime
ItemItem IDItem
string
ItemCodeCode of ItemItemCode
string
ItemDescriptionDescription of ItemItemDescription
string
ModifiedLast modified dateModified
datetime
ModifierUser ID of modifierModifier
string
ModifierFullNameName of modifierModifierFullName
sensiblestring
NumberOfItemsPerUnitThis is the multiplication factor when going from default item unit to the unit of this price.For example if the default item unit is 'gram' and the price unit is 'kilogram' then the value of this property is 1000.NumberOfItemsPerUnit
float
PriceThe actual price of this sales itemPrice
float
ProjectID of project that is linked to sales item priceProject
string
ProjectDescriptionDescription of the projectProjectDescription
string
QuantityMinimum quantity to which the price is applicableQuantity
float
StartDateTogether with EndDate this determines whether the price is activeStartDate
datetime
UnitThe unit code of the priceUnit
string
UnitDescriptionDescription of the price unitUnitDescription
string
IDPrimary keyID
string
TimestampTimestampTimestamp
integer
BarcodeThis is the barcode for the unit other than standard unit of the item. Only supported by the Premium for Wholesale & Distribution and ManufacturingBarcode
string
CopyRemarksCopy purchase remarks to purchase linesCopyRemarks
string
CountryOfOriginCountry of origin codeCountryOfOrigin
string
CountryOfOriginDescriptionDescription of country of originCountryOfOriginDescription
string
CreatedCreation dateCreated
datetime
CreatorUser ID of creatorCreator
string
CreatorFullNameName of creatorCreatorFullName
sensiblestring
CurrencyCurrency of item priceCurrency
string
CurrencyDescriptionDescription of currency of item priceCurrencyDescription
string
Division codeDivision
integer
DropShipmentIndicates that the supplier will deliver the item directly to customer. Values: 0 = No, 1 = Yes, 2 = OptionalDropShipment
string
EndDateTogether with StartDate this determines whether the price is activeEndDate
datetime
ItemItem IDItem
string
ItemCodeItem codeItemCode
string
ItemDescriptionDescription of ItemItemDescription
string
ItemUnitItem UnitItemUnit
string
ItemUnitCodeItem Unit CodeItemUnitCode
string
ItemUnitDescriptionItem Unit DescriptionItemUnitDescription
string
MainSupplierIndicates this is a main supplierMainSupplier
boolean
MinimumQuantityMinimum quantity of the item for purchase, only available for Wholesale & Distribution (Professional and Premium only)MinimumQuantity
float
ModifiedLast modified dateModified
datetime
ModifierUser ID of modifierModifier
string
ModifierFullNameName of modifierModifierFullName
sensiblestring
NotesNotesNotes
string
PurchaseLeadTimeThe number of days between placing an order with a supplier and receiving items from the supplierPurchaseLeadTime
integer
PurchaseLotSizeLot size of the item for purchase, only available for Wholesale & Distribution (Premium only)PurchaseLotSize
integer
PurchasePricePurchase price. If neither active nor future price exists, it shows 0 when GETPurchasePrice
float
PurchaseUnitUnit codePurchaseUnit
string
PurchaseUnitDescriptionDescription of unitPurchaseUnitDescription
string
PurchaseUnitFactorThis is the multiplication factor when going from default item unit to the unit of this pricePurchaseUnitFactor
float
PurchaseVATCodeVAT codePurchaseVATCode
string
PurchaseVATCodeDescriptionDescription of VATPurchaseVATCodeDescription
string
StartDateTogether with EndDate this determines whether the price is activeStartDate
datetime
SupplierSupplier IDSupplier
string
SupplierCodeSupplier codeSupplierCode
string
SupplierDescriptionDescription of supplierSupplierDescription
StatusDescriptionDescription of StatusStatusDescription
string
TypeType of Item version: 10-Sales bill of material, 20-Manufacturing recipeType
integer
TypeDescriptionDescription of TypeTypeDescription
string
VersionDateVersion dateVersionDate
datetime
VersionNumberVersion NumberVersionNumber
integer
TimestampTimestampTimestamp
integer
AmountDCAmount in the default currency of the companyAmountDC
float
AmountDiscountDiscount amount in the default currency of the company. Only supported for headerAmountDiscount
float
AmountDiscountExclVatDiscount amount excluding VAT in the default currency of the company. Only supported for headerAmountDiscountExclVat
float
AmountFCAmount in the currency of the transactionAmountFC
float
AmountFCExclVatAmount exclude VAT in the currency of the transaction. Only supported for headerAmountFCExclVat
float
ApprovalStatusApproval status of purchase order. 0=Awaiting approval, 1=Automatically, 2=Approved. Approve a new purchase order by giving value 2 if user has PurchaseOrderApproval right.ApprovalStatus
integer
ApprovalStatusDescriptionDescription of ApprovalStatusApprovalStatusDescription
string
ApprovedApproval datetimeApproved
datetime
ApproverUser who approved the purchase orderApprover
string
ApproverFullNameName of approverApproverFullName
sensiblestring
CostCenterReference to Cost centerCostCenter
string
CostCenterCodeCode of Cost Center (user-defined ID)CostCenterCode
string
CostCenterDescriptionDescription of Cost CenterCostCenterDescription
string
CostUnitReference to Cost UnitCostUnit
string
CostUnitCodeCode of Cost Unit (user-defined ID)CostUnitCode
string
CostUnitDescriptionDescription of Cost UnitCostUnitDescription
string
CreatedCreation dateCreated
datetime
CreatorUser ID of creatorCreator
string
CreatorFullNameName of creatorCreatorFullName
sensiblestring
CurrencyCurrency codeCurrency
string
CustomFieldCustom field endpoint. Provided only for the Exact Online Premium users.CustomField
string
DeliveryAccountReference to account for deliveryDeliveryAccount
DeliveryAddressReference to shipping addressDeliveryAddress
string
DeliveryContactReference to contact for deliveryDeliveryContact
string
DeliveryContactPersonFullNameName of the contact person of the customer who will receive delivered goodsDeliveryContactPersonFullName
sensiblestring
DescriptionDescriptionDescription
string
DiscountDiscount in percentage for item.Discount
float
Division codeDivision
integer
DocumentDocument that is manually linked to the purchase orderDocument
string
DocumentNumberNumber of the documentDocumentNumber
integer
DocumentSubjectSubject of the documentDocumentSubject
string
DropShipmentShows if it is a drop shipment purchase orderDropShipment
boolean
ExchangeRateThe exchange rate between the invoice currency and the default currency of the division.ExchangeRate
float
ExpenseExpense related to the Work Breakdown Structure of the selected project. Only available with a professional service licenseExpense
string
ExpenseDescriptionDescription of expense. Only available with a professional service licenseExpenseDescription
string
IDPrimary keyID
string
IncotermAddressAddress of IncotermIncotermAddress
string
IncotermCodeCode of IncotermIncotermCode
string
IncotermVersionVersion of Incoterm Supported version for Incoterms : 2010, 2020IncotermVersion
integer
InvoicedQuantityQuantity of item that has been invoicedInvoicedQuantity
float
InvoiceStatusInvoice status of purchase order: 10-Open, 20-Partial, 30-Complete, 40-CanceledInvoiceStatus
integer
IsBatchNumberItemIndicates that an Item is an batch itemIsBatchNumberItem
string
IsSerialNumberItemIndicates that an Item is an serial itemIsSerialNumberItem
string
ItemReference to the item for purchase orderItem
string
ItemBarcodeBarcode of the item (numeric string)ItemBarcode
string
ItemCodeItem codeItemCode
string
ItemDescriptionDescription of itemItemDescription
string
ItemDivisableIndicates if fractional quantities of the item can be used, for example quantity = 0.4ItemDivisable
boolean
LineNumberLine numberLineNumber
integer
ModifiedLast modified dateModified
datetime
ModifierUser ID of modifierModifier
string
ModifierFullNameName of modifierModifierFullName
sensiblestring
NetPriceThe net price is the unit price (VAT code taken into account) with any discount appliedNetPrice
float
NotesNotesNotes
string
OrderDateOrder dateOrderDate
datetime
OrderNumberHuman readable id of the purchase orderOrderNumber
integer
OrderStatusPurchase order status: 10-Open, 20-Partial, 30-Complete, 40-CanceledOrderStatus
integer
PaymentConditionThe payment condition code used for due date and discount calculationPaymentCondition
string
PaymentConditionDescriptionDescription of payment conditionPaymentConditionDescription
string
ProjectReference to project. Only available with a professional service licenseProject
string
ProjectCodeProject code. Only available with a professional service licenseProjectCode
string
ProjectDescriptionDescription of the project. Only available with a professional service licenseProjectDescription
string
PurchaseAgentPurchase agentPurchaseAgent
string
PurchaseAgentFullNameName of purchase agentPurchaseAgentFullName
sensiblestring
PurchaseOrderIDThe Purchase OrderID identifies the purchase order. All the lines of a purchase order have the same Purchase Order IDPurchaseOrderID
string
QuantityQuantity in item unitsQuantity
float
QuantityInPurchaseUnitsQuantity in purchase units. Use this field when creating a purchase orderQuantityInPurchaseUnits
float
RebillIndicates whether the purchase order line needs to be rebilled. Only available with a professional service licenseRebill
boolean
ReceiptDateThis field shows the date the goods are expected to be received.ReceiptDate
datetime
ReceiptStatusReceipt status of purchase order: 10-Open, 20-Partial, 30-Complete, 40-CanceledReceiptStatus
integer
ReceivedQuantityQuantity of goods receivedReceivedQuantity
float
RemarksInclude any relevant remarks regarding the purchase order.Remarks
string
SalesOrderReference to sales order when purchase order generated via back to back sales order. Show NULL if more than one sales order is linked to the purchase order.SalesOrder
string
SalesOrderLineSales order line of the sales order that Is linked to a back to back sales order in purchase order. Show NULL if more than one sales order is linked to the purchase order line.SalesOrderLine
string
SalesOrderLineNumberNumber of the sales order line. Show NULL if more than one sales order is linked to the purchase order line.SalesOrderLineNumber
integer
SalesOrderNumberNumber of the sales order. Show NULL if more than one sales order is linked to the purchase order line.SalesOrderNumber
integer
SelectionCodeID of selection code. Only supported by the Plus, Professional and Premium for Wholesale & Distribution and ManufacturingSelectionCode
string
SelectionCodeCodeCode of selection codeSelectionCodeCode
string
SelectionCodeDescriptionDescription of selection codeSelectionCodeDescription
string
SendingMethodSendingMethodSendingMethod
integer
ShippingMethodShipping MethodShippingMethod
string
ShippingMethodCodeCode of Shipping MethodShippingMethodCode
string
ShippingMethodDescriptionDescription of Shipping MethodShippingMethodDescription
string
SourceThis shows how the purchase order was created: 1-Manual entry, 2-Import, 3-Other, 4-Purchase order, 5-Sales order, 6-Supplier's items, 7-Subcontract, 8-Purchase order advice, 9-Shop order, 10-MRP calculation, 11-Rest API, 12-Merge purchase ordersSource
integer
SupplierReference to supplier accountSupplier
string
SupplierCodeCode of supplierSupplierCode
string
SupplierContactContact of supplierSupplierContact
string
SupplierContactPersonFullNameContact person full name of supplierSupplierContactPersonFullName
sensiblestring
SupplierItemCodeCode the supplier uses for this itemSupplierItemCode
string
SupplierItemCopyRemarksIndicate if the notes content should be copied from SupplierItem's remarks. The default follows the CopyRemarks value from SupplierItem. Values: 0 = Do not copy remark, 1 = Copy remarkSupplierItemCopyRemarks
string
SupplierNameName of supplierSupplierName
string
UnitCode of item unitUnit
string
UnitDescriptionDescription of unitUnitDescription
string
UnitPriceItem price per purchase unitUnitPrice
float
VATAmountTotal VAT amount in the currency of the transactionVATAmount
float
VATCodeThe VAT code used when the invoice was registeredVATCode
string
VATDescriptionDescription of vat codeVATDescription
string
VATPercentageThe VAT percentage of the VAT code. This is the percentage at the moment the invoice is created. It's also used by the default calculation of VAT amounts and VAT base amountsVATPercentage
float
WarehouseWarehouseWarehouse
string
WarehouseCodeCode of WarehouseWarehouseCode
string
WarehouseDescriptionDescription of WarehouseWarehouseDescription
string
YourRefThe reference number of the customerYourRef
string
Invoice IDPrimary keyInvoiceID
string
Amount DCFor the header lines (LineNumber = 0) of an entry this is the SUM(AmountDC) of all linesAmountDC
float
Amount DiscountDiscount amount in the default currency of the companyAmountDiscount
float
Amount Discount Exclude VatDiscount amount exclude VAT in the default currency of the companyAmountDiscountExclVat
float
Amount FCFor the header this is the sum of all lines, including VATAmountFC
float
Amount FC Exclude VatFor the header this is the sum of all lines, excluding VATAmountFCExclVat
float
CreatedCreation dateCreated
datetime
CreatorUser ID of creatorCreator
string
Creator Full NameName of creatorCreatorFullName
sensiblestring
CurrencyCurrency for the invoiceCurrency
string
Deliver To IDDelivery account for invoiceDeliverTo
string
Deliver To Address IDAddress of delivery as per invoice delivery accountDeliverToAddress
string
Deliver To Contact Person IDDelivery account person for invoiceDeliverToContactPerson
string
Deliver To NameName of the delivery account's customer as per invoiceDeliverToName
string
DescriptionDescriptionDescription
string
DiscountDiscount percentageDiscount
float
Discount TypeLeading field of total discountDiscountType
integer
Division codeDivision
integer
DocumentDocument that is manually linked to the invoiceDocument
string
Document NumberNumber of the documentDocumentNumber
integer
Document SubjectSubject of the documentDocumentSubject
string
Due DateThe due date for paymentsDueDate
datetime
Extra Duty Amount FCExtra duty amount in the currency of the transactionExtraDutyAmountFC
float
G Account Amount FCA positive value of the amount indicates that the amount is to be paid by the customer to your G bank accountGAccountAmountFC
float
Invoice DateOfficial date for the invoiceInvoiceDate
datetime
Invoice NumberAssigned at entry or at printing depending on settingInvoiceNumber
integer
Invoice To IDReference to the Customer who will receive the invoiceInvoiceTo
string
Invoice To Contact Person IDReference to the Contact person of the customer who will receive the invoiceInvoiceToContactPerson
string
Invoice To Contact Person Full NameName of the contact person of the customer who will receive the invoiceInvoiceToContactPersonFullName
sensiblestring
Invoice To NameName of the customer who will receive the invoiceInvoiceToName
string
JournalThe journal codeJournal
string
Journal DescriptionDescription of JournalJournalDescription
string
ModifiedLast modified dateModified
datetime
Order DateOrder dateOrderDate
datetime
Order NumberNumber to identify the orderOrderNumber
integer
Ordered By IDCustomer who ordered the invoiceOrderedBy
string
Ordered By Contact Person IDContact person of customer who ordered the invoiceOrderedByContactPerson
string
Ordered By Contact Person Full NameName of contact person of customer who ordered the invoiceOrderedByContactPersonFullName
sensiblestring
Ordered By NameName of customer who ordered the invoiceOrderedByName
string
Payment ConditionThe payment condition used for due date and discount calculationPaymentCondition
string
Payment Condition DescriptionDescription of PaymentConditionPaymentConditionDescription
string
Payment ReferencePayment reference for sales invoicePaymentReference
string
RemarksExtra remarksRemarks
string
SalespersonSales representativeSalesperson
string
Salesperson Full NameName of sales representativeSalespersonFullName
DeliveryAddressReference to shipping addressDeliveryAddress
string
DeliveryContactReference to contact for deliveryDeliveryContact
string
DeliveryContactPersonFullNameName of the contact person of the customer who will receive delivered goodsDeliveryContactPersonFullName
sensiblestring
DeliveryDateDate of goods deliveryDeliveryDate
datetime
DeliveryNumberDelivery numberDeliveryNumber
integer
DescriptionHeader descriptionDescription
string
Division codeDivision
integer
DocumentDocument that is manually linked to the sales order deliveryDocument
string
DocumentSubjectDocument SubjectDocumentSubject
string
EntryIDPrimary keyEntryID
string
EntryNumberEntry numberEntryNumber
integer
ModifiedLast modified dateModified
datetime
ModifierUser ID of modifierModifier
string
ModifierFullNameName of modifierModifierFullName
sensiblestring
RemarksRemarksRemarks
string
ShippingMethodReference to shipping method. Define shipping method during POST, else it will be empty by default.ShippingMethod
string
ShippingMethodCodeCode of shipping methodShippingMethodCode
string
ShippingMethodDescriptionDescription of shipping methodShippingMethodDescription
string
TrackingNumberReference to header tracking numberTrackingNumber
string
WarehouseWarehouseWarehouse
string
WarehouseCodeCode of WarehouseWarehouseCode
string
WarehouseDescriptionDescription of WarehouseWarehouseDescription
string
TimestampTimestampTimestamp
integer
BatchNumbersCollection of batch numbersBatchNumbers
string
CreatedCreation dateCreated
datetime
CreatorUser ID of creatorCreator
string
CreatorFullNameName of creatorCreatorFullName
sensiblestring
CustomerItemCodeCode the customer uses for this itemCustomerItemCode
string
DeliveryDateDate of goods deliveryDeliveryDate
datetime
DescriptionDescription of sales order deliveryDescription
string
Division codeDivision
integer
EntryIDThe EntryID identifies the goods delivery. All the lines of a goods delivery have the same EntryIDEntryID
string
IDPrimary key. The unique identifier of a stock transaction for a goods delivery line. A goods delivery line can be split into multiple storage locations. In this case, multiple storage locations will have the same stock transaction ID.ID
TrackingNumberReference to tracking numberTrackingNumber
string
UnitcodeCode of item unitUnitcode
string
IDPrimary keyID
string
TimestampTimestampTimestamp
integer
AmountDCAmount in the default currency of the companyAmountDC
float
AmountDiscountDiscount amount in the default currency of the company. Only supported for headerAmountDiscount
float
AmountDiscountExclVatDiscount amount excluding VAT in the default currency of the company. Only supported for headerAmountDiscountExclVat
float
AmountFCAmount in the currency of the transactionAmountFC
float
AmountFCExclVatAmount exclude VAT in the currency of the transaction. Only supported for headerAmountFCExclVat
float
ApprovalStatusShows if this sales order is approvedApprovalStatus
integer
ApprovalStatusDescriptionDescription of ApprovalStatusApprovalStatusDescription
string
ApprovedApproval datetimeApproved
datetime
ApproverUser who approved the sales orderApprover
string
ApproverFullNameName of approverApproverFullName
sensiblestring
CreatedCreation dateCreated
datetime
CreatorUser ID of creatorCreator
string
CreatorFullNameName of creatorCreatorFullName
sensiblestring
CurrencyCurrency codeCurrency
string
CustomFieldCustom field endpoint. Provided only for the Exact Online Premium users.CustomField
string
DeliverToReference to the delivery customer. For an existing sales order this value can not be changed.DeliverTo
string
DeliverToContactPersonReference to contact person of delivery customerDeliverToContactPerson
string
DeliverToContactPersonFullNameName of contact person of delivery customerDeliverToContactPersonFullName
sensiblestring
DeliverToNameName of delivery customerDeliverToName
string
DeliveryAddressDelivery addressDeliveryAddress
string
DeliveryDateDelivery date of this lineDeliveryDate
datetime
DeliveryStatusShipping status of the sales order. 12=Open, 20=Partial, 21=Complete, 45=CancelledDeliveryStatus
integer
DeliveryStatusDescriptionDescription of DeliveryStatusDeliveryStatusDescription
string
DescriptionDescriptionDescription
string
DiscountDiscount given on the default price. Discount = (DefaultPrice of Item - PriceItem in line) / DefaultPrice of ItemDiscount
float
Division codeDivision
integer
DocumentDocument that is manually linked to the sales orderDocument
string
DocumentNumberNumber of the documentDocumentNumber
integer
DocumentSubjectSubject of the documentDocumentSubject
string
IncotermAddressAddress of IncotermIncotermAddress
string
IncotermCodeCode of IncotermIncotermCode
string
IncotermVersionVersion of Incoterm Supported version for Incoterms : 2010, 2020IncotermVersion
integer
InvoiceStatusInvoice status of the sales order. 12=Open, 20=Partial, 21=Complete, 45=CancelledInvoiceStatus
integer
InvoiceStatusDescriptionDescription of InvoiceStatusInvoiceStatusDescription
string
InvoiceToReference to the customer who will receive the invoice. For an existing sales order this value can not be changed.InvoiceTo
string
InvoiceToContactPersonReference to the contact person of the customer who will receive the invoiceInvoiceToContactPerson
string
InvoiceToContactPersonFullNameName of the contact person of the customer who will receive the invoiceInvoiceToContactPersonFullName
sensiblestring
InvoiceToNameName of the customer who will receive the invoiceInvoiceToName
string
ModifiedLast modified dateModified
datetime
ModifierUser ID of modifierModifier
string
ModifierFullNameName of modifierModifierFullName
sensiblestring
NotesExtra notesNotes
string
OrderDateOrder dateOrderDate
datetime
OrderedByCustomer who ordered the sales order. For an existing sales order this value can not be changed.OrderedBy
string
OrderedByContactPersonContact person of the customer who ordered the sales orderOrderedByContactPerson
string
OrderedByContactPersonFullNameName of contact person of the customer who ordered the sales orderOrderedByContactPersonFullName
sensiblestring
OrderedByNameName of the customer who ordered the sales orderOrderedByName
string
OrderIDThe OrderID identifies the sales order. All the lines of a sales order have the same OrderIDOrderID
string
OrderNumberNumber of sales orderOrderNumber
integer
PaymentConditionThe payment condition used for due date and discount calculationPaymentCondition
string
PaymentConditionDescriptionDescription of PaymentConditionPaymentConditionDescription
string
PaymentReferencePayment reference for sales orderPaymentReference
string
The project to which the sales order line is linked. The project can be different per line. Sometimes also the project in the header is filled although this is not really usedProject
string
ProjectCodeCode of ProjectProjectCode
string
ProjectDescriptionDescription of ProjectProjectDescription
string
RemarksExtra remarksRemarks
string
SalesChannelID of Sales channel.SalesChannel
string
SalesChannelCodeCode of Sales channelSalesChannelCode
string
SalesChannelDescriptionDescription of Sales channelSalesChannelDescription
string
SalespersonSales representativeSalesperson
string
SalespersonFullNameName of sales representativeSalespersonFullName
sensiblestring
SelectionCodeID of selection codeSelectionCode
string
SelectionCodeCodeCode of selection codeSelectionCodeCode
string
SelectionCodeDescriptionDescription of selection codeSelectionCodeDescription
string
ShippingMethodShippingMethodShippingMethod
string
ShippingMethodCodeCode of Shipping MethodShippingMethodCode
string
ShippingMethodDescriptionDescription of Shipping MethodShippingMethodDescription
string
StatusThe status of the sales order. 12 = Open, 20 = Partial, 21 = Complete, 45 = Cancelled.Status
integer
StatusDescriptionDescription of StatusStatusDescription
string
VATAmountVAT amount in the currency of the transactionVATAmount
float
VATCodeVAT codeVATCode
string
VATCodeDescriptionDescription of VATCodeVATCodeDescription
string
WarehouseCodeCode of WarehouseWarehouseCode
string
WarehouseDescriptionDescription of WarehouseWarehouseDescription
string
WarehouseIDWarehouseWarehouseID
string
YourRefThe reference number of the customerYourRef
string
¿Necesita un dataset, métrica o atributo que no ve?
Se ejecuta según su programación. Los datasets con rango de fechas vuelven a leer una ventana móvil en cada ejecución, las listas como Aging Receivables extraen todos los datos actuales y una resincronización completa de datos carga el historial anterior.
Más aciertos. La mitad de errores presentados como hechos.
Planteamos 43 preguntas registradas de antemano sobre tres conjuntos de datos reales - Google Search Console, deals de HubSpot y Google Ads - y entregamos las mismas filas al mismo modelo de cuatro formas. Solo cambió la capa de datos.
78,5 %
de las preguntas respondidas correctamente - el mejor de los cuatro métodos de entrega probados
2x
menos respuestas erróneas presentadas como seguras - 14,0 % de las ejecuciones frente a 24,0 % y 26,3 %
2,8x
más respuestas correctas con datos de CRM desordenados - mejor en 8 preguntas, peor en ninguna
Respuestas correctasLas 43 preguntas - más es mejor
Dataddo Data to AI™78,5 %
Conector SQL genérico71,5 %
Archivos CSV + documentación69,0 %
Archivos CSV65,5 %
Incorrectas, pero presentadas como hechosPorcentaje de ejecuciones - menos es mejor
Dataddo Data to AI™14,0 %
Archivos CSV + documentación24,0 %
Conector SQL genérico26,3 %
Archivos CSV33,3 %
El mismo modelo, las mismas instrucciones y las mismas filas en todas las condiciones; 759 ejecuciones evaluadas, con las respuestas de referencia fijadas antes de cualquier ejecución. Solo en Google Search Console, los archivos CSV documentados rindieron igual que Data to AI™: la ventaja viene de datos más complejos, como los deals de HubSpot.
Extraiga con Dataddo datasets de Exact Online como Sales - Invoices, Receivables y Payments, y vincúlelos a un destino de Copilot o a un AI Model. En Copilot Studio, añada una herramienta Model Context Protocol que apunte a https://headless.dataddo.com/mcp-data, inicie sesión con OAuth 2.0 Dynamic discovery y publique el agente en Teams y Microsoft 365 Copilot.
¿Cómo acceden los usuarios de Teams a los datos de Exact Online?
Mediante un agente de Copilot Studio con Dataddo Data Access como herramienta MCP. Publíquelo en Channels > Teams and Microsoft Copilot, y los usuarios lo mencionan con @ en chats y canales para preguntar por facturas o cobros.
¿Qué debe decir la descripción del servidor para un agente de Exact Online?
El agente usa la descripción para decidir cuándo llamar a Dataddo. Mencione facturas, cobros, pagos y pérdidas y ganancias de Exact Online, para que las preguntas financieras activen una consulta y las conversaciones no relacionadas no.
¿Puede GitHub Copilot leer datos de Exact Online en VS Code?
Sí. Añada la URL de Dataddo a .vscode/mcp.json con type http, inicie el servidor e inicie sesión, y luego use Copilot Chat en Agent mode. En Copilot Business y Enterprise, un administrador debe habilitar los servidores MCP en la política de Copilot.
Tenemos varias divisiones de Exact Online. ¿Puede un solo agente cubrirlas todas?
Sí, si los flujos las incluyen. La extracción multicuenta recoge un dataset de todas las entidades a las que tiene acceso, y el agente puede desglosar las cifras por Division cuando el dataset tiene ese campo.
¿Qué datasets de Exact Online son adecuados para un agente en Teams?
Empiece por lo que más se pregunta: Sales - Invoices para consultas de estado, Receivables y Payments para la caja por vencer, y Financial - Profit and Loss para los resultados. Vincule solo los datasets que deba ver el público del agente.
¿Puede el agente de Copilot aprobar facturas de proveedores en Exact Online?
No. El agente solo lee datos extraídos a través de Dataddo. Se puede consultar el Approval Status de Payables list, pero aprobar o modificar una factura se sigue haciendo en el propio Exact Online.