Sage EasyPay Data Model

Entity Branch

Description of Entity Branch

This entity stores the different types of branches of the company. It records the information about the branch of the company.

List of all Dependencies of the Entity Branch

Reference

Reference

Reference

List of Attributes of the Entity Branch

Entity Attribute Branch ID of the Entity Branch

Card of Attribute Branch ID of the Entity Branch

Name	Branch ID
Code	BranchId
Data Type	char(20)
Mandatory	Yes

Description of Attribute Branch ID of the Entity Branch

Shows the identity of the branch. This is also the primary key for the Branch table.

Entity Attribute Name of the Entity Branch

Card of Attribute Name of the Entity Branch

Name	Name
Code	BranchName
Data Type	char(80)
Mandatory	No

Description of Attribute Name of the Entity Branch

Shows the branch name of the company.

Entity Attribute Address of the Entity Branch

Card of Attribute Address of the Entity Branch

Name	Address
Code	BranchAddress
Data Type	char(150)
Mandatory	No

Description of Attribute Address of the Entity Branch

Shows the branch address. This address excludes the postal code, city and the country of the branch.

Entity Attribute Country of the Entity Branch

Card of Attribute Country of the Entity Branch

Name	Country
Code	BranchCountry
Data Type	char(60)
Mandatory	No

Description of Attribute Country of the Entity Branch

Shows the country of the branch.
Example: Singapore / Malaysia etc

Entity Attribute City of the Entity Branch

Card of Attribute City of the Entity Branch

Name	City
Code	BranchCity
Data Type	char(60)
Mandatory	No

Description of Attribute City of the Entity Branch

Shows the city of the branch.
Example: Singapore / Kuala Lumpur etc

Entity Attribute Postal Code of the Entity Branch

Card of Attribute Postal Code of the Entity Branch

Name	Postal Code
Code	BranchPCode
Data Type	char(20)
Mandatory	No

Description of Attribute Postal Code of the Entity Branch

Shows the postal code of the branch.

Entity Attribute State of the Entity Branch

Card of Attribute State of the Entity Branch

Name	State
Code	BranchState
Data Type	char(60)
Mandatory	No

Description of Attribute State of the Entity Branch

Shows the state of the branch.
Example: Singapore / Kuala Lumpur etc

Entity Attribute BranchAddress2 of the Entity Branch

Card of Attribute BranchAddress2 of the Entity Branch

Name	BranchAddress2
Code	BranchAddress2
Data Type	char(150)
Mandatory	No

Description of Attribute BranchAddress2 of the Entity Branch

Second line for the branch address.

Entity Attribute BranchAddress3 of the Entity Branch

Card of Attribute BranchAddress3 of the Entity Branch

Name	BranchAddress3
Code	BranchAddress3
Data Type	char(150)
Mandatory	No

Description of Attribute BranchAddress3 of the Entity Branch

Third line for the branch address.

Entity Attribute Branch Foreign Name of the Entity Branch

Card of Attribute Branch Foreign Name of the Entity Branch

Name	Branch Foreign Name
Code	BranchForeignName
Data Type	char(80)
Mandatory	No

Description of Attribute Branch Foreign Name of the Entity Branch

Stores the foreign name of the branch.

Home