Skip to main content

Ticket Configuration - Key Tables

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

CATEGORYDETAIL (14 columns)

# Column Type Length Nullable Default
1 CDid int NO
2 CDCategoryName nvarchar 4000 YES ('')
3 CDType int YES ((0))
4 CDSLAid int YES ((-1))
5 CDseriousness int YES ((-1))
6 cdratedef int YES ((-1))
7 CDchangeseq int YES ((0))
8 cdgroup int YES ((0))
9 cdincludenote bit YES ((0))
10 cdnote nvarchar 1000 YES ('')
11 cdusernote nvarchar 1000 YES ('')
12 citilrequesttype int YES ((0))
13 CDGUID uniqueidentifier YES (newid())
14 cdallowaisuggestion bit YES

REQUESTTYPE (357 columns)

# Column Type Length Nullable Default
1 RTid int NO
2 RTSortseq int YES
3 rtdesc nvarchar 4000 YES
4 RTVisible bit NO ((0))
5 RTEndUsersCanSelect bit NO ((0))
6 RTIncludeInSLA bit NO ((0))
7 RTDefSection nvarchar 4000 YES
8 RTDefCat2 nvarchar 4000 YES
9 RTDefCat3 nvarchar 4000 YES
10 RTDefCat4 nvarchar 4000 YES
11 RTDefCat5 nvarchar 4000 YES
12 RTDefSeriousness int YES
13 RTDefInitialStatus int YES
14 RTDefTech int YES
15 RTRequestType int YES ((0))
16 RTexcludefromSLA bit NO ((0))
17 RTShowOnWeb bit NO ((-1))
18 RTcalcFixbydate bit NO ((0))
19 RTAutoStartApproval int YES ((0))
20 RTtargetopen float YES ((0))
21 RTSLAid int YES ((-1))
22 RTInformAccountManager bit NO ((-1))
23 RTChargeRate int YES ((-1))
24 RTMailboxid int YES ((0))
25 RTcalcolour int YES ((16777215))
26 RTIsOpportunity bit NO ((0))
27 RTStatusAfterUserUpdate int YES ((-1))
28 RTClosedRequestsWithUpdates int YES ((0))
29 RTIncludeInMobileDBsync bit NO ((-1))
30 RTqr2filename nvarchar 4000 YES
31 RTWorkFlowID int YES ((0))
32 RTBccToAddress nvarchar 4000 YES
33 RTIsProject bit NO ((0))
34 RTreopenedstatus int YES ((-1))
35 RTMinCredit float YES ((0.00))
36 rtIsPurchaseRequisition bit YES ((0))
37 RTScriptID int YES ((0))
38 RTQuoteID int YES ((0))
39 RTDeliverToUs bit YES ((0))
40 RTQuoteQR2FileName nvarchar 4000 YES ('')
41 RTcat2 varchar -1 YES
42 RTcat3 varchar -1 YES
43 RTcat4 varchar -1 YES
44 RTcat5 varchar -1 YES
45 rtGID nvarchar 4000 YES ('')
46 rtGIDEND nvarchar 4000 YES ('')
47 rtprintrequestdetails bit YES ((0))
48 rtprintserviceform bit YES ((0))
49 RTDefaultSendAck int YES ((0))
50 RTDefaultSendEmail bit YES ((1))
51 RTIsRMA bit YES ((0))
52 RTchangeseq int YES ((0))
53 rtclosedrequestsemailID int YES ((180))
54 RThiderespondbtn bit YES ((0))
55 RTDefaultSubject nvarchar 500 YES ('')
56 RTQuickCaption nvarchar 1000 YES ('')
57 RTKBonclose int YES ((0))
58 RTwebannouncement nvarchar -1 YES
59 RTUsercanaddattachments int YES ((0))
60 RTAlwaysAvailableInSearch bit YES ((0))
61 RTJiraIssueType nvarchar 255 YES ('')
62 RTDefaultDetails nvarchar -1 YES
63 RTDontSendSLAReminders bit YES ((0))
64 RTStatusAfterEndUsersRequestsClosure int YES ((-1))
65 rtTechMustChoosePriority bit YES ((0))
66 RTStatusAfterTechUpdate int NO ((1))
67 rtallowallactions bit YES ((1))
68 rtallowallstatus bit YES ((1))
69 rtallowallcat2 bit YES ((1))
70 rtallowallcat3 bit YES ((1))
71 rtallowallcat4 bit YES ((1))
72 rtallowallcat5 bit YES ((1))
73 rtdefproduct int YES ((0))
74 RTHideUserDefFields int NO ((0))
75 RTHideDateOccured int NO ((0))
76 RTHideSLAFields int NO ((0))
77 RTHideAssigned int NO ((0))
78 RTHideStatus int NO ((0))
79 RTHideReportedBy int NO ((0))
80 RTHideTimeTaken int NO ((0))
81 RTPartsLookupID int NO ((0))
82 RTAcknowledgementTemplate int YES ((0))
83 RTAcknowledgementTemplateOOH int YES ((0))
84 RTStatusAfterSupplierUpdate int YES ((-1))
85 RTAppointmentNoteBlob image 2147483647 YES
86 RTAppointmentDefaultBody int NO ((0))
87 RTAppointmentNoteHTML nvarchar -1 YES
88 rtgroupid int YES ((0))
89 rtagentscanselect bit YES ((1))
90 RTClosedUserUpdateHours float YES ((0.00))
91 RTApplyDefaultsOnTypeChange int YES ((0))
92 RTdefaultestimate float YES ((0.00))
93 RTmustclosechildbeforeclosure bit YES ((0))
94 rtdefbudgettype int YES ((0))
95 RTdefsectiontoagentsdefault bit YES ((0))
96 RTDefaultSendRemoteInvite int YES ((0))
97 RTLogTimeInDays bit YES ((0))
98 RTLogTimeInDaysIncrement float YES ((0.50))
99 RTUseTimeslotsForStartAndTargetTimes bit YES ((0))
100 RTChildTicketColumnsOverride int YES ((0))
101 rtshowunborntab bit YES ((0))
102 rtallowcustomiseunborn bit YES ((0))
103 rtallowattachments bit YES ((1))
104 rtdontusependingclosure bit YES ((0))
105 rtallowtickettypetobechild bit YES ((1))
106 RTShowKBPrompt bit YES ((1))
107 RTAllowCSVUserUpload bit YES ((0))
108 RTCSVTableID int NO ((0))
109 RTAutoForwardEmailUpdates int NO ((0))
110 RTpdftemplateid int YES ((0))
111 rtanonymouscanselect bit YES ((0))
112 RTmaximumRestrictedPriority int YES ((0))
113 RAutoRespondLoggedManually int YES ((0))
114 RTclosedrequestreplylimit int YES ((0))
115 rtautoclosehours int YES ((0))
116 RTPortalCanReopen bit YES ((1))
117 RToverrideWithTheFollowingTemplateWhenLoggingManually int YES ((-1))
118 RTeditServStatus bit YES ((0))
119 RTallowVoting bit YES ((0))
120 RTsetRelatedServicesFromAssets bit YES ((0))
121 rtdefaultmatchedkbid int YES ((0))
122 RTDefaultSendToSOC int YES ((0))
123 RTDefaultSOCTargetType int YES ((0))
124 RTDefaultSOCTargetId nvarchar 100 YES ('')
125 RTDefaultSOCTargetName nvarchar 150 YES ('')
126 RTForwardInboundUpdates bit YES ((0))
127 rtDefaultApptSummary nvarchar 4000 YES ('')
128 rtDefaultApptDetails nvarchar -1 YES
129 RTDisplayOnQuickTime bit YES ((1))
130 RTisSprint bit YES ((0))
131 rtstatusafterapproverupdate int YES ((-1))
132 rtdisplayaudittab bit YES ((0))
133 RTOverwriteShowForUsers bit YES ((0))
134 RTShowDownvote bit YES ((1))
135 RTDefaultChangeInformationHtml nvarchar -1 YES
136 RTDefaultJustification nvarchar 4000 YES ('')
137 RTDefaultImpact int YES ((0))
138 RTDefaultImpactDescription nvarchar 4000 YES ('')
139 RTDefaultRiskLevel int YES ((0))
140 RTDefaultRiskLevelDescription nvarchar 4000 YES ('')
141 RTDefaultTestPlan nvarchar 4000 YES ('')
142 RTDefaultBackoutPlan nvarchar 4000 YES ('')
143 RTDefaultCommunicationPlan nvarchar 4000 YES ('')
144 RTIsBillable bit YES ((1))
145 rtAddActionsToLinked int YES ((3))
146 rtAddNoteOnlyToLinked bit YES ((0))
147 RTdefaultResourceType int YES ((0))
148 RTShowDevOpsID bit YES ((0))
149 RTdefaultListType int YES ((0))
150 RTdefaultTab int YES ((0))
151 rtpendingrequestswithupdates int YES ((0))
152 RTpendingrequestreplylimit int YES
153 rtpendingrequestsemailID int YES ((0))
154 RTpendingUserUpdateHours float YES ((0))
155 RTClosedRequestsWithUpdatesIncPending bit YES ((0))
156 rtdefaultsynctosentinel bit YES
157 RTAddUserUpdatesToChildren bit YES ((0))
158 RTDefaultTargetDate int YES ((-1))
159 rtresourcebookingtypeagent int YES ((0))
160 rtuserbookfromportal bit YES ((0))
161 RTdefaultResourceTypeAgent int YES ((0))
162 rtshowopenusertickets bit YES
163 rtshowopensitetickets bit YES
164 rtshowopenclienttickets bit YES
165 rtattendeesenduser int YES ((1))
166 rtupdateservicestatus bit YES
167 rtdefaultservicestatusnote nvarchar 4000 YES
168 RTshowAutomationsTab bit YES
169 rtshowoppcontacttab bit YES
170 RTDefaultAgentResourceBookingDuration int YES ((0))
171 rtsubmitlabeloverride nvarchar 50 YES ('')
172 rtshowactivestatuskanban bit YES ((1))
173 rtkanbanstatuschoice_list nvarchar 4000 YES
174 rtallowallappointmenttypes bit YES ((1))
175 rtincludeappsscheduledhours bit YES ((0))
176 rtganttgrandchildview int YES ((0))
177 rtticketlinktype int YES
178 rtalluserscanview int YES ((0))
179 rtdefaultsynctosalesforce bit YES
180 rtsalesforcedefaultstage int YES ((1))
181 rtshowaddnote bit YES ((1))
182 rtcopyattachmentstochild bit YES ((0))
183 rtautodeletedata int YES ((0))
184 rtautodeletedays int YES
185 rtshowchildtaskstype int YES
186 rtpinimportantactions bit YES ((0))
187 rtshowdecendantwarningoptions bit YES ((0))
188 rtshowbillingtab bit YES ((1))
189 rtstatusafterresourcebook int YES ((0))
190 rtallowlogonbehalfof int YES ((-2))
191 rtparentstatusafterallchildclosed int YES
192 rtautocreateappt int YES
193 rthideanoncontactinfo bit YES
194 rtticketcreatedoverride nvarchar 200 YES
195 rtallowanonymouslogging bit YES
196 rtpublishedid nvarchar 500 YES
197 RTnewrequestmessage nvarchar 4000 YES
198 rtaddackattachments bit YES
199 RTGUID uniqueidentifier YES (newid())
200 rtshowuserfeed bit YES
201 rtdefaultpagerdutyservice nvarchar 500 YES
202 rtdefaultsidebarcollapsed bit YES ((0))
203 rtlogonbehalflabeloverride nvarchar 255 YES
204 rttabdisplay int YES ((0))
205 RTsprintTicketType int YES ((0))
206 rtenableusermentions bit YES
207 rtusemilestones bit YES
208 rtsladontclose bit YES
209 rtpendingdontclose bit YES
210 rtminattachments int YES
211 rtenableforecasting bit YES
212 rtmakeccfollowers bit YES
213 rtdefaultkanbanview int YES ((0))
214 rtshowgeneralsurveyfields bit YES ((1))
215 rtdefaultsendtopagerduty bit YES ((0))
216 rtcompletionstatustype int YES ((0))
217 rtshowprojecttaskdates bit YES ((0))
218 rtprojecttype int YES ((0))
219 rtallowallteam bit YES ((1))
220 rtdefaultissensitive bit YES ((0))
221 rtprocessopentickets int YES ((0))
222 rttodolistportalvisibility int YES ((0))
223 rtdefaultappttype int YES ((0))
224 rtshowchildassets bit YES ((0))
225 rtallowalliframecustomtabs bit YES ((0))
226 RThideanonphonenumber bit YES
227 RTshowconfirmemail bit YES
228 rtticketstatusafterappointment int YES ((-1))
229 RTshowopendevicetickets bit YES
230 rtdontconfirmupdateparent bit YES ((0))
231 rtmaxopenperuser int YES
232 rtmaxtotalperuser int YES
233 rtmilestonebilling bit YES
234 rtshowsuggestionstab bit YES ((0))
235 rtshowopensuppliertickets bit YES ((0))
236 rtallowallsuggestionfaqlists bit YES ((1))
237 rtstartdatevalidation int YES ((-1))
238 rtstartdatevalidationdays int YES
239 rttargetdatevalidation int YES ((-1))
240 rttargetdatevalidationdays int YES
241 rtautocontributor bit YES
242 RTAllowTeamsChatCreation bit YES ((0))
243 RTTeamsChatDefaultName nvarchar 250 YES ('$FAULTID - $SYMPTOM')
244 RTShowTeamsChatsAsTabs bit YES ((0))
245 rtenabletaskdependencies bit YES
246 rtcopyattachmentstorelated bit YES ((0))
247 rtdefaultservicenowtype int YES ((0))
248 rtlapsafestatusafterwebhook int YES
249 RTshowStatusOnPortal bit YES ((1))
250 rtshowvotecomment bit YES ((1))
251 rtexcludefromsalesmailboxmatch bit YES
252 RTAllowSlackChannelCreation bit YES ((0))
253 RTSlackChannelDefaultName nvarchar 250 YES ('halo-$faultid')
254 RTShowSlackChannelsAsTabs bit YES ((0))
255 RTSlackChannelAccessType int YES ((-1))
256 RTSlackChannelWorkspace int YES ((-1))
257 RThideAnonEmail int YES ((0))
258 rtquotepdftemplateid int YES ((0))
259 rtcontinueautorelease bit YES ((1))
260 rtitemsarebillable bit YES ((1))
261 rtdoaisurvey bit YES ((0))
262 rtenduserscanlog bit YES ((1))
263 rtanonymouscanlog bit YES ((1))
264 RTgenerateAIEmbeddings bit YES ((0))
265 rtloadbalanceinterval int YES ((0))
266 rtloadbalancemaxtickets int YES ((-1))
267 rtloadbalanceonschedule bit YES ((0))
268 rtallowallchildtickettypes bit YES ((1))
269 rtportalsummaryhintplaceholder bit YES ((0))
270 rtportaldetailshintplaceholder bit YES ((0))
271 rtagentsummaryhintplaceholder bit YES ((1))
272 rtagentdetailshintplaceholder bit YES ((1))
273 rtportalscreenafterlogging int YES ((0))
274 rtshowotheropenticketsinnewtab bit YES ((0))
275 rtapplyworkflowontypechange bit YES ((1))
276 rtshowrelatedofrelated int YES ((0))
277 rthideuserdetails bit YES
278 rtinheritparentcategory1 bit YES
279 rtinheritparentcategory2 bit YES
280 rtinheritparentcategory3 bit YES
281 rtinheritparentcategory4 bit YES
282 rtdefaultisdowntime bit YES
283 rtaddrelatedassetstoparent bit YES
284 rtthirdpartymigrationid nvarchar 100 YES
285 rtwaittimetype int YES ((0))
286 rtdefaultwaittime float YES
287 rtwaittimecalchours int YES ((24))
288 rtshowallrelated int YES ((0))
289 rtallowanonattachments bit YES
290 rtpromptfortechchild bit YES
291 rtloadbalancemaxticketsthistypeonly bit YES
292 rtloadbalancemaxticketsagentspecific bit YES
293 RTticketDetailsHeaderWidget1 int YES ((-1))
294 RTticketDetailsHeaderWidget2 int YES ((-1))
295 RTticketDetailsSideBarContent int YES ((0))
296 RTticketDetailsSideBarMax int YES ((2))
297 RTticketDetailsHeaderIconColourType int YES ((0))
298 RTticketDetailsHeaderIconOverride nvarchar 50 YES ('')
299 RTticketDetailShowTicketIdInHeader bit YES ((1))
300 rtappointmentscheduleoverride int YES ((0))
301 rtmilestonebillingtype int YES ((0))
302 rtcreateteamschatuseenduser bit YES
303 rtagentclosedrequestswithupdates int YES
304 rtagentpendingrequestswithupdates int YES
305 rtenablequotecountersigning bit YES
306 rtsendcountersignedquote bit YES
307 rtcountersignedtemplateid int YES
308 rtlinkaimatchedtickets bit YES
309 rtrisktype int YES ((0))
310 rtriskcalculation nvarchar 1000 YES
311 rtallowallchargerates bit YES ((1))
312 rtcloseduserupdatehoursuseworkinghours int YES ((1))
313 rtpendinguserupdatehoursuseworkinghours int YES ((1))
314 rtloadbalancemaxticketsteamspecific bit YES
315 rtonlysendreplytoincomingemail bit YES
316 rtitiltypematchedtickets bit YES
317 rtallowassetlinkedit bit YES
318 rtdefaultstartdate int YES ((-1))
319 rtuserstartchatfromticket bit YES
320 rtportalcolumns int YES ((1))
321 rthideopeningaction bit YES
322 rtportalmultipage bit YES
323 rtportalassetcolumnprofileid int YES ((-1))
324 RTportalallowdrafts bit YES
325 rtallowallclients bit YES
326 rtenableclosefieldsonnewrequest int YES ((0))
327 rtproblemmatchagent int YES ((1))
328 rtproblemmatchuser int YES ((1))
329 rtsendcountersignrequest bit YES
330 rtcountersignreqagentid int YES
331 rtassignapptagentstoadditionalagents bit YES
332 rtteamschatclosuremessage int YES ((-1))
333 rtapprovalactionuservisibility int YES ((0))
334 RTresourcebookingagentremindertime int YES
335 RTresourcebookinguserremindertime int YES
336 RTresourcebookingagentremindertemplateid int YES
337 RTresourcebookinguserremindertemplateid int YES
338 RTmustSetCustomerFirst int YES ((0))
339 rtcalculatedatesfromchildren bit YES
340 rtautoloadbalanceonclose bit YES
341 rthidesendonquote bit YES
342 rtmandatoryanonphonenumber int YES ((-1))
343 rtchildticketfilterid int YES
344 rtshowgrandchildren int YES ((0))
345 rtagentappcolumns int YES ((4))
346 rtdefaultfilterotheropentickets int YES ((-1))
347 RTallowallpipeline bit YES ((1))
348 rtuseforestimateforecasting bit YES
349 rtshowraterestrictions bit YES
350 rtonlyvalidatestartdateoncreation bit YES
351 rtonlyvalidatetargetdateoncreation bit YES
352 rtfieldstocopytochildren int YES
353 rtuseaiackemails bit YES
354 rtaiackprompt nvarchar 4000 YES
355 rtaiacknowledgementtemplate int YES
356 rtrelatedcicolumnprofile int YES ((-1))
357 rtpreventuserchangeduringapprovals int YES ((-1))

