Config / Data/Buffer Tables / ANVEDI Address/Contact

ANVEDI Address/Contact

The table EDI Contact can hold incoming or outgoing contact details. This can be all contact structured data, like customer information or addresses. The table data always belong to table EDI Document.

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

Cross-references and Value Translations

This table has a few fields, which can be used with the automatic value translations and cross-references. The External Identification can be used in combination with the External Identification Type to automatically fill the Internal No. on incoming documents. Or to fill the external information from the internal one on outgoing documents.

For the External Type, you can use value translations to get the internal one.

Fields

Document Type

Foreign key to the EDI Document this contact belongs to.

Document No.

Foreign key to the EDI Document this contact belongs to.

Document Version No.

Foreign key to the EDI Document this contact belongs to.

Document Line No.

Foreign key to the EDI Document Line this contact belongs to. This value should be zero, if the contact belongs to the document header-.

No.

Part of the primary key of this table. The number is automatically assigned, if the “No.” is empty. All contacts are numbered for each EDI Document individually.

Type

The type of the contact. This field has a special meaning, as some values will affect the parent EDI Document. This field also influences the lookup functionality of the Internal No. field.

Other

Any kind of contact information. (The integer value of this option in the database is 0)

Contact

Represents a Microsoft Dynamics NAV 2017 contact.
The field Internal No. has a table relation to a contact.
(The integer value of this option in the database is 1)

Customer

Represents a Microsoft Dynamics NAV 2017 customer.
The field Internal No. has a table relation to the customer table.
(The integer value of this option in the database is 2)

Sell-to Customer

This option value has a special meaning: The sell-to information in the EDI Document is overridden with this contact information. There should only be one contact of this type. Represents a Microsoft Dynamics NAV 2017 customer.
The field Internal No. has a table relation to the customer table.
(The integer value of this option in the database is 3)

Bill-to Customer

This option value has a special meaning: The bill-to information in the EDI Document is overridden with this contact information. There should only be one contact of this type.
Represents a Microsoft Dynamics NAV 2017 customer.
The field Internal No. has a table relation to the customer table.
(The integer value of this option in the database is 4)

Vendor

Represents a Microsoft Dynamics NAV 2017 vendor.
The field Internal No. has a table relation to the vendor table. (The integer value of this option in the database is 5)

Buy-From Vendor

The vendor information does not update the EDI document.
Represents a Microsoft Dynamics NAV 2017 vendor.
The field Internal No. has a table relation to the vendor table.
(The integer value of this option in the database is 6)

Pay-to Vendor

The vendor information does not update the EDI document.
Represents a Microsoft Dynamics NAV 2017 vendor.
The field Internal No. has a table relation to the vendor table.
(The integer value of this option in the database is 7)

Ship-to Address

This option value has a special meaning: The ship-to information in the EDI Document is overridden with this contact information. There should only be one contact of this type.

Represents a Microsoft Dynamics NAV 2017 ship-to address.
The field Internal No. has a table relation to the ship-to address table.
(The integer value of this option in the database is 8)

Supplier

Represents the supplier. This field has no special meaning or table relation.
(The integer value of this option in the database is 11)

External Type

Can be used to store an external representation of the type. For incoming documents there is a value translation available to automatically set the Type field.

External Type Translation

Value translation used for incoming documents to set the Type field from the External Type field information.

Internal No.

Used to store the Microsoft Dynamics NAV 2017 internal number. Depending of the value of the Type field, a lookup is available.

External Identification

This field can be used in any way. This is a Text field of length 64. Can be used to store the external identification of the contact.

External Identification Type

Cross-reference type to automatically find the Internal No. from the external one on imports, and vice versa on exports.

External Id.Agency

This field can be used in any way. This is a Text field of length 64. Can be used to store the type of the External Identification field information. Can be used in combination with the External Id.Agency Translation field, to automatically set the External Identification Type cross-reference.

External Id.Agency Translation

This field can be set to a value translation to to translate the External Id.Agency to an External Identification Type.

Name

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

Name 2

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

Address

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

Address 2

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

City

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

Contact

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

Post Code

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

County

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

Country/Region Code

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

Phone No.

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

Telex No.

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

Fax No.

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

VAT Registration No.

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

Registration No.

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

Our Account No.

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

GLN

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

Forename

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

Surname

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

Birthdate

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

E-Mail

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

Passport Type

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

Passport No.

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

Passport Authority

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

Sell-to Customer No.

Do not use. FlowField used internally to allow the lookup of ship-to adresses.

Consumption Point

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

Unloading Point

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

Use System Value

With this option field, you can control, whether Microsoft Dynamics NAV 2017 data should be used to fill missing information in this table.

No

Do not automatically fill any information. All information has to be set from the mapping, or by using cross-references and value translations. (The integer value of this option in the database is 0)

Add missing values

Do fill out missing information from internal Microsoft Dynamics NAV 2017 data, if available. (The integer value of this option in the database is 1)

Overwrite

Override any data with the system internal values, if available. (The integer value of this option in the database is 2)

System Field BitMask

Used internally to determine whether data is set from system values or manually. Do not modify.