Description
This report provides inventory details by SKU at each Flexport Reserve storage facility for a given date.
Report for a specific date would have inventory counts as on morning of the selected date.
Documentation
| Column | Description |
| createdat | Timestamp of report creation in UTC |
| sellerId | Unique identifier of seller account in Flexport |
| Snapshot DATE | Timestamp of inventory sync in UTC |
| Name | Name of the SKU in inventory |
| SKU | MSKU of the SKU, which is automatically imported with merchants product and can be updated in Inventory Details |
| Barcode | Barcode(s) tied to the SKU |
| Facility Location | The city where inventory is located. |
| Warehouse ID | The facility where inventory is located |
| DSKU | Flexport SKU (DSKU) of product. This is a unique identifier Flexport uses for all SKUs in the Flexport network. |
| PalletId (LPN) | The pallet identification where the SKU is stored |
| Lot Number | The lot number provided by merchant or captured during receiving |
| Expiration Date | The expiry date of products provided by merchant or captured during receiving |
| Case Quantity | The case pack quantity of the inventory |
| Total Qty | The total on-hand quantity of inventory in the facility |
| Total Cases | The total on-hand cases of inventory in facility |
| Available in Reserve | Amount of available inventory of the SKU in the specified reserve facility. |
| Unavailable Qty | Amount of unavailable inventory in the facility |
| Processing in Reserve | Amount of inventory being processed in the facility |
| AGE (Days) | Age of the inventory in days at LPN in the warehouse |
| First Available At | The date when the SKU in the LPN was made available for the first time |