Data model and field mappings in edoc D365 FO invoice cockpit

edoc D365 FO invoice cockpit has its own data model so that it can communicate with edoc invoice.

Using the data model, you can categorize the data, e.g. for an invoice in the third-party application, in order to use corresponding fields for the data transfer between edoc invoice and edoc invoice cockpit.

The respective endpoints for the required invoice data are saved in tables with the following names:

EDIVCSTGstatus: Endpoint (entity) for the status of an invoice. This table contains the general properties of an invoice and its status (document ID, event name, event ID).
EDIVSTGheadValue: Endpoint (entity) for the header fields of an invoice. This table contains the general properties of an invoice and its base data (master data).
EDIVSTGheadpositionValuesV2: Endpoint (entity) for the purchase order lines of an invoice. This table contains the general properties of an invoice and the posting details.

Basic knowledge of the data model and field mappings

The data model with the corresponding fields expects a certain naming convention for the fields in edoc invoice.

You must use the naming convention for field names in edoc invoice, otherwise the data transfer will fail.

You must map the edoc invoice fields to the corresponding fields of the respective endpoints (entities, tables).

The data model of the individual endpoints (tables) contains a large number of different fields. Certain fields are used by default in edoc invoice cockpit. This standard allows you to quickly implement a functioning data transfer between the applications.

All default fields from edoc invoice are mandatory fields. If you want to implement further scenarios or information for a data transfer, you can use the optional fields that have not yet been used.

The mapping of the fields also depends on the respective invoice category: invoice without order reference, invoice with order reference and invoices for fixed assets.

EDIVCSTGstatus table and field mappings (overview)

The fields used by edoc D365 FO invoice cockpit by default can be found in the Mandatory field column with the entry Yes. The columns for the invoice category contain the respective fields in edoc invoice cockpit if the edoc invoice field is used for the category.

The fields in the EDIVCSTGstatus table are used for all invoice categories: Invoice with and without purchase order reference and fixed assets.

All fields marked with No are available for further scenarios.

edoc invoice field	Dynamics 365 field	Mandatory field	Field for invoice without order reference	Field for invoice with order reference	Field for invoice for fixed assets	Description
event_id	EventId	Yes	Mapped using the base data (master data).	Mapped using the base data (master data).	Mapped using the base data (master data).	Is the event ID of the record.
event_name	EventName	Yes	Mapped using the base data (master data).	Mapped using the base data (master data).	Mapped using the base data (master data).	Is the name of the event. The event name must be Post.
ecm_id	ECMDocuId	Yes	ECM Document ID field ECMDocuId database field	ECM Document ID field ECMDocuId database field	ECM Document ID field ECMDocuId database field	Is the document ID.
created_at	CreatedAt	Yes	Creation date and time field createdDateTime database field	Creation date and time field createdDateTime database field	Creation date and time field createdDateTime database field	Is the creation date of the invoice in edoc invoice.
transferred_at	TransferredAt	No	-	-	-	Deprecated. Only exists for reasons of backwards compatibility. Is the transfer date of the invoice after the transfer from edoc invoice to Dynamics 365.
schema_version	SchemaVersion	Yes	Mapped using the base data (master data).	Mapped using the base data (master data).	Mapped using the base data (master data).	Displays the schema version used in edoc invoice.
edoc_document_id	edoc_document_Id	Yes	Mapped using the base data (master data).	Mapped using the base data (master data).	Mapped using the base data (master data).	If the supplying ECM system provides a document ID, the document ID must be used in GUID format. Is identical to the value of ecm_id and refers to edoc documents.
text_01..text_20	Text01..Text20	No	-	-	-	You can use this data type field for your own purposes.
int_01..int_05	Int01..Int05	No	-	-	-	You can use this data type field for your own purposes.
real_01..real_05	Real01..Real05	No	-	-	-	You can use this data type field for your own purposes.
date_01..date_05	Date01..Date05	No	-	-	-	You can use this data type field for your own purposes.
datetime_01..datetime_05	UTCDatetime01..UTCDatetime05	No	-	-	-	You can use this data type field for your own purposes.

