Skip to main content

Agents & Technicians - Key Tables

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

SECTIONDETAIL (50 columns)

# Column Type Length Nullable Default
1 SDid int NO
2 SDSectionName nvarchar 200 YES
3 SDWorkingHoursBeforeAlert float YES ((0))
4 SDEmailAddress nvarchar 4000 YES
5 SDAddToAllTechs bit YES ((0))
6 SDforrequests bit YES ((1))
7 SDforopps bit YES ((1))
8 SDforprojects bit YES ((1))
9 SDchangeseq int YES ((0))
10 SDallowlivechat bit YES ((1))
11 SDRTID int YES ((0))
12 SDMailboxOverride int YES ((-1))
13 SDCat2 ntext 1073741823 YES
14 SDCat3 ntext 1073741823 YES
15 SDCat4 ntext 1073741823 YES
16 SDCat5 ntext 1073741823 YES
17 sddepartmentid int NO ((0))
18 sdallowallcat2 bit YES ((1))
19 sdallowallcat3 bit YES ((1))
20 sdallowallcat4 bit YES ((1))
21 sdallowallcat5 bit YES ((1))
22 SDtreeseq int YES ((0))
23 SDResetReassignLimit bit YES ((0))
24 sdinactive bit YES ((0))
25 SDReopenTicketsTech int NO ((0))
26 sdoverridecolumnsid int YES ((0))
27 sdmessagegroup int YES ((-1))
28 sdmainemail nvarchar 255 YES ('')
29 sdphonenumber nvarchar 50 YES ('')
30 sdalternativename nvarchar 255 YES ('')
31 SDTimezone nvarchar 100 YES ('')
32 SDLogoBase64 nvarchar -1 YES
33 sdincludeinloadbalance bit YES ((1))
34 SDDontSendSurvey bit YES ((0))
35 SDnote ntext 1073741823 YES
36 sdbookingworkdayid int YES ((1))
37 sdteamphotopath nvarchar -1 YES
38 SDGUID uniqueidentifier YES (newid())
39 sdlast_modified datetime YES ((0))
40 SDhideFromTreeIfNoTickets bit YES ((0))
41 sdtimesheetapprover int YES
42 SDconcurrentLicLimit int YES ((-1))
43 sdhomescreendashboardid int YES ((0))
44 sdthirdpartymigrationid nvarchar 100 YES
45 SDLoadbalanceinterval int YES ((0))
46 SDloadbalancemaxtickets int YES ((-1))
47 SDloadbalanceonschedule bit YES
48 SDloadbalancemaxticketsthisteamonly bit YES
49 SDloadbalancemaxticketsagentspecific bit YES
50 sdautoloadbalanceonclose bit YES

UNAME (393 columns)

