Database Table: RFQ

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.
Indexes:
Index Name Indexed Column Names Index Type
I0000207 NAME, MAJORVERSION, MINORVERSION Unique Index
SQL030416035049830 RFQ_ID Primary Key
Constraints:
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

Referenced By:
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