EDIVSTGheadValue table and field mappings (overview)

All fields marked with No are available for further scenarios.

edoc invoice field	Dynamics 365field	Mandatory field	Field for invoice without order reference	Field for invoice with order reference	Field for invoice for fixed assets	Description
event_id	EventId	Yes	Only displayed in the staging tables.	Only displayed in the staging tables.	Only displayed in the staging tables.	The event ID must be specified in GUID format.
ecm_id	ECMDocuId	Yes	ECM Document ID field	ECM Document ID field	ECM Document ID field	Is the document ID from the ECM system.
company_id	ExtCompany	No	-	-	-	Is a default field from edoc invoice, is irrelevant for edoc invoice cockpit.
finance_id	Company	Yes	Company field Company database field	Company field Company database field	Company field Company database field	Specifies the ID of the company.
barcode	BarcodeId	No	Barcode fieldBarcodeId database field	Barcode field BarcodeId database field	Barcode fieldBarcodeId database field	Specifies the ID of the barcode. If you use barcodes in your ECM system, you can use this field.
vendor_id	InvoiceAccount	Yes	Invoice account fieldInvoiceAccount database field	Invoice account field InvoiceAccount database field	Invoice account fieldInvoiceAccount database field	Specifies the vendor's invoice account.
vendor_name	VendName	Yes	Mapped using the base data (master data).	Mapped using the base data (master data).	Mapped using the base data (master data).	Is a default field from edoc invoice and has no effect on the posting logic. The default field is only used for display in edoc invoice cockpit. Specifies the name of the vendor.
vendor_vat_id	VendVATId	Yes	Mapped using the base data (master data).	Mapped using the base data (master data).	Mapped using the base data (master data).	Is a default field from edoc invoice, is irrelevant for edoc invoice cockpit and has no effect on the posting logic. The default field is only used for display in edoc invoice cockpit. Specifies the VAT identification number of the vendor.
vendor_tax_id	VendTaxRegNum	Yes	Mapped using the base data (master data).	Mapped using the base data (master data).	Mapped using the base data (master data).	Is a default field from edoc invoice, is irrelevant for edoc invoice cockpit and has no effect on the posting logic. The default field is only used for display in edoc invoice cockpit. Specifies the VAT identification number of the vendor.
vendor_address_street	VendAddressStreet	No	Mapped using the base data (master data).	Mapped using the base data (master data).	Mapped using the base data (master data).	Is a default field from edoc invoice, is irrelevant for edoc invoice cockpit and has no effect on the posting logic. Specifies the street in the vendor's address.
vendor_address_city	VendAddressCity	No	Mapped using the base data (master data).	Mapped using the base data (master data).	Mapped using the base data (master data).	Is a default field from edoc invoice, is irrelevant for edoc invoice cockpit and has no effect on the posting logic. Specifies the location in the vendor's address.
vendor_address_zip	VendAddressZip	No	Mapped using the base data (master data).	Mapped using the base data (master data).	Mapped using the base data (master data).	Is a default field from edoc invoice, is irrelevant for edoc invoice cockpit and has no effect on the posting logic. Specifies the postal code in the vendor's address.
vendor_address_country	VendAddressCountry	No	Mapped using the base data (master data).	Mapped using the base data (master data).	Mapped using the base data (master data).	Is a default field from edoc invoice, is irrelevant for edoc invoice cockpit and has no effect on the posting logic. Specifies the country/region in the vendor's address.
vendor_bank_iban	VendIBAN	No	Mapped using the base data (master data).	Mapped using the base data (master data).	Mapped using the base data (master data).	Is a default field from edoc invoice, is irrelevant for edoc invoice cockpit and has no effect on the posting logic. Specifies the IBAN of the vendor's bank details.
vendor_bank_bic	VendBIC	No	Mapped using the base data (master data).	Mapped using the base data (master data).	Mapped using the base data (master data).	Is a default field from edoc invoice, is irrelevant for edoc invoice cockpit and has no effect on the posting logic. Specifies the bank identification code of the vendor's bank details.
vendor_bank_account	BankAccount	No	Mapped using the base data (master data).	Mapped using the base data (master data).	Mapped using the base data (master data).	Is a default field from edoc invoice, is irrelevant for edoc invoice cockpit and has no effect on the posting logic. Specifies the account number of the vendor.
vendor_bank_code	BankCode	No	-	-	-	Is a default field from edoc invoice, is irrelevant for edoc invoice cockpit.
vendor_bank_name	BankName	No	Mapped using the base data (master data).	Mapped using the base data (master data).	Mapped using the base data (master data).	Is a default field from edoc invoice, is irrelevant for edoc invoice cockpit and has no effect on the posting logic. Specifies the name of the vendor's bank.
invoice_type_id	InvoiceTypeId	Yes	Mapped using the base data (master data).	Mapped using the base data (master data).	Mapped using the base data (master data).	Specifies the ID with which an invoice is typed in edoc invoice.
invoice_type_text	InvoiceTypeText	Yes	Mapped using the base data (master data).	Mapped using the base data (master data).	Mapped using the base data (master data).	Specifies the invoice type: Invoice or credit memo or invoice for fixed assets.
confidential	Confidential	No	Mapped using the base data (master data).	Mapped using the base data (master data).	Mapped using the base data (master data).	Is a default field from edoc invoice, is irrelevant for edoc invoice cockpit and has no effect on the posting logic. Specifies whether the content has been declared confidential.
workflow_type	WorkflowType	Yes	Only displayed in the staging tables.	Only displayed in the staging tables.	Only displayed in the staging tables.	Specifies the invoice category (invoice with or without order reference) that is used for the posting method.
order_numbers	PurchId	Yes	-	Purchase order field PurchId database field	-	Mandatory field for invoice with order reference. Specifies the purchase order number on the invoice.
delivery_notes	PackingSlipId	Yes	-	Product receipt field PackingSlipId database field	-	Mandatory field for invoice with order reference. Specifies that this is a packing slip.
external_number	ExternalInvoice	Yes	Invoice field Invoice database field	Number field Num database field	Invoice field Invoice database field	Specifies the external invoice number.
internal_number	InternalInvoice	No	Only displayed in the staging tables.	Only displayed in the staging tables.	Only displayed in the staging tables.	Is a default field from edoc invoice, is irrelevant for edoc invoice cockpit and has no effect on the posting logic. Specifies the internal invoice number.
invoice_date	InvoiceDate	Yes	Invoice date field InvoiceDate database field	Invoice date field InvoiceDate database field	Invoice date field InvoiceDate database field	Specifies the invoice date.
valuta_date	ValueDate	No	Only displayed in the staging tables.	Only displayed in the staging tables.	Only displayed in the staging tables.	Is a default field from edoc invoice, is irrelevant for edoc invoice cockpit and has no effect on the posting logic. Specifies the value date.
performance_date	DueDate	No	Mapped using the base data (master data).	Mapped using the base data (master data).	Mapped using the base data (master data).	Is a default field from edoc invoice, is irrelevant for edoc invoice cockpit and has no effect on the posting logic. Specifies the due date of the invoice.
posting_date	PostingDate	Yes	Field Posting date PostingDate database field	Field Posting date PostingDate database field	Field Posting date PostingDate database field	Specifies the date of the invoice posting.
currency	Currencycode	Yes	Currency field Currencycode database field	Currency field Currencycode database field	Currency field Currencycode database field	Specifies the currency in which the invoice is to be paid.
exchange_rate	ExchangeRate	No	Only displayed in the staging tables.	Only displayed in the staging tables.	Only displayed in the staging tables.	Is a default field from edoc invoice, is irrelevant for edoc invoice cockpit and has no effect on the posting logic. Specifies the exchange rate for the currency in which the invoice is paid.
net_amount_1	AmountNet	Yes	Amount Net field AmountNet database field	Amount Net field AmountNet database field	Amount Net field AmountNet database field	Specifies the total net amount in which the invoice will be paid.
vat_amount_1	AmountTax	Yes	Amount Tax field AmountTax database field	Amount Tax field AmountTax database field	Amount Tax field AmountTax database field	Specifies the VAT amount of the invoice.
vat_percent_1	PercentTax	Yes	Only displayed in the staging tables.	Only displayed in the staging tables.	Only displayed in the staging tables.	Specifies the VAT percentage.
net_amount_2..net_amount_4	AmountNet2..AmountNet2	No	-	-	-	Only applies to invoice with order reference. Specifies the net amount of the invoice.
vat_amount_2..vat_amount_4	AmountTax2..AmountTax2	No	-	-	-	Only applies to invoice with order reference. Specifies the VAT amount of the invoice.
vat_percent_2..vat_percent_4	PercentTax2..PercentTa4	No	-	-	-	Specifies the VAT percentage. Only applies to invoice with order reference.
net_total	AmountNetTotal	Yes	Only displayed in the staging tables.	Only displayed in the staging tables.	Only displayed in the staging tables.	Specifies the net amount of the invoice. Is identical to the value in net_amount_1.
vat_total	AmountTaxTotal	Yes	Only displayed in the staging tables.	Only displayed in the staging tables.	Only displayed in the staging tables.	Specifies the VAT amount of the invoice. Is identical to the value in vat_amount_1.
gross	AmountLarge	Yes	Field Amount Database field Amount	Field Amount Database field Amount	Field Amount Database field Amount	Specifies the gross amount of the invoice.
payment_terms_id	PaymTerm	Yes	Payment term field PaymTerm database field	Payment term field PaymTerm database field	Payment term field PaymTerm database field	Specifies the payment term for the invoice.
payment_terms_text	PaymDiscDesc	No	Only displayed in the staging tables.	Only displayed in the staging tables.	Only displayed in the staging tables.	Specifies the definition for the payment term.
payment_discount_days	PaymDiscDays	No	Only displayed in the staging tables.	Only displayed in the staging tables.	Only displayed in the staging tables.	Specifies the number of days until the cash discount is due.
payment_discount_month	PaymDiscMonths	No	Only displayed in the staging tables.	Only displayed in the staging tables.	Only displayed in the staging tables.	Specifies the number of months until the cash discount is due.
payment_discount_percent	PaymDiscPercent	No	Only displayed in the staging tables.	Only displayed in the staging tables.	Only displayed in the staging tables.	Specifies the percentage for the cash discount deduction.
payment_net_days	PaymNetDays	No	Only displayed in the staging tables.	Only displayed in the staging tables.	Only displayed in the staging tables.	Specifies the number of days until net payment.
payment_net_month	PaymNetMonths	No	Only displayed in the staging tables.	Only displayed in the staging tables.	Only displayed in the staging tables.	Specifies the number of months when the total net amount is due.
payment_due_date	PaymDueDate	No	Only displayed in the staging tables.	Only displayed in the staging tables.	Only displayed in the staging tables.	Is a default field from edoc invoice, is irrelevant for edoc invoice cockpit and has no effect on the posting logic. Specifies the due date of the invoice.
payment_discount_date	PaymDiscDate	No	Only displayed in the staging tables.	Only displayed in the staging tables.	Only displayed in the staging tables.	Specifies the date until which the discount is granted for the invoice amount.
payment_discount_amount	PaymDiscAmount	No	Only displayed in the staging tables.	Only displayed in the staging tables.	Only displayed in the staging tables.	Specifies the cash discount amount.
payment_discount_use	IsPaymDisc	No	Mapped using the base data (master data).	Mapped using the base data (master data).	Mapped using the base data (master data).	Is a default field from edoc invoice, is irrelevant for edoc invoice cockpit and has no effect on the posting logic. Specifies whether a cash discount is granted.
payment_term	PaymDiscCode	No	Mapped using the base data (master data).	Mapped using the base data (master data).	Mapped using the base data (master data).	Is a default field from edoc invoice, is irrelevant for edoc invoice cockpit and has no effect on the posting logic. Specifies the payment term for the invoice.
payment_mode	PaymMode	Yes	Payment method field PaymMode database field	Payment method field PaymMode database field	Payment method field PaymMode database field	Specifies the payment method (SEPA, direct debit, etc.) for the invoice.
vendTransPaymId	VendTransPaymId	No	-	-	-	Deprecated. Only exists for reasons of backwards compatibility. Is identical to the vendor_id field from edoc invoice.
text_01..text_20	Text01..Text20	No	-	-	-	You can use this data type field for your own purposes.
int_01..int_05	Int01..Int05	No	-	-	-	You can use this data type field for your own purposes.
real_01..real_05	Real01..Real05	No	-	-	-	You can use this data type field for your own purposes.
date_01..date_05	Date01..Date05	No	-	-	-	You can use this data type field for your own purposes.
datetime_01..datetime_05	UTCDatetime01..UTCDatetime05	No	-	-	-	You can use this data type field for your own purposes.
markup_alloc_after_enum	MarkupAllocAfter	Yes	-	Charges allocation field MarkupAllocateAfter database field	-	Specifies how the charges (markups) are to be assigned per net amount, quantity, and item.
markup_alloc_on_enum	MarkupAllocOn	Yes	-	Allocate charges to lines field MarkupAllocateOn database field	-	Specifies how the charges are to be assigned to the item lines.
markup_alloc_isAll_enum	MarkupAllocIsAll	Yes	-	Allocate all field MarkupAllocateIsAll database field	-	Specifies whether charges are to be assigned to all purchase order lines.
markup_alloc_isOnlyStock_enum	MarkupAllocIsOnlyStock	Yes	-	In stock field MarkupAllocateIsOnlyStock database field	-	Specifies whether charges should only be assigned to stored purchase order lines.
posted_date	PostedDate	Yes	-	-	-	From edoc invoice schema version 5. Specifies the date on which the workflow was completed.
posted_clerk	PostedClerk	Yes	-	-	-	From edoc invoice schema version 5. Specifies the name of the assigned person (clerk) who completed the workflow.
posted_group	PostedGroup	Yes	-	-	-	From edoc invoice schema version 5. Specifies the name of the workflow group in which the person responsible for completing the workflow is located. If the person is in several workflow groups, all groups are specified.

