Each row of this table represents a Procurement
System.
Column Descriptions:
Name | Type | Description |
PROCSYSNAME | CHAR (16) NOT NULL | Name of the procurement system. This is the
primary key. |
FIELD1 | VARCHAR (64) | Customizable. |
FIELD2 | VARCHAR (64) | 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> | PROCSYSNAME | Primary Key |
Referenced By Child Tables:
Constraint | Columns | Child Table | Child Columns | Type |
F_619 | PROCSYSNAME | PROCPROTCL | PROCSYSNAME | Cascade |