| Field Name | Field Description | Data Type | FK Join |
|---|---|---|---|
| Active | Indicates if the Record is Active or Not | bit | |
| ChangeOrderId | Change Order Id | int | vr_ChangeOrder |
| ChangeOrderNumber | Change Order Number | nvarchar | |
| CJProjectId | Capital Project Id | int | |
| CreatedDate | Record Creation Date | datetime | |
| CreatorId | User Id (Record Creator) | int | vr_users |
| DeactivatedById | Deactivated By Id | int | vr_users |
| DeactivatedByName | Deactivated By Name | nvarchar | |
| DeactivatedDate | Deactivated Date | datetime | |
| EstimateId | Estimate Id | int | vr_estimate |
| EstimateNumber | Estimate Number | nvarchar | |
| Id | Estimate Tier Id | int | |
| Level | Level | int | |
| ModifiedDate | Last Modified Date | datetime | |
| ModifierId | User Id (Record Modifier) | int | vr_users |
| ReferenceNumber | Reference Number | nvarchar | |
| TransactionNumber | Transaction Number | int | |
| WorkOrderId | Work Order Id | int | vr_WorkOrder |
| WorkOrderNumber | Work Order Number | nvarchar |