|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Absence Information
Table Name: HEM1
Table Description: Absence Information
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| empID | Employee ID | Int | 11 | OHEM | Â | Â | Â |
| line | Absence Information Row | Int | 6 | - | Â | Â | Â |
| fromDate | Absence from | Date | 8 | - | Â | Â | Â |
| toDate | Absence to | Date | 8 | - | Â | Â | Â |
| reason | Reason | nVarChar | 20 | - | Â | Â | Â |
| approvedBy | Approved By | nVarChar | 20 | - | Â | Â | Â |
| cnfrmrNum | Confirmer Number | Int | 11 | OHEM | Â | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| type | Absence Type | Int | 11 | PMC5 | Â | Â | Â |
| EncryptIV | Encrypt IV | nVarChar | 100 | - | Â | Â | Â |
| EnType | Encrypt Absence Type | Text | 16 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | empID |
| Â | Â | line |