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:

NameTypeDescription
STOREENT_IDINTEGER NOT NULLThe ID that uniquely identifies the store from which the customer placed the order.
ORDERS_IDBIGINT NOT NULLThe ID that uniquely identifies the order.
MEMBER_IDBIGINT NOT NULLThe ID that uniquely identifies the customer of the order.
FIELD1INTEGERCustomizable.
FIELD2VARCHAR (254)Customizable.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ORDERS_ID+MEMBER_IDPrimary Key
I0000542STOREENT_IDNon-Unique Index
I168207MEMBER_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_258STOREENT_IDSTORESTORE_IDCascade
F_259MEMBER_IDMEMBERMEMBER_IDCascade
F_260ORDERS_IDORDERSORDERS_IDCascade