REQUESTTYPEFIELD (34 columns)

# Column Type Length Nullable Default
1 RTFid int NO
2 RTFRTid int NO ((0))
3 RTFFieldId int NO ((0))
4 RTFSeq int NO ((0))
5 RTFTableID int YES ((0))
6 rtfgroupid int YES ((0))
7 rtfendusernew int YES ((0))
8 rtfenduserdetail int YES ((0))
9 rtftechnew int YES ((0))
10 rtftechdetail int YES ((0))
11 RTFtechnewlocation int YES ((0))
12 RTFRestrictUpdate bit YES ((0))
13 RTFLabelOverride nvarchar 1000 YES ('')
14 RTFBoldLabelAndValue bit YES ((0))
15 rtfenduserdetailhideifempty bit YES ((0))
16 rtftechdetailhideifempty bit YES ((0))
17 rtfcopytochild bit YES ((0))
18 rtfcopytorelated bit YES ((0))
19 rtfenduserdetailrejected int YES ((0))
20 rtftechtabid int YES ((-1))
21 rtfshowdependency bit YES
22 rtfrestrictread bit YES ((0))
23 rtfcopytochildonupdate bit YES ((0))
24 rtfchatmessage nvarchar 1000 YES
25 rtftechaction int YES
26 rtfenduseraction int YES
27 rtfendusercheckboxmandatory bit YES
28 rtfdisplaytype int YES ((0))
29 rtfusage int NO ((0))
30 rtfcopytoparent bit YES
31 rtfcopytoparentonupdate bit YES
32 rtfagentcheckboxmandatory bit YES
33 RTFagentbookingdetail int YES
34 rtfcopytoparentnewticket bit YES

