Which transactional data is exported with the schema?

The edoc invoice schema is used to provide the fields of the transactional data for an export in order to assign the fields to another application.

Select the schema for a company under Settings > Data > Export - Transactional data. For further details see: Export transactional data to a destination system

Various versions of the schema are available to you, as the schema is versioned when changes are made.

In the following overview you will find the elements (parameters) of the schema, the purpose and the versions in which the element is contained.

Field name	Description	Included in schematic version
event_id	Specifies the unique ID for the executed event. Examples: Verify Approve Complete workflow	Version 1–5
ecm_id	Specifies the document ID of the invoice in the ECM system.	Version 1–5
company_id	Specifies the company ID of a company as a character string. Example: edoc	Version 1–5
barcode	Specifies a specific barcode that is usually used for scanning and identifying items.	Version 1–5
vendor_id	Specifies the unique ID of the vendor.	Version 1–5
vendor_name	Specifies the full name of the vendor.	Version 1–5
vendor_vat_id	Specifies the VAT identification number of the vendor.	Version 1–5
vendor_tax_id	Specifies the tax identification number of the vendor.	Version 1–5
vendor_account	Specifies the account number of the vendor.	Version 1–5
vendor_address_street	Specifies the street and house number in the vendor's address.	Version 1–5
vendor_address_city	Specifies the city in the vendor's address.	Version 1–5
vendor_address_zip	Specifies the zip code in the vendor's address.	Version 1–5
vendor_address_country	Specifies the country/region in the vendor's address.	Version 1–5
vendor_bank_iban	Specifies the IBAN of the vendor's account.	Version 1–5
vendor_bank_bic	Specifies the BIC (Bank Identifier Code) of the vendor's account.	Version 1–5
vendor_bank_account	Specifies the account number of the vendor.	Version 1–5
vendor_bank_code	Indicates the specific bank code of the vendor.	Version 1–5
vendor_bank_name	Specifies the name of the vendor's bank.	Version 1–5
invoice_type_id	Specifies the type of invoice as an integer. Example: Invoice: 1 Credit memo: 2	Version 1–5
invoice_type_text	Specifies the name of the invoice type. Examples: Invoice Credit memo	Version 1–5
confidential	Indicates whether the information must be treated confidentially.	Version 1–5
workflow_type	Specifies the type of workflow to which the event belongs. Example: Invoice with purchase order reference (invoice for goods) Invoice without purchase order reference	Version 1–5
order_numbers	Specifies a list of purchase order numbers associated with the event.	Version 1–5
delivery_notes	Specifies a list of packing slips associated with the event.	Version 1–5
external_number	Specifies an external invoice number for the event.	Version 1–5
internal_number	Specifies an internal invoice number for the event.	Version 1–5
invoice_date	Specifies the date on which the invoice was issued.	Version 1–5
valuta_date	Specifies the value date of the invoice.	Version 1–5
performance_date	Specifies the service date associated with the invoice.	Version 1–5
posting_date	Specifies the posting date of the invoice in the ERP system.	Version 1–5
currency	Specifies the currency in which the invoice amounts were entered.	Version 1–5
exchange_rate	Specifies the conversion rate for the currency in which the invoice is paid at a point in time.	Version 1–5
net_amount_1..net_amount _4	Specifies the net amount of the invoice.	Version 1–5
vat_amount_1..vat_amount_4	Specifies the VAT amount of the invoice.	Version 1–5
vat_percent_1..vat_percent_4	Specifies the VAT rate of the invoice as a percentage.	Version 1–5
net_total	Specifies the invoice total as the net amount of all invoice items.	Version 1–5
vat_total	Specifies the total VAT amount of all invoice items.	Version 1–5
gross	Specifies the gross amount of the invoice.	Version 1–5
payment_terms_id	Specifies the ID of the payment terms.	Version 1–5
payment_terms_text	Specifies the description of the payment term.	Version 1–5
payment_discount_days	Specifies the number of days until the cash discount is due.	Version 1–5
payment_discount_month	Specifies the number of months until the cash discount is due.	Version 1–5
payment_discount_percent	Specifies the percentage for the cash discount deduction.	Version 1–5
payment_net_days	Specifies the number of days until net payment.	Version 1–5
payment_net_month	Specifies the number of months until net payment.	Version 1–5
payment_discount_use	Specifies the ID whether a cash discount is granted. Example: No: 0 Yes: 1	Version 1–5
payment_due_date	Specifies the due date of the payment.	Version 1–5
payment_discount_date	Specifies the date until which the discount is granted for the invoice amount.	Version 1–5
payment_discount_amount	Specifies the amount of the cash discount granted.	Version 1–5
payment_net_date	Specifies the date of the net payment.	Version 1–5
finance_id	Specifies the ID of the company in the ERP system.	Version 2–5
price_units	Specifies the unit as a decimal number for the price, e.g. for a single item, a dozen or per pallet.	Version 3–5
edoc_document_id	Specifies the document ID of the invoice in edoc documents.	Version 4–5
posted_date	Specifies the date on which the workflow was completed.	Version 5
posted_clerk	Specifies the name of the assigned person (Clerk) who completed the workflow.	Version 5
posted_group	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.	Version 5