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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000190 | PROTOCOLNAME, VERSION | Unique Index |
SQL030416035039150 | PROCPROTCL_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_619 | PROCSYSNAME | PROCSYS | PROCSYSNAME | Cascade |
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 |