AI-generated Key Takeaways
-
This documentation outlines the required data elements for sharing storage location information from a 3PL partner's warehouse system.
-
Each storage location is uniquely identified by
storage_location_idand linked to a Google-providedwarehouse_code. -
Data points include storage type, area, zone, status, capacity, and various dimensions (weight, height, length, width, volume) along with their respective units of measure.
-
Validation rules and lists of accepted values for specific fields are provided through external links for standardization.
-
The
data_extract_datetime_utcfield ensures data timestamping for tracking and reconciliation purposes.
Include all storage locations associated with the 3PL operator/partner.
| 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 | Max Length: 50 |
| warehouse_code | Google provided physical location identifier. | String | Yes | Max Length: 50 |
| source_wms | Warehouse Management System used by the 3PL Partners | String | Yes | Max Length: 50 |
| storage_type | Type of storage. | String | Yes | List of valid values |
| storage_area | Warehouse area with which the storage location is associated. | String | Yes | List of valid values |
| storage_zone | Warehouse zone with which the storage location is associated. | String | Yes | List of recommended values |
| storage_location_status | Indicates the current status of the storage location. | String | Yes | List of valid values |
| capacity | Capacity of the storage location (e.g. location with 12 pallet positions would have a capacity of 12) | Integer | No | Min Value: 0 |
| capacity_uom | Unit of measure of the capacity.(e.g. Pallets) | String | No | Max Length: 50 |
| weight | Weight capacity for this storage location | Number | No | Precision: 38, Scale: 9 |
| weight_uom | Unit of measure of the weight. | String | No | List of valid values |
| height | Height capacity for this storage location. | Number | No | Precision: 38, Scale: 9 |
| height_uom | Unit of measure of the height. | String | No | List of valid values |
| length | Length capacity for this storage location. | Number | No | Precision: 38, Scale: 9 |
| length_uom | Unit of measure of the length. | String | No | List of valid values |
| width | Width capacity for this storage location. | Number | No | Precision: 38, Scale: 9 |
| width_uom | Unit of measure of the width. | String | No | List of valid values |
| volume | Volume capacity for this storage location. | Number | No | Precision: 38, Scale: 9 |
| volume_uom | Unit of measure of the quantity. | String | No | List of valid values |
| 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) |