B2C Order Wise SLA and Pendency Report
Navigate To
- 1 Description
- 2 Fields
- 3 Filters
- 4 FAQs
Description
Provides order wise leg to leg time taken and pending qty.
Fields
Fields | Description | This column can be null | Sample Data | |
---|---|---|---|---|
1 | Client Name | Name of the client | NA | Increff |
2 | Fulfillment Location Name | Name of the Fulfillment Location | NA | wms_hosur |
3 | Sales Channel | Channel through which order is placed | Â | FLIPKARTV3 |
4 | Channel Order Date | Order placed timestamp | Â | 2023-01-01 12:34:56 |
5 | Channel Order No | Order ID from channel | Â | abcd123 |
6 | System Order ID | Increff’s unique Order ID | NA | 5234242342 |
7 | System Sub Order ID | Increff’s Unique Sub Order ID | NA | 1231212312 |
8 | Order Type | Type of order | NA | SALES |
9 | SLA Breach | Whether order has breached SLA or not | NA | YES or NO |
10 | Order Qty | Quantity Ordered | NA | 423 |
11 | Cancelled Qty | Quantity Cancelled | NA | 454 |
12 | Reserve Qty | Quantity Reserved | NA | 6453 |
13 | Dispatched / Packed Qty | Quantity Dispatched or Packed | NA | 523 |
14 | Pending Qty | Quantity Pending | NA | 534 |
15 | Unfulfillable Qty | Quantity unfulfillable | NA | 534 |
16 | OMS Order time to WMS Order time in Hrs | Hours Taken to Create Order in WMS from OMS | If WMS order is not yet created | 0.012 |
17 | WMS Order Creation to Last Picked in Hrs | Hours Taken to Complete Picking from Order Creation in WMS | If no items were picked yet | 1.23 |
18 | Last Picked to Invoice Creation in Hrs | Hours Taken to Create Invoice after Last Item Picked | If Invoice is not yet created | 42.42 |
19 | Invoice Time to Manifest Time in Hrs | Hours Taken to Manifest after Invoice | If manifest is not yet created | 5.32 |
20 | Manifest Time to Handover Time | Hours Taken to Handover a Shipment after Manifested | If not handed over yet | 43.11 |
Filters
Filters | Description | Limitation | |
---|---|---|---|
1 | Order Created From | Order created from the date |
|
2 | Order Created To | Order created to the date | |
3 | Channel Order Number | Order ID from channel | NA |
4 | System Order ID | Increff’s unique Order ID | NA |
5 | System Sub Order ID | Increff’s Unique Sub Order ID | NA |