Point Reward Rules

This form is used to manage point reward rules data.

Application menu: General → Rules → Point Reward Rules
Database table: salespointrewardrules
Primary Key: id (Code).
User permissions: Access for this form (create, update, delete, duplicate) can be configured from the General → User Role List menu.
Initial focus when creating data: Field Code will receive focus first.
Sorting order: Records are sorted by Code.

Additional Fields

The additional fields section contains several inputs that end users can populate:

Code
The code input is required..
Description
The description input is required.. The description input can be used as a filter on the main list form..
Display Name
The display name input is required..
Category
The category input is required.. The category input can be used as a filter on the main list form..
- Select one of the available options.
- Available options:
  - Product
  - Transaction
Created By
This input is read-only and only displays data from system.. The created by input can be used as a filter on the main list form..
- This field shows the user code that created the record and is filled automatically.
Modified By
This input is read-only and only displays data from system.. The modified by input can be used as a filter on the main list form..
- This field shows the user code that last modified the record and is filled automatically.
Last Modified
This input is read-only and only displays data from system.. The last modified input can be used as a filter on the main list form..
- This field displays a timestamp that is populated automatically.

Formula
The formula input is required..
Available Variables
- This field searches vw_salespointrewardrules. Open the dropdown, type a keyword, and pick the desired record.
Available Functions
- Select one of the available options.
- Available options:
  - round(decimal, precision) - round(2.4) = 2, round(3.455, 2) = 3.46
  - floor(decimal) - floor(4.9) = 4, floor(4.1) = 4
  - ceil(decimal) - ceil(0.6) = 1, ceil(5.1) = 6
  - abs(number) - abs(1) = 1, abs(-1) = 1
  - is_infinite(any) - is infinite number
  - is_nan(any) - is NAN (Not A Number)
  - is_finite(any) - is finite number
  - trim(var) - trim("\n Hello World! \t") = "Hello World!"
  - ltrim(var) - ltrim("\n Hello World! \t") = "Hello World! \t"
  - rtrim(var) - rtrim("\n Hello World! \t") = "\n Hello World!"
  - str_replace(find, replacement, string) - string replacement
  - implode(separator, array) - array to string
  - explode(separator, string) - string to array
  - isset(var) - is set a variable
  - currentday - current day in number i.e 1, 2, ..., 31
  - currentmonth - current month in number i.e 1, 2, .., 12
  - currentyear - current year i.e 2025, 2026
  - currenthour - current hour 0-24
  - currentminute - current minute 00-59
  - currentsecond - current second 00-59
  - stackeddiscount(30, 40, 50) - discount 30%+40%+50%