SAP Business One SDK 10.0 - Database Tables Reference
-
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 |