Reference > Database > WebSphere Commerce database tables > R
WebSphere Commerce database table: RFQRSPEVAL
This table holds all the response product evaluations for the RFQ.
Column Name Column 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...
- 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 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030422460 RFQRSPEVAL_ID Primary Key I0000338 RFQRSPPROD_ID Non-Unique Index I0000728 RFQRSP_ID Non-Unique Index I0000729 RFQ_ID Non-Unique Index
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
Related reference
_vcc_freeselect_bottom_