OPSYSTEM

This table is ued for storing Order Processing system.

Column Descriptions:

NameTypeDescription
OPSYSTEM_IDINTEGER NOT NULLIndicate the Order Processing system for the order.
NAMEVARCHAR (254) NOT NULLName of the order processing system.
OPTCOUNTERSMALLINTThe 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>OPSYSTEM_IDPrimary Key

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
R_3455OPSYSTEM_IDORDERSOPSYSTEM_IDCascade