> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Heading table

> Heading items for all MDO lists, lists that are grouped and filtered.

## Heading Table (58)

Heading items for all MDO lists, lists that are grouped and filtered.

## Fields

| Name                      | Description                                                                   | Type                            | Nullable |
| ------------------------- | ----------------------------------------------------------------------------- | ------------------------------- | :------: |
| heading\_id               | Primary key                                                                   | PK                              |    No    |
| name                      | The visible heading                                                           | String(239)                     |    No    |
| rank                      | Rank order                                                                    | UShort                          |    Yes   |
| tooltip                   | Tooltip or other description                                                  | String(254)                     |    Yes   |
| deleted                   | 0 -> record is active 1 -> record is deleted and should not be shown in lists | UShort                          |    Yes   |
| listTableId               | Which List is this heading connected to? (table ID)                           | TableNumber                     |    No    |
| extraId                   | Extra ID for refining the list id                                             | Id                              |    Yes   |
| registered                | Registered when                                                               | UtcDateTime                     |    No    |
| registered\_associate\_id | Registered by whom                                                            | FK [associate](./associate.mdx) |    No    |
| updated                   | Last updated when                                                             | UtcDateTime                     |    No    |
| updated\_associate\_id    | Last updated by whom                                                          | FK [associate](./associate.mdx) |    No    |
| updatedCount              | Number of updates made to this record                                         | UShort                          |    No    |

<img src="https://mintcdn.com/superofficeas/zNQa3AO19PFK63SB/media/loc/en/database/tables/Heading.png?fit=max&auto=format&n=zNQa3AO19PFK63SB&q=85&s=51677e94ffef3444b464ddcd2e21b6ff" alt="Heading table relationship diagram" width="375" height="59" data-path="media/loc/en/database/tables/Heading.png" />

## Indexes

| Fields      | Types       | Description |
| ----------- | ----------- | ----------- |
| name        | String(239) | Index       |
| listTableId | TableNumber | Index       |

## Relationships

