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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000209 | NAME, MAJORVERSION, MINORVERSION | Unique Index |
SQL030416035050980 | RFQRSP_ID | Primary Key |
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 |
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 |