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:
Name | 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 NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
Name | Column Names | Type |
<SYSTEM-GENERATED> | PROCPROTCL_ID+ORGENTITY_ID+MSGNAME | Primary Key |
I0000699 | ORGENTITY_ID | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
F_617 | ORGENTITY_ID | ORGENTITY | ORGENTITY_ID | Cascade |
F_618 | PROCPROTCL_ID | PROCPROTCL | PROCPROTCL_ID | Cascade |