Database – Source Company Entity (source_company_entity)
Holds information for source companies
Column | Data Type | Column Info | Value Notes | Other |
id | int(11) | The id of the entity | ||
company_name | varchar(255) | company name | ||
contact_name | varchar(255) | contact name | ||
contact_phone | char(20) | contact phone | ||
contact_email | varchar(255) | contact email | ||
address_id | int(11) | ID of associated address | ||
checking_account_id | int(11) | checking account id | ||
mc_id | int(11) | PCI Wallet ID | ||
num_prefix | varchar(20) | number prefix | ||
num_suffix | varchar(20) | number suffix | ||
created | timestamp | Timestamp of when the entity was created | ||
lastUpdated | timestamp | Timestamp of when the entity was last updated | ||
active | tinyint(1) | Whether or not the entity is active | 1 - yes, 0 - no | |
deleted | tinyint(1) | Whether or not the entity was deleted | 1 - yes, 0 - no |