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 Column Description
ERRORVIEW VARCHAR (254)
NULL
The error task name to be used if any error conditions occur.
MSGNAME VARCHAR (200)
NOT NULL
Name of the message to be composed and sent to the procurement system.
ORGENTITY_ID BIGINT
NOT NULL
Buyer organization reference number.
PROCPROTCL_ID INTEGER
NOT NULL
Procurement protocol reference number.
VIEWNAME VARCHAR (254)
NOT NULL
The view task name to be used to compose the response.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035038700 PROCPROTCL_ID, ORGENTITY_ID, MSGNAME Primary Key
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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable