Database Table: ORDQUOTREL

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.
Indexes:
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
Constraints:
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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable