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 1. If data is archived
  1. Channel doesn’t send the data against the System Invoice Line Item ID | 5 | | 32 | CGST Rate | CGST Tax Rate | 1. If data is archived
  2. Channel doesn’t send the data against the System Invoice Line Item ID | 5 | | 33 | SGST Rate | SGST Tax Rate | 1. If data is archived
  3. Channel doesn’t send the data against the System Invoice Line Item ID | 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 | 1. CANCELLED
  4. COMPLETED
  5. CREATED
  6. FULFILLABLE
  7. PACKED
  8. PICKING
  9. PROCESSING
  10. READY_TO_DISPATCH
  11. UNFULFILLABLE | | 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 | | 1. CANCELLED
  12. CLOSED
  13. DELIVERED
  14. DISPATCHED
  15. INVOICED
  16. MANIFESTED
  17. OPEN | | 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 1. Maximum date range : 92
  1. *sm | | 5 | Invoice Created Before | Invoice created till the date | | | 6 | Order Created From | Order created from the date | 1. Maximum date range : 92
  2. *sm | | 7 | Order Created To | Order created till the date | | | 8 | Handover From | Handover from the date | 1. Maximum date range : 92
  3. *sm | | 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 | 1. Maximum date range : 92
  4. *sm | | 15 | Cancelled To | Cancelled till the date | | | 16 | Packed/Shipment Closed From | Packed/Shipment Closed from the date | 1. Maximum date range : 92
  5. *sm | | 17 | Packed/Shipment Closed To | Packed/Shipment Closed till the date | |

FAQs

  1. Why are my Tax Rates empty (IGST Rate, SGST Rate, CGST Rate)?
    1. 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.