INSRULEPAYMTHD

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

Column Descriptions:

NameTypeDescription
INSRULEPAYMTHD_IDBIGINT NOT NULLThe qualified payment method id.
INSRULE_IDBIGINT NOT NULLThe related installment rule id.
PAYMTHDVARCHAR (128)The related payment method name. NULL = All payment method qualified
ASSOCTYPESMALLINT NOT NULL DEFAULT 0The associated type. 0 = Qualified. 1 = Unqualified.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>INSRULEPAYMTHD_IDPrimary Key
I0001332INSRULE_ID+PAYMTHDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3623INSRULE_IDINSRULEINSRULE_IDCascade