MailMessagesSent: Exact Online Mail Messages Sent
insert update delete per partition webhook REST
- Catalogus:
ExactOnlineREST - Schema:
Mailbox - Primaire sleutels:
ID - Label: Mail Messages Sent
Mail messages sent, partitioned per Exact Online subscription.
De gegevens in deze tabel zijn gepartitioneerd per waarde van de kolom Division.
Je kunt gegevens ophalen en wijzigen met insert, update en delete.
Samenvatting
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.
Wijzigingen worden doorgegeven via het webhook-onderwerp MailMessagesSent.
API-bron
- Eindpunt:
/api/v1/{division}/mailbox/MailMessagesSent - Metagegevens:
/api/v1/{division}/mailbox/$metadata
Prestatiekenmerken
| Characteristic | Value |
|---|---|
| Gemiddelde toegangsvertraging (ms) | 5 |
| Aantal rijen per minuut bij volledige scan | 7,200 |
| Aantal rijen per minuut in een Query | 300 |
| Aantal rijen per minuut schrijven | 300 |
Het resultaat kan op de client in de Cache worden opgeslagen.
Tabelkolommen
De kolommen van de tabel MailMessagesSent worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
| Name | Datatype | 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 |
Bankrekening | 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 |
Aangemaakt (UTC) | writable | Creation date in UTC. | |
Creator |
guid |
Creator | filters on the platform, writable | User ID of creator. | |
Creator |
varchar2 |
Aanmaker Volledige Naam | filters on the platform, writable | Name of creator. | |
Division |
int32 |
Divisie ID | Unique number of the Exact Online division. | ||
Division |
varchar2 |
Divisie Kamer van Koophandel Nummer | writable | Chamber of commerce number of the Exact Online division. | |
Division |
varchar2 |
Divisie IBAN Nummer | writable | IBAN number of the Exact Online division. | |
Division |
varchar2 |
Divisie Bedrijfsnaam | writable | Company name of the Exact Online division. | |
Division |
varchar2 |
Divisie RSIN Nummer | writable | RSIN number of the Exact Online division. | |
Division |
varchar2 |
Divisie BTW Nummer | writable | VAT number of the Exact Online division. | |
Division |
varchar2 |
Divisie Loonbelastingnummer | writable | Wage tax number of the Exact Online division. | |
Division |
varchar2 |
Divisie Label | writable | Label of the Exact Online division. | |
Division |
varchar2 |
Administratie Naam | writable | Name of the Exact Online division. | |
Division |
varchar2 |
Naam Abonnementhouder | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
varchar2 |
Abonnementhoudernummer | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
int64 |
Divisie Korte Naam | writable | Short name of the Exact Online division. | |
For |
int32 |
Voor Divisie | 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 |
Gewijzigd (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | filters on the platform, writable | User ID of modifier. | |
Modifier |
varchar2 |
Gewijzigd Volledige Naam | 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 |
Oorspronkelijk Bericht | filters on the platform, writable | Provides a link to another MailMessage (Kirean scan service). | |
Original |
varchar2 |
Oorspronkelijk Bericht Onderwerp | filters on the platform, writable | Subject of the OriginalMessage. | |
Partner |
guid |
Partnersleutel | 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 |
Ontvanger Account | filters on the platform, writable | Reference to the account that is receiving this mailmessage. | |
Recipient |
int16 |
Ontvanger is Verwijderd | 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 |
Ontvanger Postvak | filters on the platform, writable | Mailbox of recipient. | |
Recipient |
varchar2 |
Ontvanger Mailbox Omschrijving | filters on the platform, writable | Mailbox description of recipient. | |
Recipient |
guid |
Ontvanger 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 |
Ontvanger Status | filters on the platform, writable | Status of the mail message, only the recipient can update this. | |
Recipient |
varchar2 |
Ontvanger Statusomschrijving | filters on the platform, writable | Description of RecipientStatus. | |
Sender |
guid |
Afzender Account | filters on the platform, writable | Reference to Account of Sender. | |
Sender |
datetime |
Datum Verzonden | 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 |
Afzender Verwijderd | 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 |
Afzender IP-adres | filters on the platform, writable | IP address of the sender. | |
Sender |
varchar2 |
Afzender Postvak | filters on the platform, writable | Mailbox of sender. | |
Sender |
guid |
Postvak Klant ID | writable | Unique ID of Exact Online customer account in division 1. | |
Sender |
varchar2 |
Postvak Klant Naam | writable | Name of Exact Online customer account in division 1. | |
Sender |
varchar2 |
Afzender Mailbox Omschrijving | filters on the platform, writable | Description of SenderMailbox. | |
Sender |
int32 |
Postvak Divisie | writable | Specific division to which mailbox is assigned to. | |
Sender |
varchar2 |
Postvak Divisie | writable | Description of specific division to which mailbox is assigned to. | |
Sender |
guid |
Afzender 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 |
Postvak van Postvak | writable | Email address-like format of mailbox, for example 'johndoe@exactonline.nl'. | |
Sender |
char |
Mailbox Publicatie | 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 |
Postvaksoort | writable | Type of mailbox. | |
Sender |
datetime |
Postvak Geldig van | writable | Date that this mailbox will be valid from. | |
Sender |
datetime |
Postvak Geldig tot | writable | Date that this mailbox will not be valid anymore. | |
Skip |
varchar2 |
itgen_eol_skiprecipientmailboxaddressoverride | filters op het platform | ||
Subject |
varchar2 |
Subject | filters on the platform, writable | Subject of the mail message. | |
Synchronization |
varchar2 |
Zender Synchronisatiecode | 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. |
Toetsen
| Key | Column | Verwijst naar | Kind | Description |
|---|---|---|---|---|
Mail |
Creator |
Users. |
Key | |
Mail |
Modifier |
Users. |
Key | |
Mail |
Recipient |
Mailboxes.ID |
Key |
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: