Anveo Knowledge Base

Config / Data/Buffer Tables / ANVEDI Document
Anveo EDI Connect 5.3
Microsoft Dynamics 365 Business Central

ANVEDI Document

This table is intended to hold data that is structured as header and line data. Typical example are sales orders, warehouse documents and others. This table is structured like the sales header in Microsoft Dynamics 365 Business Central. With a few exceptions, fields in this table does not have a table relation or validation logic. The main idea is to be able to import data, even if there is no corresponding master data. The few fields with validation logic are build in a way, that they do not throw errors.

The table name has changed in version 5.00 of the module. The table was previously named EDI Document.

Field Use

The fields can be used in any way that suits your process needs. We highly recommend to check the field data type and length. Please document, if you’re using a field where the name does not correspond to the data. It is also possible to extend the table or to use custom buffer tables, in case the table does not match your requirements.

There is a secondary table called EDI Additional Information, which can be used to store any additional data in a structured way.

Fields

Please be aware that not all fields are available in the page. If the information is important, please make sure that the field is available and visible to the end-user.

Document Type

This field is part of the primary key of this table. This fields represents the document type of the document. The option values are not identical to the sales header / purchase header and cannot be transferred directly.

Quote

A sales or purchase quote. (The integer value in the database is 0)

Order

A sales or purchase order. (The integer value in the database is 1)

Invoice

A sales or purchase invoice. (The integer value in the database is 2)

Credit Memo

A sales or purchase credit memo. (The integer value in the database is 3)

Blanket Order

A sales or purchase blanket order. (The integer value in the database is 4)

Return Order

A sales or purchase return order. (The integer value in the database is 5)

Shipment

A sales or purchase shipment. (The integer value in the database is 8)

Receipt

A sales or purchase receipt. (The integer value in the database is 9)

Order Response

A sales or purchase order response. (The integer value in the database is 14)

Order Change

A sales or purchase order change. (The integer value in the database is 15)

Instructions to Despatch

A sales or purchase instruction to despatch. (The integer value in the database is 18)

Invoice List

A sales or purchase invoice list. (The integer value in the database is 23)

JIT Delivery

A sales or purchase just-in-time delivery. (The integer value in the database is 27)

Consignment

A consignment. (The integer value in the database is 28)

Package

A package. (The integer value in the database is 29)

Packaging (Position)

A packaging position. (The integer value in the database is 30)

Inventory Report

An inventory report. (The integer value in the database is 34)

Sales Report

A sales report. (The integer value in the database is 35)

Catalog

Catalog data. (The integer value in the database is 38)

Remittance Advice

A remittance advice. (The integer value in the database is 39)

Technical Acknowledgment

A technical acknowledgement. (The integer value in the database is 40)

No.

This field is part of the primary key of this table. The number is assigned automatically, if it is empty. If you import more than one record, you should reset the number explicitly to get a new number. You can configure the way the number is assigned in the EDI Setup.

Version No.

This field is part of the primary key of this table. The version number allows you to have multiple versions of the same document. This is used in combination with the Status field. You can release a document and make it thereby read-only. If the user wants to change a value he has to reset the status, which will create a new version.

Direction

The direction is for information only. We recommend setting this field from the mapping.

Outgoing

The data is outgoing from Microsoft Dynamics 365 Business Central to an external partner. (The integer value of this option in the database is 0)

Incoming

The data is sent by an external partner to Microsoft Dynamics 365 Business Central. (The integer value of this option in the database is 1)

Status

Represents the status of the document. This field is not set automatically. To see the status of the EDI workflow, we recommend using business transactions instead.

Open

The document is open and can be modified. (The integer value of this option in the database is 0)

Released

The document is released and read-only. (The integer value of this option in the database is 1)

Processed

The document is processed and the status cannot be changed anymore. New versions cannot be created from a processed document.
(The integer value of this option in the database is 2)

Ignored

The status is ignored. The document is read-only.
(The integer value of this option in the database is 3)

Old Version

There is a new version of the document available. The document is read-only.
(The integer value of this option in the database is 6)

External Document Type

This field accepts any value. On incoming documents, it can be used in combination with the field External Document Type Trans. to set the Document Type from an external value automatically.

External Document Type Trans.

Specifies a value translation that translates the External Document Type field to the
Document Type.

System Document Source

