B2C Outward SKU Wise Report - OMS
- Prakash Nagulapati
Navigate To
- 1 Description
- 2 Fields
- 3 Filters
- 4 FAQs
Description
Provides invoiced B2C Outward Orders with tax information, Customer details, life-cycle timestamps(creation, packed, SLA, manifest etc)
Fields
Fields | Description | This column can be null | Sample Data | |
|---|---|---|---|---|
| 1 | Client Name | Name of the Client | NA | Increff |
| 2 | Fulfilment Location Name | Name of the fulfilment location | NA | wms_hosur |
| 3 | Fulfilment Location City | City of the fulfilment location | NA | Hosur |
| 4 | Channel Order ID | Order ID from Channel | NA | aB12Pq34 |
| 5 | System Order ID | Increff’s unique Order ID | NA | 1231212312 |
| 6 | System Sub Order ID | Increff’s Unique Sub Order ID | NA | 1231212312 |
| 7 | Channel Parent Order Code | Parent Order ID from the Channel | Â If not provided by channel | Â abcd123 |
| 8 | Order QC Status | QC status of the order | NA | PASS or FAIL |
| 9 | Channel Invoice No | ID of the invoice created by channel | Â If not provided by channel | AB12CD34EF56 |
| 10 | System Invoice No | Increff’s Invoice ID | NA | 123123 |
| 11 | System Invoice Line Item ID | Increff’s Invoice Line Item ID | NA | 123123 |
| 12 | Channel Invoice Time | Invoice Created Timestamp | NA | 2023-01-01 10:10:00 |
| 13 | Sales Channel | Channel through which order is placed | NA | FLIPKARTV3 |
| 14 | Client SKU ID / EAN | Client SKU ID | NA | ABCD1234 |
| 15 | Virtual SKU | SKU is virtual or not | NA | TRUE or FALSE |
| 16 | SKU Description | Description of the SKU | If not provided | Custom Input |
| 17 | Style | Style ID of the SKU | Â | abcd |
| 18 | Brand | Brand of the SKU | Â | abcd |
| 19 | Size | Size of the item | Â | XL |
| 20 | Color | Color of the SKU | Â | Black |
| 21 | MRP | MRP of the SKU | NA | 999 |
| 22 | SO Quantity | Sales Order Quantity | NA | 5 |
| 23 | Dispatched Quantity | Quantity of items dispatched | NA | 4 |
| 24 | Payment Type | Customer’s payment type while placing order |  | COD |
| 25 | Unit Base Price | Base price per unit | NA | 89 |
| 26 | Unit Tax | Tax per unit | NA | 10 |
| 27 | Unit Sale Price | Selling Price per unit (Base plus Tax) | NA | 99 |
| 28 | Total Base Price | Base Price per unit multiplied by quantity | NA | 178 |
| 29 | Total Tax | Tax value per unit multiplied by quantity | NA | 20 |
| 30 | Total Sale Price | Actual Selling Price per unit multiplied by quantity | NA | 198 |
| 31 | IGST Rate | IGST Tax Rate |
| 5 |
| 32 | CGST Rate | CGST Tax Rate |
| 5 |
| 33 | SGST Rate | SGST Tax Rate |
| 5 |
| 34 | Discount | Total Discount at Order SKU level | Â | 100 |
| 35 | Shipping Charges | Total Shipping Charge at Order SKU level | Â | 50 |
| 36 | HSN Code | HSN Code of the SKU | Â | 234345 |
| 37 | Outward AWB No | Air Way Bill Number for a shipment | If not provided | abcd123 |
| 38 | Transporter | Transporter of shipment | NA | abcd123 |
| 39 | Customer City | City of the Customer | Â | Bangalore |
| 40 | Customer State | State of the Customer | Â | Karnataka |
| 41 | Customer pin | Shipping Pin Code of the Customer | Â | 560001 |
| 42 | Customer Billing Pin | Billing Pin Code of the Customer | Â | 560001 |
| 43 | Order Status | Status of the order | NA |
|
| 44 | System Shipment ID | Increff’s Shipment ID | NA | 1245 |
| 45 | External Shipment ID | Shipment ID created by the marketplace | Â | abcd123 |
| 46 | System Manifest ID | Increff’s Manifest ID | NA |  |
| 47 | System Order Time | Time when Order was created in the Increff System | NA | 2023-01-01 12:34:56 |
| 48 | Channel Order Time | Time when Order was placed in the Channel | NA | 2023-01-01 12:34:56 |
| 49 | SLA Time | Timestamp of SLA required by | NA | 2023-01-01 12:34:56 |
| 50 | Packed / Shipment Closed Time | Timestamp of SKU packed | Â | 2023-01-01 12:34:56 |
| 51 | Manifest Time | Timestamp of shipment manifest | Â | 2023-01-01 12:34:56 |
| 52 | Handover Time | Timestamp of shipment handover | Â | 2023-01-01 12:34:56 |
| 53 | Manifested within 24 Hours | If manifest is closed in 24 hours from order creation or not | If manifest is not yet closed | YES or NO |
| 54 | SLA Breach | Whether order has breached SLA or not | NA | YES or NO |
| 55 | Shipment Status | Status of shipment | Â |
|
| 56 | Shipment Status Updated Time | Time when shipment status was updated | Â | 2023-01-01 12:34:56 |
| 57 | Delivered At | Shipment Delivered Timestamp | Â | 2023-01-01 12:34:56 |
| 58 | Order Remarks | Remarks of order | Â | Custom Input |
Filters
Filters | Description | Limitation | |
|---|---|---|---|
| 1 | Client | Name of the client | Mandatory |
| 2 | Fulfilment Locations | Name of the fulfilment locations | Mandatory |
| 3 | Sales Channel | Name of the Sales Channel | NA |
| 4 | Invoice Created After | Invoice created from the date |
|
| 5 | Invoice Created Before | Invoice created till the date | |
| 6 | Order Created From | Order created from the date |
|
| 7 | Order Created To | Order created till the date | |
| 8 | Handover From | Handover from the date |
|
| 9 | Handover To | Handover till the date | |
| 10 | Channel Order ID | Order ID by channel | *sm |
| 11 | Parent Order ID | Parent order ID of channel | *sm |
| 12 | System Invoice ID | Increff’s Invoice ID | *sm |
| 13 | Internal Manifest ID | Increff’s Manifest ID | *sm |
| 14 | Cancelled From | Cancelled from the date |
|
| 15 | Cancelled To | Cancelled till the date | |
| 16 | Packed/Shipment Closed From | Packed/Shipment Closed from the date |
|
| 17 | Packed/Shipment Closed To | Packed/Shipment Closed till the date |
*sm : At least one of the filters tagged with this is a MUST to submit a report request.
FAQs
Why are my Tax Rates empty (IGST Rate, SGST Rate, CGST Rate)?
Data will be archived after certain period of time. Reports won’t fetch it from archival. Please reach out Increff team to know more about the archival mechanism of this particular data point.