Data model and field mappings in edoc D365 BC invoice cockpit

edoc D365 BC invoice cockpit has its own data model to 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 D365 BC invoice cockpit.

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

Edoc Inv. Cp. Transfer Status: 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).
Edoc Inv. Cp. Transfer Header: Endpoint (entity) for the header fields of an invoice. This table contains the general properties of an invoice and its master data.
Edoc Inv. Cp. Transfer Pos.: End point (entity) for the 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.

Some default fields from edoc invoice are only mandatory in certain constellations of the setup.

The mappings of the fields also depends on the respective invoice category: invoice without order reference and invoices for fixed assets, invoices with order reference. On the Business Central side, you can also enter invoices without an order reference for two different purchasing processes: Purchase journal or Purchase invoice. In some cases, the mapped fields are therefore different.

"Edoc Inv. Cp. Transfer status" table and field mappings (overview)

By default, you can find the fields used by edoc D365 BC invoice cockpit in the Mandatory field column with the entry Yes. The columns for the invoice category contain the respective fields in edoc D365 BC invoice cockpit if the edoc invoice field is used for the category.

The fields in the Edoc Inv. Cp. Transfer Status table are used for all invoice categories: Invoice with and without order reference and fixed assets.

All fields marked with No are available for further scenarios.

edoc invoice field	Dynamics 365 BC field	Mandatory field	Field for invoice without order reference in table 81 "Gen. Journal Line"	Field for invoice without order reference in table 38 "Purchase Header"	Field for invoice with order reference in table 38 "Purchase header"	Description
event_id	event_id	Yes	Without effect.	Without effect.	Without effect.	The field has no effect.
event_name	event_name	No	Without effect.	Without effect.	Without effect.	The field has no effect.
ecm_id	ecm_id	No	Without effect.	Without effect.	Without effect.	The field has no effect.
created_at	created_at	No	Without effect.	Without effect.	Without effect.	The field has no effect.
transferred_at	transferred_at	No	Without effect.	Without effect.	Without effect.	The field has no effect.
schema_version	schema_version	No	Without effect.	Without effect.	Without effect.	The field has no effect.
edoc_document_id	edoc_document_id	No	Without effect.	Without effect.	Without effect.	The field has no effect.

"Edoc Inv. Cp. Transfer header" table and field mappings (overview)

All fields marked with No are available for further scenarios.

All fields marked with Setup-dependent are only mandatory fields in certain constellations if you have defined the field as mandatory in Business Central.

