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, PURCHASE, |
| 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 % | If there is no tax data available for the invoice_item_id | 5 |
| 34 | CGST Rate | CGST % | If there is no tax data available for the invoice_item_id | 5 |
| 35 | SGST Rate | SGST % | If there is no tax data available for the invoice_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 | ||
| 48 | Customer City | City of customer | HYDERABAD | |
| 49 | Customer State | State of customer | PUNJAB | |
| 50 | Order Status | Status of the order |
| |
| 51 | Shipped Status | Status of the shipment |
| |
| 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 | Maximum date range : 92 |
| 4 | Invoice Created Before | Invoice created till the date | |
| 5 | Order Created From | Order created from the date | Maximum date range : 92 |
| 6 | Order Created To | Order created till the date | |
| 7 | Handover From | Handover from the date | Maximum date range : 92 |
| 8 | Handover To | Handover till the date | |
| 9 | Cancelled From | Cancelled from the date | Maximum date range : 92 |
| 10 | Cancelled To | Cancelled till the date | |
| 11 | Channel Order ID | Order ID by channel | NA |
| 12 | Shipment Status | Status of shipment | NA |
| 13 | Packed/Shipment Closed From | Packed/Shipment Closed from the date | Maximum date range : 92 |
| 14 | Packed/Shipment Closed To | Packed/Shipment Closed till the date |