Skip to main content

Clients & Sites - Key Tables

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

AREA (332 columns)

# Column Type Length Nullable Default
1 Aarea int NO
2 aareadesc nvarchar 4000 YES
3 Amemo ntext 1073741823 YES
4 Aannounce ntext 1073741823 YES
5 Aannouncedate datetime YES
6 Apritech int YES ((0))
7 Asectech int YES ((0))
8 Aprinotify bit NO ((0))
9 Asecnotify bit NO ((0))
10 Apriassign bit NO ((0))
11 Asecassign bit NO ((0))
12 Aconfirmemail int YES ((0))
13 Aactionemail int YES ((0))
14 Aclearemail int YES ((0))
15 Apercballot int YES ((0))
16 Achargeperiod int YES ((0))
17 Achargehours float YES ((0))
18 Achargecarryover float YES ((0))
19 Ainvoiceyes bit NO ((0))
20 Atreeid int YES ((0))
21 Afluserdef1 nvarchar 4000 YES
22 Afluserdef2 nvarchar 4000 YES
23 Afluserdef3 nvarchar 4000 YES
24 Afluserdef4 nvarchar 4000 YES
25 Afluserdef5 nvarchar 4000 YES
26 Afloverride bit NO ((0))
27 Afluserdef1hide bit NO ((0))
28 Afluserdef2hide bit NO ((0))
29 Afluserdef3hide bit NO ((0))
30 Afluserdef4hide bit NO ((0))
31 Afluserdef5hide bit NO ((0))
32 Afluserdef1mand bit NO ((0))
33 Afluserdef2mand bit NO ((0))
34 Afluserdef3mand bit NO ((0))
35 Afluserdef4mand bit NO ((0))
36 Afluserdef5mand bit NO ((0))
37 Aincludeactions bit NO ((0))
38 Aneedsinvoice bit NO ((0))
39 Astartdate datetime YES
40 Astartbalance money YES ((0))
41 AHourlyRate money YES ((0))
42 APeriodCharge money YES ((0))
43 Adontinvoice bit NO ((0))
44 Ainvoicetemplate nvarchar 4000 YES
45 Ainvoicecomment nvarchar 4000 YES
46 ALastInvoiceEndDate datetime YES
47 ashowslaonweb bit NO ((0))
48 ASLAtaxcode int YES ((0))
49 ANONSLAtaxcode int YES ((0))
50 aaccountsid nvarchar 4000 YES
51 Aimageindex int YES ((3))
52 Achargehours2 float YES ((0))
53 Ahourlyrate2 float YES ((0))
54 Acat2 ntext 1073741823 YES
55 Acat3 ntext 1073741823 YES
56 Acat4 ntext 1073741823 YES
57 Acat5 ntext 1073741823 YES
58 Aenddate datetime YES
59 AMessageGroup int YES ((-1))
60 AFromAddress nvarchar 4000 YES
61 AUCemail int YES ((0))
62 AFCemail int YES ((0))
63 Astopped int YES ((0))
64 AActGuid nvarchar 4000 YES
65 ASMSbalance int YES ((0))
66 ahtml ntext 1073741823 YES
67 AHV float YES ((0))
68 AHVDate datetime YES
69 AEMailInvoice bit NO ((-1))
70 aseriousnesslevel int YES ((-1))
71 Achangeseq int YES ((1))
72 ADefCat2 nvarchar 4000 YES
73 ADefCat3 nvarchar 4000 YES
74 ADefCat4 nvarchar 4000 YES
75 ADefCat5 nvarchar 4000 YES
76 AAccountManagerTech int YES ((0))
77 AThresholdBreached int YES ((0))
78 AIsInactive bit NO ((0))
79 amonthlyreportinclude bit NO ((0))
80 Amonthlyreportlastrun datetime YES
81 amonthlyreportemaildirect bit NO ((0))
82 amonthlyreportemailmanager bit NO ((0))
83 amonthlyreportshowonweb bit NO ((0))
84 ATechNote ntext 1073741823 YES
85 Aarearef nvarchar 4000 YES
86 Aareatype int YES ((0))
87 asignature varbinary -1 YES
88 AUnmatchedCombinations int YES ((0))
89 APrepayRecurringChargeNextDate datetime YES
90 ABillForRecurringPrePayAmount bit NO ((0))
91 APrepayRecurringCharge float YES ((0))
92 APrepayRecurringHours float YES ((0))
93 APrepayRecurringChargeBP int YES ((0))
94 AGFIclientid nvarchar 4000 YES ('0')
95 AAccountsEmailAddress nvarchar 4000 YES
96 ADisclaimerMatchString nvarchar 4000 YES
97 APaymentTerms int YES ((0))
98 AShowAllNonBillable bit YES ((0))
99 ABillingGroup int YES ((0))
100 AAutoTopUpThreshhold float YES ((0.00))
101 AAutoTopUpToAmount float YES ((0.00))
102 AAutoTopUpCostPerHour float YES ((0.00))
103 AAutoTopUpByAmount float YES ((0.00))
104 ASurchargeID int YES ((0))
105 AContractTemplateID int YES ((0))
106 Aphoto varbinary -1 YES
107 AOverideGreeting nvarchar 4000 YES ('')
108 AClientPackage int YES ((-1))
109 AScopeOfBusiness int YES ((-1))
110 APrefferedAgent int YES ((0))
111 ACallHandlingNotes nvarchar 4000 YES ('')
112 ATeamviewerPassword nvarchar 4000 YES ('')
113 acustomertype int YES ((0))
114 ACallDate datetime YES
115 aDiscountPerc float YES ((0.00))
116 AShowFAQForTopLevel bit YES ((0))
117 AAccountsCCEmailAddress nvarchar 4000 YES ('')
118 AIsOpportunity int YES ((0))
119 ASnowName nvarchar 500 YES ('')
120 AisVIP bit YES ((0))
121 APrepayAccountsDesc nvarchar 400 YES ('')
122 AContractAccountsDesc nvarchar 400 YES ('')
123 AContractTaxCode int NO ((0))
124 AKaseyaID nvarchar 100 YES ('')
125 acolour nvarchar 10 YES ('')
126 asignaturehtml nvarchar -1 YES
127 aallowallcat2 bit YES ((1))
128 aallowallcat3 bit YES ((1))
129 aallowallcat4 bit YES ((1))
130 aallowallcat5 bit YES ((1))
131 aorgid int YES ((0))
132 aallorgsallowed bit YES ((1))
133 adatecreated datetime YES ((0))
134 acreatedfromid int YES ((0))
135 AShowAllUserDashboardButtons bit YES ((1))
136 AUserPortalURL nvarchar 200 YES ('')
137 ARecurringDelayInvoiceUnit int NO ((0))
138 ARecurringDelayInvoiceType int NO ((0))
139 ALogoBase64 nvarchar -1 YES
140 Aorganisationlogooverride bit YES ((0))
141 Aoverrideorganisationname nvarchar 100 YES ('')
142 Aoverrideorganisationaddress nvarchar 1000 YES ('')
143 Aoverrideorganisationphone nvarchar 50 YES ('')
144 Aoverrideorganisationemail nvarchar 255 YES ('')
145 Aoverrideorganisationwebsite nvarchar 500 YES ('')
146 Aoverrideorganisationportalurl nvarchar 500 YES ('')
147 AMailboxID int YES ((-1))
148 adefaultmailboxid int YES ((0))
149 alocked bit YES ((0))
150 acautomateid int YES ((0))
151 AThirdPartyNHDPref int YES ((0))
152 AThirdPartyNHDApiUrl nvarchar 255 YES ('')
153 AThirdPartyNHDAuthUrl nvarchar 255 YES ('')
154 AThirdPartyNHDTenant nvarchar 50 YES ('')
155 AThirdPartyNHDApiClientId nvarchar 100 YES ('')
156 AThirdPartyNHDApiClientSecret nvarchar 1000 YES ('')
157 aExcludeFromInvoiceSync bit YES ((0))
158 APortalLogoBase64 nvarchar -1 YES
159 ANinjaRMMId int YES ((0))
160 aAzureDomain nvarchar 500 YES ('')
161 aCurrency int NO ((0))
162 aprepayrecurringminimumdeduction float YES ((0.00))
163 aprepayrecurringminimumdeductiononlyactive bit YES ((0))
164 AIsXeroArchived bit YES ((0))
165 AXeroID nvarchar 200 YES ('')
166 AAccountsFirstName nvarchar 250 YES
167 AAccountsLastName nvarchar 250 YES
168 APurchasesTaxCode int YES ((0))
169 aprepayrecurringautomaticdeduction float YES ((0.00))
170 APreferredDeliveryMethod int YES ((0))
171 AQBODefaultTax int YES ((0))
172 ATaxable bit YES ((0))
173 aallowallchargerates bit YES ((1))
174 AXeroTenantId nvarchar 100 YES ('')
175 AportalBackgroundImageURL nvarchar 500 YES ('')
176 AServiceNowId nvarchar 100 YES ('')
177 ADevice42Id int YES ((0))
178 AQBODefaultTaxCode int YES ((0))
179 AQBODefaultTaxCodeName nvarchar 100 YES ('')
180 AportalColour nvarchar 7 YES ('')
181 AConnectWiseId int YES ((0))
182 ADattoId nvarchar 100 YES ('')
183 ADattoAlternateId int YES ((0))
184 ADattoUrl nvarchar 100 YES ('')
185 AAzureTenantId nvarchar 100 YES ('')
186 AAzurePartnerRelationship nvarchar 100 YES ('')
187 AAzureAccessToken nvarchar -1 YES ('')
188 AAzureTokenExpiry datetime YES ((0))
189 AAutotaskId int YES ((-1))
190 AOverridePdfTemplateInvoice int YES ((-1))
191 AAteraId int YES ((0))
192 AKashflowId int YES ((0))
193 AKashflowTenantId int YES ((0))
194 AWebsite nvarchar 250 YES ('')
195 Aclienttoinvoiceid int YES ((0))
196 ALastUpdate datetime YES ((0))
197 AInvoiceDueDaysExtra int YES ((0))
198 aprepaytaxcode int YES ((0))
199 AITGlueId nvarchar 100 YES ('')
200 ASnelStartId nvarchar 100 YES ('')
201 acurrencyoverride nvarchar 10 YES ('')
202 AdefaultCurrencyCode int YES ((0))
203 aclienttoinvoicerecurringid int YES ((0))
204 asentinelsubscriptionid nvarchar 500 YES ('')
205 asentinelworkspacename nvarchar 500 YES ('')
206 asentinelresourcegroupname nvarchar 500 YES ('')
207 ASyncroId int YES ((0))
208 adattocommerceid int YES ((-1))
209 adattocommerceurl nvarchar 250 YES
210 ASentinelTenantId int YES
211 asnowid int YES ((0))
212 AAuvikId nvarchar 100 YES ('')
213 apassportalid bigint YES
214 AHubSpotId nvarchar 100 YES
215 AHubSpotUrl nvarchar 1000 YES
216 AHubSpotDontSync bit YES ((0))
217 AHubSpotArchived bit YES ((0))
218 ADomain nvarchar 250 YES
219 aprepayasamount bit YES
220 AQBOCompanyId nvarchar 100 YES
221 axerotaxnumber nvarchar 4000 YES
222 asyncedtointacct bit YES
223 aprepayrecurringexpirymonths int YES
224 ahubspotlifecycle nvarchar 4000 YES
225 aaccountsbccemailaddress nvarchar -1 YES ('')
226 adefaultcontractoverride int YES
227 aliongardid int YES
228 aregmanagertech int YES
229 alogmanagertech int YES
230 asalesreptech int YES
231 aaccountownertech int YES
232 acxmleadtech int YES
233 APortalChatProfile nvarchar 50 YES ('')
234 atradingname nvarchar 4000 YES
235 ADBCCompanyId nvarchar 100 YES ('')
236 asalesforcedontsync bit YES
237 astripepaymentmethodid nvarchar 100 YES
238 astripepaymentmethodname nvarchar 150 YES
239 aservicenowurl nvarchar 255 YES ('')
240 aservicenowlocale nvarchar 50 YES ('')
241 aservicenowusername nvarchar 255 YES ('')
242 aservicenowkey nvarchar 1000 YES ('')
243 aservicenowvalidated bit YES
244 aservicenowassignmentgroup nvarchar 100 YES
245 aservicenowassignmentgroupname nvarchar 255 YES
246 aservicenowdefaultuserid nvarchar 100 YES
247 aservicenowdefaultusername nvarchar 255 YES
248 asagebusinessclouddetailsid int YES
249 acurrencyisocode nvarchar 10 YES
250 aexactdivision int YES
251 ancdid int YES
252 aoverridesentineldefaultuser int YES ((0))
253 ajiraurl nvarchar 255 YES ('')
254 ajirausername nvarchar 255 YES ('')
255 ajirakey nvarchar 1000 YES ('')
256 ajiravalidated bit YES
257 ajiraservicedeskid nvarchar 100 YES
258 ajiraservicedeskname nvarchar 255 YES
259 ajirasmuserid nvarchar 100 YES
260 ajirasmusername nvarchar 255 YES
261 aticketinvoicesforeachsite bit YES ((0))
262 aintacctloctype nvarchar 100 YES
263 aintacctlocids nvarchar 1000 YES
264 aintacctsaveloc nvarchar 1000 YES
265 aintacctinvoicesaveloc nvarchar 50 YES
266 aingrammicrodetailsid int YES
267 adefaultpdftemplateinvoicetickets int YES
268 adefaultpdftemplateinvoiceorders int YES
269 adefaultpdftemplateinvoicerecurring int YES
270 adontautosendinvoices bit YES ((0))
271 ainvoiceclass nvarchar 250 YES
272 adattocommercetenantid int YES
273 adefsectiontosalesrepoverride bit YES ((0))
274 aiconatguid nvarchar 50 YES ('')
275 abillingplantext nvarchar 4000 YES
276 aservicenowenablewebhook bit YES
277 aservicenowwebhooksecret nvarchar 4000 YES
278 aservicenowwebhookuser int YES
279 aservicenowwebhooktickettype int YES
280 amyobrowversion nvarchar 500 YES
281 asyncservicenowattachments int YES ((0))
282 ATwilioSubAccountName nvarchar 4000 YES
283 ATwilioSubAccountSID nvarchar 250 YES
284 ATwilioSubAccountAuthToken nvarchar 250 YES
285 ATwilioSubAccountCreated bit YES
286 ATwilioSubAccountStatus nvarchar 250 YES
287 aoverridepdftemplatequote int YES ((-1))
288 aoverridelayoutid int YES ((-1))
289 aservicenowticketsync nvarchar 255 YES
290 ajirawebhookuser int YES
291 aduedatetype int YES
292 acustomerrelationshiplist nvarchar 4000 YES
293 aautomaticcallscriptid int YES ((-1))
294 CFDtcClientGuid nvarchar 255 YES
295 ainvoiceticketsseperatelyoverride bit YES
296 ainvoicemailboxoverride int YES ((0))
297 aquotemailboxoverride int YES ((0))
298 Aisaccount bit YES ((0))
299 CFRemoteAccessAppAuthorizatoins nvarchar 1000 YES
300 aservicenowauthtype int YES
301 aservicenowaccesstoken int YES
302 aservicenowtokenexpiry datetime YES ((0))
303 aportaltitleoverride bit YES
304 aportaltitle nvarchar 4000 YES
305 areplyaddress nvarchar 100 YES
306 aautoredirectfailedlogin bit YES
307 alastaiprofileevaluation datetime YES ((0))
308 aexcludefromaiclientprofiling bit YES
309 Adynamicscrmdetailsid int YES
310 athirdpartynhdvalidated bit YES ((0))
311 athirdpartynhdstatus int YES
312 athirdpartynhdcategory int YES
313 athirdpartynhdtickettype int YES
314 athirdpartynhdoutcome int YES
315 athirdpartynhdattachments int YES
316 CFclientVeeamS3BucketName nvarchar 255 YES
317 aapiversion nvarchar 20 YES
318 AJiraAllowWebhooks bit YES
319 AJiraWebhookAuthentication int YES ((0))
320 AJiraWebhookSecret int YES
321 aexcludefromaifunc bit YES
322 apax8monthlyinvoice int YES
323 apax8annualinvoice int YES
324 aservicenowsyncchild bit YES
325 adbctemplate nvarchar 1000 YES
326 ajirastatusafterupdate int YES ((-1))
327 aquickbookstaxexemptionreasonid int YES ((0))
328 AQBOLastUpdated datetime YES ((0))
329 agficlientname nvarchar 200 YES
330 asendautomatedinvoiceremindersafterdays int YES ((0))
331 aexcludefromautomatedinvoicereminders bit YES ((0))
332 adontcreatepax8invoicelines bit YES

COMPANY (109 columns)

# Column Type Length Nullable Default
1 Cnum int NO
2 cdesc nvarchar 4000 YES
3 cphone1 nvarchar 4000 YES
4 cphone2 nvarchar 4000 YES
5 cphone3 nvarchar 4000 YES
6 Cmemo ntext 1073741823 YES
7 Caddress ntext 1073741823 YES
8 Cslaid int YES
9 ccontractcode nvarchar 4000 YES
10 ccontractdesc nvarchar 4000 YES
11 Cemailaddress nvarchar 4000 YES
12 CIsInactive bit NO ((0))
13 CswitchSLAtoSupplier bit NO ((0))
14 CEmailOverdueFixBy bit NO ((0))
15 CEmailOverdueResponse bit NO ((0))
16 CWebServiceURL nvarchar 4000 YES
17 cemailtemplateid int YES ((0))
18 CSageAccountsID nvarchar 4000 YES
19 cwebsite nvarchar 4000 YES
20 cportalURL nvarchar 4000 YES
21 cportalref nvarchar 4000 YES
22 cportalusername nvarchar 4000 YES
23 cportalpassword nvarchar 4000 YES
24 CTree int YES ((-1))
25 CContactName nvarchar 400 YES ('')
26 CContactPosition nvarchar 400 YES ('')
27 CFax nvarchar 400 YES ('')
28 CMobile nvarchar 400 YES ('')
29 CStartTag nvarchar 400 YES ('')
30 CEndTag nvarchar 400 YES ('')
31 Cchangeseq int YES ((0))
32 CUsesNHD bit YES ((0))
33 CNHDURL nvarchar 200 YES ('')
34 CNHDEmailAddress nvarchar 200 YES ('')
35 CNHDPassword nvarchar 200 YES ('')
36 CParentID int NO ((-1))
37 clogo nvarchar -1 YES
38 cdatecreated datetime YES ((0))
39 cEmailDomain nvarchar 255 YES ('')
40 CThirdPartyNHDPref int YES ((0))
41 CThirdPartyNHDApiUrl nvarchar 255 YES ('')
42 CThirdPartyNHDAuthUrl nvarchar 255 YES ('')
43 CThirdPartyNHDTenant nvarchar 50 YES ('')
44 CThirdPartyNHDApiClientId nvarchar 100 YES ('')
45 CThirdPartyNHDApiClientSecret nvarchar 1000 YES ('')
46 CKashflowId int YES ((0))
47 CKashflowTenantId int YES ((0))
48 CXeroTenantId nvarchar 100 YES ('')
49 CXeroId nvarchar 100 YES ('')
50 CIsXeroArchived bit YES ((0))
51 CQBOCompanyId nvarchar 100 YES
52 cjiraurl nvarchar 255 YES ('')
53 cjirausername nvarchar 255 YES ('')
54 cjirakey nvarchar 1000 YES ('')
55 cjiravalidated bit YES
56 cjiraservicedeskid nvarchar 100 YES
57 cjiraservicedeskname nvarchar 255 YES
58 cjirasmuserid nvarchar 100 YES
59 cjirasmusername nvarchar 255 YES
60 csyncedtointacct bit YES
61 cintacctlocids nvarchar 1000 YES
62 cintacctloctype nvarchar 100 YES
63 cintacctsaveloc nvarchar 1000 YES
64 cdefaultcurrencycode int YES
65 cignorefromaccountingsync bit YES
66 cintacctdefaultsaveloc nvarchar 500 YES
67 csupportemailaddress nvarchar 500 YES
68 cmailboxoverride int YES ((-1))
69 ciconatguid nvarchar 50 YES ('')
70 cservicenowurl nvarchar 255 YES ('')
71 cservicenowlocale nvarchar 50 YES ('')
72 cservicenowusername nvarchar 255 YES ('')
73 cservicenowkey nvarchar 1000 YES ('')
74 cservicenowvalidated bit YES
75 cservicenowassignmentgroup nvarchar 100 YES
76 cservicenowassignmentgroupname nvarchar 255 YES
77 cservicenowdefaultuserid nvarchar 100 YES
78 cservicenowdefaultusername nvarchar 255 YES
79 cmessagegroupid int YES ((-1))
80 cmyobrowversion nvarchar 500 YES
81 cpurchasetaxcode int YES
82 csyncservicenowattachments int YES ((0))
83 clast_modified datetime YES ((0))
84 cservicenowticketsync nvarchar 255 YES
85 cjirawebhookuser int YES
86 csupplierinvoiceduedateextradays int YES ((0))
87 cissupplier bit YES ((1))
88 cismanufacturer bit YES ((1))
89 cservicenowauthtype int YES
90 cservicenowaccesstoken int YES
91 cservicenowtokenexpiry datetime YES ((0))
92 corderingemailaddress nvarchar 500 YES
93 cthirdpartynhdvalidated bit YES ((0))
94 cthirdpartynhdstatus int YES
95 cthirdpartynhdcategory int YES
96 cthirdpartynhdtickettype int YES
97 cthirdpartynhdoutcome int YES
98 cthirdpartynhdattachments int YES
99 crunbookid nvarchar 255 YES
100 capiversion nvarchar 20 YES
101 CJiraAllowWebhooks bit YES
102 CJiraWebhookAuthentication int YES ((0))
103 CJiraWebhookSecret int YES
104 cservicenowsyncchild bit YES
105 cdbctemplate nvarchar 1000 YES
106 cdbccompanyid nvarchar 1000 YES
107 cjirastatusafterupdate int YES ((-1))
108 cservicenowenablewebhook bit YES
109 cservicenowwebhooksecret int YES

