Skip to main content

Actions (Ticket Notes) - Key Tables

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

ACTARC (68 columns)

# Column Type Length Nullable Default
1 Faultid int NO
2 actionnumber int NO
3 Actoutcome nvarchar 4000 YES
4 who nvarchar 4000 YES
5 Whe_ datetime YES
6 note ntext 1073741823 YES
7 timetaken float YES
8 nonbilltime float YES ((0))
9 mileage float YES ((0))
10 emailto nvarchar 4000 YES
11 emailcc nvarchar 4000 YES
12 dateemailed datetime YES
13 emailbody ntext 1073741823 YES
14 ActionUserdef int YES ((0))
15 ActionCode int YES ((0))
16 ActionHide bit NO ((0))
17 AUserDesc nvarchar 4000 YES
18 ActOutcomeNum int YES ((0))
19 ActionDateCreated datetime YES
20 emailattachment nvarchar 4000 YES
21 ActionInvoiceNumber nvarchar 30 YES
22 ActionChargeAmount float YES ((0))
23 ActionChargeHours float YES ((0))
24 ActionNonChargeAmount float YES ((0))
25 ActionNonChargeHours float YES ((0))
26 ActionContractID int YES ((0))
27 TravelTime float YES ((0))
28 ActProcessID int YES ((0))
29 ActionBillingPlanID int YES ((0))
30 ActionCalendarStatus int YES ((0))
31 ActionApptID nvarchar 4000 YES
32 ActionSMSStatus int YES ((0))
33 ActionStatusBefore int YES ((0))
34 ActionStatusAfter int YES ((0))
35 ACchangeseq int YES ((1))
36 AEmailSubject nvarchar 4000 YES
37 ActionMailBoxID int YES ((0))
38 ActionArrivalDate datetime YES
39 ActionCompletionDate datetime YES
40 ActionTravelStartDate datetime YES
41 ActionTravelEndDate datetime YES
42 actionSLAresponseState nvarchar 1 YES
43 actionTargetResponse float YES ((0))
44 actionActualResponse float YES ((0))
45 ActIsBillable bit NO ((-1))
46 ActIsReadyForProcessing bit NO ((0))
47 ActReviewed bit NO ((0))
48 ActProcessedDate datetime YES
49 ActionPrePayHours float YES ((0))
50 EmailFromNew ntext 1073741823 YES
51 EmailToNew ntext 1073741823 YES
52 EmailCcNew ntext 1073741823 YES
53 EmailBccNew ntext 1073741823 YES
54 EmailSubjectNew ntext 1073741823 YES
55 ActionUserDefinedData nvarchar 4000 YES
56 EmailToListAll ntext 1073741823 YES
57 EmailDirection nvarchar 1 YES
58 ActionReplyDirect bit NO ((0))
59 ActionInformOwnerOfAction bit YES ((0))
60 ASendTweet bit YES ((0))
61 ATweetSent bit YES ((0))
62 ATweetFrom nvarchar 4000 YES ('')
63 ATwitterID bigint YES ((0))
64 ASendtoFB bit YES ((0))
65 ASenttoFB bit YES ((0))
66 AFacebookID nvarchar 4000 YES ('')
67 AFacebookName nvarchar 4000 YES ('')
68 CallOutcomeNum int YES ((-1))

ACTIONS (199 columns)

