ddr summary/file/tables/fields

Field: Unit Price

field nameUnit Price
field id5
base table nameInventory
base table id129
Show Uses: All Dependencies | Summary Report | Layouts | Relationships | Scripts | Field References | Custom Functions | Privileges
Field Type data
dataTypefieldTypecomment
NumberNormal
Calculation
Auto Enter Options
allow Editingoverwrite existing valuealways evaluatevaluefuriganalookupuse constantconstantuse calccalculation
TrueTrueFalseFalseFalseFalse
TrueLet ( [
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

)
Validation Options
always Validatevalidatestrict ValidationmaxLengthvaluelistby calcrangenot Emptyuniqueexistingmessageerror message
FalseOnlyDuringDataEntryFalseFalseFalseFalseFalseFalseFalseFalse
Storage Options
indexindex Languageauto indexglobalmax Repetition
AllEnglishFalse1