Heading table - SuperOffice

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	No
updated	Last updated when	UtcDateTime	No
updated_associate_id	Last updated by whom	FK associate	No
updatedCount	Number of updates made to this record	UShort	No

Indexes

Fields	Types	Description
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.

Related topics

heading AssociateHeadingLink table CategoryHeadingLink table SourceHeadingLink table IntentHeadingLink table TagsHeadingLink table

⌘I