CNTRDISPLY

This table contains display information for a Contract.

Column Descriptions:

NameTypeDescription
DEVICEFMT_IDINTEGER NOT NULLDevice format identifier.
CNTRDISPLY_IDBIGINT NOT NULLInternal reference number. This is a primary key.
CONTRACT_IDBIGINTContract ID. If null, this is the default display page.
PARTROLE_IDINTEGERParticipant role. Allows a display page based on participant role.
DISPLAYPAGENAMEVARCHAR (254)A display page name.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>CNTRDISPLY_IDPrimary Key
I0000075CONTRACT_ID+DEVICEFMT_ID+PARTROLE_IDUnique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_244PARTROLE_IDPARTROLEPARTROLE_IDCascade
F_245DEVICEFMT_IDDEVICEFMTDEVICEFMT_IDCascade
F_246CONTRACT_IDCONTRACTCONTRACT_IDCascade