This field can be used together with the next fields to specify the source for an outgoing EDI Document. This field has to be set from the mapping manually.

There is no special source table.
(The integer value of this option in the database is 0)

Sales

The EDI Document is created from a sales header.
(The integer value of this option in the database is 1)

Purchase

The EDI Document is created from a purchase header.
(The integer value of this option in the database is 2)

Sales Archive

The EDI Document is created from a sales archive header.
(The integer value of this option in the database is 3)

Purchase Archive

The EDI Document is created from a purchase archive header.
(The integer value of this option in the database is 4)

Sales Shipment

The EDI Document is created from a sales shipment header.
(The integer value of this option in the database is 10)

Sales Invoice

The EDI Document is created from a sales invoice header.
(The integer value of this option in the database is 11)

Sales Cr.Memo

The EDI Document is created from a sales credit memo header.
(The integer value of this option in the database is 12)

Sales Return

The EDI Document is created from a sales return header.
(The integer value of this option in the database is 13)

Purchase Receipt

The EDI Document is created from a purchase receipt.
(The integer value of this option in the database is 18)

Purchase Invoice

The EDI Document is created from a purchase invoice header.
(The integer value of this option in the database is 19)

Purchase Cr. Memo

The EDI Document is created from a purchase credit memo header.
(The integer value of this option in the database is 20)

Return Shipment

The EDI Document is created from a return shipment header.
(The integer value of this option in the database is 21)

Warehouse Receipt Header

The EDI Document is created from a warehouse receipt header.
(The integer value of this option in the database is 26)

Warehouse Shipment Header

The EDI Document is created from a warehouse shipment header.
(The integer value of this option in the database is 27)

Warehouse Activity Header

The EDI Document is created from a warehouse activity header.
(The integer value of this option in the database is 28)

System Document Type

Can be used to store the system document type, if applicable.

System Document No.

Can be used to store the source system document number. This field has a lookup defined to the system tables specified above.

Document Date

This field can be used in any way. This is a Date field. This field is used for the automatic “in days” fields of this table and need to be filles, before setting other date fields. The module will not automatically calculate those values, but also don’t throw errors, if this field is empty.

Shipment Date

This field can be used in any way. This is a Date field.

Order No.

This field can be used in any way. This is a Code field of length 20.

Order Date

This field can be used in any way. This is a Date field.

Posting Date

This field can be used in any way. This is a Date field.

Pmt. Discount Date

This field can be used in any way. This is a Date field. If the Document Date is set, the field Pmt. Discount Date (in Days) is calculated automatically from this field.

Pmt. Discount Date (in Days)

This field can be used in any way. This is a Integer field.
If the Document Date is set, the field Pmt. Discount Date is calculated automatically from this field.

Location Code

This field can be used in any way. This is a Code field of length 10.

External Document No.

This field can be used in any way. This is a Text field of length 30.

External Order No.

This field can be used in any way. This is a Text field of length 30.

Currency Code

This field can be used in any way. This is a Code field of length 10.

Standard VAT %

This field can be used in any way. This is a Integer field.

Language Code

This field can be used in any way. This is a Code field of length 10.

Salesperson Code

This field can be used in any way. This is a Code field of length 10.

Shipping No.

This field can be used in any way. This is a Code field of length 20.

Posting No.

This field can be used in any way. This is a Code field of length 20.

VAT Registration No.

This field can be used in any way. This is a Text field of length 20.

Reason Code

This field can be used in any way. This is a Code field of length 10.

EU 3-Party Trade

This field can be used in any way. This is a Boolean field.

Transaction Type

This field can be used in any way. This is a Code field of length 10.

Transport Method

This field can be used in any way. This is a Code field of length 10.

Exit Point

This field can be used in any way. This is a Code field of length 10.

Correction

This field can be used in any way. This is a Boolean field.

Area

This field can be used in any way. This is a Code field of length 10.

Transaction Specification

This field can be used in any way. This is a Code field of length 10.

Payment Method Code

This field can be used in any way. This is a Code field of length 10.

Shipping Agent Code

This field can be used in any way. This is a Code field of length 10.

Serial Shipping Container Code (SSCC)

This field can be used in any way. This is a Text field of length 30.

Carrier

This field can be used in any way. This is a Text field of length 64.

Carrier Delivery Date/Time

This field can be used in any way. This is a DateTime field.

Way Of Transport

This field can be used in any way. This is a Text field of length 20.

