Navigate To

Description

Provides Invoiced Outward Orders at Order-Invoice level data with their Tax Split ups.

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 fulfilment location NA wms_hosur
3 Channel Order ID Order ID by channel NA aB12Pq34
4 Parent Order Code Parent Order ID from the Channel abcd123
5 System Order ID Increff’s unique Order ID NA 1231212312
6 System Sub Order ID Increff’s Unique Sub Order ID NA 12
7 Sales Channel Channel through which order is placed FLIPKARTV3
8 Order Type Type of order NA SALES
9 Channel Invoice ID Channel’s Invoice Number AB12CD34EF56
10 System Invoice ID Increff’s Invoice ID NA 123123
11 Warehouse City City of fulfilment location If not provided PATNA
12 Invoice Time Invoice Created Timestamp NA 2023-01-01 10:10:00
13 Customer Name Customer Name abcd
14 Ship to Customer Name Customer who is supposed to receive the shipment If not provided abcd
15 Customer City City If not provided PATNA
16 SO Qty Sales Quantity NA 34
17 Dispatch Qty Quantity dispatched NA 23
18 Total Base Price Base price considering quantity NA 178
19 IGST Rate IGST % 5
20 CGST Rate CGST % 5
21 SGST Rate SGST % 5
22 Total Sale Price Actual Selling Price considering quantity NA 198
23 Total dispatched Value Actual Selling Price considering quantity NA 198
24 Channel Order Time Order placed timestamp 2023-01-01 12:34:56
25 Order Creation Time OMS Order Creation Timestamp 2023-01-01 12:34:56
26 Order Release Time Start Processing Timestamp of the Order 2023-01-01 12:34:56
27 Required By Timestamp of SLA required by 2023-01-01 12:34:56
28 Packed Time Timestamp of item packed 2023-01-01 12:34:56
29 AWB Number Air Way Bill Number
30 Transporter Transporter of shipment NA abcd123
31 Box Count Count of boxes in DISPATCHED, CLOSE, PACKED statuses NA 12
32 Shipment Updated Time Shipment Updated Time 2023-01-01 12:34:56
33 Handover Time Timestamp of shipment handover 2023-01-01 12:34:56
34 Remarks Remarks if any If not provided String
35 Shipment ID
36 Shipment Status Status of Shipment DISPATCHED
37 Package SKU If it is a Package SKU or not True / False
38 Order Resolution Order Resolution CUSTOMER_CANCELLED
39 Customer Country Country If not provided INDIA
40 Customer Pincode Pin Code If not provided 560031

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 Reservation Pool Reservation Pool NA
5 Invoice Created From Invoice created from the date Maximum date range : 31
6 Invoice Created To Invoice created till the date
7 Handover From Handover from the date Maximum date range : 31
8 Handover To Handover till the date
9 Cancelled From Cancelled from the date Maximum date range : 31
10 Cancelled To Cancelled till the date
11 System Invoice ID Increff’s Invoice ID NA
12 Business Pack Type NA
13 Shipment Status Shipment Statuses NA
14 Order Creation From Order Creation From Maximum date range : 31
15 Order Creation To Order Creation To
16 Order Release From Order Release From Maximum date range : 31
17 Order Release To Order Release To

FAQs