Refund_Line_Items
The table below describes the Refund_Line_Items table.
This is a virtual table, and is linked to the Refunds table (see Refunds).
This table contains the following virtual tables:
None of the columns in this table are nullable.
This table contains the following foldable column:
- Refund_Id
This table does not contain Return Primary Key columns.
| Column Name | SQL Type | Updatable |
|---|---|---|
|
Refund_Id Primary Key Foreign Key linked to column Refund_Id in Refunds table |
SQL_BIGINT(unsigned) | True |
|
Refund_Line_Items_Index Primary Key |
SQL_INTEGER(unsigned) | False |
|
Refund_Line_Items_Line_Item_Id Foreign Key linked to column Order_Line_Items_Id in Order_Line_Items table |
SQL_BIGINT(unsigned) | False |
|
Refund_Line_Items_Line_Item_Product_Id Foreign Key linked to column Product_Id in Products table |
SQL_BIGINT(unsigned) | False |
|
Refund_Line_Items_Line_Item_Variant_Id Foreign Key linked to column Product_Variant_Id in Product_Variants table |
SQL_BIGINT(unsigned) | False |
|
Refund_Line_Items_Id |
SQL_BIGINT(unsigned) | False |
|
Refund_Line_Items_Line_Item_Fulfillable_Quantity |
SQL_INTEGER(signed) | False |
|
Refund_Line_Items_Line_Item_Fulfillment_Service |
SQL_VARCHAR(1024) | False |
|
Refund_Line_Items_Line_Item_Fulfillment_Status |
SQL_VARCHAR(1024) | False |
|
Refund_Line_Items_Line_Item_Gift_Card |
SQL_BIT | False |
|
Refund_Line_Items_Line_Item_Grams |
SQL_INTEGER(unsigned) | False |
|
Refund_Line_Items_Line_Item_Name |
SQL_VARCHAR(1024) | False |
|
Refund_Line_Items_Line_Item_Price |
SQL_NUMERIC(38,2) | False |
|
Refund_Line_Items_Line_Item_Product_Exists |
SQL_BIT | False |
|
Refund_Line_Items_Line_Item_Quantity |
SQL_INTEGER(signed) | False |
|
Refund_Line_Items_Line_Item_Requires_Shipping |
SQL_BIT | False |
|
Refund_Line_Items_Line_Item_Sku |
SQL_VARCHAR(1024) | False |
|
Refund_Line_Items_Line_Item_Taxable |
SQL_BIT | False |
|
Refund_Line_Items_Line_Item_Title |
SQL_VARCHAR(1024) | False |
|
Refund_Line_Items_Line_Item_Total_Discount |
SQL_NUMERIC(38,2) | False |
|
Refund_Line_Items_Line_Item_Variant_Inventory_Management |
SQL_VARCHAR(1024) | False |
|
Refund_Line_Items_Line_Item_Variant_Title |
SQL_VARCHAR(1024) | False |
|
Refund_Line_Items_Line_Item_Vendor |
SQL_VARCHAR(1024) | False |
|
Refund_Line_Items_Quantity |
SQL_INTEGER(signed) | False |