Database Table: RFQRSPEVAL

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

Column Name Column Type Column Description
EVALRESULT INTEGER
NOT NULL, DEFAULT 1
Indicates if this product is accepted, 0 - Lost/Rejected, 1 - Won/Accepted.
REMARKS VARCHAR (254)
NULL
Free-form remarks.
RFQRSPEVAL_ID BIGINT
NOT NULL
The internal reference number of the evaluation.
RFQRSPPROD_ID BIGINT
NOT NULL
The internal reference number of the product included in the RFQ response.
RFQRSP_ID BIGINT
NOT NULL
The internal reference number of the RFQ response.
RFQ_ID BIGINT
NOT NULL
The internal reference number of the RFQ request.
UPDATETIME TIMESTAMP
NULL
Date and time the evaluation was updated.
Indexes:
Index Name Indexed Column Names Index Type
I0000338 RFQRSPPROD_ID Non-Unique Index
SQL030416035051320 RFQRSPEVAL_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_996 RFQ_ID RFQ RFQ_ID Cascade
F_997 RFQRSP_ID RFQRSP RFQRSP_ID Cascade
F_998 RFQRSPPROD_ID RFQRSPPROD RFQRSPPROD_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable