WebSphere Commerce database table: MERCHCONF

This table stores the merchant configuration for the specific payment system and payment configuration group.

Column Descriptions

Column Name	Column Type	Description
MERCHCONF_ID	BIGINT NOT NULL	MerchConfig identifier
MERCHANT_ID	BIGINT NOT NULL	The merchant identifier for this merchant configuration
PAYMENTSYSTEM	VARCHAR(64) NOT NULL	Payment system name
PAYCONFGRP	VARCHAR(64) NOT NULL	Payment configuration group
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	IBM internal use
FIELD1	INTEGER	For customizable use
FIELD2	VARCHAR(250)	For customizable use
FIELD3	VARCHAR(250)	For customizable use

Indexes

Index Name	Indexed Column Names	Index Type
I0000972	MERCHANT_ID+PAYMENTSYSTEM+PAYCONFGRP	Unique Index
SQL060903235214510	MERCHCONF_ID	Primary Key

Constraints

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_3469	MERCHANT_ID	MERCHANT	MERCHANT_ID	Cascade

Constraint Name	Referenced Column Name	Foreign Table Name	Foreign Column Names	Constraint Type
F_3470	MERCHCONF_ID	MERCHCONFINFO	MERCHCONF_ID	Cascade