Skip to main content

Email & Communication - Key Tables

Full column listings for the 3 key tables in this category.

EMAILRULE (61 columns)

# Column Type Length Nullable Default
1 ERid int NO
2 ERType int YES ((0))
3 ERDesc nvarchar 4000 YES
4 ERPop3ServerID int YES ((0))
5 ERSubject nvarchar 4000 YES
6 ERBody nvarchar 4000 YES
7 ERFromAddr nvarchar 4000 YES
8 ERToAddr nvarchar 4000 YES
9 EREnabled bit NO ((0))
10 ERstarttag nvarchar 4000 YES
11 ERendtag nvarchar 4000 YES
12 ERfieldname nvarchar 4000 YES
13 ERlength int YES ((0))
14 ERUseendofline bit NO ((0))
15 ER2starttag nvarchar 4000 YES
16 ER2endtag nvarchar 4000 YES
17 ER2fieldname nvarchar 4000 YES
18 ER2length int YES ((0))
19 ER2Useendofline bit NO ((0))
20 ER3starttag nvarchar 4000 YES
21 ER3endtag nvarchar 4000 YES
22 ER3fieldname nvarchar 4000 YES
23 ER3length int YES ((0))
24 ER3Useendofline bit NO ((0))
25 ERCloseString nvarchar 4000 YES
26 errequesttype int YES ((-1))
27 ER4starttag nvarchar 4000 YES
28 ER4endtag nvarchar 4000 YES
29 ER4fieldname nvarchar 4000 YES
30 ER4length int YES ((0))
31 ER4Useendofline bit NO ((0))
32 ERSeq int YES ((0))
33 ERpagerduty bit YES ((0))
34 ERFromAddrExact bit YES ((0))
35 ERToAddrExact bit YES ((0))
36 ERPrivateActions bit YES ((0))
37 ERPagerdutyAgent int YES ((0))
38 ER5starttag nvarchar 200 YES ('')
39 ER5endtag nvarchar 200 YES ('')
40 ER5fieldname nvarchar 200 YES ('')
41 ER5length int YES ((0))
42 ER5Useendofline bit YES ((0))
43 ERSplunkOnCall bit YES ((0))
44 erattachmentname nvarchar 500 YES ('')
45 erattachmentmatchtype int YES ((0))
46 ermatchonattachment bit YES ((0))
47 er3useticketuser bit YES ((0))
48 ERmatchccandbcc bit YES ((0))
49 er6starttag nvarchar 200 YES
50 er6endtag nvarchar 200 YES
51 er6length int YES
52 er6useendofline bit YES
53 ERPagerDutyService nvarchar 500 YES
54 ERAlwaysCloseAlerts bit YES ((0))
55 ERClosedAlertsReadStatus int YES ((0))
56 erdontsendacknowledgement bit YES ((0))
57 erscanfullbody bit YES ((1))
58 ermsid int YES ((0))
59 erdontupdatefromaddress bit YES
60 erguid uniqueidentifier NO (newid())
61 ERmatchphonenumberwithtags bit YES

EMAILSTORE (31 columns)

# Column Type Length Nullable Default
1 ESID int NO
2 ESref int YES ((0))
3 ESemailSubject nvarchar 4000 YES
4 ESemailbody ntext 1073741823 YES
5 ESemailto ntext 1073741823 YES
6 ESemailcc ntext 1073741823 YES
7 ESdateemailed datetime YES
8 ESemailattachments ntext 1073741823 YES
9 ESMsgGroupID int YES ((0))
10 ESemailbodyrich varbinary -1 YES
11 ESFaultID int YES ((0))
12 ESTemplateID int YES ((0))
13 ESemailbcc ntext 1073741823 YES
14 ESKeymessage ntext 1073741823 YES
15 ESReplyAddress ntext 1073741823 YES
16 ESAddActionAfterSending bit NO ((0))
17 ESMailBoxID int YES ((0))
18 ESOrgID int YES ((0))
19 ESAreaID int YES ((0))
20 ESSiteID int YES ((0))
21 ESUser nvarchar 255 YES ('')
22 ESUid int YES ((0))
23 ESemailbodyhtml nvarchar -1 YES
24 ESReportTypeToSend int NO ((0))
25 esquotationid int YES ((0))
26 essalesorderid int YES ((0))
27 espurchaseorderid int YES ((0))
28 ESInvoiceID int YES ((0))
29 esdatecreated datetime YES ((0))
30 essalesmailboxoverrideid int YES
31 ESSubType int YES

MAILBOX (101 columns)

