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 |