Reference > Database > WebSphere Commerce database tables > O
WebSphere Commerce database table: ORDCHGRSN
This table is used for storing the order change reason code for different actions.
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.
Indexes Index Name Indexed Column Names Index Type SQL100520030400360 ORDCHGRSN_ID Primary Key I0001266 STOREENT_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type R_3450 STOREENT_ID STOREENT STOREENT_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type R_3456 ORDCHGRSN_ID ORCOMMENT ORDCHGRSN_ID Cascade R_3457 ORDCHGRSN_ID ORDCHGRSNDS ORDCHGRSN_ID Cascade _vcc_freeselect_bottom_