Search Results

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

All 20 tables in the Time Tracking & Scheduling category. Table Type Columns Key APPOINTMENT BASE TABLE 100 KEY ASSIGNSCHEDULE BASE TABLE 11 AppointmentReminderEmails BASE TABLE 4 AppointmentReminderSetup BASE TABLE 2 AppointmentTypeRequestTy...

All 34 tables in the Custom Fields & Configuration category. Table Type Columns Key CONTROL BASE TABLE 808 KEY CONTROL2 BASE TABLE 827 CONTROL3 BASE TABLE 879 CUSTOMFIELDUPDATE BASE TABLE 6 CUSTOMFIELDVALUERESTRICTIONS BASE TABLE 6 CUSTOMF...

Full column listings for the 2 key tables in this category. QUOTATIONDETAIL (62 columns) # Column Type Length Nullable Default 1 QDid int NO 2 QDProductCode nvarchar 4000 YES 3 QDDesc nvarchar 4000 YES 4 QDPrice float YES ((0)) 5 QDCostPric...

All 11 tables in the Quotes & Opportunities category. Table Type Columns Key CALLHISTORY BASE TABLE 7 CALLLOG BASE TABLE 25 CALLOUTCOME BASE TABLE 28 DCRM BASE TABLE 5 OPPCLOSURECATEGORYFIELDS BASE TABLE 4 QUALIFICATION BASE TABLE 8 QU...

Full column listings for the 4 key tables in this category. ORDERHEAD (59 columns) # Column Type Length Nullable Default 1 OHid int NO 2 OHsitenum int YES 3 OHstatus int YES 4 OHnote ntext 1073741823 YES 5 OHusername nvarchar 4000 YES ...

All 16 tables in the Supplier Orders & Purchasing category. Table Type Columns Key CONSIGNMENTDETAIL BASE TABLE 16 CONSIGNMENTHEADER BASE TABLE 11 GOODINLINE BASE TABLE 6 GOODSINHEAD BASE TABLE 6 ORDERHEAD BASE TABLE 59 KEY ORDERLINE BASE ...

Full column listings for the 1 key table in this category. KBENTRY (318 columns) # Column Type Length Nullable Default 1 id int NO 2 abstract nvarchar 4000 YES 3 description nvarchar -1 YES 4 resolution nvarchar -1 YES 5 datecreated datetim...

Full column listings for the 2 key tables in this category. ITEM (125 columns) # Column Type Length Nullable Default 1 Iid int NO 2 Istatus int YES 3 Igeneric int YES 4 Inote nvarchar -1 YES 5 idesc nvarchar 4000 YES 6 idesc2 nvarchar ...