PROCBUYPRF

This table contains the buyer organization specific profile information of procurement system protocols to support Procurement System integration.

Column Descriptions:

NameTypeDescription
PROCPROTCL_IDINTEGER NOT NULLThe Procurement Protocol reference number.
ORGENTITY_IDBIGINT NOT NULLThe buyer organization reference number.
REQIDPARMVARCHAR (32) NOT NULLThe Requisitioner ID parameter name.
ORGUNITPARMVARCHAR (32) NOT NULLThe organization unit parameter name.
CONTRACTPARMVARCHAR (32)The parameter name for identifying the Contract.
FIELD1VARCHAR (32)Customizable.
FIELD2VARCHAR (32)Customizable.
FIELD3VARCHAR (32)Customizable.
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_IDPrimary Key
I0000698ORGENTITY_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_615ORGENTITY_IDORGENTITYORGENTITY_IDCascade
F_616PROCPROTCL_IDPROCPROTCLPROCPROTCL_IDCascade