RFQRSP

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


Column Descriptions:

Name 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:

  • 1=draft

  • 2=active

  • 3=canceled

  • 4=in-evaluation

  • 5=pending approval

  • 6=rejected

  • 7=retracted

  • 8=won

  • 9=lost

  • 10=won completed

  • 11=lost completed

  • 12=won next round

  • 13=lost next round

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 NOT NULL DEFAULT 0 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> RFQRSP_ID Primary Key
I0000209 NAME+MAJORVERSION+MINORVERSION Unique Index
I0000351 RFQ_ID+MEMBER_ID Non-Unique Index
I0000352 NAME Non-Unique Index
I0000727 MEMBER_ID Non-Unique Index
I0001279 TFTRADENG_ID Non-Unique Index


Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_682 RFQ_ID RFQ RFQ_ID Cascade
F_683 RFQRSP_ID TRADING TRADING_ID Cascade
F_684 TFTRADENG_ID TFTRADENG TFTRADENG_ID Cascade
F_685 MEMBER_ID MEMBER MEMBER_ID Cascade


Referenced By Child Tables:

Constraint Columns Child Table Child Columns Type
F_1000 RFQRSP_ID RFQRSPTCRL RFQRSP_ID Cascade
F_689 RFQRSP_ID RFQRSPPROD RFQRSP_ID Cascade
F_991 RFQRSP_ID RFQRSPPARL RFQRSP_ID Cascade
F_997 RFQRSP_ID RFQRSPEVAL RFQRSP_ID Cascade


Related reference
Request for Quote (RFQ) data model