UNPKG

198 kBMarkdownView Raw
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