| Table                                                        | Description                                                                                                                                                                                 |
| ------------------------------------------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| [AmountClassHeadingLink](./amountclassheadinglink)           | Heading link table for AmountClass, for MDO headers                                                                                                                                         |
| [associate](./associate)                                     | Employees, resources and other users - except for External persons                                                                                                                          |
| [AssociateHeadingLink](./associateheadinglink)               | Heading link table for associate for display only. Supportive table, used for grouping and filtering on lists.                                                                              |
| [BusinessHeadingLink](./businessheadinglink)                 | Heading link table for Business, for MDO headers                                                                                                                                            |
| [CategoryHeadingLink](./categoryheadinglink)                 | Heading link table for Category, for MDO headers                                                                                                                                            |
| [ComptrHeadingLink](./comptrheadinglink)                     | Heading link table for Comptr, for MDO headers                                                                                                                                              |
| [ContIntHeadingLink](./contintheadinglink)                   | Heading link table for ContInt, for MDO headers                                                                                                                                             |
| [CountryHeadingLink](./countryheadinglink)                   | Heading link table for Country, for MDO headers                                                                                                                                             |
| [CreditedHeadingLink](./creditedheadinglink)                 | Heading link table for Credited, for MDO headers                                                                                                                                            |
| [CurrencyHeadingLink](./currencyheadinglink)                 | Heading link table for Currency, for MDO headers                                                                                                                                            |
| [DeliveryTermsHeadingLink](./deliverytermsheadinglink)       | Heading link table for DeliveryTerms, for MDO item headings                                                                                                                                 |
| [DeliveryTypeHeadingLink](./deliverytypeheadinglink)         | Heading link table for DeliveryType, for MDO item headings                                                                                                                                  |
| [DocTmplHeadingLink](./doctmplheadinglink)                   | Heading link table for DocTmpl, for MDO headers                                                                                                                                             |
| [ExtAppHeadingLink](./extappheadinglink)                     | Heading link table for ExtApp, for MDO headers                                                                                                                                              |
| [IntentHeadingLink](./intentheadinglink)                     | Heading link table for Intent, for MDO headers                                                                                                                                              |
| [MrMrsHeadingLink](./mrmrsheadinglink)                       | Heading link table for MrMrs, for MDO headers                                                                                                                                               |
| [PaymentTermsHeadingLink](./paymenttermsheadinglink)         | Heading link table for PaymentTerms, for MDO item headings                                                                                                                                  |
| [PaymentTypeHeadingLink](./paymenttypeheadinglink)           | Heading link table for PaymentType, for MDO item headings                                                                                                                                   |
| [PersIntHeadingLink](./persintheadinglink)                   | Heading link table for PersInt, for MDO headers                                                                                                                                             |
| [PersPosHeadingLink](./persposheadinglink)                   | Heading link table for PersPos, for MDO headers                                                                                                                                             |
| [PMembTypeHeadingLink](./pmembtypeheadinglink)               | Heading link table for PMembType, for MDO headers                                                                                                                                           |
| [PriceUnitHeadingLink](./priceunitheadinglink)               | Heading link table for PriceUnit, for MDO item headings                                                                                                                                     |
| [PriorityHeadingLink](./priorityheadinglink)                 | Heading link table for Priority, for MDO headers                                                                                                                                            |
| [ProbHeadingLink](./probheadinglink)                         | Heading link table for Prob, for MDO headers                                                                                                                                                |
| [ProductCategoryHeadingLink](./productcategoryheadinglink)   | Heading link table for ProductCategory, for MDO item headings                                                                                                                               |
| [ProductFamilyHeadingLink](./productfamilyheadinglink)       | Heading link table for ProductFamily, for MDO item headings                                                                                                                                 |
| [ProductTypeHeadingLink](./producttypeheadinglink)           | Heading link table for ProductType, for MDO item headings                                                                                                                                   |
| [ProjStatusHeadingLink](./projstatusheadinglink)             | Heading link table for ProjStatus, for MDO headers                                                                                                                                          |
| [ProjTypeHeadingLink](./projtypeheadinglink)                 | Heading link table for ProjType, for MDO headers                                                                                                                                            |
| [QuoteApprReasonHeadingLink](./quoteapprreasonheadinglink)   | Heading link table for QuoteApprReason, for MDO headers                                                                                                                                     |
| [QuoteDenyReasonHeadingLink](./quotedenyreasonheadinglink)   | Heading link table for QuoteDenyReason, for MDO headers                                                                                                                                     |
| [ReasonHeadingLink](./reasonheadinglink)                     | Heading link table for Reason, for MDO headers                                                                                                                                              |
| [ReasonSoldHeadingLink](./reasonsoldheadinglink)             | Heading link table for ReasonSold, for MDO headers                                                                                                                                          |
| [ReasonStalledHeadingLink](./reasonstalledheadinglink)       | Heading link table for ReasonStalled, for MDO headers                                                                                                                                       |
| [RejectReasonHeadingLink](./rejectreasonheadinglink)         | Heading link table for RejectReason, for MDO headers                                                                                                                                        |
| [RelDefHeadingLink](./reldefheadinglink)                     | Heading link table for RelDef, for MDO headers                                                                                                                                              |
| [SaleTypeCatHeadingLink](./saletypecatheadinglink)           | Heading link table for SaleTypeCat, for MDO headers                                                                                                                                         |
| [SaleTypeHeadingLink](./saletypeheadinglink)                 | Heading link table for SaleType, for MDO headers                                                                                                                                            |
| [SalutationHeadingLink](./salutationheadinglink)             | Heading link table for Salutation, for MDO headers                                                                                                                                          |
| [SearchCatHeadingLink](./searchcatheadinglink)               | Heading link table for SearchCat, for MDO headers                                                                                                                                           |
| [SourceHeadingLink](./sourceheadinglink)                     | Heading link table for Source, for MDO headers                                                                                                                                              |
| [StakeholderRoleHeadingLink](./stakeholderroleheadinglink)   | Heading link table for StakeholderRole, for MDO headers                                                                                                                                     |
| [SubscriptionUnitHeadingLink](./subscriptionunitheadinglink) | Heading link table for SubscriptionUnit, for MDO item headings                                                                                                                              |
| [TagsHeadingLink](./tagsheadinglink)                         | Heading link table for Source, for MDO headers                                                                                                                                              |
| [TaskHeadingLink](./taskheadinglink)                         | Heading link table for Task, for MDO headers                                                                                                                                                |
| [TaskMenuHeadingLink](./taskmenuheadinglink)                 | Heading link table for TaskMenu, for MDO headers                                                                                                                                            |
| [UDListHeadingLink](./udlistheadinglink)                     | Heading link table for UDList, for MDO headers. Note - MDO mode for userdefinede lists are either turned on or off, you may not have it on for one userdefined list and off for the others. |

## Replication Flags

* Replicate changes DOWN from central to satellites and travellers.
* Replicate changes UP from satellites and travellers back to central.
* Copy to satellite and travel prototypes.

## Security Flags

* No access control via user's Role.


## Related topics

- [heading](/en/api/mdo-providers/reference/heading.md)
- [AssociateHeadingLink table](/en/database/tables/associateheadinglink.md)
- [IntentHeadingLink table](/en/database/tables/intentheadinglink.md)
- [CountryHeadingLink table](/en/database/tables/countryheadinglink.md)
- [CreditedHeadingLink table](/en/database/tables/creditedheadinglink.md)
- [CurrencyHeadingLink table](/en/database/tables/currencyheadinglink.md)
