This table contains the buyer organization specific
profile information of procurement system protocols to support
Procurement System integration.
Column Descriptions:
| Name | Type | Description |
| PROCPROTCL_ID | INTEGER NOT NULL | The Procurement Protocol reference number. |
| ORGENTITY_ID | BIGINT NOT NULL | The buyer organization reference number. |
| REQIDPARM | VARCHAR (32) NOT NULL | The Requisitioner ID parameter name. |
| ORGUNITPARM | VARCHAR (32) NOT NULL | The organization unit parameter name. |
| CONTRACTPARM | VARCHAR (32) | The parameter name for identifying the
Contract. |
| FIELD1 | VARCHAR (32) | Customizable. |
| FIELD2 | VARCHAR (32) | Customizable. |
| FIELD3 | VARCHAR (32) | Customizable. |
| OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | PROCPROTCL_ID+ORGENTITY_ID | Primary Key |
| I0000698 | ORGENTITY_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_615 | ORGENTITY_ID | ORGENTITY | ORGENTITY_ID | Cascade |
| F_616 | PROCPROTCL_ID | PROCPROTCL | PROCPROTCL_ID | Cascade |