Navigate To
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 | Maximum date range : 92 |
| 5 | Invoice Created Before | Invoice created till the date | |
| 6 | Order Created From | Order created from the date | Maximum date range : 92 |
| 7 | Order Created To | Order created till the date | |
| 8 | Handover From | Handover from the date | Maximum date range : 92 |
| 9 | Handover To | Handover till the date | |
| 10 | Channel Order ID | Order ID by channel | |
| 11 | Parent Order ID | Parent order ID of channel | |
| 12 | System Invoice ID | Increff’s Invoice ID | |
| 13 | Internal Manifest ID | Increff’s Manifest ID | |
| 14 | Cancelled From | Cancelled from the date | Maximum date range : 92 |
| 15 | Cancelled To | Cancelled till the date | |
| 16 | Packed/Shipment Closed From | Packed/Shipment Closed from the date | Maximum date range : 92 |
| 17 | Packed/Shipment Closed To | Packed/Shipment Closed till the date |