|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Time Sheet - Header - History
Table Name: ATSH
Table Description: Time Sheet - Header - History
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Key | Int | 11 | - | Â | Â | Â |
| ProjectID | Project No. | Int | 11 | OPMG | Â | Â | Â |
| DocNum | Document Number | Int | 11 | - | Â | Â | Â |
| Type | Type | VarChar | 1 | - | E | E | Employee |
| Â | Â | Â | Â | Â | Â | U | User |
| Â | Â | Â | Â | Â | Â | O | External |
| UserID | Employee/User ID | Int | 11 | OHEM | Â | Â | Â |
| LastName | Last Name | nVarChar | 50 | - | Â | Â | Â |
| FirstName | First Name | nVarChar | 50 | - | Â | Â | Â |
| Department | Department | Int | 6 | - | Â | Â | Â |
| DateFrom | Date From | Date | 8 | - | Â | Â | Â |
| DateTo | Date To | Date | 8 | - | Â | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| UpdateDate | Date of Update | Date | 8 | - | Â | Â | Â |
| UserSign | User Signature | Int | 6 | - | Â | Â | Â |
| UserSign2 | Updating User | Int | 6 | - | Â | Â | Â |
| CreateDate | Production Date | Date | 8 | - | Â | Â | Â |
| UpdateTS | Update Full Time | Int | 11 | - | Â | Â | Â |
| DPPStatus | Data Protection Status | VarChar | 1 | - | N | N | None |
| Â | Â | Â | Â | Â | Â | D | Erased |
| SAPPassprt | Extended SAP Passport | Text | 16 | - | Â | Â | Â |
| EncryptIV | Encrypt IV | nVarChar | 100 | - | Â | Â | Â |
| AtcEntry | Attachment Entry | Int | 11 | OATC | Â | Â | Â |
| Attachment | Attachment | Text | 16 | - | Â | Â | Â |
| UserCode | Employee/User Code | nVarChar | 50 | - | Â | Â | Â |
| DataVers | Data Version | Int | 11 | - | 1 | Â | Â |
| OwnerCode | Owner | Int | 11 | OHEM | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| Â | Â | LogInstanc |