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