Overview

The Pick Decline Feed is a pipe-delimited text file that contains information on orders that have at least one declined item.

Notes:

Exchange Frequency: Daily

File Naming Convention: <Client_ID>_DeclineDtls_<YYYYMMDDHH24MISS>.txt

File Type: Text file

File Header: First row should be header

File Delimiter: Pipe (|)

Schema

This feed is a pipe-delimited text file that contains the following columns.

Column
CHANNEL_ID
STATUS_DATE
FULFILLMENT_LOCATION
FULFILLMENT_LOCATION_TYPE
MIA_FLAG
FULFILLMENT_TYPE
FULFILLMENT_ORDER_ID
ORDER_DATE
WEB_ORDER_NO
RADIAL_ORDER_NO
RELEASE_NUM
SHIPMENT_NO
LINE_NUM
SUBLINE_NUM
SKU_NAME
SHIPMENT_CREATED_DATE
SHIPPED_QTY
PICK_DECLINE_DATE
PICK_DECLINE_QTY
PICK_DECLINE_CODE
PICK_DECLINE_DESCRIPTION
PACK_DECLINE_DATE
PACK_DECLINE_QTY
PACK_DECLINE_CODE
PACK_DECLINE_DESCRIPTION
CUSTOMER_PICK_DECLINE_DATE
CUSTOMER_PICK_DECLINE_QTY
CUSTOMER_PICK_DECLINE_CODE
CUSTOMER_PICK_DECLINE_DESCRIPTION
CHECK_IN_DECLINE_DATE
CHECK_IN_DECLINE_QTY
CHECK_IN_DECLINE_CODE
CHECK_IN_DECLINE_DESCRIPTION