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 Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031258410 PROCPROTCL_ID+ORGENTITY_ID+MSGNAME Primary Key
I0000699 ORGENTITY_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_617 ORGENTITY_ID ORGENTITY ORGENTITY_ID Cascade
F_618 PROCPROTCL_ID PROCPROTCL PROCPROTCL_ID Cascade

Feedback