ORDCHGRSN

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

Column Descriptions:

NameTypeDescription
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.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ORDCHGRSN_IDPrimary Key
I0001266STOREENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
R_3450STOREENT_IDSTOREENTSTOREENT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
R_3456ORDCHGRSN_IDORCOMMENTORDCHGRSN_IDCascade
R_3457ORDCHGRSN_IDORDCHGRSNDSORDCHGRSN_IDCascade