STGMERTAB

The stage configuration table for all merchant tables.

Column Descriptions:

NameTypeDescription
TABNBRINTEGER NOT NULLThe reference number of the table. The parent table must have a lower reference number than any child table.
TABNAMECHAR (30)The table name. TABNAME has a limit of 18 characters.
UPDATABLE_UK_COLVARCHAR (128)Column to use to support cyclical use of unique-key values during StagingProp. This column should be part of the supplementary unique-key (unique index) of the table recorded in TABNAME column.
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>TABNBRPrimary Key