# Column Type Length Nullable Default
1 MBid int NO
2 MBserver nvarchar 4000 YES
3 MBusername nvarchar 4000 YES
4 MBpassword nvarchar 4000 YES
5 MBUseTLS bit NO ((0))
6 MBenabled bit NO ((0))
7 mborgid int YES ((1))
8 MBType int YES ((0))
9 MBExchangeMailBoxDisplayName nvarchar 4000 YES
10 MBExchangeMailBoxFQDN nvarchar 4000 YES
11 MBHardDeleteReadMessages bit NO ((0))
12 MBRequestType int YES ((0))
13 mbpopport int YES ((0))
14 MBsmtpserver nvarchar 4000 YES
15 MBsmtpaddress nvarchar 4000 YES
16 MBsmtpusername nvarchar 4000 YES
17 MBsmtppassword nvarchar 4000 YES
18 MBsmtpport int YES ((0))
19 MBSMTPUseTLS bit NO ((0))
20 MBMessageGroup int YES ((0))
21 MBSMTPdisplayname nvarchar 4000 YES
22 MBSyncAddressbook bit YES ((0))
23 MBDontSendAck bit YES ((0))
24 MBDefaultSite int YES ((0))
25 MBDefaultUser nvarchar 4000 YES ('')
26 MBchangeseq int YES ((0))
27 MBAccessToken nvarchar 4000 YES ('')
28 MBAccessTokenExpiryDate datetime YES ((0))
29 MBRefreshToken nvarchar 4000 YES ('')
30 MBRefreshTokenExpiryDate datetime YES ((0))
31 MBTokenDestructionDate datetime YES ((0))
32 MBTLSType int YES ((0))
33 MBDeletedItemsFolder nvarchar 200 YES ('')
34 MBEWSUsername nvarchar 255 YES ('')
35 mbname nvarchar 255 YES ('')
36 mbrestrictiontype int YES ((0))
37 mbdepartmentid int YES ((0))
38 mbteamid int YES ((0))
39 MBAzureSecret nvarchar 2000 YES ('')
40 MBAzureAppID nvarchar 2000 YES ('')
41 MBAzureEmail nvarchar 2000 YES ('')
42 MBAzureAuthCode nvarchar 2000 YES ('')
43 MBAzureAccessToken nvarchar -1 YES
44 MBAzureRefreshToken nvarchar -1 YES
45 MBAzureTenant nvarchar 2000 YES ('')
46 MBAzureState nvarchar 2000 YES ('')
47 MBazureredirecturi nvarchar 2000 YES ('')
48 MBMostRecentEmailDate datetime YES ((0))
49 MBIMAPLeaveMailInInbox bit YES ((0))
50 MBGoogleEmail nvarchar 200 YES ('')
51 MBGoogleAccessToken nvarchar -1 YES
52 MBGoogleRefreshToken nvarchar -1 YES
53 MBGoogleTokenExpiry datetime YES ((0))
54 MBGoogleRedirectUri nvarchar 200 YES ('')
55 MBAzureAuthorized bit YES ((0))
56 MBGoogleAuthorized bit YES ((0))
57 MBSharedMailboxEmailAddress nvarchar 2000 YES ('')
58 mbshowinfromaddress bit YES ((1))
59 mbgoogletype int YES
60 mbusesmtpforazuremailbox bit YES ((0))
61 MBAzureLeaveMailInInbox bit YES ((0))
62 MBAzureDatecutoff datetime YES ((0))
63 MBIncomingFolderName nvarchar 2000 YES ('')
64 mblasterrordate datetime YES ((0))
65 mblasterror nvarchar 1000 YES ('')
66 mblasterrorcode nvarchar 50 YES ('')
67 MBInboundMethod int YES ((0))
68 MBAzureSubscriptionId nvarchar 100 YES ('')
69 MBAzureSubscribed bit YES ((0))
70 MBAzureSubscriptionExpiry datetime YES ((0))
71 MBAzureSubscriptionSecret nvarchar 500 YES ('')
72 MBIgnoreCCEmails bit YES ((0))
73 MBAcceptAutoReplies bit YES ((1))
74 MBAllowEmailHashtags bit YES ((1))
75 MBSitePrefixMatching bit YES ((1))
76 MBSiteWildcardMatching bit YES ((1))
77 MBSiteDomainMatching bit YES ((1))
78 MBSiteToCcMatching bit YES ((1))
79 MBUnmatchedUsers int YES ((0))
80 MBNewUserDefaultSite int YES ((0))
81 MBNewUserSendWelcomeEmail bit YES ((0))
82 MBNewUserSendAck bit YES ((0))
83 MBHaloIntegratorLastSync datetime YES ((0))
84 MBHaloIntegratorLastError nvarchar 1000 YES ('')
85 MBAzureAuthority int YES ((0))
86 mberrorcounter int YES ((0))
87 MBSafeAttachmentPolicy int YES ((0))
88 MBSafeAttachmentPlaceholder nvarchar 250 YES
89 mbcreationdate datetime YES ((0))
90 mbdontimportbeforecreation bit YES ((0))
91 MBAzureAuthenticationType int YES ((0))
92 mbstopnewticketsviaemail bit YES
93 MBhalointegratoroutlook bit YES
94 MBhalointegratoroutlooklasterror nvarchar 4000 YES
95 MBhalointegratoroutlooklastsync datetime YES ((0))
96 mbstopnewticketsviaemailreplywithtemplate int YES ((0))
97 MBguid uniqueidentifier NO (newid())
98 mbdontprocesssentbysamemailbox bit YES
99 mbuseemailaddressfornewusers bit YES
100 mbsenderrestrictiontype int YES ((0))
101 mblabeltype nvarchar 200 YES ('TRASH')
Back to top