Table Schema: mf_batches

This topic describes the columns in the mf_batches table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
batch_guid uniqueidentifier 1 0 1   2  
company_guid uniqueidentifier 0 0 2   0  
catalog_guid uniqueidentifier 0 1 3 Catalog-F-mf_catalogs 0  
site_guid uniqueidentifier 0 1 4 Catalog-F-mf_sites 0  
provider_instance_guid uniqueidentifier 0 1 5   0  
batch_code_guid uniqueidentifier 0 1 6   0  
batch_id varchar (50) 0 1 7   0  
batch_date datetime 0 0 8 Order date 0  
batch_label varchar (50) 0 0 9   0  
batch_label_short varchar (50) 0 1 10   0  
batch_description varchar (255) 0 1 11   0  
batch_provider_state varchar (50) 0 1 12   0  
batch_provider_status varchar (255) 0 1 13   0  
batch_tag varchar (1000) 0 1 14   0  
batch_progress_percent_complete smallint 0 1 15   0  
batch_progress_description varchar (255) 0 1 16   0  
batch_order smallint 0 0 17   0  
batch_posted tinyint 0 0 18   0  
batch_flag tinyint 0 0 19 Used by UI as a way to assign records to different colored flags.-F-mf_flags 0  
batch_alert tinyint 0 0 20 Status flag- Indicates whether the order is alerted 0  
batch_visible tinyint 0 0 21 Status flag- Indicates whether the order is visible 0  
batch_new tinyint 0 0 22 Status flag- Indicates whether the order is new 0  
batch_approved tinyint 0 0 23 Work Flow flag- Indicates whether the order is approved 0  
batch_suspended tinyint 0 0 24 Status flag- Indicates whether the order is suspended 0  
batch_locked tinyint 0 0 25 Status flag- Indicates whether the order is locked 0  
batch_closed tinyint 0 0 26 Work Flow flag- Indicates whether the order is closed 0  
batch_filed tinyint 0 0 27 Work Flow flag- Indicates whether the order is filed 0  
lu_dt datetime 0 0 28   0  
cr_dt datetime 0 0 29   0  
lu_guid uniqueidentifier 0 1 30   0  
cr_guid uniqueidentifier 0 1 31   0  

Return to index of tables