Table Schema: mf_invoice_transactions

This topic describes the columns in the mf_invoice_transactions table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
invoice_transaction_guid uniqueidentifier 1 0 1   0  
invoice_guid uniqueidentifier 0 1 2   0 mf_invoices.invoice_guid
invoice_transaction_reference_guid uniqueidentifier 0 1 3   0  
invoice_transaction_type_id smallint 0 1 4   0 mf_invoice_transaction_types.invoice_transaction_type_id
invoice_transaction_date datetime 0 1 5   0  
invoice_transaction_reference_id varchar (50) 0 1 6   0  
invoice_transaction_description varchar (100) 0 1 7   0  
invoice_transaction_amount money 0 1 8   0  
invoice_transaction_commission_amount money 0 1 9   0  
invoice_transaction_commission_rate decimal (4,4) 0 1 10   0  
lu_dt datetime 0 1 11   0  
cr_dt datetime 0 1 12   0  
lu_guid uniqueidentifier 0 1 13   0  
cr_guid uniqueidentifier 0 1 14   0  

Return to index of tables