WebSphere Commerce database table: PROCMSGVW

This table contains the view names used to compose the response message sent to procurement systems. Response message composition can be customized (per buyer, per protocol) using this table.

Column Descriptions
Column Name Column Type Description
ORGENTITY_ID BIGINT NOT NULL Buyer organization reference number.
MSGNAME VARCHAR(200) NOT NULL Name of the message to be composed and sent to the procurement system.
VIEWNAME VARCHAR(254) NOT NULL The view task name to be used to compose the response.
PROCPROTCL_ID INTEGER NOT NULL Procurement protocol reference number.
ERRORVIEW VARCHAR(254) The error task name to be used if any error conditions occur.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235235600 PROCPROTCL_ID+ORGENTITY_ID+MSGNAME Primary Key
I0000699 ORGENTITY_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_617 ORGENTITY_ID ORGENTITY ORGENTITY_ID Cascade
F_618 PROCPROTCL_ID PROCPROTCL PROCPROTCL_ID Cascade
Related reference