Column Descriptions
| 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)
| Vof 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.
|