Search Results

All 19 tables in the Audit & Logging category. Table Type Columns Key AUDIT BASE TABLE 15 KEY AUDITEVENT BASE TABLE 7 AUDITFAULT BASE TABLE 11 AnonRequestLog BASE TABLE 5 AuditPasswordField BASE TABLE 6 BackgroundTask BASE TABLE 14 CUST...

Full column listings for the 1 key table in this category. Licence (38 columns) # Column Type Length Nullable Default 1 LID int NO 2 LType int NO ((0)) 3 LDesc nvarchar 500 YES 4 LCount int NO ((0)) 5 Larea int NO ((0)) 6 LSite int NO (...

All 7 tables in the Software & Licences category. Table Type Columns Key AzureLicences BASE TABLE 3 LICENCEHISTORY BASE TABLE 12 Licence BASE TABLE 38 KEY LicenceChange BASE TABLE 8 LicenceMatch BASE TABLE 4 LicenceRole BASE TABLE 4 Lic...

Full column listings for the 3 key tables in this category. CONTRACT (19 columns) # Column Type Length Nullable Default 1 CNid int NO 2 CNcompanynum int YES 3 cnphone1 nvarchar 4000 YES 4 cnphone2 nvarchar 4000 YES 5 cnphone3 nvarchar 4000...

All 16 tables in the Contracts & Recurring category. Table Type Columns Key CONTRACT BASE TABLE 19 KEY CONTRACTDETAIL BASE TABLE 30 KEY CONTRACTHEADER BASE TABLE 98 KEY CONTRACTPERIODHISTORY BASE TABLE 8 CONTRACTPLAN BASE TABLE 9 CONTRACTPLA...

Full column listings for the 3 key tables in this category. MileStone (17 columns) # Column Type Length Nullable Default 1 MSTid int NO 2 MSTFaultId int YES 3 MSTName nvarchar 1000 YES 4 MSTSequence int YES 5 MSTStartDate datetime YES ...

All 8 tables in the Projects & Milestones category. Table Type Columns Key MileStone BASE TABLE 17 KEY MileStoneDependency BASE TABLE 3 PROJECTNOTE BASE TABLE 5 KEY ProjectSetupLines BASE TABLE 10 TASK BASE TABLE 10 KEY TaskMonitor BASE TABL...

Full column listings for the 2 key tables in this category. LIVECHATHEADER (34 columns) # Column Type Length Nullable Default 1 LCHid int NO 2 LCHname nvarchar 255 YES 3 LCHsectionid int YES 4 LCHistech bit YES 5 LCHisclosed bit YES ((0)...

All 17 tables in the Live Chat category. Table Type Columns Key CHATMESSAGE BASE TABLE 7 ChatBanner BASE TABLE 6 ChatInputSuggestion BASE TABLE 5 ChatMatchingData BASE TABLE 5 ChatPopupMessage BASE TABLE 4 ChatProfile BASE TABLE 55 Cha...

Full column listings for the 2 key tables in this category. CHANGESEQ (40 columns) # Column Type Length Nullable Default 1 id int NO 2 lastseq int YES 3 faults int YES 4 actions int YES 5 requesttype int YES 6 tstatus int YES 7 s...

All 13 tables in the Releases & Change Management category. Table Type Columns Key CABHEADER BASE TABLE 9 CABMEMBER BASE TABLE 9 CHANGELG BASE TABLE 19 CHANGESEQ BASE TABLE 40 KEY CabRole BASE TABLE 6 RELEASE BASE TABLE 20 KEY RELEASECOM...

Full column listings for the 4 key tables in this category. HOLIDAYS (18 columns) # Column Type Length Nullable Default 1 Hid int NO 2 Hdate datetime NO 3 hdesc nvarchar 4000 YES 4 Hduration float YES ((0)) 5 Htype int YES ((0)) 6 HTech...

All 20 tables in the SLA & Service Level category. Table Type Columns Key Downtime BASE TABLE 9 HOLIDAYS BASE TABLE 18 KEY SERV BASE TABLE 2 SERVICECATALOG BASE TABLE 20 SERVICECATALOGLINES BASE TABLE 4 SERVICECATALOGTYPE BASE TABLE 2 S...

All 25 tables in the Knowledge Base category. Table Type Columns Key FAQCLIENT BASE TABLE 2 FAQCompany BASE TABLE 2 FAQLISTDET BASE TABLE 3 FAQLISTHEAD BASE TABLE 15 FAQOrg BASE TABLE 2 FAQRole BASE TABLE 4 FAQSite BASE TABLE 2 FAQS...

All 44 tables in the Agents & Technicians category. Table Type Columns Key AgentCheckIn BASE TABLE 4 AgentLogin BASE TABLE 5 AgentStatusChangeLog BASE TABLE 6 AgentStatusReassignMapping BASE TABLE 4 SECTIONDETAIL BASE TABLE 50 KEY SECTIONE...

All 29 tables in the Clients & Sites category. Table Type Columns Key ADDRESSBOOK BASE TABLE 12 ADDRESSSTORE BASE TABLE 17 AREA BASE TABLE 332 KEY AREAFIELD BASE TABLE 4 AREAITEM BASE TABLE 26 AREANOTE BASE TABLE 22 AREAORGANISATION BAS...

All 39 tables in the Tickets (Faults) category. Table Type Columns Key BudgetType BASE TABLE 4 ConfirmClosure BASE TABLE 7 EcommerceOrder BASE TABLE 12 EcommerceOrderFault BASE TABLE 3 FAULTAPPROVAL BASE TABLE 30 KEY FAULTARC BASE TABLE 19...

Full column listings for the 1 key table in this category. USERS (217 columns) # Column Type Length Nullable Default 1 Usite float NO 2 uusername nvarchar 255 NO 3 uextn nvarchar 4000 YES 4 umobile nvarchar 4000 YES 5 ufax nvarchar 4000 YES...