EDIVSTGheadpositionValuesV2 table and field mappings (overview)

All fields marked with No are available for further scenarios.

edoc invoice field	Dynamics 365field	Mandatory field	Field for invoice without order reference	Field for invoice with order reference	Field for invoice for fixed assets	Description
event_id	EventId	Yes	Only displayed in the staging tables.	Only displayed in the staging tables.	Only displayed in the staging tables.	The event ID must be specified in GUID format.
ecm_id	ECMDocuId	Yes	ECMDocuId field	ECM Document ID field	ECM Document ID field	Is the document ID from the ECM system.
row_index	LineNum	Yes	Line number field LineNum database field	Line number field LineNum database field	Line number field LineNum database field	Specifies the number of the purchase order line.
account	LineAccount	Yes	Ledger account field LineAccount database field	Ledger account field LineAccount database field	Ledger account field LineAccount database field	Specifies the ledger account in Dynamics 365.
cost_center	CostCenter	No	Mapped using the base data (master data).	Mapped using the base data (master data).	Mapped using the base data (master data).	Specifies the cost center of the financial dimensions to which the purchase order line is posted in Dynamics 365.
cost_object	CostObject	No	Mapped using the base data (master data).	Mapped using the base data (master data).	Mapped using the base data (master data).	Is a default field from edoc invoice, is irrelevant for edoc invoice cockpit and has no effect on the posting logic. The default field is only used for display in edoc invoice cockpit. Specifies the cost object of the financial dimensions.
KST1..KST2	FinDim01..FinDim02	No	-	-	-	Are default fields from edoc invoice, are irrelevant for edoc invoice cockpit and have no effect on the posting logic. Specifies an additional cost center in each case.
posting_key	PostingKey	No	Mapped using the base data (master data).	Mapped using the base data (master data).	Mapped using the base data (master data).	Is a default field from edoc invoice, is irrelevant for edoc invoice cockpit and has no effect on the posting logic. The default field is only used for display in edoc invoice cockpit.
net_amount	AmountNet	Yes	Amount Net field AmountNet database field	Amount Net field AmountNet database field	Amount Net field AmountNet database field	Specifies the net amount of the invoice.
vat_amount	AmountTax	Yes	Amount Tax field AmountNet database field	Amount Tax field AmountNet database field	Amount Tax field AmountNet database field	Specifies the VAT amount of the net amount.
vat_percent	PercentTax	Yes	Percent Tax field PercentTax database field	Percent Tax field PercentTax database field	Percent Tax field PercentTax database field	Specifies the VAT percentage of the invoice.
vat_code	VatCode	Yes	Mapped using the base data (master data).	Mapped using the base data (master data).	Mapped using the base data (master data).	Is a default field from edoc invoice, is irrelevant for edoc invoice cockpit and has no effect on the posting logic. The default field is only used for display in edoc invoice cockpit. Specifies the VAT code.
gross_amount	Amount	Yes	Mapped using the base data (master data).	Mapped using the base data (master data).	Mapped using the base data (master data).	Specifies the gross amount of the invoice total.
order_number	PurchId	Yes	-	Purchase order field PurchId database field	-	Specifies the order number of the invoice with order reference.
delivery_note	PackingSlipId	Yes	-	Packing slip field PackingSlipId database field	-	Specifies the packing slip number of the invoice with order reference.
quantity	Qty	Yes	-	Field Quantity Qty database field	-	Specifies the quantity of items delivered.
unit_price	Price	Yes	-	Price field Price database field	-	Specifies the price per item.
price_units	PriceUnits	Yes	-	Price unit field PriceUnits database field	-	Specifies the unit as a decimal number for the price, e.g. for a single item, a dozen or per pallet.
item_number	ItemId	Yes	-	Item number field ItemId database field	-	Specifies the item number.
item_description	ItemDescription	Yes	-	Item description field ItemDescription database field	-	Specifies the item description.
posting_text	PostingText	Yes	-	Posting text field PostingText database field	-	Specifies a description as posting text.
order_position	PurchLinenum	Yes	-	Purchase line number field PurchLinenum database field	-	Specifies the number of the purchase order line.
asset_number	AssetNum	No	-	-	-	Deprecated. Only exists for reasons of backwards compatibility.
fixed_assetid	FixedAssetId	Yes	-	-	Asset number field FixedAssetId database field	Specifies the ID of the fixed asset.
tax_code	TaxCode	Yes	-	Sales Tax Code field TaxCode database field	-	Specifies the sales tax code.
tax_item_code	TaxItemCode	Yes	-	Item sales tax group field TaxItemCode database field	-	Specifies the sales tax group for the item.
tax_code_group	TaxCodeGroup	Yes	-	Sales tax group field TaxCodeGroup database field	-	Specifies the sales tax group.
exception_type	ExceptionType	Yes	-	Only displayed in the staging tables.	-	This field is only used if there are charges (markup) for line items or header data.
text_01..text_20	Text01..Text20	No	-	-	-	You can use this data type field for your own purposes.
int_01..int_05	Int01..Int05	No	-	-	-	You can use this data type field for your own purposes.
real_01..real_05	Real01..Real05	No	-	-	-	You can use this data type field for your own purposes.
date_01..date_05	Date01..Date05	No	-	-	-	You can use this data type field for your own purposes.
datetime_01..datetime_05	UTCDatetime01..UTCDatetime05	No	-	-	-	You can use this data type field for your own purposes.
findim01..findim10	FinDim01..FinDim10	No	-	-	-	You can use this data type field for your own purposes.