invantive documentation
Invantive SupportforenAnmelden / Eintragen

MailMessagesReceived: Exact Online Received Mail Messages

insert update delete per partition webhook REST

  • Katalog: ExactOnlineREST
  • Schema: Mailbox
  • Primärschlüssel: ID
  • Label: Received Mail Messages

Mail messages received, partitioned per Exact Online subscription.

Die Daten in dieser Tabelle sind nach dem Wert der Spalte Division aufgeteilt.

Mit insert, update und delete können Daten abgerufen und geändert werden.

Zusammenfassung

Each Exact Online subscription can have a number of mailboxes. When you query any division, you will retrieve all received mail messages in the mailboxes on that subscription. A list of duplicate received mail messages will be retrieved when you query multiple divisions within the same Exact Online subscription.

Änderungen werden über das Webhook-Thema MailMessagesReceived übermittelt.

API-Quelle

  • Endpunkt: /api/v1/{division}/mailbox/MailMessagesReceived
  • Metadaten: /api/v1/{division}/mailbox/$metadata

Leistungsmerkmale

Characteristic Value
Durchschnittliche Zugriffsverzögerung (ms) 5
Anzahl der Vollscan-Zeilen pro Minute 7,200
Anzahl der Query-Zeilen pro Minute 300
Zeilen pro Minute schreiben 300

Das Ergebnis kann auf dem Client im Cache zwischengespeichert werden.

Tabellenspalten

Die Spalten der Tabelle MailMessagesReceived sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

