Config / Data Exchange / EDI Transmission

EDI Transmission

This table stores information about incoming and outgoing transmissions. This table will store all the metadata, while the actual data is stored in the table EDI Message. A transmission can consists of multiple messages, like for example, an email can have multiple attachments. But a lot of the times you have one message per transmission. The user will mainly work with the transmission table.

Fields

Entry No.

An automatically assigned number. This field is part of the primary key.

Direction

The direction of the transmission.

Incoming

The data is received from an external party and is incoming into Microsoft Dynamics NAV 2017.
(The integer value of this option in the database is 0)

Outgoing

The data is sent to an external party.
(The integer value of this option in the database is 1)

Reference No.

Currently not used.

Folder Code

The code of the EDI Transmission Folder this transmission belongs to.

Description

An automatically created description.

Transmission Status

The current status of the transmission.

Open

The transmission is open. For outgoing transmissions it means taht it is waiting for the send action. On incoming data it means that the transmission was ssen, but not yet received.
(The integer value of this option in the database is 0)

Retry

The status was reseted after an error.
(The integer value of this option in the database is 1)

In Progress

The transmission is currently being sent or received.
(The integer value of this option in the database is 2)

Received/Transmitted

The transmission was successfully sent or received.
(The integer value of this option in the database is 3)

Failed

Sending or receiving failed. There is an processing queue entry with more information.
(The integer value of this option in the database is 4)

In Creation

The transmission is currently created.
(The integer value of this option in the database is 5)

Creation Failed

The transmission could not be created.
(The integer value of this option in the database is 6)

Created Date/Time

The date/time the transmission was created in Microsoft Dynamics NAV 2017.

Transmission Date/Time

The date/time the transmission was created according to the communication channel (e.g. the file date).

Last Modified Date/Time

The date/time the transmission was modified last.

Original Date/Time

Not used.

Communication Channel Code

The responsible EDI Communication Channel code.

Sender Partner

The sending partner code.

Sender Identification

The sending partner identification.

Sender Cross-Reference Type

The cross-reference used to translate an incoming partner identification to the partner code.

Receiver Partner

The receiving partner code.

Receiver Identification

The receiving partner identification.

Receiver Cross-Reference Type

The cross-reference used to translate the receiving partner identification to the partner code.

Tag 1

Information about the transmission. Depending on the communication codeunit this contains, for example, the path.

Tag 2

Information about the transmission. Depending on the communication codeunit this contains, for example, the file name. On e-mails this contains the servers message ID.

Tag 3

Additional information about the transmission.

Tag 4

Additional information about the transmission.

Message Count

Read-only flow representing the count of messages.

Processing Queue Entries

Read-only flow representing the count of processing queue entries to process this transmission.

Open Proc.Queue Entries

Read-only flow representing the count of open processing queue entries to process this transmission.

Failed Proc.Queue Entries

Read-only flow representing the count of failed processing queue entries to process this transmission.

Linked Documents

Read-only flow representing the count of linked document to this transmission.

Project Code

The project code of the mapping used to process this transmission.

Format Code

The format code of the mapping used to process this transmission.

Mapping Code

The code of the mapping used to process this transmission.

Test Flag

Whether this transmission is tagged as test.