This table holds basic RFQ data.
Column Description(s):
Column Name | Column Type | Description |
MEMBER_ID |
BIGINT NOT NULL |
Identifier of the member who owns this RFQ. |
RFQ_ID |
BIGINT NOT NULL |
The internal reference number of the RFQ. |
ACCESSTYPE |
INTEGER |
Indicates the audience of the RFQ. Valid values are as follows:
- 0=RFQ is targeted to the public
- 1=RFQ is private
|
TFTRADENG_ID |
BIGINT |
Reserved for IBM internal use. |
STARTTIME |
TIMESTAMP |
Scheduled start time for the RFQ. |
STORE_ID |
INTEGER |
The identifier of the store in which this RFQ was created. |
ENDTIME |
TIMESTAMP |
Scheduled end time for the RFQ. |
DURATION |
TIMESTAMP |
Reserved for IBM internal use. |
NUMRESPONSES |
INTEGER |
This RFQ will be closed when this number of the responses has been received. |
CREATETIME |
TIMESTAMP |
Date and time the RFQ was created. |
UPDATETIME |
TIMESTAMP |
Date and time this RFQ was last updated. |
CANCELTIME |
TIMESTAMP |
Date and time the RFQ was canceled. |
STATE |
INTEGER NOT NULL |
The state of the RFQ: draft, active, canceled, complete, or future. |
PREVOFFID |
BIGINT |
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 |
The type of the previous offering. For multi-round, this is the RFQ request type. |
NEXTOFFID |
BIGINT |
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 |
The type of the next offering. For multi-round, this is the RFQ request type. |
ROUND |
INTEGER |
For multi-round, this counter keeps the current round number. |
STAGE |
INTEGER |
Reserved for IBM internal use. |
NAME |
VARCHAR(200) NOT NULL |
Unique alphanumeric name for the RFQ. |
MAJORVERSION |
INTEGER NOT NULL |
Reserved for IBM internal use. |
MINORVERSION |
INTEGER NOT NULL |
Reserved for IBM internal use. |
ENDRESULT |
INTEGER |
Indicates what happens to the RFQ. Valid values are as follows:
- 0 = RFQ results in a contract
- 1 = RFQ results in an order
|
MARKFORDELETE |
INTEGER |
Indicates if this RFQ is marked for deletion. Valid values are as follows:
- 0=No
- 1=Yes, this RFQ and its associated values may be deleted from the system
|
ACTIVATETIME |
TIMESTAMP |
Date and time the RFQ was posted or activated. |
CLOSETIME |
TIMESTAMP |
Date and time the RFQ was closed. |
COMPLETETIME |
TIMESTAMP |
Date and time the RFQ was completed. |
RULETYPE |
INTEGER NOT NULL DEFAULT 1 |
RFQ closing rules. Valid values are as follows:
- 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
|
TRACKNUMBER |
VARCHAR(254) |
Reserved for IBM internal use. |
VERSIONFLAGS |
INTEGER |
Reserved for IBM internal use. |
EXTRFQNUM |
VARCHAR(64) |
External RFQ number for use in 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. |