# MailMessagesReceived: Exact Online Received Mail Messages
Mail messages received, partitioned per Exact Online subscription.
## Documentation:
Each Exact Online subscription can have a number of mailboxes. When you query any division, you will retrieve all received mail messages in the mailboxes on that subscription. A list of duplicate received mail messages will be retrieved when you query multiple divisions within the same Exact Online subscription.
- Catalog: `ExactOnlineREST`
- Schema: `Mailbox`
- Primary Keys: `ID`
- Label: Received Mail Messages
The data in this table is partitioned per value of the `Division` column.
Can retrieve data and change data using insert, update and delete.
## Table Columns
The columns of the table `MailMessagesReceived` 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 | Documentation |
|---|:---:|---|:---:|---|
| `Bank` | `guid` | Bank | ☐ | 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 | ☐ | 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 | ☐ | Country code. |
| `Created` | `datetime` | Created | ☐ | Creation date. |
| `CreatedUtc` | `datetime` | Created (UTC) | ☐ | Creation date in UTC. |
| `Creator` | `guid` | Creator | ☐ | User ID of creator. |
| `CreatorFullName` | `varchar2`(240) | Creator Full Name | ☐ | Name of creator. |
| `Division` | `int32` | Division ID | ☑ | Unique number of the Exact Online division. |
| `DivisionCompanyCoCNumber` | `varchar2`(60) | Division Chamber of Commerce Number | ☐ | Chamber of commerce number of the Exact Online division. |
| `DivisionCompanyIBANNumber` | `varchar2`(50) | Division IBAN Number | ☐ | IBAN number of the Exact Online division. |
| `DivisionCompanyName` | `varchar2`(50) | Division Company Name | ☑ | Company name of the Exact Online division. |
| `DivisionCompanyRSINNumber` | `varchar2`(9) | Division RSIN Number | ☐ | RSIN number of the Exact Online division. |
| `DivisionCompanyVATNumber` | `varchar2`(35) | Division VAT Number | ☐ | VAT number of the Exact Online division. |
| `DivisionCompanyWageTaxNumber` | `varchar2`(60) | Division Wage Tax Number | ☐ | Wage tax number of the Exact Online division. |
| `DivisionLabel` | `varchar2`(128) | Division Label | ☑ | Label of the Exact Online division. |
| `DivisionName` | `varchar2`(50) | Administration Name | ☑ | Name of the Exact Online division. |
| `DivisionOwnerCompanyName` | `varchar2`(50) | Subscription Holder Name | ☑ | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. |
| `DivisionOwnerCompanyNumber` | `varchar2`(18) | Subscription Holder Number | ☑ | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. |
| `DivisionShortName` | `int64` | Division Short Name | ☑ | Short name of the Exact Online division. |
| `EuropeProcessing` | `int16` | Europe Processing | ☑ | Indicates that the scanning service must be done in (1) Europe or (0) both (inside or outside Europe). |
| `ForDivision` | `int32` | For Division | ☐ | 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 | ☑ | Primary key. |
| `Modified` | `datetime` | Modified | ☐ | Last modified date. |
| `ModifiedUtc` | `datetime` | Modified (UTC) | ☐ | Last modified date in UTC. |
| `Modifier` | `guid` | Modifier | ☐ | User ID of modifier. |
| `ModifierFullName` | `varchar2`(240) | Modified Full Name | ☐ | Name of modifier. |
| `Operation` | `int16` | Operation | ☐ | Specifies the operation upon dealing with the mailmessage (Kirean scan service). |
| `OriginalMessage` | `guid` | Original Message | ☐ | Provides a link to another MailMessage (Kirean scan service). |
| `OriginalMessageSubject` | `varchar2`(256) | Original Message Subject | ☐ | Subject of the OriginalMessage. |
| `PartnerKey` | `guid` | Partner Key | ☐ | 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 | ☐ | Specifies the number of lines of the returned MailMessage attachment (Kirean scan service). |
| `RecipientAccount` | `guid` | Recipient Account | ☐ | Reference to the account that is receiving this mailmessage. |
| `RecipientDeleted` | `int16` | Recipient Is Deleted | ☑ | 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 | ☐ | Mailbox of recipient. |
| `RecipientMailboxCustomerId` | `guid` | Mailbox Customer ID | ☐ | Unique ID of Exact Online customer account in division 1. |
| `RecipientMailboxCustomerName` | `varchar2` | Mailbox Customer Name | ☐ | Name of Exact Online customer account in division 1. |
| `RecipientMailboxDescription` | `varchar2`(240) | Recipient Mailbox Description | ☐ | Mailbox description of recipient. |
| `RecipientMailboxForDivision` | `int32` | Mailbox Division | ☐ | Specific division to which mailbox is assigned to. |
| `RecipientMailboxForDivisionDescription` | `varchar2` | Mailbox Division | ☐ | Description of specific division to which mailbox is assigned to. |
| `RecipientMailboxID` | `guid` | Recipient Mailbox ID | ☐ | Mailbox ID of the recipient. The GlobalState of this mailbox will see the message in the inbox. |
| `RecipientMailboxMailbox` | `varchar2` | Mailbox of Mailbox | ☐ | Email address-like format of mailbox, for example '
[email protected]'. |
| `RecipientMailboxPublish` | `char` | Mailbox Publish | ☐ | 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. |
| `RecipientMailboxType` | `int32` | Mailbox Type | ☐ | Type of mailbox. |
| `RecipientMailboxValidFrom` | `datetime` | Mailbox Valid from | ☐ | Date that this mailbox will be valid from. |
| `RecipientMailboxValidTo` | `datetime` | Mailbox Valid to | ☐ | Date that this mailbox will not be valid anymore. |
| `RecipientStatus` | `int16` | Recipient Status | ☐ | Status of the mail message, only the recipient can update this. |
| `RecipientStatusDescription` | `varchar2`(30) | Recipient Status Description | ☐ | Description of RecipientStatus. |
| `SenderAccount` | `guid` | Sender Account | ☐ | Reference to Account of Sender. |
| `SenderDateSent` | `datetime` | Date Sent | ☐ | 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 | ☑ | 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 | ☐ | IP address of the sender. |
| `SenderMailbox` | `varchar2`(60) | Sender Mailbox | ☐ | Mailbox of sender. |
| `SenderMailboxDescription` | `varchar2`(240) | Sender Mailbox Description | ☐ | Description of SenderMailbox. |
| `SenderMailboxID` | `guid` | Sender Mailbox ID | ☐ | Mailbox ID of the sender. The GlobalState of this mailbox will see the message in the sent items. |
| `SkipRecipientMailBoxAddressOverride` | `varchar2` | | ☐ | |
| `Subject` | `varchar2`(256) | Subject | ☐ | Subject of the mail message. |
| `SynchronizationCode` | `varchar2`(30) | Sender Synchronization Code | ☐ | Provides a link between Exact Online and the banks. |
| `Type` | `int32` | Type | ☐ | Type of the mail message. |