STGMRSTTAB

The stage configuration table for all tables containing both merchant and site information.

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.
COLNAMECHAR (30)The name for the column used to identify if the row is site or merchant related.
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