Reference > Database > WebSphere Commerce database tables > P
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 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 SQL100520030413510 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
_vcc_freeselect_bottom_