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 Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031258680 PROCSYSNAME Primary Key

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_619 PROCSYSNAME PROCPROTCL PROCSYSNAME Cascade

Feedback