This table is used for storing the order change reason code for different actions.

Column Descriptions:

ORDCHGRSN_IDINTEGER NOT NULLThe generated unique id for the order reason code.
STOREENT_IDINTEGER NOT NULLThe StoreEntity in which the reason is defined. Stores may establish their own change reasons.
REASONCODEVARCHAR (64) NOT NULLthe event associated with the reason - Order Begin - Add item - Delete item - Update quantity - Cancel order - Override price/price match - Change shipping address/billing address - Delivery instructions add/modify - Change ship date - Change ship mode - Change payment mode - Apply promotions - Price adjustments/discounts - Order Status changes - Payment status changes
FIELD1VARCHAR (254)Customizable field
FIELD2BIGINTCustomizable field
FIELD3INTEGERCustomizable 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.


NameColumn NamesType
I0001266STOREENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType