Table Schema: mf_batch_items

This topic describes the columns in the mf_batch_items table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
batch_item_guid uniqueidentifier 1 0 1   0  
batch_guid uniqueidentifier 0 0 2   0 mf_batches.batch_guid
object_guid uniqueidentifier 0 0 3   0  
object_type_id int 0 0 4   0  
batch_item_quantity int 0 1 5   0  
batch_item_label varchar (50) 0 1 6   0  
batch_item_label_short varchar (50) 0 1 7   0  
batch_item_description varchar (255) 0 1 8   0  
batch_item_tag varchar (1000) 0 1 9   0  
batch_item_order smallint 0 0 10   0  
batch_item_provider_state varchar (50) 0 1 11   0  
batch_item_provider_status varchar (255) 0 1 12   0  
batch_item_posted tinyint 0 0 13   0  
batch_item_closed tinyint 0 0 14   0  
lu_dt datetime 0 0 15   0  
cr_dt datetime 0 0 16   0  
lu_guid uniqueidentifier 0 1 17   0  
cr_guid uniqueidentifier 0 1 18   0  

Return to index of tables