INSRULE

Each row in this table represents an installment rule.

Column Descriptions:

NameTypeDescription
INSRULE_IDBIGINT NOT NULLThe installment rule id.
STOREENT_IDINTEGER NOT NULLThe related store id.
NAMEVARCHAR (64) NOT NULLThe name of the installment rule.
DESCRIPTIONVARCHAR (254)The description of the installment rule.
PRIORITYDOUBLE NOT NULL DEFAULT 0The priority of the installment rule.
STARTDATETIMESTAMPThe start date of the installment rule.
ENDDATETIMESTAMPThe end date of the installment rule.
STATUSSMALLINT NOT NULL DEFAULT 0The status of this installment rule. 0 = inactive 1 = active
LASTUPDATETIMESTAMPThe date that this installment rule was last updated.
FIELD1INTEGERCustomizable.
FIELD2DECIMAL (20,5)Customizable.
FIELD3VARCHAR (254)Customizable.
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>INSRULE_IDPrimary Key
I0001326STOREENT_ID+NAMEUnique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3618STOREENT_IDSTOREENTSTOREENT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3619INSRULE_IDINSRULECATGRPINSRULE_IDCascade
F_3621INSRULE_IDINSRULECATENTINSRULE_IDCascade
F_3623INSRULE_IDINSRULEPAYMTHDINSRULE_IDCascade
F_3624INSRULE_IDINSRULECONDINSRULE_IDCascade
F_3625INSRULE_IDINSRULEINSOPTINSRULE_IDCascade