SFS : Outward Order Status Report Detail - OMS
- Prakash Nagulapati
Navigate To:
- 1 Description
- 2 Fields
- 3 Filters
Description
Provides Outward Order details at Order-SKU level with all the relevant information for SFS orders.
Fields
Fields | Description | This column can be null | Sample Data | |
|---|---|---|---|---|
| 1 | Client Name | Name of the client | NA | increff |
| 2 | Fulfillment Location Name | Name of fulfilment location | NA | wms_sfast |
| 3 | Channel Order ID | Order ID by channel | Â NA | 557344e3-3112-4614-9304-ad00dbc96e42 |
| 4 | Channel Parent Order Code | Parent Order ID from the Channel | Â | OD328500508079303100 |
| 5 | System Order ID | Increff’s unique Order ID | NA | 24096644 |
| 6 | System Sub Order ID | Increff’s Unique Sub Order ID | NA | 23031012 |
| 7 | System Sub Order Item ID | Increff’s Unique Sub Order Item ID | NA | 54008013 |
| 8 | Order Type | Type of order | NA | SALES |
| 9 | Party | Partner’s name | NA | Default_CUSTOMER |
| 10 | Pin Code | Pin Code | If not provided | 251201 |
| 11 | Status | Status of order w.r.t. channel | NA | COMPLETED |
| 12 | Sales Channel | Channel through which order is placed | Â | FLIPKARTV3 |
| 13 | On Hold | If is on hold or not | NA | 0 |
| 14 | System Order Date | OMS Order Creation Timestamp | NA | 01/07/23 0:00 |
| 15 | Channel Order Date | Ordered Timestamp by Channel | NA | 30/06/23 23:59 |
| 16 | Order Release Time | Order Processing Starting Timestamp | Â | 01/07/23 0:04 |
| 17 | SLA Time | SLA Required By Timestamp | Â | 03/07/23 16:00 |
| 18 | Manifest Closing Time | Timestamp of Manifest Closed | NA | 02/07/23 14:31 |
| 19 | Remarks | Remarks if any | If not provided | Â |
| 20 | Gift | A gift or not | NA | 0 |
| 21 | Pack Type | Type of packing - B2B or B2C | NA | B2C |
| 22 | Order Resolution | Â | Â Â | RECEIVED_BY_TRANSPORTER |
| 23 | Client SKU ID / EAN | Client SKU ID / EAN | Â | 4.06454E+12 |
| 24 | Virtual SKU | Virtual SKU | Â | 0 |
| 25 | Category | Category | Â | Apparel |
| 26 | Style | Style | Â | 67038901 |
| 27 | Color | Color | Â | Puma Black |
| 28 | Size | Size | Â | L |
| 29 | Brand | Brand | Â | PUMA |
| 30 | Internal Batch ID | Â | Â | Â |
| 31 | Min Expiry | Â | Â | Â |
| 32 | Order Qty | Â | Â | 1 |
| 33 | Cancelled Qty | Â | Â | 0 |
| 34 | Reserve Qty | Â | Â | 0 |
| 35 | Customer Cancelled Qty | Â | Â | 0 |
| 36 | Seller Cancelled Qty | Â | Â | 0 |
| 37 | Max Allocated Qty | Â | Â | 1 |
| 38 | Packed/ Dispatched Qty | Â | Â | 1 |
| 39 | Dispatched Qty | Â | Â | 1 |
| 40 | Pack Pending Qty | Â | Â | 0 |
| 41 | Unfulfillable Qty | Â | Â | 0 |
| 42 | Sorted Qty | Â | Â | 0 |
| 43 | Fulfilled Pc | Â | Â | 1 |
| 44 | Order MRP Amount | Â | Â | 2999 |
| 45 | Order Amount | Â | Â | 1509 |
| 46 | Shipping Charge | Â | Â | 10 |
| 47 | Gift Charge | Gift Charges | If not provided | 0 |
| 48 | Pick List ID | Â | Â | 37621 |
| 49 | Shipment Status | Â | Â | DISPATCHED |
| 50 | Manifest ID | Â | Â | 677749 |
| 51 | AWB No. | Â | Â | FMPC2863330778 |
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 | Brand | Â | Â |
| 5 | Order Created From | Order created from the date | Maximum date range : 31 |
| 6 | Order Created To | Order created till the date | |
| 7 | Required By From | Required from the date | Maximum date range : 31 |
| 8 | Required By To | Required till the date | |
| 9 | Order Status | Status of order | NA |
| 10 | Parent Order ID | Parent order ID of channel | NA |
| 11 | Channel Order ID | Order ID by channel | NA |
| 12 | System Order ID | Increff’s unique system order ID | NA |
| 13 | System Sub Order ID | Increff’s unique sub order ID | NA |
| 14 | Party | Â | NA |
| 15 | Virtual / Combo Perspective | Marketplace or Warehouse perspective | Mandatory, Single Select |
| 16 | Client SKU ID | Client’s SKU ID / EAN | NA |
| 17 | Business | B2B, B2C | NA |