PRCORSN

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

Column Descriptions:

NameTypeDescription
PRCORSN_IDINTEGER NOT NULLGenerated unique key.
STOREENT_IDINTEGER NOT NULLThe StoreEntity in which the override reason is used.
MARKFORDELETEINTEGER NOT NULL DEFAULT 0Indicates if this override reason has been marked for deletion: 0 = No. 1 = Yes, this override reason has been marked for deletion.
CODEVARCHAR (50) NOT NULLOverride reason code use for price and shipping charge. The code can be used across multiple stores within the instance.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>PRCORSN_IDPrimary Key
I0000968STOREENT_ID+CODEUnique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1232STOREENT_IDSTOREENTSTOREENT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1233PRCORSN_IDPRCORSNDSCPRCORSN_IDCascade