Table Schema: mf_terms

This topic describes the columns in the mf_terms table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
term_guid uniqueidentifier 1 0 1   5  
company_guid uniqueidentifier 0 0 2   0  
term_cd varchar (50) 0 1 3   0  
term_label varchar (50) 0 1 4   0  
term_label_short varchar (50) 0 1 5   0  
term_description varchar (255) 0 1 6   0  
term_due_days smallint 0 0 7   0  
term_due_percent money 0 0 8   0  
term_payment_shipping_as_additional tinyint 0 0 9   0  
term_payment_handling_as_additional tinyint 0 0 10   0  
term_visible tinyint 0 0 11   0  
lu_dt datetime 0 1 12   0  
cr_dt datetime 0 1 13   0  
lu_guid uniqueidentifier 0 1 14   0  
cr_guid uniqueidentifier 0 1 15   0  

Return to index of tables