Field Description Type
ID UUID of the record text
colour colour of the record when displayed in lists text
code a short code for the location alpha 60
description Full description of the location text
Comment For your use to record any info text
hold if true, stock at this location can't be issued on customer invoices- can use for quarantine areas. boolean
parent_ID UUID of the parent of this location (e.g the rack of a particular slot, or the aisle of a rack text
priority numeric value that can be used for sorting locations for picking longint
store_ID UUID of the store that this location is for text
summary_only only to be used for reporting, not for assigning to stock (e.g. an aisle that has racks as children) text
type_ID UUID of Location_type record that this record is related to. Location types can be used to restrict storage of items to certain location (types) text
volume volume available at this location in cubic metres (m3) real number
  • Last modified: 2018/06/06 03:22
  • by Craig Drown