Table Schema: mf_customer_items

This topic describes the columns in the mf_customer_items table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
customer_guid uniqueidentifier 1 0 1   0 mf_customers.customer_guid
item_guid uniqueidentifier 1 0 2   0  
customer_item_price money 0 1 3   0  
customer_item_expiration_date datetime 0 1 4   0  
customer_item_cd varchar (25) 0 1 5   0  
customer_item_cost money 0 1 6   0  
customer_item_srp money 0 1 7   0  
customer_item_price_adjustment_value decimal (16,6) 0 1 8   0  
customer_item_price_adjustment_calc_method_id smallint 0 1 9   0  
customer_item_price_adjustment_description varchar (50) 0 1 10   0  
lu_dt datetime 0 0 11   0  
cr_dt datetime 0 0 12   0  
lu_guid uniqueidentifier 0 1 13   0  
cr_guid uniqueidentifier 0 1 14   0  

Return to index of tables