STDREQUEST (413 columns)

# Column Type Length Nullable Default
1 stdid int NO
2 stdsymptom ntext 1073741823 YES
3 stdseriousness int YES
4 stdestimate money YES
5 stdcat2 nvarchar 4000 YES
6 stdcat3 nvarchar 4000 YES
7 stdshowonweb bit NO ((0))
8 stdtype int YES
9 stdsite int YES ((0))
10 stdassignedtoint int YES ((0))
11 stdusername nvarchar 4000 YES
12 stdtime datetime YES
13 stdlastcreated datetime YES
14 stdstatus int YES ((0))
15 stdinformlevel int YES ((0))
16 stddom int YES ((0))
17 stdmon int YES ((0))
18 stdtue int YES ((0))
19 stdwed int YES ((0))
20 stdthu int YES ((0))
21 stdfri int YES ((0))
22 stdsat int YES ((0))
23 stdsun int YES ((0))
24 stdneedsinvoice bit NO ((0))
25 stdcat4 nvarchar 4000 YES
26 stdcat5 nvarchar 4000 YES
27 stdsymptom2 ntext 1073741823 YES
28 stdyear int YES ((0))
29 stddaysplus int YES ((0))
30 stdevery int YES ((0))
31 stdsection nvarchar 4000 YES
32 stdreportid int YES ((0))
33 stdgroup int YES ((0))
34 stdreportperiod int YES ((0))
35 stdreportarea int YES ((0))
36 stdreportsite int YES ((0))
37 stddisabled bit NO ((0))
38 StdRequestTypeDef int YES ((1))
39 STDexcludefromSLA bit NO ((0))
40 STDRepeat int YES ((0))
41 stdtoplevel int YES ((0))
42 stdAPid int YES ((0))
43 stdEmailsubject ntext 1073741823 YES
44 stdEmailBody ntext 1073741823 YES
45 stdEmailto ntext 1073741823 YES
46 stdEmailcc ntext 1073741823 YES
47 stdkbid int YES ((0))
48 STDDid int YES ((0))
49 STDYearGapValue int YES ((0))
50 stdgraph bit YES ((0))
51 stdtable bit YES ((0))
52 stdPrompt bit YES ((0))
53 stdPromptProceed bit YES ((0))
54 stdEndUserTemplate bit YES ((0))
55 CFColour int YES ((0))
56 CFColourBlue int YES ((0))
57 stdpdf bit YES ((0))
58 stdsendifempty bit YES ((1))
59 STDNextCreationDate datetime YES ((0))
60 StdSymptom2Blob varbinary -1 YES
61 stdservice int YES ((0))
62 StdSymptom2HTML ntext 1073741823 YES
63 stdworkflowid int YES ((0))
64 CFdesktopType int YES ((0))
65 CFjustification ntext 1073741823 YES
66 CFnewOrExisting int YES ((0))
67 CFperipheralsDesktop nvarchar 255 YES
68 CFsoftware nvarchar 255 YES
69 CFexistingAsset nvarchar 255 YES
70 CFadministrationRights int YES ((0))
71 CFadministratorJustification nvarchar 255 YES
72 CFcostCentre int YES ((0))
73 CFrequestDetails ntext 1073741823 YES
74 CFexistingLocation nvarchar 255 YES
75 CFlaptopType int YES ((0))
76 CFmobileRequest int YES ((0))
77 CFmobilePhone int YES ((0))
78 CFjobFunction nvarchar 255 YES
79 CFcomments ntext 1073741823 YES
80 CFmobileNumber nvarchar 255 YES
81 CFsimCardNumber nvarchar 255 YES
82 CFperipherals nvarchar 255 YES
83 CFprinterRequestType int YES ((0))
84 CFprinterLocation nvarchar 255 YES
85 CFprinterMake nvarchar 255 YES
86 CFprinterColourMono int YES ((0))
87 CFpaperSize int YES ((0))
88 CFfurtherInfo nvarchar 255 YES
89 CFscanToEmail int YES ((0))
90 CFprinterName nvarchar 255 YES
91 CFnewLocation nvarchar 255 YES
92 CFfirstName nvarchar 255 YES
93 CFlastName nvarchar 255 YES
94 CFemployeeId nvarchar 255 YES
95 CFemailAddress nvarchar 255 YES
96 CFleavingDate datetime YES
97 CFstartingDate datetime YES
98 CFhardware int YES ((0))
99 CFsharedDrive int YES ((0))
100 CFaccessType int YES ((0))
101 CFsharedFilePath nvarchar 255 YES
102 CFchangeType int YES ((0))
103 CFstartDate datetime YES
104 CFendDate datetime YES
105 CFoutageRequired bit YES ((0))
106 CFoutageDuration nvarchar 255 YES
107 CFchangeDuration nvarchar 255 YES
108 CFemergencyChangeReason nvarchar 255 YES
109 StdName nvarchar 255 YES ('')
110 stdavailabletoorgid int YES ((0))
111 stdavailabletodepartmentid int YES ((0))
112 stdavailabletoteamid int YES ((0))
113 stdavailabletoagentid int YES ((0))
114 STDEmailTemplateID int NO ((0))
115 stdstartdate datetime YES ((0))
116 STDcreatelocked bit YES ((0))
117 STDonefaultid int YES ((0))
118 STDcopiedfromid int YES ((0))
119 STDCreateOnNonWorkDays bit YES ((1))
120 stdclearance nvarchar 4000 YES ('')
121 stdimpact int YES ((-1))
122 stdurgency int YES ((-1))
123 StdGroupID int NO ((0))
124 STDReportOutputFile nvarchar 1000 YES ('')
125 stdapprovalid int YES ((0))
126 StdInvoiceId int YES ((0))
127 stdenddate datetime YES ((0))
128 StdPeriod int YES ((0))
129 StdCreationType int YES ((0))
130 stdparentticketid int YES ((0))
131 stdmatchedkbid int YES ((0))
132 CFExistingProvider int YES ((0))
133 CFCompanyType int YES ((0))
134 CFOpportunityType int YES ((0))
135 CFHowDidTheyHear int YES ((0))
136 CFOppSize int YES ((0))
137 CFCustomerRequriementsHTML nvarchar -1 YES
138 CFSalesRequirements image 2147483647 YES
139 CFSalesRequirementsHTML nvarchar -1 YES
140 STDForwardInboundUpdates bit YES ((0))
141 CFSiteReportNotes image 2147483647 YES
142 CFSiteReportNotesHTML nvarchar -1 YES
143 stdemailcclist nvarchar 4000 YES ('')
144 stdbtid int YES ((0))
145 stdoverridebudgets bit YES ((0))
146 STDdefaultResourceType int YES ((0))
147 stdcsv bit YES ((0))
148 stduserid int YES ((-99))
149 STDupdateParentStatusOnClose int YES ((0))
150 STDupdateParentTargetOnCreate float YES ((0))
151 stdautomationtype int YES ((0))
152 CFWorkingFromHome int YES ((0))
153 stdincreasecontractnextcalldate int YES ((0))
154 STDGUID uniqueidentifier YES (newid())
155 stdoptionalserviceid int YES
156 stdshowonwebint int YES ((1))
157 stdforwardinboundupdatesint int YES ((1))
158 stdexcludefromslaint int YES ((1))
159 CFTonality nvarchar 255 YES
160 CFCategorySuggestion nvarchar 255 YES
161 CFRiskCategory int YES ((0))
162 CFoppWebsite nvarchar 255 YES
163 CFoppLinkedIn nvarchar 255 YES
164 STDexecutionType int YES ((0))
165 CFAISummary nvarchar 255 YES
166 CFRootCause image 2147483647 YES
167 CFRootCauseHTML nvarchar -1 YES
168 CFChangeClosureCategory int YES ((0))
169 CFChangeImplementationPlan image 2147483647 YES
170 CFChangeImplementationPlanHTML nvarchar -1 YES
171 CFChangePlan image 2147483647 YES
172 CFChangePlanHTML nvarchar -1 YES
173 CFChangeTestPlan image 2147483647 YES
174 CFChangeTestPlanHTML nvarchar -1 YES
175 CFChangeBackoutPlan image 2147483647 YES
176 CFChangeBackoutPlanHTML nvarchar -1 YES
177 CFChangePlanMemo ntext 1073741823 YES
178 CFChangeImplementationPlanMemo ntext 1073741823 YES
179 CFChangeTestPlanMemo ntext 1073741823 YES
180 CFChangeBackoutPlanMemo ntext 1073741823 YES
181 STDjson bit YES ((0))
182 CFAIPriority nvarchar 255 YES
183 CFAITicketType nvarchar 255 YES
184 CFStatementOfWork image 2147483647 YES
185 CFStatementOfWorkHTML nvarchar -1 YES
186 CFExecutiveSummary image 2147483647 YES
187 CFExecutiveSummaryHTML nvarchar -1 YES
188 CFLabelsOpp int YES ((0))
189 CFProposalTermsAndConditions image 2147483647 YES
190 CFProposalTermsAndConditionsHTML nvarchar -1 YES
191 CFDefaultProposalOption int YES ((0))
192 CFCustomerTestimonial image 2147483647 YES
193 CFCustomerTestimonialHTML nvarchar -1 YES
194 CFDefaultStatementOfWork int YES ((0))
195 stdstartnumdaysadded int YES ((-1))
196 stdtargetnumdaysadded int YES ((-1))
197 stdsqltoselectusers bit YES ((0))
198 stdusersqllookup nvarchar 4000 YES
199 stdnotificationid int YES
200 STDwebhookId nvarchar 100 YES
201 CFDiagnosticProcess image 2147483647 YES
202 CFDiagnosticProcessHTML nvarchar -1 YES
203 CFEscalationReason nvarchar 1000 YES
204 CFRecurringProblem bit YES ((0))
205 CFHardwareRequired image 2147483647 YES
206 CFHardwareRequiredHTML nvarchar -1 YES
207 CFHardwareJustification image 2147483647 YES
208 CFHardwareJustificationHTML nvarchar -1 YES
209 CFCompanyName nvarchar 255 YES
210 CFDrsFullName nvarchar 255 YES
211 CFPointOfContactName nvarchar 255 YES
212 CFAddress nvarchar 255 YES
213 CFPhoneNumber nvarchar 255 YES
214 CFFaxNumber nvarchar 255 YES
215 CFEmail nvarchar 255 YES
216 CFHowDidTheyHearAboutUs nvarchar 1000 YES
217 CFWhatServices nvarchar 1000 YES
218 CFFloorplans int YES ((0))
219 CFNewOfficeOrCurrentPractice int YES ((0))
220 CFWhatKindOfSoftware nvarchar 255 YES
221 CFHowManyOps nvarchar 255 YES
222 CFHowManyAdmins nvarchar 255 YES
223 CFBestTimeDay nvarchar 255 YES
224 CFOpportunityLostReason nvarchar 1000 YES
225 CFReEngageDate datetime YES
226 CFQualificationNotes image 2147483647 YES
227 CFQualificationNotesHTML nvarchar -1 YES
228 CFWebsiteDomainName nvarchar 255 YES
229 CFEmailManagement nvarchar 255 YES
230 CFFirewallLoginCredentials nvarchar 255 YES
231 CFServerAdminCredentials nvarchar 255 YES
232 CFWorkstationCredentials nvarchar 255 YES
233 CFImagingSoftware int YES ((0))
234 CFPhoneService int YES ((0))
235 CFVOIP nvarchar 255 YES
236 CFApplicationsUsed nvarchar 255 YES
237 CFNumberOfUsers nvarchar 255 YES
238 CFMicrosoftService int YES ((0))
239 CFM365Service nvarchar 255 YES
240 CFISP nvarchar 255 YES
241 CFFirewallSettings int YES ((0))
242 CFExistingIPScheme nvarchar 255 YES
243 CFNetworkSwitches nvarchar 255 YES
244 CFWirelessAccess nvarchar 255 YES
245 CFNumberofServers nvarchar 255 YES
246 CFOperatingSystem nvarchar 255 YES
247 CFDHCPDNSADDS nvarchar 255 YES
248 CFSoftwareVersions nvarchar 255 YES
249 CFStorageSize nvarchar 255 YES
250 CFHarddriveType nvarchar 255 YES
251 CFEvents nvarchar 255 YES
252 CFErrors nvarchar 255 YES
253 CFHIPAACompliant nvarchar 255 YES
254 CFMSOffice nvarchar 255 YES
255 CF3rdpartydevices nvarchar 255 YES
256 CFVirtualization nvarchar 255 YES
257 CFWorkgroupordomain nvarchar 255 YES
258 CFExistingGroupPolicies nvarchar 255 YES
259 CFExistingRMM nvarchar 255 YES
260 CFUsers nvarchar 255 YES
261 CFUnqiueSharedAccounts nvarchar 255 YES
262 CFBackupServicesLocation nvarchar 255 YES
263 CFCriticalDataLocations nvarchar 255 YES
264 CFServerPanNAS nvarchar 255 YES
265 CFPainPoints ntext 1073741823 YES
266 CFHardwareLookup nvarchar 1000 YES
267 CFRemediationPlanOverview image 2147483647 YES
268 CFRemediationPlanOverviewHTML nvarchar -1 YES
269 CFRemediationPlanSuccessCriteria image 2147483647 YES
270 CFRemediationPlanSuccessCriteriaHTML nvarchar -1 YES
271 CFRemediationPlanSummary nvarchar 255 YES
272 CFRemediationServiceCancellationDate datetime YES
273 CFRemediationServicesToCancel image 2147483647 YES
274 CFRemediationServicesToCancelHTML nvarchar -1 YES
275 CFServicesCancellationRequestDate datetime YES
276 CFServicesToCancel image 2147483647 YES
277 CFServicesToCancelHTML nvarchar -1 YES
278 CFServicesAdded image 2147483647 YES
279 CFServicesAddedHTML nvarchar -1 YES
280 CFServicesRemoved image 2147483647 YES
281 CFServicesRemovedHTML nvarchar -1 YES
282 CFAccountPainPoints image 2147483647 YES
283 CFAccountPainPointsHTML nvarchar -1 YES
284 CFAccountProblemRemediationRoadblocks image 2147483647 YES
285 CFAccountProblemRemediationRoadblocksHTML nvarchar -1 YES
286 CFAccountChangeSuspendBilling bit YES ((0))
287 CFAccountChangeSuspendBillingStartDate datetime YES
288 CFAccountChangeSuspendBillingEndDate datetime YES
289 CFAccountChangeServiceChangeIsOffboarding bit YES ((0))
290 CFSalesEngineeringDependencies image 2147483647 YES
291 CFSalesEngineeringDependenciesHTML nvarchar -1 YES
292 CFSecurityAuthorizationsRemoteAccessRequest nvarchar 1000 YES
293 CFPotentialRecurringValue int YES ((0))
294 CFPotentialOneTimeValue int YES ((0))
295 CFAuthorizationsEquipment image 2147483647 YES
296 CFAuthorizationsEquipmentHTML nvarchar -1 YES
297 CFShippingLabel image 2147483647 YES
298 CFShippingLabelHTML nvarchar -1 YES
299 CFDeliveryEstimatedTimeArrival datetime YES
300 CFShippingTrackingNumber nvarchar 255 YES
301 CFShippingCarrier nvarchar 1000 YES
302 CFShippingSignatureRequired bit YES ((0))
303 CFShippingContact nvarchar 255 YES
304 CFAddionalAgentsJobAid ntext 1073741823 YES
305 CFEscalator int YES ((0))
306 CFEscalationDate datetime YES
307 stdmakeinactive bit YES
308 stdtickettemplate int YES ((-1))
309 stdenabletaskdependencies bit YES
310 stdemailbcc nvarchar 4000 YES
311 stdslaid int YES ((-1))
312 stduploadtype int YES ((0))
313 stdintegrationdetailsid int YES
314 stdintegrationmapping int YES
315 stdintegrationfolder nvarchar 500 YES
316 stdoverwritefiles bit YES
317 stdcreateforusertype int YES ((-1))
318 CFReleaseInfoReleaseDate datetime YES
319 CFProjectType int YES ((0))
320 CFQuickProject bit YES ((0))
321 CFEnhancementsRequestedChange image 2147483647 YES
322 CFEnhancementsRequestedChangeHTML nvarchar -1 YES
323 CFEnhancementsActualChanges image 2147483647 YES
324 CFEnhancementsActualChangesHTML nvarchar -1 YES
325 CFProblemProblem image 2147483647 YES
326 CFProblemProblemHTML nvarchar -1 YES
327 CFProblemStartDate datetime YES
328 CFProblemDiagnosis image 2147483647 YES
329 CFProblemDiagnosisHTML nvarchar -1 YES
330 CFProblemSolution image 2147483647 YES
331 CFProblemSolutionHTML nvarchar -1 YES
332 CFReleaseCommunicationType nvarchar 1000 YES
333 CFReleaseCommunicationContent image 2147483647 YES
334 CFReleaseCommunicationContentHTML nvarchar -1 YES
335 CFReleaseCommunicationDate datetime YES
336 CFReleaseCommunicationTone nvarchar 1000 YES
337 CFReleaseCommunicationAudience nvarchar 1000 YES
338 CFDepartmentSelection nvarchar 1000 YES
339 CFApplicationUpdateApplicationName nvarchar 255 YES
340 CFApplicationUpdateApplicationCurrentVersion nvarchar 255 YES
341 CFApplicationUpdateApplicationRequestedVersion nvarchar 255 YES
342 CFApplicationUpdateReasonForUpdate image 2147483647 YES
343 CFApplicationUpdateReasonForUpdateHTML nvarchar -1 YES
344 CFApplicationUpdateApplicationLicensesRequired bit YES ((0))
345 CFApplicationUpdateIfApplicationLicensingRequiredClientPurchasedNewLicense bit YES ((0))
346 CFApplicationUpdateDoesTheVendorRequireAQuoteForLicensingChanges bit YES ((0))
347 CFApplicationUpdateDescribeDependenciesThatNeedTestedAndUpdated image 2147483647 YES
348 CFApplicationUpdateDescribeDependenciesThatNeedTestedAndUpdatedHTML nvarchar -1 YES
349 CFAppicationUpdateRequestedMainteanceWindow nvarchar 255 YES
350 CFApplicationUpdateEstimatedDowntimeHours nvarchar 255 YES
351 CFMaintenanceMaintenanceWindowConfirmed bit YES ((0))
352 CFKnowledgeLinksDTCKBArticle ntext 1073741823 YES
353 stdarticledescription nvarchar -1 YES
354 stdarticleresolution nvarchar -1 YES
355 stdarticlednotes nvarchar -1 YES
356 stdarticletype int YES
357 stdarticletags nvarchar 4000 YES
358 StdReportingPeriod int YES ((-1))
359 CFMyAccountPortalFeedback nvarchar 255 YES
360 stdintegrationdrive nvarchar 500 YES
361 stdintegrationfoldername nvarchar 500 YES
362 stdintegrationfolderaltid nvarchar 500 YES
363 stdcreatedby int YES
364 stdsqltoselectassets bit YES ((0))
365 stdassetsqllookup nvarchar 4000 YES
366 stddisablemilestonemodification bit YES
367 stdinvoiceday int YES
368 stdholidayworkday int YES ((-1))
369 STDfdid int YES
370 STDcustomTableId int YES
371 CFRemoteUsers nvarchar 1000 YES
372 CFReleaseDate datetime YES
373 CFSalesRequirementsPLAIN nvarchar -1 YES
374 CFSiteReportNotesPLAIN nvarchar -1 YES
375 CFRootCausePLAIN nvarchar -1 YES
376 CFChangeImplementationPlanPLAIN nvarchar -1 YES
377 CFChangePlanPLAIN nvarchar -1 YES
378 CFChangeTestPlanPLAIN nvarchar -1 YES
379 CFChangeBackoutPlanPLAIN nvarchar -1 YES
380 CFStatementOfWorkPLAIN nvarchar -1 YES
381 CFExecutiveSummaryPLAIN nvarchar -1 YES
382 CFProposalTermsAndConditionsPLAIN nvarchar -1 YES
383 CFCustomerTestimonialPLAIN nvarchar -1 YES
384 CFDiagnosticProcessPLAIN nvarchar -1 YES
385 CFHardwareRequiredPLAIN nvarchar -1 YES
386 CFHardwareJustificationPLAIN nvarchar -1 YES
387 CFQualificationNotesPLAIN nvarchar -1 YES
388 CFRemediationPlanOverviewPLAIN nvarchar -1 YES
389 CFRemediationPlanSuccessCriteriaPLAIN nvarchar -1 YES
390 CFRemediationServicesToCancelPLAIN nvarchar -1 YES
391 CFServicesToCancelPLAIN nvarchar -1 YES
392 CFServicesAddedPLAIN nvarchar -1 YES
393 CFServicesRemovedPLAIN nvarchar -1 YES
394 CFAccountPainPointsPLAIN nvarchar -1 YES
395 CFAccountProblemRemediationRoadblocksPLAIN nvarchar -1 YES
396 CFSalesEngineeringDependenciesPLAIN nvarchar -1 YES
397 CFAuthorizationsEquipmentPLAIN nvarchar -1 YES
398 CFShippingLabelPLAIN nvarchar -1 YES
399 CFEnhancementsRequestedChangePLAIN nvarchar -1 YES
400 CFEnhancementsActualChangesPLAIN nvarchar -1 YES
401 CFProblemProblemPLAIN nvarchar -1 YES
402 CFProblemDiagnosisPLAIN nvarchar -1 YES
403 CFProblemSolutionPLAIN nvarchar -1 YES
404 CFReleaseCommunicationContentPLAIN nvarchar -1 YES
405 CFApplicationUpdateReasonForUpdatePLAIN nvarchar -1 YES
406 CFApplicationUpdateDescribeDependenciesThatNeedTestedAndUpdatedPLAIN nvarchar -1 YES
407 stdpslid int YES
408 STDmcid int YES
409 stdmailboxid int YES ((-1))
410 CFDownPaymentPercentage nvarchar 255 YES
411 CFPaymentMethod int YES
412 CFBillingContact nvarchar 255 YES
413 CFFinancing int YES

