PROCSYS

Each row of this table represents a Procurement System.

Column Descriptions:

NameTypeDescription
PROCSYSNAMECHAR (16) NOT NULLName of the procurement system. This is the primary key.
FIELD1VARCHAR (64)Customizable.
FIELD2VARCHAR (64)Customizable.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>PROCSYSNAMEPrimary Key

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_619PROCSYSNAMEPROCPROTCLPROCSYSNAMECascade