EDI Transmission
This table keeps track of all EDI data sent or received by your organization. It provides information on the status of each transmission, such as whether it was successful, failed, or in progress. You can also see the date and time of the transmission and the sender/recipient of the transmission. Each transmission has one (or more) associated messages. The transmission stores the basic metadata, while the file content is stored in the EDI Message. The easiest way to think of this is as an email. The EDI Transmission is the message data such as sender, etc., while the EDI Message is the individual attachment with the payload data.
Fields
An automatically assigned number. This field is part of the primary key.
The direction of the transmission.
The data is received from an external party and is incoming into Microsoft Dynamics 365 Business Central.
(The integer value of this option in the database is 0)
The data is sent to an external party.
(The integer value of this option in the database is 1)
Currently not used.
The code of the EDI Transmission Folder this transmission belongs to.
A description of the transmission.
The current status of the transmission.
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)
The status was reseted after an error.
(The integer value of this option in the database is 1)
The transmission is currently being sent or received.
(The integer value of this option in the database is 2)
The transmission was successfully sent or received.
(The integer value of this option in the database is 3)
Sending or receiving failed. There is an processing queue entry with more information.
(The integer value of this option in the database is 4)
The transmission is currently created.
(The integer value of this option in the database is 5)
The transmission could not be created.
(The integer value of this option in the database is 6)
The date/time the transmission was created in Microsoft Dynamics 365 Business Central.
The date/time the transmission was created according to the communication channel (e.g. the file date).
The date/time the transmission was modified last.
Not used.
The responsible EDI Communication Channel code.
The sending partner code.
The sending partner identification.
The cross-reference used to translate an incoming partner identification to the partner code.
The receiving partner code.
The receiving partner identification.
The cross-reference used to translate the receiving partner identification to the partner code.
Information about the transmission. Depending on the communication codeunit this contains, for example, the path.
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.
Additional information about the transmission.
Additional information about the transmission.
Read-only flow representing the count of messages.
Read-only flow representing the count of processing queue entries to process this transmission.
Read-only flow representing the count of open processing queue entries to process this transmission.
Read-only flow representing the count of failed processing queue entries to process this transmission.
Read-only flow representing the count of linked document to this transmission.
The project code of the mapping used to process this transmission.
The format code of the mapping used to process this transmission.
The code of the mapping used to process this transmission.
Whether this transmission is tagged as test.