field name | Unit Price |
---|---|
field id | 5 |
base table name | Inventory |
base table id | 129 |
dataType | fieldType | comment |
---|---|---|
Number | Normal |
allow Editing | overwrite existing value | always evaluate | value | furigana | lookup | use constant | constant | use calc | calculation |
---|---|---|---|---|---|---|---|---|---|
True | True | False | False | False | False | True | Let ( [ unit = 100 * Inventory::Unit Cost ; charge = unit + If ( Taxable ; RATE_component ( Unit ; "gst" ) ) + If ( freight ; RATE_component ( Unit ; "freight" ) ) + RATE_component ( Unit ; .05 ) ; rounded = Round(charge;0) ]; ( rounded + If ( Mod( rounded ; 5 ) ; 5 - Mod(rounded ; 5)) ) / 100 ) |
always Validate | validate | strict Validation | maxLength | valuelist | by calc | range | not Empty | unique | existing | message | error message |
---|---|---|---|---|---|---|---|---|---|---|---|
False | OnlyDuringDataEntry | False | False | False | False | False | False | False | False |
index | index Language | auto index | global | max Repetition |
---|---|---|---|---|
All | English | False | 1 |