MERCHCONF

This table stores the information of the value object container Credit for credit-related transactions in the payments subsystem.

Column Descriptions:

Name	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	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>	MERCHCONF_ID	Primary Key
I0000972	MERCHANT_ID+PAYMENTSYSTEM+PAYCONFGRP	Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_3469	MERCHANT_ID	MERCHANT	MERCHANT_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_3470	MERCHCONF_ID	MERCHCONFINFO	MERCHCONF_ID	Cascade
F_3477	MERCHCONF_ID	PPCBATCH	MERCHCONF_ID	Cascade