Database Table: RFQRSP

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

Column Name Column Type Column Description
ACCEPTACTION INTEGER
NOT NULL, DEFAULT 0
Indicates if all products in the response must be accepted, 0 - all products must be accepted or rejected at the same time, 1 - not all products must be accepted.
CANCELTIME TIMESTAMP
NULL
Date and time the RFQ Response was canceled.
CREATETIME TIMESTAMP
NULL
Date and time the RFQ Response was created.
DESCRIPTION VARCHAR (254)
NULL
Description of RFQ Response.
MAJORVERSION INTEGER
NOT NULL
Reserved for IBM internal use.
MARKFORDELETE INTEGER
NULL
Indicates if this RFQ Response is marked for deletion:
0 = No.
1 = Yes, this RFQ Response is marked for deletion.
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.
PREVRSP BIGINT
NULL
Reserved for IBM internal use.
REJECTREASON VARCHAR (254)
NULL
If a response is in a rejected state, this field indicates why the response was rejected.
REMARKS VARCHAR (254)
NULL
Free-form remarks that a seller provides when creating an RFQ Response.
RFQRSP_ID BIGINT
NOT NULL
The internal reference number of the RFQ Response.
RFQ_ID BIGINT
NOT NULL
The ID of the RFQ which this response responds to
STATE INTEGER
NOT NULL
The state of the RFQ Response: draft, active, retracted, canceled, in-evaluation, pending approval, rejected, won, lost.
STORE_ID INTEGER
NOT NULL
The identifier of the store that this RFQ response was created in.
TFTRADENG_ID BIGINT
NULL
Reserved for IBM internal use.
UPDATETIME TIMESTAMP
NULL
Date and time the RFQ Response was updated.
VERSIONFLAGS INTEGER
NULL
Reserved for IBM internal use.
Indexes:
Index Name Indexed Column Names Index Type
I0000209 NAME, MAJORVERSION, MINORVERSION Unique Index
SQL030416035050980 RFQRSP_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint 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:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint 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