TOUTCOME (191 columns)

# Column Type Length Nullable Default
1 Ooutcome nvarchar 150 YES
2 Onewstatus smallint YES
3 OSLAHoldIsChecked bit NO ((0))
4 OHide bit NO ((0))
5 OUserDesc nvarchar 4000 YES
6 OEmailID int YES ((0))
7 OSLAReleaseIsChecked bit NO ((0))
8 OSystemId int YES ((0))
9 OChargeRate int YES ((0))
10 ODefaultUserDef int YES ((0))
11 Odefaultmanhrs float YES ((0))
12 Odefaultnonbill float YES ((0))
13 OsecurityLevel int YES ((0))
14 OChangeProcessID int YES ((0))
15 OSendEmail int YES ((0))
16 OHideFromUser bit NO ((0))
17 OFieldVisible nvarchar 4000 YES
18 ohotkey nvarchar 4000 YES
19 obuttonsequence int YES ((0))
20 obuttoncaption nvarchar 4000 YES
21 obuttonimage int YES ((-1))
22 OHideSendEmail bit NO ((0))
23 OHideCloseRequest bit NO ((0))
24 ODefaultTech int YES ((0))
25 ODefaultSection nvarchar 4000 YES
26 OIncludeCC bit NO ((-1))
27 OIncludeTo bit NO ((-1))
28 Oid int NO ((0))
29 OActionVisibility int YES ((0))
30 OColour int YES ((0))
31 ocannedtext int YES ((0))
32 OMustAssign bit YES ((0))
33 ODontShowScreen bit YES ((0))
34 ORequestType int YES ((0))
35 Ochangeseq int YES ((0))
36 oMustAddNote bit YES ((0))
37 OWorddocID int YES ((0))
38 OWorddocPath nvarchar 1000 YES ('')
39 OSynctoSAP bit YES ((0))
40 OChildTemplate int YES ((0))
41 oRespondType int YES ((0))
42 OToOverride nvarchar 4000 YES ('')
43 OCCOverride nvarchar 4000 YES ('')
44 OFlowID int YES ((0))
45 OSyncToDynamics bit YES ((0))
46 OPSSID int NO ((0))
47 ocolourhex nvarchar 10 YES ('#0f61a1')
48 oshowhidecheckbox bit YES ((0))
49 oshowslacheckbox bit YES ((0))
50 odefaultnotehtml nvarchar -1 YES
51 OIsImportant bit YES ((0))
52 OShowImportantCheckbox bit YES ((0))
53 oshowfollowcheckbox bit YES ((0))
54 ofollow bit YES ((0))
55 odefaultappointmentstatus int YES ((0))
56 otfstype nvarchar 255 YES ('')
57 otodotemplateid int YES ((-1))
58 ofaiconname nvarchar 50 YES ('')
59 OChildEmailTemplate int YES ((0))
60 ODefaultLinkedTicketStatus int YES ((0))
61 OuseTimer bit YES ((1))
62 oupdatedynamicemaillist bit YES ((0))
63 oshowemailfields bit YES ((1))
64 odefaultnewsummaryfromsource bit YES ((0))
65 odefaultnewdetailsfromsource bit YES ((0))
66 OLogTimeUnits int YES ((0))
67 Oskippendingclosure bit YES ((0))
68 ocallscript int YES ((0))
69 ocreatechildticketortemplate int YES ((0))
70 ochildrtid int YES ((0))
71 OSendSMS int YES ((2))
72 OHideSendSMS bit YES ((1))
73 OPrintTicket int YES ((-1))
74 OexcludeFromDynamicLists bit YES ((0))
75 OAutomationRunbookId uniqueidentifier YES
76 OSetDetailsFromNewTicket bit YES ((0))
77 ohideactionfromcandi bit YES ((0))
78 OBccFollowers bit YES ((1))
79 odefaultseriousness int YES ((0))
80 OShowEvenIfNoChild bit YES ((0))
81 OReplyType int YES ((0))
82 OParentDefaultUser int YES ((0))
83 assetsearchtext nvarchar 50 YES ('')
84 OActionResetsResponse bit YES ((0))
85 oshowattachmentstouser bit YES ((0))
86 ourl nvarchar 4000 YES ('')
87 oincludeallattachments bit YES
88 odefaultcat1 nvarchar 4000 YES
89 odefaultcat2 nvarchar 4000 YES
90 odefaultcat3 nvarchar 4000 YES
91 odefaultcat4 nvarchar 4000 YES
92 OAzureAction int YES ((0))
93 OAzureConnection int YES ((0))
94 odefaultsynctosalesforce bit YES
95 oshowtouser bit YES
96 odefaultsupplierid int YES ((-1))
97 oreportid int YES ((0))
98 oishiddenfrominternalit bit YES
99 odefaultsynctoservicenow bit YES
100 odefaultassettype int YES ((0))
101 oshowautorelease bit YES ((1))
102 OQuoterTemplate nvarchar 100 YES
103 ofollowersccbcc int YES ((0))
104 oapptcompletetimetype int YES
105 oprimaryserviceusersfollow bit YES
106 ouseremailintellisense int YES ((0))
107 osupplieremailintellisense int YES ((0))
108 OGUID uniqueidentifier YES (newid())
109 odefaultsynctojira bit YES
110 oallowuserattachments bit YES
111 odefaultassetstatus int YES ((-1))
112 odefaultsendtohalo bit YES
113 OtagReleaseType int YES ((0))
114 oautocontactmethod bit YES
115 oshowsendtwitter bit YES
116 oshowsendfacebook bit YES
117 odefaultprivatenotehtml nvarchar -1 YES
118 OaiOperation int YES ((0))
119 OaiModel nvarchar 100 YES ('gpt-3.5-turbo')
120 OaiPrompt nvarchar 4000 YES
121 oshowsendwhatsapp bit YES
122 odefaultoppclosurecat int YES ((-1))
123 OintegrationMethodId int YES
124 oupdateparentattachmenttype int YES ((0))
125 OreportAttachPdf bit YES ((1))
126 OreportAttachXls bit YES ((0))
127 OreportAttachCsv bit YES ((0))
128 OreportAttachJson bit YES ((0))
129 otranslatebeforesending bit YES ((0))
130 odefaultsendtopagerduty bit YES ((0))
131 OBccOverride nvarchar 4000 YES
132 ominattachments int YES ((0))
133 odefaultappointmenttype int YES ((0))
134 oshowsendsurvey bit YES ((0))
135 osendsurvey int YES ((0))
136 oshowsendinstagram bit YES ((0))
137 oshowslacheckboxmandatory bit YES ((0))
138 oaipreview bit YES
139 Odefaultcommunicationmethod int YES ((0))
140 orelatednotevisibility int YES ((0))
141 ooverridefrommailboxid int YES ((-1))
142 ocreateissuetype int YES ((0))
143 oshowwhenlocked bit YES
144 Oshowsendgooglebusiness bit YES
145 osubmitlabeloverride nvarchar 50 YES ('')
146 oaiimproveagentnotedefaulton bit YES ((1))
147 odefaultsendjiranote bit YES ((0))
148 oconfigtype int YES ((0))
149 oshowonparent int YES ((0))
150 oshowonchild int YES ((0))
151 olapsafedefaultinstallation nvarchar 50 YES
152 olapsafedefaultinstallationname nvarchar 255 YES
153 olapsafedefaultbaysize int YES
154 onewactiondisplay int YES ((-1))
155 onewactiondisplaysize int YES ((2))
156 ohideheaderbutton bit YES ((0))
157 ochargerateoverridesticket bit YES
158 odefsectiontoagentsdefault bit YES
159 odonotallowwithopenappointments bit YES
160 onewticketattachments bit YES ((0))
161 orunaiinsights bit YES ((0))
162 ohideuservisibilitytoggle bit YES
163 oflowstepid int YES ((0))
164 oemailediting int YES ((0))
165 odlid int YES ((-1))
166 oemailasimportant bit YES
167 oisresponseonchild bit YES
168 oaddactionstolinked int YES ((3))
169 OShowActionHistoryOnNewAction int YES ((0))
170 oautoforwardhaloapi bit YES
171 osynctohaloapi int YES ((0))
172 oexcludefromemailthreading bit YES
173 ohideuserselect bit YES
174 oactionitemtoissue int YES ((0))
175 ocaneditclosedtickets bit YES
176 odownloadallattachments bit YES
177 oaisuggestionscontext bit YES
178 oactiongroup int YES ((0))
179 oaddnotetoparent bit YES
180 ohidetickettypeselection bit YES
181 oautomationrunbooktrigger int YES ((0))
182 oTranslateBeforeSendingDefault bit YES
183 Owhatsappcontenttemplate nvarchar 50 YES
184 Owhatsappdetailsid int YES
185 Oallowaudiorecording bit YES
186 oallowactionwhenaccountstopped bit YES
187 Ohideportalbutton bit YES
188 oaddautosuppressheader bit YES
189 oshowfromaddressbydefault bit YES
190 ooverridetemplate int YES
191 onewticketusertype int YES ((0))

TSTATUS (32 columns)

# Column Type Length Nullable Default
1 Tstatus smallint NO
2 tstatusdesc nvarchar 4000 YES
3 TstatusType int YES ((0))
4 TStatusEmailID int YES ((0))
5 TStatusEmailFreqDays int YES ((0))
6 Tcolour int YES ((0))
7 TStatusNoChangeHours float YES ((0))
8 TStatusPutOnSLAhold bit YES ((0))
9 TNotifyStatusChange int YES ((0))
10 TstatusSeq int YES ((0))
11 ttimeuntilloffhold float YES ((0.00))
12 TDontSendSLAReminders bit YES ((0))
13 Tchangeseq int YES ((0))
14 tShowOnQuickChange bit YES ((1))
15 TStatusTakeOffSLAhold bit YES ((0))
16 TStatusNoChangeHoursManager int YES ((0))
17 TStatusNoChangeTemplate int YES ((-1))
18 tcolourhex nvarchar 10 YES ('')
19 TStatusNoChangeHoursSection float YES ((0.00))
20 TStatusNoChangeHoursRecurring bit YES ((0))
21 TStatusNoChangeHoursSectionRecurring bit YES ((0))
22 TStatusNoChangeHoursManagerRecurring bit YES ((0))
23 tshortname nvarchar 50 YES ('')
24 TSLAIgnoreRelease bit YES ((0))
25 tstatuschangetofreq float YES ((0.00))
26 tstatuschangeto int YES ((0))
27 tstatususeworkinghours int YES
28 TStatusGUID uniqueidentifier YES (newid())
29 tsuseworkinghoursstatusnochangehours int YES ((0))
30 tsuseworkinghoursstatusnochangehourssection int YES ((0))
31 tsuseworkinghoursstatusnochangehoursmanager int YES ((0))
32 TincludeInLoadBalance bit YES ((1))

