Provides Batch and SKU details of expired items based on the days since expiry.
| Fields | Description | This Column Can be NULL | Sample Data | |
|---|---|---|---|---|
| 1 | Fulfillment Location Name | Name of the fulfillment location | NA | wms_abc |
| 2 | Global SKU ID | Increff’s SKU ID | NA | 1146167939 |
| 3 | Client SKU ID/ EAN | SKU ID generated by client | NA | abcd123 |
| 4 | Internal Batch ID | Increff’s Batch ID | NA | 1422 |
| 5 | External Batch ID | Batch ID generated by client | NA | abcdABCD123 |
| 6 | Manufacturing Date | Date of manufacturing | NA | 07/07/22 |
| 7 | Expiry Date | Date of product Expiry | NA | 08/07/23 |
| 8 | Total Qty | Total QC Pass qty | NA | 45 |
| 9 | Days Since Expired | No of days since expired | NA | 19 |
| 10 | Style | Style | abcd123 | |
| 11 | Color | Color | 0 | |
| 12 | Size | Size | 105.6 | |
| 13 | MRP | MRP | 0 | |
| 14 | Brand | Brand | vuse | |
| 15 | Category | Category | abcd123 | |
| 16 | SKU Description | SKU Description | abcd123 |
| Filters | Description | Limitation |
|---|---|---|
| Client | Name of the client | Mandatory |
| SFS Locations | Name of the fulfilment locations | Mandatory |
| Days since Expiry | No. of days since expiry | Mandatory |