Search Results

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...

Full column listings for the 3 key tables in this category. APPOINTMENT (100 columns) # Column Type Length Nullable Default 1 APid int NO 2 APunum int YES ((0)) 3 APType int YES ((0)) 4 APFaultid int YES ((0)) 5 APsubject nvarchar 4000 YES ...

All 26 tables in the Users & Contacts category. Table Type Columns Key PORTALLOG BASE TABLE 10 PORTALLOGTYPE BASE TABLE 2 PORTALRESETPASSWORD BASE TABLE 6 PortalAuth BASE TABLE 8 USERADDRESS BASE TABLE 2 USERANALYZER BASE TABLE 9 USERD...

All 46 tables in the Ticket Configuration category. Table Type Columns Key CATEGORYDETAIL BASE TABLE 14 KEY CATEGORYRESTRICTION BASE TABLE 12 ChildRequestType BASE TABLE 3 FLOWDETAIL BASE TABLE 49 FLOWHEADER BASE TABLE 8 FLOWSUBDETAIL BASE...