WebSphere Commerce database table: PRCORSN

WebSphere Commerce database table: PRCORSN

Price Override Reason - This table stores the reason the merchant needed to override a system calculated price.
Column Descriptions
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
SQL060903235235150 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

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_1233 PRCORSN_ID PRCORSNDSC PRCORSN_ID Cascade

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.

Index Name	Indexed Column Names	Index Type
I0000968	STOREENT_ID+CODE	Unique Index
SQL060903235235150	PRCORSN_ID	Primary Key