Reference > Database > WebSphere Commerce database tables > P
WebSphere Commerce database table: PROCPROTCL
Each row of this table represents a procurement system protocol and its version number. For example, cXML, OCI, OBI, and so on.
Column Name Column Type Description PROCPROTCL_ID INTEGER NOT NULL Generated primary key. PROCSYSNAME CHAR(16) Name of the procurement system that uses this protocol. Foreign key to PROCSYS table. PROTOCOLNAME VARCHAR(32) NOT NULL Name of the procurement protocol. Together with column VERSION forms a unique index.
VERSION VARCHAR(32) Version of the procurement protocol. AUTHTYPE INTEGER NOT NULL Authentication type used by the protocol. TWOSTEPMODE CHAR(1) NOT NULL Indicates whether this protocol uses two modes of communication for the shopping session. For example, cXML uses XML or HTTP to authenticate the procurement system buyer and then browser-based HTTP to complete the shopping cycle. PROCPROTCLCOMMENT VARCHAR(254) Comment CLASSIFDOMAIN CHAR(32) Product classification standard used by the procurement protocol version. Examples of classification standards include UNSPSC, SPSC, and so on. UOMSTANDARD VARCHAR(32) Unit of measurement standard (ISO for example) used by the procurement protocol. FIELD1 VARCHAR(64) Customizable. FIELD2 VARCHAR(64) Customizable. FIELD3 VARCHAR(64) Customizable. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000190 PROTOCOLNAME+VERSION Unique Index SQL100520030413710 PROCPROTCL_ID Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_619 PROCSYSNAME PROCSYS PROCSYSNAME Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_138 PROCPROTCL_ID BUYSUPMAP PROCPROTCL_ID Cascade F_616 PROCPROTCL_ID PROCBUYPRF PROCPROTCL_ID Cascade F_618 PROCPROTCL_ID PROCMSGVW PROCPROTCL_ID Cascade
Related reference
_vcc_freeselect_bottom_