MailMessagesSent: Exact Online Mail Messages Sent
insert update delete per partition webhook REST
- Katalog:
ExactOnlineREST - Schema:
Mailbox - Primärschlüssel:
ID - Label: Mail Messages Sent
Mail messages sent, 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 sent mail messages in the mailboxes on that subscription. A list of duplicate sent mail messages will be retrieved when you query multiple divisions within the same Exact Online subscription.
Änderungen werden über das Webhook-Thema MailMessagesSent übermittelt.
API-Quelle
- Endpunkt:
/api/v1/{division}/mailbox/MailMessagesSent - 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 MailMessagesSent 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. | |
Bank |
varchar2 |
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. | |
Created |
datetime |
Angelegt | writable | Creation date in UTC. | |
Creator |
guid |
Creator | filters on the platform, writable | User ID of creator. | |
Creator |
varchar2 |
Ersteller vollständiger Name | filters on the platform, writable | Name of creator. | |
Division |
int32 |
Abteilung ID | Unique number of the Exact Online division. | ||
Division |
varchar2 |
Nummer der Handelskammer des Bezirks | writable | Chamber of commerce number of the Exact Online division. | |
Division |
varchar2 |
Abteilung IBAN-Nummer | writable | IBAN number of the Exact Online division. | |
Division |
varchar2 |
Geschäftsbereich Firmenname | writable | Company name of the Exact Online division. | |
Division |
varchar2 |
Abteilung RSIN-Nummer | writable | RSIN number of the Exact Online division. | |
Division |
varchar2 |
Umsatzsteuer-Identifikationsnummer der Abteilung | writable | VAT number of the Exact Online division. | |
Division |
varchar2 |
Nummer der Lohnsteuerabteilung | writable | Wage tax number of the Exact Online division. | |
Division |
varchar2 |
Abteilungsbezeichnung | writable | Label of the Exact Online division. | |
Division |
varchar2 |
Verwaltung Name | writable | Name of the Exact Online division. | |
Division |
varchar2 |
Name des Abonnenten | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
varchar2 |
Abonnentennummer | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
int64 |
Kurzbezeichnung der Abteilung | writable | Short name of the Exact Online division. | |
For |
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. | |
Modified |
datetime |
Geändert (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | filters on the platform, writable | User ID of modifier. | |
Modifier |
varchar2 |
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). | |
Original |
guid |
Originalnachricht | filters on the platform, writable | Provides a link to another MailMessage (Kirean scan service). | |
Original |
varchar2 |
Original Nachrichtenbetreff | filters on the platform, writable | Subject of the OriginalMessage. | |
Partner |
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). | |
Recipient |
guid |
Empfänger Konto | filters on the platform, writable | Reference to the account that is receiving this mailmessage. | |
Recipient |
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. | |
Recipient |
varchar2 |
Empfänger Mailbox | filters on the platform, writable | Mailbox of recipient. | |
Recipient |
varchar2 |
Empfänger Mailbox Beschreibung | filters on the platform, writable | Mailbox description of recipient. | |
Recipient |
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. | |
Recipient |
int16 |
Empfänger Status | filters on the platform, writable | Status of the mail message, only the recipient can update this. | |
Recipient |
varchar2 |
Empfänger Status Beschreibung | filters on the platform, writable | Description of RecipientStatus. | |
Sender |
guid |
Absender Konto | filters on the platform, writable | Reference to Account of Sender. | |
Sender |
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). | |
Sender |
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. | |
Sender |
varchar2 |
Absender IP Adresse | filters on the platform, writable | IP address of the sender. | |
Sender |
varchar2 |
Absender Postfach | filters on the platform, writable | Mailbox of sender. | |
Sender |
guid |
Postfach-Kunden-ID | writable | Unique ID of Exact Online customer account in division 1. | |
Sender |
varchar2 |
Postfach Kundenname | writable | Name of Exact Online customer account in division 1. | |
Sender |
varchar2 |
Sender Mailbox Beschreibung | filters on the platform, writable | Description of SenderMailbox. | |
Sender |
int32 |
Abteilung Postfächer | writable | Specific division to which mailbox is assigned to. | |
Sender |
varchar2 |
Abteilung Postfächer | writable | Description of specific division to which mailbox is assigned to. | |
Sender |
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. | |
Sender |
varchar2 |
Postfach von Postfach | writable | Email address-like format of mailbox, for example 'johndoe@exactonline.nl'. | |
Sender |
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. | |
Sender |
int32 |
Postfachtyp | writable | Type of mailbox. | |
Sender |
datetime |
E-Mail-Adresse Gültig ab | writable | Date that this mailbox will be valid from. | |
Sender |
datetime |
Postfach gültig bis | writable | Date that this mailbox will not be valid anymore. | |
Skip |
varchar2 |
itgen_eol_skiprecipientmailboxaddressoverride | Filter auf der Plattform | ||
Subject |
varchar2 |
Subject | filters on the platform, writable | Subject of the mail message. | |
Synchronization |
varchar2 |
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 |
|---|---|---|---|---|
Mail |
Creator |
Users. |
Key | |
Mail |
Modifier |
Users. |
Key | |
Mail |
Recipient |
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: