Table Schema: mf_return_order_items

This topic describes the columns in the mf_return_order_items table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
return_order_item_guid uniqueidentifier 1 0 1   4  
return_order_guid uniqueidentifier 0 0 2   0 mf_return_orders.return_order_guid
order_item_guid uniqueidentifier 0 0 3   0 mf_order_items.order_item_guid
invoice_item_guid uniqueidentifier 0 1 4   0 mf_invoice_items.invoice_item_guid
return_item_guid uniqueidentifier 0 1 5   0  
return_order_item_line_id smallint 0 1 6   0  
return_order_item_quantity int 0 0 7   0  
return_order_item_quantity_replaced int 0 0 8   0  
return_order_item_quantity_received int 0 0 9   0  
return_order_item_quantity_credited int 0 0 10   0  
return_order_item_unit_price decimal (16,6) 0 0 11   0  
return_order_item_unit_price_ref decimal (16,6) 0 1 12   0  
return_order_item_tax money 0 0 13   0  
return_order_item_tax_replaced money 0 1 14   0  
return_order_item_product_tax money 0 0 15   0  
return_order_item_shipping money 0 0 16   0  
return_order_item_shipping_tax money 0 0 17   0  
return_order_item_shipping_replaced money 0 1 18   0  
return_order_item_handling money 0 0 19   0  
return_order_item_handling_tax money 0 0 20   0  
return_order_item_handling_replaced money 0 1 21   0  
return_order_item_insurance money 0 0 22   0  
return_order_item_insurance_replaced money 0 1 23   0  
return_order_item_discount_rate decimal (7,6) 0 1 24   0  
return_order_item_discount money 0 0 25   0  
return_order_item_discount_replaced money 0 1 26   0  
return_order_item_discount2 money 0 0 27   0  
return_order_item_discount2_replaced money 0 1 28   0  
return_order_item_price_adjustment money 0 0 29   0  
return_order_item_price_adjustment_replaced money 0 0 30   0  
return_order_item_price_adjustment_tax money 0 0 31   0  
return_order_item_price_adjustment_tax_replaced money 0 0 32   0  
return_order_item_return_order_price_adjustment money 0 0 33   0  
return_order_item_return_order_price_adjustment_replaced money 0 0 34   0  
return_order_item_return_order_price_adjustment_tax money 0 0 35   0  
return_order_item_return_order_price_adjustment_tax_replaced money 0 0 36   0  
return_order_item_extended_price money 0 1 37   0  
return_order_item_closed tinyint 0 0 38   0  
lu_dt datetime 0 1 39   0  
cr_dt datetime 0 1 40   0  
lu_guid uniqueidentifier 0 1 41   0  
cr_guid uniqueidentifier 0 1 42   0  

Return to index of tables

X Privacy Update: We use cookies to make interactions with our websites and services easy and meaningful, to better understand how they are used. By continuing to use this site you are giving us your consent to do this. Privacy Policy.