| Field Name | Field Description | Data Type | FK Join |
|---|---|---|---|
| Active | Indicates if the Record is Active or Not | bit | |
| AdjustedCost | Adjusted Cost | decimal | |
| Budget | Budget | decimal | |
| ChangeOrderId | Change Order Id | int | vr_ChangeOrder |
| ChargeTypeCode | Charge Type Code | nvarchar | |
| ChargeTypeDefaultRate | Charge Type Default Rate | decimal | |
| ChargeTypeDescription | Charge Type Description | nvarchar | |
| ChargeTypeId | Charge Type Id | int | vr_chargeType |
| Comment | Comments | nvarchar | |
| CPRenewalItemId | Capital Planning Renewal Item Id | int | |
| CPWorkElementId | Work Element Id | int | vr_cpWorkElement |
| CreatedDate | Record Creation Date | datetime | |
| CreatorId | User Id (Record Creator) | int | vr_users |
| CurrencyExchangeDate | Currency Exchange Date | datetime | |
| CurrencyExchangeId | Currency Exchange Id | int | |
| CurrencyId | Currency Id | int | vrpt_Currency |
| Description | Description | nvarchar | |
| EstimateId | Estimate Id | int | vr_Estimate |
| EstimateTypeCode | Estimate Type Code | nvarchar | |
| EstimateTypeDescription | Estimate Type Description | nvarchar | |
| EstimateTypeId | Estimate Type Id | int | vr_estimateType |
| EstimateTypeTimeTypeId | Estimate Type Time Type Id | int | vr_TimeType |
| ExtendedCost | Extended Cost | decimal | |
| ExtendedCosts | Extended Costs | decimal | |
| Id | Estimate Item Id | int | |
| InAction | Indicates if the record is in action | bit | |
| InflatedCost | Inflated Cost | decimal | |
| ItemCode | Item Code | nvarchar | |
| ItemDescription | Item Description | nvarchar | |
| ItemId | Item Id | int | |
| ItemTypeId | Item Type Id | int | |
| MarkupCost | Markup Cost | decimal | |
| ModifiedDate | Last Modified Date | datetime | |
| ModifierId | User Id (Record Modifier) | int | vr_users |
| PartAverageCost | Part Average Cost | decimal | |
| PartCode | Part Code | nvarchar | |
| PartDescription | Part Description | nvarchar | |
| PartId | Part Id | int | vr_Part |
| PartTypeId | Part Type Id | int | vr_PartType |
| ProjectTaskDescription | Project Task Description | nvarchar | |
| ProjectTaskId | Project Task Id | int | vrpt_ProjectTask |
| ProjectTaskName | Project Task Name | nvarchar | |
| Quantity | Quantity | decimal | |
| RSMCatalogDescription | RSMeans Catalog Description (RSMeans is a database of current construction cost estimates) | nvarchar | |
| RSMCatalogId | RSMeans Catalog Id (RSMeans is a database of current construction cost estimates) | nvarchar | |
| RSMCatalogTypeDescription | RSMeans Catalog Type Description (RSMeans is a database of current construction cost estimates) | nvarchar | |
| RSMCatalogTypeId | RSMeans Catalog Type Id (RSMeans is a database of current construction cost estimates) | nvarchar | |
| RSMCostDataFormat | RSMeans Cost Data Format (RSMeans is a database of current construction cost estimates) | nvarchar | |
| RSMCostLineDescription | RSMeans Cost Line Description (RSMeans is a database of current construction cost estimates) | nvarchar | |
| RSMCostLineId | RSMeans Cost Line Id (RSMeans is a database of current construction cost estimates) | nvarchar | |
| RSMCostTypeDescription | RSMeans Cost Type Description (RSMeans is a database of current construction cost estimates) | nvarchar | |
| RSMCostTypeId | RSMeans Cost Type Id (RSMeans is a database of current construction cost estimates) | int | |
| RSMCountryId | RSMeans Country Id (RSMeans is a database of current construction cost estimates) | nvarchar | |
| RSMDivision1Description | RSMeans Division 1 Description (RSMeans is a database of current construction cost estimates) | nvarchar | |
| RSMDivision1Id | RSMeans Division 1 Id (RSMeans is a database of current construction cost estimates) | nvarchar | |
| RSMDivision2Description | RSMeans Divisison 2 Description (RSMeans is a database of current construction cost estimates) | nvarchar | |
| RSMDivision2Id | RSMeans Division 2 Id (RSMeans is a database of current construction cost estimates) | nvarchar | |
| RSMDivision3Description | RSMeans Division 3 Description (RSMeans is a database of current construction cost estimates) | nvarchar | |
| RSMDivision3Id | RSMeans Division 3 Id (RSMeans is a database of current construction cost estimates) | nvarchar | |
| RSMDivision4Description | RSMeans Division 4 Description (RSMeans is a database of current construction cost estimates) | nvarchar | |
| RSMDivision4Id | RSMeans Division 4 Id (RSMeans is a database of current construction cost estimates) | nvarchar | |
| RSMEquipmentCost | RSMeans Equipment Cost (RSMeans is a database of current construction cost estimates) | decimal | |
| RSMEquipmentCost0 | RSMeans Equipment Cost 0 (RSMeans is a database of current construction cost estimates) | decimal | |
| RSMEquipmentCost1 | RSMeans Equipment Cost 1 (RSMeans is a database of current construction cost estimates) | decimal | |
| RSMInstallationCost | RSMeans Installation Cost (RSMeans is a database of current construction cost estimates) | decimal | |
| RSMInstallationCost0 | RSMeans Installation Cost 0 (RSMeans is a database of current construction cost estimates) | decimal | |
| RSMInstallationCost1 | RSMeans Installation Cost 1 (RSMeans is a database of current construction cost estimates) | decimal | |
| RSMLaborCost | RSMeans Labor Cost (RSMeans is a database of current construction cost estimates) | decimal | |
| RSMLaborCost0 | RSMeans Labor Cost 0 (RSMeans is a database of current construction cost estimates) | decimal | |
| RSMLaborCost1 | RSMeans Labor Cost 1 (RSMeans is a database of current construction cost estimates) | decimal | |
| RSMLaborHours | RSMeans Labor Hours (RSMeans is a database of current construction cost estimates) | decimal | |
| RSMLaborTypeDescription | RSMeans Labor Type Description (RSMeans is a database of current construction cost estimates) | nvarchar | |
| RSMLaborTypeId | RSMeans Labor Type Id (RSMeans is a database of current construction cost estimates) | nvarchar | |
| RSMLineDescription | RSMeans Line Description (RSMeans is a database of current construction cost estimates) | nvarchar | |
| RSMLineNumber | RSMeans Line Number (RSMeans is a database of current construction cost estimates) | nvarchar | |
| RSMLocationDescription | RSMeans Location Description (RSMeans is a database of current construction cost estimates) | nvarchar | |
| RSMLocationId | RSMeans Location Id (RSMeans is a database of current construction cost estimates) | nvarchar | |
| RSMMaterialCost | RSMeans Material Cost (RSMeans is a database of current construction cost estimates) | decimal | |
| RSMMaterialCost0 | RSMeans Material Cost 0 (RSMeans is a database of current construction cost estimates) | decimal | |
| RSMMaterialCost1 | RSMeans Material Cost 1 (RSMeans is a database of current construction cost estimates) | decimal | |
| RSMMeasurementSystemDescription | RSMeans Measurement System Description (RSMeans is a database of current construction cost estimates) | nvarchar | |
| RSMMeasurementSystemId | RSMeans Measurement System Id (RSMeans is a database of current construction cost estimates) | nvarchar | |
| RSMReleaseDescription | RSMeans Release Description (RSMeans is a database of current construction cost estimates) | nvarchar | |
| RSMReleaseId | RSMeans Release Id (RSMeans is a database of current construction cost estimates) | nvarchar | |
| RSMStateId | RSMeans State Id (RSMeans is a database of current construction cost estimates) | nvarchar | |
| RSMTotalCost | RSMeans Total Cost (RSMeans is a database of current construction cost estimates) | decimal | |
| RSMTotalCost0 | RSMeans Total Cost 0 (RSMeans is a database of current construction cost estimates) | decimal | |
| RSMTotalCost1 | RSMeans Total Cost 1 (RSMeans is a database of current construction cost estimates) | decimal | |
| RSMTotalInHouseCost0 | RSMeans Total In House Cost 0 (RSMeans is a database of current construction cost estimates) | decimal | |
| RSMUnitOfMeasure | RSMeans Unit of Measure (RSMeans is a database of current construction cost estimates) | nvarchar | |
| ShopId | Shop Id | int | vr_Shop |
| TechnicianChargeRate | Technician Charge Rate | decimal | |
| TechnicianCode | Technician Code | nvarchar | |
| TechnicianId | Technician Id | int | vrpt_Technician |
| TechnicianName | Technician Name | nvarchar | |
| TradeCode | Trade Code | nvarchar | |
| TradeDefaultCharge | Trade Default Charge | decimal | |
| TradeDescription | Trade Description | nvarchar | |
| TradeId | Trade Id | int | vr_Trade |
| Type | Type | smallint | |
| TypeDescription | Type Description | varchar | |
| UnitCost | Unit Cost | decimal | |
| UtilityServiceId | Utility Service Id | int | vr_UtilityService |
community
/hc/en-us/community/topics
/hc/theming_assets/01HZH76HW8NTQYYTTBVVTM979X
Community
**You must be logged in to see any Topics or Posts**
work order, WebTMA7, reporting