This file will include details of all Google warehouse materials.
| Data element name | Description | Type | Required (Yes/No) | Validation rules |
|---|---|---|---|---|
| google_part_number | Google-issued part number.Unique identifier of the material. | String | Yes | |
| google_part_description | Description of the material. | String | Yes | |
| is_serial_number_tracked | Flag indicating whether serial numbers of the material are tracked. The attribute is set if we need the serial numbers to be tracked by the Warehouse Management System. WMS will store the serial numbers of all items in the warehouse and it will track the movement of these items as they are received, stored, picked, packed and shipped. If this flag is set to true, Ship Confirmation and Material Receipt transactions will need serial numbers to be specified. | Boolean | Yes | Values:True,False |
| is_expiration_controlled | Flag indicating whether material has an expiration date. For example, if batteries are expired specific ops procedure to handle expired batteries is applied such as proper disposition procedures. | Boolean | Yes | Values:True,False |
| is_container_id_tracked | Flag indicating whether the container IDs for the material are tracked. If this flag is set to true, WMS will need to tracks LPNs. Container IDs are often tracked in warehouse management systems (WMS) along with license plate numbers (LPNs). LPNs are unique identifiers that are assigned to individual pallets, totes, or other units of inventory. This flag has no implications on transactions. | Boolean | Yes | Values:True,False |
| is_cage_tracked | Indicates if this item needs to be stored in a high value cage. HRI / Cage Tracked Inventory is list of sensitive commodities which require stronger protection across the manufacturing and logistics supply chain. These items are hence proprietary or high value component and require. additional security activities. | Boolean | Yes | Values:True,False |
| is_dangerous_goods | Indicates if this Item/material is classified as dangerous goods. | Boolean | Yes | Values:True,False |
| un_number | If material is considered dangerous good, it will have an associated United Nations number for the dangerous goods. UN number is a four digit number that identifies dangerous goods, hazardous substances and articles (such as explosives, flammable liquids, toxic substances) Examples: UN 1139, UN 1956, UN 2807. | String | No | |
| packaging_google_part_number | Packaging Google Part Number. Optional field. | String | No | |
| 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) |