AuditMilestone
Name Data Type Size Comments
Record of a key date/phase reached within the Audit
ActualDate date (8) Date when actually complete
Comments richtext Unlimited rich text comments
Comments_Plain string Plain text equivilent of the corresponding rich text field
HasTargetVariance boolean Indicates if the Target Variance is set
HasVariance boolean Indicates if the Variance is set
PlannedDate date (8) Date when planned to be complete
TargetVariance int32 Difference (in days) between the Actual Date and expected Actual Date (based on offsets)
Variance int32 Difference (in days) between the Planned Date and Actual Date (or today if not yet complete)
Audit Audit M:1 Link to parent Audit
AuditEnd Audit 1:1 Link to parent Audit
AuditReport Audit 1:1 Link to parent Audit
AuditStart Audit 1:1 Link to parent Audit
Milestone Milestone M:1 Link to parent Milestone
OfflineCheckOut OfflineCheckOut 1:1 Link to child check out which contains who/when item was checked out