INSRULEINSOPT

Each row represents an installment payment option of an installment rule.


Column Descriptions:

Name 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 installment 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 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> INSRULEINSOPT_ID Primary Key
I0001334 INSRULE_ID Non-Unique Index
I0001335 CURRENCY Non-Unique Index


Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_3625 INSRULE_ID INSRULE INSRULE_ID Cascade
F_3626 CURRENCY SETCURR SETCCURR Cascade