Storage Locations Utilization

  • This dataset provides detailed inventory data for each storage location within a 3PL warehouse.

  • Information includes item details like Google Part Number (GPN), quantity, unit of measure, and project allocation.

  • The data also includes timestamps for item reception, expiration (if applicable), and data extraction.

  • Each record is uniquely identified by the storage location ID and licence plate number.

Storage location utilization data with the details of items stored in each Location.

Data element name Description Type Required (Yes/No) Validation rules
storage_location_id Unique identifier of the storage Location generated within the 3PL warehouse system. String Yes FK: StorageLocations.storage_location_id; Max Length: 50
location_code Google provided location code. String Yes Max Length: 50
licence_plate_number Licence Plate Number (LPN) the material that was counted was associated with. String Yes Max Length: 50
google_part_number GPN (Google Part Number) is a unique identifier for the specification of a part (or assembly). String Yes Max Length: 50
quantity_on_hand Quantity of the item stored in this location. Integer Yes Min Value: 0
quantity_uom Unit of measure of the quantity. String Yes List of recommended values
project_code Project Code as in source WMS. This is assigned by google for items allocation to specific projects. String Yes Max Length: 50
item_country_of_origin GPN country of Origin where the part was manufactured. String Yes Max Length: 2 (ISO 3166-1 alpha-2)
item_received_datetime_utc Date time when the item was received at the warehouse storage location. Datetime Yes Format: yyyy-mm-ddThh:mm:ssZ (ISO 8601)
expiration_date_time_utc Date time the LPN will expire. Datetime No Format: yyyy-mm-ddThh:mm:ssZ (ISO 8601)
data_extract_datetime_utc Date time the report/data was generated from the 3PL system. Datetime Yes Format: yyyy-mm-ddThh:mm:ssZ (ISO 8601)