|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Activity CheckIns
Table Name: CLG1
Table Description: Activity CheckIns
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| ClgCode | Activity Number | Int | 11 | OCLG | Â | Â | Â |
| LineNum | Line Number | Int | 11 | - | Â | Â | Â |
| Date | Date | Date | 8 | - | Â | Â | Â |
| Location | Location | nVarChar | 254 | - | Â | Â | Â |
| Latitude | Latitude | nVarChar | 13 | - | Â | Â | Â |
| Longitude | Longitude | nVarChar | 14 | - | Â | Â | Â |
| Time | Time | Int | 11 | - | Â | Â | Â |
| OwnerUser | Owner User | Int | 6 | OUSR | Â | Â | Â |
| OwnerEmp | Owner Employee | Int | 11 | OHEM | Â | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| RecpntType | Recipient Type | VarChar | 1 | - | 0 | 0 | User |
| Â | Â | Â | Â | Â | Â | 1 | Employee |
| Â | Â | Â | Â | Â | Â | 2 | Contact Person |
| Â | Â | Â | Â | Â | Â | 3 | Distribution List |
| Â | Â | Â | Â | Â | Â | 4 | Other |
| RecpntName | Recipient Name | nVarChar | 50 | OUSR | Â | Â | Â |
| EmailAddr | Email Address | nVarChar | 50 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | ClgCode |
| Â | Â | LineNum |