XTYPE (140 columns)

# Column Type Length Nullable Default
1 TTypenum smallint NO
2 tdesc nvarchar 100 YES
3 Tlabel smallint YES
4 Ttext smallint YES
5 Tconnector bit NO ((0))
6 Tlength smallint YES
7 Theight smallint YES
8 Tforce bit NO ((0))
9 Tconnstyle smallint YES
10 Tgeneric smallint YES
11 Tbmp nvarchar 4000 YES
12 Tmemo ntext 1073741823 YES
13 Tind bit NO ((0))
14 Tsize smallint YES
15 Tcolour int YES
16 Tx smallint YES
17 Ty smallint YES
18 TTypecolour int YES
19 TTypewidth smallint YES
20 Tmanufacturer smallint YES
21 Tsupplier1 smallint YES
22 Tactype smallint YES
23 Thidebmpdesc bit NO ((0))
24 Tlabelseqnos int YES ((0))
25 Titemno int YES
26 TRightsLevel int YES ((0))
27 TCost float YES ((0.00))
28 Tchangeseq int YES ((0))
29 tuseteamviewer bit YES ((0))
30 tAccountsCode1 nvarchar 255 YES ('')
31 tAccountsCode2 nvarchar 255 YES ('')
32 tweeklyCost float YES ((0.00))
33 tmonthlyCost float YES ((0.00))
34 tquarterlyCost float YES ((0.00))
35 tsixMonthlyCost float YES ((0.00))
36 tyearlyCost float YES ((0.00))
37 ttwoYearlyCost float YES ((0.00))
38 tthreeYearlyCost float YES ((0.00))
39 tfourYearlyCost float YES ((0.00))
40 tfiveYearlyCost float YES ((0.00))
41 tlabelseqnos2 int YES ((-1))
42 tlabelseqnos3 int YES ((-1))
43 TKaseyaID nvarchar 100 YES ('')
44 ticonbase64 nvarchar -1 YES
45 TShowToUsers bit YES ((1))
46 TItemCode nvarchar 4000 YES ('')
47 TDefaultSequence int YES ((0))
48 TTagPrefix nvarchar 100 YES ('')
49 TenableResourceBooking bit YES ((0))
50 TresourceBookingWorkDays int YES ((1))
51 TresourceBookingAllowAssetSelection bit YES ((0))
52 TresourceBookingAssetRestrictionType int YES ((0))
53 TresourceBookingMinHoursInAdvance float YES ((1))
54 TresourceBookingMaxDaysInAdvance float YES ((365))
55 linkedcontracttype int YES ((-1))
56 tffid int YES ((-1))
57 TiconATGuid nvarchar 50 YES ('')
58 TAssetTabDisplay int YES ((0))
59 tallowallstatus bit YES ((1))
60 XBusinessOwnerVisibility int YES
61 XTechnicalOwnerVisibility int YES
62 XSlaVisibility int YES
63 XPriorityVisibility int YES
64 XStatusVisibility int YES
65 XServicesVisibility int YES
66 XDependenciesVisibility int YES
67 tcolumnprofileoverride int YES ((0))
68 tvisibilitylevel int YES ((1))
69 TGUID uniqueidentifier YES (newid())
70 tresourcebookingsiteselectiontype int YES ((0))
71 XNotesVisibility int YES ((1))
72 tnewticketpriority int YES
73 XLicenceVisibility int YES ((1))
74 xallowallview bit YES ((0))
75 XCriticalityVisibility int YES ((1))
76 tisservice bit YES ((0))
77 tisbusinessapp bit YES ((0))
78 tsvcid int YES
79 XUserVisibility int YES ((1))
80 tdefaultitem int YES ((-1))
81 tenablelansweeperusermatching bit YES
82 townerid int YES
83 townercabid int YES
84 tdefaultshowinusercatalog int YES ((0))
85 towningservicevisibility int YES
86 towningbusinessappvisibility int YES
87 towningservice int YES
88 tallowallcustombuttons bit YES ((1))
89 tdefaultdevicetemplate int YES ((0))
90 tallowassetmaintenance bit YES
91 tisportfolio bit YES
92 tisbusinessappinstance bit YES
93 towningcivisibility int YES
94 towningportfoliovisibility int YES
95 tuse int YES ((0))
96 tprimaryinstancetype int YES ((0))
97 tusertab int YES ((-1))
98 tbusinessownertab int YES ((-1))
99 ttechnicalownertab int YES ((-1))
100 tslatab int YES ((-1))
101 tprioritytab int YES ((-1))
102 tstatustab int YES ((-1))
103 tservicestab int YES ((-1))
104 tdependenciestab int YES ((-1))
105 tnotestab int YES ((-1))
106 tlicencetab int YES ((-1))
107 tcriticalitytab int YES ((-1))
108 towningservicetab int YES ((-1))
109 towningbusinessapptab int YES ((-1))
110 towningcitab int YES ((-1))
111 towningportfoliotab int YES ((-1))
112 tAssetTypetab int YES ((-1))
113 tInventoryNumbertab int YES ((-1))
114 tSitetab int YES ((-1))
115 tActivetab int YES ((-1))
116 tStockLocationtab int YES ((-1))
117 tStockLocationVisibility int YES
118 tSuppliertab int YES ((-1))
119 tSupplierVisibility int YES
120 tManufacturertab int YES ((-1))
121 tManufacturerVisibility int YES
122 tPurchaseDatetab int YES ((-1))
123 tPurchaseDateVisibility int YES
124 tReftab int YES ((-1))
125 tRefVisibility int YES
126 tPartsWarrantyStarttab int YES ((-1))
127 tPartsWarrantyStartVisibility int YES
128 tPartsWarrantyEndtab int YES ((-1))
129 tPartsWarrantyEndVisibility int YES
130 tLabourWarrantyStarttab int YES ((-1))
131 tLabourWarrantyStartVisibility int YES
132 tLabourWarrantyEndtab int YES ((-1))
133 tLabourWarrantyEndVisibility int YES
134 tWarrantyNotestab int YES ((-1))
135 tWarrantyNotesVisibility int YES
136 tallowassetmeters bit YES
137 tdiagramfield1 int YES ((0))
138 tdiagramfield2 int YES ((0))
139 tdiagramfield3 int YES ((0))
140 tresourcebookingassetcf int YES ((0))
Back to top