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

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