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