ORGANISATION (36 columns)

# Column Type Length Nullable Default
1 ORid int NO
2 ORname nvarchar 4000 YES
3 ORreplyaddr nvarchar 4000 YES
4 ORMessageGroup int YES ((0))
5 ORAddress ntext 1073741823 YES
6 ORPhone nvarchar 4000 YES
7 ORFax nvarchar 4000 YES
8 OREmail nvarchar 4000 YES
9 ORWebsite nvarchar 4000 YES
10 ORLogoBlob varbinary -1 YES
11 ORLogoFilename nvarchar 4000 YES
12 ORDeliverySite int YES ((0))
13 ORPortalURL nvarchar 100 YES ('')
14 Ochangeseq int YES ((0))
15 ORLogoBase64 nvarchar -1 YES
16 ORportalcolour nvarchar 10 YES ('')
17 ORPortalFolderLocation nvarchar 200 YES
18 ORPortalLogoBase64 nvarchar -1 YES
19 ORportalBackgroundImageURL nvarchar 500 YES ('')
20 ORBankDetails1 nvarchar 200 YES
21 ORBankDetails2 nvarchar 200 YES
22 ORBankDetails3 nvarchar 200 YES
23 ORBankDetails4 nvarchar 200 YES
24 ORBankDetails5 nvarchar 200 YES
25 ORTaxNumber nvarchar 200 YES
26 ORGUID uniqueidentifier YES (newid())
27 oriconatguid nvarchar 50 YES ('')
28 orportaltitle nvarchar 4000 YES
29 oalluserfaqlistsallowed bit YES ((1))
30 oportalchatprofileoverride nvarchar 100 YES
31 ORforthoughtwidgetoverride int YES
32 ORportalFaviconATguid nvarchar 40 YES
33 ORportalAllowPWA bit YES
34 ORportalManifestIconATguid nvarchar 40 YES
35 ORportalManifestShortName nvarchar 100 YES
36 ORportalManifestDescription nvarchar 1000 YES

SERVSITE (117 columns)

# Column Type Length Nullable Default
1 starea int NO
2 stsitenum int NO
3 stid int NO
4 stoverride int YES
5 stcheckmon bit NO ((0))
6 stchecktue bit NO ((0))
7 stcheckwed bit NO ((0))
8 stcheckthu bit NO ((0))
9 stcheckfri bit NO ((0))
10 stchecksat bit NO ((0))
11 stchecksun bit NO ((0))
12 stcheckminutes int YES
13 stdesc nvarchar 4000 YES
14 stservicekind int YES ((0))
15 stdetails nvarchar 4000 YES
16 stparam1 nvarchar 4000 YES
17 stparam2 nvarchar 4000 YES
18 stparam3 nvarchar 4000 YES
19 stmin int YES ((0))
20 stmax int YES ((0))
21 STnotes ntext 1073741823 YES
22 STPop3ServerID int YES ((0))
23 stsubject nvarchar 4000 YES
24 stbody nvarchar 4000 YES
25 stfromaddr nvarchar 4000 YES
26 sttoaddr nvarchar 4000 YES
27 STEnabled bit NO ((0))
28 stoksubject nvarchar 4000 YES
29 stokbody nvarchar 4000 YES
30 stokfromaddr nvarchar 4000 YES
31 stoktoaddr nvarchar 4000 YES
32 STOKAny bit NO ((0))
33 stfailsubject nvarchar 4000 YES
34 stfailbody nvarchar 4000 YES
35 stfailfromaddr nvarchar 4000 YES
36 stfailtoaddr nvarchar 4000 YES
37 STFailAny bit NO ((0))
38 STFailCreateRequest bit NO ((0))
39 STShowInUserCatalog bit NO ((-1))
40 STTrackStatus bit NO ((-1))
41 STwdid int YES ((0))
42 STcat2 ntext 1073741823 YES
43 STWorkdays int YES ((0))
44 STsvcid int YES ((0))
45 STphotopath nvarchar 1000 YES ('')
46 STallowIncidients bit YES ((1))
47 STallowOptIn bit YES ((1))
48 STsummary ntext 1073741823 YES
49 STservicertid int YES ((0))
50 STserviceshownewreqscreen bit YES ((0))
51 STservicetemplateid int YES ((0))
52 STincidentrtid int YES ((0))
53 STincidenttemplateid int YES ((0))
54 STautoemail bit YES ((0))
55 STCost float YES ((0.00))
56 STEstimatedDelivery int YES ((0))
57 STservicedetailsBLOB varbinary -1 YES
58 STservicedetailsHTML ntext 1073741823 YES
59 STsubscribercount int YES ((0))
60 STsubscribable bit YES ((0))
61 STalsosubscribe int YES ((1))
62 STallowUnsubscribe bit YES ((0))
63 STallowServiceRequests bit YES ((0))
64 stuserlevel int YES ((-1))
65 stshowonmyservicespage bit YES ((1))
66 sttypenum int YES ((0))
67 stservicerequestlbl nvarchar 255 YES ('Request this Service')
68 stincidentlbl nvarchar 255 YES ('Log an Incident')
69 STfailalwaysnewrequest bit YES ((0))
70 STSeq int NO ((100))
71 STShowInTechCatalog bit YES ((0))
72 stallowallcat2 bit YES ((1))
73 stallowallcat3 bit YES ((1))
74 stallowallcat4 bit YES ((1))
75 stallowallcat5 bit YES ((1))
76 stimagebase64 nvarchar -1 YES
77 stservicerequesthint nvarchar 4000 YES ('')
78 stincidenthint nvarchar 4000 YES ('')
79 sbusiness_owner_id int YES ((0))
80 stechnical_owner_id int YES ((0))
81 stcreateonunsubscribe bit YES ((0))
82 stunsubscribeticketortemplate int YES ((0))
83 stunsubscribertid int YES ((0))
84 stunsubscribetemplateid int YES ((0))
85 stunsubscribeall bit YES ((0))
86 stunsubscribefield int YES ((0))
87 STallowFollowFault bit YES ((0))
88 sbusiness_owner_cab_id int YES ((0))
89 stechnical_owner_cab_id int YES ((0))
90 stshowinrelatedservices bit YES ((1))
91 STGUID uniqueidentifier YES (newid())
92 scompliance_owner_id int YES ((0))
93 scompliance_owner_cab_id int YES ((0))
94 STRelatedWorkdayId int YES ((0))
95 STiconATGuid nvarchar 50 YES ('')
96 sttypenums nvarchar 4000 YES
97 stserviceurl nvarchar 4000 YES
98 stincidenturl nvarchar 4000 YES
99 ststatushistoryportal bit YES ((0))
100 stscreenafterlogging int YES ((0))
101 stsequence int YES ((10))
102 stsendemailtype int YES
103 stincidentonly bit YES ((0))
104 stpricingrange float YES ((0))
105 stcriticality int YES ((0))
106 STsearchIndexSyncTimestamp datetime YES ((0))
107 STsearchIndexSyncBatches int YES
108 STsearchIndexSyncError nvarchar 100 YES
109 stpreviewwhenlogging int YES ((0))
110 sttrackavailability bit YES ((0))
111 sttrackingperiod int YES
112 sttrackingtarget float YES
113 stdelayavilabilitycalc int YES
114 stdeviceid int YES
115 stowningservice int YES
116 stshowinfavourites int YES ((0))
117 stdisplayname nvarchar 4000 YES

