Reference > Database > WebSphere Commerce database tables > M
WebSphere Commerce database table: MERCHCONF
This table stores the information of the value object container Credit for credit-related transactions in the WebSphere Commerce Payments.
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 SQL100520030355590 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
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_3470 MERCHCONF_ID MERCHCONFINFO MERCHCONF_ID Cascade F_3477 MERCHCONF_ID PPCBATCH MERCHCONF_ID Cascade _vcc_freeselect_bottom_