Email Address Field Lengths

 

Email address fields are throughout the MoversSuite application.  Below is a listing of database tables that contain an email column. The chart also indicates field lengths for each of those locations. The “field length” indicates how many characters can be entered in that field. The extended lengths of the field allow for multiple emails addresses to be entered within the field, when allowed. Separate each email address with a comma or a semicolon.

 

NOTE: The key email address field of an order are those found within the OrderEmailAddress table. This table is populated with multiple email addresses for each type defined within Shipper Email Type Setup. There can only be one email address of each type per order. View the Multiple Email Addresses Grid section within the Name, Address, Phone or Contacts and Locations topics for information on setting these emails.

 

NOTE: The Orders.Email address is a legacy address that is referenced by some processes. Eventually, it will become obsolete, however, it currently stores the highest ranked phone number on the order (as set through the Name, Address, Phone or Contacts and Locations tab).

 

 

Table

Column

Field Type

Length

Location Topic

AccountProfileContacts

Email

varchar

120

Account Profile Setup, Add/Edit Order Contact

AgentContact

Email

varchar

120

Add Agent Contact

BranchAddress

Email

varchar

120

Add Branch Address

ClaimEmailAddress

EmailAddress

EmailAddress

50

Claim Detail

CreditWarningSetting

CustomEmailAddresses

varchar

256

Credit Warning Lockdown Setup

CustomerStatement

EmailAddress

varchar

201

Customer Information

EmailOptions

OtherEmail

varchar

50

Email Options Setup

InternationalBOLConsignee

Email

varchar

120

Bill of Lading Consignee

InternationalBookingNumber

TransitEmail

varchar

50

Pickup/Delivery Information

InternationalBookingNumberAddress

Email

varchar

50

Pickup/Delivery Information

InternationalCarrier

EMail

varchar

128

Carrier Information, Carrier Setup (International Orders)

InternationalConsolidator

EMail

varchar

128

Consolidator Information, Consolidator Setup

InternationalCustomsAgent

EMail

varchar

128

Customs Agent Information, Customs Agent Setup

InternationalLinehaulCarrier

EMail

varchar

128

Linehaul Carrier Information, Linehaul Carrier Setup

MilitaryBase

EMail

varchar

128

Base Information, Base Setup

MilitaryBaseContact

Email

varchar

120

Add Base Contact, Base Information

MilitaryCarrier

EMail

varchar

128

Carrier Information, Carrier Setup (Military/Government)

MilitaryCarrierContact

Email

varchar

120

Add Contact

MobileSetup

MSCrewFromEmailAddress

varchar

50

Mobile Api Setup

MoversConnectEmailRecipient

RecipientEmail

varchar

100

MoversConnect Setup, Add MoversConnect Email Recipient

OrderContacts

Email

varchar

120

Add/Edit Order Contact

OrderEmailAddress

EmailAddress

nvarchar

120

Name, Address, Phone , Contacts and Locations

Orders

Email

nvarchar

120

Name, Address, Phone, Contacts and Locations

PlasticWebDeal

EmailAddress

varchar

255

Setup Credit Card/Bank Online Payment

PlasticWebDeal

NotificationEmailAddress

varchar

255

Electronic Payment Success, Electronic Refund Success, Electronic Void Success, Electronic Payment Failure

Storage

EmailAddresses

varchar

255

Payment Setup

Sysuser

EMAIL

varchar

50

Personnel Setup

VanlineAddress

Email

varchar

120

Van Line Setup

VendorConnect

EmailAddresses

nvarchar

255

VendorConnect Setup