CPENDORDER

Each row of this table indicates that an order is marked as current for a customer in a store, if its status is "P" (Pending).

Column Descriptions:

Name	Type	Description
STOREENT_ID	INTEGER NOT NULL	The ID that uniquely identifies the store from which the customer placed the order.
ORDERS_ID	BIGINT NOT NULL	The ID that uniquely identifies the order.
MEMBER_ID	BIGINT NOT NULL	The ID that uniquely identifies the customer of the order.
FIELD1	INTEGER	Customizable.
FIELD2	VARCHAR (254)	Customizable.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	ORDERS_ID+MEMBER_ID	Primary Key
I0000542	STOREENT_ID	Non-Unique Index
I168207	MEMBER_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_258	STOREENT_ID	STORE	STORE_ID	Cascade
F_259	MEMBER_ID	MEMBER	MEMBER_ID	Cascade
F_260	ORDERS_ID	ORDERS	ORDERS_ID	Cascade

Related reference
Order data model