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.
|