This table holds the basic RFQ data.
Column Name | Column Type | Column Description |
---|---|---|
ACCESSTYPE | INTEGER NULL |
Indicates to what the RFQ is targeted: 0 = RFQ is targeted to public, 1 = RFQ is targeted to private. |
ACTIVATETIME | TIMESTAMP NULL |
Date and time the RFQ was posted or activated. |
CANCELTIME | TIMESTAMP NULL |
Date and time the RFQ was canceled. |
CLOSETIME | TIMESTAMP NULL |
Date and time the RFQ was closed. |
COMPLETETIME | TIMESTAMP NULL |
Date and time the RFQ was completed. |
CREATETIME | TIMESTAMP NULL |
Date and time the RFQ was created. |
DURATION | TIMESTAMP NULL |
Reserved for IBM internal use. |
ENDRESULT | INTEGER NULL |
Indicates what happens to the RFQ: 0 = RFQ results in a contract, 1 = RFQ results in an order. |
ENDTIME | TIMESTAMP NULL |
Scheduled end time for the RFQ. |
MAJORVERSION | INTEGER NOT NULL |
Reserved for IBM internal use. |
MARKFORDELETE | INTEGER NULL |
Indicates if this RFQ is marked for deletion: 0 = No. 1 = Yes, this RFQ and its associated values may be deleted from the system. |
MEMBER_ID | BIGINT NOT NULL |
Identifier of the member who owns this RFQ. |
MINORVERSION | INTEGER NOT NULL |
Reserved for IBM internal use. |
NAME | VARCHAR (200) NOT NULL |
Unique alphanumeric name for the RFQ. |
NEXTOFFID | BIGINT NULL |
The ID of the next offering in the chain. For multi-round, the internal reference number of the RFQ that was created in the next round is stored in this column. |
NEXTOFFTYPE | INTEGER NULL |
The type of the next offering. For multi-round, this is the RFQ request type. |
NUMRESPONSES | INTEGER NULL |
This RFQ will be closed when this number of the responses have been received. |
PREVOFFID | BIGINT NULL |
The ID of the previous offering. For multi-round, the internal reference number of the RFQ in the previous round from which this RFQ is created is stored in this column. |
PREVOFFTYPE | INTEGER NULL |
The type of the previous offering. For multi-round, this is the RFQ request type. |
RFQ_ID | BIGINT NOT NULL |
The internal reference number of the RFQ. |
ROUND | INTEGER NULL |
For multi-round, this counter keeps the current round number. |
RULETYPE | INTEGER NOT NULL, DEFAULT 1 |
RFQ closing rules: 1 - RFQ closes at a fixed end time, 2 - RFQ closes if a specified number of responses are received, 3 - RFQ closes based on logical OR of 1 and 2, 4 - RFQ closes based on logical AND of 1 and 2. |
STAGE | INTEGER NULL |
Reserved for IBM internal use. |
STARTTIME | TIMESTAMP NULL |
Scheduled start time for the RFQ. |
STATE | INTEGER NOT NULL |
The state of the RFQ: draft, active, canceled, complete, or future. |
STORE_ID | INTEGER NULL |
The identifier of the store that this RFQ was created in. |
TFTRADENG_ID | BIGINT NULL |
Reserved for IBM internal use. |
TRACKNUMBER | VARCHAR (254) NULL |
Reserved for IBM internal use. |
UPDATETIME | TIMESTAMP NULL |
Date and time this RFQ was last updated. |
VERSIONFLAGS | INTEGER NULL |
Reserved for IBM internal use. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000207 | NAME, MAJORVERSION, MINORVERSION | Unique Index |
SQL030416035049830 | RFQ_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_674 | RFQ_ID | TRADING | TRADING_ID | Cascade |
F_675 | MEMBER_ID | MEMBER | MEMBER_ID | Cascade |
F_676 | TFTRADENG_ID | TFTRADENG | TFTRADENG_ID | Cascade |
F_677 | STORE_ID | STORE | STORE_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_1021 | RFQ_ID | RFQTARGET | RFQ_ID | Cascade |
F_680 | RFQ_ID | RFQPROD | RFQ_ID | Cascade |
F_682 | RFQ_ID | RFQRSP | RFQ_ID | Cascade |
F_690 | RFQ_ID | RFQRSPTCRL | RFQ_ID | Cascade |
F_992 | RFQ_ID | RFQRSPPARL | RFQ_ID | Cascade |
F_994 | RFQ_ID | RFQCATEGRY | RFQ_ID | Cascade |
F_996 | RFQ_ID | RFQRSPEVAL | RFQ_ID | Cascade |