tables_fields:other_tables:location

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/01/07 01:05] – ↷ Page moved from tables:other_tables:location to tables_fields:other_tables:location loutables_fields:other_tables:location [2020/06/02 08:09] (current) – [Location] Gary Willetts
Line 1: Line 1:
-====== Location ======+===== Location & Location Movement ===== 
 +[[tables_fields:|Back to the list of tables]]
  
-[[tables:other_tables:|Back to the list of other tables]]+====== 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 15: 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  ==== 
 +^ Field number  ^  Field Name  ^   Description ^ Type  ^  Length  ^  Index ^ 
 +|3|enter_date|     |   Date  |  |  | 
 +|4|enter_time|     |   Time  |  |  | 
 +|5|exit_date|     |   Date  |  |  | 
 +|6|exit_time|     |   Time  |  |  | 
 +|1|ID|  Unique ID of the record   |   Alpha  |  |  Y  | 
 +|7|item_line_ID|     |   Alpha  |  |  | 
 +|2|location_ID|     |   Alpha  |  |  | 
 +|8|store_ID|     |   Alpha  |  |  |
  
 ---- struct data ---- ---- struct data ----
 +pagestatus.status    : 
 ---- ----
  
  • Last modified: 2020/01/07 01:05
  • by lou