Column Descriptions
| Column Name
| Column Type
| Description |
| 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.
|