WebSphere Commerce database table: PRCORSN

Price Override Reason - This table stores the reason the merchant needed to override a system calculated price.


Column Description(s):
Column NameColumn TypeDescription
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(es):
Index NameIndexed Column NamesIndex Type
I0000968 STOREENT_ID+CODE Unique Index
SQL050212031257990 PRCORSN_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_1232 STOREENT_ID STOREENT STOREENT_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_1233 PRCORSN_ID PRCORSNDSC PRCORSN_ID Cascade

Feedback