ORDCHGRSN

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

Column Descriptions:

Name	Type	Description
ORDCHGRSN_ID	INTEGER NOT NULL	The generated unique id for the order reason code.
STOREENT_ID	INTEGER NOT NULL	The StoreEntity in which the reason is defined. Stores may establish their own change reasons.
REASONCODE	VARCHAR (64) NOT NULL	the 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
FIELD1	VARCHAR (254)	Customizable field
FIELD2	BIGINT	Customizable field
FIELD3	INTEGER	Customizable field
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>	ORDCHGRSN_ID	Primary Key
I0001266	STOREENT_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
R_3450	STOREENT_ID	STOREENT	STOREENT_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
R_3456	ORDCHGRSN_ID	ORCOMMENT	ORDCHGRSN_ID	Cascade
R_3457	ORDCHGRSN_ID	ORDCHGRSNDS	ORDCHGRSN_ID	Cascade