WebSphere Commerce database table: BLKRSNCODE

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


Column Description(s):
Column NameColumn TypeDescription
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 1- Manual Block; 0- Not manual block. 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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031202050 BLKRSNCODE_ID Primary Key

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_1221 BLKRSNCODE_ID BLKRSNDESC BLKRSNCODE_ID Cascade
F_1220 BLKRSNCODE_ID ORDERBLK BLKRSNCODE_ID Cascade

Feedback