Each row of this table represents a relationship between a parent Order and a child Order.
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 Rel record. Bit 1 = The response for the order quotation request resulted in an error. The Order associated with the Order Quotation Rel 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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL050212031248870 | ORDQUOTREL_ID | Primary Key |
I0000278 | CHILD_ID | Non-Unique Index |
I0000308 | PARENT_ID+RELTYPE+CHILDSTORE_ID+CHILD_ID | Non-Unique Index |
I0000309 | CHILDSTORE_ID+CHILD_ID+RELTYPE+PARENT_ID | Non-Unique Index |
I0000673 | TRADING_ID | Non-Unique Index |
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_932 | CHILD_ID | ORDERS | ORDERS_ID | Cascade |
F_933 | PARENT_ID | ORDERS | ORDERS_ID | Cascade |
F_934 | CHILDSTORE_ID | STORE | STORE_ID | Cascade |
F_931 | TRADING_ID | TRADING | TRADING_ID | Cascade |