RFQRSPTCRL

The relationship between one specified RFQ term or condition, and an RFQ Response to this term or condition.

Column Descriptions:

NameTypeDescription
RFQRSPTCRL_IDBIGINT NOT NULLThe internal reference number of the RFQ Response term or condition relationship.
RFQ_IDBIGINT NOT NULLThe internal reference number of the RFQ.
RFQRSP_IDBIGINT NOT NULLThe internal reference number of the RFQ Response.
RFQTC_IDBIGINT NOT NULLThe internal reference number of the RFQ term or condition.
RFQRSPTC_IDBIGINT NOT NULLThe internal reference number of the RFQ Response term or condition.
CHANGEFLAGINTEGERReserved for HCL internal use.
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>RFQRSPTCRL_IDPrimary Key
I0000211RFQ_ID+RFQRSP_ID+RFQTC_ID+RFQRSPTC_IDUnique Index
I0000212RFQTC_ID+RFQRSPTC_IDUnique Index
I0000735RFQRSPTC_IDNon-Unique Index
I0000736RFQRSP_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1000RFQRSP_IDRFQRSPRFQRSP_IDCascade
F_690RFQ_IDRFQRFQ_IDCascade
F_691RFQRSPTC_IDTERMCONDTERMCOND_IDCascade
F_692RFQTC_IDTERMCONDTERMCOND_IDCascade