Config / Advanced Topics / EDI Cross-Reference Type

EDI Cross-Reference Type

The cross-reference system in Anveo EDI Connect is a simple way to translate between internal and external information. There are several point where we have a combination of two fields, where one field name ends with Identification and the other one with Identification Type.
The field ending with Identification is used to store external information. The field ending with Identification Type specifies the EDI Cross-Reference Type that should be used to either set the information in the field whose name ends with Identification or retrieve internal information from that field.

In the table EDI Document the field Direction is used to determine the direction for the cross-reference.

The cross-reference system also allows the user to add missing information directly in the buffer document and store it for later use.

The system is build in a way that the translation of the values does not create any errors. This way you can directly apply cross-references on import mappings. You have to ensure that you got the required information by checking the data in the mappings.

Fields

Code

This field is part of the primary key. A code describing the cross-reference. You can use the same code for multiple references to different tables, like GLN linked to the customer and GLN linked to a ship-to address.

Relation Table ID

This field is part of the primary key. The table this cross-reference is linked to.

Description

A description of the cross reference type.

Update Behavior

Defines what should happen if the user enters missing information.

Ask User

Ask the user whether the value should be stores for further use.
(The integer value of this option in the database is 0)

Do not update

Do not automatically create references.
(The integer value of this option in the database is 1)

Update automatically

Automatically create the link, if it is missing.
(The integer value of this option in the database is 2)

Type

The way the cross-reference retrieves the number.

Cross Reference Lookup Table

Use a lookup table from the Anveo EDI Connect module. You can directly navigate to the entries from this page.
(The integer value of this option in the database is 0)

Field

Use a field on the target table. Like the GLN on the Customer or a similar field, which uniquely identifies the record.
(The integer value of this option in the database is 1)

Callback

Use custom C/AL or AL programming to retrieve the correct data.
(The integer value of this option in the database is 2)

Relation Table

The name of the table this cross-reference is linking to.

External Value Field

In case you are using a field from the target table for the lookup, this field stores the field name that should be used.

External Value Field No.

In case you are using a field from the target table for the lookup, this field stores the field number that should be used.

Relation Table Caption

The caption of the related table.

Last Modified

The date/time this record was modified last.

Table EDI Cross-Reference

This table is used to store the relations, if the module internal cross-reference table should be used.

Fields

We only describe the fields used by the page. You should not directly modify this table.

EDI Project Code

This field is part of the primary key. Not used anymore, please leave blank.

Cross-Reference Type

This field is part of the primary key. The cross-reference type this entry belongs to.

Internal No.

The number in the Anveo EDI Connect system or Anveo EDI Connect module table.

External No.

The external number used by the EDI partner.

Priority

You can optionally assign a priority to the entry.

Highest

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

High

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

Normal

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

Low

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

Lowest

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

WordPress Cookie Notice by Real Cookie Banner