...
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 % |
| 5 |
| 34 | CGST Rate | CGST % |
| 5 |
| 35 | SGST Rate | SGST % |
| 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 | 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 |
|
| 4 | Invoice Created Before | Invoice created till the date | |
| 5 | Order Created From | Order created from the date |
|
| 6 | Order Created To | Order created till the date | |
| 7 | Handover From | Handover from the date |
|
| 8 | Handover To | Handover till the date | |
| 9 | Cancelled From | Cancelled from the date |
|
| 10 | Cancelled To | Cancelled till the date | |
| 11 | Channel Order ID | Order ID by channel | NA*sm |
| 12 | Shipment Status | Status of shipment | NA |
| 13 | Packed/Shipment Closed From | Packed/Shipment Closed from the date |
|
| 14 | Packed/Shipment Closed To | Packed/Shipment Closed till the date |
*sm : At least one of the filters tagged with this is a MUST to submit a report request.
FAQs
Why are my Tax Rates empty (IGST Rate, SGST Rate, CGST Rate)?
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.