TermAndCondition Table
TermAndCondition
stores a list of terms and conditions related to a contract.
TenantID
has been set in the SQL Server
connection context information. That setting filters an underlying table to produce this
view of data for the single, selected tenant.
Database Column |
Details |
---|---|
TermAndConditionID
|
Type: integer. Key. Generated ID A unique identifier for the term/condition. |
TermAndConditionTypeID
|
Type: integer. Key The type of term/condition. Foreign key to |
Description
|
Type: text (max 100 characters). Key A description assigned by the operator. |
DocReference
|
Type: text (max 100 characters). Nullable A text reference to a document for this term/condition. |
Comments
|
Type: text. Nullable Comments about this term/condition. |
BeginDate
|
Type: datetime. Nullable The start date for this term or condition. |
EndDate
|
Type: datetime. Nullable The end date for this term or condition. |
ContractID
|
Type: integer. Key The contract to which this term/condition applies. Foreign key to the |
CreationUser
|
Type: text (max 128 characters). Nullable The operator who created the record. |
CreationDate
|
Type: datetime The date the term/condition was created. |
UpdatedUser
|
Type: text (max 128 characters). Nullable The name of the operator who last updated the term/condition. |
UpdatedDate
|
Type: datetime. Nullable The date the record was last updated. |
EmailComplianceUserID
|
Type: integer. Key. Nullable A user who may be emailed according to conditions on this term/condition. Foreign key to the |
EmailIntervalTypeID
|
Type: integer. Key. Nullable The interval type for |
EmailInterval
|
Type: integer. Nullable The interval used when sending emails. |
ReminderIntervalTypeID
|
Type: integer. Key. Nullable The interval type for |
ReminderInterval
|
Type: integer. Nullable The interval used when sending reminders. |
EscalationCompliance UserID
|
Type: integer. Key. Nullable A user who may be emailed if the term/condition needs to be escalated. Foreign key to the |
EscalationIntervalTypeID
|
Type: integer. Key. Nullable The interval type for |
EscalationInterval
|
Type: integer. Nullable The interval used when sending escalation messages. |
Auditable
|
Type: boolean Boolean to indicate whether the term/condition is auditable. |
FlexNet Manager Suite (On-Premises)
2020 R1