| ccma_id | int(11) | NO | | PRI | auto_increment | Primary key |
| ccma_cus_id | int(11) | NO | | MUL | | Customer ID |
| ccma_cli_id | int(11) | NO | | MUL | | Client ID |
| ccma_merchant_id | varchar(20) | NO | | | | |
| ccma_loc_id | int(11) | YES | | | | LOCATION ID# |
| ccma_hsn_number | varchar(30) | YES | | | | If available, unique identifier for card reader |
| ccma_log_transactions | tinyint(1) | NO | 0 | | | Indicates if card connect merchant transactions should be logged |
| ccma_disabled | tinyint(1) | NO | 0 | | | 1 indicates disabled merchant |
| ccma_modified | timestamp | YES | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| ccma_created | timestamp | YES | CURRENT_TIMESTAMP | | | |