edoc invoice field	Dynamics 365 BC field	Mandatory field	Field for invoice without order reference in table 81 "Gen. Journal Line"	Field for invoice without order reference in table 38 "Purchase Header"	Field for invoice with order reference in table 38 "Purchase header"	Description
event_id	event_id	Yes	Without effect.	Without effect.	Without effect.	The event ID must be specified in GUID format.
ecm_id	ecm_id	Yes	Field edoc invoice cockpit ECM ID Database field Edoc Invoice Cockpit ECM ID	Field edoc invoice cockpit ECM ID Database field Edoc Invoice Cockpit ECM ID	Field edoc invoice cockpit ECM ID Database field Edoc Invoice Cockpit ECM ID	Is the document ID from the ECM system.
company_id	company_id	Yes	Without effect.	Without effect.	Without effect.	Specifies the ID of the company. If the field matches the Company field in edoc invoice cockpit Setup, the process is imported with event_id.
finance_id	finance_id	No	Without effect.	Without effect.	Without effect.	The field has no effect.
barcode	barcode	No	Without effect.	Without effect.	Without effect.	The field has no effect.
vendor_id	vendor_id	Yes	Field Account No. Database field Account No.	Field Vendor no. Database field Buy-from Vendor No.	Field Vendor no. Database field Buy-from Vendor No.	Specifies the vendor number.
vendor_name	vendor_name	No	Without effect.	Without effect.	Without effect.	The field has no effect.
vendor_vat_id	vendor_vat_id	No	Without effect.	Without effect.	Without effect.	The field has no effect.
vendor_tax_id	vendor_tax_id	No	Without effect.	Without effect.	Without effect.	The field has no effect.
vendor_address_street	vendor_address_street	No	Without effect.	Without effect.	Without effect.	The field has no effect.
vendor_address_city	vendor_address_city	No	Without effect.	Without effect.	Without effect.	The field has no effect.
vendor_address_zip	vendor_address_zip	No	Without effect.	Without effect.	Without effect.	The field has no effect.
vendor_address_country	vendor_address_country	No	Without effect.	Without effect.	Without effect.	The field has no effect.
vendor_bank_iban	vendor_bank_iban	No	Without effect.	Without effect.	Without effect.	The field has no effect.
vendor_bank_bic	vendor_bank_bic	No	Without effect.	Without effect.	Without effect.	The field has no effect.
vendor_bank_account	vendor_bank_account	No	Without effect.	Without effect.	Without effect.	The field has no effect.
vendor_bank_code	vendor_bank_code	No	Without effect.	Without effect.	Without effect.	The field has no effect.
vendor_bank_name	vendor_bank_name	No	Without effect.	Without effect.	Without effect.	The field has no effect.
invoice_type_id	invoice_type_id	Yes	Field Document type Database field Document Type	Field Document type Database field Document Type	Field Document type Database field Document Type	Specifies the ID with which an invoice is typed in edoc invoice. Permitted values are 1 and 2: 1 is used for an invoice. 2 is used for a credit memo.
invoice_type_text	invoice_type_text	No	Without effect.	Without effect.	Without effect.	The field has no effect.
confidential	confidential	No	Without effect.	Without effect.	Without effect.	The field has no effect.
workflow_type	workflow_type	Yes	Without effect.	Without effect.	Without effect.	Specifies the invoice category (invoice with or without order reference) for an invoice or credit memo that is used for the posting method. Only two values are permitted: Invoice without order reference or Invoice with order reference.
order_numbers	order_numbers	No	Without effect.	Without effect.	Without effect.	The field has no effect.
delivery_notes	delivery_notes	No	Without effect.	Without effect.	Without effect.	The field has no effect.
external_number	external_number	Setup-dependent	Field External document No. Database field External Document No.	Field Vendor Invoice No. Database field Vendor Invoice No. Field Vendor Cr. Memo No. Database field Vendor Cr. Memo No.	Field Vendor Invoice No. Database field Vendor Invoice No. Field Vendor Cr. Memo No. Database field Vendor Cr. Memo No.	Specifies the external invoice or credit memo number. The mandatory field property is dependent on the field Ext. Doc. No. Mandatory on the Purchase & Payable Setup page.
internal_number	internal_number	No	Without effect.	Without effect.	Without effect.	The field has no effect.
invoice_date	invoice_date	Yes	Field Document date Database field Document Date Field Posting date (optional) Database field Posting date	Field Document date Database field Document Date Field Posting date (optional) Database field Posting date	Field Document date Database field Document Date Field Posting date (optional) Database field Posting date	Specifies the invoice date. Is setup-dependent (optional): If the Posting date field has the value Document date on the edoc invoice cockpit Setup page.
valuta_date	valuta_date	No	Without effect.	Without effect.	Without effect.	The field has no effect.
performance_date	performance_date	Setup-dependent	Field Posting date Database field Posting Date	Field Posting date Database field Posting Date	Field Posting date Database field Posting Date	Is setup-dependent: If the Posting date field has the value Performance date on the edoc invoice cockpit Setup page.
posting_date	posting_date	Setup-dependent	Field Posting date Database field Posting Date	Field Posting date Database field Posting Date	Field Posting date Database field Posting Date	Specifies the date of the invoice posting. The mandatory field property and its use depend on the setup: If the field Posting date has the value Workflow completion date on the edoc invoice cockpit Setup page. If the Posting date field has the value Document date or Performance date on the edoc invoice cockpit Setup page, but the edoc invoice fields invoice_date and performance_date are empty.
currency	currency	No	Field Currency code Database field Currency Code	Field Currency code Database field Currency Code	Field Currency code Database field Currency Code	Specifies the currency in which the invoice is to be paid.
exchange_rate	exchange_rate	No	Without effect.	Without effect.	Without effect.	The field has no effect.
net_amount_1	net_amount_1	No	Without effect.	Without effect.	Without effect.	The field has no effect.
vat_amount_1	vat_amount_1	No	Without effect.	Without effect.	Without effect.	The field has no effect.
vat_percent_1	vat_percent_1	No	Without effect.	Without effect.	Without effect.	The field has no effect.
net_amount_2..net_amount_4	net_amount_2..net_amount_4	No	Without effect.	Without effect.	Without effect.	The field has no effect.
vat_amount_2..vat_amount_4	vat_amount_2..vat_amount_4	No	Without effect.	Without effect.	Without effect.	The field has no effect.
vat_percent_2..vat_percent_4	vat_percent_2..vat_percent_4	No	Without effect.	Without effect.	Without effect.	The field has no effect.
net_total	net_total	No	Without effect.	Without effect.	Without effect.	The field has no effect.
vat_total	vat_total	No	Without effect.	Without effect.	Without effect.	The field has no effect.
gross	gross	Setup-dependent	Field Amount Database field Amount	Without effect.	Without effect.	Indicates the gross amount of the invoice. The field is a mandatory field if the Documenttype cost acc. field has the value Posting Journal on the edoc invoice cockpit Setup page.
payment_terms_id	payment_terms_id	No	Without effect.	Without effect.	Without effect.	The field has no effect.
payment_terms_text	payment_terms_text	No	Without effect.	Without effect.	Without effect.	The field has no effect.
payment_discount_days	payment_discount_days	No	Without effect.	Without effect.	Without effect.	The field has no effect.
payment_discount_month	payment_discount_month	No	Without effect.	Without effect.	Without effect.	The field has no effect.
payment_discount_percent	payment_discount_percent	No	Without effect.	Without effect.	Without effect.	The field has no effect.
payment_net_days	payment_net_days	No	Without effect.	Without effect.	Without effect.	The field has no effect.
payment_net_month	payment_net_month	No	Without effect.	Without effect.	Without effect.	The field has no effect.
payment_due_date	payment_due_date	No	Without effect.	Without effect.	Without effect.	The field has no effect.
payment_discount_date	payment_discount_date	No	Without effect.	Without effect.	Without effect.	The field has no effect.
payment_discount_amount	payment_discount_amount	No	Without effect.	Without effect.	Without effect.	The field has no effect.
payment_discount_use	payment_discount_use	No	Without effect.	Without effect.	Without effect.	The field has no effect.
payment_net_date	payment_net_date	No	Without effect.	Without effect.	Without effect.	The field has no effect.
gen_bus_posting_group	gen_bus_posting_group	No	Without effect.	Without effect.	Without effect.	If the field is filled, the general business posting group is specified for all lines whose gen_bus_posting_group field is empty. The field has an effect on the VAT Bus. Posting Group field and therefore also on VAT determination for lines. Can be used to override the default VAT calculation.
vat_bus_posting_group	vat_bus_posting_group	No	Without effect.	Without effect.	Without effect.	If the field is filled, the VAT general business posting group is specified for all lines whose vat_bus_posting_group field is empty. Can be used to override the default VAT calculation.
map_field_dec..map_field_dec5	map_field_dec..map_field_dec5	No	Without effect.	Without effect.	Without effect.	You can use this data type field for your own purposes.
map_field_text..map_field_text5	map_field_text..map_field_text5	No	Without effect.	Without effect.	Without effect.	You can use this data type field for your own purposes.
map_field_date..map_field_date3	map_field_date..map_field_date3	No	Without effect.	Without effect.	Without effect.	You can use this data type field for your own purposes.
posted_date	posted_date	No	Without effect.	Without effect.	Without effect.	The field has no effect.
posted_clerk	posted_clerk	No	Without effect.	Without effect.	Without effect.	The field has no effect.
posted_group	posted_group	No	Without effect.	Without effect.	Without effect.	The field has no effect.

