This article outlines the database structure for the MMv4 aff_payment database table.

• id
  Primary Key of aff_payments table.
  int(10) | unsigned | auto increment | primary key | indexed
  
• aff_id
  The system ID number of the affiliate associated with the specific payment.
  int(10) | unsigned | indexed
  
• date
  The date of the payment
  int(10) | 0/timestamp | indexed
  
• payment_id
  The user defined Payment ID number
  varchar(255) |indexed
  
• type
  The type of payment, such as Credit Card, PayPal, etc.
  varchar(255)| indexed
  
• value
  The value of the payment.
  double(16,2) | indexed
  
• memo
  Payment memo.
  text