This table stores the NVPs for properties of
merchant information for a specific merchant configuration.
Column Descriptions:
| Name | Type | Description |
| MERCHCONFINFO_ID | BIGINT NOT NULL | Merchant configuration information
identifier |
| MERCHCONF_ID | BIGINT NOT NULL | Merchant configuration id for the current
NVP |
| PROPERTY_NAME | VARCHAR (64) NOT NULL | Property name |
| PROPERTY_VALUE | VARCHAR (4000) NOT NULL | Property value |
| ENCRYPTED | SMALLINT NOT NULL DEFAULT 1 | Indicates if the value is encrypted. 0:The value
is not encrypted. 1:The value is encrypted. |
| 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. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | MERCHCONFINFO_ID | Primary Key |
| I0000973 | MERCHCONF_ID+PROPERTY_NAME | Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_3470 | MERCHCONF_ID | MERCHCONF | MERCHCONF_ID | Cascade |