# Column Type Length Nullable Default
1 Faultid int NO
2 actionnumber int NO
3 Actoutcome nvarchar 500 YES
4 who nvarchar 4000 YES
5 Whe_ datetime YES
6 note ntext 1073741823 YES
7 timetaken float YES
8 dateemailed datetime YES
9 emailbody ntext 1073741823 YES
10 nonbilltime float YES ((0))
11 mileage float YES ((0))
12 emailto nvarchar 4000 YES
13 emailcc nvarchar 4000 YES
14 emailattachment nvarchar 4000 YES
15 ActionUserdef int YES ((0))
16 ActionCode int YES ((-1))
17 ActionHide bit NO ((0))
18 AUserDesc nvarchar 4000 YES
19 ActOutcomeNum int YES ((0))
20 ActionDateCreated datetime YES
21 ActionInvoiceNumber nvarchar 30 YES
22 ActionChargeAmount float YES ((0))
23 ActionChargeHours float YES ((0))
24 ActionNonChargeAmount float YES ((0))
25 ActionNonChargeHours float YES ((0))
26 ActionContractID int YES ((0))
27 TravelTime float YES ((0))
28 ActProcessID int YES ((0))
29 ActionTravelAmount float YES ((0))
30 ActionMileageAmount float YES ((0))
31 ActionTravelMileageInvoiceNumber int YES ((0))
32 ActionBillingPlanID int YES ((0))
33 ActionBlob varbinary -1 YES
34 emailbodyrich varbinary -1 YES
35 EmailAttachments ntext 1073741823 YES
36 ActionCalendarStatus int YES ((0))
37 ActionApptID nvarchar 4000 YES
38 ActionSMSStatus int YES ((0))
39 ActionStatusBefore int YES ((0))
40 ActionStatusAfter int YES ((0))
41 ACchangeseq int YES ((1))
42 AEmailSubject nvarchar 4000 YES
43 timetakenAdjusted float YES ((0))
44 SiteVisitUnits float YES ((0))
45 aSVID int YES ((0))
46 ALWdevice int YES ((0))
47 ALWdevicesite int YES ((0))
48 ALWwarrantyreported bit NO ((0))
49 ActionMailBoxID int YES ((0))
50 ActionArrivalDate datetime YES
51 ActionCompletionDate datetime YES
52 ActionTravelStartDate datetime YES
53 ActionTravelEndDate datetime YES
54 actionActualResponse float YES ((0))
55 actionSLAresponseState nvarchar 1 YES
56 emailbcc nvarchar 4000 YES
57 ActIsBillable bit NO ((-1))
58 ActIsReadyForProcessing bit NO ((0))
59 ActReviewed bit NO ((0))
60 ActProcessedDate datetime YES
61 ActionPrePayHours float YES ((0))
62 EmailFromNew ntext 1073741823 YES
63 EmailToNew ntext 1073741823 YES
64 EmailCcNew ntext 1073741823 YES
65 EmailBccNew ntext 1073741823 YES
66 EmailSubjectNew ntext 1073741823 YES
67 ActionUserDefinedData nvarchar 4000 YES
68 EmailToListAll ntext 1073741823 YES
69 EmailDirection nvarchar 1 YES
70 ActionReplyDirect bit NO ((0))
71 ActionInformOwnerOfAction bit YES ((0))
72 ASurchargeID int YES ((0))
73 AChargeTotalAction bit YES ((0))
74 ASendTweet bit YES ((0))
75 ATweetSent bit YES ((0))
76 ATweetFrom nvarchar 4000 YES ('')
77 ATwitterID bigint YES ((0))
78 ASendtoFB bit YES ((0))
79 ASenttoFB bit YES ((0))
80 AFacebookID nvarchar 4000 YES ('')
81 AFacebookName nvarchar 4000 YES ('')
82 CallOutcomeNum int YES ((-1))
83 AMailEntryID nvarchar 4000 YES ('')
84 ActionResponseDate datetime YES ((0))
85 ActionTargetResponseDate datetime YES ((0))
86 APagerdutySendStatus int YES ((0))
87 Aisimportant bit YES ((0))
88 AReplyToAddress nvarchar 200 YES ('')
89 ActSAPUUID nvarchar 255 YES ('')
90 noteHTML ntext 1073741823 YES
91 WhoWith nvarchar 255 YES ('')
92 Achatid int YES ((0))
93 Adateinvoicedmileage datetime YES ((0))
94 Adateinvoicedtraveltime datetime YES ((0))
95 ADynamicsActionID nvarchar 100 YES ('')
96 aContinuumID nvarchar 500 YES ('')
97 emailbodyhtml nvarchar -1 YES
98 AExternalActionID int NO ((0))
99 actoutcomeid int YES ((0))
100 actionbyunum int YES ((0))
101 actionbyuid int YES ((0))
102 afromoverride nvarchar 255 YES ('')
103 actionapid int YES ((0))
104 aChildUnread int YES ((0))
105 ActionQuoteID int NO ((0))
106 actionapplicationid nvarchar 200 YES ('')
107 whoagentid int YES ((0))
108 achargetotalprocessed bit YES ((0))
109 ActionOOHTime float YES ((0.00))
110 ActionHolidayTime float YES ((0.00))
111 ActionTotalOOHTime float YES ((0.00))
112 ARemoteTechID int YES ((0))
113 timetakendays float YES ((0.00))
114 asupplierid int YES ((0))
115 ASentToAPIUrl nvarchar 1000 YES ('')
116 ASentToAPIAreaId int YES ((0))
117 ASentToAPISupplierId int YES ((0))
118 aSMSTo nvarchar 4000 YES ('')
119 actiontravelinvoicenumber nvarchar 10 YES ('')
120 actionmileageinvoicenumber nvarchar 10 YES ('')
121 ARelatedToId int YES ((0))
122 ARelatedToActionId int YES ((0))
123 ARelatedFromId int YES ((0))
124 ARelatedFromActionId int YES ((0))
125 AContractId int YES ((-1))
126 AagentNotificationNeeded int YES ((0))
127 AProjectID int YES ((0))
128 AisProjectInvoice bit YES ((0))
129 ATravelChargeRate int YES ((-1))
130 ATravelSurchargeId int YES ((0))
131 asentinelid nvarchar 500 YES ('')
132 ag2aremoteid nvarchar 100 YES ('')
133 AAutomationId int YES
134 actionprepayamount float YES
135 Ausecroverride bit YES
136 AAzureActionComplete bit YES
137 id int NO
138 ActionisJson bit YES
139 aisbillingaction bit YES
140 aishiddenfrominternalit bit YES
141 AFTEID int YES
142 ABillingOverriddenByTimeEntry int YES
143 aparentactionnumber int YES
144 acontractdateoverride datetime YES ((0))
145 AFacebookParentId nvarchar 100 YES
146 apagerdutyid nvarchar 50 YES
147 AmergedFromFaultid int YES
148 AmergedFromActionNumber int YES
149 AFacebookFromId nvarchar 100 YES
150 ATwitterFromId nvarchar 100 YES
151 asenttojirasupplierid int YES
152 aMailID nvarchar 1000 YES ('')
153 AGUID uniqueidentifier YES (newsequentialid())
154 CFAgentPoliteness nvarchar 255 YES
155 actioninvoicelineid int YES ((-1))
156 asenttowhatsapp bit YES
157 awhatsappname nvarchar 500 YES
158 awhatsappid nvarchar 100 YES
159 CFcrmContactMethod int YES ((0))
160 CFcrmContactNotes image 2147483647 YES
161 CFcrmContactNotesHTML nvarchar -1 YES
162 CFcrmContactNotesPLAIN nvarchar -1 YES
163 CFcrmContactHurdles ntext 1073741823 YES
164 ALastUpdated datetime YES ((0))
165 outgoingmethod int YES
166 AInstagramParentId nvarchar 100 YES
167 AInstagramId nvarchar 250 YES
168 AInstagramName nvarchar 200 YES
169 Asenttoinsta bit YES
170 AInstagramFromId nvarchar 100 YES
171 adontrecalculatebilling bit YES
172 asenttoservicenowsupplierid int YES
173 atimesheetapprovalstatus int YES
174 adefprepaydateinvoiced datetime YES ((0))
175 adefprepayinvoicenumber nvarchar 1000 YES
176 adefprepayamount float YES
177 amilestonebillid int YES
178 asalesmailboxoverrideid int YES
179 AInternetMessageId nvarchar 100 YES
180 areplyingto int YES
181 aonbehalfof int YES
182 aWarningType int YES
183 actiontravelbillingplanid int YES
184 atravelcontractid int YES
185 actiontravelchargehours float YES
186 atwadelivereddate datetime YES ((0))
187 atwareaddate datetime YES ((0))
188 emailbccmax nvarchar -1 YES
189 emailbccnewmax nvarchar -1 YES
190 travelisreadyforprocessing bit YES
191 aisundeliverable bit YES
192 areplytoactionid int YES
193 aishaloack bit YES
194 aemailimportance nvarchar 50 YES
195 asynctohaloapi int YES
196 aexcludefromemailthreading bit YES
197 aemailstatus int YES
198 addautosuppressheader bit YES
199 aWaitForCIDImages bit YES

ACTYPE (11 columns)

# Column Type Length Nullable Default
1 Actypenum int NO
2 actext1 nvarchar 4000 YES
3 Acfield1 smallint YES
4 actext2 nvarchar 4000 YES
5 Acfield2 smallint YES
6 actext3 nvarchar 4000 YES
7 Acfield3 smallint YES
8 acfield4 int YES ((0))
9 actext4 nvarchar 4000 YES
10 acfield5 int YES ((0))
11 actext5 nvarchar 4000 YES
Back to top