Include all the Inbound Order transactions for the previous 1 hour and all the records not included in the previous file.
| Data element name | Description | Type | Required (Yes/No) | Validation rules |
|---|---|---|---|---|
| inbound_order_number | Google provided PO or Move order number. | String | Yes | Max Length: 50 |
| warehouse_shipment_id | Unique identifier for this shipment issued by the shipping partner. | String | Yes | Max Length: 50 |
| advanced_shipment_notice_id | Unique identifier for the advanced shipment notice (ASN). | String | No | Max Length: 50 |
| order_type | Order type identifying the type of inbound order. | String | No | List of valid values |
| tracking_number | Carrier Tracking Number of the Inbound order received. | String | No | Max Length: 50 |
| google_transport_load_id | Reference to the Transport Load planned by Google's Transportation Management System (TMS) for this shipment, when applicable. | String | No | Max Length: 50 |
| trailer_number | Physical Trailer Number. Systemic trailer number the order is received on, which should match the physical trailer number. | String | No | Max Length: 50 |
| dock_door_number | Dock door the trailer is docked at and the material is unloaded from. | String | No | Max Length: 50 |
| last_wms_order_status | Most recent status of the order based on the operational process flow. | String | No | List of valid values |
| next_wms_order_status | Next expected status based on the operational process flow. | String | No | List of valid values |
| delivered_date_time_utc | Date time the trailer containing the material was delivered at the facility. | Datetime | No | Format: yyyy-mm-ddThh:mm:ssZ (ISO 8601) |
| trailer_docked_date_time_utc | Date time the trailer containing the material is docked at the dock door. | Datetime | No | Format: yyyy-mm-ddThh:mm:ssZ (ISO 8601) |
| unload_start_date_time_utc | Date time the first unit (e.g. pallet, carton) of material for the order is unloaded from the trailer. | Datetime | No | Format: yyyy-mm-ddThh:mm:ssZ (ISO 8601) |
| unload_end_date_time_utc | Date time the last unit (e.g. pallet, carton) of material for the order is unloaded from the trailer. | Datetime | No | Format: yyyy-mm-ddThh:mm:ssZ (ISO 8601) |
| dispatch_date_time_utc | Date time the trailer is closed and dispatched from the dock door. | Datetime | No | Format: yyyy-mm-ddThh:mm:ssZ (ISO 8601) |
| receipt_start_date_time_utc | Date time the first unit of material for the order is received. | Datetime | No | Format: yyyy-mm-ddThh:mm:ssZ (ISO 8601) |
| receipt_end_date_time_utc | Date time the last unit of material for the order is received. | Datetime | No | Format: yyyy-mm-ddThh:mm:ssZ (ISO 8601) |
| putaway_start_date_time_utc | Date time the first unit of material for the order is put away. | Datetime | No | Format: yyyy-mm-ddThh:mm:ssZ (ISO 8601) |
| putaway_end_date_time_utc | Date time the last unit of material for the order is put away. | Datetime | No | Format: yyyy-mm-ddThh:mm:ssZ (ISO 8601) |
| source_google_location_code | The code of location where the items are shipped from. | String | Yes | Max Length: 50 |
| destination_google_location_code | The code of location where the items are shipped to. | String | Yes | Max Length: 50 |
| 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) |