Database Table: PROCBUYPRF

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

Column Name Column Type Column Description
CONTRACTPARM VARCHAR (32)
NULL
The parameter name for identifying the Contract.
FIELD1 VARCHAR (32)
NULL
Customizable.
FIELD2 VARCHAR (32)
NULL
Customizable.
FIELD3 VARCHAR (32)
NULL
Customizable.
ORGENTITY_ID BIGINT
NOT NULL
The buyer organization reference number.
ORGUNITPARM VARCHAR (32)
NOT NULL
The organization unit parameter name.
PROCPROTCL_ID INTEGER
NOT NULL
The Procurement Protocol reference number.
REQIDPARM VARCHAR (32)
NOT NULL
The Requisitioner ID parameter name.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035038330 PROCPROTCL_ID, ORGENTITY_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_615 ORGENTITY_ID ORGENTITY ORGENTITY_ID Cascade
F_616 PROCPROTCL_ID PROCPROTCL PROCPROTCL_ID Cascade

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