Skip to main content

Custom Fields & Configuration - Key Tables

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

CONTROL (808 columns)

# Column Type Length Nullable Default
1 Rseq int NO
2 RDBVersion int YES ((0))
3 RDBname nvarchar 8 YES
4 RShbitmaps bit NO ((0))
5 RShMap bit NO ((0))
6 RAutoedit bit NO ((0))
7 rgbitdir nvarchar 4000 YES
8 rmapfile nvarchar 4000 YES
9 Rcheckpassword bit NO ((0))
10 Rfixfollowhd bit NO ((0))
11 Rsinglesection bit NO ((0))
12 Rlisthdid bit NO ((0))
13 Rfixlower smallint YES
14 Rfixupper smallint YES
15 rdefsection nvarchar 4000 YES
16 rdefcat2 nvarchar 4000 YES
17 rdefcat3 nvarchar 4000 YES
18 Rusepriority bit NO ((0))
19 Rsections ntext 1073741823 YES
20 Rcat2 ntext 1073741823 YES
21 Rcat3 ntext 1073741823 YES
22 rdudir nvarchar 4000 YES
23 Rprintenlarge float YES
24 Rlandscape bit NO ((0))
25 Rborder smallint YES
26 Rpagetopx smallint YES
27 Rpagetopy smallint YES
28 Rpagebottomx smallint YES
29 Rpagebottomy smallint YES
30 Rpagebordersize smallint YES
31 Rdiagrambordersize smallint YES
32 RSitex smallint YES
33 Rsitey smallint YES
34 Rdetailsx smallint YES
35 Rdetailsy smallint YES
36 Rdefchargecode1 nvarchar 4000 YES
37 Rdefchargecode2 nvarchar 4000 YES
38 Rfileloc ntext 1073741823 YES
39 Rnotepad nvarchar 4000 YES
40 Rwordpro nvarchar 4000 YES
41 Rofflength smallint YES
42 Roffheight smallint YES
43 Roffdist smallint YES
44 Rsnapfactor smallint YES
45 rreportdir nvarchar 4000 YES
46 Rreviewdays smallint YES
47 Rcat4 ntext 1073741823 YES
48 Rcat5 ntext 1073741823 YES
49 rdefcat4 nvarchar 4000 YES
50 rdefcat5 nvarchar 4000 YES
51 Ruseexthd bit NO ((0))
52 Rreportevents bit NO ((0))
53 Rreportextevents bit NO ((0))
54 Rallusethisslaid int YES
55 Rseriousness int YES
56 rareaclient nvarchar 4000 YES
57 Rdefassignedto smallint YES
58 rdefsection2 nvarchar 4000 YES
59 rdefcat22 nvarchar 4000 YES
60 rdefcat32 nvarchar 4000 YES
61 Rdefassignedto2 smallint YES
62 Rseriousness2 int YES
63 rdefsection3 nvarchar 4000 YES
64 rdefcat23 nvarchar 4000 YES
65 rdefcat33 nvarchar 4000 YES
66 Rdefassignedto3 smallint YES
67 Rseriousness3 int YES
68 Rdefstatus smallint YES
69 Rdefstatus2 smallint YES
70 Rdefstatus3 smallint YES
71 RDateField datetime YES
72 rfixwarninghours money YES ((0))
73 rdatelastchecked datetime YES
74 rlastemailin ntext 1073741823 YES
75 rlasterror ntext 1073741823 YES
76 rservicedays int YES ((0))
77 rldapstring nvarchar 4000 YES
78 rdefucontacted bit NO ((0))
79 rtechassign int YES ((0))
80 rstatusafterview int YES ((0))
81 Rusenetworkloginname bit NO ((0))
82 Rhidefaq bit NO ((0))
83 Rhidenewrequest bit NO ((0))
84 RFirstUserScreen int YES ((0))
85 RHideSeriousness bit NO ((0))
86 RHidereportedby bit NO ((0))
87 Rhidechangepassword bit NO ((0))
88 RHideStats bit NO ((0))
89 Rhidedate bit NO ((0))
90 Rhidetime bit NO ((0))
91 Rhidepasswordbox bit NO ((0))
92 Rhidehelp bit NO ((0))
93 Rhidesection bit NO ((0))
94 Rhidecat2 bit NO ((0))
95 Rhidecat3 bit NO ((0))
96 Rlsection nvarchar 4000 YES
97 Rlcat2 nvarchar 4000 YES
98 Rlcat3 nvarchar 4000 YES
99 Rlareaclient nvarchar 4000 YES
100 Rhidetechnician bit NO ((0))
101 Rdropboxmax int YES ((0))
102 Rshownonbilltime int YES ((0))
103 Restimatedefault float YES ((0))
104 Restimateunknown float YES ((0))
105 Rshowtoplevel bit NO ((0))
106 Rluserdef1 nvarchar 4000 YES
107 Rluserdef2 nvarchar 4000 YES
108 Rluserdef3 nvarchar 4000 YES
109 Rluserdef4 nvarchar 4000 YES
110 Rluserdef5 nvarchar 4000 YES
111 Rallowwindowsauth bit NO ((0))
112 Rlsymptom nvarchar 4000 YES
113 Rlreportedby nvarchar 4000 YES
114 Rlseriousness nvarchar 4000 YES
115 Rldateoccurred nvarchar 4000 YES
116 Rltimeoccurred nvarchar 4000 YES
117 Rlserviceannouncement nvarchar 4000 YES
118 Rfluserdef1 nvarchar 4000 YES
119 Rfluserdef2 nvarchar 4000 YES
120 Rfluserdef3 nvarchar 4000 YES
121 Rfluserdef4 nvarchar 4000 YES
122 Rfluserdef5 nvarchar 4000 YES
123 Rlsitename nvarchar 4000 YES
124 Rlusername nvarchar 4000 YES
125 Rfluserdef1hide bit NO ((0))
126 Rfluserdef2hide bit NO ((0))
127 Rfluserdef3hide bit NO ((0))
128 Rfluserdef4hide bit NO ((0))
129 Rfluserdef5hide bit NO ((0))
130 Rfluserdef1mand bit NO ((0))
131 Rfluserdef2mand bit NO ((0))
132 Rfluserdef3mand bit NO ((0))
133 Rfluserdef4mand bit NO ((0))
134 Rfluserdef5mand bit NO ((0))
135 Roverduecolour int YES ((0))
136 Rhideaddnote bit NO ((0))
137 Rhidelistinventory bit NO ((0))
138 Rpercentageoverdue int YES ((0))
139 Rhideactions bit NO ((0))
140 Rstartclock bit NO ((0))
141 RAllowduplicateinv bit NO ((0))
142 rlinv nvarchar 4000 YES
143 Rinvmand bit NO ((0))
144 Rtimeoutmins int YES ((0))
145 RdontuseISOdate bit NO ((0))
146 Rtechhidestatus bit NO ((0))
147 Ruserhidestatus bit NO ((0))
148 Rtechhideplanneddate bit NO ((0))
149 Ruserhideplanneddate bit NO ((0))
150 Rtechhidefixbydate bit NO ((0))
151 Ruserhidefixbydate bit NO ((0))
152 Rtechhidetech bit NO ((0))
153 Ruserhidetech bit NO ((0))
154 Rtechhidedesc bit NO ((0))
155 Ruserhidedesc bit NO ((0))
156 Rhide2chars bit NO ((0))
157 Ruseminsnotdecimals bit NO ((0))
158 Ractualhrsoptional bit NO ((0))
159 Rallownewuser bit NO ((0))
160 Rallownewuserchoose bit NO ((0))
161 Rallownewusersiteid int YES ((0))
162 Rcompletedstatus int YES ((0))
163 Rcompletedcaption nvarchar 4000 YES
164 Rallowtechwindowsauth bit NO ((0))
165 RADPageSize int YES ((0))
166 RAutoPublish bit NO ((0))
167 rcalinterval int YES ((0))
168 rcaldays int YES ((0))
169 rcalhidesymptom bit NO ((0))
170 rcalinccleared bit NO ((0))
171 rcalstart int YES ((0))
172 rcalend int YES ((0))
173 rcalwdstart int YES ((0))
174 rdontallowactionedit bit NO ((0))
175 rdontallowactiondelete bit NO ((0))
176 rallowrequestdelete bit NO ((0))
177 rcalwdend int YES ((0))
178 rGID nvarchar 4000 YES
179 rGIDEND nvarchar 4000 YES
180 rshowfulltreeafteradd bit NO ((0))
181 RNextInvoiceNumber int YES ((0))
182 RTaxCode1 money YES ((0))
183 RTaxCode2 money YES ((0))
184 RTaxCode3 money YES ((0))
185 RTaxCode4 money YES ((0))
186 RTaxCode5 money YES ((0))
187 RTaxCodeDesc1 nvarchar 4000 YES
188 RTaxCodeDesc2 nvarchar 4000 YES
189 RTaxCodeDesc3 nvarchar 4000 YES
190 RTaxCodeDesc4 nvarchar 4000 YES
191 RTaxCodeDesc5 nvarchar 4000 YES
192 risexampledb bit NO ((0))
193 rhidetotals bit NO ((0))
194 rhideslasummary bit NO ((0))
195 RSageDataPath nvarchar 4000 YES
196 RSageUserName nvarchar 4000 YES
197 RSagePassword nvarchar 4000 YES
198 RSageNONSLAItemCode nvarchar 4000 YES
199 rusesage bit NO ((0))
200 RSageVersion int YES ((0))
201 RIndexKB bit NO ((0))
202 rdefcat42 nvarchar 4000 YES
203 rdefcat43 nvarchar 4000 YES
204 rdefcat52 nvarchar 4000 YES
205 rdefcat53 nvarchar 4000 YES
206 Rhidecat4 bit NO ((0))
207 Rhidecat5 bit NO ((0))
208 Rlcat4 nvarchar 4000 YES
209 Rlcat5 nvarchar 4000 YES
210 REmailStart nvarchar 4000 YES
211 REmailEnd nvarchar 4000 YES
212 RUseClients bit NO ((0))
213 RQBVersion nvarchar 10 YES
214 RUseQB bit NO ((0))
215 RSLAexcusecolour int YES ((0))
216 RAllowWebUpload bit NO ((0))
217 RAllowWebUploadtech bit NO ((0))
218 RPlannedTodaycolour int YES ((0))
219 Rsendackemailsforwebrequests bit NO ((0))
220 Rtechhidecreateuser bit NO ((0))
221 Rhiderequesttype bit NO ((0))
222 RLLogin nvarchar 4000 YES
223 Rhidecat2tech bit NO ((0))
224 Rhidecat3tech bit NO ((0))
225 Rhidecat4tech bit NO ((0))
226 Rhidecat5tech bit NO ((0))
227 RhideReportedBytech bit NO ((0))
228 Rhidelistinventorytech bit NO ((0))
229 Rinvmandtech bit NO ((0))
230 Rhideotherlogin bit NO ((0))
231 Rhidesectiontech bit NO ((0))
232 rdbversionweb int YES ((0))
233 rliccount int YES ((5))
234 rlicname nvarchar 255 YES ('')
235 rlicend datetime YES ((0))
236 rdbid nvarchar 50 YES ('')
237 rdbkey nvarchar 50 YES ('')
238 lic image 2147483647 YES
239 LicError nvarchar 1000 YES ('')
240 AppName nvarchar 255 YES ('Halo ITSM')
241 RdefaultPdfTemplateCredit int YES ((6))
242 RenableMultiEntitySearch bit YES ((0))
243 RmultiEntitySearchIncludeFaults bit YES ((1))
244 RmultiEntitySearchIncludeKbentry bit YES ((1))
245 RmultiEntitySearchIncludeDevice bit YES ((1))
246 RmultiEntitySearchIncludeArea bit YES ((1))
247 RmultiEntitySearchIncludeSite bit YES ((0))
248 RmultiEntitySearchIncludeUsers bit YES ((1))
249 RmultiEntitySearchIncludeCompany bit YES ((0))
250 RmultiEntitySearchIncludeItem bit YES ((0))
251 RmultiEntitySearchIncludeQuote bit YES ((0))
252 RmultiEntitySearchIncludeSO bit YES ((0))
253 RmultiEntitySearchIncludePO bit YES ((0))
254 RmultiEntitySearchIncludeServices bit YES ((1))
255 RshowQuickSearch bit YES ((1))
256 RshowTreeSearch bit YES ((1))
257 RportalAllowKbSearch bit YES ((1))
258 RportalAllowServiceSearch bit YES ((0))
259 RportalAllowTicketSearch bit YES ((0))
260 RallowNewUserFromChangeUserScreen bit YES ((0))
261 RADSelfServiceWebAppPwdResetType int YES ((0))
262 RticketTimerDisplay int YES ((0))
263 RportalButtonMaxPerRow int YES ((3))
264 RcontinuallyAppId nvarchar 200 YES ('')
265 RtrackTicketViews bit YES ((0))
266 RShowPrePayBalanceOnTicket bit YES ((0))
267 RssoRememberMe bit YES ((0))
268 REUPAllowSiteSelection bit YES ((0))
269 RshowTemplateSelectionButton bit YES ((1))
270 RshowSaveAsTemplateButton bit YES ((1))
271 rWelcomeMessage ntext 1073741823 YES
272 RProblemMatchSearchMode int YES ((0))
273 RupdateTicketWhenPOInStock bit YES ((0))
274 RupdateTicketWhenPOInStockStatus int YES ((0))
275 RallowStockReserve bit YES ((0))
276 RbudgetCalcType int YES ((1))
277 RDefaultContractEndDateType int YES ((0))
278 RPeriodsAheadForContractInvoiceStart int YES ((0))
279 REncThumbprint nvarchar 255 YES ('')
280 rhomescreendashboardid int YES ((-1))
281 RallowTaxCodeOverride bit YES ((0))
282 RmergeRecurringInvoices bit YES ((0))
283 RmergeSalesOrderInvoices bit YES ((0))
284 RallowLiveChatOnNewPortal bit YES ((0))
285 rloadimagesfromapitype int YES ((0))
286 rloadimagesfromapilocation nvarchar 200 YES ('')
287 RshowUsersAssetsOnTicket bit YES ((0))
288 RUseTechFWDFunctionalityUpdateParent bit YES ((0))
289 RshowUsersAssetsOnCall bit YES ((0))
290 RenableMentions bit YES ((0))
291 RpoMinCostForApproval float YES ((0))
292 RenableQuoteApprovals bit YES ((0))
293 RpoApproverSelectionType int YES ((0))
294 RquoteMarginForApproval float YES ((100))
295 RenableMyReports bit YES ((0))
296 RenableMyScheduledReports bit YES ((0))
297 RshowQuoteCannedOnApprovalScreen bit YES ((0))
298 RenableAgentBooking bit YES ((0))
299 RagentBookingMinHoursInAdvance float YES ((1))
300 RagentBookingMaxDaysInAdvance float YES ((365))
301 RagentBookingOnlyAuthenticated bit YES ((1))
302 RenableProjectTreeView bit YES ((0))
303 RpublishChangeCalendar bit YES ((0))
304 RenableKBDrafts bit YES ((0))
305 RkbDraftTicketType int YES ((0))
306 RuseCurrencyConversion bit YES ((0))
307 RuseTravelChargeRates bit YES ((0))
308 RuserSearchMode int YES ((1))
309 RuserSearchMode2 int YES ((1))
310 RdetailsScreenDisplayType int YES ((0))
311 RnavDisplayMode int YES ((1))
312 RuseSemanticVersioning bit YES ((0))
313 Rappfont nvarchar 255 YES ('')
314 rconcurrentliccount int YES ((0))
315 RuseSecureQuoteSigning bit YES ((0))
316 Rloadimagesfromapiurloverride nvarchar 255 YES
317 RTimeFieldInputType int YES ((0))
318 RticketDetailsTitleDisplayMode int YES ((0))
319 RItemNamesUnique bit YES ((1))
320 RTranslationTextType int YES ((0))
321 RTranslationMonthlyCharacterCap bigint YES
322 RTranslationMonthlyCharacterCapCanEdit bit YES ((1))
323 RCRMShowExtraDetails bit YES ((0))
324 RdefaultClientDetailsLayout int YES ((0))
325 RKBViewAgentApp int YES ((0))
326 RuseBackgroundThreads bit YES ((1))
327 REnableFullTextSearchActions bit YES
328 rlivechatconnectionmethod int YES ((0))
329 RPortalChatProfile nvarchar 50 YES ('a34f0eb2-5f48-44af-87f7-5ba3307339a9')
330 RAddressFieldType int YES ((0))
331 RTwillioSMSAccountSID nvarchar 500 YES ('')
332 RTwillioSMSAuthToken nvarchar 500 YES ('')
333 RTwillioSMSFromPhoneNumber nvarchar 100 YES ('')
334 RTwillioSMSLeadingZeroSubstitute nvarchar 100 YES ('+44')
335 RSMSType int YES ((0))
336 rsage50ukinvoicetype int YES ((0))
337 rconnectwisemanageclientid nvarchar 500 YES ('')
338 rshowallphonenumbersonticketdetails bit YES ((0))
339 rsendaccountmanagernotifications bit YES ((1))
340 ruseutcforappointments bit YES ((1))
341 rstopautomaticdevicemovementsinstock bit YES ((0))
342 RliveChatJoinMode int YES ((0))
343 RchatShowNewBubble bit YES ((1))
344 rsetdisplaynametoagentname bit YES ((0))
345 renablehalostripe bit YES
346 renablehalostripewebhooks bit YES
347 RAutomateTicketScriptID int YES
348 rsyncingxeroproducts bit YES ((1))
349 rreportcolourpalette int YES ((0))
350 rdonotcreateuser bit YES
351 rattachmentstabtable bit YES ((0))
352 RenableHaloNews bit YES ((1))
353 rdefaultstockbinlocation int YES ((1))
354 renablestockbins bit YES
355 rdefaultmovestocklocation int YES
356 rdefaultmovestockbinlocation int YES
357 renableportalgdprscreen bit YES
358 rautocreatecustomerreference int YES ((0))
359 rautogenerateitemaccountsid bit YES ((0))
360 ruseeventsendpoint bit YES
361 ruseeventservice bit YES ((0))
362 rusedefaultsubjectmatchingtag bit YES ((1))
363 ruseprepaypurchasedatesforcalculatingbalance bit YES ((0))
364 rsagebusinessclouddefaulttenantid int YES
365 rsagebusinessclouddefaultinvoicestatus int YES
366 rpublishchangecalendartype int YES ((0))
367 rxeropostgroupheaders bit YES ((0))
368 rresponsedontassign bit YES
369 rautomaticallysendsignedticketclosurepdf bit YES ((1))
370 rlinkrecurringapptticket bit YES ((0))
371 rclosetaskswhenclosingticket int YES ((0))
372 rshowassettagongoodsout bit YES ((0))
373 rassetserializationtabbehaviour int YES ((0))
374 rmustsetcustomerfirst bit YES
375 RDontSendAckToNonSiteDomain bit YES ((0))
376 rsalesorderstatusafterinvoiced int YES ((0))
377 rsalesorderstatusafterinvoicedandactionscomplete int YES ((0))
378 RDefaultForNewOpportunityUser int YES ((0))
379 rdonotshowwarrantyexpiration bit YES ((0))
380 RDevopsMigrated bit YES ((0))
381 rhidedefaultoppsarea bit YES ((0))
382 rshowassetdiagramservices bit YES ((0))
383 RTemplateAccessMigrated bit YES ((0))
384 rportalkbmatchingtype int YES ((0))
385 rcheckticketclashes bit YES
386 renablecontractrollover bit YES
387 rcontractusagenextmonthpercent float YES
388 rsplashtopemailtype int YES ((0))
389 rsplashtopemail nvarchar 255 YES
390 rsplashtopmacfield int YES
391 rssobypass2fa bit YES
392 RNinjaAlertWebhooks bit YES
393 radditionalresponseactioninfo bit YES
394 RQuoterDefaultTemplate nvarchar 100 YES
395 RQuoterInstanceUrl nvarchar 500 YES
396 RQuoterOpenContactForm bit YES ((0))
397 RQuoterCreateSOs bit YES ((0))
398 RQuoterInvoicePrefix nvarchar 100 YES
399 RQuoterEnableXeroLink bit YES ((0))
400 RenableMentionsCRM bit YES ((0))
401 rdefaultuserrole int YES ((-99))
402 rpreventclashchangelogging bit YES
403 rexactdefaultdivision int YES
404 rnewsearchtype int YES ((0))
405 rlimitactionsearch bit YES ((0))
406 rremovewelcomemessage bit YES ((0))
407 rappschallagents bit YES ((0))
408 renableagentcheckins bit YES ((0))
409 RNCentralMigrated bit YES
410 rnabledeletedevices bit YES
411 rallowuserimpersonation bit YES
412 rallowagentimpersonation bit YES
413 rcopyattachmentstoarea bit YES ((0))
414 rxerodefaultinvoicelinetax nvarchar 100 YES
415 REnableConfigChangeTracking bit YES ((0))
416 rdevopssyncsummary bit YES
417 rprepayinvoicebeforeuse bit YES
418 raddattachmenttags bit YES
419 rshowbackbutton bit YES
420 RSAMLIdPColour nvarchar 10 YES
421 RSAMLIdPLogo nvarchar -1 YES ('')
422 RAllowIdPInitiatedRequests bit YES ((0))
423 RAuthnRequestsSigned bit YES ((0))
424 rsplitcustomersarea bit YES
425 rhidecustomers bit YES
426 rfloatingcontactsite int YES ((0))
427 renableteammentions bit YES
428 rticketstatusafterquoteapproval int YES
429 rnaguser int YES
430 rnagtickettype int YES
431 rnagwarningpriority int YES
432 rnagcriticalpriority int YES
433 rnagassetipaddress int YES
434 rnagassethostname int YES
435 rbulkprivatenote bit YES ((0))
436 rbulkpublicnote bit YES ((0))
437 rshowopenjourneysintodo bit YES
438 rshowagentuserfieldsportal bit YES
439 rprepayusagenextmonthpercent int YES
440 rgroupservicestatus bit YES ((0))
441 rforceuser2fa bit YES ((0))
442 rquicktimedefaultsite int YES
443 rbulkslachange int YES ((0))
444 rassetshowsite bit YES ((1))
445 rassetshowkeyfield1 bit YES ((1))
446 rassetshowkeyfield2 bit YES ((1))
447 rassetshowkeyfield3 bit YES ((1))
448 ragentrestrictionsmigrated bit YES ((0))
449 RMigrateDataSourcePerms bit YES ((0))
450 RApprovalSignatureMigrated bit YES ((0))
451 SyncId nvarchar 50 YES ('')
452 rl0permmigrated bit YES
453 RTeamPhotosMigrated bit YES
454 raddigy_assettype int YES ((0))
455 rdefaultsalesforceuser int YES
456 rlansweeperupdateassetonly bit YES ((0))
457 RUnameCustomsMigrated bit YES ((0))
458 RAutomateTicketScriptEntityID int YES
459 rshowappointmentstatus bit YES ((0))
460 rshowappointmentlocation bit YES ((0))
461 rappointmentlocationtype int YES ((0))
462 RKbNtextMigrated bit YES ((0))
463 renablekbfulltextsearch bit YES ((0))
464 remaillistforpayments nvarchar 500 YES
465 RDroppedTwitterDetails bit YES ((0))
466 rworkspacedefaultgroup int YES
467 rworkspacedeletedevices bit YES ((0))
468 rworkspaceassettypefield int YES ((0))
469 rworkspaceintegratorimportlist nvarchar 200 YES
470 rworkspacedontupdateassettype bit YES ((0))
471 rcreateproratanormallines int YES ((0))
472 rroadmapcategory int YES
473 rsiteoverridetype int YES ((0))
474 rdattocommercemigrated bit YES
475 rdefaultcostperweight float YES
476 rdefaultpdftemplatekb int YES
477 rshowsiteselectclient bit YES ((0))
478 renableinvoiceapprovals bit YES
479 rninjarmmdeeplinkurl nvarchar 200 YES
480 rpagerdutywebhooktype int YES ((0))
481 RPagerDutyMigrated bit YES ((0))
482 rconnectwisecontrolclientfield int YES
483 rconnectwisecontrolsitefield int YES
484 rconnectwisecontroltoplevel int YES
485 rconnectwisecontrolassettypefield int YES
486 rconnectwisecontrolassetdefaultsite int YES
487 rconnectwisecontroldeletedevices bit YES
488 rconnectwisecontrolimportentities nvarchar 100 YES
489 rconnectwisecontroldefaultassettype int YES
490 rconnectwisecontrolmigrated bit YES
491 RTwilioAllowInbound bit YES ((0))
492 RTwilioTicketType int YES ((0))
493 RTwilioDefaultUser int YES ((0))
494 RTwilioReopenTickets bit YES ((0))
495 rdecimalplacesforinvoices int YES ((2))
496 rnewtickettypesavailabletoallcustomers bit YES ((0))
497 rappointmentnotificationbody nvarchar -1 YES ('You have a new appointment.

For: $area
Ticket ID: $faultid
Subject: $apsubject
From $apstartdate to $apenddate
Body: $apnote')
498 rmarkunassignedclosedalertsasread bit YES ((1))
499 rcreateproratainvoicesautomatically int YES ((0))
500 rrestrictitemsonpobysupplier bit YES ((1))
501 RAzureDevOpsMigrated bit YES ((0))
502 RtabNameType int YES ((0))
503 rloadattachmentsfromapitype int YES ((0))
504 rcalcincminprojectlevel bit YES
505 retilizecatalog nvarchar 400 YES
506 retilizelocale nvarchar 100 YES
507 rb2cazuretenantid nvarchar 1000 YES
508 rb2cazuressoappid nvarchar 1000 YES
509 rb2cenableazuresinglesignon bit YES
510 rb2cazureadsso int YES
511 rb2cazureautocreateusers bit YES
512 rb2cazureautocreationsite int YES
513 rb2cazureautoredirect bit YES
514 RAzureB2CMigrated bit YES
515 rpoCCaddress nvarchar 4000 YES
516 rpoBCCaddress nvarchar 4000 YES
517 rmandatoryapprovecomment bit YES ((0))
518 rexchangeappointmentsyncenddate int YES ((6))
519 rforwardagentfollower bit YES ((0))
520 raddedapptdeleteperm bit YES ((0))
521 renableimagepopout bit YES ((0))
522 rlansweeperrelationsync bit YES ((0))
523 RTableRestrictionAdded bit YES ((0))
524 radminextraread bit YES ((1))
525 rassetdisplaydata int YES ((0))
526 ruse_project_start_and_target_date_for_appointment_action bit YES ((1))
527 rprocessstreettickettype int YES
528 rprocessstreetuser int YES
529 RdbversionWebPre int YES
530 rshowmigrations bit YES ((1))
531 rsalesforceimportcasefeed bit YES ((0))
532 rtemplateconfigmigrated bit YES ((0))
533 rsuzukigateway nvarchar 255 YES ('')
534 rreleasesfromdevopsproject bit YES
535 rautoloaddependencychart bit YES ((1))
536 rchargerateroundmultorder int YES ((0))
537 rqbodisablecfsync bit YES
538 rqbocfdefinition nvarchar 10 YES
539 rqbocfname nvarchar 250 YES
540 rpreventuserchange bit YES ((0))
541 rdefaultshowgeneralusers bit YES ((1))
542 rdefaultshowdefaultsite bit YES ((1))
543 rdefaultshowagentusers bit YES ((1))
544 rdefaultshowinternalareas bit YES ((1))
545 cshowmodalscreenforcannedtext bit YES ((0))
546 RPrependTextToNotification bit YES ((1))
547 Rsplitactionemails int YES ((0))
548 RhtmlTemplateEditorType int YES ((0))
549 RAllowLiveChatTeams bit YES ((0))
550 RTeamsChatProfile nvarchar 50 YES
551 RTeamsChatTenants nvarchar 2000 YES
552 RTeamsOptionsStyle int YES ((0))
553 RTeamsChatWelcomeMessage nvarchar -1 YES ('Welcome to the Halo Chat Bot. Use the Start a conversation command to start a new conversation with me, or use the Help command for more information.')
554 RTeamsChatHelpMessage nvarchar -1 YES
555 rworkspacedefaultsite int YES
556 rfollowersscope int YES ((-1))
557 rccscope int YES ((-1))
558 radjustpriceforsoinvoice bit YES
559 rshowallforopplink bit YES
560 rintacctdefaultloctype nvarchar 100 YES
561 rintacctsynchaloid nvarchar 500 YES
562 rintacctdefaultwarid nvarchar 500 YES
563 rdefaultintacctsavelocation nvarchar 2000 YES
564 rintacctdonttaxpos bit YES
565 rintacctdefaultglgroup nvarchar 500 YES
566 rintacctdefaultmanualitemtype nvarchar 500 YES
567 rintacctdefaultautoitemtype nvarchar 500 YES
568 rintaccttaxonseparateline bit YES
569 rintaccttaxonseparatelineitem nvarchar 500 YES
570 rintacctcredittransdef nvarchar 500 YES
571 rintacctpotransdef nvarchar 500 YES
572 rintacctbilltransdef nvarchar 500 YES
573 rintacctsigtax bit YES
574 RIngramMicroMigrated bit YES ((0))
575 rallowusermerging bit YES ((0))
576 rdefaultpdftemplateinvoicetickets int YES
577 rdefaultpdftemplateinvoiceorders int YES
578 rdefaultpdftemplateinvoicerecurring int YES
579 rstripetakepaymentonduedate int YES ((0))
580 rhubspotdefaultlifecyclestage nvarchar 4000 YES
581 rEnableTeamsMsg bit YES ((0))
582 rdefaultteamsmsg nvarchar 255 YES ('Ticket ID: $FAULTID, Ticket Subject: $symptom')
583 rauditteamsmessage bit YES ((0))
584 ritsmtickettype int YES
585 RprMergeAction int YES ((0))
586 rsendnewuserswelcomeemail bit YES ((0))
587 rhidehaloinvoiceid bit YES ((0))
588 rdefaultquotercountryiso nvarchar 250 YES
589 rdefaultquoterregioniso nvarchar 250 YES
590 rremovelicenceswheninactive bit YES ((1))
591 rallowadditionalagentsontickets bit YES ((0))
592 ruserslabel nvarchar 100 YES ('Users')
593 rshowusernoteswhenempty bit YES ((0))
594 rshowsitenoteswhenempty bit YES ((0))
595 rshowareanoteswhenempty bit YES ((0))
596 rshowenduserdetailsopps bit YES ((0))
597 rlogicmonitordefaultsite int YES
598 rlogicmonitordefaultassettype int YES
599 rlogicmonitorenablealerting bit YES
600 rlogicmonitoralerttype int YES
601 rlogicmonitoralertuser int YES
602 rlogicmonitordeletedevices bit YES
603 rlogicmonitorimporttype int YES
604 rmaxparentdeps int YES ((-1))
605 rmaxchilddeps int YES ((-1))
606 rinvoiceitembillingdescriptionlong nvarchar 2000 YES ('')
607 rinvoiceitembillingdescriptionshort nvarchar 2000 YES ('')
608 rclientdefaultcolumns int YES ((-1))
609 rhideotherdepteams bit YES ((0))
610 RkbEditorRich bit YES ((1))
611 RkbEditorMarkdown bit YES ((0))
612 rchatimagetype int YES ((0))
613 RcognigyEndpoint nvarchar 100 YES
614 RConnectwiseAutomateAlertLastUpdated datetime YES ((0))
615 rcannedsuggestnewticket bit YES
616 rservicepermissiontype int YES ((0))
617 rincludeslaholdloadbalancing bit YES ((0))
618 rmilestoneupdatealldates bit YES
619 rmatchninjauser bit YES ((1))
620 ruselistgroups bit YES
621 RConnectWiseAutomateControlGUID nvarchar 300 YES
622 rallowquickuseradd bit YES ((0))
623 rlansweerassettypechoice int YES ((1))
624 rbarracudadefaultsite int YES
625 rbarracudadefaultassettype int YES
626 rbarracudaalertuser int YES
627 rbarracudaimporttype int YES
628 rbarracudadeletedevices bit YES
629 rbarracudaalerttype int YES
630 rlansweeperdefaultassettype int YES
631 rlansweeperassettypefield nvarchar 255 YES ('type')
632 rsuppcontractmandatory bit YES ((0))
633 rsearchfullticketids bit YES ((1))
634 rqualysusertype int YES ((0))
635 rgoogleworkspacenamedroles nvarchar -1 YES
636 roktanamedroles nvarchar -1 YES
637 rpreventparentchange bit YES ((0))
638 rplanningorangepercentage float YES ((50))
639 rplanningredpercentage float YES ((0))
640 rwhatsappcreatetickets bit YES
641 rwhatsappreopentickets bit YES
642 rwhatsapptickettype int YES
643 RSnowMigrated bit YES
644 rintacctuseapinvoice bit YES
645 rintacctusearinvoice bit YES
646 rintacctitemgroup int YES
647 rintacctdefaulttaxsol nvarchar 500 YES
648 ruseschedulingservice int YES ((0))
649 rchildtemplaterecursiondepth int YES ((3))
650 rsoftwareimportlicencematching bit YES ((0))
651 rshowslaonkanban bit YES ((0))
652 rsite24x7alerttype int YES
653 rsite24x7alertuser int YES
654 rresetsecuritystamps bit YES
655 rholidayapikey nvarchar 255 YES
656 rshowalllicforquantitycalc bit YES ((0))
657 rprepaypayinvoicebeforeuse bit YES
658 rnewusertemplate int YES ((-1))
659 rnewusertype int YES ((0))
660 rkaseyasyncagentsonly bit YES
661 rkaseyadefaultassettype_server int YES
662 rkaseyadefaultassettype_workstation int YES
663 rrecaptchatype int YES ((0))
664 rrecaptchathreshold float YES ((0.5))
665 rjamfinstancetype int YES ((0))
666 rjamfsitematchtype int YES ((0))
667 raddedagentcostperm bit YES
668 rprepayitemid int YES ((0))
669 rpercentinvoicedmigrated bit YES ((0))
670 rshowservicescosts bit YES
671 rshowservicescostsendusers bit YES
672 rexcludenonticketapptodo bit YES ((0))
673 rpohideitempopup bit YES
674 rmergesalesorderinvoicessite bit YES
675 rshowintelrouting bit YES
676 rshowintelroutingonactions bit YES
677 rintelroutingmaxtickets int YES ((5))
678 rintelroutingcutoffdays int YES ((30))
679 rcloseallchildren bit YES
680 rshowtraveltimesheet bit YES
681 RSetupTabMigrated bit YES ((0))
682 rshowfeedbackcaptcha bit YES
683 rrecaptchaisenterprise bit YES
684 rcallchargerate int YES ((-1))
685 rusestripereceiptemails bit YES
686 rinvoicecreationengine int YES ((1))
687 rshowponumonapproval bit YES ((1))
688 rmultientitysearchincludecontracts bit YES
689 rhideaddtoprojectandcreatechild bit YES ((0))
690 rtimefieldstoshowontimesheet int YES ((0))
691 RshowJsonExportButton bit YES ((0))
692 rissueditemsdesclong nvarchar 2000 YES ('')
693 roverridefeedbacklink bit YES ((0))
694 rprtgmigrated bit YES ((0))
695 rallowuserdrafts bit YES ((0))
696 ricingadefaultsite int YES ((0))
697 ricingadefaultgroup int YES ((0))
698 ricingaassettypefield int YES ((0))
699 ricingadefaultassettype int YES ((0))
700 ricingaimporttype int YES
701 ricingadeletedevices bit YES ((0))
702 ricingaselfsignedcert bit YES ((0))
703 ricingaalerttype int YES
704 ricingaalertuser int YES
705 ricingaenablealerting bit YES ((0))
706 renabledocumentpreviewer bit YES ((0))
707 raddigydontimportsoftware bit YES ((0))
708 RConvertIntegrationRoles bit YES ((0))
709 rcustomersdefaultview int YES ((-1))
710 rusersdefaultview int YES ((-1))
711 rcustomertreeviewmigrated bit YES ((0))
712 RdefaultNavScreenLayout int YES ((0))
713 rcreateuserifgeneraluser bit YES ((1))
714 RMultiSeriesMigrated bit YES ((0))
715 rshowpipelinestages bit YES ((0))
716 rdefaultpipelinestage int YES ((1))
717 rnavbarnewcall bit YES
718 rshowuserscontractsonticketonly bit YES ((0))
719 rassetpermissiontype int YES ((0))
720 rbeyondtrustinstancetype int YES ((1))
721 rcontractdefaultcolumns int YES ((-1))
722 rsitedefaultcolumns int YES ((-1))
723 rusersdefaultcolumns int YES ((-1))
724 rjamfdontupdateassettype bit YES ((0))
725 rquotehideitempopup bit YES
726 rsohideitempopup bit YES
727 rcookiemessage nvarchar 4000 YES
728 ractiondatedisplay int YES ((1))
729 rbillingcontactinfoonportal bit YES ((0))
730 rrhipesubscriptionclient int YES
731 rfollowupappointmentsubject bit YES ((0))
732 rusechargeforbudg bit YES
733 raddedreportpublishperm bit YES
734 rshowdeviceoninvoiceline bit YES ((0))
735 ruserticketprofile int YES
736 ruserprojectprofile int YES
737 rassetreturnstatus int YES ((-1))
738 rspellchecksuggestionscore decimal YES
739 rloadrinvoiceslines bit YES ((1))
740 rjamfmigrated bit YES
741 rshowcalllogonticket bit YES ((0))
742 radminoverridequickstatuschange bit YES ((0))
743 rcreatesoonquoteapproved bit YES ((0))
744 radditionalagentsonticketstype int YES ((0))
745 rshowtoplevelaccessportaloption bit YES ((1))
746 rshowallaccessportaloption bit YES ((1))
747 raddedinvoicecreateperm bit YES
748 rdonttrackleavesite bit YES ((0))
749 Rtimesensitivemethod int YES ((0))
750 rmeterminqty float YES
751 rshowkbmenu bit YES ((1))
752 ruseoutgoingservice bit YES ((0))
753 rlasttaskschedulerundate datetime YES ((0))
754 radminsecurityprompt int YES ((0))
755 rhalonewssandbox int YES ((0))
756 radminsaccessallreports bit YES ((1))
757 ricingacomment nvarchar 500 YES ('')
758 rsyncicingacomment bit YES ((0))
759 RIcingaAssetTypeChoice int YES ((1))
760 ropennewquoteinnewtab bit YES ((1))
761 rdefaultaideployment nvarchar 50 YES
762 rconnectwisermmdefclient int YES
763 rconnectwisermmdefxtype int YES
764 rconnectwisermmtoplevel int YES
765 rconnectwisermmddeletedevices bit YES
766 rconnectwisermmimportentities nvarchar 500 YES
767 RshowEventsTabForAdmins bit YES
768 rcreateproratainvautononcalcqty int YES ((0))
769 rsalesorderstatusafterinvoicedeleted int YES ((-1))
770 rshowrelatedofrelated bit YES ((0))
771 rinvertactionhistory bit YES ((0))
772 RenableKBDraftsNews bit YES ((0))
773 rkbdrafttickettypenews int YES ((0))
774 rzabbixmigratedxtypemappings bit YES
775 rshopifycustomerimporttype int YES ((0))
776 rshopifydefaultsite int YES ((1))
777 rshopifyintegratorcustomerslastsync datetime YES ((0))
778 rshopifyintegratororderslastsync datetime YES ((0))
779 rshopifyintegratorentitiestoimport nvarchar 500 YES
780 recommerceshowordersarea bit YES
781 rdevice42preventdeviceimport bit YES ((0))
782 ractionvismigrated bit YES ((0))
783 rstripemanualpaymentmethodoptions nvarchar 1000 YES
784 rlogactionresponsesonactionsubmit int YES ((0))
785 rxensamdefaultsite int YES
786 rxensamdefaultgroup int YES
787 rxensamdefaultassettype int YES
788 rxensamintegratorentitiestoimport nvarchar 500 YES
789 rxensamdeletedevices bit YES ((0))
790 rxensamdontupdateassettype bit YES ((0))
791 rxensamassettypechoice int YES ((1))
792 rxensamassettypefield nvarchar 255 YES ('type')
793 rxensamassettypefielddatacentre nvarchar 255 YES ('os_type_name')
794 ruseembeddingscoresazureopenai bit YES
795 ruseembeddingscoresopenai bit YES
796 RUseIncomingService bit YES ((0))
797 rautoaddbreaktime bit YES ((0))
798 rautoaddbreaktimedatechecked datetime YES ((0))
799 rautoaddbreakminutestoadd int YES ((30))
800 rautoaddbreakhourlimit int YES ((4))
801 rsidemenudashboardid int YES ((-1))
802 RAteraAlertMethod int YES ((0))
803 RAddigyAlertMethod int YES ((0))
804 RAutomateAlertMethod int YES ((0))
805 rdattormmalertmethod int YES ((0))
806 RConvertIntegrationCabs bit YES ((0))
807 rsuppliersdefaultview int YES ((-1))
808 RControlMode int YES ((0))

FIELD (44 columns)

# Column Type Length Nullable Default
1 Ykind nvarchar 1 NO
2 Yseq int NO
3 Yname nvarchar 4000 YES
4 Yvalidate nvarchar 2 YES
5 Ysystemuse int YES
6 yidstring nvarchar 4000 YES
7 ydatafrom int YES ((0))
8 ydatalength int YES ((0))
9 YIsSoftware bit NO ((0))
10 YOrder int YES ((0))
11 YLookupID int YES ((0))
12 YIsMandatory bit NO ((0))
13 Ychangeseq int YES ((0))
14 YShowOnCalendar bit YES ((0))
15 YMoveUpdateType int NO ((0))
16 YInactiveUpdateType int NO ((0))
17 YMoveUpdateDefault nvarchar 400 YES ('')
18 Yshowonactivity bit YES ((0))
19 Yurl nvarchar 500 YES ('')
20 yparentassettype int YES ((0))
21 YOrderValuesAlphanumerically bit YES ((1))
22 YGUID uniqueidentifier YES (newid())
23 yhint nvarchar 4000 YES
24 yhinttype int YES
25 yshowonrelationshipedit bit YES
26 ynochangehistory bit YES
27 Yextratype int YES
28 Ylookupmethod int YES
29 Yloadtype int YES
30 Ysqlconnectiontype int YES
31 Ysqlserver nvarchar 250 YES
32 Ysqldatabasename nvarchar 250 YES
33 Ysqluser nvarchar 250 YES
34 Ycertificateid int YES
35 Ysqllookup nvarchar 250 YES
36 Ywheresql nvarchar 2000 YES
37 Yoimid int YES
38 Yoimvid int YES
39 Yvalueproperty nvarchar 250 YES
40 Ydisplayproperty nvarchar 250 YES
41 Yaddunknown bit YES
42 Yordervaluesby int YES
43 Ymaxselection int YES
44 Ysqlpassword int YES

FIELDINFO (94 columns)

# Column Type Length Nullable Default
1 FIid int NO
2 FIName nvarchar 4000 YES
3 FILabel nvarchar 4000 YES
4 FIHint nvarchar 4000 YES
5 FILookup int NO ((0))
6 FIType int NO ((0))
7 FICustom int NO ((0))
8 FIusage int YES ((0))
9 FIshowontabID int YES ((0))
10 FIDetailTableID int YES ((0))
11 FIReadOnly bit YES ((0))
12 FIAddUnknown bit YES ((0))
13 FIExtraType int YES ((-1))
14 FICalcField nvarchar 4000 YES ('')
15 FIChangeSeq int YES ((0))
16 FICharacterLimit int YES ((0))
17 FICharacterLimitType int YES ((0))
18 FIInputType int YES ((0))
19 FIcopytochild bit YES ((1))
20 FIDefaultValue nvarchar 4000 YES
21 FIJiraFieldName nvarchar 400 YES ('')
22 FILinkedField int NO ((0))
23 FIsearchable bit YES ((1))
24 FIordervaluesalphanumerically bit YES ((0))
25 fisummary nvarchar 255 YES ('')
26 FIHideForEndUserTable bit YES ((0))
27 FIScriptToRun nvarchar 4000 YES ('')
28 FIUserSearchable bit YES ((1))
29 FISQLLookup nvarchar 4000 YES ('')
30 ficopytochildonupdate bit YES ((0))
31 fiImportAlias nvarchar 255 YES ('')
32 FIhyperlink nvarchar 500 YES ('')
33 fishowintable bit YES ((1))
34 FIGroupName nvarchar 255 YES ('')
35 fiShowHintOnDetails bit YES ((0))
36 fishowondetailsscreen bit YES ((0))
37 FIselectionFieldId int YES ((0))
38 FIvariableFormat1 nvarchar 1000 YES
39 FIvariableFormat2 nvarchar 1000 YES
40 ficustomextratableid int YES ((0))
41 FICopyToRelated bit YES ((0))
42 fDefaultDate int YES ((0))
43 fideleteafterclosure bit YES ((0))
44 fideleteafterclosuredays int YES ((-1))
45 FIcalendarSearchable bit YES ((0))
46 ficalculation nvarchar 4000 YES ('')
47 FIonlyShowForAgents bit YES
48 fimandatory bit YES
49 firegex nvarchar 4000 YES ('')
50 fiordervaluesby int YES
51 fiexcludefromallfields bit YES ((0))
52 fiinheritacfromtickettype bit YES
53 FIGUID uniqueidentifier YES (newid())
54 fiishorizontal bit YES ((0))
55 FIShowOnCrmNote bit YES
56 fiisencrypted bit YES ((0))
57 FItableHeight int YES
58 FIsqlconnectiontype int YES ((1))
59 FIsqluser nvarchar 250 YES
60 FIsqlpassword nvarchar 250 YES
61 FIsqlserver nvarchar 250 YES
62 FIsqldatabasename nvarchar 250 YES
63 FIcertificateId int YES ((0))
64 fimaxselection int YES
65 fihinttype int YES ((0))
66 fidefaultdays int YES
67 finewstoragemethod bit YES ((0))
68 fiwheresql nvarchar 2000 YES
69 filoadtype int YES ((0))
70 firounding int YES ((-1))
71 fihidefromfilters bit YES
72 filookupmethod int YES ((0))
73 fioimid int YES
74 fioimvid int YES
75 fidisplayproperty nvarchar 250 YES
76 fivalueproperty nvarchar 250 YES
77 ficopytoparent bit YES
78 ficopytoparentonupdate bit YES
79 fishowinpool bit YES
80 fiallowpooloverride bit YES
81 fisimplifyrich bit YES
82 fidetailscolumngroup int YES
83 ficalculatevariablesinvalue bit YES
84 fiStoreInFieldData bit YES
85 fiaddrowpervalue bit YES
86 fisequence int YES
87 fiusenonintegeridentifier bit YES
88 fifirstvaluedefault bit YES
89 fipopulatevariablesinpdfandemail bit YES
90 ficopytoparentnewticket bit YES
91 ficopytograndchildonupdate bit YES
92 FIentityrestriction bit YES
93 fionlyvalidateoncreation bit YES
94 FIentity nvarchar 50 YES
Back to top