Table Schema: mf_order_price_adjustments

This topic describes the columns in the mf_order_price_adjustments table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
order_price_adjustment_guid uniqueidentifier 1 0 1 PrimaryKey 3  
order_guid uniqueidentifier 0 0 2   0 mf_orders.order_guid
order_item_guid uniqueidentifier 0 1 3   0 mf_order_items.order_item_guid
order_ship_group_guid uniqueidentifier 0 1 4   0  
order_service_item_guid uniqueidentifier 0 1 5   0  
order_item_option_guid uniqueidentifier 0 1 6   0 mf_order_item_options.order_item_option_guid
campaign_guid uniqueidentifier 0 1 7   0  
promotion_guid uniqueidentifier 0 1 8   0  
coupon_code_guid uniqueidentifier 0 1 9   0  
price_adjustment_reason_guid uniqueidentifier 0 1 10   0 mf_price_adjustment_reasons.price_adjustment_reason_guid
price_adjustment_type_id smallint 0 0 11   0 mf_price_adjustment_types.price_adjustment_type_id
order_price_adjustment_id varchar (100) 0 1 12   0  
order_price_adjustment_label varchar (100) 0 1 13   0  
order_price_adjustment_description varchar (255) 0 1 14   0  
order_price_adjustment_campaign_id varchar (100) 0 1 15   0  
order_price_adjustment_campaign_label varchar (100) 0 1 16   0  
order_price_adjustment_promotion_id varchar (100) 0 1 17   0  
order_price_adjustment_promotion_label varchar (100) 0 1 18   0  
order_price_adjustment_coupon_code_id varchar (100) 0 1 19   0  
order_price_adjustment_value money 0 0 20   0  
order_price_adjustment_value_ref money 0 0 21   0  
order_price_adjustment_tax money 0 0 22   0  
order_price_adjustment_position smallint 0 1 23   0  
order_price_adjustment_posted_after_sale bit 0 0 24   0  
order_price_adjustment_void bit 0 0 25   0  
lu_dt datetime 0 0 26   0  
cr_dt datetime 0 0 27   0  

Return to index of tables