Tablenumbers

In this article
    An overview of all database tables by table number

    The table numbers do not change and is the numbers you will see in the database when one table is referring to another table. Tables named "Obsolete_x" where removed from CRM 7, but kept in dictionary.

    0    sequence
    1    company
    2    associate
    3    AssociateGroupLink
    4    AssociateHeadingLink
    5    contact
    6    person
    7    address
    8    phone
    9    appointment
    10    document
    11    project
    12    projectmember
    13    sale
    14    contactinterest
    15    personinterest
    16    ziptocity
    17    redletterday
    18    text
    19    country
    20    CountryGroupLink
    21    CountryHeadingLink
    22    preference
    23    selection
    24    selectionmember
    25    SORPublishGroupLink
    26    obsolete_2
    27    obsolete_3
    28    activeuser
    29    traveltransactionlog
    30    travelgeneratedtransaction
    31    traveller
    32    travelcurrent
    33    travelgenerateddatabase
    34    obsolete_4
    35    udcontactSmall
    36    udcontactLarge
    37    MergeMoveLog
    38    area
    39    obsolete_9
    40    areauserassignment
    41    areauserinclusion
    42    satellite
    43    travelidmapping
    44    freetextstopwords
    45    freetextwords
    46    freetextindex
    47    obsolete_5
    48    relationdefinition
    49    RelDefGroupLink
    50    RelDefHeadingLink
    51    relationtarget
    52    relations
    53    History
    54    URL
    55    Email
    56    UserPreference
    57    AddressFormat
    58    Heading
    59    UserGroup
    60    UserGroupLink
    61    Business
    62    BusinessGroupLink
    63    BusinessHeadingLink
    64    Category
    65    CategoryGroupLink
    66    CategoryHeadingLink
    67    Task
    68    TaskGroupLink
    69    TaskHeadingLink
    70    ContInt
    71    ContIntGroupLink
    72    ContIntHeadingLink
    73    PersInt
    74    PersIntGroupLink
    75    PersIntHeadingLink
    76    PersPos
    77    PersPosGroupLink
    78    PersPosHeadingLink
    79    Priority
    80    PriorityGroupLink
    81    PriorityHeadingLink
    82    Prob
    83    ProbGroupLink
    84    ProbHeadingLink
    85    ProjType
    86    ProjTypeGroupLink
    87    ProjTypeHeadingLink
    88    ProjStatus
    89    ProjStatusGroupLink
    90    ProjStatusHeadingLink
    91    PMembType
    92    PMembTypeGroupLink
    93    PMembTypeHeadingLink
    94    MrMrs
    95    MrMrsGroupLink
    96    MrMrsHeadingLink
    97    Credited
    98    CreditedGroupLink
    99    CreditedHeadingLink
    100    Source
    101    SourceGroupLink
    102    SourceHeadingLink
    103    Reason
    104    ReasonGroupLink
    105    ReasonHeadingLink
    106    SearchCat
    107    SearchCatGroupLink
    108    SearchCatHeadingLink
    109    Comptr
    110    ComptrGroupLink
    111    ComptrHeadingLink
    112    Currency
    113    CurrencyGroupLink
    114    CurrencyHeadingLink
    115    ReasonSold
    116    ReasonSoldGroupLink
    117    ReasonSoldHeadingLink
    118    SaleTypeCat
    119    SaleTypeCatGroupLink
    120    SaleTypeCatHeadingLink
    121    SaleStakeholder
    122    StakeholderRole
    123    StakeholderRoleGroupLink
    124    StakeholderRoleHeadingLink
    125    SuggestedAppointment
    126    SuggestedDocument
    127    obsolete_6
    128    obsolete_7
    129    obsolete_8
    130    DocTmpl
    131    DocTmplGroupLink
    132    DocTmplHeadingLink
    133    ExtApp
    134    ExtAppGroupLink
    135    ExtAppHeadingLink
    136    UDList
    137    UDListGroupLink
    138    UDListHeadingLink
    139    UDListDefinition
    140    udpersonSmall
    141    udpersonLarge
    142    udprojectSmall
    143    udprojectLarge
    144    udtempSmall
    145    udtempLarge
    146    UDefField
    147    UDefFieldGL
    148    CacheTables
    149    SaleType
    150    SaleTypeGroupLink
    151    SaleTypeHeadingLink
    152    TabOrder
    153    SystemEvent
    154    ReasonStalled
    155    ReasonStalledGroupLink
    156    ReasonStalledHeadingLink
    157    SaleHist
    158    udsalesmall
    159    udsalelarge
    160    SaleTypeStageLink
    161    OLESubject
    162    OLESubjectText
    163    OLEView
    164    OLEViewText
    165    OLEField
    166    OLEFieldText
    167    OwnerContactLink
    168    FieldLabel
    169    LocaleText
    170    ReporterListDef
    171    RefCounts
    172    RefCountRange
    173    SORTemplate
    174    SORPublish
    175    SORCriteria
    176    SOROperators
    177    SORSection
    178    SORFCT
    179    SORField
    180    SORLabelLayout
    181    foreignapp
    182    foreigndevice
    183    foreignkey
    184    PrefDesc
    185    PrefDescLine
    186    ImportObject
    187    ImportField
    188    ImportRelation
    189    ImportDefault
    190    UsageStats
    191    Role
    192    UserRoleLink
    193    FunctionRight
    194    FunctionRightRoleLink
    195    DataRight
    196    VisibleFor
    197    CounterValue
    198    StatusDef
    199    StatusValue
    200    Publish
    201    SearchCriteria
    202    SearchCriteriaGroup
    203    SearchCriterion
    204    SearchCriterionValue
    205    BinaryObject
    206    BinaryObjectLink
    207    RecurrenceRule
    208    WinPosSize
    209    SuperListColumnSize
    210    LanguageInfo
    211    LanguageInfoCountry
    212    ModuleOwner
    213    ProjectTypeStatusLink
    214    DiaryView
    215    DiaryViewRow
    216    Intent
    217    IntentGroupLink
    218    IntentHeadingLink
    219    Salutation
    220    SalutationGroupLink
    221    SalutationHeadingLink
    222    RejectReason
    223    RejectReasonGroupLink
    224    RejectReasonHeadingLink
    225    AmountClass
    226    AmountClassGroupLink
    227    AmountClassHeadingLink
    228    udappntsmall
    229    udappntlarge
    230    uddocsmall
    231    uddoclarge
    232    AudienceVisibility
    233    ExternalEvent
    234    AudienceLayout
    235    AudienceLayoutLink
    236    AudienceConfig
    237    ModuleLicense
    238    LicenseAssocLink
    239    LicenseSatlLink
    240    ProductVersion
    241    MessageHandler
    242    Message
    243    BatchTask
    244    BatchTaskDefinition
    245    TZLocation
    246    TZStdRule
    247    TZDstRule
    248    BaseTZLocation
    249    WebAppUsage
    250    Credentials
    251    PhoneFormat
    252    TrayApp

    Following tables where new in CRM 7
    253    registry
    254    session_object
    255    config
    256    ticket_attachment
    257    ej_category
    258    ej_message
    259    message_header
    260    message_customers
    261    ticket_status_history
    262    ticket
    263    ticket_status
    264    ticket_customers
    265    invoice
    266    invoice_sum
    267    ticket_log
    268    ticket_log_change
    269    ticket_log_action
    270    category_membership
    271    mail_in_filter
    272    mail_in_uidl
    273    mail_alias
    274    ticket_alert
    275    ticket_priority
    276    reply_template_folder
    277    reply_template
    278    reply_template_attachment
    279    reply_template_body
    280    doc_document
    281    doc_folder
    282    kb_entry
    283    kb_category
    284    kb_attachment
    285    kb_http_link
    286    kb_group
    287    kb_group_entry
    288    kb_entry_keyword
    289    kb_entry_comment
    290    kb_entry_log
    291    kb_category_log
    292    kb_workflow
    293    kb_workflow_access
    294    kb_solution_finder
    295    kb_solution_finder_entry
    296    attachment
    297    login
    298    login_customer
    299    ejuser
    300    timestamps
    301    notify
    302    help
    303    company_domain
    304    extra_fields
    305    extra_tables
    306    hierarchy
    307    extra_menus
    308    extra_tables_result
    309    extra_tables_entry
    310    ms_filter
    311    ms_filter_mail
    312    ms_trashbin
    313    ms_substitute
    314    eab_folder
    315    eab_entry
    316    mail_block
    317    ext_datasource
    318    ext_table
    319    ext_field
    320    cust_lang
    321    cust_category
    322    password_rules
    323    ej_role
    324    role_member
    325    role_category
    326    role_element
    327    role_workflow
    328    element_profile
    329    profile
    330    chat_topic
    331    chat_topic_user
    332    chat_session
    333    chat_message
    334    s_shipment
    335    s_message
    336    s_link
    337    s_link_customer
    338    s_link_customer_statical
    339    s_picture_folder
    340    s_picture_entry
    341    s_washing
    342    s_bounce_shipment
    343    s_washing_list
    344    s_list
    345    s_list_element
    346    s_list_customer
    347    s_shipment_addr
    348    s_list_shipment
    349    s_attachment
    350    s_dyn_criteria
    351    outbox
    352    inbox
    353    legal_html_tags
    354    kb_entry_words
    355    word_relations
    356    temporary_words
    357    wsdl_description
    358    dictionary
    359    dictionary_base
    360    invoice_entry
    361    invoice_type
    362    soap_access
    363    hotlist
    364    log_events
    365    log_debug
    366    form_keys
    367    sms_hysteria
    368    item_config
    369    snapshot
    370    screen_definition
    371    screen_definition_action
    372    screen_definition_element
    373    screen_definition_hidden
    374    screen_definition_language
    375    screen_chooser
    376    scheduled_task
    377    ejscript
    378    system_script
    379    schedule
    380    locking
    381    dbi_agent
    382    dbi_agent_field
    383    dbi_agent_schedule
    384    ejpackage
    385    ejpackage_item
    386    message_id
    387    ejscript_debug
    388    sms
    389    user_candidate
    390    s_smtp_servers
    391    ejselection
    392    ejsel_ejsel
    393    ejsel_source_idlist
    394    ejsel_source_script
    395    ejsel_source_xml
    396    static_list_ref
    397    ejsel_meta_result
    398    ejsel_result_set
    399    tree_explorer_entry
    400    tree_explorer_link
    401    external_document
    402    autosave
    403    user_attribute
    404    notice_frame
    405    s_sent_message
    406    access_script

    Following table was new from 7.1
    407    outgoing_message