Reference > Database > WebSphere Commerce database tables > I
WebSphere Commerce database table: INSRULEINSOPT
Each row represents an installment payment option of an installment rule.
Column Name Column Type Description INSRULEINSOPT_ID BIGINT NOT NULL The installment payment option id. INSRULE_ID BIGINT NOT NULL The related installment rule id. INSTALLMENTS SMALLINT The instalment number of this installment payment option. RATE DECIMAL (20,5) NOT NULL The rate used in this installment payment option. MININSAMOUNT DECIMAL (20,5) The minimal payment amount of this installment payment option. CURRENCY CHAR(3) The currency used in this installment payment option. OPTCOUNTER INTEGER NOT NULL DEFAULT 0 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030712010 INSRULEINSOPT_ID Primary Key I0001334 INSRULE_ID Non-Unique Index I0001335 CURRENCY Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3625 INSRULE_ID INSRULE INSRULE_ID Cascade F_3626 CURRENCY SETCURR SETCCURR Cascade _vcc_freeselect_bottom_