Gift Reward Rules

This form is used to manage gift reward rules data.

Application menu
General → Rules → Gift Reward Rules
Database table
salesproductrewardrules
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.
gift reward rules (Daftar)
GIFT REWARD RULES (Daftar)
gift reward rules (Form)
GIFT REWARD RULES (Form)

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
  • Reward
    The reward input is required.. The reward input can be used as a filter on the main list form..
    • This field searches table product (form Product). Open the dropdown, type a keyword, and pick the desired record.
  • Department
    The department input is required..
    • This field searches table departement (form Department). Open the dropdown, type a keyword, and pick the desired record.
  • 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

  • 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%

English Documentation Administrator 06 Dec 2025 11:07pm