VAT Base Discount %

This field can be used in any way. This is a Decimal field.

Invoice Discount Calculation

This field can be used in any way. This is a Option field.

None

(The integer value of this option in the database is 0)

%

(The integer value of this option in the database is 1)

Amount

(The integer value of this option in the database is 2)

Invoice Discount Value

This field can be used in any way. This is a Decimal field.

Prepayment %

This field can be used in any way. This is a Decimal field.

Prepayment Due Date

This field can be used in any way. This is a Date field.

Prepmt. Pmt. Discount Date

This field can be used in any way. This is a Date field.

Prepmt. Payment Discount %

This field can be used in any way. This is a Decimal field.

Quote No.

This field can be used in any way. This is a Code field of length 20.

Transmission Number

This field can be used in any way. This is a Code field of length 20.

Previous Transmission Number

This field can be used in any way. This is a Code field of length 20.

Means of Transport

This field can be used in any way. This is a Text field of length 20.

Means of Transport No.

This field can be used in any way. This is a Text field of length 20.

Gross Weight

This field can be used in any way. This is a Decimal field.

Net Weight

This field can be used in any way. This is a Decimal field.

Document Reference Start

This field can be used in any way. This is a Code field of length 20.

Document Reference End

This field can be used in any way. This is a Code field of length 20.

Length

This field can be used in any way. This is a Decimal field.

Width

This field can be used in any way. This is a Decimal field.

Height

This field can be used in any way. This is a Decimal field.

Packaging Type

This field can be used in any way. This is a Text field of length 20.

Packaging Code

This field can be used in any way. This is a Text field of length 20.

Packaging Owner Code

This field can be used in any way. This is a Text field of length 20.

Credit Card No.

This field can be used in any way. This is a Code field of length 20.

Invoice No.

This field can be used in any way. This is a Code field of length 20.

Credit Memo No.

This field can be used in any way. This is a Code field of length 20.

Responsibility Center

This field can be used in any way. This is a Code field of length 10.

Shipping Advice

This field can be used in any way. This is a Option field.

Partial

(The integer value of this option in the database is 0)

Complete

(The integer value of this option in the database is 1)

Requested Delivery Date

This field can be used in any way. This is a Date field.

Promised Delivery Date

This field can be used in any way. This is a Date field.

Shipping Agent Service Code

This field can be used in any way. This is a Code field of length 10.

Promised Delivery Time

This field can be used in any way. This is a Time field.

Return Receipt No.

This field can be used in any way. This is a Code field of length 20.

Last Return Receipt No.

This field can be used in any way. This is a Code field of length 20.

Your Reference

This field can be used in any way. This is a Text field of length 30.

Delivery Terms Code

This field can be used in any way. This is a Code field of length 10.

Payment Terms Code

This field can be used in any way. This is a Code field of length 10.

Due Date

This field can be used in any way. This is a Date field.
If the Document Date is set, the field Due Date (in Days) is calculated automatically from this field.

Payment Discount %

This field can be used in any way. This is a Decimal field.

Shipment Method Code

This field can be used in any way. This is a Code field of length 10.

Due Date (in Days)

This field can be used in any way. This is a Integer field.
If the Document Date is set, the field Due Date is calculated automatically from this field.

Location Identification Type

A cross-reference type to link the Location Identification and Location Code.

Location Identification

This field can be used in any way. This is a Text field of length 64. An external number to get the location code.

Tracking No.

This field can be used in any way. This is a Text field of length 64.

Return Tracking No.

This field can be used in any way. This is a Text field of length 64.

Sender

This field can be used in any way. This is a Text field of length 64.
Warning there is a similar field Sender No..

Receiver

This field can be used in any way. This is a Text field of length 64.

Profile

This field can be used in any way. This is a Code field of length 20. While this field has no logic, it is intended to store a code which you can use in exports or imports to customize the behaviour. For example, to implement different versions of the interface.

Grouping Code

This field is not filled automatically. It is not used internally.

Test Flag

This field is not filled automatically. It is not used internally.

EDI Message Count

Deprecated. This is a FlowField. Read-only.

Creation Date/Time

The creation date/time. Is automatically set from the insert trigger.

Deprecated Fields

The following fields are removed in version 5.00 of the module and are not available anymore. If you want to update an existing system and you’re using the FOB-Version of the module, you can keep the old buffer tables. If you’re using the Extension you might want to add some of the fields back using a custom extension.

