Each row of this table represents a relationship between a parent Order and a child Order.
Column Descriptions
Column Name
| Column Type
| Description |
PARENT_ID
| BIGINT NOT NULL
| The parent Order.
|
CHILD_ID
| BIGINT
| The child Order.
|
ORDQUOTREL_ID
| BIGINT NOT NULL
| Generated primary key.
|
CHILDSTORE_ID
| INTEGER
| The Store of the child Order.
|
TRADING_ID
| BIGINT
| The TradingAgreement that governs this relationship.
|
RELTYPE
| CHAR(16) NOT NULL
| Indicates the type of relationship represented by this OrderQuotationRel object.
initial = the child Order represents a quotation received for the items in the parent Order.
selection = the child Order represents specified quantities of items selected from a quotation for the parent Order.
final = the child Order represents a quotation received for the items in the selection child Order for the parent Order.
submission = the child Order represents a submitted Order (OrderProcess has been invoked) for the parent Order.
|
TIMEOUTTIME
| TIMESTAMP
| The time the user interface should stop polling to see if the child Order has been received yet.
|
DISPLAYSEQUENCE
| DOUBLE NOT NULL DEFAULT 0
| Can be used by a user interface to determine the sequence in which child Orders should be displayed.
|
FLAGS
| INTEGER NOT NULL DEFAULT 0
| Bit flags for the Order Quotation Relationship record. Bit 1 = The response for the order quotation request resulted in an error. The Order associated with the Order Quotation Relationship record has a status of 'H'. An ORDSTAT record is created with the response message's status message in the OSCMNT column.
|
OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|