|
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. |
|
Name |
Code |
Class Name |
|
Reference |
||
|
Reference |
||
|
Reference |
||
|
Reference |
||
|
Reference |
|
Name |
Code |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
Yes |
|
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. |
|
Name |
|
|
Code |
|
|
Data Type |
char(35) |
|
Mandatory |
No |
|
Holds the company's business registration number. It is usually obtained from the government. |
|
Name |
|
|
Code |
|
|
Data Type |
char(100) |
|
Mandatory |
No |
|
Stores the name of the company. |
|
Name |
|
|
Code |
|
|
Data Type |
integer |
|
Mandatory |
No |
|
Stores the company’s probation period. It can last anywhere from 30 days to an entire year. |
|
Name |
|
|
Code |
|
|
Data Type |
char(150) |
|
Mandatory |
No |
|
Holds the first line for the company’s address. This entry excludes the postal code, city and country of the company. |
|
Name |
|
|
Code |
|
|
Data Type |
char(60) |
|
Mandatory |
No |
|
Records the particular country that the company is located in. |
|
Name |
|
|
Code |
|
|
Data Type |
char(60) |
|
Mandatory |
No |
|
Stores the particular city that the company is located in. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Records the postal code of the company. It is also known as postcode or ZIP code. |
|
Name |
|
|
Code |
|
|
Data Type |
char(60) |
|
Mandatory |
No |
|
Holds records of the particular state the company is located at. |
|
Name |
|
|
Code |
|
|
Data Type |
integer |
|
Mandatory |
No |
|
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. |
|
Name |
|
|
Code |
|
|
Data Type |
char(30) |
|
Mandatory |
No |
|
Stores the fax number of the company. It is normally a telephone number connected to a printer or an output device. |
|
Name |
|
|
Code |
|
|
Data Type |
char(30) |
|
Mandatory |
No |
|
Stores the company’s main contact number. |
|
Name |
|
|
Code |
|
|
Data Type |
char(100) |
|
Mandatory |
No |
|
Holds the remarks about the company. These remarks can either be about the company web page or the software the clients are using. |
|
Name |
|
|
Code |
|
|
Data Type |
char(100) |
|
Mandatory |
No |
|
Second line for the remarks. |
|
Name |
|
|
Code |
|
|
Data Type |
char(10) |
|
Mandatory |
No |
|
Records the date format for the system. |
|
Name |
|
|
Code |
|
|
Data Type |
char(10) |
|
Mandatory |
No |
|
Records the unit of probation for the company. It is a fixed setting for the rest of the employees. |
|
Name |
|
|
Code |
|
|
Data Type |
long binary |
|
Mandatory |
No |
|
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 |
|
Name |
|
|
Code |
|
|
Data Type |
char(150) |
|
Mandatory |
No |
|
Second line for the company’s address. |
|
Name |
|
|
Code |
|
|
Data Type |
char(150) |
|
Mandatory |
No |
|
Third line for the company’s address. |
|
Name |
|
|
Code |
|
|
Data Type |
char(1) |
|
Mandatory |
No |
|
Separates the digits in groups of three, i.e. thousands, with a comma. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
Used as a medium of exchange. They are usually defined by the government. They come in a form of banknotes and coins. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
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. |
|
Name |
|
|
Code |
|
|
Data Type |
char(100) |
|
Mandatory |
No |
|
Shows the company’s name in other languages. |
|
Name |
|
|
Code |
|
|
Data Type |
char(100) |
|
Mandatory |
No |
|
Stores the Electronic Mail of a company. It is used to exchange messages from a sender to one or more recipients. |
|
|
|