TermAndCondition Table

FlexNet Manager Suite 2020 R1 (On-Premises)

TermAndCondition stores a list of terms and conditions related to a contract.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database 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.
Table 1. Database columns for TermAndCondition table

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 TermAndConditionType table.

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 Contract table.

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 ComplianceUser table.

EmailIntervalTypeID

Type: integer. Key. Nullable

The interval type for EmailInterval. Foreign key to the IntervalType table.

EmailInterval

Type: integer. Nullable

The interval used when sending emails.

ReminderIntervalTypeID

Type: integer. Key. Nullable

The interval type for ReminderInterval. Foreign key to the IntervalType table.

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 ComplianceUser table.

EscalationIntervalTypeID

Type: integer. Key. Nullable

The interval type for EscalationInterval. Foreign key to the IntervalType table.

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