MERCHCONFINFO

This table stores the NVPs for properties of merchant information for a specific merchant configuration.

Column Descriptions:

NameTypeDescription
MERCHCONFINFO_IDBIGINT NOT NULLMerchant configuration information identifier
MERCHCONF_IDBIGINT NOT NULLMerchant configuration id for the current NVP
PROPERTY_NAMEVARCHAR (64) NOT NULLProperty name
PROPERTY_VALUEVARCHAR (4000) NOT NULLProperty value
ENCRYPTEDSMALLINT NOT NULL DEFAULT 1Indicates if the value is encrypted. 0:The value is not encrypted. 1:The value is encrypted.
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.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>MERCHCONFINFO_IDPrimary Key
I0000973MERCHCONF_ID+PROPERTY_NAMEUnique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3470MERCHCONF_IDMERCHCONFMERCHCONF_IDCascade