STOREMERCH

Mapping information indicates which merchant id is used for a specific store.

Column Descriptions:

Name	Type	Description
STORE_ID	INTEGER NOT NULL	Store identifier
MERCHANT_ID	BIGINT NOT NULL	Merchant identifier
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
FIELD1	INTEGER	For customizable use
FIELD2	VARCHAR (250)	For customizable use
FIELD3	VARCHAR (250)	For customizable use

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	STORE_ID	Primary Key
I0001289	MERCHANT_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_3467	STORE_ID	STORE	STORE_ID	Cascade
F_3468	MERCHANT_ID	MERCHANT	MERCHANT_ID	Cascade