PROCBUYPRF

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

Column Descriptions:

Name	Type	Description
PROCPROTCL_ID	INTEGER NOT NULL	The Procurement Protocol reference number.
ORGENTITY_ID	BIGINT NOT NULL	The buyer organization reference number.
REQIDPARM	VARCHAR (32) NOT NULL	The Requisitioner ID parameter name.
ORGUNITPARM	VARCHAR (32) NOT NULL	The organization unit parameter name.
CONTRACTPARM	VARCHAR (32)	The parameter name for identifying the Contract.
FIELD1	VARCHAR (32)	Customizable.
FIELD2	VARCHAR (32)	Customizable.
FIELD3	VARCHAR (32)	Customizable.
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	Primary Key
I0000698	ORGENTITY_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_615	ORGENTITY_ID	ORGENTITY	ORGENTITY_ID	Cascade
F_616	PROCPROTCL_ID	PROCPROTCL	PROCPROTCL_ID	Cascade

Related reference
Procurement data model