Search Results

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

Full column listings for the 2 key tables in this category. ANALYZERPROFILE (99 columns) # Column Type Length Nullable Default 1 APid int NO 2 APTitle nvarchar 4000 YES 3 APSQL ntext 1073741823 YES 4 APEmailsubject ntext 1073741823 YES 5 AP...

All 63 tables in the Reports & Analytics category. Table Type Columns Key ANALYZERFILTER BASE TABLE 10 ANALYZERPROFILE BASE TABLE 99 KEY ANALYZERPROFILECOLUMN BASE TABLE 16 ANALYZERSUMMARYCOL BASE TABLE 7 ANALYZERSUMMARYGROUP BASE TABLE 4 ...

Full column listings for the 4 key tables in this category. SECTIONDETAIL (50 columns) # Column Type Length Nullable Default 1 SDid int NO 2 SDSectionName nvarchar 200 YES 3 SDWorkingHoursBeforeAlert float YES ((0)) 4 SDEmailAddress nvarchar 4...

Full column listings for the 3 key tables in this category. ACTARC (68 columns) # Column Type Length Nullable Default 1 Faultid int NO 2 actionnumber int NO 3 Actoutcome nvarchar 4000 YES 4 who nvarchar 4000 YES 5 Whe_ datetime YES 6 n...

All 7 tables in the Actions (Ticket Notes) category. Table Type Columns Key ACT BASE TABLE 5 ACTARC BASE TABLE 68 KEY ACTIONS BASE TABLE 199 KEY ACTYPE BASE TABLE 11 KEY ActionReaction BASE TABLE 5 ActionRead BASE TABLE 4 Action_View VIEW...

Full column listings for the 13 key tables in this category. FAULTAPPROVAL (30 columns) # Column Type Length Nullable Default 1 FAid int NO 2 FAseq int NO 3 FAActionNumber int YES ((0)) 4 FAEmailstatus int YES ((0)) 5 FAResult int YES ((0...

Full column listings for the 5 key tables in this category. CHARGERATE (27 columns) # Column Type Length Nullable Default 1 CRid int NO 2 CRarea int NO 3 CRchargeid int NO 4 CRstartdate datetime NO 5 CRrate float YES ((0)) 6 CRorg int...

All 40 tables in the Invoicing & Billing category. Table Type Columns Key ACCOUNTSINTERFACE BASE TABLE 19 BILLINGREPORT BASE TABLE 21 BillingAudit BASE TABLE 5 BillingPlanCriteria BASE TABLE 10 CHARGECD BASE TABLE 3 CHARGERATE BASE TABLE ...

Full column listings for the 5 key tables in this category. AREA (332 columns) # Column Type Length Nullable Default 1 Aarea int NO 2 aareadesc nvarchar 4000 YES 3 Amemo ntext 1073741823 YES 4 Aannounce ntext 1073741823 YES 5 Aannouncedate ...

Full column listings for the 7 key tables in this category. CATEGORYDETAIL (14 columns) # Column Type Length Nullable Default 1 CDid int NO 2 CDCategoryName nvarchar 4000 YES ('') 3 CDType int YES ((0)) 4 CDSLAid int YES ((-1)) 5 CDseriousne...

Full column listings for the 3 key tables in this category. CONTROL (808 columns) # Column Type Length Nullable Default 1 Rseq int NO 2 RDBVersion int YES ((0)) 3 RDBname nvarchar 8 YES 4 RShbitmaps bit NO ((0)) 5 RShMap bit NO ((0)) 6 R...