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)

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 - 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).


How did we do?


Powered by HelpDocs (opens in a new tab)