Navigate To

Description

Provides Return gate entry details and AWBs received against it.

Fields

Fields Description This column can be null Sample Data
1 Client Name Name of the Client NA Increff
2 Client ID Increff ID of the Client NA 11000000123
3 Fulfillment Location Name Name of the Fulfilment Location NA wms_hsr
4 Return Gate Entry ID Increff Gate entry ID of returns NA 1234
5 Consignment Number Consignment number of the returns NA 12abc
6 Consignment Document ID Consignment Document ID of the returns NA abc.pdf
7 Document Date Consignment Document Date of the returns NA 01-07-2020 12:49
8 Gate Entry Created Time Gate entry creation time of returns NA 13-07-2020 12:49
9 Last updated Time Last updated time of the Return Gate Entry NA 13-07-2020 13:07
10 AWB Scan Time Time when the return packet is received and AWB scanned against the
Return Gate Entry When no AWB is received and scanned against the Return
Gate Entry 13-07-2020 13:07
11 Box Count No of boxes present in the Return Gate Entry NA 20
12 Sales Channel Sales Channel NA Amazon
13 Gate Entry Status Status of the Return Gate Entry:
  1. CREATED
  2. CLOSED | NA | CLOSED | | 14 | Gate Entry Item Status | Status of the Return Gate Entry Item
  3. RECEIVED
  4. REJECTED
  5. PROCESSING
  6. PROCESSED | When no return packet is received against the return gate entry | RECEIVED | | 15 | Return Order Tracking ID | Returns tracking ID | 1.When Marketplace is not passing it 2.When data is not uploaded | 1234567 | | 16 | Transporter | Name of the Transporter | NA | XKART | | 17 | Gate Entry Processed AWB Number | AWB No of the Return Item scanned against the Return Gate Entry | When no AWB is received and scanned against the Return Gate Entry | fmpc0770647135 | | 18 | Return Data present with Gate Entry AWB | If Return Expectaion present with the same AWB as the Return Gate Entry (Yes/No) | NA | No | | 19 | Received Return Order Item ID | Line Item ID of the received_return_order_items table | When no return packet is received against the return gate entry | 7521 | | 20 | Expected Return Order Item ID | Line Item ID of the expected_return_order_items table | 1.When no return packet is received against the return gate entry 2.When the received return packet has no expectation | 7540 | | 21 | Return Order Item Status | Line Item Status of the Return:
  7. MISSING
  8. RECEIVED
  9. PROCESSING
  10. PARTIAL_MISSING_COMBO | When no return packet is received against the return gate entry | RECEIVED | | 22 | System Order ID | Forward Order ID of the Received Return | When no return packet is received against the return gate entry | 12345 | | 23 | Return Order ID | System Return Order ID of the expected return order | 1.When no return packet is received against the return gate entry 2.When the received return packet has no expectation | 11356 | | 24 | Return Order Status | Order Status of the Return
  11. CANCELLED
  12. COMPLETED
  13. CREATED
  14. PROCESSING | 1.When no return packet is received against the return gate entry 2.When the received return packet has no expectation | COMPLETED | | 25 | AWB present for another channel’s return | IF Return Expectation present for a different channel with the same Return Gate Entry AWB (Yes/No) | NA | No | | 26 | Expected Return Mapped | If the Return Gate Entry is Mapped to a Return Expectation (Yes/No) | NA | Yes | | 27 | ret | Expected Returns or not | | Yes / NO | | 28 | Global SKU ID | Global SKU ID | NA | 123456789 | | 29 | Client SKU ID | Client SKU ID | NA | 123456678 |

Filters

Filters Description Limitation
1 Client Name of the client Mandatory
2 Fulfilment Location Name of the Fulfilment Location Mandatory
3 Gate Entry Date From - Gate Entry Date To To filter the report based on Return Gate Entry Creation Time NA
4 Gate Entry ID To filter the report based on Return Gate Entry ID NA
5 Sales Channel To filter the report based on Sales Channel NA
6 Return Order Status To filter the report based on the status of return orders NA
7 Return Gate Entry Status To filter the report based on the return gate entry status NA
8 Return Gate Entry Item Status To filter the report based on the return gate entry item status NA

FAQs