This table is used for storing the order change reason code for different actions.
Column Descriptions
| Column Name
| Column 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
| Reserved for IBM internal use.
|