invantive documentation
Invantive Support ForumsLog In / Sign Up

MailMessagesSentUnhandled: Exact Online Unhandled Sent Mail Messages

read only

  • Catalog: ExactOnlineREST
  • Schema: Mailbox
  • Label: Unhandled Sent Mail Messages

Mail messages sent in Exact Online, but not yet handled.

Can only retrieve data.

Performance Characteristics

Characteristic Value
Average access latency (ms) 432
Full scan rows per minute 50,300
Point query rows per minute 138

The result can be cached on the client.

Table Columns

The columns of the table MailMessagesSentUnhandled are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type 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) Bank Account 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 Created (UTC) writable Creation date in UTC.
Creator guid Creator filters on the platform, writable User ID of creator.
CreatorFullName varchar2(240) Creator Full Name filters on the platform, writable Name of creator.
Division int32 Division ID Unique number of the Exact Online division.
DivisionCompanyCoCNumber varchar2(60) Division Chamber of Commerce Number writable Chamber of commerce number of the Exact Online division.
DivisionCompanyIBANNumber varchar2(50) Division IBAN Number writable IBAN number of the Exact Online division.
DivisionCompanyName varchar2(50) Division Company Name writable Company name of the Exact Online division.
DivisionCompanyRSINNumber varchar2(9) Division RSIN Number writable RSIN number of the Exact Online division.
DivisionCompanyVATNumber varchar2(35) Division VAT Number writable VAT number of the Exact Online division.
DivisionCompanyWageTaxNumber varchar2(60) Division Wage Tax Number writable Wage tax number of the Exact Online division.
DivisionLabel varchar2(128) Division Label writable Label of the Exact Online division.
DivisionName varchar2(50) Administration Name writable Name of the Exact Online division.
DivisionOwnerCompanyName varchar2(50) Subscription Holder Name writable Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionOwnerCompanyNumber varchar2(18) Subscription Holder Number writable Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionShortName int64 Division Short Name writable Short name of the Exact Online division.
ForDivision int32 For 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.
ModifiedUtc datetime Modified (UTC) writable Last modified date in UTC.
Modifier guid Modifier filters on the platform, writable User ID of modifier.
ModifierFullName varchar2(240) Modified Full 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 Original Message filters on the platform, writable Provides a link to another MailMessage (Kirean scan service).
OriginalMessageSubject varchar2(256) Original Message Subject filters on the platform, writable Subject of the OriginalMessage.
PartnerKey guid Partner Key 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 Recipient Account filters on the platform, writable Reference to the account that is receiving this mailmessage.
RecipientDeleted int16 Recipient Is Deleted 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) Recipient Mailbox filters on the platform, writable Mailbox of recipient.
RecipientMailboxDescription varchar2(240) Recipient Mailbox Description filters on the platform, writable Mailbox description of recipient.
RecipientMailboxID guid Recipient 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 Recipient Status filters on the platform, writable Status of the mail message, only the recipient can update this.
RecipientStatusDescription varchar2(30) Recipient Status Description filters on the platform, writable Description of RecipientStatus.
SenderAccount guid Sender Account filters on the platform, writable Reference to Account of Sender.
SenderDateSent datetime Date Sent 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 Sender Deleted 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) Sender IP Address filters on the platform, writable IP address of the sender.
SenderMailbox varchar2(60) Sender Mailbox filters on the platform, writable Mailbox of sender.
SenderMailboxCustomerId guid Mailbox Customer ID writable Unique ID of Exact Online customer account in division 1.
SenderMailboxCustomerName varchar2 Mailbox Customer Name writable Name of Exact Online customer account in division 1.
SenderMailboxDescription varchar2(240) Sender Mailbox Description filters on the platform, writable Description of SenderMailbox.
SenderMailboxForDivision int32 Mailbox Division writable Specific division to which mailbox is assigned to.
SenderMailboxForDivisionDescription varchar2 Mailbox Division writable Description of specific division to which mailbox is assigned to.
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.
SenderMailboxMailbox varchar2 Mailbox of Mailbox writable Email address-like format of mailbox, for example 'johndoe@exactonline.nl'.
SenderMailboxPublish char Mailbox Publish 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 Mailbox Type writable Type of mailbox.
SenderMailboxValidFrom datetime Mailbox Valid from writable Date that this mailbox will be valid from.
SenderMailboxValidTo datetime Mailbox Valid to writable Date that this mailbox will not be valid anymore.
SkipRecipientMailBoxAddressOverride varchar2 itgen_eol_skiprecipientmailboxaddressoverride filters on the platform
Subject varchar2(256) Subject filters on the platform, writable Subject of the mail message.
SynchronizationCode varchar2(30) Sender Synchronization Code 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.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: