This file will include all the Cycle Count transactions for the previous 24 hrs from the data extraction time and all the records not included in the previous file.
| Data element name | Description | Type | Required (Yes/No) | Validation rules |
|---|---|---|---|---|
| cycle_count_id | Cycle Count unique identifier that give unique number for each cycle count action. This is generated by 3PL partner WMS systems. | String | Yes | Max Length: 50 |
| licence_plate_number | Licence Plate Number (LPN), unique identifiers that are assigned to individual handling units of inventory that were counted. | 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 |
| location_code | Google provided location code. | String | Yes | Max Length: 50 |
| count_batch_id | Count batch ID, the individual count id is associated with, one batch id can have many Cycle count IDs. Blank if the counting is not based on batches. | String | No | Max Length: 50 |
| count_status | Status of the count. | String | Yes | List of valid values |
| count_type | Type of count. | String | Yes | List of valid values |
| count_sequence | Sequence of the count (1, 2, 3) | Integer | Yes | Values:1,2 or 3 |
| count_method | Method of performing inventory counting during cycle count process. | String | Yes | List of valid values |
| storage_location_id | Storage location of an item refers to the specific physical location within the warehouse where inventory items are stored and counted. | String | Yes | FK: StorageLocations.storage_location_id; Max Length: 50 |
| system_quantity | Quantity that was expected based on the WMS inventory record in 3PL WMS system. | Integer | Yes | Min Value: 0 |
| count_quantity | Quantity that was actually counted. | Integer | Yes | Min Value: 0 |
| previous_cycle_count_id | Cycle count ID of the first cycle count operation. | String | No | Max Length: 50 |
| count_create_datetime_utc | Date time in UTC when the cycle count was created. | Datetime | Yes | Format: yyyy-mm-ddThh:mm:ssZ (ISO 8601) |
| count_close_datetime_utc | Date time in UTC when the cycle count was completed and closed. | Datetime | No | Format: yyyy-mm-ddThh:mm:ssZ (ISO 8601) |
| batch_close_datetime_utc | Date time in UTC when the batch count was completed. | Datetime | No | Format: yyyy-mm-ddThh:mm:ssZ (ISO 8601) |
| count_performed_by | UserID (in 3PL systems) of the user that completed the count. | String | No | 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) |