Heading Table (58)
•
Environment: onsite, online
Some tooltip text!
• 5 minutes to read
• 5 minutes to read
Heading items for all MDO lists, lists that are grouped and filtered.
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| heading_id | Primary key | PK | |
| name | The visible heading | String(239) | |
| rank | Rank order | UShort | ● |
| tooltip | Tooltip or other description | String(254) | ● |
| deleted | 0 -> record is active 1 -> record is deleted and should not be shown in lists | UShort | ● |
| listTableId | Which List is this heading connected to? (table ID) | TableNumber | |
| extraId | Extra ID for refining the list id | Id | ● |
| registered | Registered when | UtcDateTime | |
| registered_associate_id | Registered by whom | FK associate | |
| updated | Last updated when | UtcDateTime | |
| updated_associate_id | Last updated by whom | FK associate | |
| updatedCount | Number of updates made to this record | UShort |
Indexes
| Fields | Types | Description |
|---|---|---|
| heading_id | PK | Clustered, Unique |
| name | String(239) | Index |
| listTableId | TableNumber | Index |
Relationships
| Table | Description |
|---|---|
| AmountClassHeadingLink | Heading link table for AmountClass, for MDO headers |
| associate | Employees, resources and other users - except for External persons |
| AssociateHeadingLink | Heading link table for associate for display only. Supportive table, used for grouping and filtering on lists. |
| BusinessHeadingLink | Heading link table for Business, for MDO headers |
| CategoryHeadingLink | Heading link table for Category, for MDO headers |
| ComptrHeadingLink | Heading link table for Comptr, for MDO headers |
| ContIntHeadingLink | Heading link table for ContInt, for MDO headers |
| CountryHeadingLink | Heading link table for Country, for MDO headers |
| CreditedHeadingLink | Heading link table for Credited, for MDO headers |
| CurrencyHeadingLink | Heading link table for Currency, for MDO headers |
| DeliveryTermsHeadingLink | Heading link table for DeliveryTerms, for MDO item headings |
| DeliveryTypeHeadingLink | Heading link table for DeliveryType, for MDO item headings |
| DocTmplHeadingLink | Heading link table for DocTmpl, for MDO headers |
| ExtAppHeadingLink | Heading link table for ExtApp, for MDO headers |
| IntentHeadingLink | Heading link table for Intent, for MDO headers |
| MrMrsHeadingLink | Heading link table for MrMrs, for MDO headers |
| PaymentTermsHeadingLink | Heading link table for PaymentTerms, for MDO item headings |
| PaymentTypeHeadingLink | Heading link table for PaymentType, for MDO item headings |
| PersIntHeadingLink | Heading link table for PersInt, for MDO headers |
| PersPosHeadingLink | Heading link table for PersPos, for MDO headers |
| PMembTypeHeadingLink | Heading link table for PMembType, for MDO headers |
| PriceUnitHeadingLink | Heading link table for PriceUnit, for MDO item headings |
| PriorityHeadingLink | Heading link table for Priority, for MDO headers |
| ProbHeadingLink | Heading link table for Prob, for MDO headers |
| ProductCategoryHeadingLink | Heading link table for ProductCategory, for MDO item headings |
| ProductFamilyHeadingLink | Heading link table for ProductFamily, for MDO item headings |
| ProductTypeHeadingLink | Heading link table for ProductType, for MDO item headings |
| ProjStatusHeadingLink | Heading link table for ProjStatus, for MDO headers |
| ProjTypeHeadingLink | Heading link table for ProjType, for MDO headers |
| QuoteApprReasonHeadingLink | Heading link table for QuoteApprReason, for MDO headers |
| QuoteDenyReasonHeadingLink | Heading link table for QuoteDenyReason, for MDO headers |
| ReasonHeadingLink | Heading link table for Reason, for MDO headers |
| ReasonSoldHeadingLink | Heading link table for ReasonSold, for MDO headers |
| ReasonStalledHeadingLink | Heading link table for ReasonStalled, for MDO headers |
| RejectReasonHeadingLink | Heading link table for RejectReason, for MDO headers |
| RelDefHeadingLink | Heading link table for RelDef, for MDO headers |
| SaleTypeCatHeadingLink | Heading link table for SaleTypeCat, for MDO headers |
| SaleTypeHeadingLink | Heading link table for SaleType, for MDO headers |
| SalutationHeadingLink | Heading link table for Salutation, for MDO headers |
| SearchCatHeadingLink | Heading link table for SearchCat, for MDO headers |
| SourceHeadingLink | Heading link table for Source, for MDO headers |
| StakeholderRoleHeadingLink | Heading link table for StakeholderRole, for MDO headers |
| SubscriptionUnitHeadingLink | Heading link table for SubscriptionUnit, for MDO item headings |
| TagsHeadingLink | Heading link table for Source, for MDO headers |
| TaskHeadingLink | Heading link table for Task, for MDO headers |
| TaskMenuHeadingLink | Heading link table for TaskMenu, for MDO headers |
| 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.