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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000338 | RFQRSPPROD_ID | Non-Unique Index |
SQL030416035051320 | RFQRSPEVAL_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|