Reference > Database > WebSphere Commerce database tables > P


WebSphere Commerce database table: PROCSYS

Each row of this table represents a Procurement System.

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
SQL100520030413900 PROCSYSNAME Primary Key

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


Related reference

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search