WebSphere Commerce database table: PROCBUYPRF

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


Column Description(s):
Column NameColumn TypeDescription
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 Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031258270 PROCPROTCL_ID+ORGENTITY_ID Primary Key
I0000698 ORGENTITY_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_615 ORGENTITY_ID ORGENTITY ORGENTITY_ID Cascade
F_616 PROCPROTCL_ID PROCPROTCL PROCPROTCL_ID Cascade

Feedback