MailMessagesSent: Exact Online Mail Messages Sent
insert update delete per partition webhook REST
- Catalogue :
ExactOnlineREST - Schéma :
Mailbox - Clés primaires :
ID - Label: Mail Messages Sent
Mail messages sent, partitioned per Exact Online subscription.
Les données de cette table sont partitionnées en fonction de la valeur de la colonne Division.
Permet de récupérer et de modifier des données à l'aide de insert, update et delete.
Résumé
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.
Les modifications sont transmises via le sujet de webhook MailMessagesSent.
Source de l'API
- Point de terminaison :
/api/v1/{division}/mailbox/MailMessagesSent - Métadonnées :
/api/v1/{division}/mailbox/$metadata
Caractéristiques de performance
| Characteristic | Value |
|---|---|
| Latence moyenne d'accès (ms) | 5 |
| Nombre de lignes par minute en mode de balayage complet | 7,200 |
| Nombre de lignes de requêtes ponctuelles par minute | 300 |
| Nombre d'enregistrements écrits par minute | 300 |
Le résultat peut être mis en cache côté client.
Colonnes de table
Les colonnes de la table MailMessagesSent sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.
| Name | Type de données | 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 |
Compte bancaire | 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 |
Créé | writable | Creation date in UTC. | |
Creator |
guid |
Creator | filters on the platform, writable | User ID of creator. | |
Creator |
varchar2 |
Nom complet de l'auteur | filters on the platform, writable | Name of creator. | |
Division |
int32 |
ID de l'entreprise | Unique number of the Exact Online division. | ||
Division |
varchar2 |
Numéro d'enregistrement à la Chambre de commerce de la division | writable | Chamber of commerce number of the Exact Online division. | |
Division |
varchar2 |
Numéro IBAN de la division | writable | IBAN number of the Exact Online division. | |
Division |
varchar2 |
Division - Nom de l'entreprise | writable | Company name of the Exact Online division. | |
Division |
varchar2 |
Numéro de division RSIN | writable | RSIN number of the Exact Online division. | |
Division |
varchar2 |
Numéro de TVA de la division | writable | VAT number of the Exact Online division. | |
Division |
varchar2 |
Numéro d'identification fiscale de la division | writable | Wage tax number of the Exact Online division. | |
Division |
varchar2 |
Étiquette de division | writable | Label of the Exact Online division. | |
Division |
varchar2 |
Nom de l'administration | writable | Name of the Exact Online division. | |
Division |
varchar2 |
Nom du titulaire de l'abonnement | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
varchar2 |
Numéro d'abonné | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
int64 |
Nom abrégé de la division | writable | Short name of the Exact Online division. | |
For |
int32 |
Pour la division | 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 |
Modifié (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | filters on the platform, writable | User ID of modifier. | |
Modifier |
varchar2 |
Nom complet modifié | 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 |
Message original | filters on the platform, writable | Provides a link to another MailMessage (Kirean scan service). | |
Original |
varchar2 |
Objet du message d'origine | filters on the platform, writable | Subject of the OriginalMessage. | |
Partner |
guid |
Clé partenaire | 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 |
Compte du bénéficiaire | filters on the platform, writable | Reference to the account that is receiving this mailmessage. | |
Recipient |
int16 |
Le destinataire a été supprimé | 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 |
Boîte aux lettres du destinataire | filters on the platform, writable | Mailbox of recipient. | |
Recipient |
varchar2 |
Description de la boîte aux lettres du destinataire | filters on the platform, writable | Mailbox description of recipient. | |
Recipient |
guid |
Identifiant de la boîte aux lettres du destinataire | filters on the platform, writable | Mailbox ID of the recipient.The GlobalState of this mailbox will see the message in the inbox. | |
Recipient |
int16 |
Statut du destinataire | filters on the platform, writable | Status of the mail message, only the recipient can update this. | |
Recipient |
varchar2 |
Description du statut du destinataire | filters on the platform, writable | Description of RecipientStatus. | |
Sender |
guid |
Compte expéditeur | filters on the platform, writable | Reference to Account of Sender. | |
Sender |
datetime |
Date d'envoi | 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 |
Expéditeur supprimé | 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 |
Adresse IP de l'expéditeur | filters on the platform, writable | IP address of the sender. | |
Sender |
varchar2 |
Boîte aux lettres de l'expéditeur | filters on the platform, writable | Mailbox of sender. | |
Sender |
guid |
Identifiant client de la boîte aux lettres | writable | Unique ID of Exact Online customer account in division 1. | |
Sender |
varchar2 |
Boîte aux lettres - Nom du client | writable | Name of Exact Online customer account in division 1. | |
Sender |
varchar2 |
Description de la boîte aux lettres de l'expéditeur | filters on the platform, writable | Description of SenderMailbox. | |
Sender |
int32 |
Division des boîtes aux lettres | writable | Specific division to which mailbox is assigned to. | |
Sender |
varchar2 |
Division des boîtes aux lettres | writable | Description of specific division to which mailbox is assigned to. | |
Sender |
guid |
Identifiant de la boîte aux lettres de l'expéditeur | 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 |
Boîte aux lettres de Mailbox | writable | Email address-like format of mailbox, for example 'johndoe@exactonline.nl'. | |
Sender |
char |
Publication de la boîte aux lettres | 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 |
Type de boîte aux lettres | writable | Type of mailbox. | |
Sender |
datetime |
Boîte aux lettres Valable à partir du | writable | Date that this mailbox will be valid from. | |
Sender |
datetime |
Boîte aux lettres valide jusqu'au | writable | Date that this mailbox will not be valid anymore. | |
Skip |
varchar2 |
itgen_eol_skiprecipientmailboxaddressoverride | filtres disponibles sur la plateforme | ||
Subject |
varchar2 |
Subject | filters on the platform, writable | Subject of the mail message. | |
Synchronization |
varchar2 |
Code de synchronisation de l'expéditeur | 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. |
Clés
| Key | Column | Se réfère à | Kind | Description |
|---|---|---|---|---|
Mail |
Creator |
Users. |
Key | |
Mail |
Modifier |
Users. |
Key | |
Mail |
Recipient |
Mailboxes.ID |
Key |
Notes de Version
Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :