Navigate To

Description

Provides return order details at Item level.

Fields

1. RETURN_TO_ORIGIN
2. CUSTOMER_RETURN | 1.When no expectation present 2.When it is an excess return | CUSTOMER_RETURN | | 6 | System Return ID | System return order ID | 1.When no expectation present 2.When it is an excess return | 291473 | | 7 | Return Order Item ID | System Return order line Item ID | When Return not processed | 34227 | | 8 | Channel Return ID | Channel retun order ID | 1.When no expectation present 2.When it is an excess return | U100ML11211141 | | 9 | Forward Order Creation Time | Time when the Forward Order was Created | NA | 21/09/2019 12:07:08 | | 10 | Forward Fulfillment Location Name | Fulfillment Location Name of the dispatched forward order | If the forward outward order is a split order | wms_abc | | 11 | Return Gate Entry No | Gate entry ID of returns | When the Return order is not scanned against a gate entry | 1142 | | 12 | Return GateEntry Item ID | Gate Entry Item ID of returns | When no item is received against the return gate entry item | 1234 | | 13 | Return Gate Entry AWB | AWB No of the Return Item scanned against the Return Gate Entry | When no item is received against the return gate entry item | XXX050456xxx | | 14 | Return Gate Entry Item Status | Status of the Return Gate Entry Item
3. RECEIVED
4. REJECTED
5. PROCESSING
6. PROCESSED | When no item is received against the return gate entry item | PROCESSED | | 15 | Return Gate Entry Time | Time when the Return Gate Entry got created | When the Return order is not scanned against a gate entry | 21/10/2019 12:07:08 | | 16 | Tracking ID | Returns tracking ID | 1.When Marketplace is not passing it 2.When data is not uploaded | abc1234 | | 17 | Transporter | Name of the Transporter | NA | REDFINE | | 18 | Return Order Created Time | Time when the Return Order got created | 1.When no expectation present 2.When it is an excess return | 21/10/2019 12:07:08 | | 19 | Return Order Expected Date | Expected date of return order | Yes if return order is not expected | | | 20 | Inward Time | Time when the Return Item is received and GRNed in the system | When no item is received and GRNed | 21/10/2019 18:01:59 | | 21 | Return Order Updated Time | Time when the Return Order Line Item got updated | When Return not processed | 21/10/2019 18:02:04 | | 22 | Return Order Processed Time | Time when the return order line item got processed. | when return not processed | | | 23 | QC Reason | Reason for QC rejection | 1.When Return not processed 2.When Return Order QC is Pass | USED_PRODUCT | | 24 | Reason for Return | Customer Reason for Return | 1.When no expectation present 2.When it is an excess return | RETURN_REASON | | 25 | Return Order Item QC Status | QC status of the return:
7. PASS
8. FAIL | When Return not processed | FAIL | | 26 | Return Order Status | Status of the return order:
9. CANCELLED
10. COMPLETED
11. CREATED
12. PROCESSING | 1.When no expectation present 2.When it is an excess return | COMPLETE | | 27 | Channel Return Order Status | Channel Return Order Status | Return Order Status from Channel | 1. CANCELLED
13. COMPLETED | | 28 | Final Resolution | Final Resolution of the Return Order | 1.When no expectation present 2.When it is an excess return | LOST_IN_TRANSIT | | 29 | Return Order Item Status | Line Item status of the return:
14. MISSING
15. RECEIVED
16. PROCESSING
17. PARTIAL_MISSING_COMBO | When Return not processed | RECEIVED | | 30 | Putaway Status | Wheather the Item is Putawayed or not (Yes/No) | When Item is not Putawayed | NO | | 31 | Uploaded Channel Order ID | Forward Channel Order ID as per the expectation | When no expectation present | GPML103529 | | 32 | Channel sub order ID | Return Sub order ID from the channel | 1.When no expectation present 2.When it is an excess return 3.When the marketplace is not sending it | GPML103529 | | 33 | Channel Return Item ID | Channel Return Item ID from the channel | 1.When no expectation present 2.When it is an excess return 3.When the marketplace is not sending it | 1236711367000_1 | | 34 | Client SKU ID / EAN | Client SKU ID | NA | MENS-SS18-12345 | | 35 | Global SKU ID | System SKU ID | NA | 1100426655 | | 36 | Internal Batch ID | System Batch of the Received Return Item | 1.When Return not Processed 2.When the Processed Return Item is not part of any batch | 1234 | | 37 | External Batch ID | External Batch of the Received Return Item | 1.When Return not Processed 2.When the Processed Return Item is not part of any batch | 1256gx | | 38 | SKU Description | Standard attribute - SKU Name/Description from the Article Master | When not present in the SKU Master | | | 39 | Style | Standard attribute - Style from the Article Master | When not present in the SKU Maste | | | 40 | Brand | Standard attribute - Brand from the Article Master | When not present in the SKU Master | XYZ | | 41 | Category | Standard attribute - Category from the Article Master | When not present in the SKU Master | | | 42 | Size | Standard attribute - Size from the Article Master | When not present in the SKU Master | 1000 | | 43 | MRP | Standard attribute - MRP from the Article Master | When not present in the SKU Master | | | 44 | Manifacturing Date | Date of manufacturing of item | NA | | | 45 | Expiry Date | Expiry date of item | Yes if item is not expirable | | | 46 | Price | Price of item | | | | 47 | Forward Order Value | Selling price of the Forward Order | NA | 800 | | 48 | Item ID | System Item ID | 1.When Return not Processed 2.When Return Item is Missing | 1117594927 | | 49 | External Item Code | External Item ID - will be same as System Item ID, if the client has not provided any. | 1.When Return not Processed 2.When Return Item is Missing | 1117594927 | | 50 | Sales Channel | Sales Channel | NA | Amazon | | 51 | Return Order Item Remark | Remarks entered by the operator | When no remarks has been entered | | | 52 | Is Uploaded | When the Return Order is uploaded(true/false) | When no expectation is present | false | | 53 | Excess Returns | When the Received Item is an excess return(true/false) | When Return not Processed | false | | 54 | Return Processed without Expectation | Identifier for orders processed with or without expectation YES: • If the expectation is not present at the moment of return processing (Always populates YES even if the expectation is pushed later) NO: • If expectation is present while processing return Null: • If expectation is present and return is NOT YET received or processed at the warehouse | When the EXPECTED return is NOT YET processed | 1. YES
18. NO
19. null | | 55 | External Serial Code | external_serial_code | When not uploaded by client | asd123 | | 56 | Putaway Time | When the Item is made LIVE after return processing | If not yet made LIVE after the return received/processed | 2023-01-01 12:34:56 |

Filters

FAQs