ORDERTMPL

Each row of this table indicates that an Order is used as a template by a customer. And it also indicates whether the template is current for that customer.

Column Descriptions:

NameTypeDescription
ORDERS_IDBIGINT NOT NULLThe Order.
MEMBER_IDBIGINT NOT NULLThe customer.
USAGEINTEGER NOT NULL DEFAULT 0The intended usage for this template. 0 = no usage information. 1 = template is a current template. Values less than 1000 are Reserved for HCL internal use.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The 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>MEMBER_ID+ORDERS_IDPrimary Key
I0000655ORDERS_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_518MEMBER_IDMEMBERMEMBER_IDCascade
F_519ORDERS_IDORDERSORDERS_IDCascade