# Column Type Length Nullable Default
1 Unum int NO
2 uname nvarchar 4000 YES
3 upassword nvarchar 4000 YES
4 Ulevel smallint YES
5 usection nvarchar 4000 YES
6 Ustartup nvarchar 2 YES
7 Udiaglevel smallint YES
8 Ukblevel smallint YES
9 Uclient smallint YES
10 usmtp nvarchar 4000 YES
11 UPC nvarchar 4000 YES
12 Uevent1 nvarchar 10 YES
13 Uevent2 nvarchar 10 YES
14 Uevent3 nvarchar 10 YES
15 uevent5 nvarchar 10 YES
16 uevent6 nvarchar 10 YES
17 uevent7 nvarchar 10 YES
18 uevent9 nvarchar 10 YES
19 uevent10 nvarchar 10 YES
20 uevent11 nvarchar 10 YES
21 uevent13 nvarchar 10 YES
22 uevent14 nvarchar 10 YES
23 uevent15 nvarchar 10 YES
24 uevent17 nvarchar 10 YES
25 uevent18 nvarchar 10 YES
26 uevent19 nvarchar 10 YES
27 UChangeLevel int YES ((0))
28 UServiceLevel int YES ((0))
29 UShowMidpoints int YES ((0))
30 UForceText int YES ((0))
31 UShowBitmaps int YES ((0))
32 UShowGrid int YES ((0))
33 USnapToGrid int YES ((0))
34 UShowDate int YES ((0))
35 UShowSeriousness int YES ((0))
36 UShowArea int YES ((0))
37 UShowSite int YES ((0))
38 UShowUsername int YES ((0))
39 UAutoRefresh int YES ((0))
40 USortOrder int YES ((0))
41 UUseLastZoom int YES ((0))
42 UShowSection int YES ((0))
43 UShowCat2 int YES ((0))
44 UShowCat3 int YES ((0))
45 Udontassign bit NO ((0))
46 Uisdisabled bit NO ((0))
47 Ucalcolour int YES ((0))
48 UdontemailmeifIloggedit bit NO ((0))
49 Urights nvarchar 4000 YES
50 UStopAllSections bit NO ((0))
51 UAD nvarchar 4000 YES
52 Ulastlogindate datetime YES
53 uhidebillinginfo bit NO ((0))
54 udashboardrefresh int YES ((0))
55 UAllowAll bit NO ((0))
56 UrefreshInterval int YES ((0))
57 Uhideothertechs bit NO ((0))
58 USMS nvarchar 4000 YES
59 UPortNumber int YES ((0))
60 uevent21 nvarchar 10 YES
61 uevent22 nvarchar 10 YES
62 uevent23 nvarchar 10 YES
63 uevent25 nvarchar 10 YES
64 uevent26 nvarchar 10 YES
65 uevent27 nvarchar 10 YES
66 UApptExchangeMailBoxFQDN nvarchar 4000 YES
67 Uapptsync int YES ((0))
68 uhidetabactions bit NO ((0))
69 uhidetabadditional bit NO ((0))
70 uhidetabother bit NO ((0))
71 uhidetabitemsissued bit NO ((0))
72 uhidetabtodo bit NO ((0))
73 uhidetabchange bit NO ((0))
74 uhidetabrelated bit NO ((0))
75 uhidetablinked bit NO ((0))
76 uhidetabapproval bit NO ((0))
77 uhidemenurequests bit NO ((0))
78 uhidemenuchangelog bit NO ((0))
79 uhidemenudevices bit NO ((0))
80 uhidemenuconns bit NO ((0))
81 uhidemenuservices bit NO ((0))
82 uhidemenuitems bit NO ((0))
83 uhidemenusuppliers bit NO ((0))
84 uhidemenuorders bit NO ((0))
85 usignature varbinary -1 YES
86 UCanEditClosedRequests bit NO ((0))
87 UWorkDayID int YES ((1))
88 uhrsreducer float YES ((1))
89 uhidetabinvoice bit NO ((0))
90 uhidetabsupplierorder bit NO ((0))
91 uhidetabconsignment bit NO ((0))
92 uhidetabquotation bit NO ((0))
93 uhidetabadvanced bit NO ((0))
94 Udefaultchargerate int YES ((-1))
95 uevent29 nvarchar 10 YES
96 uevent30 nvarchar 10 YES
97 uevent31 nvarchar 10 YES
98 uevent33 nvarchar 10 YES
99 UdefaultStockLocation int YES ((0))
100 UNchangeseq int YES ((1))
101 Ugeocoord1 float YES ((0))
102 Ugeocoord2 float YES ((0))
103 uevent34 nvarchar 10 YES
104 uevent35 nvarchar 10 YES
105 UIncludeOnTimesheetUsage bit NO ((0))
106 UReceiveTimeSheetUsageEmail bit NO ((0))
107 UDefaultViewUserID int YES ((0))
108 UDefaultViewViewID int YES ((0))
109 uhidemenuQuotes bit NO ((-1))
110 uhidemenuSupplierOrders bit NO ((-1))
111 uhidemenuConsignments bit NO ((-1))
112 uhidetabsalesorder bit NO ((0))
113 uhidetabappt bit NO ((0))
114 uhidemenuopp bit NO ((0))
115 UInformWhenNewClient bit NO ((0))
116 UJobTitle nvarchar 4000 YES
117 uhidemenucustomers bit NO ((0))
118 Ugoogleemail nvarchar 4000 YES
119 Ugooglepassword nvarchar 4000 YES
120 UtimezoneName nvarchar 4000 YES
121 UDateFormat int YES ((0))
122 UCalTimeInter int YES ((2))
123 UCalDayDisp int YES ((5))
124 UCalGroup bit NO ((0))
125 UCalTechs nvarchar 4000 YES
126 ucostPrice float YES ((0))
127 uhidemenuproject bit NO ((0))
128 UAssetTypeLevel int YES ((0))
129 uSupplier int YES ((0))
130 USendNewUserEmail bit YES ((0))
131 UTargetPrice float YES ((0.00))
132 uhidetabdelnote bit YES ((0))
133 Uspid int YES ((0))
134 unotifyprepaybreach bit YES ((0))
135 ULabNo nvarchar 4000 YES ('')
136 uevent37 nvarchar 10 YES ('')
137 uevent38 nvarchar 10 YES ('')
138 uevent39 nvarchar 10 YES ('')
139 UtemplateID int YES ((0))
140 UEndUserNewRequestsOnly bit YES ((0))
141 UTechphoto varbinary -1 YES
142 ulastlogindateweb datetime YES
143 ulastlogindatewebservice datetime YES
144 USyncAddressbook bit YES ((0))
145 Uevent4 nvarchar 10 YES ('NNNNNNNNNN')
146 Uevent8 nvarchar 10 YES ('NNNNNNNNNN')
147 Uevent12 nvarchar 10 YES ('NNNNNNNNNN')
148 Uevent16 nvarchar 10 YES ('NNNNNNNNNN')
149 Uevent20 nvarchar 10 YES ('NNNNNNNNNN')
150 Uevent24 nvarchar 10 YES ('NNNNNNNNNN')
151 Uevent28 nvarchar 10 YES ('NNNNNNNNNN')
152 Uevent32 nvarchar 10 YES ('NNNNNNNNNN')
153 Uevent36 nvarchar 10 YES ('NNNNNNNNNN')
154 Uevent40 nvarchar 10 YES ('NNNNNNNNNN')
155 UCurrDomain nvarchar 4000 YES ('')
156 uhidetabcontributors bit YES ((1))
157 UTechStatus int YES ((0))
158 ushowtechdashstartup bit YES
159 uextensionnumber nvarchar 4000 YES ('')
160 Uescspid int YES ((0))
161 UCanEditCTGlobal bit YES ((0))
162 UCanEditCTSection bit YES ((1))
163 UCanEditCTTech bit YES ((1))
164 ufacebookpage nvarchar 4000 YES ('')
165 uhidefacebook bit YES ((0))
166 uhidetwitter bit YES ((0))
167 utempdata nvarchar 4000 YES ('')
168 utempdata2 nvarchar 4000 YES ('')
169 UDefaultoppViewViewID int YES ((999))
170 UDefaultprojViewViewID int YES ((998))
171 uhidetabRMA bit YES ((0))
172 UMaxOrderAmount int YES ((0))
173 uallowmobileapps bit YES ((1))
174 ustartup2 nvarchar 4000 YES ('')
175 uworddoclevel int YES ((1))
176 Uevent41 nvarchar 10 YES ('NNNNNNNNNN')
177 Uevent42 nvarchar 10 YES ('NNNNNNNNNN')
178 Uevent43 nvarchar 10 YES ('NNNNNNNNNN')
179 Uevent44 nvarchar 10 YES ('NNNNNNNNNN')
180 uFeedbackEmail int YES ((0))
181 USendEmailIfNoPopup bit YES ((1))
182 UCanEditNotifications bit YES ((1))
183 uhidetabexpenses bit YES ((0))
184 uhidetabjourneys bit YES ((0))
185 ubugzillatoken nvarchar 1000 YES ('')
186 USendOwnerEmails bit YES ((1))
187 UActionEditLevel int YES ((0))
188 Uopptypechecklisttext ntext 1073741823 YES
189 Uprojecttypechecklisttext ntext 1073741823 YES
190 Urequesttypechecklisttext ntext 1073741823 YES
191 Ufilterrequesttypestring ntext 1073741823 YES
192 Ustatuschecklisttext ntext 1073741823 YES
193 Ufilterstatusstring ntext 1073741823 YES
194 Ucat2checklisttext ntext 1073741823 YES
195 Ufiltercat2string ntext 1073741823 YES
196 Ucat3checklisttext ntext 1073741823 YES
197 Ufiltercat3string ntext 1073741823 YES
198 Ucat4checklisttext ntext 1073741823 YES
199 Ufiltercat4string ntext 1073741823 YES
200 Ucat5checklisttext ntext 1073741823 YES
201 Ufiltercat5string ntext 1073741823 YES
202 uReplyDirect bit YES ((0))
203 UnameNotificationOverride nvarchar 500 YES ('')
204 Ulivechatissignedin bit YES ((1))
205 uClientTabVisibility nvarchar 100 YES ('YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY')
206 uSiteTabVisibility nvarchar 100 YES ('YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY')
207 uUserTabVisibility nvarchar 100 YES ('YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY')
208 UAllowAllType bit YES ((1))
209 uAssetPermissions nvarchar 100 YES ('22222222222222222222222222222222222222222222222222')
210 uAssetTabVisibility nvarchar 100 YES ('YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY')
211 uCalendarPermissions nvarchar 100 YES ('22222222222222222222222222222222222222222222222222')
212 uSalt nvarchar 255 YES ('')
213 uIterations int YES ((0))
214 UCanOnlyAccessCalendar bit YES ((0))
215 uhideremote bit YES ((0))
216 uActGUID nvarchar 38 YES ('')
217 UTechPhotoPath nvarchar 1000 YES ('')
218 uMobileItemPermissions nvarchar 100 YES ('22222222222222222222222222222222222222222222222222')
219 ufirstname nvarchar 100 YES ('')
220 ulastname nvarchar 200 YES ('')
221 uinitials nvarchar 3 YES ('')
222 ucolour nvarchar 7 YES ('')
223 uadconnection int YES ((-1))
224 usignaturehtml nvarchar -1 YES
225 UDesc nvarchar 500 YES ('')
226 UCiscoAgentName nvarchar 500 YES ('')
227 UciscoAgentExtension nvarchar 500 YES ('')
228 UCiscoAgentPassword nvarchar 500 YES ('')
229 utechphotobase64 nvarchar -1 YES
230 upagesize int YES ((15))
231 uticketdefaultfilter int YES ((-1))
232 uticketdefaultview nvarchar 100 YES ('')
233 uticketdefaultcolumns int YES ((-1))
234 uticketdefaultview2 int YES ((-1))
235 udefaultactionview nvarchar 10 YES ('nonsys')
236 udefaultticketpreviewsize int YES ((409))
237 ulisttype int YES ((0))
238 ucalendardefaultview nvarchar 10 YES ('')
239 ucalendaroptions nvarchar 1000 YES ('')
240 unewtabpref int YES ((1))
241 utheme nvarchar 50 YES ('theme-light')
242 ulanguageid int YES ((0))
243 uappcolour nvarchar 50 YES ('')
244 usearchoptions nvarchar 4000 YES ('')
245 Uactionwindowdisplaytype int YES ((0))
246 udefaultfeedview nvarchar 25 YES
247 uUseADWebLogin int YES ((0))
248 uactived nvarchar 255 YES ('')
249 UHistoryDisplay int YES ((0))
250 uhomescreenchartid int YES ((0))
251 uoppsdefaultfilter int YES ((-1))
252 uoppsdefaultview nvarchar 100 YES ('')
253 uoppsdefaultview2 int YES ((-1))
254 uoppsdefaultcolumns int YES ((-1))
255 UForecastPermission int NO ((0))
256 udatecreated datetime YES ((0))
257 USageDepartmentID int NO ((0))
258 uticketpreviewmode int YES ((0))
259 UNavMenuMode int YES ((0))
260 uenablehighcontrast bit YES ((0))
261 Ulogmeinid nvarchar 50 YES ('')
262 uallowbeyondtrustinvites bit YES ((0))
263 ubeyondtrustname nvarchar 100 YES ('')
264 UJiraID nvarchar 50 YES ('')
265 usendemailerrors bit YES ((0))
266 uwarnifnoscan bit YES ((0))
267 UWarnIfNoScanIntegrator bit YES ((0))
268 UWarnIfNoScanIntegratorHours int YES ((0))
269 UOrionUsername nvarchar 100 YES ('')
270 UOrionPassword nvarchar 250 YES ('')
271 UNCentralUsername nvarchar 100 YES ('')
272 UNCentralPassword nvarchar 500 YES ('')
273 USOCUsername nvarchar 100 YES ('')
274 UAutotaskId int YES ((-1))
275 UOktaId nvarchar 250 YES ('')
276 uhomescreendashboardid int YES ((0))
277 UPoMinCostForApprovalType int YES ((0))
278 UpoMinCostForApproval float YES ((0))
279 UquoteMarginForApprovalType int YES ((0))
280 UquoteMarginForApproval float YES ((0))
281 ulinemanager int YES ((0))
282 UNewMethod bit YES ((0))
283 UnavDisplayMode int YES ((0))
284 UExchangeAccessToken nvarchar -1 YES ('')
285 UExchangeRefreshToken nvarchar -1 YES ('')
286 UExchangeTokenExpiry datetime YES ((0))
287 UExchangeAuthorized bit YES ((0))
288 UExchangeAccount nvarchar 250 YES ('')
289 UExchangeRedirect nvarchar 500 YES ('')
290 USentinelAccessToken nvarchar -1 YES ('')
291 USentinelRefreshToken nvarchar -1 YES ('')
292 USentinelTokenExpiry datetime YES ((0))
293 USentinelAuthorized bit YES ((0))
294 UsentinelRedirect nvarchar 500 YES ('')
295 uassetdefaultcolumns int YES ((-1))
296 UClientDetailsLayout int YES ((-1))
297 UlicenseType int YES ((0))
298 uexcludefromresourcebooking bit YES ((0))
299 uenableshifts bit YES
300 UthemeRevert nvarchar 50 YES
301 ugooglemailauthorized bit YES ((0))
302 uisapiagent bit YES
303 uholidayallowance float YES
304 udefaulttravelrate int YES ((-1))
305 UgithubUsername nvarchar 255 YES
306 uclientsdefaultcolumns int YES ((-1))
307 ucustomersdefaultview int YES
308 uusersdefaultview int YES
309 UNavScreenLayout int YES ((-1))
310 ucontractsdefaultcolumns int YES ((-1))
311 usitedefaultcolumns int YES ((-1))
312 uusersdefaultcolumns int YES ((-1))
313 upagerdutyemail nvarchar 400 YES
314 ucanapprovepurchaseorder bit YES ((0))
315 ucanapprovequote bit YES ((0))
316 ulast_modified datetime YES ((0))
317 ujirainstance int YES ((1))
318 usidemenudashboardid int YES ((0))
319 uPrefNotificationSound int YES ((0))
320 uPrefChatSound int YES ((0))
321 usuppliercontractsdefaultcolumns int YES ((-1))
322 uassetdefaultlist int YES
323 uassetdefaultview nvarchar 50 YES
324 usplashtopurl nvarchar 50 YES ('https://webapi.splashtop.com')
325 usplashtopauthorized bit YES ((0))
326 usplashtopaccesstoken nvarchar -1 YES ('')
327 usplashtoprefreshtoken nvarchar -1 YES ('')
328 usplashtoptokenexpiry datetime YES ((0))
329 udefaultsplashtopchannel int YES
330 udefaultsplashtopchannelname nvarchar 255 YES
331 ucanapproveinvoice bit YES ((1))
332 uallowautomaticcallscripts bit YES ((1))
333 ugotoresolveauthorized bit YES ((0))
334 ugotoresolveaccesstoken nvarchar -1 YES ('')
335 ugotoresolverefreshtoken nvarchar -1 YES ('')
336 ugotoresolvetokenexpiry datetime YES ((0))
337 UAzureADConnection int YES ((0))
338 usupplierdefaultcolumns int YES ((-1))
339 usuppliersdefaultview int YES ((-1))
340 UContractDetailsLayout int YES ((-1))
341 udefaultactiondatedisplay int YES
342 CFSalesQuotaJan nvarchar 255 YES
343 CFSalesQuotaFeb nvarchar 255 YES
344 CFSalesQuotaMar nvarchar 255 YES
345 CFSalesQuotaApr nvarchar 255 YES
346 CFSalesQuotaMay nvarchar 255 YES
347 CFSalesQuotaJun nvarchar 255 YES
348 CFSalesQuotaJul nvarchar 255 YES
349 CFSalesQuotaAug nvarchar 255 YES
350 CFSalesQuotaSep nvarchar 255 YES
351 CFSalesQuotaOct nvarchar 255 YES
352 CFSalesQuotaNov nvarchar 255 YES
353 CFSalesQuotaDec nvarchar 255 YES
354 CFRecurringQuotaJan nvarchar 255 YES
355 CFRecurringQuotaFeb nvarchar 255 YES
356 CFRecurringQuotaMar nvarchar 255 YES
357 CFRecurringQuotaApr nvarchar 255 YES
358 CFRecurringQuotaMay nvarchar 255 YES
359 CFRecurringQuotaJun nvarchar 255 YES
360 CFRecurringQuotaJul nvarchar 255 YES
361 CFRecurringQuotaAug nvarchar 255 YES
362 CFRecurringQuotaSep nvarchar 255 YES
363 CFRecurringQuotaOct nvarchar 255 YES
364 CFRecurringQuotaNov nvarchar 255 YES
365 CFRecurringQuotaDec nvarchar 255 YES
366 usignatureattachmentid int YES
367 UUserDetailsLayout int YES ((-1))
368 usitedetailslayout int YES ((-1))
369 uposdefaultcolumns int YES ((-1))
370 Uguid uniqueidentifier NO (newid())
371 uenableteamsshifts bit YES
372 uwarnifincompletets bit YES
373 uwarnifincompletetsmanager bit YES
374 uincompletetsthreshold int YES ((100))
375 uincompletetssendtime datetime YES ((0))
376 uincompletetslastcreated datetime YES ((0))
377 UFederatedIdentityId nvarchar 100 YES
378 uTreeDisplayMode int YES ((-1))
379 uHaloTabPref int YES ((-1))
380 uNavColour nvarchar 7 YES
381 usosdefaultcolumns int YES ((-1))
382 uquotesdefaultcolumns int YES ((-1))
383 uinvoicesdefaultcolumns int YES ((-1))
384 urinvoicesdefaultcolumns int YES ((-1))
385 UOrionKeyVaultSecretName nvarchar 250 YES
386 ugotoresolveredirecturi nvarchar 250 YES
387 usplashtopredirecturi nvarchar 250 YES
388 utimezone nvarchar 100 YES
389 ucontactpref1 int YES ((0))
390 ucontactpref2 int YES ((0))
391 ucontactpref3 int YES ((0))
392 uaccountsdefaultcolumns int YES ((-1))
393 uprospectsdefaultcolumns int YES ((-1))

