Navigate To

Description

Provides invoiced B2B 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 ID Unique ID of Fulfilment location NA 1231212312
4 Fulfilment Location City City of Fulfilment Location If not defined in addresses DELHI
5 Channel Order ID Order ID from channel abcd123
6 System Order ID Increff’s unique Order ID NA 1231212
7 System Sub Order ID Increff’s Unique Sub Order ID NA 1231212312
8 Parent Order ID Parent Order ID from channel abcd123
9 Order Type Type of order NA SALES,
RETURNS,
PURCHASE,
STOCK TRANSFER
10 Order QC Status QC Status of order NA PASS or FAIL
11 Channel Invoice No Invoice number from channel abcd123
12 System Invoice No Increff’s Invoice ID NA 1231212312
13 Channel Invoice Time Channel Invoice’s timestamp NA 2023-01-01 12:34:56
14 Client SKU ID / EAN Client’s SKU ID / EAN NA abcd123
15 Virtual SKU SKU is virtual or not NA TRUE or FALSE
16 SKU Description Custom Description of SKU NA custom field
17 Sales Channel Channel through which order is placed NA FLIPKARTV3
18 Style Style ID of the sub order abcd123
19 Brand Brand of the SKU abcd123
20 Size Size of the SKU XL
21 Color Color of the SKU Blue
22 Category Category of the SKU Casual Shirts
23 MRP MRP 999
24 SO Quantity Ordered Quantity NA 5
25 Dispatched Quantity Quantity of items dispatched 4
26 Unit Sale Price Selling Price per unit (Base plus Tax) NA 99
27 Unit Base Price Base price of one unit of the item NA 89
28 Unit Tax Tax per unit of the item NA 10
29 Total Base Price(SO) Base price considering dispatched quantity NA 178
30 Total Tax Tax considering dispatched quantity NA 20
31 Total Sale Price(SO) Actual Selling Price considering ordered quantity NA 396
32 Total Dispatched Value Actual Selling Price considering dispatched quantity NA 198
33 IGST Rate IGST % 1. If data is archived
  1. Channel doesn’t send the data against the System Invoice Line Item ID | 5 | | 34 | CGST Rate | CGST % | 1. If data is archived
  2. Channel doesn’t send the data against the System Invoice Line Item ID | 5 | | 35 | SGST Rate | SGST % | 1. If data is archived
  3. Channel doesn’t send the data against the System Invoice Line Item ID | 5 | | 36 | IGST Tax Per Unit | IGST Tax per unit | If there is no tax data available for the invoice_item_id | 5 | | 37 | CGST Tax Per Unit | CGST Tax per unit | If there is no tax data available for the invoice_item_id | 5 | | 38 | SGST Tax Per Unit | SGST Tax per unit | If there is no tax data available for the invoice_item_id | 5 | | 39 | HSN Code | HSN ID | | 12435 | | 40 | Customer TIN | Customer’s GST Number | | | | 41 | Transporter | Transporter | | | | 42 | LR No | LR Number | | | | 43 | Vehicle No | Vehicle Number | | | | 44 | Customer Name | Name of the Customer | | Increff | | 45 | Customer ID | ID of the customer | | 1231212 | | 46 | Customer Contact Number | Contact Number of customer | | 9876512345 | | 47 | Customer Contact Email | Email of customer | | [email protected] | | 48 | Customer City | City of customer | | HYDERABAD | | 49 | Customer State | State of customer | | PUNJAB | | 50 | Order Status | Status of the order | | 1. CANCELLED
  4. COMPLETED
  5. CREATED
  6. FULFILLABLE
  7. PACKED
  8. PICKING
  9. PROCESSING
  10. READY_TO_DISPATCH
  11. UNFULFILLABLE | | 51 | Shipped Status | Status of the shipment | | 1. CANCELLED
  12. CLOSED
  13. DELIVERED
  14. DISPATCHED
  15. INVOICED
  16. MANIFESTED
  17. OPEN | | 52 | System Shipment ID | Increff’s unique shipment ID | | 12312123 | | 53 | Channel Order Time | Order placed timestamp | | 2023-01-01 12:34:56 | | 54 | Packed / Shipment Closed Time | Timestamp of item packed | | 2023-01-01 12:34:56 | | 55 | Shipment Status Updated Time | Timestamp of shipment status update | | 2023-01-01 12:34:56 | | 56 | Handover Time | Timestamp of shipment handover | | 2023-01-01 12:34:56 | | 57 | Delivered At | Timestamp of shipment delivery | | 2023-01-01 12:34:56 | | 58 | Order Remarks | Remarks of order | | Custom Input |

Filters

Filters Description Limitation
1 Fulfilment Locations Name of fulfilment locations Mandatory
2 Client Name of the client Mandatory
3 Invoice Created After Invoice created from the date 1. Maximum date range : 92
  1. *sm | | 4 | Invoice Created Before | Invoice created till the date | | | 5 | Order Created From | Order created from the date | 1. Maximum date range : 92
  2. *sm | | 6 | Order Created To | Order created till the date | | | 7 | Handover From | Handover from the date | 1. Maximum date range : 92
  3. *sm | | 8 | Handover To | Handover till the date | | | 9 | Cancelled From | Cancelled from the date | 1. Maximum date range : 92
  4. *sm | | 10 | Cancelled To | Cancelled till the date | | | 11 | Channel Order ID | Order ID by channel | *sm | | 12 | Shipment Status | Status of shipment | NA | | 13 | Packed/Shipment Closed From | Packed/Shipment Closed from the date | 1. Maximum date range : 92
  5. *sm | | 14 | 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.