In new projects we recommend to use the EDI Address/Contact and EDI Additional Information to store the information.

Prices Including VAT

This field can be used in any way. This is a Boolean field.

Invoice

This field can be used in any way. This is a Boolean field.

Combine Shipments

This field can be used in any way. This is a Boolean field.

Gen. Bus. Posting Group

This field can be used in any way. This is a Code field of length 10.

VAT Country/Region Code

This field can be used in any way. This is a Code field of length 10.

Sell-to Customer Name

This field can be used in any way. This is a Text field of length 50. This field will be overridden, if there is an EDI Contact of type Sell-to Customer.

Sell-to Customer Name 2

This field can be used in any way. This is a Text field of length 50. This field will be overridden, if there is an EDI Contact of type Sell-to Customer.

Sell-to Address

This field can be used in any way. This is a Text field of length 50. This field will be overridden, if there is an EDI Contact of type Sell-to Customer.

Sell-to Address 2

This field can be used in any way. This is a Text field of length 50. This field will be overridden, if there is an EDI Contact of type Sell-to Customer.

Sell-to City

This field can be used in any way. This is a Text field of length 30. This field will be overridden, if there is an EDI Contact of type Sell-to Customer.

Sell-to Contact

This field can be used in any way. This is a Text field of length 50. This field will be overridden, if there is an EDI Contact of type Sell-to Customer.

Bill-to Post Code

This field can be used in any way. This is a Code field of length 20. This field will be overridden, if there is an EDI Contact of type Bill-to Customer.

Bill-to County

This field can be used in any way. This is a Text field of length 30. This field will be overridden, if there is an EDI Contact of type Bill-to Customer.

Bill-to Country/Region Code

This field can be used in any way. This is a Code field of length 10. This field will be overridden, if there is an EDI Contact of type Bill-to Customer.

Sell-to Post Code

This field can be used in any way. This is a Code field of length 20. This field will be overridden, if there is an EDI Contact of type Sell-to Customer.

Sell-to County

This field can be used in any way. This is a Text field of length 30. This field will be overridden, if there is an EDI Contact of type Sell-to Customer.

Sell-to Country/Region Code

This field can be used in any way. This is a Code field of length 10. This field will be overridden, if there is an EDI Contact of type Sell-to Customer.

Ship-to Post Code

This field can be used in any way. This is a Code field of length 20. This field will be overridden, if there is an EDI Contact of type Ship-to Address.

Ship-to County

This field can be used in any way. This is a Text field of length 30. This field will be overridden, if there is an EDI Contact of type Ship-to Address.

Ship-to Country/Region Code

This field can be used in any way. This is a Code field of length 10. This field will be overridden, if there is an EDI Contact of type Ship-to Address.

Consumption Point

This field can be used in any way. This is a Text field of length 20.

Tax Area Code

This field can be used in any way. This is a Code field of length 20.

Tax Liable

This field can be used in any way. This is a Boolean field.

VAT Bus. Posting Group

This field can be used in any way. This is a Code field of length 10.

Prepayment No. Series

This field can be used in any way. This is a Code field of length 10.

Compress Prepayment

This field can be used in any way. This is a Boolean field.

Prepmt. Cr. Memo No. Series

This field can be used in any way. This is a Code field of length 10.

Prepmt. Posting Description

This field can be used in any way. This is a Text field of length 50.

Prepmt. Payment Terms Code

This field can be used in any way. This is a Code field of length 10.

Transmissionnumber No. Series

This field can be used in any way. This is a Code field of length 10.

Transport Partner No. Customer

This field can be used in any way. This is a Code field of length 10.

Unloading Point

This field can be used in any way. This is a Text field of length 20.

Sender No.

This field can be used in any way. This is a Text field of length 64. Warning, there is a similar field called Sender.

Authorization Required

This field can be used in any way. This is a Boolean field.

Campaign No.

This field can be used in any way. This is a Code field of length 20.

Sell-to Customer Template Code

This field can be used in any way. This is a Code field of length 10. This field will be overridden, if there is an EDI Contact of type Sell-to Customer.

Sell-to Contact No.

This field can be used in any way. This is a Code field of length 20. This field will be overridden, if there is an EDI Contact of type Sell-to Customer.

Bill-to Contact No.

