Updated: 2009-09-16

Version: Control 4.4

This document displays a table showing the linkages between ClassTypeIDs, the Class of the object, and the database table that it is stored in.

Table

~ ClassTypeID~ Object Type~ System Data~ Database Table
-1No Class Type
100ActionYes
200Navigation ItemYes
300UnitYes
350Title sql_structure_-_element_table
360System Data
400Printer Device Type
500System ImageYes
610Explorer Query
700Store Constant sql_structure_-_storeconstant_table
701Store Constant Category sql_structure_-_element_table
800Virtual QueryYesSQL Structure - SystemData Table
801SQL Function
850Generic Template
900Web Browser
1000Store sql_structure_-_store_table
1100Option sql_structure_-_useroption_table
1101System Option sql_structure_-_useroption_table
1301Commission Rate sql_structure_-_commissionrate_table
1500Pricing Graphic sql_structure_-_pricinggraphic_table
1501System Graphic
1502Graphic sql_structure_-_graphic_table
1503Payment Account Graphic
1600Selection List Category sql_structure_-_pricingelement_table
1601Selection List sql_structure_-_selectionlist_table
1602Selection List Item sql_structure_-_selectionlistitem_table
1750Activity Pick List sql_structure_-_element_table
1751Activity Pick List Item sql_structure_-_element_table
1760Calendar Link sql_structure_-_calendarlink_table
1770Calendar View
1780Calendar Status sql_structure_-_calendarstatus_table
1800Activity Time Span sql_structure_-_activitytimespan_table
1810Signature Usage Type sql_structure_-_element_table
1811Signature Activity
2000Company sql_structure_-_account_table
2001Company UDF Value
2100Vendor
2500Service Contract Type sql_structure_-_servicecontracttype_table
2600Service Ticket Type sql_structure_-_element_table
2700Service Ticket Priority sql_structure_-_serviceticketpriority_table
3000Company Contact sql_structure_-_accountcontact_table
3400Employee Group sql_structure_-_employeegroup_table
3500Employee sql_structure_-_employee_table
3501Employee Contact sql_structure_-_employeecontact_table
4000Address Type sql_structure_-_element_table
4001Address sql_structure_-_address_table
4002Address Link sql_structure_-_addresslink_table
4100Phone Number sql_structure_-_phonenumber_table
4101Phone Number Type sql_structure_-_element_table
5000Tax Class sql_structure_-_taxclass_table
5002Tax Link sql_structure_-_taxlink_table
5003Postal Code Tax Class sql_structure_-_postalcodetaxclass_table
5004Postal Code Tax Class List sql_structure_-_element_table
5005Product Taxability Code sql_structure_-_producttaxabilitycode_table
5006State Tax Exempt Link
5500Marking List sql_structure_-_element_table
5501Marking List Item sql_structure_-_marketinglistitem_table
5511Prospect (Company) Stage sql_structure_-_element_table
5512Client (Company) Stage sql_structure_-_element_table
5600Disposition List sql_structure_-_element_table
5601Disposition sql_structure_-_element_table
6000User sql_structure_-_username_table
6002Security Right
6003Security Link SQL Structure - SecurityLink Table
6004Security Right Action
6005Lock Time Out
6006WebPro Security Right Action
6010Security Right Template sql_structure_-_element_table
6020Security Right Change sql_structure_-_securityrightchange_table
6030Partial Security Right Template
6040Partial Security Right
6050WebPro Security Right Template sql_structure_-_element_table
6060WebPro Security Right
6070WebPro Security Right Change
6130Shipping Methods sql_structure_-_element_table
7000Spped Note sql_structure_-_speednote_table
7100PO Speed Note sql_structure_-_speednote_table
7500Standard Pricing Formula sql_structure_-_speednote_table
8000GL Account Group sql_structure_-_glaccount_table
8001GL Account Item sql_structure_-_glaccount_table
8002Payment Method sql_structure_-_paymentaccount_table
8050Computed Account Group? sql_structure_-_glaccount_table
8051Computed Cost Account? sql_structure_-_glaccount_table
8055Computed Cost Account? sql_structure_-_glaccount_table
8100Bill Payment Method sql_structure_-_paymentaccount_table
8900GL Entry sql_structure_-_gl_table
8901Inventory Log SQL Structure - Depricated? Table|
8911Daily Closeout sql_structure_-_journal_table, sql_structure_-_closeout_table
8912Monthly Closeout sql_structure_-_journal_table, sql_structure_-_closeout_table
8913Yearly Closeout sql_structure_-_journal_table, sql_structure_-_closeout_table
8914Export Closeout sql_structure_-_journal_table, sql_structure_-_closeout_table
8915Royalty Closeout sql_structure_-_journal_table, sql_structure_-_closeout_table
8916CC Settlement sql_structure_-_journal_table, sql_structure_-_closeout_table
8917Weekly Closeout sql_structure_-_journal_table, sql_structure_-_closeout_table
8918Quarterly Closeout sql_structure_-_journal_table, sql_structure_-_closeout_table
8919Session Closeout sql_structure_-_journal_table, sql_structure_-_closeout_table
8951Element
9000Contact Manager
9201Recurring Activity sql_structure_-_recurringactivity_table
9202Recurring Macro Activity sql_structure_-_recurringactivity_table
9750Account Reconciliation sql_structure_-_journal_table
10000Order/Estimate/Template/Service Tickets sql_structure_-_transheader_table
10001Order/Estimate/Template/Service Tickets History sql_structure_-_transheaderhistory_table
10100Transaction Detail sql_structure_-_transdetail_table
10101Transaction Detail History SQL Structure - TransDetailHistory Table
10200Transaction Modifier sql_structure_-_transmod_table
10201Transaction Modifier History SQL Structure - TransModHistory Table
10300Transaction Part sql_structure_-_transpart_table
10301Transaction Part History SQL Structure - TransPartHistory Table
10400Transaction Variation sql_structure_-_transvariation_table
10401Transaction Variation History sql_structure_-_transvariationhistory_table
10500Transaction Tax sql_structure_-_transtax_table
10501Transaction Tax History SQL Structure - TransTaxHistory Table
10600Transaction Detail Graphic sql_structure_-_transdetailgraphic_table
10601Transaction Detail Graphic History SQL Structure - TransDetailGraphicHistory Table
11000Purchase Order/Bill/Receiving Document sql_structure_-_transheader_table
11001Purchase Order/Bill/Receiving Document History sql_structure_-_transheaderhistory_table
11100PO Detail sql_structure_-_vendortransdetail_table
11101PO Detail History SQL Structure - VendorTransDetailHistory Table
11200PO Part
11201PO Part History
11300PO Variation sql_structure_-_transvariation_table
11301PO Variation History sql_structure_-_transvariationhistory_table
12000Product sql_structure_-_customergoodsitem_table
12001Product UDF sql_structure_-_productuserfield_table
12010Modifier sql_structure_-_customergoodsitem_table
12014Part sql_structure_-_part_table
12016Part Conversion Item sql_structure_-_partinventoryconversion_table
12020Product Category sql_structure_-_pricingelement_table
12030Modifier Category sql_structure_-_pricingelement_table
12035Part Category sql_structure_-_pricingelement_table
12040Product Pricing Plan sql_structure_-_pricingplan_table
12041Modifier Pricing Plan sql_structure_-_pricingplan_table
12050Pricing Plan Type sql_structure_-_pricingelement_table
12051Pricing Level sql_structure_-_pricinglevel_table
12052Promotion sql_structure_-_promotion_table
12053Sales Goal Month sql_structure_-_salesgoal_table
12054Sales Goal Year sql_structure_-_salesgoal_table
12060Product Tax Exempt Link
12070Product/Modifier Link sql_structure_-_prodmodlink_table
12071Product/Part Link sql_structure_-_goodsitempartlink_table
12072Modifier/Part Link sql_structure_-_goodsitempartlink_table
12074Part/Employee Link
12075Part Instance sql_structure_-_pricingelement_table
12076Catalog Item sql_structure_-_catalogitem_table
12077Assembly Link sql_structure_-_assemblylink_table
12080Pricing Method
12090Pricing Method Parameter
12095Pricing Method Table
12100Pricing Family sql_structure_-_pricingelement_table
12200Inventory sql_structure_-_inventory_table
12500Quick Product sql_structure_-_quickproduct_table
12501Quick Product List sql_structure_-_pricinglink_table
13000Commission Plan sql_structure_-_element_table, SQL Structure - CommissionPlan Table
14020Goods Item Parameter Link sql_structure_-_pricinglink_table
14030Transaction Detail Parameter sql_structure_-_transdetailparam_table
14031Transaction Detail Parameter History SQL Structure - TransDetailParamHistory Table
14040Pricing Table sql_structure_-_pricingtable_table
14041Pricing Table Element SQL Structure - Depricated Table
14045Pricing Table Category sql_structure_-_pricingelement_table
14050Discount Table sql_structure_-_discounttable_table
14051Discount Table Item sql_structure_-_discounttableitem_table
14500Variable Category sql_structure_-_pricingelement_table
14505Variable sql_structure_-_variable_table
14510Goods Item Variable Link sql_structure_-_pricinglink_table
14515Pricing Plan Variable sql_structure_-_variable_table
15000Input Template/Pricing Setup sql_structure_-_iotemplate_table
15001Input Template Category sql_structure_-_pricingelement_table
15010Output Template sql_structure_-_iotemplate_table
15011Output Template Category sql_structure_-_pricingelement_table
15020Canvas
15021Canvas Category
16000Payment Terms sql_structure_-_paymentterms_table
16100Payment Plan sql_structure_-_paymentplan_table
16110Scheduled Payment sql_structure_-_scheduledpayment_table
17000Crystal System Report
17001Report Template Category
17002Crystal Report Template
17003Report Category
17004Report Item
17006Report Group
17010Action Report Template
17011Word Report Template
17012SMSQR System Report
17100Word System Report
17105SMS System Report
17200Report Menu Change sql_structure_-_reportmenuitem_table
17210Report Menu Item
17220Report Menu Template
17230Report Menu Group sql_structure_-_reportmenuitem_table
17240Action Report Menu Item sql_structure_-_reportmenuitem_table
17250Word Report Menu Item sql_structure_-_reportmenuitem_table
17260SMS Report Menu Item sql_structure_-_reportmenuitem_table
17270Crystal Report Menu Item sql_structure_-_reportmenuitem_table
17280Report Menu BMP
17290SQL Report Menu Item sql_structure_-_reportmenuitem_table
17310System Report Menu Item
17330System Report Menu Group
17340System Action Report Menu Item
17350System Word Report Menu Item
17360System SMS Report Menu Item
17370System Crystal Report Menu Item
17380System SQL Report Menu Item
17500Cyrious Printer Type
17600Custom Report Range
18001Time Clock Status
19000Database Group
19001Database Item
20000Master Payment sql_structure_-_journal_table, sql_structure_-_payment_table
20001Order Payment sql_structure_-_journal_table, sql_structure_-_payment_table
20002Over Payment sql_structure_-_journal_table, sql_structure_-_payment_table
20003Change Return sql_structure_-_journal_table, sql_structure_-_payment_table
20004Order Refund sql_structure_-_journal_table, sql_structure_-_payment_table
20005Credit Refund sql_structure_-_journal_table, sql_structure_-_payment_table
20006Order Credit Memo sql_structure_-_journal_table, sql_structure_-_payment_table
20007Failed Payment sql_structure_-_journal_table, sql_structure_-_payment_table
20008Tip Recorded sql_structure_-_journal_table, sql_structure_-_payment_table
20009Bill Payment sql_structure_-_journal_table, sql_structure_-_payment_table
20010Credit Adjustment sql_structure_-_journal_table
20011Change Over Payment
20015Write Off sql_structure_-_journal_table
20020Finance Charge sql_structure_-_journal_table
20025System Finance Charge sql_structure_-_journal_table
20030CC Activity sql_structure_-_journal_table
20035Journal Entry sql_structure_-_journal_table
20036Deposit sql_structure_-_journal_table
20037Master Bill Payment sql_structure_-_journal_table, sql_structure_-_payment_table
20038Miscellaneous Receipt sql_structure_-_journal_table
20039Vendor Credit Adjustment
20040Master Tip Payout sql_structure_-_journal_table
20041Detail Tip Payout sql_structure_-_journal_table
20050Master Time Card sql_structure_-_journal_table, sql_structure_-_timecard_table
20051Detail Time Card sql_structure_-_journal_table, sql_structure_-_timecard_table
20060Email Activity sql_structure_-_journal_table, sql_structure_-_emailactivity_table
20061Email Activity Template sql_structure_-_journal_table, sql_structure_-_emailactivity_table
20065Note Activity sql_structure_-_journal_table
20070Viewing CC Number Activity sql_structure_-_journal_table
20075JDF Activity
20500Transaction Activity sql_structure_-_journal_table
20505Line Item Activity sql_structure_-_journal_table
20510Company Activity sql_structure_-_journal_table
20515Company Stage Change Activity sql_structure_-_journal_table
20520Transaction Part Usage Activity sql_structure_-_journal_table
20521Station Activity sql_structure_-_journal_table
20522Proof Approval Activity sql_structure_-_journal_table
20530Inventory Adjustment sql_structure_-_journal_table
20531Inventory TransPartDetail
20535Global Inventory Adjustment Activity sql_structure_-_journal_table
20536Inventory Division Summary Adjustment Header
20540Import Activity sql_structure_-_journal_table
20550Global Cost Adjustment Activity sql_structure_-_journal_table
20560Part Usage Processor
20565Part Usage Card sql_structure_-_journal_table, sql_structure_-_partusagecard_table
20566Inventory Transfer Header
20567Inventory Transfer Detail
20570Backup Activity sql_structure_-_journal_table
20580Service Item sql_structure_-_journal_table
20590Report Activity sql_structure_-_journal_table
20600Login Activity sql_structure_-_journal_table
20610Logout Activity sql_structure_-_journal_table
20620Authentication Activity sql_structure_-_journal_table
20630EULA Terms Activity
20700Reservation Activity sql_structure_-_journal_table
21000Activity Viewer
21100Contact Activity sql_structure_-_journal_table, sql_structure_-_contactactivity_table
21150Contact Activity Template sql_structure_-_journal_table, sql_structure_-_contactactivity_table
21200Macro Activity sql_structure_-_journal_table, sql_structure_-_ruleactivity_table
21250Macro Activity Template sql_structure_-_journal_table, sql_structure_-_ruleactivity_table
21300Work Assignment sql_structure_-_journal_table, sql_structure_-_contactactivity_table
21350Work Assignment Template sql_structure_-_journal_table, sql_structure_-_contactactivity_table
22000User Field sql_structure_-_userfielddef_table
22001User Field Layout sql_structure_-_userfieldlayout_table
22300CCCS Configuration
22500Advanced Query Node
22501Advanced Query Criteria
22502Advanced Query Boolean Node
22503Advanced Query Table
22504Advanced Query Criteria Category
22505Criteria Builder Category
22506Advanced Query Macro
22507User Field Builder Category
22508DB Criteria Builder Category
22509Static Criteria Builder Category
22510Advanced Query Visual Element
22600Advanced Query Manager sql_structure_-_advquery_table
22610Advanced Query Manager Category
22700User Query Criteria sql_structure_-_advquerynode_table
22701User Query Boolean Node sql_structure_-_advquerynode_table
22702User Query Table sql_structure_-_advquerynode_table
22703User Query Macro sql_structure_-_advquerynode_table
23000Macro sql_structure_-_rulemacro_table
23005Macro Category
23110Contact Acitvity Action sql_structure_-_journal_table, sql_structure_-_ruleaction_table
23120Email Action sql_structure_-_journal_table, sql_structure_-_ruleaction_table
23130Report Action sql_structure_-_journal_table, sql_structure_-_ruleaction_table
23141UDF Action sql_structure_-_journal_table, sql_structure_-_ruleaction_table
23144Popup Action sql_structure_-_journal_table, sql_structure_-_ruleaction_table
23146Transaction Action sql_structure_-_journal_table, sql_structure_-_ruleaction_table
23148Another Macro Action sql_structure_-_journal_table, sql_structure_-_ruleaction_table
23150Company Activity Action sql_structure_-_journal_table, sql_structure_-_ruleaction_table
23160Service Contract Action sql_structure_-_journal_table, sql_structure_-_ruleaction_table
23170Work Assignment Action sql_structure_-_journal_table, sql_structure_-_ruleaction_table
23180Transaction Update Action sql_structure_-_journal_table, sql_structure_-_ruleaction_table
23181Transaction Station Action sql_structure_-_journal_table, sql_structure_-_ruleaction_table
23182Company Stage Action sql_structure_-_journal_table, sql_structure_-_ruleaction_table
24001Groom
24002Matchmaker
24003SSLIP's Client
24010SSLIP's Log
24011HoneyDoLog
24020SSLIP's Region
24021SSLIP's User
24030HoneyDoSQLBatch
24031HoneyDoAuthorize
24040HoneyDoGroup
25000Language
25010Translation Item
26000Line Item Stage sql_structure_-_element_table
26001Service Ticket Stage sql_structure_-_element_table
26002Vendor Stage sql_structure_-_element_table
26100Station sql_structure_-_station_table
30000Course
30030Course Event sql_structure_-_courseevent_table
30050Course Contact Link sql_structure_-_coursecontactlink_table
30100Course Section Type sql_structure_-_pricingelement_table
30110Course Section
30200Contract Period sql_structure_-_contractperiod_table
31000Dashboard sql_structure_-_dashboard_table
31001System Dashboard
31002Dashboard Instrument
35250Payroll sql_structure_-_journal_table
35300Payroll Payment Summary sql_structure_-_journal_table, sql_structure_-_payment_table
35301Payroll Payment Detail sql_structure_-_journal_table, sql_structure_-_payment_table


You could leave a comment if you were logged in.