Search Results

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

All 33 tables in the Items & Products category. Table Type Columns Key ITEM BASE TABLE 125 KEY ITEMASSEMBLY BASE TABLE 6 ITEMPRICE BASE TABLE 4 ITEMRESERVE BASE TABLE 8 ITEMSUPPLIER BASE TABLE 10 ItemAccountsLink BASE TABLE 17 ItemBundl...

Full column listings for the 5 key tables in this category. AUTOASSIGN (52 columns) # Column Type Length Nullable Default 1 auid int NO 2 auseq int YES 3 auarea int YES 4 ausite int YES 5 aurequesttype int YES 6 ausection nvarchar 40...

All 28 tables in the Automation & Workflows category. Table Type Columns Key APPROVALPROCESS BASE TABLE 5 APPROVALPROCESSRULE BASE TABLE 20 APPROVALPROCESSRULECRITERIA BASE TABLE 10 APPROVALPROCESSSTEP BASE TABLE 55 AUTOASSIGN BASE TABLE 52 ...

Full column listings for the 4 key tables in this category. CONN (25 columns) # Column Type Length Nullable Default 1 Dsite smallint NO 2 Ddevnum smallint NO 3 Dtype smallint YES 4 Dconnector bit NO ((0)) 5 Dtx smallint YES 6 Dty smal...

All 27 tables in the Assets & Configuration Items category. Table Type Columns Key ASSETFIELDCOLUMN BASE TABLE 5 AssetAttachmentMaint BASE TABLE 7 AssetMeters BASE TABLE 7 CONN BASE TABLE 25 KEY CONNCHANGE BASE TABLE 8 KEY ConfigCommit BASE...

Full column listings for the 3 key tables in this category. EMAILRULE (61 columns) # Column Type Length Nullable Default 1 ERid int NO 2 ERType int YES ((0)) 3 ERDesc nvarchar 4000 YES 4 ERPop3ServerID int YES ((0)) 5 ERSubject nvarchar 400...

All 50 tables in the Email & Communication category. Table Type Columns Key BulkEmail BASE TABLE 19 BulkEmailUser BASE TABLE 8 CANNEDTEXT BASE TABLE 14 CANNEDTEXTPERMISSION BASE TABLE 4 CannedTextFavourites BASE TABLE 3 CannedTextTag BASE...