"Edoc Inv. Cp. Transfer Pos." table and field mappings (overview)

All fields marked with No are available for further scenarios.

All fields marked with Setup-dependent are only mandatory fields in certain constellations if you have defined the field as mandatory in Business Central.

All fields marked as process-dependent are only mandatory in certain constellations.

edoc invoice field	Dynamics 365 BC field	Mandatory field	Field for invoice without order reference in table 81 "Gen. Journal Line"	Field for invoice without order reference in table 39 "Purchase line"	Field for invoice with order reference in table 39 "Purchase line"	Description
id	id	Yes	Without effect.	Without effect.	Without effect.	The field has no effect.
event_id	event_id	Yes	Without effect.	Without effect.	Without effect.	The field has no effect.
ecm_id	ecm_id	Yes	Field edoc invoice cockpit ECM ID Database field Edoc Invoice Cockpit ECM ID	Field edoc invoice cockpit ECM ID Database field Edoc Invoice Cockpit ECM ID	Field edoc invoice cockpit ECM ID Database field Edoc Invoice Cockpit ECM ID	Is the document ID from the ECM system. The edoc invoice cockpit ECM ID field is transferred to the table for posted documents and partially for entries.
row_index	row_index	No	Without effect.	Without effect.	Without effect.	The field has no effect.
account	account	No	Field Account No. Database field Account No.	Field No. Database field No.	Field No. Database field No. (Only specified if you have so-called mixed invoices, i.e. if you add further lines without order reference to an invoice with order reference)	Specifies the G/L account in Dynamics 365 Business Central.
cost_center	cost_center	Setup-dependent	If Dimension 1 code is filled on the edoc invoice cockpit Setup page, a record is created in table 480 Dimension Set Entry and filled with the following two fields: Field Dimension code (Dimension Code database field) is filled with the value from the Dimension 1 code field on the edoc invoice cockpit Setup page. Field Dimension Value Code (database field Dimension Value Code) is filled with the field cost_center.	If Dimension 1 code is filled on the edoc invoice cockpit Setup page, a record is created in table 480 Dimension Set Entry and filled with the following two fields: Field Dimension code (Dimension Code database field) is filled with the value from the Dimension 1 code field on the edoc invoice cockpit Setup page. Field Dimension Value Code (database field Dimension Value Code) is filled with the field cost_center.	If Dimension 1 code is filled on the edoc invoice cockpit Setup page, a record is created in table 480 Dimension Set Entry and filled with the following two fields: Field Dimension code (Dimension Code database field) is filled with the value from the Dimension 1 code field on the edoc invoice cockpit Setup page. Field Dimension Value Code (database field Dimension Value Code) is filled with the field cost_center.	Indicates the dimension value that was specified in the dimension in the Dimension 1 code field on the edoc invoice cockpit Setup page. The dimension with the value is specified with the respective invoice.
cost_object	cost_object	Setup-dependent	If Dimension 2 code is filled on the edoc invoice cockpit Setup page, a record is created in table 480 Dimension Set Entry and filled with the following two fields: Field Dimension code (Dimension Code database field) is filled with the value from the Dimension 2 code field on the edoc invoice cockpit Setup page. Field Dimension Value Code (database field Dimension Value Code) is filled with the field cost_object.	If Dimension 2 code is filled on the edoc invoice cockpit Setup page, a record is created in table 480 Dimension Set Entry and filled with the following two fields: Field Dimension code (Dimension Code database field) is filled with the value from the Dimension 2 code field on the edoc invoice cockpit Setup page. Field Dimension Value Code (database field Dimension Value Code) is filled with the field cost_object.	If Dimension 2 code is filled on the edoc invoice cockpit Setup page, a record is created in table 480 Dimension Set Entry and filled with the following two fields: Field Dimension code (Dimension Code database field) is filled with the value from the Dimension 2 code field on the edoc invoice cockpit Setup page. Field Dimension Value Code (database field Dimension Value Code) is filled with the field cost_object.	Indicates the dimension value that was specified in the dimension in the Dimension 2 code field on the edoc invoice cockpit Setup page. The dimension with the value is specified with the respective invoice.
dim_3_value_code..dim_8_value_code	dim_3_value_code..dim_8_value_code	Setup-dependent	If Dimension 3..8 code is filled on the edoc invoice cockpit Setup page, a record is created in table 480 Dimension Set Entry and filled with the following two fields: Field Dimension code (Dimension Code database field) is filled with the value from the Dimension 3..8 code field on the edoc invoice cockpit Setup page. Field Dimension Value Code (database field Dimension Value Code) is filled with the field dim_3_value_code..dim_8_value_code.	If Dimension 3..8 code is filled on the edoc invoice cockpit Setup page, a record is created in table 480 Dimension Set Entry and filled with the following two fields: Field Dimension Code (database field Dimension Code) is filled with the value from the Dimension 3..8 code field on the edoc invoice cockpit Setup page. Field Dimension Value Code (database field Dimension Value Code) is filled with the field dim_3_value_code..dim_8_value_code.	If Dimension 2 code is filled on the edoc invoice cockpit Setup page, a record is created in table 480 Dimension Set Entry and filled with the following two fields: Field Dimension Code (database field Dimension Code) is filled with the value from the Dimension 3..8 code field on the edoc invoice cockpit Setup page. Field Dimension Value Code (database field Dimension Value Code) is filled with the field dim_3_value_code..dim_8_value_code.	Indicates the dimension value that was specified in the dimension in the Dimension 3..8 code field on the edoc invoice cockpit Setup page. The dimension with the value is specified with the respective invoice.
posting_key	posting_key	No	Without effect.	Without effect.	Without effect.	The field has no effect.
net_amount	AmountNet	Setup-dependent	Without effect.	Field Line Amount Excluding VAT Database field Line Amount	Field Line Amount Excluding VAT Database field Line Amount	Indicates the net amount of the invoice line. The field is a mandatory field for an invoice with order reference or if the Documenttype cost acc. field has the value Purchase invoice on the edoc invoice cockpit Setup page.
vat_amount	vat_amount	No	Without effect.	Without effect.	Without effect.	The field has no effect.
vat_percent	vat_percent	No	Without effect.	Without effect.	Without effect.	The field has no effect.
vat_code	vat_code	No	Without effect.	Without effect.	Without effect.	The field has no effect.
gross_amount	gross_amount	Setup-dependent	Field Amount Database field Amount	Without effect.	Without effect.	The field is a mandatory field if the Documenttype cost acc. field has the value Posting Journal on the edoc invoice cockpit Setup page. Indicates the gross amount of the invoice line.
order_number	order_number	Process-dependent	Without effect.	Without effect.	No existing field, is required when determining associated receipt lines.	The field is a mandatory field for invoice lines with order reference. Specifies the order number of the invoice with order reference.
order_position	order_position	Process-dependent	Without effect.	Without effect.	No existing field, is required when determining associated receipt lines.	The field is a mandatory field for invoice lines with order reference. Specifies the order item number of the invoice with order reference.
delivery_note	delivery_note	Process-dependent	Without effect.	Without effect.	No existing field, is required when determining associated receipt lines.	The field is a mandatory field for invoice lines with order reference. Specifies the posted purchase receipt number of the invoice with order reference.
quantity	quantity	Setup-dependent	Without effect.	Field Quantity Database field Quantity	Field Quantity Database field Quantity	Indicates the delivered quantity of the line. The field is a mandatory field for an invoice with order reference or if the Documenttype cost acc. field has the value Purchase invoice on the edoc invoice cockpit Setup page.
unit_price	unit_price	Setup-dependent	Without effect.	Field Direct Unit Cost excl. VAT Database field Direct Unit Cost	Field Direct Unit Cost excl. VAT Database field Direct Unit Cost	Indicates the net amount of the invoice line. The field is a mandatory field for an invoice with order reference or if the Documenttype cost acc. field has the value Purchase invoice on the edoc invoice cockpit Setup page.
price_units	price_units	No	Without effect.	Without effect.	Without effect.	The field has no effect.
item_number	item_number	No	Without effect.	Without effect.	Without effect.	The field has no effect.
item_description	item_description	No	Without effect.	Without effect.	Without effect.	The field has no effect.
posting_text	PostingText	Setup-dependent	Field Description Database field Description	Field Description Database field Description	Field Description Database field Description	Only used if the field Overwrite description with posting text has been activated on the edoc invoice cockpit Setup page (Yes) and the field Treat commercial invoice as cost invoice has been deactivated (No). Specifies a description as posting text.
fixed_assetid	FixedAssetId	No	Field Account No. Database field Account No.	Field No. Database field No.	Field No. Database field No. (Only specified if you have so-called mixed invoices, i.e. if you add further lines without order reference to an invoice with order reference)	Specifies the fixed asset number.
resource	resource	No	Without effect.	Field No. Database field No.	Field No. Database field No. (Only specified if you have so-called mixed invoices, i.e. if you add further lines without order reference to an invoice with order reference)	Specifies the resource number.
charge_item	charge_item	No	Without effect.	Field No. Database field No.	Field No. Database field No. (Only specified if you have so-called mixed invoices, i.e. if you add further lines without order reference to an invoice with order reference)	Specifies the charge (item) number for item lines on the invoice.
item_charge_distribution_type	item_charge_distribution_type	No	Without effect.	Without effect.	Only used if the field Distribute charge (item) manually has been deactivated (No) on the edoc invoice cockpit Setup page.	Specifies how the charge (item) for item lines are to be distributed to the individual item lines.
gen_jnl_line_fa_posting_type	gen_jnl_line_fa_posting_type	No	Field FA Posting Type Database field FA Posting Type	Without effect.	Without effect.	This field is only used for fixed asset items. The field indicates the fixed asset posting type.
gen_bus_posting_group	gen_bus_posting_group	No	Field Gen. Bus. Posting Group Database field Gen. Bus. Posting Group	Field Gen. Bus. Posting Group Database field Gen. Bus. Posting Group	Field Gen. Bus. Posting Group Database field Gen. Bus. Posting Group (Only specified if you have so-called mixed invoices, i.e. if you add further lines without order reference to an invoice with order reference)	Specifies the business posting group of the line. The field has an effect on the VAT Bus. Posting Group field and therefore also on VAT determination for the line. Can be used to override the default VAT calculation.
gen_prod_posting_group	gen_prod_posting_group	No	Field Gen. Prod. Posting Group Database field Gen. Prod. Posting Group	Field Gen. Prod. Posting Group Database field Gen. Prod. Posting Group	Field Gen. Prod. Posting Group Database field Gen. Prod. Posting Group (Only specified if you have so-called mixed invoices, i.e. if you add further lines without order reference to an invoice with order reference)	Specifies the product postiung group of the line. The field has an effect on the VAT Prod. Posting Group field and therefore also on the VAT calculation for the line. Can be used to override the default VAT calculation.
vat_bus_posting_group	vat_bus_posting_group	No	Field VAT Bus. Posting Group Database field VAT Bus. Posting Group	Field VAT Bus. Posting Group Database field VAT Bus. Posting Group	Field VAT Bus. Posting Group Database field VAT Bus. Posting Group (Only specified if you have so-called mixed invoices, i.e. if you add further lines without order reference to an invoice with order reference)	Indicates the VAT business posting group of the line. Can be used to override the default VAT calculation.
vat_prod_posting_group	vat_prod_posting_group	No	Field VAT Prod. Posting Group Database field VAT Prod. Posting Group	Field VAT Prod. Posting Group Database field VAT Prod. Posting Group	Field VAT Prod. Posting Group Database field VAT Prod. Posting Group (Only specified if you have so-called mixed invoices, i.e. if you add further lines without order reference to an invoice with order reference)	Indicates the VAT product posting group of the line. Can be used to override the default VAT calculation.
map_field_dec..map_field_dec5	map_field_dec..map_field_dec5	No	Without effect.	Without effect.	Without effect.	You can use this data type field for your own purposes.
map_field_text..map_field_text5	map_field_text..map_field_text5	No	Without effect.	Without effect.	Without effect.	You can use this data type field for your own purposes.