This table holds all the response product
evaluations for the RFQ.
Column Descriptions:
| Name | Type | Description |
| RFQRSPEVAL_ID | BIGINT NOT NULL | The internal reference number of the
evaluation. |
| EVALRESULT | INTEGER NOT NULL DEFAULT 1 | Indicates if this product is accepted. Valid
values are as follows:
- 0=Lost or rejected
- 1=Won or accepted
|
| REMARKS | VARCHAR (254) | Free-form remarks. |
| UPDATETIME | TIMESTAMP | Date and time the evaluation was updated. |
| RFQ_ID | BIGINT NOT NULL | The internal reference number of the RFQ
request. |
| RFQRSP_ID | BIGINT NOT NULL | The internal reference number of the RFQ
response. |
| RFQRSPPROD_ID | BIGINT NOT NULL | The internal reference number of the product
included in the RFQ response. |
| OPTCOUNTER | SMALLINT | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | RFQRSPEVAL_ID | Primary Key |
| I0000338 | RFQRSPPROD_ID | Non-Unique Index |
| I0000728 | RFQRSP_ID | Non-Unique Index |
| I0000729 | RFQ_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | 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 |