Entity Company

Description of Entity Company

This is the starting point for describing the company's structure to Sage EasyPay. This entity stores all information about the company. It includes the address, branches, retirement age, the company's probation period and many more.


List of all Dependencies of the Entity Company

Name

Code

Class Name

Have Many2

Have_Many2

Reference

Relation_4355

Relation_4355

Reference

Relation_4362

Relation_4362

Reference

Relation_1683319

Relation_1683319

Reference

Relation_11077

Relation_11077

Reference


List of Attributes of the Entity Company

Name

Code

Company ID

CompanyId

Registration Number

CompanyReg

Name

CompanyName

Probation Period

CompanyProbationPeriod

Address

CompanyAddress

Country

CompanyCountry

City

CompanyCity

Postal Code

CompanyPCode

State

CompanyState

Retirement Age

CompanyRetireAge

Fax Number

CompanyFax

Phone Number

CompanyContact

Remarks 1

Remarks1

Remarks 2

Remarks2

Date Format

DateFormat

Probation Period Unit

CompanyProbationUnit

Company Letterhead

CompanyLogo

CompanyAddress2

CompanyAddress2

CompanyAddress3

CompanyAddress3

Thousand Separator

ThousandSeparator

Company Currency

CompanyCurrency

CompanyStatutoryContri

CompanyStatutoryContri

CompanyForeignName

CompanyForeignName

EMail Address

CompanyEMailAddress


Entity Attribute Company ID of the Entity Company

Card of Attribute Company ID of the Entity Company

Name

Company ID

Code

CompanyId

Data Type

char(20)

Mandatory

Yes


Description of Attribute Company ID of the Entity Company

Holds the identification number for a company. In Singapore, when a company is set up, they are given a business registration number. This is also the primary key for the Company table.


Entity Attribute Registration Number of the Entity Company

Card of Attribute Registration Number of the Entity Company

Name

Registration Number

Code

CompanyReg

Data Type

char(35)

Mandatory

No


Description of Attribute Registration Number of the Entity Company

Holds the company's business registration number. It is usually obtained from the government.


Entity Attribute Name of the Entity Company

Card of Attribute Name of the Entity Company

Name

Name

Code

CompanyName

Data Type

char(100)

Mandatory

No


Description of Attribute Name of the Entity Company

Stores the name of the company.
Example: Sage Software Asia Pte. Ltd.


Entity Attribute Probation Period of the Entity Company

Card of Attribute Probation Period of the Entity Company

Name

Probation Period

Code

CompanyProbationPeriod

Data Type

integer

Mandatory

No


Description of Attribute Probation Period of the Entity Company

Stores the company’s probation period. It can last anywhere from 30 days to an entire year.


Entity Attribute Address of the Entity Company

Card of Attribute Address of the Entity Company

Name

Address

Code

CompanyAddress

Data Type

char(150)

Mandatory

No


Description of Attribute Address of the Entity Company

Holds the first line for the company’s address. This entry excludes the postal code, city and country of the company.


Entity Attribute Country of the Entity Company

Card of Attribute Country of the Entity Company

Name

Country

Code

CompanyCountry

Data Type

char(60)

Mandatory

No


Description of Attribute Country of the Entity Company

Records the particular country that the company is located in.


Entity Attribute City of the Entity Company

Card of Attribute City of the Entity Company

Name

City

Code

CompanyCity

Data Type

char(60)

Mandatory

No


Description of Attribute City of the Entity Company

Stores the particular city that the company is located in.


Entity Attribute Postal Code of the Entity Company

Card of Attribute Postal Code of the Entity Company

Name

Postal Code

Code

CompanyPCode

Data Type

char(20)

Mandatory

No


Description of Attribute Postal Code of the Entity Company

Records the postal code of the company. It is also known as postcode or ZIP code.


Entity Attribute State of the Entity Company

Card of Attribute State of the Entity Company

Name

State

Code

CompanyState

Data Type

char(60)

Mandatory

No


Description of Attribute State of the Entity Company

Holds records of the particular state the company is located at.


Entity Attribute Retirement Age of the Entity Company

Card of Attribute Retirement Age of the Entity Company

Name

Retirement Age

Code

CompanyRetireAge

Data Type

integer

Mandatory

No


Description of Attribute Retirement Age of the Entity Company

Stores the retirement age for all employees. In Singapore, the retirement age is usually 62. Depending on their work performance and their medical fitness, employees can work up till the age of 65.


Entity Attribute Fax Number of the Entity Company

Card of Attribute Fax Number of the Entity Company

Name

Fax Number

Code

CompanyFax

Data Type

char(30)

Mandatory

No


Description of Attribute Fax Number of the Entity Company

