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