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:

NameTypeDescription
ORGENTITY_IDBIGINT NOT NULLBuyer organization reference number.
MSGNAMEVARCHAR (200) NOT NULLName of the message to be composed and sent to the procurement system.
VIEWNAMEVARCHAR (254) NOT NULLThe view task name to be used to compose the response.
PROCPROTCL_IDINTEGER NOT NULLProcurement protocol reference number.
ERRORVIEWVARCHAR (254)The error task name to be used if any error conditions occur.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>PROCPROTCL_ID+ORGENTITY_ID+MSGNAMEPrimary Key
I0000699ORGENTITY_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_617ORGENTITY_IDORGENTITYORGENTITY_IDCascade
F_618PROCPROTCL_IDPROCPROTCLPROCPROTCL_IDCascade