This table contains data about returned items.
Column Name | Type | Length | Null Allowed | Description |
---|---|---|---|---|
| timestamp | Yes | The date and time a return was submitted. | |
| varchar | 40 | No | Identifier of the day on which the return was submitted. Foreign key to |
| int | No | Identifier of the time at which the return was submitted. Foreign key to the | |
| int | No | SKU of the item being returned. Foreign key to the | |
| int | No | Product being returned. Foreign key to the | |
| int | No | Customer returning the product. Foreign key to the | |
| smallint | No | Currency in which the return was made. Foreign key to the | |
| varchar | 40 | No | Natural key of the return. |
| varchar | 40 | No | Natural key of the order in which the returned item was purchased. |
| 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. |
| bigint | No | Identifier. Primary key for this table. | |
| varchar | 40 | No | Natural key for the return. |
| numeric | No | Quantity of the item returned. | |
| one-digit | No | Indicates that the return was made as part of an exchange. 1 = Yes 0 = No Defaults to 0. | |
| numeric or tinyint | 1 | No | Channel through which the return was performed. Foreign key to |
| varchar | 40 | No | Agent involved in the return, if any. Foreign key to |
| int | No | Reason for which the item was returned. Foreign key to the | |
| smallint | No | The site on which the returned item was added to the order. Foreign key to | |
| smallint | No | The site on which the order for the returned item was submitted. Foreign key to | |
| double | No | Refund amount for the item in the local currency. | |
| double | No | Total refund for this line item including all adjustments, in the local currency. | |
| double | No | Total adjustments allocated for this return, including shipping, fees, taxes, etc., in the local currency. | |
| 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 | |
| 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 | |
| double | No | Amount of any additional refund not accounted for elsewhere that is allocated to this line item, in the local currency. | |
| double | No | Amount of any return fee applied to this line item, in the local currency. The allocation is determined by the processing pipeline | |
| double | No | Refund amount for the item in the reporting currency. | |
| double | No | Total refund for this line item, including all adjustments, in the standard currency. | |
| double | No | Total adjustments allocated for this return, including shipping, fees, taxes, etc., in the standard currency. | |
| 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 | |
| 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 | |
| double | No | Amount of any additional refund not accounted for elsewhere that is allocated to this line item, in the reporting currency. | |
| double | No | Amount of any return fee applied to this line item, in the standard currency. The allocation is determined by the processing pipeline |