SFS : B2C Outward Sku Wise Report - OMS
- Prakash Nagulapati
Navigate To:
- 1 Description
- 2 Fields
- 3 Filters
Description
Provides invoiced B2C Outward Orders with tax information, Customer details, life-cycle timestamps(creation, packed, SLA, manifest etc) for SFS orders.
Fields
Fields | Description | This column can be null | Sample Data | |
|---|---|---|---|---|
| 1 | Fulfillment Location Name | Name of the fulfilment location | NA | wms_sfast |
| 2 | Fulfilment Location City | City of the fulfilment location | NA | BANGALORE |
| 3 | Channel Order ID | Order ID from Channel | NA | DFZB3V1v7 |
| 4 | System Order ID | Increff’s unique Order ID | NA | 24041298 |
| 5 | System Sub Order ID | Increff’s Unique Sub Order ID | NA | 22975618 |
| 6 | Channel Parent Order ID | Parent Order ID from the Channel | NA | 406-4063010-1309931 |
| 7 | Order QC Status | QC status of the order | NA | PASS |
| 8 | Channel Invoice No | ID of the invoice created by channel | NA | IN-26338 |
| 9 | System Invoice No | Increff’s Invoice ID | NA | 20483435 |
| 10 | System Invoice Line Item ID | Increff’s Invoice Line Item ID | NA | 49704894 |
| 11 | Channel Invoice Time | Invoice Created Timestamp | NA | 01/07/23 0:00 |
| 12 | Sales Channel | Channel through which order is placed | NA | AMAZON_SC_ES |
| 13 | Client SKU ID / EAN | Client SKU ID | NA | 4.06545E+12 |
| 14 | SKU Description | Description of the SKU | NA | Quarter Socks 3P |
| 15 | Style | Style ID of the SKU |
| 93371801 |
| 16 | Brand | Brand of the SKU |
| PUMA |
| 17 | Size | Size of the item |
| 39/42 |
| 18 | Color | Color of the SKU |
| Black/ Forest Night/ Navy |
| 19 | Category | Category of the SKU |
| Accessories |
| 20 | MRP | MRP of the SKU |
| 599 |
| 21 | SO Quantity | Sales Order Quantity | NA | 1 |
| 22 | Dispatched Quantity | Quantity of items dispatched |
| 1 |
| 23 | Payment Type | Customer’s payment type while placing order |
| NCOD |
| 24 | Unit Sale Price | Selling Price per unit (Base plus Tax) |
| 389 |
| 25 | Unit Base Price | Base price per unit |
| 347.32 |
| 26 | Unit Tax | Tax per unit |
| 41.68 |
| 27 | Total Base Price | Base Price per unit multiplied by quantity |
| 347.32 |
| 28 | Total Tax | Tax value per unit multiplied by quantity |
| 41.68 |
| 29 | Total Sale Price | Actual Selling Price per unit multiplied by quantity |
| 389 |
| 30 | Discount | Total Discount at Order SKU level |
| 0 |
| 31 | IGST Rate | IGST Tax Rate |
| 12 |
| 32 | CGST Rate | CGST Tax Rate |
|
|
| 33 | SGST Rate | SGST Tax Rate |
|
|
| 34 | HSN Code | HSN Code of the SKU |
| 61159500 |
| 35 | Customer TIN | GST No. of customer |
| NA |
| 36 | Outward AWB No | Outward tracking number |
| 3.24849E+11 |
| 37 | Transporter | Transporter of shipment |
| ATS |
| 38 | Customer Name | Name of customer |
| John Doe |
| 39 | Customer E-Mail | Email ID of customer |
|
|
| 40 | Customer Contact Number | Contact number of customer |
|
|
| 41 | Customer City | City of the Customer |
|
|
| 42 | Customer State | State of the Customer |
| KARNATAKA |
| 43 | Customer Pin | Shipping Pin Code of the Customer |
| 854318 |
| 44 | Customer Billing Pin | Billing Pin Code of the Customer |
| 854318 |
| 45 | Order Status | Status of the order |
| COMPLETED |
| 46 | System Manifest ID | Increff’s Manifest ID |
| 676352 |
| 47 | Picklist ID | Increff’s picklist ID |
| 37495 |
| 48 | System Order Time | Time when Order was created in the Increff System |
| 29/06/23 8:23 |
| 49 | Channel Order Time | Time when Order was placed in the Channel |
| 29/06/23 8:22 |
| 50 | SLA Time | Timestamp of SLA required by |
| 01/07/23 23:59 |
| 51 | Packed Time | Timestamp of SKU packed |
| 30/06/23 23:59 |
| 52 | Manifest Time | Timestamp of shipment manifest |
| 01/07/23 13:06 |
| 53 | Handover Time | Timestamp of shipment handover |
| 01/07/23 13:24 |
| 54 | Manifested within 24 hours | If manifest is closed in 24 hours from order creation or not | NA | NO |
| 55 | SLA Breached | Whether order has breached SLA or not | NA | NO |
| 56 | Order Remarks | Remarks of order | yes |
|
Filters
Filters | Description | Limitation | |
|---|---|---|---|
| 1 | Client | Name of the client | Mandatory |
| 2 | SFS Locations | Name of the fulfilment locations | Mandatory |
| 3 | Sales Channel | Name of the Sales Channel | NA |
| 4 | Invoice Created From | Invoice created from the date | Maximum date range : 31 |
| 5 | Invoice Created To | Invoice created till the date | |
| 6 | Order Created From | Order created from the date | Maximum date range : 1 |
| 7 | Order Created To | Order created till the date | |
| 8 | Channel Order ID | Order ID by channel | NA |