Reference > Database > WebSphere Commerce database tables > B
WebSphere Commerce database table: BLKRSNCODE
Stores the various reason codes for which an Order may be blocked.
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 SQL100520030303480 BLKRSNCODE_ID Primary Key
Referenced By 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 _vcc_freeselect_bottom_