TimeSheetLine
Name Data Type Size Comments
The set of recorded time for particular Audit/Task on a Time Sheet
Comments richtext Unlimited rich text comments
Comments_Plain string Plain text equivilent of the corresponding rich text field
Total decimal (18,2) The sum of all the Time Sheet Values for the Time Sheet Line
Audit Audit M:1 Link to parent Audit
AuditAssignment AuditAssignment M:1 Link to parent Audit Assignment
Component TimeSheetComponent M:1 Basic segmentation
Task TimeSheetTask M:1 Basic segmentation
TimeSheet TimeSheet M:1 Link to the parent time sheet
Type TimeSheetLineType M:1 Whether the item is "Audit" or "Task"
Values TimeSheetValue 1:M Link to child Time Sheet Values