Outward Summary Report - OMS
- Prakash Nagulapati
Navigate To
- 1 Description
- 2 Fields
- 3 Filters
- 4 FAQs
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
Â
Â
Â