STOREMERCH

This table stores the mapping information indicates which merchant id is used for a specific store.

Column Descriptions:

NameTypeDescription
STORE_IDINTEGER NOT NULLStore identifier
MERCHANT_IDBIGINT NOT NULLMerchant identifier
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.
FIELD1INTEGERFor customizable use
FIELD2VARCHAR (250)For customizable use
FIELD3VARCHAR (250)For customizable use

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>STORE_IDPrimary Key
I0001289MERCHANT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3467STORE_IDSTORESTORE_IDCascade
F_3468MERCHANT_IDMERCHANTMERCHANT_IDCascade