Reference > Database > WebSphere Commerce database tables > I

WebSphere Commerce database table: INSRULEPAYMTHD

Each row represents a qualified payment type in an installment rule.

Column Name	Column Type	Description
INSRULEPAYMTHD_ID	BIGINT NOT NULL	The qualified payment method id.
INSRULE_ID	BIGINT NOT NULL	The related installment rule id.
PAYMTHD	VARCHAR(128)	The related payment method name. NULL = All payment method qualified
ASSOCTYPE	SMALLINT NOT NULL DEFAULT 0	The associated type. 0 = Qualified. 1 = Unqualified.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	Reserved for IBM internal use.

Indexes

Index Name	Indexed Column Names	Index Type
SQL100520030712320	INSRULEPAYMTHD_ID	Primary Key
I0001332	INSRULE_ID+PAYMTHD	Non-Unique Index

Constraints

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_3623	INSRULE_ID	INSRULE	INSRULE_ID	Cascade

_vcc_freeselect_bottom_

+

Search Tips   |   Advanced Search