1 | ### Available Reports for ConnectWise v2018.6 (58531)
|
2 | ---
|
3 | #### AccountsReceivableAging
|
4 | | | | |
|
5 | |-------------|-------------|-----|
|
6 | | `Aging` | Numeric | nullable |
|
7 | | `Aging_Bucket` | Text | nullable |
|
8 | | `Billing_Terms` | Text | nullable |
|
9 | | `Billing_Unit_RecID` | Numeric | nullable |
|
10 | | `Business_Unit_Description` | Text | nullable |
|
11 | | `Company_Name` | Text | nullable |
|
12 | | `Company_RecID` | Numeric | nullable |
|
13 | | `Credit_Amount` | Numeric | nullable |
|
14 | | `Date_Invoice` | DateTime | nullable |
|
15 | | `DueDate` | DateTime | nullable |
|
16 | | `Invoice_Amount` | Numeric | |
|
17 | | `Invoice_Number` | Text | nullable |
|
18 | | `IsPaid` | Numeric | |
|
19 | | `Location` | Text | nullable |
|
20 | | `Open_Balance` | Numeric | nullable |
|
21 | | `Owner_Level_RecID` | Numeric | |
|
22 | | `PO_Number` | Text | nullable |
|
23 | | `Paid_Amount` | Numeric | |
|
24 | | `Type` | Text | nullable |
|
25 |
|
26 | #### Activity
|
27 | | | | |
|
28 | |-------------|-------------|-----|
|
29 | | `Assign_To` | Text | |
|
30 | | `Assigned_By` | Text | |
|
31 | | `Close_flag` | Boolean | |
|
32 | | `Closed_By` | Text | nullable |
|
33 | | `Company_ID` | Text | nullable |
|
34 | | `Company_Name` | Text | nullable |
|
35 | | `Company_Owner_Level_Recid` | Numeric | nullable |
|
36 | | `Company_RecID` | Numeric | nullable |
|
37 | | `Contact_RecID` | Numeric | |
|
38 | | `Country` | Text | nullable |
|
39 | | `Date_Closed` | DateTime | nullable |
|
40 | | `Date_Entered` | DateTime | nullable |
|
41 | | `Date_Entered_UTC` | DateTime | nullable |
|
42 | | `Date_Time_End` | DateTime | nullable |
|
43 | | `Date_Time_Start` | DateTime | nullable |
|
44 | | `Entered_By` | Text | |
|
45 | | `Inactive_Flag` | Boolean | |
|
46 | | `Last_Update` | DateTime | nullable |
|
47 | | `Last_Update_UTC` | DateTime | nullable |
|
48 | | `Marketing_Campaign_RecID` | Numeric | |
|
49 | | `Marketing_ID` | Text | |
|
50 | | `Notes` | Text | nullable |
|
51 | | `Notify_Complete_Flag` | Boolean | |
|
52 | | `Opportunity_Name` | Text | nullable |
|
53 | | `Opportunity_Recid` | Numeric | nullable |
|
54 | | `Owner_ID` | Numeric | nullable |
|
55 | | `PhoneNbr` | Text | nullable |
|
56 | | `Reminder_Flag` | Boolean | |
|
57 | | `Reminder_Minutes` | Numeric | nullable |
|
58 | | `Reminder_Time_Desc` | Text | nullable |
|
59 | | `SO_Activity_Recid` | Numeric | |
|
60 | | `SO_Activity_Type_ID` | Text | nullable |
|
61 | | `SO_Activity_Type_RecID` | Numeric | nullable |
|
62 | | `SO_Reference_RecID` | Numeric | nullable |
|
63 | | `SR_Location_RecID` | Numeric | nullable |
|
64 | | `SR_Service_Recid` | Numeric | nullable |
|
65 | | `Schedule_RecID` | Numeric | |
|
66 | | `Schedule_Type_RecID` | Numeric | |
|
67 | | `Sr_Location_Desc` | Text | nullable |
|
68 | | `State_ID` | Text | nullable |
|
69 | | `Subject` | Text | nullable |
|
70 | | `Time_Zone` | Text | nullable |
|
71 | | `Updated_By` | Text | nullable |
|
72 | | `Xref_Mbr_RecID` | Numeric | nullable |
|
73 | | `agr_header_recid` | Numeric | nullable |
|
74 | | `agr_name` | Text | nullable |
|
75 | | `closed_flag` | Boolean | nullable |
|
76 | | `contact_name` | Text | nullable |
|
77 | | `so_act_status_recid` | Numeric | |
|
78 | | `so_activity_type_desc` | Text | nullable |
|
79 | | `statusdesc` | Text | nullable |
|
80 |
|
81 | #### ActivityCustomFields
|
82 | | | | |
|
83 | |-------------|-------------|-----|
|
84 | | `Last_Update_UTC` | DateTime | |
|
85 | | `Pod_RecID` | Numeric | |
|
86 | | `SO_Activity_RecID` | Numeric | |
|
87 | | `Subject` | Text | nullable |
|
88 | | `Updated_By` | Text | |
|
89 | | `User_Defined_Field_RecID` | Numeric | |
|
90 | | `User_Defined_Field_Value` | Text | |
|
91 | | `activity_customfield` | Text | |
|
92 | | `activity_fieldtype` | Text | nullable |
|
93 | | `customfield_podID` | Text | |
|
94 |
|
95 | #### ActivityStatus
|
96 | | | | |
|
97 | |-------------|-------------|-----|
|
98 | | `Closed_Flag` | Boolean | |
|
99 | | `Default_Flag` | Boolean | |
|
100 | | `Inactive_Flag` | Boolean | |
|
101 | | `Last_Update` | DateTime | |
|
102 | | `Last_Update_UTC` | DateTime | |
|
103 | | `SO_Act_Status_Desc` | Text | nullable |
|
104 | | `SO_Act_Status_RecID` | Numeric | |
|
105 | | `Time_Zone` | Text | nullable |
|
106 | | `Updated_By` | Text | nullable |
|
107 | | `spawn_followup_flag` | Boolean | nullable |
|
108 |
|
109 | #### ActivityType
|
110 | | | | |
|
111 | |-------------|-------------|-----|
|
112 | | `Default_Flag` | Boolean | |
|
113 | | `Inactive_Flag` | Boolean | nullable |
|
114 | | `Last_Update` | DateTime | nullable |
|
115 | | `Last_Update_UTC` | DateTime | |
|
116 | | `SO_Activity_Type_Desc` | Text | nullable |
|
117 | | `SO_Activity_Type_RecID` | Numeric | |
|
118 | | `Time_Zone` | Text | nullable |
|
119 | | `Updated_By` | Text | |
|
120 |
|
121 | #### AgrSite
|
122 | | | | |
|
123 | |-------------|-------------|-----|
|
124 | | `AGR_Header_RecID` | Numeric | nullable |
|
125 | | `AGR_Name` | Text | nullable |
|
126 | | `AGR_Site_RecID` | Numeric | |
|
127 | | `Company_RecID` | Numeric | nullable |
|
128 | | `Last_Update` | DateTime | |
|
129 | | `SiteId` | Numeric | nullable |
|
130 | | `Time_Zone` | Text | nullable |
|
131 | | `Updated_By` | Text | |
|
132 |
|
133 | #### AgrType
|
134 | | | | |
|
135 | |-------------|-------------|-----|
|
136 | | `AGR_Default_Flag` | Boolean | nullable |
|
137 | | `AGR_Detail_Type_ID` | Text | nullable |
|
138 | | `AGR_Detail_Type_RecID` | Numeric | nullable |
|
139 | | `AGR_Inactive_Flag` | Boolean | nullable |
|
140 | | `AGR_Type_Desc` | Text | nullable |
|
141 | | `AGR_Type_RecID` | Numeric | |
|
142 | | `Activity_Class_RecID` | Numeric | nullable |
|
143 | | `Activity_Type_RecID` | Numeric | nullable |
|
144 | | `AppCycle_ID` | Text | nullable |
|
145 | | `BL_InvTemplate_Custom_RecID` | Numeric | nullable |
|
146 | | `BU_Restrict_Flag` | Boolean | nullable |
|
147 | | `Bill_Amount` | Numeric | nullable |
|
148 | | `Bill_Cycle_RecID` | Numeric | nullable |
|
149 | | `Billing_Terms_RecID` | Numeric | nullable |
|
150 | | `Billing_Unit_RecID` | Numeric | nullable |
|
151 | | `BottomComment_Flag` | Boolean | nullable |
|
152 | | `BusGroup` | Text | nullable |
|
153 | | `Calc_Flag` | Numeric | nullable |
|
154 | | `Carryover_Days` | Numeric | nullable |
|
155 | | `Charge_Firm_Flag` | Boolean | nullable |
|
156 | | `Comp_Limit_Amount` | Numeric | nullable |
|
157 | | `Comp_Limit_Option` | Text | nullable |
|
158 | | `Comp_Rate_Amount` | Numeric | nullable |
|
159 | | `Comp_Rate_Option` | Text | nullable |
|
160 | | `Copy_Work_Roles_Flag` | Boolean | |
|
161 | | `Copy_Work_Types_Flag` | Boolean | |
|
162 | | `CycleBasis_ID` | Text | nullable |
|
163 | | `EX_Billable_Flag` | Boolean | nullable |
|
164 | | `EX_InvCust_Flag` | Boolean | nullable |
|
165 | | `EX_Invoice_Flag` | Boolean | nullable |
|
166 | | `IV_Billable_Flag` | Boolean | nullable |
|
167 | | `IV_InvCust_Flag` | Boolean | nullable |
|
168 | | `IV_Invoice_Flag` | Boolean | nullable |
|
169 | | `Invoice_Desc` | Text | nullable |
|
170 | | `Invoice_PreSuf` | Text | nullable |
|
171 | | `Last_Update` | DateTime | |
|
172 | | `OL_Restrict_Flag` | Boolean | nullable |
|
173 | | `OneTime_Flag` | Boolean | nullable |
|
174 | | `Overrun_Flag` | Boolean | nullable |
|
175 | | `Overrun_Limit` | Numeric | nullable |
|
176 | | `Owner_Level_RecID` | Numeric | nullable |
|
177 | | `PM_Type_RecID` | Numeric | nullable |
|
178 | | `PP_Amount` | Numeric | nullable |
|
179 | | `PP_Carryover_Flag` | Boolean | nullable |
|
180 | | `PP_Expenses_Flag` | Boolean | nullable |
|
181 | | `PP_Expire_Flag` | Boolean | nullable |
|
182 | | `PP_One_Time_Flag` | Boolean | nullable |
|
183 | | `PP_Products_Flag` | Boolean | nullable |
|
184 | | `PP_Tax_Flag` | Boolean | nullable |
|
185 | | `PP_Time_Flag` | Boolean | nullable |
|
186 | | `PP_Unlimited_Flag` | Boolean | nullable |
|
187 | | `PreSuf_Flag` | Boolean | nullable |
|
188 | | `Prepay_Flag` | Boolean | nullable |
|
189 | | `Restrict_DP_Flag` | Boolean | nullable |
|
190 | | `SR_SLA_RecID` | Numeric | nullable |
|
191 | | `SR_Urgency_RecID` | Numeric | nullable |
|
192 | | `TE_Amount` | Numeric | nullable |
|
193 | | `TE_AmtOption` | Numeric | nullable |
|
194 | | `TE_Billable_Flag` | Boolean | nullable |
|
195 | | `TE_InvCust_Flag` | Boolean | nullable |
|
196 | | `TE_Invoice_Flag` | Boolean | nullable |
|
197 | | `TE_UseAmt_Flag` | Numeric | nullable |
|
198 | | `TE_UseBill_Flag` | Numeric | nullable |
|
199 | | `TE_UseRate_Flag` | Numeric | nullable |
|
200 | | `Taxable_Flag` | Boolean | nullable |
|
201 | | `Time_Zone` | Text | nullable |
|
202 | | `TopComment_Flag` | Boolean | nullable |
|
203 | | `Updated_By` | Text | nullable |
|
204 | | `bl_invTemplate_recid` | Numeric | nullable |
|
205 | | `location` | Text | nullable |
|
206 |
|
207 | #### AgrUnits
|
208 | | | | |
|
209 | |-------------|-------------|-----|
|
210 | | `AGR_Detail_Type_Desc` | Text | nullable |
|
211 | | `AGR_Detail_Type_ID` | Text | nullable |
|
212 | | `Restrict_Flag` | Text | |
|
213 |
|
214 | #### AgreementAdditions
|
215 | | | | |
|
216 | |-------------|-------------|-----|
|
217 | | `AGR_Name` | Text | nullable |
|
218 | | `AGR_RecID` | Numeric | |
|
219 | | `Addition_RecId` | Numeric | |
|
220 | | `Addition_Status` | Text | |
|
221 | | `Bill_Customer` | Boolean | nullable |
|
222 | | `Cancelled_Date` | DateTime | nullable |
|
223 | | `Effective_Date` | DateTime | nullable |
|
224 | | `Ext_Cost` | Numeric | |
|
225 | | `Ext_Price` | Numeric | |
|
226 | | `Last_Update` | DateTime | nullable |
|
227 | | `Last_Update_UTC` | DateTime | |
|
228 | | `Less_Included` | Numeric | nullable |
|
229 | | `Margin` | Numeric | nullable |
|
230 | | `Product_Description` | Text | nullable |
|
231 | | `Product_RecId` | Numeric | nullable |
|
232 | | `Purchase_Item_Flag` | Boolean | |
|
233 | | `QuantityToBill` | Numeric | nullable |
|
234 | | `Sequence_Number` | Numeric | |
|
235 | | `Serial_Number` | Text | nullable |
|
236 | | `Taxable` | Boolean | nullable |
|
237 | | `Time_Zone` | Text | nullable |
|
238 | | `Total_Quantity` | Numeric | nullable |
|
239 | | `Unit_Cost` | Numeric | nullable |
|
240 | | `Unit_Price` | Numeric | nullable |
|
241 | | `Updated_By` | Text | nullable |
|
242 |
|
243 | #### AgreementAppCycle
|
244 | | | | |
|
245 | |-------------|-------------|-----|
|
246 | | `AGR_AppCycle_RecID` | Numeric | |
|
247 | | `AppCycle_ID` | Text | nullable |
|
248 | | `AppCycle_Name` | Text | nullable |
|
249 | | `cycle_basis` | Text | nullable |
|
250 | | `cycle_interval` | Numeric | nullable |
|
251 |
|
252 | #### AgreementAudit
|
253 | | | | |
|
254 | |-------------|-------------|-----|
|
255 | | `AGR_Audit_RecID` | Numeric | |
|
256 | | `AGR_Header_RecID` | Numeric | |
|
257 | | `Audit_Source_ID` | Text | |
|
258 | | `Audit_Text` | Text | nullable |
|
259 | | `Audit_Type_ID` | Text | |
|
260 | | `Last_Updated_UTC` | DateTime | |
|
261 | | `Locale_Text_key` | Text | nullable |
|
262 | | `Updated_By` | Text | nullable |
|
263 |
|
264 | #### AgreementInvoice
|
265 | | | | |
|
266 | |-------------|-------------|-----|
|
267 | | `AGR_Header_RecID` | Numeric | nullable |
|
268 | | `AGR_Name` | Text | nullable |
|
269 | | `Billing_Log_RecID` | Numeric | |
|
270 | | `Company_RecID` | Numeric | nullable |
|
271 | | `Created_By` | Text | nullable |
|
272 | | `Date_Created` | DateTime | nullable |
|
273 | | `Date_Invoice` | DateTime | nullable |
|
274 | | `Invoice_Number` | Text | nullable |
|
275 | | `Last_Update` | DateTime | nullable |
|
276 | | `Run_Date` | DateTime | nullable |
|
277 | | `Run_Month` | Numeric | nullable |
|
278 | | `Run_Year` | Numeric | nullable |
|
279 | | `Time_Zone` | Text | nullable |
|
280 | | `Updated_By` | Text | nullable |
|
281 |
|
282 | #### AgreementList
|
283 | | | | |
|
284 | |-------------|-------------|-----|
|
285 | | `AGR_Detail_Type_Desc` | Text | nullable |
|
286 | | `AGR_Header_RecID` | Numeric | |
|
287 | | `AGR_Name` | Text | nullable |
|
288 | | `Agreement_Start_Date` | DateTime | nullable |
|
289 | | `Agreement_Status` | Text | |
|
290 | | `BalAvailable` | Numeric | |
|
291 | | `BalRemaining` | Numeric | |
|
292 | | `Bill_Start_Date` | DateTime | nullable |
|
293 | | `Billing_Amount` | Numeric | nullable |
|
294 | | `Billing_CycleOption_RecID` | Numeric | nullable |
|
295 | | `Billing_Cycle_Desc` | Text | nullable |
|
296 | | `Billing_Unit_Name` | Text | nullable |
|
297 | | `CompanyRecId` | Numeric | |
|
298 | | `Company_Name` | Text | nullable |
|
299 | | `DateEnd` | DateTime | nullable |
|
300 | | `DateStart` | DateTime | nullable |
|
301 | | `EX_Billable_Flag` | Boolean | |
|
302 | | `EX_Invoice_Flag` | Boolean | |
|
303 | | `IV_Billable_Flag` | Boolean | |
|
304 | | `IV_Invoice_Flag` | Boolean | |
|
305 | | `Last_Update` | DateTime | nullable |
|
306 | | `Location` | Numeric | nullable |
|
307 | | `Nbr_Cycles` | Numeric | nullable |
|
308 | | `Owner_Level_Name` | Text | nullable |
|
309 | | `PM_Type_RecID` | Numeric | |
|
310 | | `Parent_Agreement_Name` | Text | nullable |
|
311 | | `Parent_Agreement_RecID` | Numeric | nullable |
|
312 | | `TE_Billable_Flag` | Boolean | |
|
313 | | `TE_Invoice_Flag` | Boolean | |
|
314 | | `Time_Zone` | Text | nullable |
|
315 | | `Universal_Formatted_Date_End` | DateTime | nullable |
|
316 | | `Universal_Formatted_Date_Start` | DateTime | nullable |
|
317 | | `UnlimitedFlag` | Boolean | |
|
318 | | `Updated_By` | Text | nullable |
|
319 | | `Valid_flag` | Boolean | nullable |
|
320 | | `agr_type_desc` | Text | nullable |
|
321 | | `agr_type_recid` | Numeric | nullable |
|
322 | | `billing_unit_recid` | Numeric | nullable |
|
323 | | `company_recid` | Numeric | |
|
324 | | `owner_level_recid` | Numeric | nullable |
|
325 |
|
326 | #### Batch
|
327 | | | | |
|
328 | |-------------|-------------|-----|
|
329 | | `Closed_Flag` | Boolean | nullable |
|
330 | | `Expense_Flag` | Boolean | nullable |
|
331 | | `GL_BatchID` | Text | nullable |
|
332 | | `Invoice_Flag` | Boolean | nullable |
|
333 | | `Last_Update` | DateTime | nullable |
|
334 | | `Procurement_Flag` | Boolean | nullable |
|
335 | | `RecID` | Numeric | |
|
336 | | `Updated_By` | Text | nullable |
|
337 |
|
338 | #### BillRateType
|
339 | | | | |
|
340 | |-------------|-------------|-----|
|
341 | | `Description` | Text | nullable |
|
342 | | `Last_Update` | DateTime | nullable |
|
343 | | `Rate_Type_ID` | Text | |
|
344 | | `Rate_Type_RecID` | Numeric | |
|
345 | | `Sort_Order` | Numeric | |
|
346 | | `Time_Zone` | Text | nullable |
|
347 | | `Updated_By` | Text | nullable |
|
348 |
|
349 | #### BillableOptions
|
350 | | | | |
|
351 | |-------------|-------------|-----|
|
352 | | `Billable_Flag` | Boolean | nullable |
|
353 | | `Billable_Options_RecID` | Numeric | |
|
354 | | `Default_Flag` | Boolean | nullable |
|
355 | | `Expense_Flag` | Boolean | nullable |
|
356 | | `Include_Nodefault_Flag` | Boolean | nullable |
|
357 | | `Invoice_Flag` | Boolean | nullable |
|
358 | | `Option_ID` | Text | nullable |
|
359 | | `Option_Text` | Text | nullable |
|
360 | | `Product_Flag` | Boolean | nullable |
|
361 | | `Time_Flag` | Boolean | nullable |
|
362 |
|
363 | #### BillingCycle
|
364 | | | | |
|
365 | |-------------|-------------|-----|
|
366 | | `Bill_Cycle_Desc` | Text | |
|
367 | | `Bill_Cycle_ID` | Text | |
|
368 | | `Bill_Cycle_RecID` | Numeric | |
|
369 | | `Cycle_Basis` | Text | nullable |
|
370 | | `Default_Flag` | Boolean | |
|
371 | | `Inactive_Flag` | Numeric | nullable |
|
372 | | `Last_Update` | DateTime | |
|
373 | | `Nbr_Cycles` | Numeric | nullable |
|
374 | | `Nbr_of_Months` | Numeric | nullable |
|
375 | | `Time_Zone` | Text | nullable |
|
376 | | `Updated_By` | Text | nullable |
|
377 | | `cycle_interval` | Numeric | nullable |
|
378 |
|
379 | #### BillingDelivery
|
380 | | | | |
|
381 | |-------------|-------------|-----|
|
382 | | `Billing_Delivery_RecID` | Numeric | |
|
383 | | `Default_Flag` | Boolean | |
|
384 | | `Description` | Text | nullable |
|
385 | | `Email_Flag` | Boolean | nullable |
|
386 | | `Last_Update` | DateTime | nullable |
|
387 | | `Time_Zone` | Text | nullable |
|
388 | | `Updated_By` | Text | nullable |
|
389 |
|
390 | #### BillingSetup
|
391 | | | | |
|
392 | |-------------|-------------|-----|
|
393 | | `Actual_InvTemplate_Setup_RecID` | Numeric | nullable |
|
394 | | `Agreement_InvTemplate_Setup_RecID` | Numeric | nullable |
|
395 | | `Ava_Validated_Flag` | Boolean | |
|
396 | | `Billing_Setup_RecID` | Numeric | |
|
397 | | `Credit_Memo_InvTemplate_Setup_RecID` | Numeric | nullable |
|
398 | | `Currency_RecID` | Numeric | nullable |
|
399 | | `Default_InvTemplate_Setup_RecID` | Numeric | nullable |
|
400 | | `Downpayment_InvTemplate_Setup_RecID` | Numeric | nullable |
|
401 | | `Email_Template_RecID` | Numeric | nullable |
|
402 | | `Exclude_Avalara_Flag` | Boolean | |
|
403 | | `Expense_Tax_Flag` | Boolean | |
|
404 | | `Fixed_Fee_InvTemplate_Setup_RecID` | Numeric | nullable |
|
405 | | `Invoice_Footer` | Text | nullable |
|
406 | | `Invoice_PreSuf` | Text | nullable |
|
407 | | `Invoice_Title` | Text | nullable |
|
408 | | `Last_Update` | DateTime | nullable |
|
409 | | `Misc_InvTemplate_Setup_RecID` | Numeric | nullable |
|
410 | | `Owner_Level_RecID` | Numeric | nullable |
|
411 | | `Payable_Name` | Text | nullable |
|
412 | | `PreSuf_Flag` | Boolean | nullable |
|
413 | | `Progress_InvTemplate_Setup_RecID` | Numeric | nullable |
|
414 | | `Remit_Address_Line1` | Text | nullable |
|
415 | | `Remit_Address_Line2` | Text | nullable |
|
416 | | `Remit_City` | Text | nullable |
|
417 | | `Remit_Country_RecID` | Numeric | nullable |
|
418 | | `Remit_Name` | Text | |
|
419 | | `Remit_Phone` | Text | nullable |
|
420 | | `Remit_State_ID` | Text | nullable |
|
421 | | `Remit_Zip` | Text | nullable |
|
422 | | `Time_Zone` | Text | nullable |
|
423 | | `Top_Comment` | Text | nullable |
|
424 | | `Updated_By` | Text | nullable |
|
425 | | `country_recid` | Numeric | nullable |
|
426 |
|
427 | #### BillingStatus
|
428 | | | | |
|
429 | |-------------|-------------|-----|
|
430 | | `Billing_Status_RecID` | Numeric | |
|
431 | | `Closed_Flag` | Boolean | |
|
432 | | `Default_Flag` | Boolean | |
|
433 | | `Description` | Text | nullable |
|
434 | | `Inactive_Flag` | Boolean | |
|
435 | | `Last_Update` | DateTime | nullable |
|
436 | | `Sent_Flag` | Boolean | |
|
437 | | `Time_Zone` | Text | nullable |
|
438 | | `Updated_By` | Text | nullable |
|
439 |
|
440 | #### BillingTerms
|
441 | | | | |
|
442 | |-------------|-------------|-----|
|
443 | | `Billing_Terms_RecID` | Numeric | |
|
444 | | `Default_Flag` | Boolean | |
|
445 | | `Description` | Text | nullable |
|
446 |
|
447 | #### BillingUnit
|
448 | | | | |
|
449 | |-------------|-------------|-----|
|
450 | | `Billing_Unit_RecID` | Numeric | |
|
451 | | `BusGroup` | Text | nullable |
|
452 | | `Last_Update` | DateTime | |
|
453 | | `Time_Zone` | Text | nullable |
|
454 | | `Updated_By` | Text | nullable |
|
455 |
|
456 | #### BillingUnitLocation
|
457 | | | | |
|
458 | |-------------|-------------|-----|
|
459 | | `Billing_Unit_Loc_RecID` | Numeric | |
|
460 | | `Billing_Unit_RecID` | Numeric | |
|
461 | | `Description` | Text | nullable |
|
462 | | `Dispatch` | Numeric | nullable |
|
463 | | `DutyManager` | Numeric | nullable |
|
464 | | `Last_Update` | DateTime | |
|
465 | | `Member_RecID` | Numeric | nullable |
|
466 | | `Owner_Level_RecID` | Numeric | |
|
467 | | `ServiceManager` | Numeric | nullable |
|
468 | | `Time_Zone` | Text | nullable |
|
469 | | `Updated_By` | Text | |
|
470 |
|
471 | #### C_Invoices
|
472 | | | | |
|
473 | |-------------|-------------|-----|
|
474 | | `AgreementType` | Text | nullable |
|
475 | | `Applied_Amount` | Numeric | |
|
476 | | `BillingDelivery` | Text | nullable |
|
477 | | `BillingType` | Text | nullable |
|
478 | | `BillingUnit` | Text | nullable |
|
479 | | `Closed` | Text | nullable |
|
480 | | `CompanyName` | Text | nullable |
|
481 | | `DatePaid` | DateTime | nullable |
|
482 | | `GLBatch` | Text | nullable |
|
483 | | `GLPosted` | Text | |
|
484 | | `InternalNote` | Text | nullable |
|
485 | | `InvoiceAmount` | Numeric | nullable |
|
486 | | `InvoiceDate` | DateTime | nullable |
|
487 | | `InvoiceNumber` | Text | nullable |
|
488 | | `InvoiceSent` | Boolean | nullable |
|
489 | | `InvoiceStatus` | Text | nullable |
|
490 | | `Location` | Text | nullable |
|
491 | | `ProjectPhase` | Text | nullable |
|
492 | | `RemitToCompany` | Text | nullable |
|
493 | | `RoutedTo` | Text | nullable |
|
494 | | `ServiceTicket` | Numeric | nullable |
|
495 | | `Territory` | Text | nullable |
|
496 |
|
497 | #### C_LifeGuarding
|
498 | | | | |
|
499 | |-------------|-------------|-----|
|
500 | | `AgrType` | Text | nullable |
|
501 | | `CLOSE DATE` | DateTime | nullable |
|
502 | | `CancelDate` | DateTime | nullable |
|
503 | | `City` | Text | nullable |
|
504 | | `Closed Tickets` | Numeric | nullable |
|
505 | | `Company Name` | Text | nullable |
|
506 | | `Company Status` | Text | nullable |
|
507 | | `Company TYPE` | Text | |
|
508 | | `Config Name` | Text | nullable |
|
509 | | `Country` | Text | nullable |
|
510 | | `Department` | Text | nullable |
|
511 | | `Division` | Text | nullable |
|
512 | | `EndDate` | DateTime | nullable |
|
513 | | `GL License` | Text | nullable |
|
514 | | `HoursBudget` | Numeric | nullable |
|
515 | | `Hours_Billable` | Numeric | nullable |
|
516 | | `Inactive/Terminated DATE` | Text | nullable |
|
517 | | `Installed DATE` | DateTime | nullable |
|
518 | | `Inventory License` | Text | nullable |
|
519 | | `MSP License` | Text | nullable |
|
520 | | `Mobile Users` | Text | nullable |
|
521 | | `Model` | Text | nullable |
|
522 | | `OPEN Tickets` | Numeric | nullable |
|
523 | | `Partner Advocate Tickets` | Numeric | nullable |
|
524 | | `Project` | Text | nullable |
|
525 | | `Project Tickets` | Numeric | nullable |
|
526 | | `ProjectManager` | Text | nullable |
|
527 | | `ProjectStatus` | Text | nullable |
|
528 | | `Purchasing Receiving License` | Text | nullable |
|
529 | | `Quoteworks` | Text | nullable |
|
530 | | `Reason` | Text | nullable |
|
531 | | `STATE` | Text | nullable |
|
532 | | `Sales Rep` | Text | nullable |
|
533 | | `Serial Number` | Text | nullable |
|
534 | | `Spam Stats` | Text | nullable |
|
535 | | `StartDate` | DateTime | nullable |
|
536 | | `TagNumber` | Text | nullable |
|
537 | | `Termination Board Tickets` | Numeric | nullable |
|
538 | | `Termination Reason` | Text | nullable |
|
539 | | `Termination Status Tickets` | Numeric | nullable |
|
540 | | `Total Revenue` | Numeric | |
|
541 | | `University Tickets` | Numeric | nullable |
|
542 | | `Users` | Numeric | nullable |
|
543 |
|
544 | #### C_PartnerReviewTerminationAndLifeguarding
|
545 | | | | |
|
546 | |-------------|-------------|-----|
|
547 | | `ClosedProjectTickets` | Numeric | nullable |
|
548 | | `ClosedServiceTickets` | Numeric | nullable |
|
549 | | `CompanyName` | Text | nullable |
|
550 | | `CompanyStatus` | Text | nullable |
|
551 | | `CompanyType` | Text | |
|
552 | | `OpenProjectTickets` | Numeric | nullable |
|
553 | | `OpenServiceTickets` | Numeric | nullable |
|
554 | | `TotalProjectTickets` | Numeric | nullable |
|
555 | | `TotalServiceTickets` | Numeric | nullable |
|
556 | | `TotalTickets` | Numeric | nullable |
|
557 |
|
558 | #### Calendar
|
559 | | | | |
|
560 | |-------------|-------------|-----|
|
561 | | `Description` | Text | |
|
562 | | `Friday_End` | DateTime | nullable |
|
563 | | `Friday_Start` | DateTime | nullable |
|
564 | | `Holiday_List_RecID` | Numeric | nullable |
|
565 | | `Last_Update_UTC` | DateTime | |
|
566 | | `Monday_End` | DateTime | nullable |
|
567 | | `Monday_Start` | DateTime | nullable |
|
568 | | `Office_Calendar_RecID` | Numeric | |
|
569 | | `Saturday_End` | DateTime | nullable |
|
570 | | `Saturday_Start` | DateTime | nullable |
|
571 | | `Sunday_End` | DateTime | nullable |
|
572 | | `Sunday_Start` | DateTime | nullable |
|
573 | | `Thursday_End` | DateTime | nullable |
|
574 | | `Thursday_Start` | DateTime | nullable |
|
575 | | `Time_Zone` | Text | nullable |
|
576 | | `Tuesday_End` | DateTime | nullable |
|
577 | | `Tuesday_Start` | DateTime | nullable |
|
578 | | `Updated_By` | Text | |
|
579 | | `Wednesday_End` | DateTime | nullable |
|
580 | | `Wednesday_Start` | DateTime | nullable |
|
581 |
|
582 | #### CalendarSetup
|
583 | | | | |
|
584 | |-------------|-------------|-----|
|
585 | | `Adj1End` | DateTime | nullable |
|
586 | | `Adj1Hours` | Numeric | nullable |
|
587 | | `Adj1Start` | DateTime | nullable |
|
588 | | `Adj2End` | DateTime | nullable |
|
589 | | `Adj2Hours` | Numeric | nullable |
|
590 | | `Adj2Start` | DateTime | nullable |
|
591 | | `Adj3End` | DateTime | nullable |
|
592 | | `Adj3Hours` | Numeric | nullable |
|
593 | | `Adj3Start` | DateTime | nullable |
|
594 | | `Calendar_Setup_RecID` | Numeric | |
|
595 | | `Last_Update` | DateTime | nullable |
|
596 | | `Time_Zone` | Text | nullable |
|
597 | | `Updated_by` | Text | nullable |
|
598 | | `Week_Start` | Numeric | nullable |
|
599 |
|
600 | #### CampaignStatus
|
601 | | | | |
|
602 | |-------------|-------------|-----|
|
603 | | `Campaign_Status_RecID` | Numeric | |
|
604 | | `Default_Flag` | Boolean | |
|
605 | | `Description` | Text | |
|
606 | | `Inactive_Flag` | Boolean | |
|
607 | | `Last_Update` | DateTime | |
|
608 | | `Time_Zone` | Text | nullable |
|
609 | | `Updated_By` | Text | |
|
610 |
|
611 | #### CampaignSubType
|
612 | | | | |
|
613 | |-------------|-------------|-----|
|
614 | | `Campaign_SubType_RecID` | Numeric | |
|
615 | | `Campaign_Type_RecID` | Numeric | |
|
616 | | `Description` | Text | |
|
617 | | `Last_Update` | DateTime | |
|
618 | | `Time_Zone` | Text | nullable |
|
619 | | `Updated_By` | Text | |
|
620 |
|
621 | #### CampaignTracking
|
622 | | | | |
|
623 | |-------------|-------------|-----|
|
624 | | `Clicked_Count` | Numeric | nullable |
|
625 | | `Contact_RecID` | Numeric | nullable |
|
626 | | `Date_First_Clicked` | DateTime | nullable |
|
627 | | `Date_First_Opened` | DateTime | nullable |
|
628 | | `Date_First_Unknown_Action` | DateTime | nullable |
|
629 | | `Date_Last_Clicked` | DateTime | nullable |
|
630 | | `Date_Last_Opened` | DateTime | nullable |
|
631 | | `Date_Last_Unknown_Action` | DateTime | nullable |
|
632 | | `Marketing_Campaign_RecID` | Numeric | |
|
633 | | `Marketing_Campaign_Tracking_RecID` | Numeric | |
|
634 | | `Opened_Count` | Numeric | nullable |
|
635 | | `Time_Zone` | Text | nullable |
|
636 | | `Unknown_Action_Count` | Numeric | nullable |
|
637 |
|
638 | #### CampaignType
|
639 | | | | |
|
640 | |-------------|-------------|-----|
|
641 | | `Campaign_Type_RecID` | Numeric | |
|
642 | | `Default_Flag` | Boolean | |
|
643 | | `Description` | Text | |
|
644 | | `Last_Update` | DateTime | |
|
645 | | `Time_Zone` | Text | nullable |
|
646 | | `Updated_By` | Text | |
|
647 |
|
648 | #### ChargeCode
|
649 | | | | |
|
650 | |-------------|-------------|-----|
|
651 | | `Activity_Class_RecID` | Numeric | nullable |
|
652 | | `Activity_Type_RecID` | Numeric | nullable |
|
653 | | `Billable_Flag` | Boolean | |
|
654 | | `Billing_Unit_RecID` | Numeric | nullable |
|
655 | | `Company_RecID` | Numeric | nullable |
|
656 | | `Description` | Text | nullable |
|
657 | | `EX_Type_Flag` | Boolean | |
|
658 | | `Expense_Flag` | Boolean | |
|
659 | | `Invoice_Flag` | Boolean | nullable |
|
660 | | `Last_Update` | DateTime | |
|
661 | | `Last_Update_UTC` | DateTime | |
|
662 | | `Owner_Level_RecID` | Numeric | nullable |
|
663 | | `TE_Charge_Code_RecID` | Numeric | |
|
664 | | `Time_Flag` | Boolean | |
|
665 | | `Time_Zone` | Text | nullable |
|
666 | | `Updated_By` | Text | nullable |
|
667 |
|
668 | #### CommunicationType
|
669 | | | | |
|
670 | |-------------|-------------|-----|
|
671 | | `Communication_Name` | Text | nullable |
|
672 | | `Communication_Type_RecID` | Numeric | |
|
673 | | `Default_flag` | Boolean | |
|
674 | | `Email_Flag` | Boolean | |
|
675 | | `Fax_Flag` | Boolean | |
|
676 | | `Last_Update` | DateTime | |
|
677 | | `Phone_Flag` | Boolean | |
|
678 | | `Time_Zone` | Text | nullable |
|
679 | | `Updated_By` | Text | |
|
680 |
|
681 | #### Company
|
682 | | | | |
|
683 | |-------------|-------------|-----|
|
684 | | `Account_Nbr` | Text | nullable |
|
685 | | `Annual_Revenue` | Numeric | |
|
686 | | `BL_InvTemplate_Setup_RecID` | Numeric | nullable |
|
687 | | `Bill_To_Company_Address_RecID` | Numeric | nullable |
|
688 | | `Bill_To_Company_Name` | Text | nullable |
|
689 | | `Bill_To_Company_RecID` | Numeric | nullable |
|
690 | | `Bill_To_Contact_RecID` | Numeric | nullable |
|
691 | | `Bill_To_Description` | Text | nullable |
|
692 | | `Bill_To_First_Name` | Text | nullable |
|
693 | | `Bill_To_Last_Name` | Text | nullable |
|
694 | | `Billable_Flag` | Numeric | nullable |
|
695 | | `Billing_Terms_Desc` | Text | nullable |
|
696 | | `Billing_Terms_RecID` | Numeric | nullable |
|
697 | | `Company_Calendar` | Text | nullable |
|
698 | | `Company_ID` | Text | nullable |
|
699 | | `Company_Name` | Text | nullable |
|
700 | | `Company_RecID` | Numeric | |
|
701 | | `Company_Status_Desc` | Text | nullable |
|
702 | | `Company_Status_RecID` | Numeric | nullable |
|
703 | | `Company_Type_Desc` | Text | nullable |
|
704 | | `Company_Type_RecID` | Text | nullable |
|
705 | | `Contact_RecID` | Numeric | nullable |
|
706 | | `Currency_Desc` | Text | nullable |
|
707 | | `Currency_ID` | Text | nullable |
|
708 | | `Currency_RecID` | Numeric | nullable |
|
709 | | `Custom_Note` | Text | nullable |
|
710 | | `Customer_Usage_Type_RecID` | Numeric | nullable |
|
711 | | `Date_Acquired` | DateTime | nullable |
|
712 | | `Date_Acquired_UTC` | DateTime | nullable |
|
713 | | `Date_Entered` | DateTime | |
|
714 | | `Date_Entered_UTC` | DateTime | |
|
715 | | `Default_Contact_Email` | Text | nullable |
|
716 | | `Default_Contact_First_Name` | Text | nullable |
|
717 | | `Default_Contact_Last_Name` | Text | nullable |
|
718 | | `Delete_Flag` | Boolean | |
|
719 | | `Delivery_Method` | Text | nullable |
|
720 | | `Due_Days` | Numeric | nullable |
|
721 | | `Email_Cc_Address` | Text | nullable |
|
722 | | `Email_Cc_Flag` | Boolean | |
|
723 | | `Entered_By` | Text | |
|
724 | | `IV_Price_Header_RecID` | Numeric | nullable |
|
725 | | `Last_Update` | DateTime | |
|
726 | | `Last_Update_UTC` | DateTime | |
|
727 | | `Lead_Flag` | Boolean | |
|
728 | | `Lead_Source` | Text | nullable |
|
729 | | `Location` | Text | nullable |
|
730 | | `Market_Desc` | Text | nullable |
|
731 | | `Market_RecID` | Numeric | nullable |
|
732 | | `Nbr_Employees` | Numeric | nullable |
|
733 | | `Office_Calendar_RecID` | Numeric | nullable |
|
734 | | `Owner_Level_RecID` | Numeric | nullable |
|
735 | | `OwnershipType` | Text | nullable |
|
736 | | `Parent_Company_RecID` | Numeric | nullable |
|
737 | | `PhoneNbr` | Text | nullable |
|
738 | | `PhoneNbr_Fax` | Text | nullable |
|
739 | | `Remit_To_RecID` | Numeric | nullable |
|
740 | | `Revenue_Year` | Numeric | nullable |
|
741 | | `SIC_Code_ID` | Text | nullable |
|
742 | | `Tax_Code_Desc` | Text | nullable |
|
743 | | `Tax_Code_ID` | Text | nullable |
|
744 | | `Tax_Code_RecID` | Numeric | nullable |
|
745 | | `Tax_ID` | Text | nullable |
|
746 | | `Time_Zone` | Text | nullable |
|
747 | | `Time_Zone_RecID` | Numeric | nullable |
|
748 | | `Unsubscribe_Flag` | Boolean | nullable |
|
749 | | `Updated_By` | Text | |
|
750 | | `Userfield10_Caption` | Text | nullable |
|
751 | | `Userfield1_Caption` | Text | nullable |
|
752 | | `Userfield2_Caption` | Text | nullable |
|
753 | | `Userfield3_Caption` | Text | nullable |
|
754 | | `Userfield4_Caption` | Text | nullable |
|
755 | | `Userfield5_Caption` | Text | nullable |
|
756 | | `Userfield6_Caption` | Text | nullable |
|
757 | | `Userfield7_Caption` | Text | nullable |
|
758 | | `Userfield8_Caption` | Text | nullable |
|
759 | | `Userfield9_Caption` | Text | nullable |
|
760 | | `Userfield_1` | Text | nullable |
|
761 | | `Userfield_10` | Text | nullable |
|
762 | | `Userfield_2` | Text | nullable |
|
763 | | `Userfield_3` | Text | nullable |
|
764 | | `Userfield_4` | Text | nullable |
|
765 | | `Userfield_5` | Text | nullable |
|
766 | | `Userfield_6` | Text | nullable |
|
767 | | `Userfield_7` | Text | nullable |
|
768 | | `Userfield_8` | Text | nullable |
|
769 | | `Userfield_9` | Text | nullable |
|
770 | | `Vendor_Nbr` | Text | nullable |
|
771 | | `Website_URL` | Text | nullable |
|
772 |
|
773 | #### CompanyAddress
|
774 | | | | |
|
775 | |-------------|-------------|-----|
|
776 | | `Address_Line1` | Text | nullable |
|
777 | | `Address_Line2` | Text | nullable |
|
778 | | `City` | Text | nullable |
|
779 | | `Company_Address_RecID` | Numeric | |
|
780 | | `Company_ID` | Text | nullable |
|
781 | | `Company_Name` | Text | nullable |
|
782 | | `Company_RecID` | Numeric | |
|
783 | | `Country` | Text | nullable |
|
784 | | `Default_Bill_Flag` | Boolean | |
|
785 | | `Default_Flag` | Boolean | |
|
786 | | `Default_Mail_Flag` | Boolean | |
|
787 | | `Default_Ship_Flag` | Boolean | |
|
788 | | `Expense_Reimbursement` | Numeric | nullable |
|
789 | | `Inactive_Flag` | Boolean | |
|
790 | | `Last_Update` | DateTime | nullable |
|
791 | | `Last_Update_UTC` | DateTime | |
|
792 | | `PhoneNbr` | Text | nullable |
|
793 | | `PhoneNbr_Fax` | Text | nullable |
|
794 | | `Site_Name` | Text | nullable |
|
795 | | `State_ID` | Text | nullable |
|
796 | | `Tax_Code_Desc` | Text | nullable |
|
797 | | `Tax_Code_ID` | Text | nullable |
|
798 | | `Time_Zone` | Text | nullable |
|
799 | | `Updated_By` | Text | nullable |
|
800 | | `Zip` | Text | nullable |
|
801 |
|
802 | #### CompanyCompanyTypeDescriptions
|
803 | | | | |
|
804 | |-------------|-------------|-----|
|
805 | | `Company_RecID` | Numeric | |
|
806 | | `Company_Types` | Text | nullable |
|
807 |
|
808 | #### CompanyCompanyTypes
|
809 | | | | |
|
810 | |-------------|-------------|-----|
|
811 | | `Company_ID` | Text | nullable |
|
812 | | `Company_Name` | Text | nullable |
|
813 | | `Company_RecID` | Numeric | |
|
814 | | `Company_Type_RecID` | Numeric | |
|
815 | | `Description` | Text | |
|
816 | | `Service_Alert_Flag` | Boolean | |
|
817 | | `Service_Alert_Message` | Text | nullable |
|
818 |
|
819 | #### CompanyContactCommunication
|
820 | | | | |
|
821 | |-------------|-------------|-----|
|
822 | | `BusinessPhone_Ext` | Text | nullable |
|
823 | | `Business_Phone` | Text | nullable |
|
824 | | `Business_Phone_Unformatted` | Text | nullable |
|
825 | | `Company_Address1` | Text | nullable |
|
826 | | `Company_Address2` | Text | nullable |
|
827 | | `Company_City` | Text | nullable |
|
828 | | `Company_Fax` | Text | nullable |
|
829 | | `Company_ID` | Text | nullable |
|
830 | | `Company_Name` | Text | nullable |
|
831 | | `Company_Phone` | Text | nullable |
|
832 | | `Company_State` | Text | nullable |
|
833 | | `Company_Zipcode` | Text | nullable |
|
834 | | `Contact_First_Name` | Text | nullable |
|
835 | | `Contact_Last_Name` | Text | nullable |
|
836 | | `Contact_RecID` | Numeric | |
|
837 | | `Date_Anniversary` | DateTime | nullable |
|
838 | | `Date_Birth` | DateTime | nullable |
|
839 | | `Email` | Text | nullable |
|
840 | | `Fax` | Text | nullable |
|
841 | | `Fax_Ext` | Text | nullable |
|
842 | | `Fax_Unformatted` | Text | nullable |
|
843 | | `Gender` | Text | nullable |
|
844 | | `HomePhone_Ext` | Text | nullable |
|
845 | | `Home_Phone` | Text | nullable |
|
846 | | `Home_Phone_Unformatted` | Text | nullable |
|
847 | | `MobilePhone_Ext` | Text | nullable |
|
848 | | `Mobile_Phone` | Text | nullable |
|
849 | | `Mobile_Phone_Unformatted` | Text | nullable |
|
850 | | `NickName` | Text | nullable |
|
851 | | `Pager` | Text | nullable |
|
852 | | `Pager_Ext` | Text | nullable |
|
853 | | `Pager_Unformatted` | Text | nullable |
|
854 | | `Reportsto_Name` | Text | nullable |
|
855 | | `Spouse_Name` | Text | nullable |
|
856 | | `Title` | Text | nullable |
|
857 |
|
858 | #### CompanyCustomFields
|
859 | | | | |
|
860 | |-------------|-------------|-----|
|
861 | | `Company_ID` | Text | nullable |
|
862 | | `Company_RecID` | Numeric | |
|
863 | | `Last_Update_UTC` | DateTime | |
|
864 | | `Pod_RecID` | Numeric | |
|
865 | | `Updated_By` | Text | |
|
866 | | `User_Defined_Field_RecID` | Numeric | |
|
867 | | `User_Defined_Field_Value` | Text | |
|
868 | | `company_customfield` | Text | |
|
869 | | `company_fieldtype` | Text | nullable |
|
870 | | `customfield_podID` | Text | |
|
871 |
|
872 | #### CompanyEntityType
|
873 | | | | |
|
874 | |-------------|-------------|-----|
|
875 | | `Description` | Text | |
|
876 | | `Entity_Type_RecID` | Numeric | |
|
877 |
|
878 | #### CompanyGroup
|
879 | | | | |
|
880 | |-------------|-------------|-----|
|
881 | | `AllContacts_Flag` | Boolean | |
|
882 | | `Company_Group_RecID` | Numeric | |
|
883 | | `Company_RecID` | Numeric | |
|
884 | | `DefaultContact_Flag` | Boolean | |
|
885 | | `Group_Type_Desc` | Text | nullable |
|
886 | | `Group_Type_RecID` | Numeric | |
|
887 | | `Last_Update` | DateTime | |
|
888 | | `Time_Zone` | Text | nullable |
|
889 | | `Unsubscribe_Flag` | Boolean | nullable |
|
890 | | `Updated_By` | Text | |
|
891 |
|
892 | #### CompanyMarkets
|
893 | | | | |
|
894 | |-------------|-------------|-----|
|
895 | | `Company_Name` | Text | nullable |
|
896 | | `Company_RecID` | Numeric | nullable |
|
897 | | `Last_Update` | DateTime | |
|
898 | | `MarketDescription` | Text | nullable |
|
899 | | `Market_RecID` | Numeric | |
|
900 | | `Time_Zone` | Text | nullable |
|
901 | | `Updated_By` | Text | nullable |
|
902 |
|
903 | #### CompanyMgmt
|
904 | | | | |
|
905 | |-------------|-------------|-----|
|
906 | | `AGR_Header_RecID` | Numeric | nullable |
|
907 | | `AGR_Name` | Text | nullable |
|
908 | | `Company_ID` | Text | nullable |
|
909 | | `Company_Mgmt_RecID` | Numeric | |
|
910 | | `Company_Name` | Text | nullable |
|
911 | | `Company_RecID` | Numeric | |
|
912 | | `Device_Type` | Text | nullable |
|
913 | | `Group_Guid` | Text | nullable |
|
914 | | `Group_ID` | Text | nullable |
|
915 | | `Last_Update` | DateTime | nullable |
|
916 | | `Last_Update_UTC` | DateTime | |
|
917 | | `Mgmt_It_Setup_RecID` | Numeric | nullable |
|
918 | | `Mgmt_Setup_Name` | Text | nullable |
|
919 | | `Time_Zone` | Text | nullable |
|
920 | | `Updated_By` | Text | nullable |
|
921 |
|
922 | #### CompanyProfileUserfields
|
923 | | | | |
|
924 | |-------------|-------------|-----|
|
925 | | `Company_Userfield_1` | Text | nullable |
|
926 | | `Company_Userfield_10` | Text | nullable |
|
927 | | `Company_Userfield_2` | Text | nullable |
|
928 | | `Company_Userfield_3` | Text | nullable |
|
929 | | `Company_Userfield_4` | Text | nullable |
|
930 | | `Company_Userfield_5` | Text | nullable |
|
931 | | `Company_Userfield_6` | Text | nullable |
|
932 | | `Company_Userfield_7` | Text | nullable |
|
933 | | `Company_Userfield_8` | Text | nullable |
|
934 | | `Company_Userfield_9` | Text | nullable |
|
935 |
|
936 | #### CompanyStateTaxRate
|
937 | | | | |
|
938 | |-------------|-------------|-----|
|
939 | | `Company_ID` | Text | nullable |
|
940 | | `Company_Name` | Text | nullable |
|
941 | | `Company_RecID` | Numeric | |
|
942 | | `State_Rate` | Numeric | |
|
943 | | `Tax_Code_RecID` | Numeric | nullable |
|
944 |
|
945 | #### CompanyStatus
|
946 | | | | |
|
947 | |-------------|-------------|-----|
|
948 | | `Cancel_Track_Flag` | Boolean | nullable |
|
949 | | `Company_Status_Desc` | Text | nullable |
|
950 | | `Company_Status_RecID` | Numeric | |
|
951 | | `CustomNote_Flag` | Boolean | nullable |
|
952 | | `Default_Flag` | Boolean | |
|
953 | | `Import_Flag` | Boolean | |
|
954 | | `Inactive_Flag` | Boolean | |
|
955 | | `Last_Update` | DateTime | |
|
956 | | `NoService_Flag` | Boolean | nullable |
|
957 | | `Notify_Flag` | Boolean | nullable |
|
958 | | `Notify_Message` | Text | nullable |
|
959 | | `StandardNote_Flag` | Boolean | nullable |
|
960 | | `Time_Zone` | Text | nullable |
|
961 | | `Updated_By` | Text | nullable |
|
962 | | `WF_Track_Header_RecID` | Numeric | nullable |
|
963 |
|
964 | #### CompanyTeam
|
965 | | | | |
|
966 | |-------------|-------------|-----|
|
967 | | `AcctMgr_Flag` | Boolean | |
|
968 | | `Billing_Unit_RecID` | Numeric | nullable |
|
969 | | `Company_RecID` | Numeric | |
|
970 | | `Company_Team_RecID` | Numeric | |
|
971 | | `Contact_Recid` | Numeric | nullable |
|
972 | | `Date_Created_UTC` | DateTime | |
|
973 | | `Description` | Numeric | nullable |
|
974 | | `Entered_By` | Text | |
|
975 | | `Last_Update_UTC` | DateTime | |
|
976 | | `Member_RecID` | Numeric | nullable |
|
977 | | `Owner_Level_RecID` | Numeric | nullable |
|
978 | | `Sales_Flag` | Boolean | |
|
979 | | `Team_Role_Recid` | Numeric | nullable |
|
980 | | `Tech_Flag` | Boolean | |
|
981 | | `Updated_By` | Text | |
|
982 |
|
983 | #### CompanyType
|
984 | | | | |
|
985 | |-------------|-------------|-----|
|
986 | | `Company_Type_Desc` | Text | |
|
987 | | `Company_Type_RecID` | Numeric | |
|
988 | | `Default_Flag` | Boolean | |
|
989 | | `Import_Flag` | Boolean | |
|
990 | | `Last_Update` | DateTime | nullable |
|
991 | | `Time_Zone` | Text | nullable |
|
992 | | `Updated_By` | Text | nullable |
|
993 | | `Vendor_Flag` | Boolean | |
|
994 |
|
995 | #### CompanyWorkRoles
|
996 | | | | |
|
997 | |-------------|-------------|-----|
|
998 | | `AGR_Header_RecID` | Numeric | nullable |
|
999 | | `AGR_Limit` | Numeric | nullable |
|
1000 | | `Activity_Class_RecID` | Numeric | nullable |
|
1001 | | `BR_Option` | Text | nullable |
|
1002 | | `Billing_Rate_RecID` | Numeric | |
|
1003 | | `Company_RecID` | Numeric | |
|
1004 | | `Date_Created_UTC` | DateTime | |
|
1005 | | `Date_Effective` | DateTime | |
|
1006 | | `Date_Ending` | DateTime | nullable |
|
1007 | | `Entered_By` | Text | |
|
1008 | | `Hourly_Rate` | Numeric | |
|
1009 | | `Last_Update_UTC` | DateTime | |
|
1010 | | `Owner_Level_RecID` | Numeric | nullable |
|
1011 | | `Rate_Type` | Text | nullable |
|
1012 | | `Time_Zone` | Text | nullable |
|
1013 | | `Updated_By` | Text | |
|
1014 |
|
1015 | #### CompanyWorkTypes
|
1016 | | | | |
|
1017 | |-------------|-------------|-----|
|
1018 | | `AGR_Header_RecID` | Numeric | nullable |
|
1019 | | `AGR_Limit` | Numeric | |
|
1020 | | `Activity_Type_RecID` | Numeric | nullable |
|
1021 | | `Billable_Flag` | Boolean | |
|
1022 | | `Company_Activity_RecID` | Numeric | |
|
1023 | | `Company_Address_RecID` | Numeric | nullable |
|
1024 | | `Company_RecID` | Numeric | |
|
1025 | | `Date_Created_UTC` | DateTime | |
|
1026 | | `Date_Effective` | DateTime | |
|
1027 | | `Date_Ending` | DateTime | nullable |
|
1028 | | `Entered_By` | Text | |
|
1029 | | `Hours_Max` | Numeric | nullable |
|
1030 | | `Hours_Min` | Numeric | nullable |
|
1031 | | `Inactive_Flag` | Boolean | |
|
1032 | | `Invoice_Flag` | Boolean | nullable |
|
1033 | | `Last_Update_UTC` | DateTime | |
|
1034 | | `Overage_Rate` | Numeric | nullable |
|
1035 | | `Overage_Rate_Type` | Text | nullable |
|
1036 | | `Owner_Level_RecID` | Numeric | nullable |
|
1037 | | `Rate` | Numeric | |
|
1038 | | `Rate_Type` | Text | |
|
1039 | | `Round_Bill_Hrs` | Numeric | nullable |
|
1040 | | `Time_Zone` | Text | nullable |
|
1041 | | `Updated_By` | Text | |
|
1042 |
|
1043 | #### ConfigCustomFields
|
1044 | | | | |
|
1045 | |-------------|-------------|-----|
|
1046 | | `Config_Name` | Text | nullable |
|
1047 | | `Config_RecID` | Numeric | |
|
1048 | | `Last_Update_UTC` | DateTime | |
|
1049 | | `Pod_RecID` | Numeric | |
|
1050 | | `Updated_By` | Text | |
|
1051 | | `User_Defined_Field_RecID` | Numeric | |
|
1052 | | `User_Defined_Field_Value` | Text | |
|
1053 | | `config_customfield` | Text | |
|
1054 | | `config_fieldtype` | Text | nullable |
|
1055 | | `customfield_podID` | Text | |
|
1056 |
|
1057 | #### ConfigStatuses
|
1058 | | | | |
|
1059 | |-------------|-------------|-----|
|
1060 | | `Closed_Flag` | Boolean | nullable |
|
1061 | | `ConfigStatus_Desc` | Text | nullable |
|
1062 | | `Config_Status_Recid` | Numeric | |
|
1063 | | `Default_Flag` | Boolean | nullable |
|
1064 | | `Last_Update` | DateTime | |
|
1065 | | `Time_Zone` | Text | nullable |
|
1066 | | `Updated_By` | Text | nullable |
|
1067 |
|
1068 | #### ConfigTypes
|
1069 | | | | |
|
1070 | |-------------|-------------|-----|
|
1071 | | `CS_Survey_RecID` | Numeric | |
|
1072 | | `ConfigType` | Text | nullable |
|
1073 | | `Inactive_Flag` | Boolean | nullable |
|
1074 | | `Instructions` | Text | nullable |
|
1075 | | `Last_Update` | DateTime | nullable |
|
1076 | | `Portal_Config_RecID` | Numeric | nullable |
|
1077 | | `System_Flag` | Boolean | nullable |
|
1078 | | `Time_Zone` | Text | nullable |
|
1079 | | `Updated_By` | Text | nullable |
|
1080 |
|
1081 | #### Configs
|
1082 | | | | |
|
1083 | |-------------|-------------|-----|
|
1084 | | `Billing_Unit_RecID` | Numeric | nullable |
|
1085 | | `CS_Survey_RecID` | Numeric | |
|
1086 | | `ClosedFlag` | Boolean | |
|
1087 | | `CompanyId` | Text | nullable |
|
1088 | | `CompanyRecId` | Numeric | |
|
1089 | | `Config_RecID` | Numeric | |
|
1090 | | `Config_Status_RecID` | Numeric | nullable |
|
1091 | | `ConfigurationName` | Text | nullable |
|
1092 | | `ConfigurationType` | Text | nullable |
|
1093 | | `ConfigurationTypeId` | Numeric | |
|
1094 | | `ContactName` | Text | |
|
1095 | | `Contact_RecID` | Numeric | nullable |
|
1096 | | `Country_RecID` | Numeric | nullable |
|
1097 | | `Date_Installed` | DateTime | nullable |
|
1098 | | `Date_Purchased` | DateTime | nullable |
|
1099 | | `Id` | Numeric | |
|
1100 | | `InstalledBy` | Text | nullable |
|
1101 | | `Last_Update` | DateTime | nullable |
|
1102 | | `Manufacturer_Name` | Text | nullable |
|
1103 | | `Manufacturer_RecID` | Numeric | nullable |
|
1104 | | `ModelNumber` | Text | nullable |
|
1105 | | `Owner_Level_RecID` | Numeric | nullable |
|
1106 | | `SLA_Name` | Text | nullable |
|
1107 | | `SR_SLA_RecID` | Numeric | nullable |
|
1108 | | `SR_Service_List` | Text | nullable |
|
1109 | | `SerialNumber` | Text | nullable |
|
1110 | | `Status` | Text | nullable |
|
1111 | | `StatusId` | Numeric | nullable |
|
1112 | | `TagNumber` | Text | nullable |
|
1113 | | `Time_Zone` | Text | nullable |
|
1114 | | `Universal_Formatted_Warranty_Expiration` | Text | nullable |
|
1115 | | `Updated_By` | Text | nullable |
|
1116 | | `Vendor` | Text | nullable |
|
1117 | | `Vendor_Nbr` | Text | nullable |
|
1118 | | `Vendor_Notes` | Text | nullable |
|
1119 | | `Vendor_RecId` | Numeric | nullable |
|
1120 | | `WarrantyExpiration` | DateTime | nullable |
|
1121 | | `address_line1` | Text | nullable |
|
1122 | | `address_line2` | Text | nullable |
|
1123 | | `city` | Text | nullable |
|
1124 | | `company_address_recid` | Numeric | nullable |
|
1125 | | `company_name` | Text | nullable |
|
1126 | | `state_id` | Text | nullable |
|
1127 | | `zip` | Text | nullable |
|
1128 |
|
1129 | #### Configuration
|
1130 | | | | |
|
1131 | |-------------|-------------|-----|
|
1132 | | `Address_line1` | Text | |
|
1133 | | `Address_line2` | Text | |
|
1134 | | `Answer` | Text | |
|
1135 | | `Billing_Unit_RecID` | Numeric | nullable |
|
1136 | | `BusinessGrp` | Text | |
|
1137 | | `CS_Survey_RecID` | Numeric | |
|
1138 | | `City` | Text | |
|
1139 | | `Company_Name` | Text | |
|
1140 | | `Company_RecID` | Numeric | |
|
1141 | | `ConfigStatus` | Text | |
|
1142 | | `Config_Name` | Text | nullable |
|
1143 | | `Config_RecID` | Numeric | |
|
1144 | | `Config_Type` | Text | nullable |
|
1145 | | `Contact_Name` | Text | |
|
1146 | | `Contact_RecID` | Numeric | nullable |
|
1147 | | `Date_Expiration` | DateTime | nullable |
|
1148 | | `Date_Installed` | DateTime | nullable |
|
1149 | | `Date_Purchased` | DateTime | nullable |
|
1150 | | `DeviceID` | Text | |
|
1151 | | `InstalledBy` | Text | |
|
1152 | | `LastLogin` | Text | |
|
1153 | | `Last_Update` | DateTime | nullable |
|
1154 | | `Location` | Text | |
|
1155 | | `Manufacturer` | Text | |
|
1156 | | `MgmtLink` | Text | |
|
1157 | | `Model_Number` | Text | |
|
1158 | | `Notes` | Text | |
|
1159 | | `Owner_Level_RecID` | Numeric | nullable |
|
1160 | | `PostalCode` | Text | |
|
1161 | | `Question` | Text | nullable |
|
1162 | | `Seq_Nbr` | Numeric | nullable |
|
1163 | | `Serial_Number` | Text | |
|
1164 | | `State` | Text | |
|
1165 | | `Tag_Number` | Text | |
|
1166 | | `Time_Zone` | Text | nullable |
|
1167 | | `Updated_By` | Text | nullable |
|
1168 |
|
1169 | #### ConfigurationAgreement
|
1170 | | | | |
|
1171 | |-------------|-------------|-----|
|
1172 | | `AgrTypeRecId` | Numeric | nullable |
|
1173 | | `AgreementName` | Text | nullable |
|
1174 | | `AgreementRecId` | Numeric | |
|
1175 | | `AgreementType` | Text | nullable |
|
1176 | | `CompanyId` | Text | nullable |
|
1177 | | `CompanyName` | Text | nullable |
|
1178 | | `CompanyRecId` | Numeric | nullable |
|
1179 | | `ConfigurationName` | Text | nullable |
|
1180 | | `ConfigurationRecId` | Numeric | nullable |
|
1181 | | `ConfigurationType` | Text | nullable |
|
1182 | | `ConfigurationTypeRecId` | Numeric | nullable |
|
1183 | | `Last_Update` | DateTime | |
|
1184 | | `Time_Zone` | Text | nullable |
|
1185 | | `Updated_By` | Text | nullable |
|
1186 |
|
1187 | #### ConfigurationType
|
1188 | | | | |
|
1189 | |-------------|-------------|-----|
|
1190 | | `Inactive_Flag` | Boolean | nullable |
|
1191 | | `Instructions` | Text | nullable |
|
1192 | | `Last_Update` | DateTime | |
|
1193 | | `Name` | Text | nullable |
|
1194 | | `RecID` | Numeric | |
|
1195 | | `Time_Zone` | Text | nullable |
|
1196 | | `Updated_By` | Text | nullable |
|
1197 |
|
1198 | #### ConfigurationTypeQuestion
|
1199 | | | | |
|
1200 | |-------------|-------------|-----|
|
1201 | | `CS_Survey_Detail_RecID` | Numeric | |
|
1202 | | `CS_Survey_RecID` | Numeric | |
|
1203 | | `Entry_Type` | Text | nullable |
|
1204 | | `Field_Type` | Text | nullable |
|
1205 | | `Inactive_Flag` | Boolean | nullable |
|
1206 | | `Last_Update` | DateTime | nullable |
|
1207 | | `Nbr_Decimals` | Numeric | nullable |
|
1208 | | `Question` | Text | nullable |
|
1209 | | `Required_Flag` | Boolean | nullable |
|
1210 | | `Seq_Nbr` | Numeric | |
|
1211 | | `Time_Zone` | Text | nullable |
|
1212 | | `Updated_By` | Text | nullable |
|
1213 |
|
1214 | #### ConnectWiseHostedApiScreen
|
1215 | | | | |
|
1216 | |-------------|-------------|-----|
|
1217 | | `Client_Api_ID` | Text | |
|
1218 | | `Presenter_Identifier_Client_Api_RecID` | Numeric | |
|
1219 |
|
1220 | #### Contact
|
1221 | | | | |
|
1222 | |-------------|-------------|-----|
|
1223 | | `Address_Line1` | Text | nullable |
|
1224 | | `Address_Line2` | Text | nullable |
|
1225 | | `Children_Flag` | Boolean | |
|
1226 | | `Children_Info` | Text | nullable |
|
1227 | | `City` | Text | nullable |
|
1228 | | `Company_Address_RecID` | Numeric | nullable |
|
1229 | | `Company_ID` | Text | nullable |
|
1230 | | `Company_Name` | Text | nullable |
|
1231 | | `Company_RecID` | Numeric | nullable |
|
1232 | | `Contact_RecID` | Numeric | |
|
1233 | | `Contact_Type_Desc` | Text | nullable |
|
1234 | | `Contact_Type_RecID` | Text | nullable |
|
1235 | | `Country` | Text | nullable |
|
1236 | | `Date_Anniversary` | DateTime | nullable |
|
1237 | | `Date_Birth` | DateTime | nullable |
|
1238 | | `Default_Billing_Flag` | Boolean | |
|
1239 | | `Default_Email` | Text | |
|
1240 | | `Default_Flag` | Boolean | nullable |
|
1241 | | `Default_Phone` | Text | |
|
1242 | | `Delete_Flag` | Numeric | nullable |
|
1243 | | `Department` | Text | nullable |
|
1244 | | `First_Name` | Text | nullable |
|
1245 | | `Gender` | Text | nullable |
|
1246 | | `Hobbies` | Text | nullable |
|
1247 | | `Image_Link` | Text | nullable |
|
1248 | | `Inactive_Flag` | Boolean | nullable |
|
1249 | | `Last_Name` | Text | nullable |
|
1250 | | `Last_Update` | DateTime | |
|
1251 | | `Last_Update_UTC` | DateTime | |
|
1252 | | `Married_Flag` | Boolean | |
|
1253 | | `NickName` | Text | nullable |
|
1254 | | `Personal_Address_Flag` | Boolean | |
|
1255 | | `Portal_Disable_Flag` | Boolean | nullable |
|
1256 | | `Portal_PW` | Numeric | nullable |
|
1257 | | `Portal_Security_Level` | Numeric | nullable |
|
1258 | | `School` | Text | nullable |
|
1259 | | `Spouse_Name` | Text | nullable |
|
1260 | | `State_ID` | Text | nullable |
|
1261 | | `Territory` | Text | nullable |
|
1262 | | `Time_Zone` | Text | nullable |
|
1263 | | `Title` | Text | nullable |
|
1264 | | `Unsubscribe_Flag` | Boolean | |
|
1265 | | `Updated_By` | Text | nullable |
|
1266 | | `Userfield1` | Text | nullable |
|
1267 | | `Userfield10` | Text | nullable |
|
1268 | | `Userfield10_Caption` | Text | nullable |
|
1269 | | `Userfield1_Caption` | Text | nullable |
|
1270 | | `Userfield2` | Text | nullable |
|
1271 | | `Userfield2_Caption` | Text | nullable |
|
1272 | | `Userfield3` | Text | nullable |
|
1273 | | `Userfield3_Caption` | Text | nullable |
|
1274 | | `Userfield4` | Text | nullable |
|
1275 | | `Userfield4_Caption` | Text | nullable |
|
1276 | | `Userfield5` | Text | nullable |
|
1277 | | `Userfield5_Caption` | Text | nullable |
|
1278 | | `Userfield6` | Text | nullable |
|
1279 | | `Userfield6_Caption` | Text | nullable |
|
1280 | | `Userfield7` | Text | nullable |
|
1281 | | `Userfield7_Caption` | Text | nullable |
|
1282 | | `Userfield8` | Text | nullable |
|
1283 | | `Userfield8_Caption` | Text | nullable |
|
1284 | | `Userfield9` | Text | nullable |
|
1285 | | `Userfield9_Caption` | Text | nullable |
|
1286 | | `Zip` | Text | nullable |
|
1287 |
|
1288 | #### ContactCommunication
|
1289 | | | | |
|
1290 | |-------------|-------------|-----|
|
1291 | | `Communication_Name` | Text | nullable |
|
1292 | | `Communication_Type_RecID` | Numeric | |
|
1293 | | `Contact_Communication_Desc` | Text | nullable |
|
1294 | | `Contact_Communication_RecID` | Numeric | |
|
1295 | | `Contact_RecID` | Numeric | |
|
1296 | | `Default_Flag` | Boolean | |
|
1297 | | `Extension` | Text | nullable |
|
1298 | | `Last_Update` | DateTime | |
|
1299 | | `Time_Zone` | Text | nullable |
|
1300 | | `Updated_By` | Text | nullable |
|
1301 |
|
1302 | #### ContactContactTypeDescriptions
|
1303 | | | | |
|
1304 | |-------------|-------------|-----|
|
1305 | | `Contact_RecID` | Numeric | |
|
1306 | | `Contact_Types` | Text | nullable |
|
1307 |
|
1308 | #### ContactContactTypes
|
1309 | | | | |
|
1310 | |-------------|-------------|-----|
|
1311 | | `Contact_RecID` | Numeric | |
|
1312 | | `Contact_Type_RecID` | Numeric | |
|
1313 | | `Description` | Text | nullable |
|
1314 | | `First_Name` | Text | nullable |
|
1315 | | `Last_Name` | Text | nullable |
|
1316 | | `Service_Alert_Flag` | Boolean | |
|
1317 | | `Service_Alert_Message` | Text | nullable |
|
1318 |
|
1319 | #### ContactCustomFields
|
1320 | | | | |
|
1321 | |-------------|-------------|-----|
|
1322 | | `Contact_RecID` | Numeric | |
|
1323 | | `First_Name` | Text | nullable |
|
1324 | | `Last_Name` | Text | nullable |
|
1325 | | `Last_Update_UTC` | DateTime | |
|
1326 | | `Pod_RecID` | Numeric | |
|
1327 | | `Updated_By` | Text | |
|
1328 | | `User_Defined_Field_RecID` | Numeric | |
|
1329 | | `User_Defined_Field_Value` | Text | |
|
1330 | | `contact_customfield` | Text | |
|
1331 | | `contact_fieldtype` | Text | nullable |
|
1332 | | `customfield_podID` | Text | |
|
1333 |
|
1334 | #### ContactGroup
|
1335 | | | | |
|
1336 | |-------------|-------------|-----|
|
1337 | | `Company_RecID` | Numeric | nullable |
|
1338 | | `Contact_Group_RecID` | Numeric | |
|
1339 | | `Contact_RecID` | Numeric | nullable |
|
1340 | | `Group_Type_Desc` | Text | nullable |
|
1341 | | `Group_Type_RecID` | Numeric | nullable |
|
1342 | | `Inactive_Flag` | Boolean | nullable |
|
1343 | | `Last_Update` | DateTime | nullable |
|
1344 | | `Public_Description` | Text | nullable |
|
1345 | | `Public_Flag` | Boolean | nullable |
|
1346 | | `Time_Zone` | Text | nullable |
|
1347 | | `Unsubscribe_Flag` | Boolean | nullable |
|
1348 | | `Updated_By` | Text | nullable |
|
1349 |
|
1350 | #### ContactName
|
1351 | | | | |
|
1352 | |-------------|-------------|-----|
|
1353 | | `Contact_RecID` | Numeric | |
|
1354 | | `First_Name` | Text | |
|
1355 | | `Last_Name` | Text | |
|
1356 | | `Last_Update` | DateTime | |
|
1357 | | `Time_Zone` | Text | nullable |
|
1358 | | `Updated_By` | Text | nullable |
|
1359 |
|
1360 | #### ContactPresence
|
1361 | | | | |
|
1362 | |-------------|-------------|-----|
|
1363 | | `Contact_Presence_RecID` | Numeric | |
|
1364 | | `Contact_Presence_Type_RecID` | Numeric | |
|
1365 | | `Contact_RecID` | Numeric | |
|
1366 | | `Last_Update_UTC` | DateTime | nullable |
|
1367 | | `Time_Zone` | Text | |
|
1368 | | `Updated_By` | Text | nullable |
|
1369 |
|
1370 | #### ContactRelationship
|
1371 | | | | |
|
1372 | |-------------|-------------|-----|
|
1373 | | `Last_Update` | DateTime | |
|
1374 | | `Relationship` | Text | nullable |
|
1375 | | `Relationship_RecID` | Numeric | |
|
1376 | | `Time_Zone` | Text | nullable |
|
1377 | | `Updated_By` | Text | nullable |
|
1378 |
|
1379 | #### ContactType
|
1380 | | | | |
|
1381 | |-------------|-------------|-----|
|
1382 | | `Contact_Type_ID` | Text | |
|
1383 | | `Contact_Type_RecID` | Numeric | |
|
1384 | | `Default_Flag` | Boolean | |
|
1385 | | `Description` | Text | nullable |
|
1386 | | `Last_Update` | DateTime | |
|
1387 | | `Time_Zone` | Text | nullable |
|
1388 | | `Updated_By` | Text | nullable |
|
1389 |
|
1390 | #### Contacts
|
1391 | | | | |
|
1392 | |-------------|-------------|-----|
|
1393 | | `Address1` | Text | nullable |
|
1394 | | `Address2` | Text | nullable |
|
1395 | | `Caption` | Text | nullable |
|
1396 | | `City` | Text | nullable |
|
1397 | | `CompanyRecID` | Numeric | nullable |
|
1398 | | `Company_Name` | Text | nullable |
|
1399 | | `Contact_RecID` | Numeric | |
|
1400 | | `Country` | Text | nullable |
|
1401 | | `Default_Flag` | Boolean | nullable |
|
1402 | | `DisablePortalLogin` | Boolean | |
|
1403 | | `Email` | Text | nullable |
|
1404 | | `First_Name` | Text | nullable |
|
1405 | | `Last_Name` | Text | nullable |
|
1406 | | `Last_Update` | DateTime | |
|
1407 | | `Phone` | Text | nullable |
|
1408 | | `Portal_Security_Level` | Numeric | nullable |
|
1409 | | `Relationship` | Text | nullable |
|
1410 | | `State` | Text | nullable |
|
1411 | | `Time_Zone` | Text | nullable |
|
1412 | | `Type` | Text | nullable |
|
1413 | | `Universal_Formatted_Last_Update` | DateTime | nullable |
|
1414 | | `Updated_By` | Text | nullable |
|
1415 | | `Zip` | Text | nullable |
|
1416 |
|
1417 | #### ConversionHistory
|
1418 | | | | |
|
1419 | |-------------|-------------|-----|
|
1420 | | `Conversion_History_RecID` | Numeric | |
|
1421 | | `Conversion_Type_ID` | Text | |
|
1422 | | `Converstion_Type_Desc` | Text | |
|
1423 | | `Converted_To_RecID` | Numeric | |
|
1424 | | `Date_Created_UTC` | DateTime | |
|
1425 | | `Entered_By` | Text | |
|
1426 | | `Parent_RecID` | Numeric | |
|
1427 | | `Parent_Type_Desc` | Text | |
|
1428 | | `Parent_Type_ID` | Text | |
|
1429 |
|
1430 | #### Countries
|
1431 | | | | |
|
1432 | |-------------|-------------|-----|
|
1433 | | `City_Caption` | Text | nullable |
|
1434 | | `Country` | Text | |
|
1435 | | `Country_Code` | Text | nullable |
|
1436 | | `Country_RecID` | Numeric | |
|
1437 | | `Currency_ID` | Text | nullable |
|
1438 | | `Default_Flag` | Boolean | |
|
1439 | | `Last_Update` | DateTime | nullable |
|
1440 | | `State_Caption` | Text | nullable |
|
1441 | | `Time_Zone` | Text | nullable |
|
1442 | | `Updated_By` | Text | nullable |
|
1443 | | `Zip_Caption` | Text | nullable |
|
1444 |
|
1445 | #### Currency
|
1446 | | | | |
|
1447 | |-------------|-------------|-----|
|
1448 | | `Currency_ID` | Text | |
|
1449 | | `Currency_RecID` | Numeric | |
|
1450 | | `Currency_Symbol` | Text | nullable |
|
1451 | | `Description` | Text | nullable |
|
1452 | | `DisplayID_Flag` | Boolean | nullable |
|
1453 | | `DisplaySymbol_Flag` | Boolean | |
|
1454 | | `Iso_Code` | Text | nullable |
|
1455 | | `Last_Update` | DateTime | nullable |
|
1456 | | `Time_Zone` | Text | nullable |
|
1457 | | `Updated_By` | Text | nullable |
|
1458 |
|
1459 | #### CustomCaption
|
1460 | | | | |
|
1461 | |-------------|-------------|-----|
|
1462 | | `Caption` | Text | nullable |
|
1463 | | `Field_Name` | Text | nullable |
|
1464 | | `Last_Update` | DateTime | nullable |
|
1465 | | `Time_Zone` | Text | nullable |
|
1466 | | `Updated_By` | Text | nullable |
|
1467 |
|
1468 | #### CustomFields
|
1469 | | | | |
|
1470 | |-------------|-------------|-----|
|
1471 | | `Required_Flag` | Boolean | |
|
1472 | | `User_Defined_Field_RecID` | Numeric | |
|
1473 | | `billing_unit_recids` | Text | nullable |
|
1474 | | `customfield_caption` | Text | |
|
1475 | | `customfield_description` | Text | nullable |
|
1476 | | `customfield_nbrdecimals` | Numeric | nullable |
|
1477 | | `customfield_podID` | Text | |
|
1478 | | `customfield_recid` | Numeric | |
|
1479 | | `customfield_screenID` | Text | |
|
1480 | | `customfield_type` | Text | nullable |
|
1481 | | `owner_level_recids` | Text | nullable |
|
1482 |
|
1483 | #### CustomFieldsOptions
|
1484 | | | | |
|
1485 | |-------------|-------------|-----|
|
1486 | | `Default_Flag` | Boolean | |
|
1487 | | `Inactive_Flag` | Boolean | |
|
1488 | | `customfield_caption` | Text | |
|
1489 | | `customfield_option_recid` | Numeric | |
|
1490 | | `customfield_recid` | Numeric | |
|
1491 | | `option_value` | Text | |
|
1492 |
|
1493 | #### Department
|
1494 | | | | |
|
1495 | |-------------|-------------|-----|
|
1496 | | `Department_Name` | Text | nullable |
|
1497 | | `Department_RecID` | Numeric | |
|
1498 | | `Last_Update` | DateTime | nullable |
|
1499 | | `Time_Zone` | Text | nullable |
|
1500 | | `Updated_By` | Text | nullable |
|
1501 |
|
1502 | #### Document
|
1503 | | | | |
|
1504 | |-------------|-------------|-----|
|
1505 | | `AGR_Header_RecID` | Numeric | nullable |
|
1506 | | `Company_RecID` | Numeric | nullable |
|
1507 | | `Config_RecID` | Numeric | nullable |
|
1508 | | `Contact_RecID` | Numeric | nullable |
|
1509 | | `DM_Document_RecID` | Numeric | |
|
1510 | | `DM_Relationship_RecID` | Numeric | |
|
1511 | | `EX_Detail_RecID` | Numeric | nullable |
|
1512 | | `Filename` | Text | nullable |
|
1513 | | `Last_Update` | DateTime | |
|
1514 | | `Last_Update_UTC` | DateTime | |
|
1515 | | `Link_Flag` | Boolean | nullable |
|
1516 | | `Opportunity_RecID` | Numeric | nullable |
|
1517 | | `Order_Header_RecID` | Numeric | nullable |
|
1518 | | `PM_Project_RecID` | Numeric | nullable |
|
1519 | | `Path` | Text | nullable |
|
1520 | | `Public_Flag` | Boolean | |
|
1521 | | `Purchase_Header_RecID` | Numeric | nullable |
|
1522 | | `RMA_Tag_RecID` | Numeric | nullable |
|
1523 | | `SRT_Service_RecID` | Numeric | nullable |
|
1524 | | `SR_Service_RecID` | Numeric | nullable |
|
1525 | | `ServerFilename` | Text | nullable |
|
1526 | | `Template_Flag` | Boolean | |
|
1527 | | `Time_RecID` | Numeric | nullable |
|
1528 | | `Title` | Text | nullable |
|
1529 | | `Updated_By` | Text | nullable |
|
1530 |
|
1531 | #### Expense
|
1532 | | | | |
|
1533 | |-------------|-------------|-----|
|
1534 | | `AgrAmtCovered` | Numeric | |
|
1535 | | `Agreement` | Text | nullable |
|
1536 | | `Billable_Amt` | Numeric | nullable |
|
1537 | | `Billable_Flag` | Boolean | |
|
1538 | | `Billing_Log_RecID` | Numeric | nullable |
|
1539 | | `BusGroup` | Text | nullable |
|
1540 | | `Charge_Code` | Text | nullable |
|
1541 | | `Company_Name` | Text | nullable |
|
1542 | | `Company_RecID` | Numeric | nullable |
|
1543 | | `Date_Expense` | DateTime | nullable |
|
1544 | | `Date_Invoice` | DateTime | nullable |
|
1545 | | `EX_Detail_RecID` | Numeric | |
|
1546 | | `Expense_Cost` | Numeric | nullable |
|
1547 | | `First_Name` | Text | nullable |
|
1548 | | `Invoice_Flag` | Boolean | nullable |
|
1549 | | `Invoice_Number` | Text | nullable |
|
1550 | | `Last_Login_UTC` | DateTime | nullable |
|
1551 | | `Last_Name` | Text | nullable |
|
1552 | | `Last_Update` | DateTime | nullable |
|
1553 | | `Location` | Text | nullable |
|
1554 | | `Member_ID` | Text | |
|
1555 | | `Member_RecID` | Numeric | |
|
1556 | | `NonBillable_Amt` | Numeric | nullable |
|
1557 | | `Option_ID` | Text | nullable |
|
1558 | | `Owner_Level_RecID` | Numeric | nullable |
|
1559 | | `PM_Phase_RecID` | Numeric | nullable |
|
1560 | | `PM_Project_RecID` | Numeric | nullable |
|
1561 | | `Payment_Method` | Text | nullable |
|
1562 | | `Project_Phase` | Text | nullable |
|
1563 | | `Reason` | Text | nullable |
|
1564 | | `Reimb_Amount` | Numeric | nullable |
|
1565 | | `Reimb_Desc` | Text | nullable |
|
1566 | | `SR_Service_RecID` | Numeric | nullable |
|
1567 | | `TE_Status_ID` | Numeric | nullable |
|
1568 | | `Time_Zone` | Text | nullable |
|
1569 | | `Updated_By` | Text | nullable |
|
1570 | | `charge_to` | Text | nullable |
|
1571 | | `expense_type` | Text | nullable |
|
1572 | | `project_name` | Text | nullable |
|
1573 | | `sr_status` | Text | nullable |
|
1574 | | `sr_summary` | Text | nullable |
|
1575 | | `te_charge_code_recid` | Numeric | nullable |
|
1576 | | `territory` | Text | nullable |
|
1577 | | `time_status` | Text | nullable |
|
1578 |
|
1579 | #### ExpenseClassification
|
1580 | | | | |
|
1581 | |-------------|-------------|-----|
|
1582 | | `Company_Flag` | Boolean | |
|
1583 | | `Default_Flag` | Boolean | |
|
1584 | | `Description` | Text | nullable |
|
1585 | | `EX_Class_RecID` | Numeric | |
|
1586 | | `Employee_Flag` | Boolean | |
|
1587 | | `Multiplier` | Numeric | nullable |
|
1588 |
|
1589 | #### ExpenseCustomFields
|
1590 | | | | |
|
1591 | |-------------|-------------|-----|
|
1592 | | `EX_Detail_RecID` | Numeric | |
|
1593 | | `EX_Header_RecID` | Numeric | |
|
1594 | | `Last_Update_UTC` | DateTime | |
|
1595 | | `Pod_RecID` | Numeric | |
|
1596 | | `Updated_By` | Text | |
|
1597 | | `User_Defined_Field_RecID` | Numeric | |
|
1598 | | `User_Defined_Field_Value` | Text | |
|
1599 | | `customfield_podID` | Text | |
|
1600 | | `expense_customfield` | Text | |
|
1601 | | `expense_fieldtype` | Text | nullable |
|
1602 |
|
1603 | #### ExpensePaymentMethod
|
1604 | | | | |
|
1605 | |-------------|-------------|-----|
|
1606 | | `Company_Flag` | Boolean | |
|
1607 | | `Default_Flag` | Boolean | |
|
1608 | | `Description` | Text | nullable |
|
1609 | | `EX_Class_RecID` | Numeric | nullable |
|
1610 | | `EX_Payment_RecID` | Numeric | |
|
1611 | | `Last_Update` | DateTime | nullable |
|
1612 | | `Time_Zone` | Text | nullable |
|
1613 | | `Updated_By` | Text | nullable |
|
1614 |
|
1615 | #### ExpenseReports
|
1616 | | | | |
|
1617 | |-------------|-------------|-----|
|
1618 | | `Date_DeadLine` | DateTime | |
|
1619 | | `Date_End` | DateTime | |
|
1620 | | `Date_Start` | DateTime | |
|
1621 | | `Description` | Text | nullable |
|
1622 | | `Last_Updated_UTC` | DateTime | |
|
1623 | | `Member_ID` | Text | |
|
1624 | | `Member_RecID` | Numeric | |
|
1625 | | `Period` | Numeric | |
|
1626 | | `TE_Period_RecID` | Numeric | |
|
1627 | | `TE_Status_ID` | Numeric | nullable |
|
1628 |
|
1629 | #### ExpenseTax
|
1630 | | | | |
|
1631 | |-------------|-------------|-----|
|
1632 | | `EX_Detail_RecID` | Numeric | |
|
1633 | | `EX_Detail_Tax_RecID` | Numeric | |
|
1634 | | `EX_Tax_Type_Desc` | Text | nullable |
|
1635 | | `EX_Tax_Type_RecID` | Numeric | |
|
1636 | | `Last_Update_UTC` | DateTime | |
|
1637 | | `Tax_Amount` | Numeric | nullable |
|
1638 | | `Updated_By` | Text | |
|
1639 |
|
1640 | #### ExpenseTaxType
|
1641 | | | | |
|
1642 | |-------------|-------------|-----|
|
1643 | | `EX_Tax_Type_Desc` | Text | nullable |
|
1644 | | `EX_Tax_Type_RecID` | Numeric | |
|
1645 | | `Inactive_Flag` | Boolean | |
|
1646 | | `Last_Update_UTC` | DateTime | |
|
1647 | | `Updated_By` | Text | |
|
1648 |
|
1649 | #### ExpenseType
|
1650 | | | | |
|
1651 | |-------------|-------------|-----|
|
1652 | | `Advance_Flag` | Boolean | |
|
1653 | | `Amount_Caption` | Text | nullable |
|
1654 | | `Billable_Flag` | Boolean | nullable |
|
1655 | | `Description` | Text | |
|
1656 | | `EX_Type_RecID` | Numeric | |
|
1657 | | `Inactive_Flag` | Boolean | nullable |
|
1658 | | `Invoice_Flag` | Boolean | nullable |
|
1659 | | `Last_Update` | DateTime | nullable |
|
1660 | | `Markup_Amount` | Numeric | nullable |
|
1661 | | `Markup_Option` | Text | nullable |
|
1662 | | `Max_Amount` | Numeric | |
|
1663 | | `Mileage_Flag` | Boolean | |
|
1664 | | `Quantity_Flag` | Boolean | |
|
1665 | | `Reimbursement_Rate` | Numeric | nullable |
|
1666 | | `Time_Zone` | Text | nullable |
|
1667 | | `Updated_By` | Text | nullable |
|
1668 |
|
1669 | #### GroupType
|
1670 | | | | |
|
1671 | |-------------|-------------|-----|
|
1672 | | `Company_Flag` | Boolean | |
|
1673 | | `Company_Group_Name` | Text | nullable |
|
1674 | | `Contact_Flag` | Boolean | |
|
1675 | | `Group_Type_RecID` | Numeric | |
|
1676 | | `Inactive_Flag` | Boolean | |
|
1677 | | `Last_Update` | DateTime | |
|
1678 | | `Public_Description` | Text | nullable |
|
1679 | | `Public_Flag` | Boolean | |
|
1680 | | `Time_Zone` | Text | nullable |
|
1681 | | `Updated_By` | Text | |
|
1682 |
|
1683 | #### Holiday
|
1684 | | | | |
|
1685 | |-------------|-------------|-----|
|
1686 | | `Description` | Text | |
|
1687 | | `Holiday_Date` | DateTime | |
|
1688 | | `Holiday_List_Name` | Text | |
|
1689 | | `Holiday_List_RecID` | Numeric | |
|
1690 | | `Last_Update_UTC` | DateTime | |
|
1691 | | `Time_End` | DateTime | nullable |
|
1692 | | `Time_Start` | DateTime | nullable |
|
1693 | | `Time_Zone` | Text | nullable |
|
1694 | | `Updated_By` | Text | |
|
1695 |
|
1696 | #### IVCategory
|
1697 | | | | |
|
1698 | |-------------|-------------|-----|
|
1699 | | `IV_Cat_Desc` | Text | nullable |
|
1700 | | `IV_Cat_RecID` | Numeric | |
|
1701 | | `Inactive_Flag` | Boolean | |
|
1702 | | `Last_Update` | DateTime | |
|
1703 | | `Time_Zone` | Text | nullable |
|
1704 | | `Updated_By` | Text | nullable |
|
1705 |
|
1706 | #### IVClass
|
1707 | | | | |
|
1708 | |-------------|-------------|-----|
|
1709 | | `IV_Class_Desc` | Text | nullable |
|
1710 | | `IV_Class_ID` | Text | |
|
1711 |
|
1712 | #### IVPriceAttribute
|
1713 | | | | |
|
1714 | |-------------|-------------|-----|
|
1715 | | `Default_Flag` | Boolean | |
|
1716 | | `Description` | Text | |
|
1717 | | `IV_Price_Attribute_ID` | Text | |
|
1718 | | `IV_Price_Attribute_RecID` | Numeric | |
|
1719 |
|
1720 | #### IVProductBundle
|
1721 | | | | |
|
1722 | |-------------|-------------|-----|
|
1723 | | `Hide_Description_Flag` | Boolean | |
|
1724 | | `Hide_Item_ID_Flag` | Boolean | |
|
1725 | | `Hide_Price_Flag` | Boolean | |
|
1726 | | `Hide_Quantity_Flag` | Boolean | |
|
1727 | | `IV_Product_Bundle_RecID` | Numeric | |
|
1728 | | `IV_Product_RecID` | Numeric | |
|
1729 | | `Last_Update` | DateTime | |
|
1730 | | `Parent_Item_RecID` | Numeric | nullable |
|
1731 | | `Parent_RecID` | Numeric | nullable |
|
1732 | | `Quantity` | Numeric | |
|
1733 | | `Sequence_Number` | Numeric | |
|
1734 | | `Time_Zone` | Text | nullable |
|
1735 | | `Updated_By` | Text | |
|
1736 |
|
1737 | #### IVSubCategory
|
1738 | | | | |
|
1739 | |-------------|-------------|-----|
|
1740 | | `IV_Cat_RecID` | Numeric | nullable |
|
1741 | | `IV_SubCat_Desc` | Text | nullable |
|
1742 | | `IV_SubCat_RecID` | Numeric | |
|
1743 | | `Inactive_Flag` | Boolean | |
|
1744 | | `Last_Update` | DateTime | |
|
1745 | | `Time_Zone` | Text | nullable |
|
1746 | | `Updated_By` | Text | nullable |
|
1747 |
|
1748 | #### IVType
|
1749 | | | | |
|
1750 | |-------------|-------------|-----|
|
1751 | | `IV_Type_Desc` | Text | nullable |
|
1752 | | `IV_Type_RecID` | Numeric | |
|
1753 | | `Inactive_Flag` | Boolean | |
|
1754 | | `Item_Type_Xref` | Text | nullable |
|
1755 | | `Last_Update` | DateTime | |
|
1756 | | `Time_Zone` | Text | nullable |
|
1757 | | `Updated_By` | Text | nullable |
|
1758 |
|
1759 | #### IVUom
|
1760 | | | | |
|
1761 | |-------------|-------------|-----|
|
1762 | | `Default_Flag` | Boolean | |
|
1763 | | `IV_UOM_RecID` | Numeric | |
|
1764 | | `IV_Uom_Desc` | Text | nullable |
|
1765 | | `Inactive_Flag` | Boolean | |
|
1766 | | `Last_Update` | DateTime | nullable |
|
1767 | | `Time_Zone` | Text | nullable |
|
1768 | | `Updated_By` | Text | nullable |
|
1769 |
|
1770 | #### InventoryBalance
|
1771 | | | | |
|
1772 | |-------------|-------------|-----|
|
1773 | | `inv_type` | Text | |
|
1774 | | `total` | Numeric | nullable |
|
1775 | | `val_date` | DateTime | nullable |
|
1776 |
|
1777 | #### InventoryBalanceWithShippedNotInvoiced
|
1778 | | | | |
|
1779 | |-------------|-------------|-----|
|
1780 | | `billing_log_recid` | Numeric | |
|
1781 | | `date_created` | DateTime | nullable |
|
1782 | | `inv_type` | Text | |
|
1783 | | `total` | Numeric | nullable |
|
1784 | | `val_date` | DateTime | nullable |
|
1785 |
|
1786 | #### InventoryItem
|
1787 | | | | |
|
1788 | |-------------|-------------|-----|
|
1789 | | `Alt_Item_ID` | Numeric | nullable |
|
1790 | | `Average_Value` | Numeric | nullable |
|
1791 | | `Calc_Cost_Flag` | Boolean | |
|
1792 | | `Calc_Price_Flag` | Boolean | |
|
1793 | | `Current_Cost` | Numeric | nullable |
|
1794 | | `Date_Entered_UTC` | DateTime | |
|
1795 | | `Description` | Text | nullable |
|
1796 | | `IV_Class_ID` | Text | nullable |
|
1797 | | `IV_Item_RecID` | Numeric | |
|
1798 | | `IV_Price_Attribute_ID` | Text | nullable |
|
1799 | | `IV_SubCat_RecID` | Numeric | nullable |
|
1800 | | `IV_Type_RecID` | Numeric | nullable |
|
1801 | | `IV_UOM_RecID` | Numeric | nullable |
|
1802 | | `Inactive_Flag` | Boolean | |
|
1803 | | `Item_ID` | Text | nullable |
|
1804 | | `Last_Update` | DateTime | |
|
1805 | | `List_Price` | Numeric | |
|
1806 | | `Long_Description` | Text | nullable |
|
1807 | | `Manufacturer_RecID` | Numeric | nullable |
|
1808 | | `Max_SO_Qty` | Numeric | nullable |
|
1809 | | `Mfg_Item_ID` | Text | nullable |
|
1810 | | `Min_SO_Qty` | Numeric | nullable |
|
1811 | | `Minimum_Stock` | Numeric | nullable |
|
1812 | | `Notes` | Text | nullable |
|
1813 | | `Phase_Product_Flag` | Boolean | |
|
1814 | | `SerializedCost_Flag` | Boolean | |
|
1815 | | `Serialized_Flag` | Boolean | nullable |
|
1816 | | `Short_Name` | Numeric | nullable |
|
1817 | | `Std_Cost` | Numeric | nullable |
|
1818 | | `Taxable_Flag` | Boolean | |
|
1819 | | `Time_Zone` | Text | nullable |
|
1820 | | `Updated_By` | Text | nullable |
|
1821 | | `Vendor_RecID` | Numeric | nullable |
|
1822 | | `Vendor_SKU` | Text | nullable |
|
1823 |
|
1824 | #### InventoryMovement
|
1825 | | | | |
|
1826 | |-------------|-------------|-----|
|
1827 | | `Credit` | Numeric | nullable |
|
1828 | | `Customer` | Text | nullable |
|
1829 | | `Date` | DateTime | nullable |
|
1830 | | `Debit` | Numeric | nullable |
|
1831 | | `Description` | Text | nullable |
|
1832 | | `ProductId` | Text | nullable |
|
1833 | | `Quantity` | Numeric | nullable |
|
1834 | | `Ref` | Text | nullable |
|
1835 | | `Type` | Text | |
|
1836 |
|
1837 | #### InvoiceAgreementAdditions
|
1838 | | | | |
|
1839 | |-------------|-------------|-----|
|
1840 | | `AGR_Amount` | Numeric | nullable |
|
1841 | | `AGR_Header_RecID` | Numeric | |
|
1842 | | `AGR_Name` | Text | nullable |
|
1843 | | `Billing_Log_RecID` | Numeric | |
|
1844 | | `Currency_RecID` | Numeric | |
|
1845 | | `Currency_Symbol` | Text | nullable |
|
1846 | | `DisplaySymbol_Flag` | Boolean | |
|
1847 | | `Extended_Price` | Numeric | nullable |
|
1848 | | `IV_Item_RecID` | Numeric | nullable |
|
1849 | | `Invoice_Number` | Text | nullable |
|
1850 | | `IsParent` | Numeric | |
|
1851 | | `Item_ID` | Text | nullable |
|
1852 | | `Last_Update_UTC` | DateTime | |
|
1853 | | `Line_Desc` | Text | nullable |
|
1854 | | `Quantity` | Numeric | nullable |
|
1855 | | `Sequence_Number` | Numeric | nullable |
|
1856 | | `Serial_Number` | Text | nullable |
|
1857 | | `Taxable_Flag` | Boolean | nullable |
|
1858 | | `Type` | Text | |
|
1859 | | `Unit_Price` | Numeric | nullable |
|
1860 |
|
1861 | #### InvoiceCustomFields
|
1862 | | | | |
|
1863 | |-------------|-------------|-----|
|
1864 | | `Billing_Log_RecID` | Numeric | |
|
1865 | | `Invoice_Number` | Text | nullable |
|
1866 | | `Last_Update_UTC` | DateTime | |
|
1867 | | `Pod_RecID` | Numeric | |
|
1868 | | `Updated_By` | Text | |
|
1869 | | `User_Defined_Field_RecID` | Numeric | |
|
1870 | | `User_Defined_Field_Value` | Text | |
|
1871 | | `customfield_podID` | Text | |
|
1872 | | `invoice_customfield` | Text | |
|
1873 | | `invoice_fieldtype` | Text | nullable |
|
1874 |
|
1875 | #### InvoiceEmailTemplate
|
1876 | | | | |
|
1877 | |-------------|-------------|-----|
|
1878 | | `Billing_Status_RecID` | Numeric | nullable |
|
1879 | | `Default_Flag` | Boolean | nullable |
|
1880 | | `Email_Template_RecID` | Numeric | |
|
1881 | | `Last_Update` | DateTime | nullable |
|
1882 | | `Subject` | Text | nullable |
|
1883 | | `Template_Name` | Text | nullable |
|
1884 | | `TimeZone` | Text | nullable |
|
1885 | | `Updated_By` | Text | nullable |
|
1886 |
|
1887 | #### InvoiceExpense
|
1888 | | | | |
|
1889 | |-------------|-------------|-----|
|
1890 | | `Agreement` | Text | nullable |
|
1891 | | `Agreement_Amount_Covered` | Numeric | |
|
1892 | | `Billing_Log_RecID` | Numeric | nullable |
|
1893 | | `Charge_To` | Text | nullable |
|
1894 | | `Company_Name` | Text | nullable |
|
1895 | | `Company_RecID` | Numeric | nullable |
|
1896 | | `Currency_RecID` | Numeric | |
|
1897 | | `Currency_Symbol` | Text | nullable |
|
1898 | | `Date_Expense` | DateTime | nullable |
|
1899 | | `DisplaySymbol_Flag` | Boolean | |
|
1900 | | `EX_Detail_RecID` | Numeric | |
|
1901 | | `Expense_Cost` | Numeric | nullable |
|
1902 | | `Expense_Type` | Text | nullable |
|
1903 | | `Extended_Amount` | Numeric | nullable |
|
1904 | | `First_Name` | Text | nullable |
|
1905 | | `Invoice_Number` | Text | nullable |
|
1906 | | `Last_Name` | Text | nullable |
|
1907 | | `Last_Update` | DateTime | nullable |
|
1908 | | `Member_ID` | Text | |
|
1909 | | `Member_RecID` | Numeric | |
|
1910 | | `Option_ID` | Text | nullable |
|
1911 | | `PM_Phase_RecID` | Numeric | nullable |
|
1912 | | `PM_Project_RecID` | Numeric | nullable |
|
1913 | | `Project_Name` | Text | nullable |
|
1914 | | `Project_Phase` | Text | nullable |
|
1915 | | `Reason` | Text | nullable |
|
1916 | | `SR_Service_RecID` | Numeric | nullable |
|
1917 | | `SR_Summary` | Text | nullable |
|
1918 | | `Time_Zone` | Text | nullable |
|
1919 | | `Updated_By` | Text | nullable |
|
1920 |
|
1921 | #### InvoiceHeader
|
1922 | | | | |
|
1923 | |-------------|-------------|-----|
|
1924 | | `AGR_Amount` | Numeric | nullable |
|
1925 | | `AGR_Header_RecID` | Numeric | |
|
1926 | | `AGR_Hours` | Numeric | nullable |
|
1927 | | `Account` | Text | nullable |
|
1928 | | `Address_Line1` | Text | nullable |
|
1929 | | `Address_Line2` | Text | nullable |
|
1930 | | `Adj_Amount` | Numeric | nullable |
|
1931 | | `Adj_By` | Text | nullable |
|
1932 | | `Adj_Reason` | Text | nullable |
|
1933 | | `Agr_Adjustment` | Numeric | nullable |
|
1934 | | `Agreement_Name` | Text | nullable |
|
1935 | | `Apply_To` | Text | nullable |
|
1936 | | `Attention` | Text | nullable |
|
1937 | | `Bill_To_Address_Line1` | Text | nullable |
|
1938 | | `Bill_To_Address_Line2` | Text | nullable |
|
1939 | | `Bill_To_City` | Text | nullable |
|
1940 | | `Bill_To_Country` | Text | nullable |
|
1941 | | `Bill_To_Name` | Text | nullable |
|
1942 | | `Bill_To_PhoneNbr` | Text | nullable |
|
1943 | | `Bill_To_RecID` | Numeric | |
|
1944 | | `Bill_To_State_ID` | Text | nullable |
|
1945 | | `Bill_To_Zip` | Text | nullable |
|
1946 | | `Bill_to_Address_RecID` | Numeric | |
|
1947 | | `Billing_Contact_Name` | Text | |
|
1948 | | `Billing_Log_RecID` | Numeric | |
|
1949 | | `Billing_Method` | Text | nullable |
|
1950 | | `Billing_Status_RecID` | Numeric | |
|
1951 | | `Billing_Terms` | Text | nullable |
|
1952 | | `Billing_Terms_RecID` | Numeric | |
|
1953 | | `Billing_Type_Desc` | Text | nullable |
|
1954 | | `Billing_Type_ID` | Text | |
|
1955 | | `Billing_Unit_RecID` | Numeric | |
|
1956 | | `Bottom_Comment` | Text | nullable |
|
1957 | | `BusGroup` | Text | nullable |
|
1958 | | `City` | Text | nullable |
|
1959 | | `Closed_Flag` | Boolean | |
|
1960 | | `Company_Address_RecID` | Numeric | |
|
1961 | | `Company_Name` | Text | nullable |
|
1962 | | `Company_RecID` | Numeric | |
|
1963 | | `Country` | Text | nullable |
|
1964 | | `Credit_Amount` | Numeric | nullable |
|
1965 | | `Currency_RecID` | Numeric | |
|
1966 | | `Currency_Symbol` | Text | nullable |
|
1967 | | `Date_Closed` | DateTime | nullable |
|
1968 | | `Date_Created` | DateTime | nullable |
|
1969 | | `Date_Invoice` | DateTime | nullable |
|
1970 | | `Date_Paid` | DateTime | nullable |
|
1971 | | `Date_Processing` | DateTime | nullable |
|
1972 | | `DisplaySymbol_Flag` | Boolean | |
|
1973 | | `DownPayment` | Numeric | |
|
1974 | | `Due_Date` | DateTime | nullable |
|
1975 | | `Expense_Amount` | Numeric | nullable |
|
1976 | | `Internal_Note` | Text | nullable |
|
1977 | | `Invoice_Amount` | Numeric | |
|
1978 | | `Invoice_Footer` | Text | nullable |
|
1979 | | `Invoice_Number` | Text | nullable |
|
1980 | | `Invoice_Subtotal` | Numeric | nullable |
|
1981 | | `Invoice_Type` | Text | |
|
1982 | | `Last_Update` | DateTime | nullable |
|
1983 | | `Location` | Text | nullable |
|
1984 | | `Misc_Amount` | Numeric | nullable |
|
1985 | | `Owner_Level_RecID` | Numeric | |
|
1986 | | `PM_Phase_RecID` | Numeric | |
|
1987 | | `PM_Project_RecID` | Numeric | |
|
1988 | | `PO_Number` | Text | nullable |
|
1989 | | `Paid_Amount` | Numeric | |
|
1990 | | `Paid_Flag` | Numeric | |
|
1991 | | `Payable_Name` | Text | nullable |
|
1992 | | `Phase_ID` | Text | nullable |
|
1993 | | `PhoneNbr` | Text | nullable |
|
1994 | | `Processing_Flag` | Boolean | |
|
1995 | | `Progress_Amount_Applied` | Numeric | nullable |
|
1996 | | `Project_ID` | Text | nullable |
|
1997 | | `Reference` | Text | nullable |
|
1998 | | `Rem_Downpayment` | Numeric | nullable |
|
1999 | | `Remit_To_Address_Line1` | Text | nullable |
|
2000 | | `Remit_To_Address_Line2` | Text | nullable |
|
2001 | | `Remit_To_City` | Text | nullable |
|
2002 | | `Remit_To_Country` | Text | nullable |
|
2003 | | `Remit_To_Name` | Text | |
|
2004 | | `Remit_To_PhoneNbr` | Text | nullable |
|
2005 | | `Remit_To_State_ID` | Text | nullable |
|
2006 | | `Remit_To_Zip` | Text | nullable |
|
2007 | | `SalesOrderNbr` | Numeric | |
|
2008 | | `Sales_Tax_Amount` | Numeric | nullable |
|
2009 | | `Sent_Flag` | Boolean | |
|
2010 | | `Ship_To_Address_Line1` | Text | nullable |
|
2011 | | `Ship_To_Address_Line2` | Text | nullable |
|
2012 | | `Ship_To_Address_RecID` | Numeric | nullable |
|
2013 | | `Ship_To_Attention` | Text | nullable |
|
2014 | | `Ship_To_City` | Text | nullable |
|
2015 | | `Ship_To_Company_RecID` | Numeric | |
|
2016 | | `Ship_To_Country` | Text | nullable |
|
2017 | | `Ship_To_Name` | Text | nullable |
|
2018 | | `Ship_To_PhoneNbr` | Text | nullable |
|
2019 | | `Ship_To_State_ID` | Text | nullable |
|
2020 | | `Ship_To_Zip` | Text | nullable |
|
2021 | | `State_ID` | Text | nullable |
|
2022 | | `Status_Description` | Text | nullable |
|
2023 | | `Tax1_Amount` | Numeric | |
|
2024 | | `Tax2_Amount` | Numeric | |
|
2025 | | `Tax3_Amount` | Numeric | |
|
2026 | | `Tax4_Amount` | Numeric | |
|
2027 | | `Tax5_Amount` | Numeric | |
|
2028 | | `Tax6_Amount` | Numeric | |
|
2029 | | `Tax_Code` | Text | nullable |
|
2030 | | `Tax_Code1` | Text | nullable |
|
2031 | | `Tax_Code2` | Text | nullable |
|
2032 | | `Tax_Code3` | Text | nullable |
|
2033 | | `Tax_Code4` | Text | nullable |
|
2034 | | `Tax_Code5` | Text | nullable |
|
2035 | | `Tax_Code6` | Text | nullable |
|
2036 | | `Tax_Code_RecID` | Numeric | |
|
2037 | | `Territory` | Text | nullable |
|
2038 | | `Territory_RecID` | Numeric | nullable |
|
2039 | | `TicketNbr` | Numeric | |
|
2040 | | `Time_Amount` | Numeric | nullable |
|
2041 | | `Top_Comment` | Text | nullable |
|
2042 | | `Updated_By` | Text | nullable |
|
2043 | | `Zip` | Text | nullable |
|
2044 |
|
2045 | #### InvoicePayments
|
2046 | | | | |
|
2047 | |-------------|-------------|-----|
|
2048 | | `Applied_Amount` | Numeric | |
|
2049 | | `Applied_By` | Text | |
|
2050 | | `Billing_Application_RecID` | Numeric | |
|
2051 | | `Billing_Log_RecID` | Numeric | |
|
2052 | | `Credit_Memo_RecID` | Numeric | nullable |
|
2053 | | `Date_Applied` | DateTime | nullable |
|
2054 | | `Invoice_Number` | Text | nullable |
|
2055 | | `Last_Update` | DateTime | |
|
2056 | | `Payment_Type` | Text | |
|
2057 | | `Updated_By` | Text | |
|
2058 |
|
2059 | #### InvoiceProduct
|
2060 | | | | |
|
2061 | |-------------|-------------|-----|
|
2062 | | `AGR_Header_RecID` | Numeric | nullable |
|
2063 | | `Billable_Flag` | Boolean | |
|
2064 | | `Billing_Log_RecID` | Numeric | nullable |
|
2065 | | `Currency_RecID` | Numeric | |
|
2066 | | `Currency_Symbol` | Text | nullable |
|
2067 | | `DisplaySymbol_Flag` | Boolean | |
|
2068 | | `Extended_Amt` | Numeric | nullable |
|
2069 | | `IV_Item_RecID` | Numeric | |
|
2070 | | `IV_Product_RecID` | Numeric | |
|
2071 | | `Invoice_Number` | Text | nullable |
|
2072 | | `Item_Desc` | Text | nullable |
|
2073 | | `Item_ID` | Text | nullable |
|
2074 | | `Last_Update` | DateTime | |
|
2075 | | `Line_Desc` | Text | nullable |
|
2076 | | `Opportunity_RecID` | Numeric | nullable |
|
2077 | | `PM_Project_RecID` | Numeric | nullable |
|
2078 | | `Project_Name` | Text | nullable |
|
2079 | | `Quantity` | Numeric | nullable |
|
2080 | | `SR_Service_RecID` | Numeric | nullable |
|
2081 | | `SR_Summary` | Text | nullable |
|
2082 | | `Serial_Number` | Text | nullable |
|
2083 | | `Taxable_Flag` | Boolean | |
|
2084 | | `Time_Zone` | Text | nullable |
|
2085 | | `UOM` | Text | nullable |
|
2086 | | `Unit_Price` | Numeric | nullable |
|
2087 | | `Updated_By` | Text | nullable |
|
2088 | | `quantity_cancelled` | Numeric | |
|
2089 | | `sequence_number` | Numeric | |
|
2090 | | `sub_number` | Numeric | |
|
2091 |
|
2092 | #### InvoiceTemplate
|
2093 | | | | |
|
2094 | |-------------|-------------|-----|
|
2095 | | `BL_InvTemplate_Custom_RecID` | Numeric | nullable |
|
2096 | | `BL_InvTemplate_RecID` | Numeric | nullable |
|
2097 | | `BL_InvTemplate_Setup_RecID` | Numeric | |
|
2098 | | `Template_Name` | Text | nullable |
|
2099 |
|
2100 | #### InvoiceTime
|
2101 | | | | |
|
2102 | |-------------|-------------|-----|
|
2103 | | `AgrAmtCovered` | Numeric | |
|
2104 | | `AgrHrsCovered` | Numeric | |
|
2105 | | `Agreement` | Text | |
|
2106 | | `Billable_Amt` | Numeric | nullable |
|
2107 | | `Billable_Flag` | Boolean | |
|
2108 | | `Billable_Hrs` | Numeric | nullable |
|
2109 | | `Billing_Log_RecID` | Numeric | |
|
2110 | | `Billing_Unit_RecID` | Numeric | nullable |
|
2111 | | `BusGroup` | Text | nullable |
|
2112 | | `Charge_To` | Text | nullable |
|
2113 | | `Company_Name` | Text | nullable |
|
2114 | | `Company_RecID` | Numeric | |
|
2115 | | `Currency_RecID` | Numeric | |
|
2116 | | `Currency_Symbol` | Text | nullable |
|
2117 | | `Date_Entered_UTC` | DateTime | |
|
2118 | | `Date_Start` | DateTime | nullable |
|
2119 | | `DisplaySymbol_Flag` | Boolean | |
|
2120 | | `First_Name` | Text | nullable |
|
2121 | | `Hourly_Cost` | Numeric | nullable |
|
2122 | | `Hourly_Rate` | Numeric | nullable |
|
2123 | | `Invoice_Number` | Text | nullable |
|
2124 | | `Last_Name` | Text | nullable |
|
2125 | | `Location` | Text | nullable |
|
2126 | | `Member_ID` | Text | |
|
2127 | | `Member_RecID` | Numeric | nullable |
|
2128 | | `NonBillable_Amt` | Numeric | nullable |
|
2129 | | `NonBillable_Hrs` | Numeric | nullable |
|
2130 | | `Notes` | Text | nullable |
|
2131 | | `Option_ID` | Text | nullable |
|
2132 | | `Owner_Level_RecID` | Numeric | nullable |
|
2133 | | `PM_Project_RecID` | Numeric | |
|
2134 | | `Project_ID` | Text | nullable |
|
2135 | | `Project_Phase` | Text | nullable |
|
2136 | | `SR_Service_RecID` | Numeric | |
|
2137 | | `Summary` | Text | nullable |
|
2138 | | `Time_Agr_Header_RecID` | Numeric | nullable |
|
2139 | | `Time_End_UTC` | DateTime | nullable |
|
2140 | | `Time_RecID` | Numeric | |
|
2141 | | `Time_Start_UTC` | DateTime | nullable |
|
2142 | | `Work_Role` | Text | |
|
2143 | | `Work_Type` | Text | |
|
2144 | | `pm_Phase_RecID` | Numeric | nullable |
|
2145 |
|
2146 | #### InvoiceTypes
|
2147 | | | | |
|
2148 | |-------------|-------------|-----|
|
2149 | | `Billing_Type_ID` | Text | |
|
2150 | | `Downpayment_Flag` | Boolean | nullable |
|
2151 | | `InvoiceType_Desc` | Text | nullable |
|
2152 |
|
2153 | #### Invoices
|
2154 | | | | |
|
2155 | |-------------|-------------|-----|
|
2156 | | `AGR_Amount` | Numeric | |
|
2157 | | `AGR_Header_RecID` | Numeric | |
|
2158 | | `AGR_Hours` | Numeric | nullable |
|
2159 | | `Address_Line1` | Text | nullable |
|
2160 | | `Address_Line2` | Text | nullable |
|
2161 | | `Adj_Amount` | Numeric | |
|
2162 | | `Adj_By` | Text | nullable |
|
2163 | | `Adj_Reason` | Text | nullable |
|
2164 | | `Agr_Adjustment` | Numeric | |
|
2165 | | `Agreement_Name` | Text | nullable |
|
2166 | | `Apply_To` | Text | nullable |
|
2167 | | `Attention` | Text | nullable |
|
2168 | | `Billing_Contact_First_Name` | Text | nullable |
|
2169 | | `Billing_Contact_Last_Name` | Text | nullable |
|
2170 | | `Billing_Contact_RecID` | Numeric | nullable |
|
2171 | | `Billing_Log_RecID` | Numeric | |
|
2172 | | `Billing_Status_RecID` | Numeric | |
|
2173 | | `Billing_Terms` | Text | nullable |
|
2174 | | `Billing_Terms_RecID` | Numeric | |
|
2175 | | `Billing_Type_Desc` | Text | nullable |
|
2176 | | `Billing_Type_ID` | Text | nullable |
|
2177 | | `Billing_Unit_RecID` | Numeric | nullable |
|
2178 | | `Bottom_Comment` | Text | nullable |
|
2179 | | `BusGroup` | Text | nullable |
|
2180 | | `City` | Text | nullable |
|
2181 | | `Closed_Flag` | Boolean | |
|
2182 | | `CompanyRecId` | Numeric | |
|
2183 | | `Company_Address_RecID` | Numeric | nullable |
|
2184 | | `Company_Name` | Text | nullable |
|
2185 | | `Company_RecID` | Numeric | |
|
2186 | | `Country` | Text | nullable |
|
2187 | | `Credit_Amount` | Numeric | nullable |
|
2188 | | `Currency_RecID` | Numeric | |
|
2189 | | `Date_Closed` | DateTime | nullable |
|
2190 | | `Date_Created` | DateTime | |
|
2191 | | `Date_Invoice` | DateTime | nullable |
|
2192 | | `Date_Paid` | DateTime | nullable |
|
2193 | | `Date_Processing` | DateTime | nullable |
|
2194 | | `DownPayment` | Numeric | |
|
2195 | | `Due_Date` | DateTime | nullable |
|
2196 | | `Expense_Amount` | Numeric | |
|
2197 | | `Internal_Note` | Text | nullable |
|
2198 | | `Invoice_Amount` | Numeric | |
|
2199 | | `Invoice_Number` | Text | nullable |
|
2200 | | `Invoice_Type` | Text | |
|
2201 | | `Last_Update` | DateTime | |
|
2202 | | `Location` | Text | nullable |
|
2203 | | `Misc_Amount` | Numeric | |
|
2204 | | `Owner_Level_RecID` | Numeric | |
|
2205 | | `PM_Phase_RecID` | Numeric | nullable |
|
2206 | | `PM_Project_RecID` | Numeric | |
|
2207 | | `PO_Number` | Text | nullable |
|
2208 | | `Paid_Amount` | Numeric | |
|
2209 | | `Paid_Flag` | Numeric | |
|
2210 | | `Phase_ID` | Text | nullable |
|
2211 | | `Processing_Flag` | Boolean | |
|
2212 | | `Progress_Amount_Applied` | Numeric | |
|
2213 | | `Project_ID` | Text | nullable |
|
2214 | | `Reference` | Text | nullable |
|
2215 | | `Rem_Downpayment` | Numeric | |
|
2216 | | `Remaining_Credit_Balance` | Numeric | nullable |
|
2217 | | `Remit_To_Name` | Text | nullable |
|
2218 | | `Remit_To_RecID` | Numeric | |
|
2219 | | `SalesOrderNbr` | Numeric | nullable |
|
2220 | | `Sales_Tax_Amount` | Numeric | |
|
2221 | | `Sent_Flag` | Boolean | nullable |
|
2222 | | `State_ID` | Text | nullable |
|
2223 | | `Status_Description` | Text | nullable |
|
2224 | | `Tax1_Amount` | Numeric | |
|
2225 | | `Tax2_Amount` | Numeric | |
|
2226 | | `Tax3_Amount` | Numeric | |
|
2227 | | `Tax4_Amount` | Numeric | |
|
2228 | | `Tax5_Amount` | Numeric | |
|
2229 | | `Tax6_Amount` | Numeric | |
|
2230 | | `Tax_Code` | Text | nullable |
|
2231 | | `Tax_Code1` | Text | nullable |
|
2232 | | `Tax_Code2` | Text | nullable |
|
2233 | | `Tax_Code3` | Text | nullable |
|
2234 | | `Tax_Code4` | Text | nullable |
|
2235 | | `Tax_Code5` | Text | nullable |
|
2236 | | `Tax_Code6` | Text | nullable |
|
2237 | | `Tax_Code_RecID` | Numeric | nullable |
|
2238 | | `Territory` | Text | nullable |
|
2239 | | `Territory_recid` | Numeric | nullable |
|
2240 | | `TicketNbr` | Numeric | |
|
2241 | | `Ticket_Summary` | Text | nullable |
|
2242 | | `Time_Amount` | Numeric | |
|
2243 | | `Time_Zone` | Text | nullable |
|
2244 | | `Top_Comment` | Text | nullable |
|
2245 | | `Updated_By` | Text | nullable |
|
2246 | | `Zip` | Text | nullable |
|
2247 | | `ship_to_company_address_recid` | Numeric | nullable |
|
2248 |
|
2249 | #### KbResolutionAuditTrail
|
2250 | | | | |
|
2251 | |-------------|-------------|-----|
|
2252 | | `Billing_Unit_RecID` | Numeric | nullable |
|
2253 | | `Company_RecId` | Numeric | nullable |
|
2254 | | `Configuration_Type_RecId` | Numeric | nullable |
|
2255 | | `Created_By` | Text | |
|
2256 | | `Detail_Problem` | Text | nullable |
|
2257 | | `Internal_Notes` | Text | nullable |
|
2258 | | `KB_Category_RecID` | Numeric | nullable |
|
2259 | | `KB_Resolution_RecID` | Numeric | |
|
2260 | | `KB_Status_Key` | Text | |
|
2261 | | `KB_SubCategory_RecID` | Numeric | nullable |
|
2262 | | `Last_Update_UTC` | DateTime | |
|
2263 | | `Owner_Level_RecID` | Numeric | nullable |
|
2264 | | `Resolution` | Text | nullable |
|
2265 | | `SR_Board_RecID` | Numeric | nullable |
|
2266 | | `Submitted_By` | Text | nullable |
|
2267 | | `Summary` | Text | nullable |
|
2268 |
|
2269 | #### KnowledgebaseCategory
|
2270 | | | | |
|
2271 | |-------------|-------------|-----|
|
2272 | | `Billing_Unit_RecID` | Numeric | nullable |
|
2273 | | `Description` | Text | nullable |
|
2274 | | `KB_Category_RecID` | Numeric | |
|
2275 | | `Last_Update` | DateTime | |
|
2276 | | `Owner_Level_RecID` | Numeric | nullable |
|
2277 | | `Time_Zone` | Text | nullable |
|
2278 | | `Updated_By` | Text | nullable |
|
2279 |
|
2280 | #### KnowledgebaseSubCategory
|
2281 | | | | |
|
2282 | |-------------|-------------|-----|
|
2283 | | `Billing_Unit_RecID` | Numeric | nullable |
|
2284 | | `Description` | Text | nullable |
|
2285 | | `KB_Category_RecID` | Numeric | |
|
2286 | | `KB_SubCategory_RecID` | Numeric | |
|
2287 | | `Last_Update` | DateTime | nullable |
|
2288 | | `Owner_Level_RecID` | Numeric | nullable |
|
2289 | | `Time_Zone` | Text | nullable |
|
2290 | | `Updated_By` | Text | nullable |
|
2291 |
|
2292 | #### Link
|
2293 | | | | |
|
2294 | |-------------|-------------|-----|
|
2295 | | `Last_Update` | DateTime | nullable |
|
2296 | | `Link_Definition` | Text | nullable |
|
2297 | | `Link_Name` | Text | |
|
2298 | | `Screen_Link_RecID` | Numeric | |
|
2299 | | `Screen_Link_Table_RecID` | Numeric | |
|
2300 | | `Time_Zone` | Text | nullable |
|
2301 | | `Updated_By` | Text | nullable |
|
2302 |
|
2303 | #### LinkTokens
|
2304 | | | | |
|
2305 | |-------------|-------------|-----|
|
2306 | | `Company_Flag` | Boolean | |
|
2307 | | `Contact_Flag` | Boolean | |
|
2308 | | `Service_Flag` | Boolean | nullable |
|
2309 | | `Token` | Text | nullable |
|
2310 | | `Token_Description` | Text | nullable |
|
2311 | | `Token_RecID` | Numeric | |
|
2312 |
|
2313 | #### Locale
|
2314 | | | | |
|
2315 | |-------------|-------------|-----|
|
2316 | | `Default_Flag` | Boolean | nullable |
|
2317 | | `Locale` | Text | |
|
2318 | | `Locale_RecID` | Numeric | |
|
2319 |
|
2320 | #### LocationBusGroup
|
2321 | | | | |
|
2322 | |-------------|-------------|-----|
|
2323 | | `Billing_Unit_RecID` | Numeric | |
|
2324 | | `BusGroup` | Text | nullable |
|
2325 | | `Last_Update` | DateTime | nullable |
|
2326 | | `Location` | Text | nullable |
|
2327 | | `Owner_Level_RecID` | Numeric | |
|
2328 | | `Time_Zone` | Text | nullable |
|
2329 | | `Updated_By` | Text | nullable |
|
2330 |
|
2331 | #### Managed_Device_XRef
|
2332 | | | | |
|
2333 | |-------------|-------------|-----|
|
2334 | | `AGR_Type_RecID` | Numeric | nullable |
|
2335 | | `AgreementType` | Text | nullable |
|
2336 | | `CS_Survey_RecID` | Numeric | nullable |
|
2337 | | `Configuration_Type` | Text | nullable |
|
2338 | | `IV_Item_RecID` | Numeric | nullable |
|
2339 | | `Inactive_Flag` | Boolean | nullable |
|
2340 | | `Last_Update` | DateTime | nullable |
|
2341 | | `Level` | Text | nullable |
|
2342 | | `Mgmt_It_Levels_RecID` | Numeric | nullable |
|
2343 | | `Mgmt_It_Setup_RecID` | Numeric | |
|
2344 | | `Mgmt_Solution_Name` | Text | nullable |
|
2345 | | `ProductName` | Text | nullable |
|
2346 | | `Time_Zone` | Text | nullable |
|
2347 | | `Type` | Text | nullable |
|
2348 | | `Updated_By` | Text | nullable |
|
2349 |
|
2350 | #### Manufacturer
|
2351 | | | | |
|
2352 | |-------------|-------------|-----|
|
2353 | | `Inactive_Flag` | Boolean | nullable |
|
2354 | | `Last_Update` | DateTime | |
|
2355 | | `Last_Update_UTC` | DateTime | |
|
2356 | | `Manufacturer_Name` | Text | |
|
2357 | | `Manufacturer_RecID` | Numeric | |
|
2358 | | `Time_Zone` | Text | nullable |
|
2359 | | `Updated_By` | Text | nullable |
|
2360 |
|
2361 | #### Market
|
2362 | | | | |
|
2363 | |-------------|-------------|-----|
|
2364 | | `Last_Update_UTC` | DateTime | |
|
2365 | | `MarketId` | Numeric | |
|
2366 | | `MarketName` | Text | nullable |
|
2367 |
|
2368 | #### MarketingCampaign
|
2369 | | | | |
|
2370 | |-------------|-------------|-----|
|
2371 | | `Actual_Cost` | Numeric | |
|
2372 | | `Budget_Cost` | Numeric | |
|
2373 | | `Budget_Revenue` | Numeric | |
|
2374 | | `Campaign_Status_RecID` | Numeric | nullable |
|
2375 | | `Campaign_SubType` | Text | nullable |
|
2376 | | `Campaign_Subtype_RecID` | Numeric | nullable |
|
2377 | | `Campaign_Type` | Text | nullable |
|
2378 | | `Cancel_Days` | Numeric | nullable |
|
2379 | | `Cancel_Type` | Text | nullable |
|
2380 | | `Date_Cancel` | DateTime | nullable |
|
2381 | | `Date_End` | DateTime | nullable |
|
2382 | | `Date_Start` | DateTime | nullable |
|
2383 | | `Emails_Sent` | Numeric | nullable |
|
2384 | | `Group_Type_RecID` | Numeric | nullable |
|
2385 | | `Inactive` | Text | |
|
2386 | | `Inactive_Flag` | Boolean | nullable |
|
2387 | | `Last_Update` | DateTime | |
|
2388 | | `Last_Update_UTC` | DateTime | |
|
2389 | | `Location` | Text | nullable |
|
2390 | | `Lost_Opportunities` | Numeric | |
|
2391 | | `Lost_Revenue` | Numeric | nullable |
|
2392 | | `Marketing_Campaign_RecID` | Numeric | |
|
2393 | | `Marketing_ID` | Text | nullable |
|
2394 | | `Notes` | Text | nullable |
|
2395 | | `Open_Opportunities` | Numeric | |
|
2396 | | `Open_Revenue` | Numeric | nullable |
|
2397 | | `Owner_Level_RecID` | Numeric | nullable |
|
2398 | | `Status` | Text | nullable |
|
2399 | | `Time_Zone` | Text | nullable |
|
2400 | | `Total_Opportunities` | Numeric | |
|
2401 | | `Updated_By` | Text | nullable |
|
2402 | | `Won_Opportunities` | Numeric | |
|
2403 | | `Won_Revenue` | Numeric | nullable |
|
2404 |
|
2405 | #### MarketingEmailsOpened
|
2406 | | | | |
|
2407 | |-------------|-------------|-----|
|
2408 | | `Contact_RecID` | Numeric | nullable |
|
2409 | | `Date_Opened` | DateTime | |
|
2410 | | `Marketing_Campaign_RecID` | Numeric | |
|
2411 | | `Marketing_Manager_Email_Opened_RecID` | Numeric | |
|
2412 | | `Time_Zone` | Text | nullable |
|
2413 |
|
2414 | #### MarketingFormsSubmitted
|
2415 | | | | |
|
2416 | |-------------|-------------|-----|
|
2417 | | `Contact_RecID` | Numeric | nullable |
|
2418 | | `Date_Submitted` | DateTime | |
|
2419 | | `Marketing_Campaign_RecID` | Numeric | |
|
2420 | | `Marketing_Manager_Form_Submitted_RecID` | Numeric | |
|
2421 | | `Page_Sub_Type` | Text | nullable |
|
2422 | | `Page_Type` | Text | nullable |
|
2423 | | `QueryString` | Text | nullable |
|
2424 | | `Status` | Text | nullable |
|
2425 | | `Time_Zone` | Text | nullable |
|
2426 | | `Topic` | Text | nullable |
|
2427 | | `URL` | Text | |
|
2428 | | `Version` | Text | nullable |
|
2429 |
|
2430 | #### MarketingLinksClicked
|
2431 | | | | |
|
2432 | |-------------|-------------|-----|
|
2433 | | `Contact_RecID` | Numeric | nullable |
|
2434 | | `Date_Clicked` | DateTime | |
|
2435 | | `Marketing_Campaign_RecID` | Numeric | |
|
2436 | | `Marketing_Manager_Link_Clicked_RecID` | Numeric | |
|
2437 | | `QueryString` | Text | nullable |
|
2438 | | `Time_Zone` | Text | nullable |
|
2439 | | `URL` | Text | |
|
2440 |
|
2441 | #### MarketingROI
|
2442 | | | | |
|
2443 | |-------------|-------------|-----|
|
2444 | | `Actual_Cost` | Numeric | |
|
2445 | | `Campaign` | Text | nullable |
|
2446 | | `Campaign_SubType` | Text | nullable |
|
2447 | | `Campaign_Type` | Text | nullable |
|
2448 | | `End_Date` | DateTime | |
|
2449 | | `Last_Update` | DateTime | nullable |
|
2450 | | `Location` | Text | nullable |
|
2451 | | `Lost_Opportunities` | Numeric | |
|
2452 | | `Lost_Revenue` | Numeric | nullable |
|
2453 | | `Open_Opportunities` | Numeric | |
|
2454 | | `Open_Revenue` | Numeric | nullable |
|
2455 | | `Start_Date` | DateTime | nullable |
|
2456 | | `Status` | Text | |
|
2457 | | `Time_Zone` | Text | nullable |
|
2458 | | `Total_Opportunities` | Numeric | |
|
2459 | | `Updated_By` | Text | nullable |
|
2460 | | `Won_Opportunities` | Numeric | |
|
2461 | | `Won_Revenue` | Numeric | nullable |
|
2462 |
|
2463 | #### MeetingAudit
|
2464 | | | | |
|
2465 | |-------------|-------------|-----|
|
2466 | | `Affected_Record` | Text | nullable |
|
2467 | | `Audit_Source_ID` | Text | nullable |
|
2468 | | `Audit_SubType` | Text | nullable |
|
2469 | | `Audit_Text` | Text | nullable |
|
2470 | | `Audit_Type` | Text | nullable |
|
2471 | | `Created_By` | Text | |
|
2472 | | `Date_Entered_UTC` | DateTime | |
|
2473 | | `Locale_RecID` | Numeric | nullable |
|
2474 | | `Meeting_Audit_RecID` | Numeric | |
|
2475 | | `Meeting_RecID` | Numeric | |
|
2476 | | `New_Value` | Text | nullable |
|
2477 | | `Old_Value` | Text | nullable |
|
2478 |
|
2479 | #### Member
|
2480 | | | | |
|
2481 | |-------------|-------------|-----|
|
2482 | | `Activity_Class_RecID` | Numeric | nullable |
|
2483 | | `Activity_Type_RecID` | Numeric | nullable |
|
2484 | | `Approved_By` | Text | nullable |
|
2485 | | `Billable_Forecast` | Numeric | nullable |
|
2486 | | `Billing_Unit_RecID` | Numeric | nullable |
|
2487 | | `Board_Name` | Text | nullable |
|
2488 | | `Country` | Text | nullable |
|
2489 | | `Country_RecID` | Numeric | nullable |
|
2490 | | `Daily_Capacity` | Numeric | nullable |
|
2491 | | `Date_Hire` | DateTime | nullable |
|
2492 | | `Date_Inactive` | DateTime | nullable |
|
2493 | | `Default_Email` | Numeric | nullable |
|
2494 | | `Default_Loc_RecID` | Numeric | nullable |
|
2495 | | `Default_Phone` | Numeric | nullable |
|
2496 | | `Default_Sales_Basis` | Text | nullable |
|
2497 | | `Default_Sales_Billing_Unit` | Numeric | nullable |
|
2498 | | `Default_Sales_Display` | Text | nullable |
|
2499 | | `Default_Sales_Owner_Level` | Numeric | nullable |
|
2500 | | `Default_Ter_RecID` | Numeric | nullable |
|
2501 | | `Disable_Login_Flag` | Boolean | nullable |
|
2502 | | `EX_Company_Flag` | Boolean | |
|
2503 | | `Email_Address` | Text | nullable |
|
2504 | | `Email_Address2` | Text | nullable |
|
2505 | | `Email_Address3` | Text | nullable |
|
2506 | | `Enter_Company_Flag` | Boolean | |
|
2507 | | `Exp_Approver` | Text | nullable |
|
2508 | | `First_Name` | Text | nullable |
|
2509 | | `Hourly_Cost` | Text | nullable |
|
2510 | | `Hourly_Rate` | Numeric | nullable |
|
2511 | | `Image_Link` | Text | nullable |
|
2512 | | `Inactive_Flag` | Boolean | |
|
2513 | | `Last_Login_UTC` | DateTime | nullable |
|
2514 | | `Last_Name` | Text | nullable |
|
2515 | | `Last_Update` | DateTime | |
|
2516 | | `Last_Update_UTC` | DateTime | |
|
2517 | | `License_Type` | Text | nullable |
|
2518 | | `MAPI_Name` | Text | nullable |
|
2519 | | `Member_Full_Name` | Text | |
|
2520 | | `Member_ID` | Text | |
|
2521 | | `Member_RecID` | Numeric | |
|
2522 | | `Member_Type_Desc` | Text | nullable |
|
2523 | | `Member_Type_RecID` | Numeric | nullable |
|
2524 | | `Middle_Initial` | Text | nullable |
|
2525 | | `Mobile_Flag` | Boolean | nullable |
|
2526 | | `Notes` | Text | nullable |
|
2527 | | `Office_Calendar_RecID` | Numeric | nullable |
|
2528 | | `Owner_ID` | Numeric | nullable |
|
2529 | | `Owner_Level_RecID` | Numeric | nullable |
|
2530 | | `PM_Billing_Unit_Recid` | Numeric | nullable |
|
2531 | | `PM_Owner_Level_RecID` | Numeric | nullable |
|
2532 | | `PR_Emp_ID` | Text | nullable |
|
2533 | | `PhoneNbr` | Text | nullable |
|
2534 | | `PhoneNbr2` | Text | nullable |
|
2535 | | `PhoneNbr2_Mobile` | Text | nullable |
|
2536 | | `PhoneNbr3` | Text | nullable |
|
2537 | | `PhoneNbr3_Ext` | Text | nullable |
|
2538 | | `PhoneNbr_Ext` | Text | nullable |
|
2539 | | `Remote_Package_Account_ID` | Text | nullable |
|
2540 | | `Remote_Package_ID` | Text | nullable |
|
2541 | | `Remote_Package_Login` | Text | nullable |
|
2542 | | `Remote_Package_Platform` | Text | nullable |
|
2543 | | `Reports_To` | Text | nullable |
|
2544 | | `Require_Exp_Flag` | Boolean | nullable |
|
2545 | | `Require_Time_Flag` | Boolean | nullable |
|
2546 | | `Restrict_BU_Flag` | Boolean | nullable |
|
2547 | | `Restrict_Loc_Flag` | Boolean | nullable |
|
2548 | | `Restrict_PM_BU_Flag` | Boolean | |
|
2549 | | `Restrict_PM_Loc_Flag` | Boolean | |
|
2550 | | `Restrict_SB_Loc_Flag` | Boolean | nullable |
|
2551 | | `Restrict_Ter_Flag` | Boolean | nullable |
|
2552 | | `Role_ID` | Text | nullable |
|
2553 | | `SR_Billing_Unit_RecID` | Numeric | nullable |
|
2554 | | `SR_Board_RecID` | Numeric | nullable |
|
2555 | | `SR_Location_RecID` | Numeric | nullable |
|
2556 | | `SR_Owner_Level_RecID` | Numeric | nullable |
|
2557 | | `Sch_BU_RecID` | Numeric | nullable |
|
2558 | | `Sch_NoDisplay_Flag` | Boolean | nullable |
|
2559 | | `Sch_OL_RecID` | Numeric | nullable |
|
2560 | | `Sch_Restrict_Flag` | Boolean | nullable |
|
2561 | | `Sched_Capacity` | Numeric | nullable |
|
2562 | | `Scheduling_Auto_Popup_Quick_Notes` | Boolean | |
|
2563 | | `Scheduling_Auto_Stopwatch` | Boolean | |
|
2564 | | `System_Flag` | Boolean | nullable |
|
2565 | | `Time_StartEnd_Flag` | Boolean | |
|
2566 | | `Time_Zone` | Text | nullable |
|
2567 | | `Time_Zone_name` | Text | nullable |
|
2568 | | `Title` | Text | nullable |
|
2569 | | `Updated_By` | Text | nullable |
|
2570 | | `Utilization_Flag` | Boolean | |
|
2571 | | `Vendor_Nbr` | Text | nullable |
|
2572 | | `Warehouse_Bin_Flag` | Boolean | |
|
2573 | | `Warehouse_Bin_RecID` | Numeric | nullable |
|
2574 | | `Warehouse_Flag` | Boolean | nullable |
|
2575 | | `Warehouse_RecID` | Numeric | nullable |
|
2576 | | `Work_Role` | Text | nullable |
|
2577 | | `Work_Type` | Text | nullable |
|
2578 | | `time_zone_recid` | Numeric | nullable |
|
2579 |
|
2580 | #### MemberCertifications
|
2581 | | | | |
|
2582 | |-------------|-------------|-----|
|
2583 | | `Cert_Name` | Text | nullable |
|
2584 | | `Cert_Nbr` | Text | nullable |
|
2585 | | `Company_Name` | Text | nullable |
|
2586 | | `Company_RecID` | Numeric | nullable |
|
2587 | | `Date_Expires` | DateTime | nullable |
|
2588 | | `Date_Received` | DateTime | nullable |
|
2589 | | `Last_Update` | DateTime | nullable |
|
2590 | | `Last_Update_UTC` | DateTime | |
|
2591 | | `Member_RecID` | Numeric | nullable |
|
2592 | | `Notes` | Text | nullable |
|
2593 | | `Percent_Complete` | Numeric | nullable |
|
2594 | | `RM_Cert_Mbr_RecID` | Numeric | |
|
2595 | | `RM_Cert_RecID` | Numeric | nullable |
|
2596 | | `Time_Zone` | Text | nullable |
|
2597 | | `Updated_By` | Text | nullable |
|
2598 |
|
2599 | #### MemberSecurityRoles
|
2600 | | | | |
|
2601 | |-------------|-------------|-----|
|
2602 | | `Add_Level` | Numeric | nullable |
|
2603 | | `Delete_Level` | Numeric | nullable |
|
2604 | | `Edit_Level` | Numeric | nullable |
|
2605 | | `FO_Role_Security_RecID` | Numeric | |
|
2606 | | `Inquire_Level` | Numeric | nullable |
|
2607 | | `Last_Update` | DateTime | nullable |
|
2608 | | `Member_ID` | Text | |
|
2609 | | `Module_ID` | Text | nullable |
|
2610 | | `Module_Name` | Text | nullable |
|
2611 | | `Time_Zone` | Text | nullable |
|
2612 | | `Updated_By` | Text | nullable |
|
2613 |
|
2614 | #### MemberSkills
|
2615 | | | | |
|
2616 | |-------------|-------------|-----|
|
2617 | | `Cat_Name` | Text | nullable |
|
2618 | | `Cert_Flag` | Boolean | |
|
2619 | | `Description` | Text | nullable |
|
2620 | | `Last_Update` | DateTime | nullable |
|
2621 | | `Last_Update_UTC` | DateTime | |
|
2622 | | `Member_RecID` | Numeric | nullable |
|
2623 | | `Notes` | Text | nullable |
|
2624 | | `RM_Skill_Cat_RecID` | Numeric | nullable |
|
2625 | | `RM_Skill_Level_ID` | Numeric | nullable |
|
2626 | | `RM_Skill_Mbr_RecID` | Numeric | |
|
2627 | | `RM_Skill_RecID` | Numeric | nullable |
|
2628 | | `Skill_Name` | Text | nullable |
|
2629 | | `Skill_Rating` | Numeric | nullable |
|
2630 | | `Time_Zone` | Text | nullable |
|
2631 | | `Updated_By` | Text | nullable |
|
2632 | | `Years_Exp` | Numeric | nullable |
|
2633 |
|
2634 | #### MyAccountCustomFields
|
2635 | | | | |
|
2636 | |-------------|-------------|-----|
|
2637 | | `Last_Update_UTC` | DateTime | |
|
2638 | | `Member_ID` | Text | |
|
2639 | | `Member_RecID` | Numeric | |
|
2640 | | `Pod_RecID` | Numeric | |
|
2641 | | `Updated_By` | Text | |
|
2642 | | `User_Defined_Field_RecID` | Numeric | |
|
2643 | | `User_Defined_Field_Value` | Text | |
|
2644 | | `customfield_podID` | Text | |
|
2645 | | `myaccount_customfield` | Text | |
|
2646 | | `myaccount_fieldtype` | Text | nullable |
|
2647 |
|
2648 | #### MyCompany
|
2649 | | | | |
|
2650 | |-------------|-------------|-----|
|
2651 | | `COO_RecID` | Numeric | nullable |
|
2652 | | `Controller_RecID` | Numeric | nullable |
|
2653 | | `Currency_ID` | Text | nullable |
|
2654 | | `Dispatch_RecID` | Numeric | nullable |
|
2655 | | `DutyManager_RecID` | Numeric | nullable |
|
2656 | | `Internal_Company_RecID` | Numeric | nullable |
|
2657 | | `Last_Update` | DateTime | |
|
2658 | | `Last_Update_UTC` | DateTime | |
|
2659 | | `Office_Calendar_RecID` | Text | nullable |
|
2660 | | `President_RecID` | Numeric | nullable |
|
2661 | | `SO_ProbLock_Flag` | Boolean | nullable |
|
2662 | | `Schedule_Span_RecID` | Numeric | nullable |
|
2663 | | `ServiceManager_RecID` | Numeric | nullable |
|
2664 | | `TE_NoFutureRecords_Flag` | Boolean | |
|
2665 | | `Time_Zone` | Text | nullable |
|
2666 | | `Updated_By` | Text | nullable |
|
2667 |
|
2668 | #### NoteType
|
2669 | | | | |
|
2670 | |-------------|-------------|-----|
|
2671 | | `Default_Flag` | Boolean | |
|
2672 | | `Description` | Text | nullable |
|
2673 | | `Last_Update` | DateTime | |
|
2674 | | `Last_Update_UTC` | DateTime | |
|
2675 | | `Note_Type_ID` | Text | |
|
2676 | | `Note_Type_RecID` | Numeric | |
|
2677 | | `Time_Zone` | Text | nullable |
|
2678 | | `Updated_By` | Text | nullable |
|
2679 |
|
2680 | #### NotifyWho
|
2681 | | | | |
|
2682 | |-------------|-------------|-----|
|
2683 | | `External_Flag` | Boolean | |
|
2684 | | `Notify_Description` | Text | nullable |
|
2685 | | `Service_Flag` | Boolean | |
|
2686 | | `WF_NotifyWho_ID` | Text | |
|
2687 | | `WF_NotifyWho_RecID` | Numeric | |
|
2688 |
|
2689 | #### Opportunity
|
2690 | | | | |
|
2691 | |-------------|-------------|-----|
|
2692 | | `Agreement_Cost` | Numeric | nullable |
|
2693 | | `Agreement_Revenue` | Numeric | nullable |
|
2694 | | `Agreement_Type` | Text | nullable |
|
2695 | | `BusGroup` | Text | nullable |
|
2696 | | `Closed_By` | Text | nullable |
|
2697 | | `Closed_Flag` | Boolean | |
|
2698 | | `Closed_Status` | Text | |
|
2699 | | `CompanyRecId` | Numeric | nullable |
|
2700 | | `Company_Name` | Text | nullable |
|
2701 | | `Company_RecID` | Numeric | nullable |
|
2702 | | `Contact_Name` | Text | nullable |
|
2703 | | `Contact_RecID` | Numeric | nullable |
|
2704 | | `CustomerPO` | Text | nullable |
|
2705 | | `Date_Became_Lead` | DateTime | nullable |
|
2706 | | `Date_Closed` | DateTime | nullable |
|
2707 | | `Date_Update` | DateTime | nullable |
|
2708 | | `Entered_By` | Text | nullable |
|
2709 | | `Expected_Close_Date` | DateTime | nullable |
|
2710 | | `Forecast` | Text | |
|
2711 | | `Last_Update` | DateTime | nullable |
|
2712 | | `Last_Update_UTC` | DateTime | |
|
2713 | | `Location` | Text | nullable |
|
2714 | | `Lost_Revenue` | Numeric | |
|
2715 | | `Opportunity_Desc` | Text | nullable |
|
2716 | | `Opportunity_Name` | Text | nullable |
|
2717 | | `Opportunity_RecID` | Numeric | |
|
2718 | | `Other1_Cost` | Numeric | nullable |
|
2719 | | `Other1_Revenue` | Numeric | nullable |
|
2720 | | `Other2_Cost` | Numeric | nullable |
|
2721 | | `Other2_Revenue` | Numeric | nullable |
|
2722 | | `Probability` | Numeric | nullable |
|
2723 | | `Product_Cost` | Numeric | nullable |
|
2724 | | `Product_Revenue` | Numeric | nullable |
|
2725 | | `Rating` | Text | nullable |
|
2726 | | `Referral_Flag` | Numeric | |
|
2727 | | `Sales_Rep1` | Text | nullable |
|
2728 | | `Sales_Rep1_FullName` | Text | nullable |
|
2729 | | `Sales_Rep2` | Text | nullable |
|
2730 | | `Sales_Rep2_FullName` | Text | nullable |
|
2731 | | `Sales_Stage` | Text | nullable |
|
2732 | | `Service_Cost` | Numeric | nullable |
|
2733 | | `Service_Revenue` | Numeric | nullable |
|
2734 | | `Status` | Text | nullable |
|
2735 | | `Status_RecID` | Numeric | |
|
2736 | | `Time_Zone` | Text | nullable |
|
2737 | | `Total_Cost` | Numeric | nullable |
|
2738 | | `Total_Revenue` | Numeric | nullable |
|
2739 | | `Universal_Formatted_Date_Update` | Text | nullable |
|
2740 | | `Updated_By` | Text | nullable |
|
2741 | | `billing_unit_recid` | Numeric | nullable |
|
2742 | | `marketing` | Text | nullable |
|
2743 | | `owner_level_recid` | Numeric | nullable |
|
2744 | | `so_Type` | Text | nullable |
|
2745 | | `so_type_recid` | Numeric | nullable |
|
2746 |
|
2747 | #### OpportunityCustomFields
|
2748 | | | | |
|
2749 | |-------------|-------------|-----|
|
2750 | | `Last_Update` | DateTime | |
|
2751 | | `Opportunity_Name` | Text | nullable |
|
2752 | | `Opportunity_RecID` | Numeric | |
|
2753 | | `Time_Zone` | Text | nullable |
|
2754 | | `Updated_By` | Text | |
|
2755 | | `User_Defined_Field_RecID` | Numeric | |
|
2756 | | `customfield_podID` | Text | |
|
2757 | | `opportunity_customfield` | Text | |
|
2758 | | `opportunity_customvalue` | Text | nullable |
|
2759 | | `opportunity_fieldtype` | Text | nullable |
|
2760 |
|
2761 | #### OpportunityInterest
|
2762 | | | | |
|
2763 | |-------------|-------------|-----|
|
2764 | | `Last_Update` | DateTime | |
|
2765 | | `Last_Update_UTC` | DateTime | |
|
2766 | | `SO_Interest_Desc` | Text | nullable |
|
2767 | | `SO_Interest_RecID` | Numeric | |
|
2768 | | `Sort_Order` | Numeric | nullable |
|
2769 | | `Time_Zone` | Text | nullable |
|
2770 | | `Updated_By` | Text | nullable |
|
2771 |
|
2772 | #### OpportunityNote
|
2773 | | | | |
|
2774 | |-------------|-------------|-----|
|
2775 | | `Entered_By` | Text | nullable |
|
2776 | | `Last_Update` | DateTime | nullable |
|
2777 | | `Note_Type_RecID` | Numeric | nullable |
|
2778 | | `Notes` | Text | nullable |
|
2779 | | `Opportunity_RecID` | Numeric | nullable |
|
2780 | | `SO_Flag` | Boolean | |
|
2781 | | `SO_Notes_RecID` | Numeric | |
|
2782 | | `Seq_Nbr` | Numeric | nullable |
|
2783 | | `Time_Zone` | Text | nullable |
|
2784 | | `Updated_By` | Text | nullable |
|
2785 |
|
2786 | #### OpportunityPipeline
|
2787 | | | | |
|
2788 | |-------------|-------------|-----|
|
2789 | | `Last_Update` | DateTime | |
|
2790 | | `Last_Update_UTC` | DateTime | |
|
2791 | | `SO_Pipeline_Desc` | Text | nullable |
|
2792 | | `SO_Pipeline_RecID` | Numeric | |
|
2793 | | `SO_Probability_RecID` | Numeric | nullable |
|
2794 | | `Seq_Nbr` | Numeric | nullable |
|
2795 | | `Time_Zone` | Text | nullable |
|
2796 | | `Updated_By` | Text | nullable |
|
2797 |
|
2798 | #### OpportunityProbability
|
2799 | | | | |
|
2800 | |-------------|-------------|-----|
|
2801 | | `Last_Update` | DateTime | |
|
2802 | | `Last_Update_UTC` | DateTime | |
|
2803 | | `Probability` | Numeric | nullable |
|
2804 | | `SO_Probability_RecID` | Numeric | |
|
2805 | | `Time_Zone` | Text | nullable |
|
2806 | | `Updated_By` | Text | nullable |
|
2807 |
|
2808 | #### OpportunitySalesRole
|
2809 | | | | |
|
2810 | |-------------|-------------|-----|
|
2811 | | `Description` | Text | nullable |
|
2812 | | `Last_Update` | DateTime | nullable |
|
2813 | | `SO_Role_RecID` | Numeric | |
|
2814 | | `Time_Zone` | Text | nullable |
|
2815 | | `Updated_By` | Text | nullable |
|
2816 |
|
2817 | #### OpportunityStatus
|
2818 | | | | |
|
2819 | |-------------|-------------|-----|
|
2820 | | `Closed_Flag` | Boolean | |
|
2821 | | `Date_Entered_UTC` | DateTime | |
|
2822 | | `Default_Flag` | Boolean | |
|
2823 | | `Entered_By` | Text | |
|
2824 | | `Inactive_Flag` | Boolean | |
|
2825 | | `Last_Update` | DateTime | |
|
2826 | | `Last_Update_UTC` | DateTime | |
|
2827 | | `Lost_Flag` | Boolean | |
|
2828 | | `SO_Opp_Status_Desc` | Text | nullable |
|
2829 | | `SO_Opp_Status_RecID` | Numeric | |
|
2830 | | `Time_Zone` | Text | nullable |
|
2831 | | `Updated_By` | Text | nullable |
|
2832 | | `Won_Flag` | Boolean | |
|
2833 |
|
2834 | #### OpportunityType
|
2835 | | | | |
|
2836 | |-------------|-------------|-----|
|
2837 | | `Inactive_Flag` | Boolean | |
|
2838 | | `Last_Update` | DateTime | nullable |
|
2839 | | `Last_Update_UTC` | DateTime | |
|
2840 | | `SO_Type_Desc` | Text | nullable |
|
2841 | | `SO_Type_RecID` | Numeric | |
|
2842 | | `Time_Zone` | Text | nullable |
|
2843 | | `Update_By` | Text | nullable |
|
2844 |
|
2845 | #### OpportunityUrgency
|
2846 | | | | |
|
2847 | |-------------|-------------|-----|
|
2848 | | `Default_Flag` | Boolean | |
|
2849 | | `SO_Urgency_Desc` | Text | |
|
2850 | | `SO_Urgency_RecID` | Numeric | |
|
2851 | | `Sort_Order` | Numeric | nullable |
|
2852 |
|
2853 | #### Opportunity_Restricted
|
2854 | | | | |
|
2855 | |-------------|-------------|-----|
|
2856 | | `Agreement_Cost` | Numeric | nullable |
|
2857 | | `Agreement_Revenue` | Numeric | nullable |
|
2858 | | `Agreement_Type` | Text | nullable |
|
2859 | | `BusGroup` | Text | nullable |
|
2860 | | `Closed_By` | Text | nullable |
|
2861 | | `Closed_Flag` | Boolean | |
|
2862 | | `Closed_Status` | Text | |
|
2863 | | `CompanyRecId` | Numeric | nullable |
|
2864 | | `Company_Name` | Text | nullable |
|
2865 | | `Company_RecID` | Numeric | nullable |
|
2866 | | `Contact_Name` | Text | nullable |
|
2867 | | `Contact_RecID` | Numeric | nullable |
|
2868 | | `CustomerPO` | Text | nullable |
|
2869 | | `Date_Became_Lead` | DateTime | nullable |
|
2870 | | `Date_Closed` | DateTime | nullable |
|
2871 | | `Date_Update` | DateTime | nullable |
|
2872 | | `Entered_By` | Text | nullable |
|
2873 | | `Expected_Close_Date` | DateTime | nullable |
|
2874 | | `Forecast` | Text | |
|
2875 | | `Influencer_Contact_RecID` | Numeric | nullable |
|
2876 | | `Last_Update` | DateTime | nullable |
|
2877 | | `Last_Update_UTC` | DateTime | |
|
2878 | | `Location` | Text | nullable |
|
2879 | | `Lost_Revenue` | Numeric | |
|
2880 | | `Opportunity_Desc` | Text | nullable |
|
2881 | | `Opportunity_Name` | Text | nullable |
|
2882 | | `Opportunity_RecID` | Numeric | |
|
2883 | | `Other1_Cost` | Numeric | nullable |
|
2884 | | `Other1_Revenue` | Numeric | nullable |
|
2885 | | `Other2_Cost` | Numeric | nullable |
|
2886 | | `Other2_Revenue` | Numeric | nullable |
|
2887 | | `Probability` | Numeric | nullable |
|
2888 | | `Product_Cost` | Numeric | nullable |
|
2889 | | `Product_Revenue` | Numeric | nullable |
|
2890 | | `Rating` | Text | nullable |
|
2891 | | `Referral_Flag` | Numeric | |
|
2892 | | `Sales_Rep1` | Text | nullable |
|
2893 | | `Sales_Rep1_FullName` | Text | nullable |
|
2894 | | `Sales_Rep2` | Text | nullable |
|
2895 | | `Sales_Rep2_FullName` | Text | nullable |
|
2896 | | `Sales_Stage` | Text | nullable |
|
2897 | | `Service_Cost` | Numeric | nullable |
|
2898 | | `Service_Revenue` | Numeric | nullable |
|
2899 | | `Status` | Text | nullable |
|
2900 | | `Status_RecID` | Numeric | |
|
2901 | | `Time_Zone` | Text | nullable |
|
2902 | | `Total_Cost` | Numeric | nullable |
|
2903 | | `Total_Revenue` | Numeric | nullable |
|
2904 | | `Universal_Formatted_Date_Update` | Text | nullable |
|
2905 | | `Updated_By` | Text | nullable |
|
2906 | | `billing_unit_recid` | Numeric | nullable |
|
2907 | | `marketing` | Text | nullable |
|
2908 | | `owner_level_recid` | Numeric | nullable |
|
2909 | | `so_Type` | Text | nullable |
|
2910 | | `so_type_recid` | Numeric | nullable |
|
2911 |
|
2912 | #### OwnerLevel
|
2913 | | | | |
|
2914 | |-------------|-------------|-----|
|
2915 | | `Last_Update` | DateTime | |
|
2916 | | `Last_Update_UTC` | DateTime | |
|
2917 | | `Location` | Text | nullable |
|
2918 | | `Location_Flag` | Boolean | nullable |
|
2919 | | `Member_ID` | Text | nullable |
|
2920 | | `Notify_Flag` | Boolean | |
|
2921 | | `OL_Address_Line1` | Text | nullable |
|
2922 | | `OL_Address_Line2` | Text | nullable |
|
2923 | | `OL_City` | Text | nullable |
|
2924 | | `OL_Country_RecID` | Numeric | nullable |
|
2925 | | `OL_PhoneNbr` | Text | nullable |
|
2926 | | `OL_Phonenbr_Fax` | Text | nullable |
|
2927 | | `OL_State_ID` | Text | nullable |
|
2928 | | `OL_Zip` | Text | nullable |
|
2929 | | `OWA_Link` | Text | nullable |
|
2930 | | `Office_Calendar_RecID` | Numeric | nullable |
|
2931 | | `Owner_Level_ID` | Numeric | |
|
2932 | | `Owner_Level_RecID` | Numeric | |
|
2933 | | `Reports_To_RecID` | Numeric | nullable |
|
2934 | | `SalesRep_ID` | Text | nullable |
|
2935 | | `Sales_Territory_Flag` | Boolean | |
|
2936 | | `Time_Zone` | Text | nullable |
|
2937 | | `Updated_By` | Text | nullable |
|
2938 | | `Xref_ID` | Text | nullable |
|
2939 | | `client_flag` | Boolean | |
|
2940 | | `time_zone_recid` | Numeric | nullable |
|
2941 |
|
2942 | #### OwnershipType
|
2943 | | | | |
|
2944 | |-------------|-------------|-----|
|
2945 | | `Description` | Text | nullable |
|
2946 | | `Last_Update` | DateTime | nullable |
|
2947 | | `Ownership_Type_RecID` | Numeric | |
|
2948 | | `Time_Zone` | Text | nullable |
|
2949 | | `Updated_By` | Text | nullable |
|
2950 |
|
2951 | #### PhaseStatus
|
2952 | | | | |
|
2953 | |-------------|-------------|-----|
|
2954 | | `Closed_Flag` | Boolean | |
|
2955 | | `Default_Flag` | Boolean | |
|
2956 | | `Description` | Text | |
|
2957 | | `Inactive_Flag` | Boolean | |
|
2958 | | `Last_Update_UTC` | DateTime | |
|
2959 | | `Phase_Status_RecID` | Numeric | |
|
2960 | | `Updated_By` | Text | |
|
2961 |
|
2962 | #### Pod
|
2963 | | | | |
|
2964 | |-------------|-------------|-----|
|
2965 | | `Last_Update_UTC` | DateTime | |
|
2966 | | `Locale_Key_RecID` | Numeric | nullable |
|
2967 | | `PodID` | Text | |
|
2968 | | `Pod_RecID` | Numeric | |
|
2969 | | `ScreenID` | Text | |
|
2970 | | `Updated_By` | Text | |
|
2971 |
|
2972 | #### PortalAgrType
|
2973 | | | | |
|
2974 | |-------------|-------------|-----|
|
2975 | | `AGR_Inactive_Flag` | Boolean | nullable |
|
2976 | | `AGR_Type_Desc` | Text | nullable |
|
2977 | | `AGR_Type_RecID` | Numeric | |
|
2978 | | `BU_Restrict_Flag` | Boolean | nullable |
|
2979 | | `Billing_Unit_RecID` | Numeric | nullable |
|
2980 | | `BusGroup` | Text | nullable |
|
2981 | | `Last_Update` | DateTime | |
|
2982 | | `OL_Restrict_Flag` | Boolean | nullable |
|
2983 | | `Owner_Level_RecID` | Numeric | nullable |
|
2984 | | `Portal_Config_RecID` | Numeric | nullable |
|
2985 | | `Time_Zone` | Text | nullable |
|
2986 | | `Updated_By` | Text | nullable |
|
2987 | | `location` | Text | nullable |
|
2988 |
|
2989 | #### PortalConfigNames
|
2990 | | | | |
|
2991 | |-------------|-------------|-----|
|
2992 | | `Company_Name` | Text | nullable |
|
2993 | | `Company_RecID` | Numeric | nullable |
|
2994 | | `Default_Flag` | Boolean | |
|
2995 | | `Last_Update` | DateTime | |
|
2996 | | `Portal_Name` | Text | nullable |
|
2997 | | `Time_Zone` | Text | nullable |
|
2998 | | `Updated_By` | Text | nullable |
|
2999 |
|
3000 | #### PortalConfigServiceBoards
|
3001 | | | | |
|
3002 | |-------------|-------------|-----|
|
3003 | | `Board_Name` | Text | nullable |
|
3004 | | `Portal_Config_RecID` | Numeric | |
|
3005 | | `Portal_Name` | Text | nullable |
|
3006 | | `SR_Board_RecID` | Numeric | |
|
3007 |
|
3008 | #### PortalInvoices
|
3009 | | | | |
|
3010 | |-------------|-------------|-----|
|
3011 | | `AGR_Header_RecID` | Numeric | |
|
3012 | | `Agreement_Name` | Text | nullable |
|
3013 | | `Balance` | Numeric | nullable |
|
3014 | | `Billing_Log_RecID` | Numeric | |
|
3015 | | `Billing_Status_RecID` | Numeric | nullable |
|
3016 | | `Billing_Terms_RecID` | Numeric | nullable |
|
3017 | | `Billing_Type_ID` | Text | nullable |
|
3018 | | `Closed_Flag` | Boolean | nullable |
|
3019 | | `CompanyAccountNumber` | Text | nullable |
|
3020 | | `CompanyFinanceStatus` | Text | nullable |
|
3021 | | `CompanyRecId` | Numeric | nullable |
|
3022 | | `Company_ID` | Text | nullable |
|
3023 | | `Company_Name` | Text | nullable |
|
3024 | | `Company_RecID` | Numeric | nullable |
|
3025 | | `Credit_Amount` | Numeric | nullable |
|
3026 | | `CurrencySymbol` | Text | nullable |
|
3027 | | `Date_Closed` | DateTime | nullable |
|
3028 | | `Date_Created` | DateTime | nullable |
|
3029 | | `Date_Invoice` | DateTime | nullable |
|
3030 | | `Date_Paid` | DateTime | nullable |
|
3031 | | `Due_Date` | DateTime | nullable |
|
3032 | | `Invoice_Amount` | Numeric | |
|
3033 | | `Invoice_Number` | Text | nullable |
|
3034 | | `Invoice_Type` | Text | |
|
3035 | | `Last_Update` | DateTime | nullable |
|
3036 | | `Owner_Level_RecID` | Numeric | nullable |
|
3037 | | `PM_Project_RecID` | Numeric | |
|
3038 | | `Paid_Amount` | Numeric | nullable |
|
3039 | | `Processing_Flag` | Boolean | |
|
3040 | | `Project_ID` | Text | nullable |
|
3041 | | `Remit_To_RecID` | Numeric | nullable |
|
3042 | | `Status_Description` | Text | nullable |
|
3043 | | `TicketNbr` | Numeric | |
|
3044 | | `Ticket_Summary` | Text | nullable |
|
3045 | | `Time_Zone` | Text | nullable |
|
3046 | | `Universal_Formatted_Date_Invoice` | Text | nullable |
|
3047 | | `Universal_Formatted_Date_Paid` | Text | nullable |
|
3048 | | `Universal_Formatted_Due_Date` | Text | nullable |
|
3049 | | `Universal_Formatted_Due_Date_Text` | Text | nullable |
|
3050 | | `Updated_By` | Text | nullable |
|
3051 |
|
3052 | #### PortalProject
|
3053 | | | | |
|
3054 | |-------------|-------------|-----|
|
3055 | | `BillingMethod_Desc` | Text | nullable |
|
3056 | | `Closed_Flag` | Boolean | |
|
3057 | | `CompanyRecId` | Numeric | |
|
3058 | | `Contact_FirstName` | Text | nullable |
|
3059 | | `Contact_LastName` | Text | nullable |
|
3060 | | `Date_Closed` | DateTime | nullable |
|
3061 | | `Date_Closed_UTC` | DateTime | nullable |
|
3062 | | `Description` | Text | nullable |
|
3063 | | `EstimatedEnd` | DateTime | nullable |
|
3064 | | `EstimatedStart` | DateTime | nullable |
|
3065 | | `Last_Update` | DateTime | nullable |
|
3066 | | `Last_Update_UTC` | DateTime | |
|
3067 | | `Owner_Level_RecID` | Numeric | |
|
3068 | | `PM_Billing_Method_ID` | Text | nullable |
|
3069 | | `ProjectManager_FirstName` | Text | nullable |
|
3070 | | `ProjectManager_LastName` | Text | nullable |
|
3071 | | `ProjectName` | Text | nullable |
|
3072 | | `ProjectNbr` | Numeric | |
|
3073 | | `ProjectType_Desc` | Text | nullable |
|
3074 | | `SR_Board_RecID` | Numeric | |
|
3075 | | `Status_Desc` | Text | nullable |
|
3076 | | `Time_Zone` | Text | nullable |
|
3077 | | `Universal_Formatted_Date_Closed` | Numeric | nullable |
|
3078 | | `Universal_Formatted_Date_Required` | Text | nullable |
|
3079 | | `Universal_Formatted_Date_Start` | Text | nullable |
|
3080 | | `Universal_Formatted_Last_Update` | Text | nullable |
|
3081 | | `Updated_By` | Text | nullable |
|
3082 |
|
3083 | #### PortalSecurity
|
3084 | | | | |
|
3085 | |-------------|-------------|-----|
|
3086 | | `Function_Description` | Text | nullable |
|
3087 | | `Function_Id` | Text | nullable |
|
3088 | | `Last_Update` | DateTime | nullable |
|
3089 | | `Level1` | Boolean | nullable |
|
3090 | | `Level2` | Boolean | nullable |
|
3091 | | `Level3` | Boolean | nullable |
|
3092 | | `Level4` | Boolean | nullable |
|
3093 | | `Level5` | Boolean | nullable |
|
3094 | | `Level6` | Boolean | nullable |
|
3095 | | `Portal_Security_RecID` | Numeric | |
|
3096 | | `Time_Zone` | Text | nullable |
|
3097 | | `Updated_By` | Text | nullable |
|
3098 |
|
3099 | #### PortalSecurityCaptions
|
3100 | | | | |
|
3101 | |-------------|-------------|-----|
|
3102 | | `Caption` | Text | nullable |
|
3103 | | `Last_Update` | DateTime | nullable |
|
3104 | | `Security_Level` | Numeric | nullable |
|
3105 | | `Time_Zone` | Text | nullable |
|
3106 | | `Updated_By` | Text | nullable |
|
3107 |
|
3108 | #### PortalService
|
3109 | | | | |
|
3110 | |-------------|-------------|-----|
|
3111 | | `AGR_Header_RecID` | Numeric | nullable |
|
3112 | | `Address_Line1` | Text | |
|
3113 | | `Address_Line2` | Text | |
|
3114 | | `Approved_Flag` | Boolean | |
|
3115 | | `Board_Name` | Text | nullable |
|
3116 | | `City` | Text | |
|
3117 | | `ClosedDesc` | Text | |
|
3118 | | `Closed_Flag` | Boolean | |
|
3119 | | `Country` | Text | |
|
3120 | | `Date_Entered_UTC` | DateTime | nullable |
|
3121 | | `Date_Req` | DateTime | nullable |
|
3122 | | `Date_Required` | DateTime | nullable |
|
3123 | | `Detail_Description` | Text | |
|
3124 | | `Hours_Actual` | Numeric | nullable |
|
3125 | | `Hours_Budget` | Numeric | nullable |
|
3126 | | `Internal_Analysis` | Text | |
|
3127 | | `IsMerged` | Numeric | |
|
3128 | | `Last_Update` | DateTime | nullable |
|
3129 | | `Last_Update_UTC` | DateTime | nullable |
|
3130 | | `Location` | Text | nullable |
|
3131 | | `PostalCode` | Text | |
|
3132 | | `Publish_Flag` | Boolean | |
|
3133 | | `Rec_Type` | Text | |
|
3134 | | `Resolution` | Text | |
|
3135 | | `SR_Board_RecID` | Numeric | |
|
3136 | | `ServiceSubType` | Text | nullable |
|
3137 | | `ServiceSubTypeItem` | Text | nullable |
|
3138 | | `ServiceType` | Text | nullable |
|
3139 | | `Site` | Text | nullable |
|
3140 | | `Site_Name` | Text | nullable |
|
3141 | | `Sla_Name` | Text | nullable |
|
3142 | | `Source` | Text | nullable |
|
3143 | | `State` | Text | |
|
3144 | | `Status_SortOrder` | Numeric | nullable |
|
3145 | | `SubTypeItem_RecID` | Numeric | nullable |
|
3146 | | `SubType_RecID` | Numeric | nullable |
|
3147 | | `Summary` | Text | nullable |
|
3148 | | `Territory` | Text | nullable |
|
3149 | | `Territory_Manager` | Text | nullable |
|
3150 | | `TicketNbr` | Numeric | |
|
3151 | | `Time_Zone` | Text | nullable |
|
3152 | | `Type_RecID` | Numeric | nullable |
|
3153 | | `Universal_Formatted_Date_Entered` | Text | nullable |
|
3154 | | `Universal_Formatted_Date_Required` | Text | nullable |
|
3155 | | `Universal_Formatted_Last_Update` | Text | nullable |
|
3156 | | `Updated_By` | Text | nullable |
|
3157 | | `Urgency` | Text | nullable |
|
3158 | | `Urgency_Sort_Order` | Numeric | nullable |
|
3159 | | `billing_unit_recid` | Numeric | nullable |
|
3160 | | `closed_by` | Text | nullable |
|
3161 | | `company_name` | Text | nullable |
|
3162 | | `company_recid` | Numeric | nullable |
|
3163 | | `contact_name` | Text | nullable |
|
3164 | | `contact_recid` | Numeric | |
|
3165 | | `date_closed` | DateTime | nullable |
|
3166 | | `date_entered` | DateTime | nullable |
|
3167 | | `entered_by` | Text | nullable |
|
3168 | | `owner_level_recid` | Numeric | nullable |
|
3169 | | `resource_list` | Text | |
|
3170 | | `service_location` | Text | nullable |
|
3171 | | `sr_status_recid` | Numeric | |
|
3172 | | `status_description` | Text | nullable |
|
3173 | | `territory_recid` | Numeric | nullable |
|
3174 |
|
3175 | #### PortalTicketTypeDescription
|
3176 | | | | |
|
3177 | |-------------|-------------|-----|
|
3178 | | `Board_Name` | Text | nullable |
|
3179 | | `PortalTicketType_Desc` | Text | |
|
3180 | | `Portal_Config_RecID` | Numeric | nullable |
|
3181 | | `SR_Board_RecID` | Numeric | |
|
3182 |
|
3183 | #### PortalTicketTypes
|
3184 | | | | |
|
3185 | |-------------|-------------|-----|
|
3186 | | `CompanyID` | Text | nullable |
|
3187 | | `CompanyRecID` | Numeric | nullable |
|
3188 | | `Default_Flag` | Boolean | |
|
3189 | | `Last_Update` | DateTime | nullable |
|
3190 | | `Last_Update_UTC` | DateTime | |
|
3191 | | `Owner_Level_RecID` | Numeric | nullable |
|
3192 | | `PortalTicketType_Desc` | Text | |
|
3193 | | `Portal_Config_RecID` | Numeric | nullable |
|
3194 | | `Problem` | Text | |
|
3195 | | `Summary` | Text | |
|
3196 | | `Time_Zone` | Text | nullable |
|
3197 | | `Updated_By` | Text | |
|
3198 | | `recid` | Numeric | |
|
3199 |
|
3200 | #### PriceHeader
|
3201 | | | | |
|
3202 | |-------------|-------------|-----|
|
3203 | | `IV_Price_Header_RecID` | Numeric | |
|
3204 | | `Inactive_Flag` | Boolean | nullable |
|
3205 | | `Last_Update` | DateTime | |
|
3206 | | `Location` | Text | nullable |
|
3207 | | `Owner_Level_RecID` | Numeric | nullable |
|
3208 | | `Price_Schedule_Name` | Text | nullable |
|
3209 | | `Time_Zone` | Text | nullable |
|
3210 | | `Updated_By` | Text | nullable |
|
3211 |
|
3212 | #### PricingSchedule
|
3213 | | | | |
|
3214 | |-------------|-------------|-----|
|
3215 | | `Amount` | Numeric | nullable |
|
3216 | | `Category_Inactive_Flag` | Boolean | nullable |
|
3217 | | `Company_ID` | Text | nullable |
|
3218 | | `Company_Name` | Text | nullable |
|
3219 | | `Company_RecID` | Numeric | nullable |
|
3220 | | `Date_End` | DateTime | nullable |
|
3221 | | `Date_Start` | DateTime | nullable |
|
3222 | | `Default_Flag` | Boolean | nullable |
|
3223 | | `IV_Cat_RecID` | Numeric | nullable |
|
3224 | | `IV_Category_Description` | Text | nullable |
|
3225 | | `IV_Category_RecID` | Numeric | nullable |
|
3226 | | `IV_Item_Description` | Text | nullable |
|
3227 | | `IV_Item_RecID` | Numeric | nullable |
|
3228 | | `IV_Price_Break_RecID` | Numeric | nullable |
|
3229 | | `IV_Price_Detail_RecID` | Numeric | |
|
3230 | | `IV_Price_Header_RecID` | Numeric | |
|
3231 | | `IV_Price_Method_ID` | Text | nullable |
|
3232 | | `IV_SubCat_RecID` | Numeric | nullable |
|
3233 | | `IV_Type_RecID` | Numeric | nullable |
|
3234 | | `Inactive_Flag` | Boolean | nullable |
|
3235 | | `Item_ID` | Text | nullable |
|
3236 | | `Last_Update` | DateTime | nullable |
|
3237 | | `Owner_Level_RecID` | Numeric | nullable |
|
3238 | | `Price_Schedule_Name` | Text | nullable |
|
3239 | | `Quanity_Price_Break` | Boolean | |
|
3240 | | `Quantity_End` | Numeric | nullable |
|
3241 | | `Quantity_Start` | Numeric | nullable |
|
3242 | | `SubCat_Description` | Text | nullable |
|
3243 | | `SubCat_Inactive_Flag` | Boolean | nullable |
|
3244 | | `Time_Zone` | Text | nullable |
|
3245 | | `Updated_By` | Text | nullable |
|
3246 |
|
3247 | #### Product
|
3248 | | | | |
|
3249 | |-------------|-------------|-----|
|
3250 | | `AGR_Detail_RecID` | Numeric | nullable |
|
3251 | | `AgrAmtCovered` | Numeric | |
|
3252 | | `Agreement` | Text | nullable |
|
3253 | | `Billable_Amt` | Numeric | nullable |
|
3254 | | `BusGroup` | Text | nullable |
|
3255 | | `Date_Entered` | DateTime | nullable |
|
3256 | | `Extended_Cost` | Numeric | nullable |
|
3257 | | `Extended_Price_Amount` | Numeric | nullable |
|
3258 | | `IV_Class_ID` | Text | nullable |
|
3259 | | `IsParent` | Numeric | |
|
3260 | | `IsPhaseProduct` | Boolean | |
|
3261 | | `Last_Update` | DateTime | |
|
3262 | | `Line_Desc` | Text | nullable |
|
3263 | | `Location` | Text | nullable |
|
3264 | | `Manufacturer_RecID` | Numeric | nullable |
|
3265 | | `NonBillable_Amt` | Numeric | nullable |
|
3266 | | `Opportunity_RecID` | Numeric | nullable |
|
3267 | | `Quantity` | Numeric | nullable |
|
3268 | | `Quantity_Picked` | Numeric | |
|
3269 | | `Quantity_Picked_Extended_Cost` | Numeric | nullable |
|
3270 | | `Quantity_Shipped` | Numeric | |
|
3271 | | `Quantity_Shipped_Extended_Cost` | Numeric | nullable |
|
3272 | | `Sub_Number` | Numeric | |
|
3273 | | `Time_Zone` | Text | nullable |
|
3274 | | `Updated_By` | Text | nullable |
|
3275 | | `billable_flag` | Boolean | |
|
3276 | | `billing_log_recid` | Numeric | nullable |
|
3277 | | `charge_to` | Text | nullable |
|
3278 | | `company_name` | Text | nullable |
|
3279 | | `company_recid` | Numeric | nullable |
|
3280 | | `date_invoice` | DateTime | nullable |
|
3281 | | `invoice_flag` | Boolean | |
|
3282 | | `invoice_number` | Text | nullable |
|
3283 | | `item_category` | Text | nullable |
|
3284 | | `item_desc` | Text | nullable |
|
3285 | | `item_id` | Text | nullable |
|
3286 | | `item_subcategory` | Text | nullable |
|
3287 | | `iv_item_recid` | Numeric | |
|
3288 | | `iv_product_RecID` | Numeric | |
|
3289 | | `option_id` | Text | nullable |
|
3290 | | `owner_level_recid` | Numeric | |
|
3291 | | `parent_recid` | Numeric | nullable |
|
3292 | | `pm_project_recid` | Numeric | nullable |
|
3293 | | `project_name` | Text | nullable |
|
3294 | | `serial_number` | Text | nullable |
|
3295 | | `sr_service_recid` | Numeric | nullable |
|
3296 | | `sr_status` | Text | nullable |
|
3297 | | `sr_summary` | Text | nullable |
|
3298 | | `te_status_id` | Numeric | nullable |
|
3299 | | `territory` | Text | nullable |
|
3300 | | `time_status` | Text | nullable |
|
3301 | | `unit_cost` | Numeric | nullable |
|
3302 | | `unit_price` | Numeric | nullable |
|
3303 | | `uom` | Text | nullable |
|
3304 |
|
3305 | #### ProductDetail
|
3306 | | | | |
|
3307 | |-------------|-------------|-----|
|
3308 | | `Date_Picked` | DateTime | nullable |
|
3309 | | `Date_Shipped` | DateTime | nullable |
|
3310 | | `IV_Product_Description` | Text | nullable |
|
3311 | | `IV_Product_Detail_RecID` | Numeric | |
|
3312 | | `IV_Product_RecID` | Numeric | |
|
3313 | | `Last_Update` | DateTime | |
|
3314 | | `Line_Number` | Numeric | |
|
3315 | | `Picked_By` | Text | nullable |
|
3316 | | `Picked_Flag` | Numeric | |
|
3317 | | `Quantity` | Numeric | |
|
3318 | | `Quantity_Picked` | Numeric | |
|
3319 | | `Quantity_Shipped` | Numeric | |
|
3320 | | `Serial_Number` | Text | nullable |
|
3321 | | `Shipped_By` | Text | nullable |
|
3322 | | `Shipped_Flag` | Numeric | |
|
3323 | | `Time_Zone` | Text | nullable |
|
3324 | | `Tracking_Number` | Text | nullable |
|
3325 | | `Updated_By` | Text | |
|
3326 |
|
3327 | #### ProductEntityType
|
3328 | | | | |
|
3329 | |-------------|-------------|-----|
|
3330 | | `Customer_Usage_Type_Code` | Text | |
|
3331 | | `Customer_Usage_Type_RecID` | Numeric | |
|
3332 | | `Description` | Text | |
|
3333 |
|
3334 | #### Project
|
3335 | | | | |
|
3336 | |-------------|-------------|-----|
|
3337 | | `AGR_Header_RecID` | Numeric | nullable |
|
3338 | | `Address_Line1` | Text | |
|
3339 | | `Address_Line2` | Text | |
|
3340 | | `Age` | Numeric | nullable |
|
3341 | | `Board_Name` | Text | nullable |
|
3342 | | `BusGroup` | Text | nullable |
|
3343 | | `City` | Text | |
|
3344 | | `ClosedDesc` | Text | |
|
3345 | | `Closed_Flag` | Boolean | nullable |
|
3346 | | `Date_Required` | DateTime | nullable |
|
3347 | | `Detail_Description` | Text | nullable |
|
3348 | | `Hours_Actual` | Numeric | nullable |
|
3349 | | `Hours_Agreement` | Numeric | nullable |
|
3350 | | `Hours_Billable` | Numeric | nullable |
|
3351 | | `Hours_Invoiced` | Numeric | nullable |
|
3352 | | `Hours_NonBillable` | Numeric | nullable |
|
3353 | | `Hours_Remaining` | Numeric | nullable |
|
3354 | | `Hours_Scheduled` | Numeric | nullable |
|
3355 | | `Internal_Analysis` | Text | nullable |
|
3356 | | `Last_Update` | DateTime | |
|
3357 | | `Last_Update_UTC` | DateTime | |
|
3358 | | `Location` | Text | nullable |
|
3359 | | `PM_Billing_Method_ID` | Text | nullable |
|
3360 | | `PM_Billing_Method_RecID` | Numeric | nullable |
|
3361 | | `PM_Phase_RecID` | Numeric | nullable |
|
3362 | | `PM_Project_RecID` | Numeric | |
|
3363 | | `Parent` | Text | |
|
3364 | | `Percent_Complete_PerTicket` | Numeric | nullable |
|
3365 | | `Phase` | Text | nullable |
|
3366 | | `PhaseStatus` | Text | nullable |
|
3367 | | `PhaseWbsCode` | Text | nullable |
|
3368 | | `PhaseWbsSequence` | Numeric | nullable |
|
3369 | | `PostalCode` | Text | |
|
3370 | | `Priority` | Text | nullable |
|
3371 | | `ProjectBillingMethod` | Text | nullable |
|
3372 | | `ProjectCloseDate` | Numeric | nullable |
|
3373 | | `ProjectCloseDateUTC` | DateTime | nullable |
|
3374 | | `ProjectEndDate` | DateTime | nullable |
|
3375 | | `ProjectManager` | Text | nullable |
|
3376 | | `ProjectManagerMemberID` | Text | nullable |
|
3377 | | `ProjectManagerRecID` | Numeric | nullable |
|
3378 | | `ProjectName` | Text | nullable |
|
3379 | | `ProjectNbr` | Numeric | |
|
3380 | | `ProjectStartDate` | DateTime | nullable |
|
3381 | | `ProjectStatus` | Text | nullable |
|
3382 | | `ProjectType` | Text | nullable |
|
3383 | | `Rec_Type` | Text | nullable |
|
3384 | | `Resolution` | Text | nullable |
|
3385 | | `Resource_List` | Text | nullable |
|
3386 | | `SR_Board_RecID` | Numeric | nullable |
|
3387 | | `SR_Service_RecID` | Numeric | nullable |
|
3388 | | `SR_Type_RecID` | Numeric | nullable |
|
3389 | | `ServiceSubType` | Text | nullable |
|
3390 | | `ServiceSubTypeItem` | Text | nullable |
|
3391 | | `ServiceType` | Text | |
|
3392 | | `State` | Text | |
|
3393 | | `Status_Description` | Text | nullable |
|
3394 | | `Status_SortOrder` | Numeric | nullable |
|
3395 | | `SubTypeItem_RecID` | Numeric | nullable |
|
3396 | | `SubType_RecID` | Numeric | nullable |
|
3397 | | `Summary` | Text | nullable |
|
3398 | | `Territory` | Text | nullable |
|
3399 | | `Territory_Manager` | Text | nullable |
|
3400 | | `Territory_Recid` | Numeric | nullable |
|
3401 | | `TicketNbr` | Numeric | nullable |
|
3402 | | `TicketWbsSequence` | Numeric | nullable |
|
3403 | | `Time_Zone` | Text | nullable |
|
3404 | | `Type_RecID` | Numeric | nullable |
|
3405 | | `Updated_By` | Text | nullable |
|
3406 | | `agreement_name` | Text | |
|
3407 | | `billing_unit_recid` | Numeric | nullable |
|
3408 | | `closed_by` | Text | nullable |
|
3409 | | `company_name` | Text | nullable |
|
3410 | | `company_recid` | Numeric | |
|
3411 | | `contact_name` | Text | nullable |
|
3412 | | `date_closed` | DateTime | nullable |
|
3413 | | `date_entered` | DateTime | nullable |
|
3414 | | `entered_by` | Text | nullable |
|
3415 | | `hours_budget` | Numeric | nullable |
|
3416 | | `owner_level_recid` | Numeric | nullable |
|
3417 | | `service_location` | Text | nullable |
|
3418 | | `sr_status_recid` | Numeric | nullable |
|
3419 | | `team_name` | Text | |
|
3420 | | `wbs_code` | Text | nullable |
|
3421 |
|
3422 | #### Project2
|
3423 | | | | |
|
3424 | |-------------|-------------|-----|
|
3425 | | `AGR_Header_RecID` | Numeric | nullable |
|
3426 | | `Address_Line1` | Text | |
|
3427 | | `Address_Line2` | Text | |
|
3428 | | `Age` | Numeric | nullable |
|
3429 | | `Board_Name` | Text | nullable |
|
3430 | | `BusGroup` | Text | nullable |
|
3431 | | `City` | Text | |
|
3432 | | `ClosedDesc` | Text | |
|
3433 | | `Closed_Flag` | Boolean | nullable |
|
3434 | | `Date_Required` | DateTime | nullable |
|
3435 | | `Detail_Description` | Text | nullable |
|
3436 | | `Hours_Actual` | Numeric | nullable |
|
3437 | | `Hours_Agreement` | Numeric | nullable |
|
3438 | | `Hours_Billable` | Numeric | nullable |
|
3439 | | `Hours_Invoiced` | Numeric | nullable |
|
3440 | | `Hours_NonBillable` | Numeric | nullable |
|
3441 | | `Hours_Remaining` | Numeric | nullable |
|
3442 | | `Hours_Scheduled` | Numeric | nullable |
|
3443 | | `Internal_Analysis` | Text | nullable |
|
3444 | | `Last_Update` | DateTime | nullable |
|
3445 | | `Last_Update_UTC` | DateTime | |
|
3446 | | `Location` | Text | nullable |
|
3447 | | `PM_Billing_Method_ID` | Text | nullable |
|
3448 | | `PM_Billing_Method_RecID` | Numeric | nullable |
|
3449 | | `PM_Phase_RecID` | Numeric | nullable |
|
3450 | | `PM_Project_RecID` | Numeric | |
|
3451 | | `Parent` | Text | |
|
3452 | | `Percent_Complete_PerTicket` | Numeric | nullable |
|
3453 | | `Phase` | Text | nullable |
|
3454 | | `PhaseStatus` | Text | nullable |
|
3455 | | `PhaseWbsCode` | Text | nullable |
|
3456 | | `PhaseWbsSequence` | Numeric | nullable |
|
3457 | | `PostalCode` | Text | |
|
3458 | | `Priority` | Text | nullable |
|
3459 | | `ProjectBillingMethod` | Text | nullable |
|
3460 | | `ProjectCloseDate` | DateTime | nullable |
|
3461 | | `ProjectCloseDateUTC` | DateTime | nullable |
|
3462 | | `ProjectEndDate` | DateTime | nullable |
|
3463 | | `ProjectManager` | Text | nullable |
|
3464 | | `ProjectManagerMemberID` | Text | nullable |
|
3465 | | `ProjectManagerRecID` | Numeric | nullable |
|
3466 | | `ProjectName` | Text | nullable |
|
3467 | | `ProjectNbr` | Numeric | |
|
3468 | | `ProjectStartDate` | DateTime | nullable |
|
3469 | | `ProjectStatus` | Text | nullable |
|
3470 | | `ProjectType` | Text | nullable |
|
3471 | | `Rec_Type` | Text | nullable |
|
3472 | | `Resolution` | Text | nullable |
|
3473 | | `Resource_List` | Text | nullable |
|
3474 | | `SR_Board_RecID` | Numeric | nullable |
|
3475 | | `SR_Service_RecID` | Numeric | nullable |
|
3476 | | `SR_Type_RecID` | Numeric | nullable |
|
3477 | | `ServiceSubType` | Text | nullable |
|
3478 | | `ServiceSubTypeItem` | Text | nullable |
|
3479 | | `ServiceType` | Text | |
|
3480 | | `State` | Text | |
|
3481 | | `Status_Description` | Text | nullable |
|
3482 | | `Status_SortOrder` | Numeric | nullable |
|
3483 | | `SubTypeItem_RecID` | Numeric | nullable |
|
3484 | | `SubType_RecID` | Numeric | nullable |
|
3485 | | `Summary` | Text | nullable |
|
3486 | | `Territory` | Text | nullable |
|
3487 | | `Territory_Manager` | Text | nullable |
|
3488 | | `Territory_Recid` | Numeric | nullable |
|
3489 | | `TicketNbr` | Numeric | nullable |
|
3490 | | `TicketWbsSequence` | Numeric | nullable |
|
3491 | | `Time_Zone` | Text | nullable |
|
3492 | | `Type_RecID` | Numeric | nullable |
|
3493 | | `Updated_By` | Text | nullable |
|
3494 | | `agreement_name` | Text | |
|
3495 | | `billing_unit_recid` | Numeric | nullable |
|
3496 | | `closed_by` | Text | nullable |
|
3497 | | `company_name` | Text | nullable |
|
3498 | | `company_recid` | Numeric | |
|
3499 | | `contact_name` | Text | nullable |
|
3500 | | `date_closed` | DateTime | nullable |
|
3501 | | `date_entered` | DateTime | nullable |
|
3502 | | `entered_by` | Text | nullable |
|
3503 | | `hours_budget` | Numeric | nullable |
|
3504 | | `owner_level_recid` | Numeric | nullable |
|
3505 | | `service_location` | Text | nullable |
|
3506 | | `sr_status_recid` | Numeric | nullable |
|
3507 | | `team_name` | Text | |
|
3508 | | `wbs_code` | Text | nullable |
|
3509 |
|
3510 | #### ProjectAudit
|
3511 | | | | |
|
3512 | |-------------|-------------|-----|
|
3513 | | `Audit_Source` | Text | nullable |
|
3514 | | `Audit_Text` | Text | nullable |
|
3515 | | `Audit_Type` | Text | nullable |
|
3516 | | `Audit_Type_RecId` | Numeric | |
|
3517 | | `Is_System_Update` | Boolean | nullable |
|
3518 | | `Last_Updated_utc` | DateTime | |
|
3519 | | `PM_Project_RecID` | Numeric | |
|
3520 | | `member_recid` | Numeric | nullable |
|
3521 |
|
3522 | #### ProjectBillingMethods
|
3523 | | | | |
|
3524 | |-------------|-------------|-----|
|
3525 | | `BillingMethod_Desc` | Text | nullable |
|
3526 | | `Default_Flag` | Boolean | |
|
3527 | | `Override_Flag` | Boolean | |
|
3528 | | `PM_Billing_Method_ID` | Text | |
|
3529 | | `PM_Billing_Method_RecID` | Numeric | |
|
3530 |
|
3531 | #### ProjectBoard
|
3532 | | | | |
|
3533 | |-------------|-------------|-----|
|
3534 | | `BillableExpenseInvoice` | Boolean | nullable |
|
3535 | | `BillableProductInvoice` | Boolean | nullable |
|
3536 | | `BillableTimeInvoice` | Boolean | nullable |
|
3537 | | `Inactive` | Boolean | nullable |
|
3538 | | `Last_Update` | DateTime | |
|
3539 | | `Last_Update_UTC` | DateTime | |
|
3540 | | `ProjectBoardName` | Text | nullable |
|
3541 | | `ProjectBoardRecId` | Numeric | |
|
3542 | | `Time_Zone` | Text | nullable |
|
3543 | | `Updated_By` | Text | nullable |
|
3544 |
|
3545 | #### ProjectContact
|
3546 | | | | |
|
3547 | |-------------|-------------|-----|
|
3548 | | `Contact_RecID` | Numeric | nullable |
|
3549 | | `Last_Update` | DateTime | nullable |
|
3550 | | `PM_Contact_RecID` | Numeric | |
|
3551 | | `PM_Project_RecID` | Numeric | nullable |
|
3552 | | `PM_Role_RecID` | Numeric | nullable |
|
3553 | | `Time_Zone` | Text | nullable |
|
3554 | | `Updated_By` | Text | nullable |
|
3555 |
|
3556 | #### ProjectCustomFields
|
3557 | | | | |
|
3558 | |-------------|-------------|-----|
|
3559 | | `Last_Update_UTC` | DateTime | |
|
3560 | | `PM_Project_RecID` | Numeric | |
|
3561 | | `Pod_RecID` | Numeric | |
|
3562 | | `Project_ID` | Text | nullable |
|
3563 | | `Updated_By` | Text | |
|
3564 | | `User_Defined_Field_RecID` | Numeric | |
|
3565 | | `User_Defined_Field_Value` | Text | |
|
3566 | | `customfield_podID` | Text | |
|
3567 | | `project_customfield` | Text | |
|
3568 | | `project_fieldtype` | Text | nullable |
|
3569 |
|
3570 | #### ProjectHeader
|
3571 | | | | |
|
3572 | |-------------|-------------|-----|
|
3573 | | `AGR_Header_RecID` | Numeric | nullable |
|
3574 | | `Agreement_Name` | Text | nullable |
|
3575 | | `Billing_Unit_RecID` | Numeric | |
|
3576 | | `Board_Name` | Text | nullable |
|
3577 | | `BusGroup` | Text | nullable |
|
3578 | | `Closed_By` | Text | nullable |
|
3579 | | `Closed_Flag` | Boolean | |
|
3580 | | `Company_Address_RecID` | Numeric | nullable |
|
3581 | | `Company_Name` | Text | nullable |
|
3582 | | `Company_RecID` | Numeric | |
|
3583 | | `Contact_First_Name` | Text | nullable |
|
3584 | | `Contact_Full_Name` | Text | |
|
3585 | | `Contact_Last_Name` | Text | nullable |
|
3586 | | `Contact_RecID` | Numeric | nullable |
|
3587 | | `Created_By` | Text | |
|
3588 | | `Date_Closed_UTC` | DateTime | nullable |
|
3589 | | `Date_Entered_UTC` | DateTime | |
|
3590 | | `Est_Days_Remaining` | Numeric | nullable |
|
3591 | | `Estimated_End_Date` | DateTime | nullable |
|
3592 | | `Estimated_Start_Date` | DateTime | nullable |
|
3593 | | `Hours_Actual` | Numeric | nullable |
|
3594 | | `Hours_Agreement` | Numeric | nullable |
|
3595 | | `Hours_Budget` | Numeric | nullable |
|
3596 | | `Hours_Budget_Remaining` | Numeric | nullable |
|
3597 | | `Hours_Invoiced` | Numeric | nullable |
|
3598 | | `Hours_NonBillable` | Numeric | nullable |
|
3599 | | `Hours_Scheduled` | Numeric | nullable |
|
3600 | | `Hours_billable` | Numeric | nullable |
|
3601 | | `Last_Update_UTC` | DateTime | |
|
3602 | | `Location` | Text | nullable |
|
3603 | | `Notes` | Text | nullable |
|
3604 | | `Owner_ID` | Numeric | nullable |
|
3605 | | `Owner_Level_RecID` | Numeric | |
|
3606 | | `PM_Project_RecID` | Numeric | |
|
3607 | | `PM_Status_RecID` | Numeric | |
|
3608 | | `PM_Type_RecID` | Numeric | nullable |
|
3609 | | `Percent_Complete` | Numeric | nullable |
|
3610 | | `Project_Manager` | Text | nullable |
|
3611 | | `Project_Name` | Text | nullable |
|
3612 | | `Project_Status` | Text | nullable |
|
3613 | | `Project_Type` | Text | nullable |
|
3614 | | `SR_Board_RecID` | Numeric | |
|
3615 | | `Updated_By` | Text | nullable |
|
3616 |
|
3617 | #### ProjectNote
|
3618 | | | | |
|
3619 | |-------------|-------------|-----|
|
3620 | | `Entered_By` | Text | nullable |
|
3621 | | `Last_Update` | DateTime | nullable |
|
3622 | | `Note_Type_RecID` | Numeric | nullable |
|
3623 | | `Notes` | Text | nullable |
|
3624 | | `PM_Note_RecID` | Numeric | |
|
3625 | | `PM_Project_RecID` | Numeric | nullable |
|
3626 | | `Red_Flag` | Boolean | |
|
3627 | | `Time_Zone` | Text | nullable |
|
3628 | | `Updated_By` | Text | nullable |
|
3629 |
|
3630 | #### ProjectRole
|
3631 | | | | |
|
3632 | |-------------|-------------|-----|
|
3633 | | `Last_Update` | DateTime | nullable |
|
3634 | | `Manager_Flag` | Boolean | |
|
3635 | | `PM_Role_ID` | Text | nullable |
|
3636 | | `PM_Role_RecID` | Numeric | |
|
3637 | | `Time_Zone` | Text | nullable |
|
3638 | | `Updated_By` | Boolean | |
|
3639 |
|
3640 | #### ProjectStatus
|
3641 | | | | |
|
3642 | |-------------|-------------|-----|
|
3643 | | `Last_Update` | DateTime | nullable |
|
3644 | | `Last_Update_UTC` | DateTime | |
|
3645 | | `ProjectName` | Text | nullable |
|
3646 | | `ProjectRecId` | Numeric | |
|
3647 | | `StatusName` | Text | nullable |
|
3648 | | `StatusRecId` | Numeric | |
|
3649 | | `Time_Zone` | Text | nullable |
|
3650 | | `Updated_By` | Text | nullable |
|
3651 |
|
3652 | #### ProjectStatuses
|
3653 | | | | |
|
3654 | |-------------|-------------|-----|
|
3655 | | `Closed_Flag` | Boolean | |
|
3656 | | `Default_flag` | Boolean | |
|
3657 | | `Inactive_Flag` | Boolean | |
|
3658 | | `Last_Update` | DateTime | nullable |
|
3659 | | `No_Time_Flag` | Boolean | |
|
3660 | | `PM_Status_RecID` | Numeric | |
|
3661 | | `ProjectStatus_Desc` | Text | nullable |
|
3662 | | `Time_Zone` | Text | nullable |
|
3663 | | `Updated_By` | Text | nullable |
|
3664 |
|
3665 | #### ProjectTeamMember
|
3666 | | | | |
|
3667 | |-------------|-------------|-----|
|
3668 | | `Activity_Class_RecID` | Numeric | nullable |
|
3669 | | `Date_Est_End` | DateTime | nullable |
|
3670 | | `Date_Est_Start` | DateTime | nullable |
|
3671 | | `Hours_Est` | Numeric | nullable |
|
3672 | | `Last_Update` | DateTime | nullable |
|
3673 | | `Member_ID` | Text | nullable |
|
3674 | | `PM_Project_RecID` | Numeric | nullable |
|
3675 | | `PM_Role_RecID` | Numeric | nullable |
|
3676 | | `PM_Team_RecID` | Numeric | |
|
3677 | | `RecID` | Numeric | nullable |
|
3678 | | `Team_Flag` | Boolean | |
|
3679 | | `Time_Zone` | Text | nullable |
|
3680 | | `Updated_By` | Text | nullable |
|
3681 |
|
3682 | #### ProjectTemplate
|
3683 | | | | |
|
3684 | |-------------|-------------|-----|
|
3685 | | `Last_Update` | DateTime | nullable |
|
3686 | | `Notes` | Text | nullable |
|
3687 | | `PM_Tmp_Project_RecID` | Numeric | |
|
3688 | | `PM_Type_RecID` | Numeric | nullable |
|
3689 | | `Template_Name` | Text | nullable |
|
3690 | | `Time_Zone` | Text | nullable |
|
3691 | | `Updated_By` | Text | nullable |
|
3692 |
|
3693 | #### ProjectTypes
|
3694 | | | | |
|
3695 | |-------------|-------------|-----|
|
3696 | | `Default_Flag` | Boolean | |
|
3697 | | `Inactive_Flag` | Boolean | |
|
3698 | | `Last_Update` | DateTime | |
|
3699 | | `PM_Type_RecID` | Numeric | |
|
3700 | | `ProjectType_Desc` | Text | nullable |
|
3701 | | `Time_Zone` | Text | nullable |
|
3702 | | `Updated_By` | Text | nullable |
|
3703 |
|
3704 | #### PurchaseOrder
|
3705 | | | | |
|
3706 | |-------------|-------------|-----|
|
3707 | | `Bill_To_Address_Line1` | Text | nullable |
|
3708 | | `Bill_To_Address_Line2` | Text | nullable |
|
3709 | | `Bill_To_City` | Text | nullable |
|
3710 | | `Bill_To_Company_Name` | Text | nullable |
|
3711 | | `Bill_To_Country` | Text | nullable |
|
3712 | | `Bill_To_PhoneNbr` | Text | nullable |
|
3713 | | `Bill_To_State` | Text | nullable |
|
3714 | | `Bill_To_Zip` | Text | nullable |
|
3715 | | `Billing_Terms_RecID` | Numeric | nullable |
|
3716 | | `Billing_Unit_RecID` | Numeric | nullable |
|
3717 | | `Billint_Terms_Description` | Text | nullable |
|
3718 | | `Closed_Flag` | Boolean | nullable |
|
3719 | | `Customer_Address_Line1` | Text | nullable |
|
3720 | | `Customer_Address_Line2` | Text | nullable |
|
3721 | | `Customer_Address_RecID` | Numeric | nullable |
|
3722 | | `Customer_City` | Text | nullable |
|
3723 | | `Customer_Company_Name` | Text | nullable |
|
3724 | | `Customer_Company_RecID` | Numeric | nullable |
|
3725 | | `Customer_Contact_Extension` | Text | nullable |
|
3726 | | `Customer_Contact_First_Name` | Text | |
|
3727 | | `Customer_Contact_Full_Name` | Text | |
|
3728 | | `Customer_Contact_Last_Name` | Text | |
|
3729 | | `Customer_Contact_PhoneNbr` | Text | nullable |
|
3730 | | `Customer_Contact_RecID` | Numeric | nullable |
|
3731 | | `Customer_Country` | Text | nullable |
|
3732 | | `Customer_Site_Name` | Text | nullable |
|
3733 | | `Customer_State` | Text | nullable |
|
3734 | | `Customer_Zip` | Text | nullable |
|
3735 | | `Entered_By` | Text | nullable |
|
3736 | | `Freight_Cost` | Numeric | nullable |
|
3737 | | `Freight_Packing_Slip` | Text | nullable |
|
3738 | | `Internal_Notes` | Text | nullable |
|
3739 | | `Last_Update` | DateTime | |
|
3740 | | `Owner_Level_RecID` | Numeric | nullable |
|
3741 | | `PO_Number` | Text | nullable |
|
3742 | | `Purchase_Date` | DateTime | nullable |
|
3743 | | `Purchase_Order_RecID` | Numeric | |
|
3744 | | `ShipMethodDescription` | Text | nullable |
|
3745 | | `Ship_Date` | DateTime | nullable |
|
3746 | | `ShipmentMethod_RecID` | Numeric | nullable |
|
3747 | | `Shipping_Instructions` | Text | nullable |
|
3748 | | `TimeZone` | Text | nullable |
|
3749 | | `Total` | Numeric | nullable |
|
3750 | | `Tracking_Number` | Text | nullable |
|
3751 | | `Updated_By` | Text | nullable |
|
3752 | | `Vendor_Address_Line1` | Text | nullable |
|
3753 | | `Vendor_Address_Line2` | Text | nullable |
|
3754 | | `Vendor_Address_RecID` | Numeric | nullable |
|
3755 | | `Vendor_City` | Text | nullable |
|
3756 | | `Vendor_Company_Name` | Text | nullable |
|
3757 | | `Vendor_Company_RecID` | Numeric | |
|
3758 | | `Vendor_Contact_First_Name` | Text | |
|
3759 | | `Vendor_Contact_Full_Name` | Text | |
|
3760 | | `Vendor_Contact_Last_Name` | Text | |
|
3761 | | `Vendor_Contact_RecID` | Numeric | nullable |
|
3762 | | `Vendor_Country` | Text | nullable |
|
3763 | | `Vendor_Invoice_Date` | DateTime | nullable |
|
3764 | | `Vendor_Invoice_Number` | Text | nullable |
|
3765 | | `Vendor_Order_Number` | Text | nullable |
|
3766 | | `Vendor_PhoneNbr` | Text | nullable |
|
3767 | | `Vendor_Site_Name` | Text | nullable |
|
3768 | | `Vendor_State` | Text | nullable |
|
3769 | | `Vendor_Zip` | Text | nullable |
|
3770 |
|
3771 | #### PurchaseOrderStatuses
|
3772 | | | | |
|
3773 | |-------------|-------------|-----|
|
3774 | | `Closed_Flag` | Boolean | nullable |
|
3775 | | `Default_Closed_Flag` | Boolean | |
|
3776 | | `Default_Flag` | Boolean | nullable |
|
3777 | | `Description` | Text | nullable |
|
3778 | | `Inactive_Flag` | Boolean | nullable |
|
3779 | | `Last_Update` | DateTime | nullable |
|
3780 | | `PO_Status_RecID` | Numeric | |
|
3781 | | `Sort_Order` | Numeric | nullable |
|
3782 | | `Time_Zone` | Text | nullable |
|
3783 | | `Updated_By` | Text | nullable |
|
3784 |
|
3785 | #### PurchaseOrderWithLineItems
|
3786 | | | | |
|
3787 | |-------------|-------------|-----|
|
3788 | | `Backorder_Flag` | Boolean | |
|
3789 | | `Date_Received` | DateTime | nullable |
|
3790 | | `Description` | Text | nullable |
|
3791 | | `Expected_Ship_Date` | DateTime | nullable |
|
3792 | | `IV_Item_RecID` | Numeric | |
|
3793 | | `IV_Product_RecID` | Numeric | nullable |
|
3794 | | `Item_ID` | Text | nullable |
|
3795 | | `Last_Update` | DateTime | |
|
3796 | | `Line_Number` | Numeric | nullable |
|
3797 | | `PO_Number` | Text | nullable |
|
3798 | | `Purchase_Detail_RecID` | Numeric | |
|
3799 | | `Purchase_Header_RecID` | Numeric | |
|
3800 | | `Quantity` | Numeric | nullable |
|
3801 | | `Received` | Boolean | |
|
3802 | | `Received_Qty` | Numeric | nullable |
|
3803 | | `Serialized_Flag` | Boolean | nullable |
|
3804 | | `Time_Zone` | Text | nullable |
|
3805 | | `Updated_By` | Text | nullable |
|
3806 | | `Vendor_SKU` | Text | nullable |
|
3807 | | `itemunitcost` | Numeric | nullable |
|
3808 | | `itemuom` | Text | nullable |
|
3809 | | `received_status` | Text | |
|
3810 | | `shipmethoddescription` | Text | nullable |
|
3811 | | `tracking_number` | Text | nullable |
|
3812 | | `tracking_url` | Text | nullable |
|
3813 |
|
3814 | #### RMATag
|
3815 | | | | |
|
3816 | |-------------|-------------|-----|
|
3817 | | `Last_Update` | DateTime | |
|
3818 | | `Product_Description` | Text | |
|
3819 | | `RMA_Tag_RecID` | Numeric | |
|
3820 | | `Time_Zone` | Text | nullable |
|
3821 | | `Updated_By` | Text | nullable |
|
3822 |
|
3823 | #### Release
|
3824 | | | | |
|
3825 | |-------------|-------------|-----|
|
3826 | | `Company_Name` | Text | nullable |
|
3827 | | `Company_RecID` | Numeric | |
|
3828 | | `Eligible` | Boolean | nullable |
|
3829 | | `Market` | Text | nullable |
|
3830 | | `MarketID` | Numeric | nullable |
|
3831 | | `Territory` | Text | nullable |
|
3832 | | `TerritoryID` | Numeric | nullable |
|
3833 | | `Type` | Text | nullable |
|
3834 | | `TypeID` | Numeric | nullable |
|
3835 |
|
3836 | #### ReleaseManager_Filters
|
3837 | | | | |
|
3838 | |-------------|-------------|-----|
|
3839 | | `Description` | Text | nullable |
|
3840 | | `FilterName` | Text | |
|
3841 | | `ID` | Numeric | |
|
3842 |
|
3843 | #### ReminderMinutes
|
3844 | | | | |
|
3845 | |-------------|-------------|-----|
|
3846 | | `Default_Flag` | Boolean | nullable |
|
3847 | | `Last_Update` | DateTime | |
|
3848 | | `Last_Update_UTC` | DateTime | |
|
3849 | | `ReminderDescription` | Text | nullable |
|
3850 | | `ReminderTimeId` | Numeric | |
|
3851 | | `Reminder_Time` | Numeric | nullable |
|
3852 | | `Time_Zone` | Text | nullable |
|
3853 | | `Updated_By` | Text | nullable |
|
3854 |
|
3855 | #### SICCode
|
3856 | | | | |
|
3857 | |-------------|-------------|-----|
|
3858 | | `Description` | Text | nullable |
|
3859 | | `SIC_Category` | Text | nullable |
|
3860 | | `SIC_Code_ID` | Text | |
|
3861 | | `SIC_Code_RecID` | Numeric | |
|
3862 |
|
3863 | #### SLA
|
3864 | | | | |
|
3865 | |-------------|-------------|-----|
|
3866 | | `Application_Order` | Numeric | nullable |
|
3867 | | `Default_Flag` | Boolean | nullable |
|
3868 | | `Description` | Text | nullable |
|
3869 | | `Hours_Type_ID` | Text | nullable |
|
3870 | | `Last_Update` | DateTime | |
|
3871 | | `Last_Update_UTC` | DateTime | |
|
3872 | | `Office_Calendar_RecId` | Numeric | nullable |
|
3873 | | `ResPlan_Hours` | Numeric | nullable |
|
3874 | | `ResPlan_Pct` | Numeric | nullable |
|
3875 | | `Resolution_Hours` | Numeric | nullable |
|
3876 | | `Resolution_Pct` | Numeric | nullable |
|
3877 | | `Responded_Hours` | Numeric | nullable |
|
3878 | | `Responded_Pct` | Numeric | nullable |
|
3879 | | `SLA_Name` | Text | nullable |
|
3880 | | `SR_SLA_RecID` | Numeric | |
|
3881 | | `Time_Zone` | Text | nullable |
|
3882 | | `Updated_By` | Text | nullable |
|
3883 |
|
3884 | #### SLAPriority
|
3885 | | | | |
|
3886 | |-------------|-------------|-----|
|
3887 | | `Last_Update` | DateTime | |
|
3888 | | `ResPlan_Hours` | Numeric | nullable |
|
3889 | | `ResPlan_Pct` | Numeric | nullable |
|
3890 | | `Resolution_Hours` | Numeric | nullable |
|
3891 | | `Resolution_Pct` | Numeric | nullable |
|
3892 | | `Responded_Hours` | Numeric | nullable |
|
3893 | | `Responded_Pct` | Numeric | nullable |
|
3894 | | `SR_SLA_RecID` | Numeric | |
|
3895 | | `SR_Urgency_RecID` | Numeric | |
|
3896 | | `Time_Zone` | Text | nullable |
|
3897 | | `Updated_By` | Text | nullable |
|
3898 |
|
3899 | #### SalesOrder
|
3900 | | | | |
|
3901 | |-------------|-------------|-----|
|
3902 | | `Company_Address_RecID` | Numeric | nullable |
|
3903 | | `Company_RecID` | Numeric | nullable |
|
3904 | | `Contact_Recid` | Numeric | nullable |
|
3905 | | `Description` | Text | nullable |
|
3906 | | `Order_Date` | DateTime | nullable |
|
3907 | | `Order_Due_Date` | DateTime | nullable |
|
3908 | | `Order_Header_RecID` | Numeric | |
|
3909 | | `Order_Status_RecID` | Numeric | nullable |
|
3910 | | `Total` | Numeric | nullable |
|
3911 |
|
3912 | #### SalesOrderCustomFields
|
3913 | | | | |
|
3914 | |-------------|-------------|-----|
|
3915 | | `Last_Update_UTC` | DateTime | |
|
3916 | | `Order_Header_RecID` | Numeric | |
|
3917 | | `Pod_RecID` | Numeric | |
|
3918 | | `Purchase_Order_Number` | Text | nullable |
|
3919 | | `Updated_By` | Text | |
|
3920 | | `User_Defined_Field_RecID` | Numeric | |
|
3921 | | `User_Defined_Field_Value` | Text | |
|
3922 | | `customfield_podID` | Text | |
|
3923 | | `sales_order_customfield` | Text | |
|
3924 | | `sales_order_fieldtype` | Text | nullable |
|
3925 |
|
3926 | #### SalesOrderStatus
|
3927 | | | | |
|
3928 | |-------------|-------------|-----|
|
3929 | | `Closed_Flag` | Boolean | nullable |
|
3930 | | `Default_Flag` | Boolean | nullable |
|
3931 | | `Description` | Text | nullable |
|
3932 | | `Inactive_Flag` | Boolean | nullable |
|
3933 | | `Last_Update` | DateTime | nullable |
|
3934 | | `Order_Status_RecID` | Numeric | |
|
3935 | | `Sort_Order` | Numeric | nullable |
|
3936 | | `Updated_By` | Text | nullable |
|
3937 |
|
3938 | #### Sales_Team
|
3939 | | | | |
|
3940 | |-------------|-------------|-----|
|
3941 | | `Inactive_Flag` | Boolean | |
|
3942 | | `Last_Update` | DateTime | |
|
3943 | | `Last_Update_UTC` | DateTime | |
|
3944 | | `Member_ID` | Text | nullable |
|
3945 | | `Member_RecID` | Numeric | nullable |
|
3946 | | `Owner_Level_recid` | Numeric | nullable |
|
3947 | | `Sales_Team_ID` | Text | |
|
3948 | | `Sales_Team_Member_RecID` | Numeric | nullable |
|
3949 | | `Sales_Team_RecID` | Numeric | |
|
3950 | | `Time_Zone` | Text | nullable |
|
3951 | | `Updated_By` | Text | nullable |
|
3952 |
|
3953 | #### Schedule
|
3954 | | | | |
|
3955 | |-------------|-------------|-----|
|
3956 | | `Ack_Date` | DateTime | nullable |
|
3957 | | `Ack_Flag` | Boolean | nullable |
|
3958 | | `Ack_Member_RecID` | Numeric | nullable |
|
3959 | | `All_Day_Flag` | Boolean | |
|
3960 | | `Close_Date` | DateTime | nullable |
|
3961 | | `Close_Member_RecID` | Numeric | nullable |
|
3962 | | `Date_Entered` | DateTime | nullable |
|
3963 | | `Date_Time_End` | DateTime | nullable |
|
3964 | | `Date_Time_End_UTC` | DateTime | nullable |
|
3965 | | `Date_Time_Start` | DateTime | nullable |
|
3966 | | `Date_Time_Start_UTC` | DateTime | nullable |
|
3967 | | `Display_Color` | Text | nullable |
|
3968 | | `Duration` | Numeric | nullable |
|
3969 | | `Entered_By_RecID` | Numeric | nullable |
|
3970 | | `Exchange_GUID` | Text | nullable |
|
3971 | | `Hours_Estimated` | Numeric | nullable |
|
3972 | | `Hours_Per_Day` | Numeric | nullable |
|
3973 | | `Hours_Sched` | Numeric | nullable |
|
3974 | | `Last_Sync` | DateTime | nullable |
|
3975 | | `Last_Update` | DateTime | nullable |
|
3976 | | `Location_Desc` | Text | nullable |
|
3977 | | `Member_ID` | Text | nullable |
|
3978 | | `Percent_Sched` | Numeric | nullable |
|
3979 | | `Priority` | Numeric | nullable |
|
3980 | | `RecID` | Numeric | nullable |
|
3981 | | `Reminder_Flag` | Boolean | |
|
3982 | | `Reminder_Minutes` | Numeric | nullable |
|
3983 | | `Reminder_Time_Desc` | Text | nullable |
|
3984 | | `SR_Impact_Name` | Text | nullable |
|
3985 | | `SR_Service_RecID` | Numeric | nullable |
|
3986 | | `SR_Severity_Name` | Text | nullable |
|
3987 | | `Schedule_Desc` | Text | nullable |
|
3988 | | `Schedule_RecID` | Numeric | |
|
3989 | | `Schedule_Status_RecID` | Numeric | nullable |
|
3990 | | `Schedule_Type_RecID` | Numeric | |
|
3991 | | `Syncable` | Boolean | |
|
3992 | | `System_Flag` | Boolean | nullable |
|
3993 | | `Table_Reference` | Text | nullable |
|
3994 | | `Time_Zone` | Text | nullable |
|
3995 | | `Updated_By` | Text | nullable |
|
3996 | | `Xref_Mbr_RecID` | Numeric | nullable |
|
3997 | | `close_flag` | Boolean | |
|
3998 |
|
3999 | #### ScheduleLocation
|
4000 | | | | |
|
4001 | |-------------|-------------|-----|
|
4002 | | `Default_Flag` | Boolean | |
|
4003 | | `Last_Update` | DateTime | |
|
4004 | | `LocationDescription` | Text | nullable |
|
4005 | | `LocationId` | Numeric | |
|
4006 | | `Time_Zone` | Text | nullable |
|
4007 | | `Updated_By` | Text | nullable |
|
4008 |
|
4009 | #### ScheduleSpan
|
4010 | | | | |
|
4011 | |-------------|-------------|-----|
|
4012 | | `SpanDescription` | Text | nullable |
|
4013 | | `SpanId` | Numeric | |
|
4014 | | `SpanIdentifier` | Text | |
|
4015 |
|
4016 | #### ScheduleStatus
|
4017 | | | | |
|
4018 | |-------------|-------------|-----|
|
4019 | | `Default_Flag` | Boolean | |
|
4020 | | `Last_Update` | DateTime | |
|
4021 | | `Last_Update_UTC` | DateTime | |
|
4022 | | `ScheduleStatusId` | Numeric | |
|
4023 | | `StatusDescription` | Text | nullable |
|
4024 | | `Time_Zone` | Text | nullable |
|
4025 | | `Updated_By` | Text | nullable |
|
4026 |
|
4027 | #### ScheduleType
|
4028 | | | | |
|
4029 | |-------------|-------------|-----|
|
4030 | | `Description` | Text | nullable |
|
4031 | | `Last_Update` | DateTime | |
|
4032 | | `Last_Update_UTC` | DateTime | |
|
4033 | | `SR_Location_RecID` | Numeric | nullable |
|
4034 | | `Schedule_Type_ID` | Text | nullable |
|
4035 | | `Schedule_Type_RecID` | Numeric | |
|
4036 | | `System_Flag` | Boolean | |
|
4037 | | `TE_Charge_Code_RecID` | Numeric | nullable |
|
4038 | | `Time_Zone` | Text | nullable |
|
4039 | | `Updated_By` | Text | nullable |
|
4040 |
|
4041 | #### ScreenConnectSession
|
4042 | | | | |
|
4043 | |-------------|-------------|-----|
|
4044 | | `Config_RecID` | Numeric | |
|
4045 | | `Member_RecID` | Numeric | |
|
4046 | | `SR_Service_RecID` | Numeric | |
|
4047 | | `ScreenConnect_Session_RecID` | Numeric | |
|
4048 | | `Session_GUID` | Text | |
|
4049 |
|
4050 | #### ScreenLinkTableReference
|
4051 | | | | |
|
4052 | |-------------|-------------|-----|
|
4053 | | `Screen_Link_Table_RecID` | Numeric | |
|
4054 | | `Table_Reference` | Text | |
|
4055 |
|
4056 | #### Service
|
4057 | | | | |
|
4058 | |-------------|-------------|-----|
|
4059 | | `AGR_Header_RecID` | Numeric | nullable |
|
4060 | | `Address_Line1` | Text | |
|
4061 | | `Address_Line2` | Text | |
|
4062 | | `Age` | Numeric | nullable |
|
4063 | | `Approved` | Boolean | |
|
4064 | | `Assigned_By_RecID` | Numeric | nullable |
|
4065 | | `Board_Name` | Text | nullable |
|
4066 | | `BusGroup` | Text | nullable |
|
4067 | | `City` | Text | |
|
4068 | | `ClosedDesc` | Text | |
|
4069 | | `Closed_Age` | Numeric | nullable |
|
4070 | | `Closed_Flag` | Boolean | nullable |
|
4071 | | `Country` | Text | nullable |
|
4072 | | `Date_Closed_UTC` | DateTime | nullable |
|
4073 | | `Date_Entered_UTC` | DateTime | nullable |
|
4074 | | `Date_Required` | DateTime | nullable |
|
4075 | | `Date_Resolved_UTC` | DateTime | nullable |
|
4076 | | `Date_Resplan_UTC` | DateTime | nullable |
|
4077 | | `Date_Responded_UTC` | DateTime | nullable |
|
4078 | | `Date_Status_Changed_UTC` | DateTime | nullable |
|
4079 | | `Detail_Description` | Text | nullable |
|
4080 | | `Escalation_Start_Date_UTC` | DateTime | nullable |
|
4081 | | `Est_Start_Date_UTC` | DateTime | nullable |
|
4082 | | `Hours_Actual` | Numeric | nullable |
|
4083 | | `Hours_Agreement` | Numeric | nullable |
|
4084 | | `Hours_Billable` | Numeric | nullable |
|
4085 | | `Hours_Budget` | Numeric | nullable |
|
4086 | | `Hours_Invoiced` | Numeric | nullable |
|
4087 | | `Hours_NonBillable` | Numeric | nullable |
|
4088 | | `Hours_Scheduled` | Numeric | nullable |
|
4089 | | `Impact` | Text | nullable |
|
4090 | | `Initial_Description` | Text | nullable |
|
4091 | | `Internal_Analysis` | Text | nullable |
|
4092 | | `Last_Update` | DateTime | nullable |
|
4093 | | `Location` | Text | nullable |
|
4094 | | `Minutes_Before_Waiting` | Numeric | nullable |
|
4095 | | `Minutes_Waiting` | Numeric | nullable |
|
4096 | | `Opportunity_RecID` | Numeric | nullable |
|
4097 | | `Overall_Start_Date_UTC` | DateTime | nullable |
|
4098 | | `PM_Phase_RecID` | Numeric | nullable |
|
4099 | | `Parent` | Text | nullable |
|
4100 | | `PostalCode` | Text | |
|
4101 | | `Previous_SR_Status_RecID` | Numeric | nullable |
|
4102 | | `Priority_Description` | Text | nullable |
|
4103 | | `Priority_Sort_Order` | Numeric | nullable |
|
4104 | | `Resolution` | Text | nullable |
|
4105 | | `Resolved_By` | Text | nullable |
|
4106 | | `Resolved_Minutes` | Numeric | nullable |
|
4107 | | `Resplan_Minutes` | Numeric | nullable |
|
4108 | | `Resplan_Skipped_Minutes` | Numeric | nullable |
|
4109 | | `Responded_By` | Text | nullable |
|
4110 | | `Responded_Minutes` | Numeric | nullable |
|
4111 | | `Responded_Skipped_Minutes` | Numeric | nullable |
|
4112 | | `SR_Billing_Method_ID` | Text | nullable |
|
4113 | | `SR_Billing_Method_RecID` | Numeric | nullable |
|
4114 | | `SR_Board_RecID` | Numeric | nullable |
|
4115 | | `SR_Impact_RecID` | Numeric | nullable |
|
4116 | | `SR_SLA_RecID` | Numeric | nullable |
|
4117 | | `SR_Service_RecID` | Numeric | |
|
4118 | | `SR_Severity_RecID` | Numeric | nullable |
|
4119 | | `SR_Urgency_RecID` | Numeric | nullable |
|
4120 | | `ServiceBillingMethod` | Text | nullable |
|
4121 | | `ServiceSubType` | Text | |
|
4122 | | `ServiceSubTypeItem` | Text | |
|
4123 | | `ServiceType` | Text | |
|
4124 | | `Severity` | Text | nullable |
|
4125 | | `Site_Name` | Text | nullable |
|
4126 | | `Source` | Text | nullable |
|
4127 | | `State` | Text | |
|
4128 | | `Status_SortOrder` | Numeric | nullable |
|
4129 | | `SubTypeItem_RecID` | Numeric | nullable |
|
4130 | | `SubType_RecID` | Numeric | nullable |
|
4131 | | `Summary` | Text | nullable |
|
4132 | | `Territory` | Text | nullable |
|
4133 | | `Territory_Manager` | Text | nullable |
|
4134 | | `TicketNbr` | Numeric | |
|
4135 | | `Ticket_Owner_First_Name` | Text | nullable |
|
4136 | | `Ticket_Owner_Last_Name` | Text | nullable |
|
4137 | | `Ticket_Owner_RecID` | Numeric | nullable |
|
4138 | | `Time_Zone` | Text | nullable |
|
4139 | | `Type_RecID` | Numeric | nullable |
|
4140 | | `Updated_By` | Text | nullable |
|
4141 | | `Urgency` | Text | nullable |
|
4142 | | `Waiting_Flag` | Boolean | nullable |
|
4143 | | `agreement_name` | Text | |
|
4144 | | `billing_unit_recid` | Numeric | nullable |
|
4145 | | `closed_by` | Text | nullable |
|
4146 | | `company_name` | Text | nullable |
|
4147 | | `company_recid` | Numeric | nullable |
|
4148 | | `config_recids` | Text | nullable |
|
4149 | | `contact_name` | Text | nullable |
|
4150 | | `contact_recid` | Numeric | |
|
4151 | | `date_closed` | DateTime | nullable |
|
4152 | | `date_entered` | DateTime | nullable |
|
4153 | | `entered_by` | Text | nullable |
|
4154 | | `owner_level_recid` | Numeric | nullable |
|
4155 | | `resource_list` | Text | nullable |
|
4156 | | `service_location` | Text | nullable |
|
4157 | | `sr_status_recid` | Numeric | |
|
4158 | | `status_description` | Text | nullable |
|
4159 | | `team_name` | Text | |
|
4160 | | `territory_recid` | Numeric | nullable |
|
4161 |
|
4162 | #### ServiceAudit
|
4163 | | | | |
|
4164 | |-------------|-------------|-----|
|
4165 | | `Audit_Source` | Text | nullable |
|
4166 | | `Audit_Text` | Text | nullable |
|
4167 | | `Email_Address` | Text | nullable |
|
4168 | | `Last_Update` | DateTime | nullable |
|
4169 | | `Last_Update_UTC` | DateTime | nullable |
|
4170 | | `SR_Audit_RecID` | Numeric | |
|
4171 | | `TicketNbr` | Numeric | |
|
4172 | | `Time_Zone` | Text | nullable |
|
4173 | | `Updated_By` | Text | nullable |
|
4174 |
|
4175 | #### ServiceBoard
|
4176 | | | | |
|
4177 | |-------------|-------------|-----|
|
4178 | | `Activity_Class_RecID` | Numeric | nullable |
|
4179 | | `Activity_Type_RecID` | Numeric | nullable |
|
4180 | | `AdditionsLockTime_Flag` | Boolean | nullable |
|
4181 | | `Board_Name` | Text | nullable |
|
4182 | | `BusGroup` | Text | nullable |
|
4183 | | `EmailContact_Flag` | Boolean | nullable |
|
4184 | | `EmailResource_Flag` | Boolean | nullable |
|
4185 | | `ExpBillable_Flag` | Boolean | nullable |
|
4186 | | `ExpInvoice_Flag` | Boolean | nullable |
|
4187 | | `Inactive_Flag` | Boolean | nullable |
|
4188 | | `InternalAnalysis_Sort` | Text | |
|
4189 | | `Last_Update` | DateTime | |
|
4190 | | `Last_Update_UTC` | DateTime | |
|
4191 | | `Location` | Text | nullable |
|
4192 | | `LockDesc_Flag` | Boolean | nullable |
|
4193 | | `Owner_Level_RecID` | Numeric | nullable |
|
4194 | | `Problem_Sort` | Text | |
|
4195 | | `ProdBillable_Flag` | Boolean | nullable |
|
4196 | | `ProdInvoice_Flag` | Boolean | nullable |
|
4197 | | `Project_Flag` | Boolean | |
|
4198 | | `Resolution_Sort` | Text | |
|
4199 | | `SR_Board_RecID` | Numeric | |
|
4200 | | `SR_InternalAnalysis_Flag` | Boolean | |
|
4201 | | `SR_Problem_Flag` | Boolean | nullable |
|
4202 | | `SR_Resolution_Flag` | Boolean | |
|
4203 | | `TE_InternalAnalysis_Flag` | Boolean | |
|
4204 | | `TE_Problem_Flag` | Boolean | |
|
4205 | | `TE_Resolution_Flag` | Boolean | |
|
4206 | | `TimeBillable_Flag` | Boolean | nullable |
|
4207 | | `TimeInvoice_Flag` | Boolean | nullable |
|
4208 | | `Time_Zone` | Text | nullable |
|
4209 | | `Updated_By` | Text | nullable |
|
4210 | | `billing_unit_recid` | Numeric | nullable |
|
4211 |
|
4212 | #### ServiceBoardMembers
|
4213 | | | | |
|
4214 | |-------------|-------------|-----|
|
4215 | | `Last_Update` | DateTime | |
|
4216 | | `Member_RecID` | Numeric | nullable |
|
4217 | | `SR_BoardMbr_RecID` | Numeric | |
|
4218 | | `SR_Board_RecID` | Numeric | nullable |
|
4219 | | `Time_Zone` | Text | nullable |
|
4220 | | `Updated_By` | Text | nullable |
|
4221 |
|
4222 | #### ServiceCode
|
4223 | | | | |
|
4224 | |-------------|-------------|-----|
|
4225 | | `Billing_Unit_RecID` | Numeric | nullable |
|
4226 | | `Last_Update` | DateTime | nullable |
|
4227 | | `Owner_Level_RecID` | Numeric | nullable |
|
4228 | | `SR_Board_RecID` | Numeric | nullable |
|
4229 | | `SR_Code_RecID` | Numeric | |
|
4230 | | `ServiceCodeDesc` | Text | nullable |
|
4231 | | `ServiceCodeName` | Text | nullable |
|
4232 | | `Time_Zone` | Text | nullable |
|
4233 | | `Updated_By` | Text | nullable |
|
4234 |
|
4235 | #### ServiceCustomFields
|
4236 | | | | |
|
4237 | |-------------|-------------|-----|
|
4238 | | `Last_Update_UTC` | DateTime | |
|
4239 | | `Pod_RecID` | Numeric | |
|
4240 | | `SR_Service_RecID` | Numeric | |
|
4241 | | `Summary` | Text | nullable |
|
4242 | | `Updated_By` | Text | |
|
4243 | | `User_Defined_Field_RecID` | Numeric | |
|
4244 | | `User_Defined_Field_Value` | Text | |
|
4245 | | `customfield_podID` | Text | |
|
4246 | | `service_customfield` | Text | |
|
4247 | | `service_fieldtype` | Text | nullable |
|
4248 |
|
4249 | #### ServiceItem
|
4250 | | | | |
|
4251 | |-------------|-------------|-----|
|
4252 | | `Billing_Unit_RecID` | Numeric | nullable |
|
4253 | | `Board_Name` | Text | nullable |
|
4254 | | `BusGroup` | Text | nullable |
|
4255 | | `Inactive_Flag` | Boolean | |
|
4256 | | `Last_Update` | DateTime | |
|
4257 | | `Last_Update_UTC` | DateTime | |
|
4258 | | `Location` | Text | nullable |
|
4259 | | `Owner_Level_RecID` | Numeric | nullable |
|
4260 | | `SR_Board_RecID` | Numeric | |
|
4261 | | `SR_SubTypeItem_RecID` | Numeric | |
|
4262 | | `SR_SubType_RecID` | Numeric | nullable |
|
4263 | | `SR_Type_RecID` | Numeric | nullable |
|
4264 | | `ServiceItemDesc` | Text | |
|
4265 | | `ServiceSubTypeDesc` | Text | nullable |
|
4266 | | `ServiceTypeDesc` | Text | nullable |
|
4267 | | `Time_Zone` | Text | nullable |
|
4268 | | `Updated_By` | Text | |
|
4269 |
|
4270 | #### ServiceKPICountByHour
|
4271 | | | | |
|
4272 | |-------------|-------------|-----|
|
4273 | | `Date_Entered_UTC` | DateTime | nullable |
|
4274 | | `Day_Entered_UTC` | DateTime | nullable |
|
4275 | | `Hour_Entered_UTC` | DateTime | nullable |
|
4276 | | `Hour_Nbr_UTC` | Numeric | nullable |
|
4277 | | `SR_Board_RecID` | Numeric | nullable |
|
4278 | | `TicketCount` | Numeric | nullable |
|
4279 |
|
4280 | #### ServiceLocation
|
4281 | | | | |
|
4282 | |-------------|-------------|-----|
|
4283 | | `Company_Address_RecID` | Numeric | |
|
4284 | | `Company_RecID` | Numeric | |
|
4285 | | `Inactive_Flag` | Boolean | nullable |
|
4286 | | `Last_Update` | DateTime | nullable |
|
4287 | | `Last_Update_UTC` | DateTime | |
|
4288 | | `ServiceLocation_Desc` | Text | nullable |
|
4289 | | `Time_Zone` | Text | nullable |
|
4290 | | `Updated_By` | Text | nullable |
|
4291 |
|
4292 | #### ServiceMetricsAging
|
4293 | | | | |
|
4294 | |-------------|-------------|-----|
|
4295 | | `Age` | Numeric | nullable |
|
4296 | | `Age_Group` | Text | |
|
4297 | | `Closed_Flag` | Boolean | |
|
4298 | | `Past_Required_Date` | Numeric | nullable |
|
4299 | | `SR_Service_RecID` | Numeric | |
|
4300 |
|
4301 | #### ServiceMetricsCounts
|
4302 | | | | |
|
4303 | |-------------|-------------|-----|
|
4304 | | `Closed_Flag` | Boolean | |
|
4305 | | `Configuration_Count` | Numeric | nullable |
|
4306 | | `Resources_Remaining_Count` | Numeric | nullable |
|
4307 | | `SR_Service_RecID` | Numeric | |
|
4308 | | `Time_Entry_Count` | Numeric | nullable |
|
4309 |
|
4310 | #### ServiceNote
|
4311 | | | | |
|
4312 | |-------------|-------------|-----|
|
4313 | | `Contact_RecID` | Numeric | nullable |
|
4314 | | `Created_By` | Text | nullable |
|
4315 | | `Date_Created_UTC` | DateTime | nullable |
|
4316 | | `Detail_Description_Flag` | Boolean | |
|
4317 | | `Internal_Analysis_Flag` | Boolean | |
|
4318 | | `Last_Update_UTC` | DateTime | nullable |
|
4319 | | `Member_RecID` | Numeric | nullable |
|
4320 | | `Notes` | Text | nullable |
|
4321 | | `RecID` | Numeric | |
|
4322 | | `Resolution_Flag` | Boolean | |
|
4323 | | `SR_Service_RecID` | Numeric | nullable |
|
4324 | | `Time_Flag` | Numeric | |
|
4325 | | `Updated_By` | Text | nullable |
|
4326 |
|
4327 | #### ServicePriority
|
4328 | | | | |
|
4329 | |-------------|-------------|-----|
|
4330 | | `Color` | Text | nullable |
|
4331 | | `Default_Flag` | Boolean | |
|
4332 | | `Image_Link` | Text | nullable |
|
4333 | | `Last_Update` | DateTime | |
|
4334 | | `SR_Urgency_RecID` | Numeric | |
|
4335 | | `Service_Priority_Desc` | Text | nullable |
|
4336 | | `Sort_Order` | Numeric | |
|
4337 | | `Time_Zone` | Text | nullable |
|
4338 | | `Updated_By` | Text | nullable |
|
4339 |
|
4340 | #### ServiceSignoff
|
4341 | | | | |
|
4342 | |-------------|-------------|-----|
|
4343 | | `Default_Flag` | Boolean | |
|
4344 | | `SR_Signoff_Name` | Text | |
|
4345 | | `SR_Signoff_RecID` | Numeric | |
|
4346 |
|
4347 | #### ServiceStatus
|
4348 | | | | |
|
4349 | |-------------|-------------|-----|
|
4350 | | `Billing_Unit_RecID` | Numeric | nullable |
|
4351 | | `Board_Flag` | Boolean | |
|
4352 | | `Board_Name` | Text | nullable |
|
4353 | | `Closed_Flag` | Boolean | |
|
4354 | | `Customer_Portal_Flag` | Boolean | nullable |
|
4355 | | `Default_Flag` | Boolean | |
|
4356 | | `Inactive_Flag` | Boolean | nullable |
|
4357 | | `Last_Update` | DateTime | |
|
4358 | | `Last_Update_UTC` | DateTime | |
|
4359 | | `No_Time_Flag` | Boolean | |
|
4360 | | `Owner_Level_RecID` | Numeric | nullable |
|
4361 | | `Project_Flag` | Boolean | nullable |
|
4362 | | `SR_Board_RecID` | Numeric | nullable |
|
4363 | | `SR_Status_RecID` | Numeric | |
|
4364 | | `Service_Status_Desc` | Text | nullable |
|
4365 | | `Sort_Order` | Numeric | nullable |
|
4366 | | `Time_Zone` | Text | nullable |
|
4367 | | `Updated_By` | Text | nullable |
|
4368 |
|
4369 | #### ServiceSubType
|
4370 | | | | |
|
4371 | |-------------|-------------|-----|
|
4372 | | `Billing_Unit_RecID` | Numeric | nullable |
|
4373 | | `Board_Name` | Text | nullable |
|
4374 | | `BusGroup` | Text | nullable |
|
4375 | | `Inactive_Flag` | Boolean | |
|
4376 | | `Last_Update` | DateTime | |
|
4377 | | `Last_Update_UTC` | DateTime | |
|
4378 | | `Location` | Text | nullable |
|
4379 | | `Owner_Level_RecID` | Numeric | nullable |
|
4380 | | `SR_Board_RecID` | Numeric | |
|
4381 | | `SR_SubType_RecID` | Numeric | |
|
4382 | | `SR_Type_RecID` | Numeric | nullable |
|
4383 | | `ServiceSubTypeDesc` | Text | |
|
4384 | | `ServiceTypeDesc` | Text | nullable |
|
4385 | | `Time_Zone` | Text | nullable |
|
4386 | | `Updated_By` | Text | |
|
4387 |
|
4388 | #### ServiceSubTypeItemTemplate
|
4389 | | | | |
|
4390 | |-------------|-------------|-----|
|
4391 | | `Auto_Apply` | Boolean | |
|
4392 | | `Last_Update_UTC` | DateTime | |
|
4393 | | `SRT_Service_RecID` | Numeric | nullable |
|
4394 | | `SR_SubTypeItem_RecID` | Numeric | nullable |
|
4395 | | `SR_SubType_RecID` | Numeric | |
|
4396 | | `SR_Type_RecID` | Numeric | |
|
4397 | | `SR_Type_SubType_SubTypeItem_Template_RecID` | Numeric | |
|
4398 |
|
4399 | #### ServiceSubTypeItemTemplateOption
|
4400 | | | | |
|
4401 | |-------------|-------------|-----|
|
4402 | | `Append_Flag` | Boolean | |
|
4403 | | `Ignore_Flag` | Boolean | |
|
4404 | | `Inactive_Flag` | Boolean | |
|
4405 | | `Option_Name` | Text | |
|
4406 | | `Overwrite_Flag` | Boolean | |
|
4407 | | `SR_Type_SubType_SubTypeItem_Template_Option_RecID` | Numeric | |
|
4408 | | `SR_Type_SubType_SubTypeItem_Template_RecID` | Numeric | |
|
4409 |
|
4410 | #### ServiceTask
|
4411 | | | | |
|
4412 | |-------------|-------------|-----|
|
4413 | | `Assign_To_RecID` | Numeric | nullable |
|
4414 | | `Child_RecID` | Numeric | nullable |
|
4415 | | `Closed_Flag` | Boolean | |
|
4416 | | `Last_Update` | DateTime | |
|
4417 | | `Last_Update_UTC` | DateTime | |
|
4418 | | `Notes` | Text | nullable |
|
4419 | | `Priority` | Numeric | nullable |
|
4420 | | `Resolution` | Text | nullable |
|
4421 | | `SR_Code_RecID` | Numeric | nullable |
|
4422 | | `SR_Service_RecID` | Numeric | |
|
4423 | | `SR_Task_RecID` | Numeric | |
|
4424 | | `Time_Zone` | Text | nullable |
|
4425 | | `Updated_By` | Text | nullable |
|
4426 | | `billing_sr` | Numeric | nullable |
|
4427 |
|
4428 | #### ServiceTeam
|
4429 | | | | |
|
4430 | |-------------|-------------|-----|
|
4431 | | `Billing_Unit_RecID` | Numeric | |
|
4432 | | `Board_Name` | Text | nullable |
|
4433 | | `BusGroup` | Text | nullable |
|
4434 | | `Default_Flag` | Boolean | |
|
4435 | | `DeleteNotify_Flag` | Boolean | nullable |
|
4436 | | `Last_Update` | DateTime | |
|
4437 | | `Last_Update_UTC` | DateTime | |
|
4438 | | `Location` | Text | nullable |
|
4439 | | `Owner_Level_RecID` | Numeric | |
|
4440 | | `SR_Board_RecID` | Numeric | nullable |
|
4441 | | `SR_Team_RecID` | Numeric | |
|
4442 | | `ServiceTeam` | Text | nullable |
|
4443 | | `Time_Zone` | Text | nullable |
|
4444 | | `Updated_By` | Text | nullable |
|
4445 |
|
4446 | #### ServiceTemplate
|
4447 | | | | |
|
4448 | |-------------|-------------|-----|
|
4449 | | `Board_Name` | Text | nullable |
|
4450 | | `Internal_Analysis` | Text | nullable |
|
4451 | | `Last_Update` | DateTime | |
|
4452 | | `Last_Update_UTC` | DateTime | |
|
4453 | | `Problem` | Text | nullable |
|
4454 | | `SRT_Service_RecID` | Numeric | |
|
4455 | | `SRT_Template_Name` | Text | |
|
4456 | | `SR_Board_RecID` | Numeric | |
|
4457 | | `SR_Type_RecID` | Numeric | nullable |
|
4458 | | `Summary` | Text | nullable |
|
4459 | | `Time_Zone` | Text | nullable |
|
4460 | | `Updated_By` | Text | nullable |
|
4461 |
|
4462 | #### ServiceTemplateTask
|
4463 | | | | |
|
4464 | |-------------|-------------|-----|
|
4465 | | `Last_Update` | DateTime | |
|
4466 | | `Last_Update_UTC` | DateTime | |
|
4467 | | `Notes` | Text | nullable |
|
4468 | | `Parent_SRT_Task_RecID` | Numeric | nullable |
|
4469 | | `Priority` | Numeric | nullable |
|
4470 | | `SRT_Service_RecID` | Numeric | |
|
4471 | | `SRT_Task_RecID` | Numeric | |
|
4472 | | `SR_Code_RecID` | Numeric | nullable |
|
4473 | | `Time_Zone` | Text | nullable |
|
4474 | | `Updated_By` | Text | nullable |
|
4475 |
|
4476 | #### ServiceTicketNotesDocuments
|
4477 | | | | |
|
4478 | |-------------|-------------|-----|
|
4479 | | `company_name` | Text | nullable |
|
4480 | | `docs_exist` | Numeric | nullable |
|
4481 | | `notes_exist` | Numeric | |
|
4482 | | `resources` | Text | nullable |
|
4483 | | `status_name` | Text | nullable |
|
4484 | | `summary` | Text | nullable |
|
4485 | | `summary_updated` | Numeric | |
|
4486 | | `ticket_recid` | Numeric | |
|
4487 | | `urgency_color` | Text | nullable |
|
4488 | | `urgency_name` | Text | nullable |
|
4489 |
|
4490 | #### ServiceType
|
4491 | | | | |
|
4492 | |-------------|-------------|-----|
|
4493 | | `ActiveType` | Text | nullable |
|
4494 | | `Billing_Unit_RecID` | Numeric | |
|
4495 | | `Board_Name` | Text | nullable |
|
4496 | | `BusGroup` | Text | nullable |
|
4497 | | `Default_Flag` | Boolean | nullable |
|
4498 | | `Inactive_Flag` | Boolean | nullable |
|
4499 | | `Last_Update` | DateTime | |
|
4500 | | `Last_Update_UTC` | DateTime | |
|
4501 | | `Location` | Text | nullable |
|
4502 | | `Owner_Level_RecID` | Numeric | |
|
4503 | | `SR_Board_RecID` | Numeric | nullable |
|
4504 | | `SR_Type_RecID` | Numeric | |
|
4505 | | `ServiceType` | Text | |
|
4506 | | `Time_Zone` | Text | nullable |
|
4507 | | `Updated_By` | Text | |
|
4508 |
|
4509 | #### Service_Open
|
4510 | | | | |
|
4511 | |-------------|-------------|-----|
|
4512 | | `AGR_Header_RecID` | Numeric | nullable |
|
4513 | | `Address_Line1` | Text | |
|
4514 | | `Address_Line2` | Text | |
|
4515 | | `Age` | Numeric | nullable |
|
4516 | | `Approved` | Boolean | |
|
4517 | | `Assigned_By_RecID` | Numeric | nullable |
|
4518 | | `Board_Name` | Text | nullable |
|
4519 | | `BusGroup` | Text | nullable |
|
4520 | | `City` | Text | |
|
4521 | | `Closed_Age` | Numeric | nullable |
|
4522 | | `Country` | Text | |
|
4523 | | `Date_Entered_UTC` | DateTime | nullable |
|
4524 | | `Date_Required` | DateTime | nullable |
|
4525 | | `Date_Resolved_UTC` | DateTime | nullable |
|
4526 | | `Date_Resplan_UTC` | DateTime | nullable |
|
4527 | | `Date_Responded_UTC` | DateTime | nullable |
|
4528 | | `Date_Status_Changed_UTC` | DateTime | nullable |
|
4529 | | `Detail_Description` | Text | nullable |
|
4530 | | `Escalation_Start_Date_UTC` | DateTime | nullable |
|
4531 | | `Est_Start_Date_UTC` | DateTime | nullable |
|
4532 | | `Hours_Actual` | Numeric | nullable |
|
4533 | | `Hours_Agreement` | Numeric | nullable |
|
4534 | | `Hours_Billable` | Numeric | nullable |
|
4535 | | `Hours_Budget` | Numeric | nullable |
|
4536 | | `Hours_Invoiced` | Numeric | nullable |
|
4537 | | `Hours_NonBillable` | Numeric | nullable |
|
4538 | | `Hours_Scheduled` | Numeric | nullable |
|
4539 | | `Impact` | Text | nullable |
|
4540 | | `Initial_Description` | Text | nullable |
|
4541 | | `Internal_Analysis` | Text | nullable |
|
4542 | | `Last_Update` | DateTime | nullable |
|
4543 | | `Location` | Text | nullable |
|
4544 | | `Minutes_Before_Waiting` | Numeric | nullable |
|
4545 | | `Minutes_Waiting` | Numeric | nullable |
|
4546 | | `Opportunity_RecID` | Numeric | nullable |
|
4547 | | `Overall_Start_Date_UTC` | DateTime | nullable |
|
4548 | | `PM_Phase_RecID` | Numeric | nullable |
|
4549 | | `Parent` | Text | nullable |
|
4550 | | `PostalCode` | Text | |
|
4551 | | `Previous_SR_Status_RecID` | Numeric | nullable |
|
4552 | | `Priority_Description` | Text | nullable |
|
4553 | | `Priority_Sort_Order` | Numeric | nullable |
|
4554 | | `Resolution` | Text | nullable |
|
4555 | | `Resolved_By` | Text | nullable |
|
4556 | | `Resolved_Minutes` | Numeric | nullable |
|
4557 | | `Resplan_Minutes` | Numeric | nullable |
|
4558 | | `Resplan_Skipped_Minutes` | Numeric | nullable |
|
4559 | | `Responded_By` | Text | nullable |
|
4560 | | `Responded_Minutes` | Numeric | nullable |
|
4561 | | `Responded_Skipped_Minutes` | Numeric | nullable |
|
4562 | | `SR_Billing_Method_ID` | Text | nullable |
|
4563 | | `SR_Billing_Method_RecID` | Numeric | nullable |
|
4564 | | `SR_Board_RecID` | Numeric | nullable |
|
4565 | | `SR_Impact_RecID` | Numeric | nullable |
|
4566 | | `SR_SLA_RecID` | Numeric | nullable |
|
4567 | | `SR_Service_RecID` | Numeric | |
|
4568 | | `SR_Severity_RecID` | Numeric | nullable |
|
4569 | | `SR_Urgency_RecID` | Numeric | nullable |
|
4570 | | `ServiceBillingMethod` | Text | nullable |
|
4571 | | `ServiceSubType` | Text | |
|
4572 | | `ServiceSubTypeItem` | Text | |
|
4573 | | `ServiceType` | Text | |
|
4574 | | `Severity` | Text | nullable |
|
4575 | | `Site_Name` | Text | nullable |
|
4576 | | `Source` | Text | nullable |
|
4577 | | `State` | Text | |
|
4578 | | `Status_Description` | Text | nullable |
|
4579 | | `Status_SortOrder` | Numeric | nullable |
|
4580 | | `SubTypeItem_RecID` | Numeric | nullable |
|
4581 | | `SubType_RecID` | Numeric | nullable |
|
4582 | | `Summary` | Text | nullable |
|
4583 | | `Territory` | Text | nullable |
|
4584 | | `Territory_Manager` | Text | nullable |
|
4585 | | `TicketNbr` | Numeric | |
|
4586 | | `Ticket_Owner_First_Name` | Text | nullable |
|
4587 | | `Ticket_Owner_Last_Name` | Text | nullable |
|
4588 | | `Ticket_Owner_RecID` | Numeric | nullable |
|
4589 | | `Time_Zone` | Text | nullable |
|
4590 | | `Type_RecID` | Numeric | nullable |
|
4591 | | `Updated_By` | Text | nullable |
|
4592 | | `Urgency` | Text | nullable |
|
4593 | | `Waiting_Flag` | Boolean | nullable |
|
4594 | | `agreement_name` | Text | |
|
4595 | | `billing_unit_recid` | Numeric | nullable |
|
4596 | | `closed_by` | Text | nullable |
|
4597 | | `company_name` | Text | nullable |
|
4598 | | `company_recid` | Numeric | nullable |
|
4599 | | `config_recids` | Text | nullable |
|
4600 | | `contact_name` | Text | nullable |
|
4601 | | `contact_recid` | Numeric | |
|
4602 | | `date_entered` | DateTime | nullable |
|
4603 | | `entered_by` | Text | nullable |
|
4604 | | `owner_level_recid` | Numeric | nullable |
|
4605 | | `resource_list` | Text | nullable |
|
4606 | | `service_location` | Text | nullable |
|
4607 | | `sr_status_recid` | Numeric | |
|
4608 | | `team_name` | Text | |
|
4609 | | `territory_recid` | Numeric | nullable |
|
4610 |
|
4611 | #### Service_SLA
|
4612 | | | | |
|
4613 | |-------------|-------------|-----|
|
4614 | | `Closed_Flag` | Boolean | |
|
4615 | | `Date_Resolved_UTC` | DateTime | nullable |
|
4616 | | `Date_Resplan_UTC` | DateTime | nullable |
|
4617 | | `Date_Responded_UTC` | DateTime | nullable |
|
4618 | | `Expected_Resolution_Expiration_Date` | DateTime | nullable |
|
4619 | | `Expected_Resolution_Expiration_Date_UTC` | DateTime | nullable |
|
4620 | | `Expected_Resplan_Expiration_Date` | DateTime | nullable |
|
4621 | | `Expected_Resplan_Expiration_Date_UTC` | DateTime | nullable |
|
4622 | | `Expected_Responded_Expiration_Date` | DateTime | nullable |
|
4623 | | `Expected_Responded_Expiration_Date_UTC` | DateTime | nullable |
|
4624 | | `Last_Update` | DateTime | |
|
4625 | | `Min_Expected_Expiration_Date` | DateTime | nullable |
|
4626 | | `Min_Expected_Expiration_Date_UTC` | DateTime | nullable |
|
4627 | | `Minutes_Waiting` | Numeric | |
|
4628 | | `Office_Calendar_RecID` | Numeric | nullable |
|
4629 | | `ResPlan_Hours` | Numeric | nullable |
|
4630 | | `Resolution_Hours` | Numeric | nullable |
|
4631 | | `Resolved_By` | Text | nullable |
|
4632 | | `Resolved_Minutes` | Numeric | |
|
4633 | | `Resplan_BY` | Text | nullable |
|
4634 | | `Resplan_Minutes` | Numeric | |
|
4635 | | `Responded_By` | Text | nullable |
|
4636 | | `Responded_Hours` | Numeric | nullable |
|
4637 | | `Responded_Minutes` | Numeric | |
|
4638 | | `SLA_Name` | Text | nullable |
|
4639 | | `SLA_Status_Text` | Text | nullable |
|
4640 | | `SR_SLA_RecID` | Numeric | |
|
4641 | | `SR_Service_RecID` | Numeric | |
|
4642 | | `SR_Status_RecID` | Numeric | |
|
4643 | | `Summary` | Text | nullable |
|
4644 | | `Time_Zone` | Text | nullable |
|
4645 | | `Updated_By` | Text | nullable |
|
4646 |
|
4647 | #### Service_Source
|
4648 | | | | |
|
4649 | |-------------|-------------|-----|
|
4650 | | `Date_Entered_UTC` | DateTime | |
|
4651 | | `Default_Flag` | Boolean | |
|
4652 | | `Entered_By` | Text | |
|
4653 | | `Last_Update` | DateTime | nullable |
|
4654 | | `Last_Update_UTC` | DateTime | |
|
4655 | | `SR_Source_RecID` | Numeric | |
|
4656 | | `Service_Source_Desc` | Text | nullable |
|
4657 | | `Time_Zone` | Text | nullable |
|
4658 | | `Updated_By` | Text | nullable |
|
4659 |
|
4660 | #### Service_Summary
|
4661 | | | | |
|
4662 | |-------------|-------------|-----|
|
4663 | | `AGR_Header_RecID` | Numeric | nullable |
|
4664 | | `Address_Line1` | Text | |
|
4665 | | `Address_Line2` | Text | |
|
4666 | | `Age` | Numeric | nullable |
|
4667 | | `Approved` | Boolean | |
|
4668 | | `Assigned_By_RecID` | Numeric | nullable |
|
4669 | | `Board_Name` | Text | nullable |
|
4670 | | `BusGroup` | Text | nullable |
|
4671 | | `City` | Text | |
|
4672 | | `ClosedDesc` | Text | |
|
4673 | | `Closed_Age` | Numeric | nullable |
|
4674 | | `Closed_Flag` | Boolean | nullable |
|
4675 | | `Country` | Text | |
|
4676 | | `Date_Closed_UTC` | DateTime | nullable |
|
4677 | | `Date_Entered_UTC` | DateTime | nullable |
|
4678 | | `Date_Required` | DateTime | nullable |
|
4679 | | `Date_Resolved_UTC` | DateTime | nullable |
|
4680 | | `Date_Resplan_UTC` | DateTime | nullable |
|
4681 | | `Date_Responded_UTC` | DateTime | nullable |
|
4682 | | `Date_Status_Changed_UTC` | DateTime | nullable |
|
4683 | | `Escalation_Start_Date_UTC` | DateTime | nullable |
|
4684 | | `Est_Start_Date_UTC` | DateTime | nullable |
|
4685 | | `Hours_Actual` | Numeric | nullable |
|
4686 | | `Hours_Agreement` | Numeric | nullable |
|
4687 | | `Hours_Billable` | Numeric | nullable |
|
4688 | | `Hours_Budget` | Numeric | nullable |
|
4689 | | `Hours_Invoiced` | Numeric | nullable |
|
4690 | | `Hours_NonBillable` | Numeric | nullable |
|
4691 | | `Hours_Scheduled` | Numeric | nullable |
|
4692 | | `Impact` | Text | nullable |
|
4693 | | `Last_Update` | DateTime | nullable |
|
4694 | | `Last_Update_UTC` | DateTime | nullable |
|
4695 | | `Location` | Text | nullable |
|
4696 | | `Minutes_Before_Waiting` | Numeric | |
|
4697 | | `Minutes_Waiting` | Numeric | |
|
4698 | | `Opportunity_RecID` | Numeric | nullable |
|
4699 | | `Overall_Start_Date_UTC` | DateTime | nullable |
|
4700 | | `PM_Phase_RecID` | Numeric | nullable |
|
4701 | | `Parent` | Text | nullable |
|
4702 | | `PostalCode` | Text | |
|
4703 | | `Previous_SR_Status_RecID` | Numeric | nullable |
|
4704 | | `Priority_Description` | Text | nullable |
|
4705 | | `Priority_Sort_Order` | Numeric | nullable |
|
4706 | | `Resolved_By` | Text | nullable |
|
4707 | | `Resolved_Minutes` | Numeric | |
|
4708 | | `Resplan_Minutes` | Numeric | |
|
4709 | | `Resplan_Skipped_Minutes` | Numeric | |
|
4710 | | `Responded_By` | Text | nullable |
|
4711 | | `Responded_Minutes` | Numeric | |
|
4712 | | `Responded_Skipped_Minutes` | Numeric | |
|
4713 | | `SR_Billing_Method_ID` | Text | nullable |
|
4714 | | `SR_Billing_Method_RecID` | Numeric | nullable |
|
4715 | | `SR_Board_RecID` | Numeric | nullable |
|
4716 | | `SR_Impact_RecID` | Numeric | nullable |
|
4717 | | `SR_SLA_RecID` | Numeric | nullable |
|
4718 | | `SR_Service_RecID` | Numeric | |
|
4719 | | `SR_Severity_RecID` | Numeric | nullable |
|
4720 | | `SR_Urgency_RecID` | Numeric | nullable |
|
4721 | | `ServiceBillingMethod` | Text | nullable |
|
4722 | | `ServiceSubType` | Text | |
|
4723 | | `ServiceSubTypeItem` | Text | |
|
4724 | | `ServiceType` | Text | |
|
4725 | | `Severity` | Text | nullable |
|
4726 | | `Site_Name` | Text | nullable |
|
4727 | | `Source` | Text | nullable |
|
4728 | | `State` | Text | |
|
4729 | | `Status_SortOrder` | Numeric | nullable |
|
4730 | | `SubTypeItem_RecID` | Numeric | nullable |
|
4731 | | `SubType_RecID` | Numeric | nullable |
|
4732 | | `Summary` | Text | nullable |
|
4733 | | `Territory` | Text | nullable |
|
4734 | | `Territory_Manager` | Text | nullable |
|
4735 | | `TicketNbr` | Numeric | |
|
4736 | | `Ticket_Owner_First_Name` | Text | nullable |
|
4737 | | `Ticket_Owner_Last_Name` | Text | nullable |
|
4738 | | `Ticket_Owner_RecID` | Numeric | nullable |
|
4739 | | `Time_Zone` | Text | nullable |
|
4740 | | `Type_RecID` | Numeric | nullable |
|
4741 | | `Updated_By` | Text | nullable |
|
4742 | | `Urgency` | Text | nullable |
|
4743 | | `Waiting_Flag` | Boolean | |
|
4744 | | `agreement_name` | Text | |
|
4745 | | `billing_unit_recid` | Numeric | nullable |
|
4746 | | `closed_by` | Text | nullable |
|
4747 | | `company_name` | Text | nullable |
|
4748 | | `company_recid` | Numeric | nullable |
|
4749 | | `config_recids` | Text | nullable |
|
4750 | | `contact_name` | Text | nullable |
|
4751 | | `contact_recid` | Numeric | |
|
4752 | | `date_closed` | DateTime | nullable |
|
4753 | | `date_entered` | DateTime | nullable |
|
4754 | | `entered_by` | Text | nullable |
|
4755 | | `owner_level_recid` | Numeric | nullable |
|
4756 | | `resource_list` | Text | nullable |
|
4757 | | `service_location` | Text | nullable |
|
4758 | | `sr_status_recid` | Numeric | |
|
4759 | | `status_description` | Text | nullable |
|
4760 | | `team_name` | Text | |
|
4761 | | `territory_recid` | Numeric | nullable |
|
4762 |
|
4763 | #### Service_Summary_Open
|
4764 | | | | |
|
4765 | |-------------|-------------|-----|
|
4766 | | `AGE` | Numeric | nullable |
|
4767 | | `AGR_Header_RecID` | Numeric | nullable |
|
4768 | | `Address_Line1` | Text | |
|
4769 | | `Address_Line2` | Text | |
|
4770 | | `Approved` | Boolean | |
|
4771 | | `Assigned_By_RecID` | Numeric | nullable |
|
4772 | | `Board_Name` | Text | nullable |
|
4773 | | `BusGroup` | Text | nullable |
|
4774 | | `City` | Text | |
|
4775 | | `Closed_Age` | Numeric | nullable |
|
4776 | | `Country` | Text | |
|
4777 | | `Date_Closed_UTC` | DateTime | nullable |
|
4778 | | `Date_Entered_UTC` | DateTime | nullable |
|
4779 | | `Date_Required` | DateTime | nullable |
|
4780 | | `Date_Resolved_UTC` | DateTime | nullable |
|
4781 | | `Date_Resplan_UTC` | DateTime | nullable |
|
4782 | | `Date_Responded_UTC` | DateTime | nullable |
|
4783 | | `Date_Status_Changed_UTC` | DateTime | nullable |
|
4784 | | `Escalation_Start_Date_UTC` | DateTime | nullable |
|
4785 | | `Est_Start_Date_UTC` | DateTime | nullable |
|
4786 | | `Hours_Actual` | Numeric | nullable |
|
4787 | | `Hours_Agreement` | Numeric | nullable |
|
4788 | | `Hours_Billable` | Numeric | nullable |
|
4789 | | `Hours_Budget` | Numeric | nullable |
|
4790 | | `Hours_Invoiced` | Numeric | nullable |
|
4791 | | `Hours_NonBillable` | Numeric | nullable |
|
4792 | | `Hours_Scheduled` | Numeric | nullable |
|
4793 | | `Impact` | Text | nullable |
|
4794 | | `Last_Update` | DateTime | nullable |
|
4795 | | `Last_Update_UTC` | DateTime | nullable |
|
4796 | | `Location` | Text | nullable |
|
4797 | | `Minutes_Before_Waiting` | Numeric | |
|
4798 | | `Minutes_Waiting` | Numeric | |
|
4799 | | `Opportunity_RecID` | Numeric | nullable |
|
4800 | | `Overall_Start_Date_UTC` | DateTime | nullable |
|
4801 | | `PM_Phase_RecID` | Numeric | nullable |
|
4802 | | `Parent` | Text | nullable |
|
4803 | | `PostalCode` | Text | |
|
4804 | | `Previous_SR_Status_RecID` | Numeric | nullable |
|
4805 | | `Priority_Description` | Text | nullable |
|
4806 | | `Priority_Sort_Order` | Numeric | nullable |
|
4807 | | `Resolved_By` | Text | nullable |
|
4808 | | `Resolved_Minutes` | Numeric | |
|
4809 | | `Resplan_Minutes` | Numeric | |
|
4810 | | `Resplan_Skipped_Minutes` | Numeric | |
|
4811 | | `Responded_By` | Text | nullable |
|
4812 | | `Responded_Minutes` | Numeric | |
|
4813 | | `Responded_Skipped_Minutes` | Numeric | |
|
4814 | | `SR_Billing_Method_ID` | Text | nullable |
|
4815 | | `SR_Billing_Method_RecID` | Numeric | nullable |
|
4816 | | `SR_Board_RecID` | Numeric | nullable |
|
4817 | | `SR_Impact_RecID` | Numeric | nullable |
|
4818 | | `SR_SLA_RecID` | Numeric | nullable |
|
4819 | | `SR_Service_RecID` | Numeric | |
|
4820 | | `SR_Severity_RecID` | Numeric | nullable |
|
4821 | | `SR_Urgency_RecID` | Numeric | nullable |
|
4822 | | `ServiceBillingMethod` | Text | nullable |
|
4823 | | `ServiceSubType` | Text | |
|
4824 | | `ServiceSubTypeItem` | Text | |
|
4825 | | `ServiceType` | Text | |
|
4826 | | `Severity` | Text | nullable |
|
4827 | | `Site_Name` | Text | nullable |
|
4828 | | `Source` | Text | nullable |
|
4829 | | `State` | Text | |
|
4830 | | `Status_Description` | Text | nullable |
|
4831 | | `Status_SortOrder` | Numeric | nullable |
|
4832 | | `SubTypeItem_RecID` | Numeric | nullable |
|
4833 | | `SubType_RecID` | Numeric | nullable |
|
4834 | | `Summary` | Text | nullable |
|
4835 | | `Territory` | Text | nullable |
|
4836 | | `Territory_Manager` | Text | nullable |
|
4837 | | `TicketNbr` | Numeric | |
|
4838 | | `Ticket_Owner_First_Name` | Text | nullable |
|
4839 | | `Ticket_Owner_Last_Name` | Text | nullable |
|
4840 | | `Ticket_Owner_RecID` | Numeric | nullable |
|
4841 | | `Time_Zone` | Text | nullable |
|
4842 | | `Type_RecID` | Numeric | nullable |
|
4843 | | `Updated_By` | Text | nullable |
|
4844 | | `Urgency` | Text | nullable |
|
4845 | | `Waiting_Flag` | Boolean | |
|
4846 | | `agreement_name` | Text | |
|
4847 | | `billing_unit_recid` | Numeric | nullable |
|
4848 | | `closed_by` | Text | nullable |
|
4849 | | `company_name` | Text | nullable |
|
4850 | | `company_recid` | Numeric | nullable |
|
4851 | | `config_recids` | Text | nullable |
|
4852 | | `contact_name` | Text | nullable |
|
4853 | | `contact_recid` | Numeric | |
|
4854 | | `date_entered` | DateTime | nullable |
|
4855 | | `entered_by` | Text | nullable |
|
4856 | | `owner_level_recid` | Numeric | nullable |
|
4857 | | `resource_list` | Text | nullable |
|
4858 | | `service_location` | Text | nullable |
|
4859 | | `sr_status_recid` | Numeric | |
|
4860 | | `team_name` | Text | |
|
4861 | | `territory_recid` | Numeric | nullable |
|
4862 |
|
4863 | #### ShipmentMethod
|
4864 | | | | |
|
4865 | |-------------|-------------|-----|
|
4866 | | `Last_Update` | DateTime | |
|
4867 | | `Last_Update_UTC` | DateTime | |
|
4868 | | `ShipMethodDescription` | Text | nullable |
|
4869 | | `ShipmentMethod_RecID` | Numeric | |
|
4870 | | `Time_Zone` | Text | nullable |
|
4871 |
|
4872 | #### States
|
4873 | | | | |
|
4874 | |-------------|-------------|-----|
|
4875 | | `Last_Update` | DateTime | |
|
4876 | | `Last_Update_UTC` | DateTime | |
|
4877 | | `State_Desc` | Text | nullable |
|
4878 | | `State_ID` | Text | |
|
4879 | | `State_RecID` | Numeric | |
|
4880 | | `Time_Zone` | Text | nullable |
|
4881 | | `Updated_By` | Text | nullable |
|
4882 |
|
4883 | #### Surveys
|
4884 | | | | |
|
4885 | |-------------|-------------|-----|
|
4886 | | `ClosedBy` | Text | nullable |
|
4887 | | `Comments` | Text | nullable |
|
4888 | | `CompanyName` | Text | nullable |
|
4889 | | `ContactMe` | Text | nullable |
|
4890 | | `Email` | Text | nullable |
|
4891 | | `Last_Update` | DateTime | nullable |
|
4892 | | `Points` | Numeric | |
|
4893 | | `Possible_Points` | Numeric | nullable |
|
4894 | | `Score` | Numeric | nullable |
|
4895 | | `SurveyName` | Text | nullable |
|
4896 | | `SurveyQtr` | Numeric | nullable |
|
4897 | | `SurveyYr` | Numeric | nullable |
|
4898 | | `Ticket` | Numeric | nullable |
|
4899 | | `Time_Zone` | Text | nullable |
|
4900 | | `Updated_By` | Text | nullable |
|
4901 | | `resources` | Text | nullable |
|
4902 |
|
4903 | #### SurveysByTicket
|
4904 | | | | |
|
4905 | |-------------|-------------|-----|
|
4906 | | `Closed_Flag` | Boolean | |
|
4907 | | `Date_Completed` | DateTime | nullable |
|
4908 | | `Date_Sent` | DateTime | nullable |
|
4909 | | `Rec_Type` | Text | |
|
4910 | | `SR_Service_RecID` | Numeric | |
|
4911 | | `Score_Avg` | Numeric | |
|
4912 | | `Score_Max` | Numeric | |
|
4913 | | `Score_Min` | Numeric | |
|
4914 | | `Surveys_Completed` | Numeric | |
|
4915 | | `Surveys_Sent` | Numeric | |
|
4916 | | `Total_Points` | Numeric | |
|
4917 | | `Total_Possible_Points` | Numeric | |
|
4918 |
|
4919 | #### SystemMenus
|
4920 | | | | |
|
4921 | |-------------|-------------|-----|
|
4922 | | `description` | Text | |
|
4923 | | `favorites_flag` | Boolean | |
|
4924 | | `menu_id` | Text | |
|
4925 | | `sort_order` | Numeric | nullable |
|
4926 | | `system_menus_recid` | Numeric | |
|
4927 |
|
4928 | #### TaxCode
|
4929 | | | | |
|
4930 | |-------------|-------------|-----|
|
4931 | | `Agency2_Xref` | Text | nullable |
|
4932 | | `Agency3_Xref` | Text | nullable |
|
4933 | | `Agency4_Xref` | Text | nullable |
|
4934 | | `Agency5_Xref` | Text | nullable |
|
4935 | | `Agency6_Xref` | Text | nullable |
|
4936 | | `Agency_Xref` | Text | nullable |
|
4937 | | `City_Max` | Numeric | nullable |
|
4938 | | `City_Rate` | Numeric | nullable |
|
4939 | | `City_Xref` | Text | nullable |
|
4940 | | `CodeCaption` | Text | nullable |
|
4941 | | `Country_RecID` | Numeric | nullable |
|
4942 | | `County_Max` | Numeric | nullable |
|
4943 | | `County_Rate` | Numeric | nullable |
|
4944 | | `County_Xref` | Text | nullable |
|
4945 | | `Date_Cancel` | DateTime | nullable |
|
4946 | | `Date_Effective` | DateTime | nullable |
|
4947 | | `Default_Flag` | Boolean | |
|
4948 | | `DisplayDetail_Flag` | Boolean | nullable |
|
4949 | | `Last_Update` | DateTime | |
|
4950 | | `LevelCaption` | Text | nullable |
|
4951 | | `LevelCaption2` | Text | nullable |
|
4952 | | `LevelCaption3` | Text | nullable |
|
4953 | | `LevelCaption4` | Text | nullable |
|
4954 | | `LevelCaption5` | Text | nullable |
|
4955 | | `LevelCaption6` | Text | nullable |
|
4956 | | `PiggyBack_Flag` | Boolean | nullable |
|
4957 | | `SingleUnitMax` | Numeric | nullable |
|
4958 | | `SingleUnitMax2` | Numeric | nullable |
|
4959 | | `SingleUnitMax3` | Numeric | nullable |
|
4960 | | `SingleUnitMax4` | Numeric | nullable |
|
4961 | | `SingleUnitMax5` | Numeric | nullable |
|
4962 | | `SingleUnitMax6` | Numeric | nullable |
|
4963 | | `SingleUnitMin` | Numeric | nullable |
|
4964 | | `SingleUnitMin2` | Numeric | nullable |
|
4965 | | `SingleUnitMin3` | Numeric | nullable |
|
4966 | | `SingleUnitMin4` | Numeric | nullable |
|
4967 | | `SingleUnitMin5` | Numeric | nullable |
|
4968 | | `SingleUnitMin6` | Numeric | nullable |
|
4969 | | `SingleUnit_Flag` | Boolean | nullable |
|
4970 | | `SingleUnit_Flag2` | Boolean | nullable |
|
4971 | | `SingleUnit_Flag3` | Boolean | nullable |
|
4972 | | `SingleUnit_Flag4` | Boolean | nullable |
|
4973 | | `SingleUnit_Flag5` | Boolean | nullable |
|
4974 | | `SingleUnit_Flag6` | Boolean | nullable |
|
4975 | | `State_ID` | Numeric | nullable |
|
4976 | | `State_Max` | Numeric | nullable |
|
4977 | | `State_Rate` | Numeric | nullable |
|
4978 | | `State_Xref` | Text | nullable |
|
4979 | | `Tax4_Max` | Numeric | nullable |
|
4980 | | `Tax4_Rate` | Numeric | nullable |
|
4981 | | `Tax4_Xref` | Text | nullable |
|
4982 | | `Tax5_Max` | Numeric | nullable |
|
4983 | | `Tax5_Rate` | Numeric | nullable |
|
4984 | | `Tax5_Xref` | Text | nullable |
|
4985 | | `Tax6_Rate` | Numeric | nullable |
|
4986 | | `Tax6_Xref` | Text | nullable |
|
4987 | | `TaxExpenses2_Flag` | Boolean | nullable |
|
4988 | | `TaxExpenses3_Flag` | Boolean | nullable |
|
4989 | | `TaxExpenses4_Flag` | Boolean | nullable |
|
4990 | | `TaxExpenses5_Flag` | Boolean | nullable |
|
4991 | | `TaxExpenses6_Flag` | Boolean | nullable |
|
4992 | | `TaxExpenses_Flag` | Boolean | nullable |
|
4993 | | `TaxProducts2_Flag` | Boolean | nullable |
|
4994 | | `TaxProducts3_Flag` | Boolean | nullable |
|
4995 | | `TaxProducts4_Flag` | Boolean | nullable |
|
4996 | | `TaxProducts5_Flag` | Boolean | nullable |
|
4997 | | `TaxProducts6_Flag` | Boolean | nullable |
|
4998 | | `TaxProducts_Flag` | Boolean | nullable |
|
4999 | | `TaxRateType` | Text | nullable |
|
5000 | | `TaxRateType2` | Text | nullable |
|
5001 | | `TaxRateType3` | Text | nullable |
|
5002 | | `TaxRateType4` | Text | nullable |
|
5003 | | `TaxRateType5` | Text | nullable |
|
5004 | | `TaxRateType6` | Text | nullable |
|
5005 | | `TaxServices2_Flag` | Boolean | nullable |
|
5006 | | `TaxServices3_Flag` | Boolean | nullable |
|
5007 | | `TaxServices4_Flag` | Boolean | nullable |
|
5008 | | `TaxServices5_Flag` | Boolean | nullable |
|
5009 | | `TaxServices6_Flag` | Boolean | nullable |
|
5010 | | `TaxServices_Flag` | Boolean | nullable |
|
5011 | | `Tax_Code_Desc` | Text | nullable |
|
5012 | | `Tax_Code_ID` | Text | nullable |
|
5013 | | `Tax_Code_RecID` | Numeric | |
|
5014 | | `Tax_Code_Xref` | Numeric | nullable |
|
5015 | | `Time_Zone` | Text | nullable |
|
5016 | | `Updated_By` | Text | nullable |
|
5017 |
|
5018 | #### TeamRole
|
5019 | | | | |
|
5020 | |-------------|-------------|-----|
|
5021 | | `Last_Update` | DateTime | nullable |
|
5022 | | `Role_Desc` | Text | nullable |
|
5023 | | `Team_Role_RecID` | Numeric | |
|
5024 | | `Time_Zone` | Text | nullable |
|
5025 | | `Updated_By` | Text | nullable |
|
5026 |
|
5027 | #### TicketAudit
|
5028 | | | | |
|
5029 | |-------------|-------------|-----|
|
5030 | | `Affected_Record` | Text | nullable |
|
5031 | | `Audit_Source_ID` | Text | nullable |
|
5032 | | `Audit_SubType` | Text | nullable |
|
5033 | | `Audit_Text` | Text | nullable |
|
5034 | | `Audit_Type` | Text | nullable |
|
5035 | | `Created_By` | Text | |
|
5036 | | `Date_Entered_UTC` | DateTime | |
|
5037 | | `Locale_RecId` | Numeric | nullable |
|
5038 | | `New_Value` | Text | nullable |
|
5039 | | `Old_Value` | Text | nullable |
|
5040 | | `SR_Service_Audit_RecID` | Numeric | |
|
5041 | | `SR_Service_RecID` | Numeric | |
|
5042 |
|
5043 | #### Time
|
5044 | | | | |
|
5045 | |-------------|-------------|-----|
|
5046 | | `AGR_Header_RecID` | Numeric | nullable |
|
5047 | | `Activity_Subject` | Text | nullable |
|
5048 | | `Actual_Utilized_Hrs` | Numeric | nullable |
|
5049 | | `AgrAdj_Firm` | Numeric | nullable |
|
5050 | | `AgrAdj_Total` | Numeric | |
|
5051 | | `AgrAmtCovered` | Numeric | |
|
5052 | | `AgrHrsCovered` | Numeric | |
|
5053 | | `Agreement` | Text | |
|
5054 | | `Billable_Amt` | Numeric | nullable |
|
5055 | | `Billable_Hrs` | Numeric | nullable |
|
5056 | | `Billable_Utilized_Hrs` | Numeric | nullable |
|
5057 | | `Billing_Log_RecID` | Numeric | nullable |
|
5058 | | `Billing_Unit_RecID` | Numeric | nullable |
|
5059 | | `BusGroup` | Text | nullable |
|
5060 | | `Charge_Code` | Text | nullable |
|
5061 | | `Company_RecID` | Numeric | |
|
5062 | | `Date_Start` | DateTime | nullable |
|
5063 | | `Hourly_Cost` | Text | nullable |
|
5064 | | `Hourly_Cost_Decimal` | Numeric | nullable |
|
5065 | | `Hourly_Rate` | Numeric | nullable |
|
5066 | | `InvAdj_Firm` | Numeric | nullable |
|
5067 | | `InvAdj_Total` | Numeric | |
|
5068 | | `Invoice_Number` | Text | nullable |
|
5069 | | `Invoice_Ready` | Numeric | |
|
5070 | | `Last_Update` | DateTime | nullable |
|
5071 | | `Last_Update_UTC` | DateTime | nullable |
|
5072 | | `Location` | Text | nullable |
|
5073 | | `NonBillable_Amt` | Numeric | nullable |
|
5074 | | `NonBillable_Hrs` | Numeric | nullable |
|
5075 | | `Notes` | Text | nullable |
|
5076 | | `Opportunity_RecID` | Numeric | nullable |
|
5077 | | `Owner_Level_RecID` | Numeric | nullable |
|
5078 | | `PM_Project_RecID` | Numeric | |
|
5079 | | `Project_Activity` | Text | nullable |
|
5080 | | `Project_Phase` | Text | nullable |
|
5081 | | `SO_Activity_RecID` | Numeric | nullable |
|
5082 | | `SR_Service_RecID` | Numeric | |
|
5083 | | `TE_Charge_Code_RecID` | Numeric | nullable |
|
5084 | | `Territory` | Text | nullable |
|
5085 | | `Time_End_UTC` | DateTime | nullable |
|
5086 | | `Time_RecID` | Numeric | |
|
5087 | | `Time_Sheet_RecID` | Numeric | nullable |
|
5088 | | `Time_Start_UTC` | DateTime | nullable |
|
5089 | | `Time_Zone` | Text | nullable |
|
5090 | | `Updated_By` | Text | nullable |
|
5091 | | `Utilization_Flag` | Boolean | nullable |
|
5092 | | `billable_flag` | Boolean | |
|
5093 | | `charge_to` | Text | nullable |
|
5094 | | `company_name` | Text | nullable |
|
5095 | | `date_entered_utc` | DateTime | |
|
5096 | | `date_invoice` | DateTime | nullable |
|
5097 | | `first_name` | Text | nullable |
|
5098 | | `hours_actual` | Numeric | |
|
5099 | | `internal_note` | Text | nullable |
|
5100 | | `invoice_flag` | Boolean | |
|
5101 | | `last_name` | Text | nullable |
|
5102 | | `member_id` | Text | |
|
5103 | | `member_recid` | Numeric | nullable |
|
5104 | | `option_id` | Text | nullable |
|
5105 | | `project_name` | Text | nullable |
|
5106 | | `sr_status` | Text | nullable |
|
5107 | | `sr_summary` | Text | nullable |
|
5108 | | `te_status_id` | Numeric | nullable |
|
5109 | | `time_end` | DateTime | nullable |
|
5110 | | `time_start` | DateTime | nullable |
|
5111 | | `time_status` | Text | nullable |
|
5112 | | `work_role` | Text | nullable |
|
5113 | | `work_type` | Text | nullable |
|
5114 |
|
5115 | #### TimeAudit
|
5116 | | | | |
|
5117 | |-------------|-------------|-----|
|
5118 | | `Audit_Source_ID` | Text | nullable |
|
5119 | | `Audit_Text` | Text | nullable |
|
5120 | | `Audit_Type` | Text | nullable |
|
5121 | | `Created_By` | Text | nullable |
|
5122 | | `Date_Entered_UTC` | DateTime | |
|
5123 | | `Locale_RecID` | Numeric | nullable |
|
5124 | | `New_Value` | Text | nullable |
|
5125 | | `Old_Value` | Text | nullable |
|
5126 | | `Time_Audit_RecID` | Numeric | |
|
5127 | | `Time_RecID` | Numeric | nullable |
|
5128 |
|
5129 | #### TimeEntryCustomFields
|
5130 | | | | |
|
5131 | |-------------|-------------|-----|
|
5132 | | `Last_Update_UTC` | DateTime | |
|
5133 | | `Pod_RecID` | Numeric | |
|
5134 | | `Time_RecID` | Numeric | |
|
5135 | | `Time_Sheet_RecID` | Numeric | nullable |
|
5136 | | `Updated_By` | Text | |
|
5137 | | `User_Defined_Field_RecID` | Numeric | |
|
5138 | | `User_Defined_Field_Value` | Text | |
|
5139 | | `customfield_podID` | Text | |
|
5140 | | `time_entry_customfield` | Text | |
|
5141 | | `time_entry_fieldtype` | Text | nullable |
|
5142 |
|
5143 | #### TimeSheetAudit
|
5144 | | | | |
|
5145 | |-------------|-------------|-----|
|
5146 | | `Audit_Text` | Text | nullable |
|
5147 | | `Date_Audit_UTC` | DateTime | |
|
5148 | | `Date_End` | DateTime | nullable |
|
5149 | | `Date_Start` | DateTime | nullable |
|
5150 | | `Member_Identifier` | Text | |
|
5151 | | `Member_Name` | Text | nullable |
|
5152 | | `Submitted_By` | Text | nullable |
|
5153 | | `Time_Audit_RecID` | Numeric | |
|
5154 | | `Time_Sheet_RecID` | Numeric | nullable |
|
5155 | | `Time_Zone` | Text | nullable |
|
5156 |
|
5157 | #### TimeSheets
|
5158 | | | | |
|
5159 | |-------------|-------------|-----|
|
5160 | | `Date_DeadLine` | DateTime | |
|
5161 | | `Date_End` | DateTime | |
|
5162 | | `Date_Start` | DateTime | |
|
5163 | | `Description` | Text | nullable |
|
5164 | | `Last_Updated_UTC` | DateTime | |
|
5165 | | `Member_ID` | Text | |
|
5166 | | `Member_RecID` | Numeric | nullable |
|
5167 | | `Period` | Numeric | |
|
5168 | | `TE_Period_RecID` | Numeric | |
|
5169 | | `TE_Status_ID` | Numeric | nullable |
|
5170 | | `Time_Sheet_RecID` | Numeric | |
|
5171 |
|
5172 | #### TimeStatus
|
5173 | | | | |
|
5174 | |-------------|-------------|-----|
|
5175 | | `Action` | Text | nullable |
|
5176 | | `Description` | Text | nullable |
|
5177 | | `TE_Status_ID` | Numeric | nullable |
|
5178 | | `TE_Status_RecID` | Numeric | |
|
5179 |
|
5180 | #### TimeZone
|
5181 | | | | |
|
5182 | |-------------|-------------|-----|
|
5183 | | `Default_Flag` | Boolean | |
|
5184 | | `End_Date_UTC` | DateTime | nullable |
|
5185 | | `Hours_Offset` | Numeric | |
|
5186 | | `Last_Update` | DateTime | |
|
5187 | | `Last_Update_UTC` | DateTime | |
|
5188 | | `Start_Date_UTC` | DateTime | nullable |
|
5189 | | `Time_Zone` | Text | nullable |
|
5190 | | `Time_Zone_Name` | Text | |
|
5191 | | `Time_Zone_RecID` | Numeric | |
|
5192 | | `Updated_By` | Text | nullable |
|
5193 |
|
5194 | #### Track
|
5195 | | | | |
|
5196 | |-------------|-------------|-----|
|
5197 | | `Description` | Text | |
|
5198 | | `Inactive_Flag` | Boolean | |
|
5199 | | `Last_Update` | DateTime | nullable |
|
5200 | | `Time_Zone` | Text | nullable |
|
5201 | | `Updated_By` | Text | nullable |
|
5202 | | `WF_Track_Header_RecID` | Numeric | |
|
5203 |
|
5204 | #### Transaction
|
5205 | | | | |
|
5206 | |-------------|-------------|-----|
|
5207 | | `Activity_Summary` | Text | nullable |
|
5208 | | `Balance` | Text | nullable |
|
5209 | | `Billing_Log_RecID` | Numeric | |
|
5210 | | `CR_Amount` | Numeric | nullable |
|
5211 | | `DR_Amount` | Numeric | nullable |
|
5212 | | `EX_Type_RecID` | Numeric | nullable |
|
5213 | | `Ex_Type_Desc` | Text | nullable |
|
5214 | | `GL_Account` | Text | nullable |
|
5215 | | `GL_BatchID` | Text | nullable |
|
5216 | | `GL_BatchID_RecID` | Numeric | nullable |
|
5217 | | `GL_COGS` | Text | nullable |
|
5218 | | `GL_Cost` | Numeric | nullable |
|
5219 | | `GL_Description` | Text | nullable |
|
5220 | | `GL_Entry_RecID` | Numeric | |
|
5221 | | `GL_Inventory` | Text | nullable |
|
5222 | | `GL_Item` | Text | nullable |
|
5223 | | `GL_SalesCode` | Text | nullable |
|
5224 | | `GL_Type_ID` | Text | |
|
5225 | | `Invoice_Number` | Text | nullable |
|
5226 | | `Item_Taxable_Flag` | Boolean | |
|
5227 | | `Last_Update` | DateTime | |
|
5228 | | `Notes` | Text | nullable |
|
5229 | | `Owner_Level_RecID` | Numeric | nullable |
|
5230 | | `PM_Phase_Desc` | Text | nullable |
|
5231 | | `PM_Phase_RecID` | Numeric | nullable |
|
5232 | | `PM_Project_RecID` | Numeric | nullable |
|
5233 | | `Packing_Slip` | Text | nullable |
|
5234 | | `Project_ID` | Text | nullable |
|
5235 | | `Quantity` | Numeric | |
|
5236 | | `SO_Activity_RecID` | Numeric | nullable |
|
5237 | | `SR_Service_RecID` | Numeric | nullable |
|
5238 | | `Segment1` | Text | nullable |
|
5239 | | `Segment10` | Text | nullable |
|
5240 | | `Segment2` | Text | nullable |
|
5241 | | `Segment3` | Text | nullable |
|
5242 | | `Segment4` | Text | nullable |
|
5243 | | `Segment5` | Text | nullable |
|
5244 | | `Segment6` | Text | nullable |
|
5245 | | `Segment7` | Text | nullable |
|
5246 | | `Segment8` | Text | nullable |
|
5247 | | `Segment9` | Text | nullable |
|
5248 | | `Service_Summary` | Text | nullable |
|
5249 | | `Table_Reference` | Text | nullable |
|
5250 | | `Taxable2_Flag` | Boolean | nullable |
|
5251 | | `Taxable3_Flag` | Boolean | nullable |
|
5252 | | `Taxable4_Flag` | Boolean | nullable |
|
5253 | | `Taxable5_Flag` | Boolean | nullable |
|
5254 | | `Taxable6_Flag` | Boolean | nullable |
|
5255 | | `Taxable_Flag` | Boolean | nullable |
|
5256 | | `Time_RecID` | Numeric | nullable |
|
5257 | | `Updated_By` | Text | |
|
5258 | | `iv_product_recid` | Numeric | nullable |
|
5259 | | `product_desc` | Text | nullable |
|
5260 |
|
5261 | #### UnpostedExpense
|
5262 | | | | |
|
5263 | |-------------|-------------|-----|
|
5264 | | `ChargeDescription` | Text | nullable |
|
5265 | | `Classification` | Text | nullable |
|
5266 | | `CompanyName` | Text | nullable |
|
5267 | | `Company_RecID` | Numeric | nullable |
|
5268 | | `Credit_Account` | Text | nullable |
|
5269 | | `Currency_Name` | Text | nullable |
|
5270 | | `Currency_RecID` | Numeric | nullable |
|
5271 | | `Currency_Symbol` | Text | nullable |
|
5272 | | `Date_Expense` | DateTime | nullable |
|
5273 | | `EX_Payment_RecID` | Numeric | nullable |
|
5274 | | `Ex_Type_RecID` | Numeric | nullable |
|
5275 | | `Expense_Type` | Text | nullable |
|
5276 | | `GL_Account` | Text | nullable |
|
5277 | | `GL_Amount` | Numeric | nullable |
|
5278 | | `GL_Description` | Text | nullable |
|
5279 | | `GL_Entry_RecID` | Numeric | |
|
5280 | | `InPolicy` | Numeric | |
|
5281 | | `Last_Update` | DateTime | |
|
5282 | | `Member_ID` | Text | nullable |
|
5283 | | `Member_Name` | Text | nullable |
|
5284 | | `Owner_Level_Name` | Text | nullable |
|
5285 | | `Owner_Level_RecID` | Numeric | nullable |
|
5286 | | `PaymentMethod` | Text | nullable |
|
5287 | | `RecID` | Numeric | |
|
5288 | | `Updated_By` | Text | |
|
5289 |
|
5290 | #### UnpostedInvoice
|
5291 | | | | |
|
5292 | |-------------|-------------|-----|
|
5293 | | `Company_Name` | Text | nullable |
|
5294 | | `Company_RecID` | Numeric | |
|
5295 | | `CreatedBy` | Text | nullable |
|
5296 | | `CurrencySymbol` | Text | nullable |
|
5297 | | `Currency_Name` | Text | |
|
5298 | | `Currency_RecID` | Numeric | |
|
5299 | | `Date_Invoice` | DateTime | nullable |
|
5300 | | `Department` | Text | nullable |
|
5301 | | `GL_Account` | Text | nullable |
|
5302 | | `GL_Amount` | Numeric | nullable |
|
5303 | | `GL_Description` | Text | nullable |
|
5304 | | `GL_Entry_RecID` | Numeric | |
|
5305 | | `InvoiceType` | Text | nullable |
|
5306 | | `Invoice_Number` | Text | nullable |
|
5307 | | `Last_Update` | DateTime | |
|
5308 | | `Owner_Level_Name` | Text | nullable |
|
5309 | | `Owner_Level_RecID` | Numeric | nullable |
|
5310 | | `RecID` | Numeric | |
|
5311 | | `Updated_By` | Text | |
|
5312 |
|
5313 | #### UnpostedProcurement
|
5314 | | | | |
|
5315 | |-------------|-------------|-----|
|
5316 | | `CurrencyId` | Numeric | |
|
5317 | | `CurrencyName` | Text | nullable |
|
5318 | | `CurrencySymbol` | Text | nullable |
|
5319 | | `Date` | DateTime | nullable |
|
5320 | | `GL_Amount` | Numeric | nullable |
|
5321 | | `GL_Description` | Text | nullable |
|
5322 | | `GL_Entry_RecID` | Numeric | |
|
5323 | | `LastUpdate` | DateTime | |
|
5324 | | `Owner_Level_Name` | Text | nullable |
|
5325 | | `Owner_Level_RecID` | Numeric | nullable |
|
5326 | | `RecID` | Text | nullable |
|
5327 | | `RecType` | Text | |
|
5328 | | `UpdatedBy` | Text | |
|
5329 | | `Vendor_Invoice_Date` | DateTime | nullable |
|
5330 | | `Vendor_Invoice_Number` | Text | nullable |
|
5331 | | `Vendor_Name` | Text | nullable |
|
5332 | | `Vendor_RecID` | Numeric | nullable |
|
5333 |
|
5334 | #### UserDefinedEntryType
|
5335 | | | | |
|
5336 | |-------------|-------------|-----|
|
5337 | | `SF_Entry_Name` | Text | nullable |
|
5338 | | `SF_Entry_Type_ID` | Text | |
|
5339 | | `SF_Entry_Type_RecID` | Numeric | |
|
5340 |
|
5341 | #### UserDefinedField
|
5342 | | | | |
|
5343 | |-------------|-------------|-----|
|
5344 | | `Button_Url` | Text | nullable |
|
5345 | | `Caption` | Text | |
|
5346 | | `Created_By` | Text | |
|
5347 | | `Date_Created_UTC` | DateTime | |
|
5348 | | `Full_View_Sort_Order` | Numeric | |
|
5349 | | `Full_View_Visible_Flag` | Boolean | |
|
5350 | | `Inactive_Flag` | Boolean | |
|
5351 | | `Last_Update_UTC` | DateTime | |
|
5352 | | `Multiline_Flag` | Boolean | |
|
5353 | | `Multiline_Order` | Numeric | nullable |
|
5354 | | `Nbr_Decimals` | Numeric | nullable |
|
5355 | | `PodId` | Numeric | |
|
5356 | | `Read_Only_Flag` | Boolean | |
|
5357 | | `Required_Flag` | Boolean | |
|
5358 | | `SF_Entry_TypeIdentifier` | Text | |
|
5359 | | `SF_Field_TypeIdentifier` | Text | |
|
5360 | | `ScreenIdentifier` | Text | |
|
5361 | | `Time_Zone` | Text | nullable |
|
5362 | | `Tooltip` | Text | nullable |
|
5363 | | `Updated_By` | Text | |
|
5364 | | `User_Defined_Field_RecID` | Numeric | |
|
5365 |
|
5366 | #### UserDefinedFieldBillingUnits
|
5367 | | | | |
|
5368 | |-------------|-------------|-----|
|
5369 | | `Billing_Unit_RecID` | Numeric | |
|
5370 | | `Last_Update_UTC` | DateTime | |
|
5371 | | `Updated_By` | Text | |
|
5372 | | `User_Defined_Field_Billing_Unit_RecID` | Numeric | |
|
5373 | | `User_Defined_Field_RecID` | Numeric | |
|
5374 |
|
5375 | #### UserDefinedFieldOption
|
5376 | | | | |
|
5377 | |-------------|-------------|-----|
|
5378 | | `Default_Flag` | Boolean | |
|
5379 | | `Last_Update_UTC` | DateTime | |
|
5380 | | `Sort_Order` | Numeric | |
|
5381 | | `Time_Zone` | Text | nullable |
|
5382 | | `Updated_By` | Text | |
|
5383 | | `User_Defined_Field_Option` | Text | |
|
5384 | | `User_Defined_Field_Option_RecID` | Numeric | |
|
5385 | | `User_Defined_Field_RecID` | Numeric | |
|
5386 |
|
5387 | #### UserDefinedFieldOwnerLevels
|
5388 | | | | |
|
5389 | |-------------|-------------|-----|
|
5390 | | `Last_Update_UTC` | DateTime | |
|
5391 | | `Owner_Level_RecID` | Numeric | |
|
5392 | | `Updated_By` | Text | |
|
5393 | | `User_Defined_Field_Owner_Level_RecID` | Numeric | |
|
5394 | | `User_Defined_Field_RecID` | Numeric | |
|
5395 |
|
5396 | #### UserDefinedFieldType
|
5397 | | | | |
|
5398 | |-------------|-------------|-----|
|
5399 | | `Config_Flag` | Boolean | |
|
5400 | | `Custom_Field_Flag` | Boolean | |
|
5401 | | `Decimals_Flag` | Boolean | nullable |
|
5402 | | `Default_Decimals` | Numeric | nullable |
|
5403 | | `Display_Info` | Text | nullable |
|
5404 | | `Entry_Type_Flag` | Boolean | nullable |
|
5405 | | `Field_Base_Type` | Text | |
|
5406 | | `SF_Field_Type_ID` | Text | |
|
5407 | | `SF_Field_Type_RecID` | Numeric | |
|
5408 | | `SF_Name` | Text | nullable |
|
5409 |
|
5410 | #### UserDefinedRequiredField
|
5411 | | | | |
|
5412 | |-------------|-------------|-----|
|
5413 | | `Display_Flag` | Boolean | |
|
5414 | | `Field_ID` | Text | nullable |
|
5415 | | `Last_Update_UTC` | DateTime | |
|
5416 | | `Pod_RecID` | Numeric | |
|
5417 | | `Required_Flag` | Boolean | |
|
5418 | | `Updated_By` | Text | |
|
5419 | | `User_Defined_Required_Field_RecID` | Numeric | |
|
5420 |
|
5421 | #### Warehouse
|
5422 | | | | |
|
5423 | |-------------|-------------|-----|
|
5424 | | `Billing_Unit_RecID` | Numeric | nullable |
|
5425 | | `BusGroup` | Text | nullable |
|
5426 | | `Company_Address_RecID` | Numeric | nullable |
|
5427 | | `Company_RecID` | Numeric | nullable |
|
5428 | | `Default_Flag` | Boolean | nullable |
|
5429 | | `Inactive_Flag` | Boolean | |
|
5430 | | `Last_Update` | DateTime | |
|
5431 | | `Last_Update_UTC` | DateTime | |
|
5432 | | `Location` | Text | nullable |
|
5433 | | `Location_Xref` | Text | nullable |
|
5434 | | `OverallDefault_Flag` | Boolean | |
|
5435 | | `Owner_Level_RecID` | Numeric | nullable |
|
5436 | | `Time_Zone` | Text | nullable |
|
5437 | | `Updated_By` | Text | nullable |
|
5438 | | `Warehouse_Name` | Text | nullable |
|
5439 | | `Warehouse_RecID` | Numeric | |
|
5440 |
|
5441 | #### WarehouseBin
|
5442 | | | | |
|
5443 | |-------------|-------------|-----|
|
5444 | | `Billing_Unit_RecID` | Numeric | nullable |
|
5445 | | `BusGroup` | Text | nullable |
|
5446 | | `Default_Flag` | Boolean | nullable |
|
5447 | | `Inactive_Flag` | Boolean | |
|
5448 | | `Last_Update` | DateTime | |
|
5449 | | `Last_Update_UTC` | DateTime | |
|
5450 | | `Location` | Text | nullable |
|
5451 | | `Max_Quantity` | Numeric | nullable |
|
5452 | | `Min_Quantity` | Numeric | nullable |
|
5453 | | `Overflow_Bin` | Numeric | nullable |
|
5454 | | `Owner_Level_RecID` | Numeric | nullable |
|
5455 | | `Time_Zone` | Text | nullable |
|
5456 | | `Updated_By` | Text | nullable |
|
5457 | | `Warehouse_Bin_Desc` | Text | nullable |
|
5458 | | `Warehouse_Bin_Height` | Text | nullable |
|
5459 | | `Warehouse_Bin_Length` | Text | nullable |
|
5460 | | `Warehouse_Bin_RecID` | Numeric | |
|
5461 | | `Warehouse_Bin_Weight` | Numeric | nullable |
|
5462 | | `Warehouse_Bin_Width` | Text | nullable |
|
5463 | | `Warehouse_RecID` | Numeric | nullable |
|
5464 |
|
5465 | #### WorkRoles
|
5466 | | | | |
|
5467 | |-------------|-------------|-----|
|
5468 | | `Activity_Class_RecID` | Numeric | |
|
5469 | | `Hourly_Cost` | Numeric | nullable |
|
5470 | | `Hourly_Rate` | Numeric | nullable |
|
5471 | | `Inactive_Flag` | Boolean | |
|
5472 | | `Integration_Xref` | Text | nullable |
|
5473 | | `Last_Update` | DateTime | |
|
5474 | | `Last_Update_UTC` | DateTime | |
|
5475 | | `Time_Zone` | Text | nullable |
|
5476 | | `Updated_By` | Text | nullable |
|
5477 | | `taxexempt_flag` | Boolean | |
|
5478 | | `work_role` | Text | |
|
5479 |
|
5480 | #### WorkRolesLocation
|
5481 | | | | |
|
5482 | |-------------|-------------|-----|
|
5483 | | `Activity_Class_Loc_RecID` | Numeric | |
|
5484 | | `Activity_Class_RecID` | Numeric | |
|
5485 | | `Hourly_Rate` | Numeric | nullable |
|
5486 | | `Last_Update` | DateTime | nullable |
|
5487 | | `Owner_Level_RecID` | Numeric | |
|
5488 | | `Time_Zone` | Text | nullable |
|
5489 | | `Updated_By` | Text | nullable |
|
5490 |
|
5491 | #### WorkTypes
|
5492 | | | | |
|
5493 | |-------------|-------------|-----|
|
5494 | | `Act_Default_Flag` | Boolean | nullable |
|
5495 | | `Activity_Type_RecID` | Numeric | |
|
5496 | | `Billable_Flag` | Boolean | |
|
5497 | | `Cost_Multiplier` | Numeric | nullable |
|
5498 | | `Default_Flag` | Boolean | |
|
5499 | | `Hours_Max` | Numeric | nullable |
|
5500 | | `Hours_Min` | Numeric | nullable |
|
5501 | | `Inactive_Flag` | Boolean | |
|
5502 | | `Integration_Xref` | Text | nullable |
|
5503 | | `Last_Update` | DateTime | nullable |
|
5504 | | `Multiplier_Flag` | Boolean | |
|
5505 | | `Rate_Type` | Text | nullable |
|
5506 | | `Round_Bill_Hrs` | Numeric | nullable |
|
5507 | | `TimeAccrual_Type_ID` | Text | nullable |
|
5508 | | `Time_Zone` | Text | nullable |
|
5509 | | `Updated_By` | Text | nullable |
|
5510 | | `Utilization_Flag` | Boolean | |
|
5511 | | `invoice_flag` | Boolean | |
|
5512 | | `rate` | Numeric | nullable |
|
5513 | | `work_type` | Text | |
|
5514 |
|
5515 |
|