Limitación de responsabilidad por el uso del Traductor Google. Haga clic aquí .
-- Reference --
EM Database (Employee)
Field | Contents | Description |
---|---|---|
EMP_NUM | 20 characters right aligned | User ID entered in the User dialog |
PRE_NAME | 4 characters left aligned | Title such as Mr., Ms., or Mrs. |
FRST_NAME | 10 characters left aligned | First name |
MID_NAME | 10 characters left aligned | Middle name |
LAST_NAME | 20 characters left aligned | Surname |
POST_NAME | 10 characters left aligned | Designation |
BIRTH_DATE | 8 character date | Birth date |
S_DATE | 8 character date | Start date |
SIN | 11 characters | Social insurance number |
ADDR1 | 40 characters | Address line 1 |
ADDR2 | 40 characters | Address line 2 |
CITY | 25 characters | City |
PROV | 20 characters | Province |
COUNTRY | 3 characters | Country |
PT_CODE | 10 characters | Postal or zip code |
PHONE1 | 17 characters | Phone number 1 |
PHONE2 | 17 characters | Phone number 2 |
COST_RATE | 7 digits and 2 decimal places | Plan rate entered in the Users dialog |
STD_RATE | 7 digits and 2 decimal places | Standard rate entered in the Users dialog |
100 | Email address | |
UNUSED | Unused | |
IDATE | 8 | Date employee made inactive |
EXINFO | 10 | Memo used for reports |
TGUID | ||
CWGUID | 22 characters | For internal purposes only. Unique identifier, created when the record is appended. |
CWDATE | 14 | Marks date and time of database changes. |
CREATED ON | 14 | Marks date the record was created. |