Table Schema: mf_listings

This topic describes the columns in the mf_listings table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
listing_guid uniqueidentifier 1 0 1   0  
company_guid uniqueidentifier 0 1 2   0  
catalog_guid uniqueidentifier 0 1 3   0  
site_guid uniqueidentifier 0 1 4   0  
item_guid uniqueidentifier 0 0 5   0 mf_items.item_guid
item_hold_guid uniqueidentifier 0 1 6   0  
provider_guid uniqueidentifier 0 1 7   0  
listing_code_guid uniqueidentifier 0 1 8   0  
listing_type_id smallint 0 0 9   0 mf_listing_types.listing_type_id
listing_cd varchar (50) 0 1 10   0  
listing_description varchar (255) 0 1 11   0  
listing_quantity smallint 0 0 12   0  
listing_quantity_value decimal (16,6) 0 0 13   0  
listing_quantity_calc_method_id smallint 0 0 14   0  
listing_quantity_sold smallint 0 1 15   0  
listing_time_span smallint 0 1 16   0  
listing_launch_date datetime 0 1 17   0  
listing_start_date datetime 0 1 18   0  
listing_end_date datetime 0 1 19   0  
listing_cost money 0 1 20   0  
listing_scan_dt datetime 0 1 21   0  
listing_provider_data text 0 1 22   0  
listing_provider_state varchar (50) 0 1 23   0  
listing_error tinyint 0 0 24   0  
listing_prepared tinyint 0 0 25   0  
listing_exported tinyint 0 0 26   0  
listing_imported tinyint 0 0 27   0  
listing_revise tinyint 0 0 28   0  
listing_relisted tinyint 0 0 29   0  
listing_alert tinyint 0 0 30   0  
listing_visible tinyint 0 0 31   0  
listing_new tinyint 0 0 32   0  
listing_approved tinyint 0 0 33   0  
listing_suspended tinyint 0 0 34   0  
listing_locked tinyint 0 0 35   0  
listing_closed tinyint 0 0 36   0  
listing_filed tinyint 0 0 37   0  
listing_flag tinyint 0 0 38   0  
lu_dt datetime 0 0 39   0  
cr_dt datetime 0 0 40   0  
lu_guid uniqueidentifier 0 1 41   0  
cr_guid uniqueidentifier 0 1 42   0  

Return to index of tables