This field can be used in any way. This is a Code field of length 20. This field will be overridden, if there is an EDI Contact of type Bill-to Customer.

Bill-to Customer Template Code

This field can be used in any way. This is a Code field of length 10. This field will be overridden, if there is an EDI Contact of type Bill-to Customer.

Opportunity No.

This field can be used in any way. This is a Code field of length 20.

Shipping Time

This field can be used in any way. This is a DateFormula field.

Outbound Whse. Handling Time

This field can be used in any way. This is a DateFormula field.

Receive

This field can be used in any way. This is a Boolean field.

Return Receipt No. Series

This field can be used in any way. This is a Code field of length 10.

Sell-to Identification Type

A cross-reference type to link the Sell-to Identification and Sell-to Customer No..

Sell-to Identification

External identification of the sell-to contact.

Bill-to Identification Type

A cross-reference type to link the Bill-to Identification and Bill-to Customer No..

Bill-to Identification

This field can be used in any way. This is a Text field of length 64. The external identification of the bill-to customer.

Ship-to Identification Type

A cross-reference type to link the Ship-to Identification and Ship-to Code.

Ship-to Identification

This field can be used in any way. This is a Text field of length 64. An external number to identify the ship-to address.

Quality

This field can be used in any way. This is a Integer field.

Sell-to Customer No.

This field can be used in any way. This is a Code field of length 20. This field will be overridden, if there is an EDI Contact of type Sell-to Customer.

Bill-to Customer No.

This field can be used in any way. This is a Code field of length 20. This field will be overridden, if there is an EDI Contact of type Bill-to Customer.

Bill-to Name

This field can be used in any way. This is a Text field of length 50. This field will be overridden, if there is an EDI Contact of type Bill-to Customer.

Bill-to Name 2

This field can be used in any way. This is a Text field of length 50. This field will be overridden, if there is an EDI Contact of type Bill-to Customer.

Bill-to Address

This field can be used in any way. This is a Text field of length 50. This field will be overridden, if there is an EDI Contact of type Bill-to Customer.

Bill-to Address 2

This field can be used in any way. This is a Text field of length 50. This field will be overridden, if there is an EDI Contact of type Bill-to Customer.

Bill-to City

This field can be used in any way. This is a Text field of length 30. This field will be overridden, if there is an EDI Contact of type Bill-to Customer.

Bill-to Contact

This field can be used in any way. This is a Text field of length 50. This field will be overridden, if there is an EDI Contact of type Bill-to Customer.

Ship-to Code

This field can be used in any way. This is a Code field of length 10. This field will be overridden, if there is an EDI Contact of type Ship-to Address.

Ship-to Name

This field can be used in any way. This is a Text field of length 50. This field will be overridden, if there is an EDI Contact of type Ship-to Address.

Ship-to Name 2

This field can be used in any way. This is a Text field of length 50. This field will be overridden, if there is an EDI Contact of type Ship-to Address.

Ship-to Address

This field can be used in any way. This is a Text field of length 50. This field will be overridden, if there is an EDI Contact of type Ship-to Address.

Ship-to Address 2

This field can be used in any way. This is a Text field of length 50. This field will be overridden, if there is an EDI Contact of type Ship-to Address.

Ship-to City

This field can be used in any way. This is a Text field of length 30. This field will be overridden, if there is an EDI Contact of type Ship-to Address.

Ship-to Contact

This field can be used in any way. This is a Text field of length 50. This field will be overridden, if there is an EDI Contact of type Ship-to Address.

Ship-to Site

This field can be used in any way. This is a Text field of length 50.

Affiliate Identification Type

Deprecated. Does not provide any cross-reference logic.

Affiliate Identification

This field can be used in any way. This is a Text field of length 64. External number to identify the affiliate.

Ultimate Customer Contact

This field can be used in any way. This is a Code field of length 20.

Confirmation

This field can be used in any way. This is a Option field.

(The integer value of this option in the database is 0)

None

(The integer value of this option in the database is 1)

Expected

(The integer value of this option in the database is 2)

Confirmed

(The integer value of this option in the database is 3)

Declined

(The integer value of this option in the database is 4)

Format Code

This field is not filled automatically. It is not used internally.

Mapping Code

This field is not filled automatically. It is not used internally.

Export Date/Time

This field is not filled automatically. It is not used internally.

Contained in Message No.

This field is not filled automatically. It is not used internally.