TimeReport:
| RecordType;DBId;EmployeeName;JobNumber;Date;TimeReportTypeName;FromTime;ToTime;Hours;ArticleNumber; DescHours;Expenses;ACExpenses;DescExpenses;BillingRate;ACBillingRate;HourlyCost;ACHourlyCost;InvoiceTNumber; InvoiceTDetailNumber;InvoicedType |
| Nr | Name | Type | Description |
|---|---|---|---|
| 1 | RecordType | Long | Type of object to import. 69 is for timereport |
| 2 | DBId | Long | Database Id in DeMaSy. It is displayed in Utilities |
| 3 | EmployeeName | Char(75) | Employee name |
| 4 | JobNumber | Char(75) | Job number |
| 5 | Date | Date/Time | Timereport date |
| 6 | TimeReportTypeName | Char(50) | Timereport type name |
| 7 | FromTime | Char(8) | Timereport start time |
| 8 | ToTime | Char(8) | Timereport end time |
| 9 | Hours | Double | Hours |
| 10 | ArticleNumber | Double | Article number |
| 11 | DescHours | Char(255) | Description for hours |
| 12 | Expenses | Double | Expenses in capital currency |
| 13 | ACExpenses | Double | Expenses in second capital currency |
| 14 | DescExpenses | Char(255) | Description for expenses |
| 15 | BillingRate | Double | Hourly rate in the first capital currency |
| 16 | ACBillingRate | Double | Hourly rate in the second capital currency |
| 17 | HourlyCost | Double | Hourly cost in the first capital currency |
| 18 | ACHourlyCost | Double | Hourly cost in the second capital currency |
| 19 | InvoiceTNumber | Char(50) | Client invoice number |
| 20 | InvoiceTDetailNumber | Char(50) | Client invoice number (detail) |
| 21 | InvoicedType | Integer | Report status: 0 = Not billed 1 = Billed 2 = Waiting |