SITE (121 columns)

# Column Type Length Nullable Default
1 Ssitenum int NO
2 sdesc nvarchar 4000 YES
3 Stext float YES
4 Sglobx float YES
5 Sgloby float YES
6 Sstyle float YES
7 Sarea float YES
8 Sinuseby smallint YES
9 Smemo ntext 1073741823 YES
10 Supwho float YES
11 Suptimestamp datetime YES
12 Sxrefsite float YES
13 Szoffsetx smallint YES
14 Szoffsety smallint YES
15 Szoomx float YES
16 Szoomy float YES
17 Ssmallx smallint YES
18 Ssmally smallint YES
19 Sbigx smallint YES
20 Sbigy smallint YES
21 Sslaid int YES
22 ldapstring nvarchar 4000 YES
23 SiteEmailDomain nvarchar 4000 YES
24 sdeliverby int YES
25 SIsInvoiceSite bit NO ((0))
26 SRefNumber int YES ((0))
27 DefaultDelivery bit NO ((0))
28 sseriousnesslevel int YES ((-1))
29 Sgeocoord1 float YES ((0))
30 Sgeocoord2 float YES ((0))
31 Schangeseq int YES ((1))
32 SToDomain nvarchar 4000 YES
33 SdefaultStockLocation int YES ((0))
34 sstopped int YES ((0))
35 smemoblob varbinary -1 YES
36 SGFISiteID int YES ((0))
37 SIsInactive bit NO ((0))
38 SiteTimeOffset int YES ((0))
39 SiteDateFormat int YES ((0))
40 StimezoneName nvarchar 4000 YES
41 SDisclaimerMatchString nvarchar 4000 YES
42 SRef nvarchar 4000 YES
43 SRegionalDirector int YES ((0))
44 SFacilitiesManager int YES ((0))
45 sActGuid nvarchar 4000 YES ('')
46 STeamviewerPassword nvarchar 4000 YES ('')
47 SContractLastChecked datetime YES
48 sMainContact int YES ((-2))
49 SWRef nvarchar 4000 YES ('')
50 smonthlyreportlastrun datetime YES ((0))
51 smonthlyreportinclude bit YES ((0))
52 smonthlyreportemailmanager bit YES ((0))
53 saccountmanagertech bit YES ((0))
54 smonthlyreportemaildirect bit YES ((0))
55 slanguageid int YES ((0))
56 SSnowName nvarchar 500 YES ('')
57 SPhoneNumber nvarchar 50 YES ('')
58 SAnnounce nvarchar 4000 YES ('')
59 SAnnounceDate datetime YES ((0))
60 SInvoiceAddressIsDeliveryAddress bit YES ((0))
61 sorgid int YES ((0))
62 stimezonenamenew nvarchar 100 YES ('')
63 STechNote nvarchar 400 YES ('')
64 sdatecreated datetime YES ((0))
65 sShowAllUserDashboardButtons bit YES ((1))
66 SNewUserWebKey nvarchar 1000 YES ('')
67 SUserPortalEnrollmentKey nvarchar 500 YES ('')
68 SGUID nvarchar 255 YES ('')
69 slocked bit YES ((0))
70 scautomateid int YES ((0))
71 SNinjaRMMId int YES ((0))
72 SisStockLocation bit YES ((0))
73 SServiceNowId nvarchar 100 YES ('')
74 SDevice42Id int YES ((0))
75 SConnectWiseId int YES ((0))
76 SDattoId nvarchar 100 YES ('')
77 SDattoAlternateId int YES ((0))
78 SDattoUrl nvarchar 100 YES ('')
79 SAzureTenantId nvarchar 100 YES ('')
80 SAutotaskId int YES ((-1))
81 SMessageGroup int YES ((-1))
82 SPagerdutyWildcard nvarchar 500 YES ('')
83 SAteraId int YES ((0))
84 SLastUpdate datetime YES ((0))
85 SITGlueId nvarchar 100 YES ('')
86 sslataxcode int YES ((-3))
87 snonslataxcode int YES ((-3))
88 sprepaytaxcode int YES ((-3))
89 scontracttaxcode int YES ((-3))
90 spurchasestaxcode int YES ((-3))
91 SSyncroId int YES ((0))
92 SAuvikId nvarchar 100 YES ('')
93 sallfaqlistsallowed bit YES
94 spassportalid bigint YES
95 SHubSpotId nvarchar 100 YES
96 sliongardid int YES
97 skaseyaid nvarchar -1 YES
98 ssurchargeid int YES
99 SCountryCode nvarchar 10 YES ('')
100 saccountsid nvarchar 500 YES ('')
101 saccountsfirstname nvarchar 500 YES ('')
102 saccountslastname nvarchar 500 YES ('')
103 saccountsemailaddress nvarchar 500 YES ('')
104 saccountsccemailaddress nvarchar 500 YES ('')
105 saccountsbccemailaddress nvarchar 500 YES ('')
106 SRegionCode int YES ((0))
107 sncdid int YES
108 ssqlref nvarchar 4000 YES
109 slapsafedefaultinstallation nvarchar 50 YES
110 slapsafedefaultinstallationname nvarchar 255 YES
111 CFDtcSiteGuid nvarchar 255 YES
112 sphonenumberint bigint YES
113 sstocklocationseq int YES
114 sauthrocketlocale nvarchar 50 YES
115 staxable int YES ((0))
116 sdefaultcurrencycode int YES ((0))
117 sclienttoinvoiceid int YES ((0))
118 sclienttoinvoicerecurringid int YES ((0))
119 saddressindexattempted bit YES
120 semailstarttag nvarchar 50 YES
121 semailendtag nvarchar 50 YES
Back to top