WebSphere Commerce database table: PROCSYS

Each row of this table represents a Procurement System. Examples of Procurement systems are Ariba, Oracle, CommerceOne, and so on.

Column Descriptions
Column Name Column Type Description
PROCSYSNAME CHAR(16) NOT NULL Name of the procurement system. This is the primary key.
FIELD1 VARCHAR(64) Customizable.
FIELD2 VARCHAR(64) Customizable.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235236020 PROCSYSNAME Primary Key

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_619 PROCSYSNAME PROCPROTCL PROCSYSNAME Cascade
Related reference