Storage Locations Utilization
Stay organized with collections
Save and categorize content based on your preferences.
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) |
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-09-26 UTC.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2024-09-26 UTC."],[[["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."]]],["This data outlines the utilization of storage locations, detailing items stored within each. Key information includes: `storage_location_id`, `location_code`, `licence_plate_number`, `google_part_number`, `quantity_on_hand`, and `quantity_uom`. Also tracked are `project_code`, `item_country_of_origin`, `item_received_datetime_utc`, `expiration_date_time_utc`, and `data_extract_datetime_utc`. Each field has specified data types, requirements, and validation rules, such as maximum lengths, allowed formats, and foreign key references, ensuring the integrity of the data.\n"]]