Name Datentyp Label Required Marks Documentation
Bank guid Bank filters on the platform, writable Bank to/from which the mail message is sent/received.This is used for mail messages of type Bank only.It has an attachment containing the bank file.When used for a mail message of type bank, the value is reserved for internal use and will then be ignored.
BankAccount varchar2(50) Bankkonto filters on the platform, writable Bank account for which the mail message is sent.This is used for mail messages of type Bank only.It has an attachment containing the bank export file.When used for a mail message of type bank, the value is reserved for internal use and will then be ignored.
Country varchar2 Country filters on the platform, writable Country code.
Created datetime Created filters on the platform, writable Creation date.
CreatedUtc datetime Angelegt writable Creation date in UTC.
Creator guid Creator filters on the platform, writable User ID of creator.
CreatorFullName varchar2(240) Ersteller vollständiger Name filters on the platform, writable Name of creator.
Division int32 Abteilung ID Unique number of the Exact Online division.
DivisionCompanyCoCNumber varchar2(60) Nummer der Handelskammer des Bezirks writable Chamber of commerce number of the Exact Online division.
DivisionCompanyIBANNumber varchar2(50) Abteilung IBAN-Nummer writable IBAN number of the Exact Online division.
DivisionCompanyName varchar2(50) Geschäftsbereich Firmenname writable Company name of the Exact Online division.
DivisionCompanyRSINNumber varchar2(9) Abteilung RSIN-Nummer writable RSIN number of the Exact Online division.
DivisionCompanyVATNumber varchar2(35) Umsatzsteuer-Identifikationsnummer der Abteilung writable VAT number of the Exact Online division.
DivisionCompanyWageTaxNumber varchar2(60) Nummer der Lohnsteuerabteilung writable Wage tax number of the Exact Online division.
DivisionLabel varchar2(128) Abteilungsbezeichnung writable Label of the Exact Online division.
DivisionName varchar2(50) Verwaltung Name writable Name of the Exact Online division.
DivisionOwnerCompanyName varchar2(50) Name des Abonnenten writable Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionOwnerCompanyNumber varchar2(18) Abonnentennummer writable Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionShortName int64 Kurzbezeichnung der Abteilung writable Short name of the Exact Online division.
EuropeProcessing int16 Verarbeitung in Europa filters on the platform, writable Indicates that the scanning service must be done in (1) Europe or (0) both (inside or outside Europe).
ForDivision int32 Für die Abteilung filters on the platform, writable Administration from which the mail message is sent.This is used for mail messages of type Bank only.When used for a mail message of type bank, the value is reserved for internal use and will then be ignored.
ID guid ID filters on the platform, writable Primary key.
Modified datetime Modified filters on the platform, writable Last modified date.
ModifiedUtc datetime Geändert (UTC) writable Last modified date in UTC.
Modifier guid Modifier filters on the platform, writable User ID of modifier.
ModifierFullName varchar2(240) Geänderter vollständiger Name filters on the platform, writable Name of modifier.
Operation int16 Operation filters on the platform, writable Specifies the operation upon dealing with the mailmessage (Kirean scan service).
OriginalMessage guid Originalnachricht filters on the platform, writable Provides a link to another MailMessage (Kirean scan service).
OriginalMessageSubject varchar2(256) Original Nachrichtenbetreff filters on the platform, writable Subject of the OriginalMessage.
PartnerKey guid Partner-Schlüssel filters on the platform, writable The partner key that was used: this refers to the application from which the message is originating.It is filled with a fixed partnerkey when created from within Exact Online.
Quantity double Quantity filters on the platform, writable Specifies the number of lines of the returned MailMessage attachment (Kirean scan service).
RecipientAccount guid Empfänger Konto filters on the platform, writable Reference to the account that is receiving this mailmessage.
RecipientDeleted int16 Empfänger wurde gelöscht filters on the platform, writable Indiciates if the recipient deleted this message.If this is the case the recipient can't see it anymore and the sender can actually delete it.
RecipientMailbox varchar2(60) Empfänger Mailbox filters on the platform, writable Mailbox of recipient.
RecipientMailboxCustomerId guid Postfach-Kunden-ID writable Unique ID of Exact Online customer account in division 1.
RecipientMailboxCustomerName varchar2 Postfach Kundenname writable Name of Exact Online customer account in division 1.
RecipientMailboxDescription varchar2(240) Empfänger Mailbox Beschreibung filters on the platform, writable Mailbox description of recipient.
RecipientMailboxForDivision int32 Abteilung Postfächer writable Specific division to which mailbox is assigned to.
RecipientMailboxForDivisionDescription varchar2 Abteilung Postfächer writable Description of specific division to which mailbox is assigned to.
RecipientMailboxID guid Empfänger Mailbox ID filters on the platform, writable Mailbox ID of the recipient.The GlobalState of this mailbox will see the message in the inbox.
RecipientMailboxMailbox varchar2 Postfach von Postfach writable Email address-like format of mailbox, for example 'johndoe@exactonline.nl'.
RecipientMailboxPublish char Postfach veröffentlichen writable Customers can decide if they want this mailbox to be visible by all.I.e. some other customer can see this in address maintenance for digital postbox of type Exact.
RecipientMailboxType int32 Postfachtyp writable Type of mailbox.
RecipientMailboxValidFrom datetime E-Mail-Adresse Gültig ab writable Date that this mailbox will be valid from.
RecipientMailboxValidTo datetime Postfach gültig bis writable Date that this mailbox will not be valid anymore.
RecipientStatus int16 Empfänger Status filters on the platform, writable Status of the mail message, only the recipient can update this.
RecipientStatusDescription varchar2(30) Empfänger Status Beschreibung filters on the platform, writable Description of RecipientStatus.
SenderAccount guid Absender Konto filters on the platform, writable Reference to Account of Sender.
SenderDateSent datetime Gesendet am filters on the platform, writable Date the message was sent.Default the date the message is created, can be an earlier date when imported from xml (the date the xml was sent).
SenderDeleted int16 Absender gelöscht filters on the platform, writable Indicates if the sender deleted the message.This means the sender can't see it anymore and the recipient can actually delete it.
SenderIPAddress varchar2(15) Absender IP Adresse filters on the platform, writable IP address of the sender.
SenderMailbox varchar2(60) Absender Postfach filters on the platform, writable Mailbox of sender.
SenderMailboxDescription varchar2(240) Sender Mailbox Beschreibung filters on the platform, writable Description of SenderMailbox.
SenderMailboxID guid Sender Mailbox ID filters on the platform, writable Mailbox ID of the sender.The GlobalState of this mailbox will see the message in the sent items.
SkipRecipientMailBoxAddressOverride varchar2 itgen_eol_skiprecipientmailboxaddressoverride Filter auf der Plattform
Subject varchar2(256) Subject filters on the platform, writable Subject of the mail message.
SynchronizationCode varchar2(30) Synchronisationscode filters on the platform, writable Provides a link between Exact Online and the banks.
Type int32 Type filters on the platform, writable Type of the mail message.

Tasten

Key Column Bezieht sich auf Kind Description
MailMessagesReceived_Creator_Users_fk Creator Users.UserID Key
MailMessagesReceived_Modifier_Users_fk Modifier Users.UserID Key
MailMessagesReceived_RecipientMailboxID_Mailboxes_fk RecipientMailboxID Mailboxes.ID Key

Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: