Entity CompanyBank

Description of Entity CompanyBank

This entity would record all the banks that the company have an account with. This entity would also record the account number and the types of account of the bank account. These account numbers are used in the Bank Disk submission. In the payroll module, payment instructions can be generated in electronic form. This is usually known as bank diskette and one of the basic information required is the company's bank account number, which is stored here.


List of all Dependencies of the Entity CompanyBank

Name

Code

Class Name

Relation_4355

Relation_4355

Reference


List of Attributes of the Entity CompanyBank

Name

Code

Bank ID

ComBankCode

Branch Code

ComBankBranchCode

Account No

ComAccountNo

Bank Name

ComBankName

Account Type

ComAccType


Entity Attribute Bank ID of the Entity CompanyBank

Card of Attribute Bank ID of the Entity CompanyBank

Name

Bank ID

Code

ComBankCode

Data Type

char(20)

Mandatory

Yes


Description of Attribute Bank ID of the Entity CompanyBank

This attribute would record the bank code obtained from a bank list that is already set in the system by the user. It also acts as a primary code for the CompanyBank table.


Entity Attribute Branch Code of the Entity CompanyBank

Card of Attribute Branch Code of the Entity CompanyBank

Name

Branch Code

Code

ComBankBranchCode

Data Type

char(20)

Mandatory

Yes


Description of Attribute Branch Code of the Entity CompanyBank

This attribute would record the company's bank branch number. This holds the primary key for the CompanyBank table.


Entity Attribute Account No of the Entity CompanyBank

Card of Attribute Account No of the Entity CompanyBank

Name

Account No

Code

ComAccountNo

Data Type

char(20)

Mandatory

Yes


Description of Attribute Account No of the Entity CompanyBank

This attribute would record the company's bank account number. This holds the primary key for the CompanyBank table.


Entity Attribute Bank Name of the Entity CompanyBank

Card of Attribute Bank Name of the Entity CompanyBank

Name

Bank Name

Code

ComBankName

Data Type

char(60)

Mandatory

No


Description of Attribute Bank Name of the Entity CompanyBank

This attribute would record the name of the company's bank.


Entity Attribute Account Type of the Entity CompanyBank

Card of Attribute Account Type of the Entity CompanyBank

Name

Account Type

Code

ComAccType

Data Type

char(50)

Mandatory

No


Description of Attribute Account Type of the Entity CompanyBank

This attribute would record the type of bank account for the record. It can be either fix deposit, savings account etc .