UNAMESECTION (14 columns)

# Column Type Length Nullable Default
1 USunum int NO
2 USsection nvarchar 4000 YES
3 USinsection bit YES ((1))
4 USSDID int YES ((-1))
5 usIsManager bit YES ((0))
6 USID int NO
7 USroleid nvarchar 100 YES ('')
8 usmembershiplevel int YES ((0))
9 USunassignedaccess bit YES ((1))
10 USotheragentaccess bit YES ((1))
11 USnoConfigAccess bit YES ((0))
12 usexcludefromteamresourcebooking bit YES
13 usisintegration bit YES
14 usexcludeautoassign bit YES

UNAMETEMPLATE (139 columns)

# Column Type Length Nullable Default
1 UTid int NO
2 UTdesc nvarchar 4000 YES ('')
3 UTsection nvarchar 4000 YES ('Not Set')
4 UTdefaultchargerate int YES ((-2))
5 UTstartup nvarchar 4000 YES ('NO')
6 UTdontassign int YES ((0))
7 UTStopAllSections int YES ((0))
8 UTisdisabled int YES ((0))
9 UTucalcolour int YES ((-1))
10 UTdontemailmeifIloggedit int YES ((0))
11 UTrefreshInterval int YES ((-1))
12 UThideothertechs int YES ((0))
13 UTUapptsync int YES ((-1))
14 UTportnumber int YES ((-1))
15 UTcostPrice float YES ((-1.00))
16 UTworkdayid int YES ((-1))
17 UThrsreducer float YES ((-1.00))
18 UTdefaultStockLocation int YES ((-1))
19 UTIncludeOnTimesheetUsage int YES ((0))
20 UTReceiveTimeSheetUsageEmail int YES ((0))
21 UTInformWhenNewClient int YES ((0))
22 UTSendNewUserEmail int YES ((0))
23 UTtimezoneName nvarchar 4000 YES ('')
24 UTDateFormat int YES ((-1))
25 UTevent1 nvarchar 10 YES ('')
26 UTevent2 nvarchar 10 YES ('')
27 UTevent3 nvarchar 10 YES ('')
28 UTevent4 nvarchar 10 YES ('')
29 UTevent5 nvarchar 10 YES ('')
30 UTevent6 nvarchar 10 YES ('')
31 UTevent7 nvarchar 10 YES ('')
32 UTevent8 nvarchar 10 YES ('')
33 UTevent9 nvarchar 10 YES ('')
34 UTevent10 nvarchar 10 YES ('')
35 UTevent11 nvarchar 10 YES ('')
36 UTevent12 nvarchar 10 YES ('')
37 UTevent13 nvarchar 10 YES ('')
38 UTevent14 nvarchar 10 YES ('')
39 UTevent15 nvarchar 10 YES ('')
40 UTevent16 nvarchar 10 YES ('')
41 UTevent17 nvarchar 10 YES ('')
42 UTevent18 nvarchar 10 YES ('')
43 UTevent19 nvarchar 10 YES ('')
44 UTevent20 nvarchar 10 YES ('')
45 UTevent21 nvarchar 10 YES ('')
46 UTevent22 nvarchar 10 YES ('')
47 UTevent23 nvarchar 10 YES ('')
48 UTevent24 nvarchar 10 YES ('')
49 UTevent25 nvarchar 10 YES ('')
50 UTevent26 nvarchar 10 YES ('')
51 UTevent27 nvarchar 10 YES ('')
52 uTlevel int YES ((0))
53 uTkblevel int YES ((0))
54 uTchangelevel int YES ((0))
55 uTservicelevel int YES ((0))
56 uTdiaglevel int YES ((0))
57 UTAssetTypeLevel int YES ((0))
58 UTrights nvarchar 4000 YES ('')
59 uThidetabactions bit YES ((0))
60 uThidetabadditional bit YES ((0))
61 uThidetabother bit YES ((0))
62 uThidetabitemsissued bit YES ((0))
63 uThidetabtodo bit YES ((0))
64 uThidetabchange bit YES ((0))
65 uThidetabrelated bit YES ((0))
66 uThidetablinked bit YES ((0))
67 uThidetabapproval bit YES ((0))
68 uThidemenurequests bit YES ((0))
69 uThidemenuchangelog bit YES ((0))
70 uThidemenudevices bit YES ((0))
71 uThidemenuconns bit YES ((0))
72 uThidemenuservices bit YES ((0))
73 uThidemenuitems bit YES ((0))
74 uThidemenusuppliers bit YES ((0))
75 uThidemenuorders bit YES ((0))
76 uThidetabinvoice bit YES ((0))
77 uThidetabsupplierorder bit YES ((0))
78 uThidetabconsignment bit YES ((0))
79 uThidetabquotation bit YES ((0))
80 uThidetabadvanced bit YES ((0))
81 uThidemenuQuotes bit YES ((1))
82 uThidemenuSupplierOrders bit YES ((1))
83 uThidemenuConsignments bit YES ((1))
84 uThidetabsalesorder bit YES ((0))
85 uThidetabappt bit YES ((0))
86 uThidemenuopp bit YES ((0))
87 uThidemenucustomers bit YES ((0))
88 uThidemenuproject bit YES ((0))
89 UTAllowAll bit YES ((0))
90 uThidetabdelnote bit YES ((0))
91 uthidetabcontributors bit YES ((1))
92 UTCanEditCTGlobal bit YES ((0))
93 UTCanEditCTSection bit YES ((1))
94 UTCanEditCTTech bit YES ((1))
95 UTevent28 nvarchar 10 YES ('')
96 UTevent29 nvarchar 10 YES ('')
97 UTevent30 nvarchar 10 YES ('')
98 UTevent31 nvarchar 10 YES ('')
99 UTevent32 nvarchar 10 YES ('')
100 UTevent33 nvarchar 10 YES ('')
101 UTevent34 nvarchar 10 YES ('')
102 UTevent35 nvarchar 10 YES ('')
103 UTevent36 nvarchar 10 YES ('')
104 UTevent37 nvarchar 10 YES ('')
105 UTevent38 nvarchar 10 YES ('')
106 UTevent39 nvarchar 10 YES ('')
107 UTevent40 nvarchar 10 YES ('')
108 UTSupplier int YES ((-1))
109 uthidetabrma bit YES ((1))
110 UTMaxOrderAmount int YES ((0))
111 utstartup2 nvarchar 4000 YES ('')
112 utworddoclevel int YES ((-1))
113 UTevent41 nvarchar 10 YES ('NNNNNNNNNN')
114 UTevent42 nvarchar 10 YES ('NNNNNNNNNN')
115 UTevent43 nvarchar 10 YES ('NNNNNNNNNN')
116 UTevent44 nvarchar 10 YES ('NNNNNNNNNN')
117 UTSendEmailIfNoPopup int YES ((-1))
118 UTCanEditNotifications int YES ((-1))
119 uthidetabexpenses bit YES ((0))
120 uthidetabjourneys bit YES ((0))
121 UTGlobalViewID int YES ((0))
122 uthidetwitter bit YES ((0))
123 uthidefacebook bit YES ((0))
124 utusesections bit YES ((1))
125 UTActionEditLevel int YES ((0))
126 utReplyDirect bit YES ((0))
127 uClientTabVisibility nvarchar 100 YES ('YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY')
128 uSiteTabVisibility nvarchar 100 YES ('YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY')
129 uUserTabVisibility nvarchar 100 YES ('YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY')
130 UTAllowAllType bit YES ((1))
131 uAssetPermissions nvarchar 100 YES ('22222222222222222222222222222222222222222222222222')
132 uAssetTabVisibility nvarchar 100 YES ('YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY')
133 uCalendarPermissions nvarchar 100 YES ('22222222222222222222222222222222222222222222222222')
134 UTCanOnlyAccessCalendar bit YES ((0))
135 uthideremote bit YES ((0))
136 utMobileItemPermissions nvarchar 100 YES ('22222222222222222222222222222222222222222222222222')
137 UTAllowMobileApps bit YES ((0))
138 UTCopyNotifications bit YES ((0))
139 utroleid uniqueidentifier YES
Back to top