SUBMIT_TIMESTAMP

timestamp

Yes

The date and time a return was submitted.

SUBMIT_DAY_ID

varchar

40

No

Identifier of the day on which the return was submitted. Foreign key to ARF_TIME_DAY.ID column.

SUBMIT_TIME_ID

int

No

Identifier of the time at which the return was submitted. Foreign key to the ARF_TIME_TOD.ID column.

SKU_ID

int

No

SKU of the item being returned. Foreign key to the ARF_SKU.ID column.

PRODUCT_ID

int

No

Product being returned. Foreign key to the ARF_PRODUCT.ID column.

CUSTOMER_ID

int

No

Customer returning the product. Foreign key to the ARF_USER.ID column.

LOCAL_CURRENCY_ID

smallint

No

Currency in which the return was made. Foreign key to the ARF_CURRENCY.ID column.

NRETURN_ID

varchar

40

No

Natural key of the return.

NORIGINAL_ORDER_ID

varchar

40

No

Natural key of the order in which the returned item was purchased.

NEXCHANGE_ORDER_ID

varchar

40

Yes

When a user returns an item and exchanges it for another item, the exchange is considered a new order, which is referenced by this column.

RETURN_ITEM_ID

bigint

No

Identifier. Primary key for this table.

NRETURN_ITEM_ID

varchar

40

No

Natural key for the return.

QUANTITY

numeric

No

Quantity of the item returned.

EXCHANGE

one-digit

No

Indicates that the return was made as part of an exchange.

1 = Yes

0 = No

Defaults to 0.

RETURN_SALES_CHANNEL

numeric or tinyint

1

No

Channel through which the return was performed. Foreign key to ARF_SALES_CHANNEL.ID column.

AGENT_ID

varchar

40

No

Agent involved in the return, if any. Foreign key to ARF_IU_USER.ID column.

RETURN_REASON_ID

int

No

Reason for which the item was returned. Foreign key to the ARF_RET_REASON_DISPOSITION.ID column.

ITEM_SITE_ID

smallint

No

The site on which the returned item was added to the order. Foreign key to ARF_SITE.ID.

SUBMITTED_SITE_ID

smallint

No

The site on which the order for the returned item was submitted. Foreign key to ARF_SITE.ID.

LOCAL_ITEM_REFUND

double

No

Refund amount for the item in the local currency.

LOCAL_TOTAL_REFUND

double

No

Total refund for this line item including all adjustments, in the local currency.

LOCAL_TOTAL_ADJ_ALLOC

double

No

Total adjustments allocated for this return, including shipping, fees, taxes, etc., in the local currency.

LOCAL_SHIPPING_REFUND_ALLOC

double

No

Amount of shipping on the return that is allocated to this line item, in the local currency. The allocation is determined by the processing pipeline

LOCAL_TAX_REFUND_ALLOC

double

No

Amount of tax on the return that is allocated to this line item, in the local currency. The allocation is determined by the processing pipeline

LOCAL_OTHER_REFUND_ALLOC

double

No

Amount of any additional refund not accounted for elsewhere that is allocated to this line item, in the local currency.

LOCAL_RETURN_FEE_ALLOC

double

No

Amount of any return fee applied to this line item, in the local currency. The allocation is determined by the processing pipeline

STD_ITEM_REFUND

double

No

Refund amount for the item in the reporting currency.

STD_TOTAL_REFUND

double

No

Total refund for this line item, including all adjustments, in the standard currency.

STD_TOTAL_ADJ_ALLOC

double

No

Total adjustments allocated for this return, including shipping, fees, taxes, etc., in the standard currency.

STD_SHIPPING_REFUND_ALLOC

double

No

Amount of shipping on the return that is allocated to this line item, in the standard currency. The allocation is determined by the processing pipeline

STD_TAX_REFUND_ALLOC

double

No

Amount of tax on the return that is allocated to this line item, in the standard currency. The allocation is determined by the processing pipeline

STD_OTHER_REFUND_ALLOC

double

No

Amount of any additional refund not accounted for elsewhere that is allocated to this line item, in the reporting currency.

STD_RETURN_FEE_ALLOC

double

No

Amount of any return fee applied to this line item, in the standard currency. The allocation is determined by the processing pipeline