PREQUATION

Each row of this table represents a price equation. Price equation is an expression for price calculation. The parameters used in the equation can include the input price, price lists, price constants etc. For example, the equation "Input Price + Distribution cost" means the final price will be the sum of the Input Price and Distribution cost.

Column Descriptions:

NameTypeDescription
PREQUATION_IDBIGINT NOT NULLGenerated Key
STOREENT_IDINTEGER NOT NULLThe unique identifier of the store in which the price equation was created.
IDENTIFIERVARCHAR (64) NOT NULLThe identifier of the price equation.
DESCRIPTIONVARCHAR (254)A description of the price equation, suitable for display to business users.
VALUEVARCHAR (1024)The value of the price equation.
CREATETIMETIMESTAMPCreated time.
LASTUPDATETIMESTAMPLast updated time.
MARKFORDELETEINTEGER NOT NULL DEFAULT 0Indicates if this is marked for deletion: 0 = No. 1 = Yes.
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>PREQUATION_IDPrimary Key
I0001349IDENTIFIER+STOREENT_IDUnique Index
I0001350STOREENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3636STOREENT_IDSTOREENTSTOREENT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3676PREQUATION_IDPREQENTRYPREQUATION_IDCascade