|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Employee Transfer Details
Table Name: HET1
Table Description: Employee Transfer Details
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| TransferID | Foreign Key to OHET | Int | 11 | OHET | Â | Â | Â |
| empID | Foreign Key to OHEM | Int | 11 | OHEM | Â | Â | Â |
| Transfered | Timestamp: Status "Sent" | Date | 8 | - | Â | Â | Â |
| Status | Processing Status | VarChar | 1 | - | N | N | New |
| Â | Â | Â | Â | Â | Â | S | Sent |
| Â | Â | Â | Â | Â | Â | A | Accepted |
| Â | Â | Â | Â | Â | Â | E | Error |
| Comment | Any comments | Text | 16 | - | Â | Â | Â |
| TransTime | Time When Status Is "Sent" | Int | 6 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | TransferID |
| Â | Â | empID |