Skip to content

Latest commit

 

History

History
59 lines (42 loc) · 1.89 KB

quoteapprreasonheadinglink.md

File metadata and controls

59 lines (42 loc) · 1.89 KB
uid title description so.generated keywords so.topic so.envir
table-QuoteApprReasonHeadingLink
QuoteApprReasonHeadingLink table
Heading link table for QuoteApprReason, for MDO headers
true
database table QuoteApprReasonHeadingLink
reference
onsite, online

QuoteApprReasonHeadingLink Table (525)

Heading link table for QuoteApprReason, for MDO headers

Fields

Name Description Type Null
quoteapprreasonheadinglink_id Primary key PK
quoteapprreason_id Link to QuoteApprReason list table FK QuoteApprReason
heading_id Link to Heading table FK Heading
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

QuoteApprReasonHeadingLink table relationship diagram

[!includedetails]

Indexes

Fields Types Description
quoteapprreasonheadinglink_id PK Clustered, Unique
quoteapprreason_id FK Index
heading_id FK Index

Relationships

Table Description
associate Employees, resources and other users - except for External persons
Heading Heading items for all MDO lists, lists that are grouped and filtered.
QuoteApprReason Predefined reasons for quote approval

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.