Stores the fax number of the company. It is normally a telephone number connected to a printer or an output device.


Entity Attribute Phone Number of the Entity Company

Card of Attribute Phone Number of the Entity Company

Name

Phone Number

Code

CompanyContact

Data Type

char(30)

Mandatory

No


Description of Attribute Phone Number of the Entity Company

Stores the company’s main contact number.


Entity Attribute Remarks 1 of the Entity Company

Card of Attribute Remarks 1 of the Entity Company

Name

Remarks 1

Code

Remarks1

Data Type

char(100)

Mandatory

No


Description of Attribute Remarks 1 of the Entity Company

Holds the remarks about the company. These remarks can either be about the company web page or the software the clients are using.


Entity Attribute Remarks 2 of the Entity Company

Card of Attribute Remarks 2 of the Entity Company

Name

Remarks 2

Code

Remarks2

Data Type

char(100)

Mandatory

No


Description of Attribute Remarks 2 of the Entity Company

Second line for the remarks.


Entity Attribute Date Format of the Entity Company

Card of Attribute Date Format of the Entity Company

Name

Date Format

Code

DateFormat

Data Type

char(10)

Mandatory

No


Description of Attribute Date Format of the Entity Company

Records the date format for the system.
It is usually in the form DD-MM-YYYY.


Entity Attribute Probation Period Unit of the Entity Company

Card of Attribute Probation Period Unit of the Entity Company

Name

Probation Period Unit

Code

CompanyProbationUnit

Data Type

char(10)

Mandatory

No


Description of Attribute Probation Period Unit of the Entity Company

Records the unit of probation for the company. It is a fixed setting for the rest of the employees.
Example: “Mth” for months


Entity Attribute Company Letterhead of the Entity Company

Card of Attribute Company Letterhead of the Entity Company

Name

Company Letterhead

Code

CompanyLogo

Data Type

long binary

Mandatory

No


Description of Attribute Company Letterhead of the Entity Company

Stores the company logo. It means the user has to scan it into the database or create it on the computer. It allows up to a maximum size of 80x640 pixels (64KB) in the format of .jpg and .bmp


Entity Attribute CompanyAddress2 of the Entity Company

Card of Attribute CompanyAddress2 of the Entity Company

Name

CompanyAddress2

Code

CompanyAddress2

Data Type

char(150)

Mandatory

No


Description of Attribute CompanyAddress2 of the Entity Company

Second line for the company’s address.


Entity Attribute CompanyAddress3 of the Entity Company

Card of Attribute CompanyAddress3 of the Entity Company

Name

CompanyAddress3

Code

CompanyAddress3

Data Type

char(150)

Mandatory

No


Description of Attribute CompanyAddress3 of the Entity Company

Third line for the company’s address.


Entity Attribute Thousand Separator of the Entity Company

Card of Attribute Thousand Separator of the Entity Company

Name

Thousand Separator

Code

ThousandSeparator

Data Type

char(1)

Mandatory

No


Description of Attribute Thousand Separator of the Entity Company

Separates the digits in groups of three, i.e. thousands, with a comma.
Example: 10,000


Entity Attribute Company Currency of the Entity Company

Card of Attribute Company Currency of the Entity Company

Name

Company Currency

Code

CompanyCurrency

Data Type

char(20)

Mandatory

No


Description of Attribute Company Currency of the Entity Company

Used as a medium of exchange. They are usually defined by the government. They come in a form of banknotes and coins.
Example: Singapore currency (SGD)


Entity Attribute CompanyStatutoryContri of the Entity Company

Card of Attribute CompanyStatutoryContri of the Entity Company

Name

CompanyStatutoryContri

Code

CompanyStatutoryContri

Data Type

char(20)

Mandatory

No


Description of Attribute CompanyStatutoryContri of the Entity Company

Shows the statutory contributions a company makes. In Singapore, there are Central Provident Fund (CPF), Foreign Worker’s Levy and Skill Development Fund, just to name a few. These funds are either deducted from the employer or the employee.


Entity Attribute CompanyForeignName of the Entity Company

Card of Attribute CompanyForeignName of the Entity Company

Name

CompanyForeignName

Code

CompanyForeignName

Data Type

char(100)

Mandatory

No


Description of Attribute CompanyForeignName of the Entity Company

Shows the company’s name in other languages.
Example: If a user’s first language is not English, he might want to view the company’s name in his first language (Mandarin).


Entity Attribute EMail Address of the Entity Company

Card of Attribute EMail Address of the Entity Company

Name

EMail Address

Code

CompanyEMailAddress

Data Type

char(100)

Mandatory

No


Description of Attribute EMail Address of the Entity Company

Stores the Electronic Mail of a company. It is used to exchange messages from a sender to one or more recipients.