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:
| Name | Type | Description |
| PREQUATION_ID | BIGINT NOT NULL | Generated Key |
| STOREENT_ID | INTEGER NOT NULL | The unique identifier of the store in which the
price equation was created. |
| IDENTIFIER | VARCHAR (64) NOT NULL | The identifier of the price equation. |
| DESCRIPTION | VARCHAR (254) | A description of the price equation, suitable for
display to business users. |
| VALUE | VARCHAR (1024) | The value of the price equation. |
| CREATETIME | TIMESTAMP | Created time. |
| LASTUPDATE | TIMESTAMP | Last updated time. |
| MARKFORDELETE | INTEGER NOT NULL DEFAULT 0 | Indicates if this is marked for deletion: 0 = No.
1 = Yes. |
| 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> | PREQUATION_ID | Primary Key |
| I0001349 | IDENTIFIER+STOREENT_ID | Unique Index |
| I0001350 | STOREENT_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_3636 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
Referenced By Child Tables:
| Constraint | Columns | Child Table | Child Columns | Type |
| F_3676 | PREQUATION_ID | PREQENTRY | PREQUATION_ID | Cascade |