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 Column Description
AUTHTYPE INTEGER
NOT NULL
Authentication type used by the protocol.
CLASSIFDOMAIN CHARACTER (32)
NULL
Product classification standard used by the procurement protocol version. Examples of classification standards include UNSPSC, SPSC, and so on.
FIELD1 VARCHAR (64)
NULL
Customizable.
FIELD2 VARCHAR (64)
NULL
Customizable.
FIELD3 VARCHAR (64)
NULL
Customizable.
PROCPROTCLCOMMENT VARCHAR (254)
NULL
Comment
PROCPROTCL_ID INTEGER
NOT NULL
Generated primary key.
PROCSYSNAME CHARACTER (16)
NULL
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.
TWOSTEPMODE CHARACTER (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.
UOMSTANDARD VARCHAR (32)
NULL
Unit of measurement standard (ISO for example) used by the procurement protocol.
VERSION VARCHAR (32)
NULL
Version of the procurement protocol.
Indexes:
Index Name Indexed Column Names Index Type
I0000190 PROTOCOLNAME, VERSION Unique Index
SQL030416035039150 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