Database – Source Company Physical Check Account (source_company_physical_check_account_entity)
Updated 2 weeks ago
This table holds information on a source company's physical checking account.
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 |