|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Time Sheet - Rows - History
Table Name: ASH1
Table Description: Time Sheet - Rows - History
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Key | Int | 11 | - | Â | Â | Â |
| LineID | Row No. | Int | 11 | - | Â | Â | Â |
| Date | Date | Date | 8 | - | Â | Â | Â |
| ActType | Activity Type | Int | 11 | PMC5 | Â | Â | Â |
| LaborItem | Labor Item No. | nVarChar | 50 | - | Â | Â | Â |
| StartTime | Start Time | Int | 11 | - | Â | Â | Â |
| EndTime | End Time | Int | 11 | - | Â | Â | Â |
| Workorder | Workorder Doc. Entry | Int | 11 | OWOR | Â | Â | Â |
| WorAbs | Workorder Abs. Entry | Int | 11 | - | Â | Â | Â |
| ServCall | Service Call ID | Int | 11 | OSCL | Â | Â | Â |
| CostCenter | Cost Center | nVarChar | 8 | - | Â | Â | Â |
| FiProject | Financial Project | nVarChar | 20 | - | Â | Â | Â |
| Location | Location | Int | 11 | - | Â | Â | Â |
| GPSData | GPS Data | nVarChar | 50 | - | Â | Â | Â |
| Branch | Branch ID | Int | 11 | OBPL | Â | Â | Â |
| Break | Break | Int | 11 | - | Â | Â | Â |
| NonBillTm | Nonbillable Time | Int | 11 | - | Â | Â | Â |
| EffectTm | Effective Time | Int | 11 | - | Â | Â | Â |
| BillableTm | Billable Time | Int | 11 | - | Â | Â | Â |
| FullDay | Full Day | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| ProjectID | Project or Subproject ID | Int | 11 | - | Â | Â | Â |
| Subproject | Subproject ID | Int | 11 | - | Â | Â | Â |
| StageID | Stage ID | Int | 11 | - | Â | Â | Â |
| Charged | Charged | Num | 19.6 | - | Â | Â | Â |
| Chargeable | Chargeable [Yes/No] | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EncryptIV | Encrypt IV | nVarChar | 100 | - | Â | Â | Â |
| BreakHr | Break Hours | Num | 19.6 | - | Â | Â | Â |
| NonBillHr | Non-Billable Hours | Num | 19.6 | - | Â | Â | Â |
| EffectHr | Effective Hours | Num | 19.6 | - | Â | Â | Â |
| BillableHr | Billable Hours | Num | 19.6 | - | Â | Â | Â |
| EnActType | Encrypt Activity Type | Text | 16 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| Â | Â | LineID |
| Â | Â | LogInstanc |