WebSphere Commerce database table: BLKRSNCODE

Stores the various reason codes for which an Order may be blocked.

Column Descriptions
Column Name Column Type Description
BLKRSNCODE_ID INTEGER NOT NULL Unique reason code Id for the block reason
BLOCKREASONTYPE CHAR(25) NOT NULL Reason codes of similar nature are grouped together by block reason type.
MANUALBLOCK SMALLINT NOT NULL Blocks that are marked manual can be applied using the Telesales rich client.
MARKFORDELETE CHAR(1) NOT NULL This reason code is scheduled to be deleted, and hence will not be used.
FIELD1 INTEGER Field for customization
FIELD2 VARCHAR(254) Field for customization
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235131120 BLKRSNCODE_ID Primary Key

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_1221 BLKRSNCODE_ID BLKRSNDESC BLKRSNCODE_ID Cascade
F_1220 BLKRSNCODE_ID ORDERBLK BLKRSNCODE_ID Cascade
R_3449 BLKRSNCODE_ID STORBLKRSN BLKRSNCODE_ID Cascade