Table Schema: mf_item_holds

This topic describes the columns in the mf_item_holds table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
item_hold_guid uniqueidentifier 1 0 1   2  
parent_guid uniqueidentifier 0 1 2   0  
item_guid uniqueidentifier 0 0 3   0 mf_items.item_guid
site_guid uniqueidentifier 0 1 4   0 mf_sites.site_guid
hold_type_id smallint 0 0 5   0 mf_hold_types.hold_type_id
item_hold_quantity int 0 0 6   0  
item_hold_tag varchar (50) 0 1 7   0  
item_hold_description varchar (100) 0 1 8   0  
item_hold_expiration datetime 0 1 9   0  
item_hold_backorder_authorization tinyint 0 0 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