ORDERBLK

Stores blocked Orders with reason code

Column Descriptions:

NameTypeDescription
ORDERBLK_IDBIGINT NOT NULLUnique primary key
ORDERS_IDBIGINT NOT NULLOrder whose block is being recorded here
BLKRSNCODE_IDINTEGER NOT NULLThe reason code Id associated with this block. It identifies the reason for the block.
TIMEBLOCKEDTIMESTAMP NOT NULLThe time the block was placed or last updated.
RESOLVEDSMALLINT NOT NULL DEFAULT 0Indicates 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.
BLKCOMMENTVARCHAR (254)Comment field to record any comments pertaining to this block. The field can be updated as needed.
FIELD1INTEGERField for customization
FIELD2VARCHAR (254)Field for customization
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ORDERBLK_IDPrimary Key
I0000956ORDERS_IDNon-Unique Index
I0000957BLKRSNCODE_ID+RESOLVEDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1219ORDERS_IDORDERSORDERS_IDCascade
F_1220BLKRSNCODE_IDBLKRSNCODEBLKRSNCODE_IDCascade