Reference > Database > WebSphere Commerce database tables > P
WebSphere Commerce database table: PRCORSN
Price Override Reason - This table stores the reason the merchant needed to override a system calculated price.
Column Name Column Type Description PRCORSN_ID INTEGER NOT NULL Generated unique key. STOREENT_ID INTEGER NOT NULL The StoreEntity in which the override reason is used. MARKFORDELETE INTEGER NOT NULL DEFAULT 0 Indicates if this override reason has been marked for deletion: 0 = No. 1 = Yes, this override reason has been marked for deletion. CODE VARCHAR(50) NOT NULL Override reason code use for price and shipping charge. The code can be used across multipel stores within the instance. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000968 STOREENT_ID+CODE Unique Index SQL100520030413010 PRCORSN_ID Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_1232 STOREENT_ID STOREENT STOREENT_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_1233 PRCORSN_ID PRCORSNDSC PRCORSN_ID Cascade _vcc_freeselect_bottom_