Database – Source Company Physical Check Account (source_company_physical_check_account_entity)

Description

This table holds information on a source company's physical checking account.

Table Values

Column

Data Type

Column Info

Value Notes

Other

id

int(11)

The ID of the entity, which must be a positive integer. This is the primary key for the table, and is automatically assigned by the system.

UN AI PK

source_company_id

int(11)

The ID for the source company, which must be a positive integer

UN

account_number

varchar(100)

The bank account number for the checking account

routing_number

varchar(100)

The routing number for the bank where the account is held

next_check_number

varchar(100)

The number on the next check

print_check_format

char(64)

The format for the printed check

deleted

tinyint(1)

Whether the account has been deleted

0 - Not deleted

1 - Deleted

created

timestamp

When the checking account was created in LMS

lastUpdated

timestamp

When the table was last updated

bank_name

varchar(255)

The name of the bank where the account is held

storenumber

varchar(25)

The store or branch number where the account is held


How did we do?


Powered by HelpDocs (opens in a new tab)