RFQ Response table. This table stores the basic RFQ response information.
Column Description(s):
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. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000209 |
NAME+MAJORVERSION+MINORVERSION |
Unique Index |
SQL050212031305010 |
RFQRSP_ID |
Primary Key |
I0000351 |
RFQ_ID+MEMBER_ID |
Non-Unique Index |
I0000352 |
NAME |
Non-Unique Index |
I0000727 |
MEMBER_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | 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 |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | 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
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.