Database – Source Company Entity (source_company_entity)
Description
Holds information for Source Companies.
Table Values
Column | Data Type | Column Info | Value Notes |
id | int(11) | The ID of the Source Company | |
company_name | varchar(255) | The name of the Source Company | |
contact_name | varchar(255) | The name of the primary contact | |
contact_phone | char(20) | The phone for the primary contact | |
contact_email | varchar(255) | The email address for the primary contact | |
primary_contact_id | itn(11) | The ID for the agent user assigned as the primary contact | |
address_id | int(11) | ID of associated address | |
checking_account_id | int(11) | checking account id | |
mc_id | int(11) | Secure Payments 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 - active, 0 - not active |
deleted | tinyint(1) | Whether or not the entity was deleted | 1 - deleted, 0 - not deleted |
cash_drawer_default_settings_id | int(11) | An ID for the default cash drawer settings (such as transaction limits or balance notifications). |