Table Schema: mf_auto_payments

This topic describes the columns in the mf_auto_payments table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
auto_payment_guid uniqueidentifier 1 0 1   1  
company_guid uniqueidentifier 0 1 2   0  
customer_guid uniqueidentifier 0 0 3   0  
customer_payment_method_guid uniqueidentifier 0 0 4   0  
object_guid uniqueidentifier 0 1 5   0  
object_type_id smallint 0 1 6   0  
term_guid uniqueidentifier 0 1 7   0  
auto_payment_code_guid uniqueidentifier 0 1 8   0 mf_object_codes.code_guid
iso_currency_cd char (3) 0 1 9   0 mf_iso_currencies.iso_currency_cd
auto_payment_id varchar (50) 0 1 10   0  
auto_payment_label varchar (50) 0 1 11   0  
auto_payment_label_short varchar (50) 0 1 12   0  
auto_payment_description varchar (255) 0 1 13   0  
auto_payment_locked tinyint 0 0 14   0  
auto_payment_visible tinyint 0 0 15   0  
auto_payment_approved tinyint 0 0 16   0  
auto_payment_flag tinyint 0 0 17   0  
auto_payment_alert tinyint 0 0 18   0  
auto_payment_suspended tinyint 0 0 19   0  
auto_payment_closed tinyint 0 0 20   0  
auto_payment_filed tinyint 0 0 21   0  
auto_payment_void tinyint 0 0 22   0  
cr_dt datetime 0 1 23   0  
lu_dt datetime 0 1 24   0  
cr_guid uniqueidentifier 0 1 25   0  
lu_guid uniqueidentifier 0 1 26   0  

Return to index of tables