WebSphere Commerce database table: ORDERBLK

Stores blocked Orders with reason code


Column Description(s):
Column NameColumn TypeDescription
ORDERBLK_ID BIGINT NOT NULL Unique primary key
ORDERS_ID BIGINT NOT NULL Order whose block is being recorded here
BLKRSNCODE_ID INTEGER NOT NULL The reason code Id associated with this block. It identifies the reason for the block.
TIMEBLOCKED TIMESTAMP NOT NULL The time the block was placed or last updated.
RESOLVED SMALLINT NOT NULL DEFAULT 0 Indicates if this block has been resolved, i.e if it is no longer blocking the Order.
A '0' indicates it is not resolved, and a '1' indicates it is resolved.
BLKCOMMENT VARCHAR(254) Comment field to record any comments pertaining to this block.
The field can be updated as needed.
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
SQL050212031243860 ORDERBLK_ID Primary Key
I0000956 ORDERS_ID Non-Unique Index
I0000957 BLKRSNCODE_ID+RESOLVED Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_1220 BLKRSNCODE_ID BLKRSNCODE BLKRSNCODE_ID Cascade
F_1219 ORDERS_ID ORDERS ORDERS_ID Cascade

Feedback