ORDERHIST

This table is used to save order snapshots in XML format.

Column Descriptions:

NameTypeDescription
ORDERS_IDBIGINT NOT NULLThe Order ID.
ORDERVERSIONSMALLINT NOT NULLThe Order history version.
LASTUPDATETIMESTAMPThe time this history is created.
ORDXMLCLOB (10000000)The XML snapshot for the order information.
FIELD1INTEGERCustomizable field
FIELD2VARCHAR (254)Customizable field
FIELD3TIMESTAMPCustomizable field
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>ORDERS_ID+ORDERVERSIONPrimary Key

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
R_3458ORDERS_IDORDERSORDERS_IDCascade