Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
tables_fields:other_tables:location [2020/05/18 05:14] Craig Drowntables_fields:other_tables:location [2020/06/02 08:09] (current) – [Location] Gary Willetts
Line 3: Line 3:
  
 ====== Location ====== ====== Location ======
 +Contains details of shelf locations in a store.
  
 ^ Field ^ Description ^ Type ^  ^ Field ^ Description ^ Type ^ 
 |ID  |UUID of the record  | text | |ID  |UUID of the record  | text |
-|colour  |colour of the record when displayed in lists  | text |+|Colour  |colour of the record when displayed in lists  | text |
 |code  |a short code for the location  | alpha 60 | |code  |a short code for the location  | alpha 60 |
-|description  |Full description of the location  | text |+|Description  |Full description of the location  | text |
 |Comment  |For your use to record any info  | 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 | |hold  |if true, stock at this location can't be issued on customer invoices- can use for quarantine areas.  | boolean |
Line 16: Line 17:
 |summary_only  |only to be used for reporting, not for assigning to stock (e.g. an aisle that has racks as children)  | 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 | |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 | +|Volume  |Total volume of this location in cubic metres (m3)  | real number | 
 +|object_type  |  | text | 
 +|bottom_y_coordinate  | Position of the bottom edge of this location. Used for displying the locaiton on a diagram. Old functionality not used any more | real number |
 ==== location_movement  ==== ==== location_movement  ====
 ^ Field number  ^  Field Name  ^   Description ^ Type  ^  Length  ^  Index ^ ^ Field number  ^  Field Name  ^   Description ^ Type  ^  Length  ^  Index ^
Line 30: Line 32:
  
 ---- struct data ---- ---- struct data ----
 +pagestatus.status    : 
 ---- ----
  
  • Last modified: 2020/05/18 05:14
  • by Craig Drown