MERCHCONF

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

Column Descriptions:

NameTypeDescription
MERCHCONF_IDBIGINT NOT NULLMerchConfig identifier
MERCHANT_IDBIGINT NOT NULLThe merchant identifier for this merchant configuration
PAYMENTSYSTEMVARCHAR (64) NOT NULLPayment system name
PAYCONFGRPVARCHAR (64) NOT NULLPayment configuration group
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>MERCHCONF_IDPrimary Key
I0000972MERCHANT_ID+PAYMENTSYSTEM+PAYCONFGRPUnique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3469MERCHANT_IDMERCHANTMERCHANT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3470MERCHCONF_IDMERCHCONFINFOMERCHCONF_IDCascade
F_3477MERCHCONF_IDPPCBATCHMERCHCONF_IDCascade