Each row of this table represents a procurement system protocol and its version number. For example, cXML, OCI, OBI, and so on.
Column Description(s):
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. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000190 |
PROTOCOLNAME+VERSION |
Unique Index |
SQL050212031258550 |
PROCPROTCL_ID |
Primary Key |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_619 |
PROCSYSNAME |
PROCSYS |
PROCSYSNAME |
Cascade |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | 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
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.