WebSphere Commerce database table: RFQRSP

RFQ Response table. This table stores the basic RFQ response information.

Column Descriptions
Column Name Column Type Description
RFQ_ID BIGINT NOT NULL The ID of the RFQ to which this RFQ response relates.
TFTRADENG_ID BIGINT Reserved for IBM internal use.
MAJORVERSION INTEGER NOT NULL Reserved for IBM internal use.
MEMBER_ID BIGINT NOT NULL The ID of the member who created the RFQ Response.
MINORVERSION INTEGER NOT NULL Reserved for IBM internal use.
NAME VARCHAR(200) NOT NULL The name of the RFQ Response.
STATE INTEGER NOT NULL The state of the RFQ Response. Valid values are as follows:

  • draft

  • active

  • retracted

  • canceled

  • in-evaluation

  • pending approval

  • rejected

  • won

  • lost

REJECTREASON VARCHAR(254) If a response is in a rejected state, this field indicates why the response was rejected.
REMARKS VARCHAR(254) Free-form remarks that a seller provides when creating an RFQ Response.
CREATETIME TIMESTAMP Date and time the RFQ Response was created.
UPDATETIME TIMESTAMP Date and time the RFQ Response was updated.
CANCELTIME TIMESTAMP Date and time the RFQ Response was canceled.
MARKFORDELETE INTEGER Indicates if this RFQ Response is marked for deletion. Valid values are as follows:

  • 0=No

  • 1=Yes, this RFQ Response is marked for deletion

RFQRSP_ID BIGINT NOT NULL The internal reference number of the RFQ Response.
DESCRIPTION VARCHAR(254) Description of RFQ Response.
VERSIONFLAGS INTEGER Reserved for IBM internal use.
STORE_ID INTEGER NOT NULL The identifier of the store that this RFQ response was created in.
PREVRSP BIGINT Reserved for IBM internal use.
ACCEPTACTION INTEGER NOT NULL DEFAULT 0 Indicates if all products in the response must be accepted. Valid values are as follows:

  • 0=all products must be accepted or rejected at the same time

  • 1=not all products must be accepted

EXTRFQRESPONSENUM VARCHAR(64) External RFQ response number used for customization.
FIELD1 BIGINT Customizable.
FIELD2 INTEGER Customizable.
FIELD3 VARCHAR(254) Customizable.
FIELD4 VARCHAR(254) Customizable.
FIELD5 TIMESTAMP Customizable.
FIELD6 TIMESTAMP Customizable.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000209 NAME+MAJORVERSION+MINORVERSION Unique Index
SQL060903235243200 RFQRSP_ID Primary Key
I0000351 RFQ_ID+MEMBER_ID Non-Unique Index
I0000352 NAME Non-Unique Index
I0000727 MEMBER_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_685 MEMBER_ID MEMBER MEMBER_ID Cascade
F_682 RFQ_ID RFQ RFQ_ID Cascade
F_684 TFTRADENG_ID TFTRADENG TFTRADENG_ID Cascade
F_683 RFQRSP_ID TRADING TRADING_ID Cascade

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_997 RFQRSP_ID RFQRSPEVAL RFQRSP_ID Cascade
F_991 RFQRSP_ID RFQRSPPARL RFQRSP_ID Cascade
F_689 RFQRSP_ID RFQRSPPROD RFQRSP_ID Cascade
F_1000 RFQRSP_ID RFQRSPTCRL RFQRSP_ID Cascade
Related reference