| id | Primary key | PK | No |
| description | Describes the shipment | String(255) | Yes |
| message_id | The id of the message that is sent in this shipment | FK s_message | No |
| start_date | The date and time when to start this shipment | DateTime | Yes |
| end_date | Is set when this shipment is ended | DateTime | Yes |
| from_addr | Email address to put in the From header of the messages | String(255) | No |
| reply_addr | Email address to put in the Reply To: header of the messages | String(255) | Yes |
| envelope_from | Email address for the MTA envelope (where bounces are returned) | String(255) | Yes |
| smtp_serv | The server to use for this shipment. | String(255) | Yes |
| smtp_port | The port of the SMTP server to use for this shipment. | Int | No |
| send_rate | Maximum number of messages sent per minute. | Int | No |
| status | Sending/stopped/failed etc. | Enum ShipmentStatus | No |
| recipients | The total number of recipients to send message to. | Int | No |
| actual_rate | The actual rate of messages per minute. can be lower than send_rate | Int | No |
| actual_time | The time of the last checkpoint | DateTime | Yes |
| actual_count | Number of emails sent at the last checkpoint | Int | No |
| current_sender | Timestamp to identify which ejsender that owns this shipment | Int | Yes |
| ticket_owner | The owner of the ticket if any is created while sending out a shipment. -1 if no ticket should be automatically delegated, 1 if the ticket is unassigned, >1 for all others | Int | Yes |
| ticket_category | The category of tickets created while sending out if any. -1 if no ticket should be created | Int | Yes |
| flags | Various flags for a shipment | UInt | Yes |
| folder_id | The folder which this shipment belongs to. -1 indicates that the shipment is on the root | Int | No |
| configuration | This field indicates what kind of shipment this is. | Int | No |
| selection_id | Set if this shipment should be related to a Selection | FK selection | Yes |
| project_id | Set if this shipment should be related to a Project | FK project | Yes |
| generated_document_id | ID of the merged document that is the result of the shipment | FK document | Yes |
| registered | Registered when | UtcDateTime | Yes |
| registered_associate_id | Registered by whom | FK associate | Yes |
| updated | Last updated when | UtcDateTime | Yes |
| updated_associate_id | Last updated by whom | FK associate | Yes |
| updatedCount | Number of updates made to this record | UShort | Yes |
| active_pane | The currently active pane in the mailing wizard | Int | Yes |
| sorting | Which sorting should be used on the document mailing recipient list, used when generating PDF | Enum RecipientSorting | No |
| delivered_num | Number of mails sent minus bounces | Int | Yes |
| open_num | Number of opened emails count | Int | Yes |
| open_rate | Open rate % (open_num / delivered_num) | Double | Yes |
| click_num | Number of links clicked | Int | Yes |
| click_rate | Click rate % (click_num / delivered_num) | Double | Yes |
| hardbounce_num | Number of hard bounces | Int | Yes |
| hardbounce_rate | Hard bounce rate % (hardbounce_num / number_transmitted) | Double | Yes |
| softbounce_num | Number of soft bounces | Int | Yes |
| softbounce_rate | Soft bounce rate % (softbounce_num / number_transmitted) | Double | Yes |
| totalbounce_num | Total number of bounces | Int | Yes |
| totalbounce_rate | Total bounce rate % (totalbounce_num / number_transmitted) | Double | Yes |
| are_statistics_dirty | Indicates if shipment needs statistics calculation, set by code that changes the shipment or receives clicks/opens | Bool | No |
| sent_num | Number of mails sent | Int | Yes |
| shipmenttype_id | Id of subscriptionType that this shipment has, so we may check for reservations | FK ShipmentType | Yes |
