RFQRSPEVAL

This table holds all the response product evaluations for the RFQ.

Column Descriptions:

NameTypeDescription
RFQRSPEVAL_IDBIGINT NOT NULLThe internal reference number of the evaluation.
EVALRESULTINTEGER NOT NULL DEFAULT 1Indicates if this product is accepted. Valid values are as follows:
  • 0=Lost or rejected
  • 1=Won or accepted
REMARKSVARCHAR (254)Free-form remarks.
UPDATETIMETIMESTAMPDate and time the evaluation was updated.
RFQ_IDBIGINT NOT NULLThe internal reference number of the RFQ request.
RFQRSP_IDBIGINT NOT NULLThe internal reference number of the RFQ response.
RFQRSPPROD_IDBIGINT NOT NULLThe internal reference number of the product included in the RFQ response.
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>RFQRSPEVAL_IDPrimary Key
I0000338RFQRSPPROD_IDNon-Unique Index
I0000728RFQRSP_IDNon-Unique Index
I0000729RFQ_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_996RFQ_IDRFQRFQ_IDCascade
F_997RFQRSP_IDRFQRSPRFQRSP_IDCascade
F_998RFQRSPPROD_IDRFQRSPPRODRFQRSPPROD_IDCascade