invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

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.
BankAccount varchar2(50) 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.
CreatedUtc datetime Aangemaakt (UTC) writable Creation date in UTC.
Creator guid Creator filters on the platform, writable User ID of creator.
CreatorFullName varchar2(240) Aanmaker Volledige Naam filters on the platform, writable Name of creator.
Division int32 Divisie ID Unique number of the Exact Online division.
DivisionCompanyCoCNumber varchar2(60) Divisie Kamer van Koophandel Nummer writable Chamber of commerce number of the Exact Online division.
DivisionCompanyIBANNumber varchar2(50) Divisie IBAN Nummer writable IBAN number of the Exact Online division.
DivisionCompanyName varchar2(50) Divisie Bedrijfsnaam writable Company name of the Exact Online division.
DivisionCompanyRSINNumber varchar2(9) Divisie RSIN Nummer writable RSIN number of the Exact Online division.
DivisionCompanyVATNumber varchar2(35) Divisie BTW Nummer writable VAT number of the Exact Online division.
DivisionCompanyWageTaxNumber varchar2(60) Divisie Loonbelastingnummer writable Wage tax number of the Exact Online division.
DivisionLabel varchar2(128) Divisie Label writable Label of the Exact Online division.
DivisionName varchar2(50) Administratie Naam writable Name of the Exact Online division.
DivisionOwnerCompanyName varchar2(50) Naam Abonnementhouder writable Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionOwnerCompanyNumber varchar2(18) Abonnementhoudernummer writable Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionShortName int64 Divisie Korte Naam writable Short name of the Exact Online division.
ForDivision 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.
ModifiedUtc datetime Gewijzigd (UTC) writable Last modified date in UTC.
Modifier guid Modifier filters on the platform, writable User ID of modifier.
ModifierFullName varchar2(240) 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).
OriginalMessage guid Oorspronkelijk Bericht filters on the platform, writable Provides a link to another MailMessage (Kirean scan service).
OriginalMessageSubject varchar2(256) Oorspronkelijk Bericht Onderwerp filters on the platform, writable Subject of the OriginalMessage.
PartnerKey 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).
RecipientAccount guid Ontvanger Account filters on the platform, writable Reference to the account that is receiving this mailmessage.
RecipientDeleted 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.
RecipientMailbox varchar2(60) Ontvanger Postvak filters on the platform, writable Mailbox of recipient.
RecipientMailboxDescription varchar2(240) Ontvanger Mailbox Omschrijving filters on the platform, writable Mailbox description of recipient.
RecipientMailboxID 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.
RecipientStatus int16 Ontvanger Status filters on the platform, writable Status of the mail message, only the recipient can update this.
RecipientStatusDescription varchar2(30) Ontvanger Statusomschrijving filters on the platform, writable Description of RecipientStatus.
SenderAccount guid Afzender Account filters on the platform, writable Reference to Account of Sender.
SenderDateSent 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).
SenderDeleted 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.
SenderIPAddress varchar2(15) Afzender IP-adres filters on the platform, writable IP address of the sender.
SenderMailbox varchar2(60) Afzender Postvak filters on the platform, writable Mailbox of sender.
SenderMailboxCustomerId guid Postvak Klant ID writable Unique ID of Exact Online customer account in division 1.
SenderMailboxCustomerName varchar2 Postvak Klant Naam writable Name of Exact Online customer account in division 1.
SenderMailboxDescription varchar2(240) Afzender Mailbox Omschrijving filters on the platform, writable Description of SenderMailbox.
SenderMailboxForDivision int32 Postvak Divisie writable Specific division to which mailbox is assigned to.
SenderMailboxForDivisionDescription varchar2 Postvak Divisie writable Description of specific division to which mailbox is assigned to.
SenderMailboxID 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.
SenderMailboxMailbox varchar2 Postvak van Postvak writable Email address-like format of mailbox, for example 'johndoe@exactonline.nl'.
SenderMailboxPublish 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.
SenderMailboxType int32 Postvaksoort writable Type of mailbox.
SenderMailboxValidFrom datetime Postvak Geldig van writable Date that this mailbox will be valid from.
SenderMailboxValidTo datetime Postvak Geldig tot writable Date that this mailbox will not be valid anymore.
SkipRecipientMailBoxAddressOverride varchar2 itgen_eol_skiprecipientmailboxaddressoverride filters op het platform
Subject varchar2(256) Subject filters on the platform, writable Subject of the mail message.
SynchronizationCode varchar2(30) 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
MailMessagesSent_Creator_Users_fk Creator Users.UserID Key
MailMessagesSent_Modifier_Users_fk Modifier Users.UserID Key
MailMessagesSent_RecipientMailboxID_Mailboxes_fk RecipientMailboxID Mailboxes.ID Key

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: