Each row of this table represents a relationship between a parent Order and a child Order.
Column Name | Column Type | Column Description |
---|---|---|
CHILDSTORE_ID | INTEGER NULL |
The Store of the child Order. |
CHILD_ID | BIGINT NULL |
The child Order. |
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. |
ORDQUOTREL_ID | BIGINT NOT NULL |
Generated primary key. |
PARENT_ID | BIGINT NOT NULL |
The parent Order. |
RELTYPE | CHARACTER (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 NULL |
The time the user interface should stop polling to see if the child Order has been received yet. |
TRADING_ID | BIGINT NULL |
The TradingAgreement that governs this relationship. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
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 |
SQL030416035023360 | ORDQUOTREL_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_931 | TRADING_ID | TRADING | TRADING_ID | Cascade |
F_932 | CHILD_ID | ORDERS | ORDERS_ID | Cascade |
F_933 | PARENT_ID | ORDERS | ORDERS_ID | Cascade |
F_934 | CHILDSTORE_ID | STORE | STORE_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|