| Field Name | Field Description | Data Type | FK Join |
|---|---|---|---|
| ACT_DESCRIPTION | Project Activity (Task) Description | nvarchar | |
| combined_code | Technician Code or Part Code | nvarchar | |
| combined_description | Technician Name, Part Description or Estimate Item Description | nvarchar | |
| combined_itemType | Labor, Material, Other or Miscellaneous | varchar | |
| combined_pk | Technician Id, Part Id or Estimate item Id | int | |
| combined_type | Estimate Item Type | smallint | |
| eco_number | Change Order Number | nvarchar | |
| eco_pk | Change Order Id | int | vr_ChangeOrder |
| ei_budget | Estimate Item Budget | decimal | |
| ei_comment | Estimate Item Comment | nvarchar | |
| ei_createdDate | Record Creation Date | datetime | |
| ei_creator_fk | User Id (Record Creator) | int | vr_users |
| ei_curr_fk | Currency Id | int | vrpt_Currency |
| ei_description | Estimate Item Description | nvarchar | |
| ei_eco_fk | Change Order Id | int | vr_ChangeOrder |
| ei_est_fk | Estimate Id | int | vr_Estimate |
| ei_et_fk | Utility Service Id | int | vr_UtilityService |
| ei_etp_fk | Estimate Type Id | int | vr_estimateType |
| ei_exch_date | Exchange Date | datetime | |
| ei_exch_fk | Currency Exchange Id | int | |
| ei_extendedCost | Extended Cost | decimal | |
| ei_fp_fk | Part Type Id | int | vr_PartType |
| ei_ftr_fk | Trade Id | int | vr_Trade |
| ei_itemType_fk | Item Type Id | int | |
| ei_modifiedDate | Last Modified Date | datetime | |
| ei_modifier_fk | User Id (Record Modifier) | int | vr_users |
| ei_pa_fk | Part Id | int | vr_Part |
| ei_pk | Estimate Item Id | int | |
| ei_quantity | Quantity | decimal | |
| ei_rsmCatalogDescription | RSMeans Catalog Description (RSMeans is a database of current construction cost estimates) | nvarchar | |
| ei_rsmCatalogTypeDescription | RSMeans Catalog Type Description (RSMeans is a database of current construction cost estimates) | nvarchar | |
| ei_rsmCostDataFormat | RSMeans Cost Data Format (RSMeans is a database of current construction cost estimates) | nvarchar | |
| ei_rsmCostLineDescription | RSMeans Cost Line Description (RSMeans is a database of current construction cost estimates) | nvarchar | |
| ei_rsmCostTypeDescription | RSMeans Cost Type Description (RSMeans is a database of current construction cost estimates) | nvarchar | |
| ei_rsmCostTypeID | RSMeans Cost Type Id (RSMeans is a database of current construction cost estimates) | int | |
| ei_rsmCountryID | RSMeans Country Id (RSMeans is a database of current construction cost estimates) | nvarchar | |
| ei_rsmDivision1Description | RSMeans Division 1 Description (RSMeans is a database of current construction cost estimates) | nvarchar | |
| ei_rsmDivision2Description | RSMeans Division 2 Description (RSMeans is a database of current construction cost estimates) | nvarchar | |
| ei_rsmDivision3Description | RSMeans Division 3 Description (RSMeans is a database of current construction cost estimates) | nvarchar | |
| ei_rsmDivision4Description | RSMeans Division 4 Description (RSMeans is a database of current construction cost estimates) | nvarchar | |
| ei_rsmEquipmentCost | RSMeans Equipment Cost (RSMeans is a database of current construction cost estimates) | decimal | |
| ei_rsmInstallationCost | RSMeans Installation Cost (RSMeans is a database of current construction cost estimates) | decimal | |
| ei_rsmLaborCost | RSMeans Labor Cost (RSMeans is a database of current construction cost estimates) | decimal | |
| ei_rsmLaborHours | RSMeans Labor Hours (RSMeans is a database of current construction cost estimates) | decimal | |
| ei_rsmLaborTypeDescription | RSMeans Labor Type Description (RSMeans is a database of current construction cost estimates) | nvarchar | |
| ei_rsmLineDescription | RSMeans Line Description (RSMeans is a database of current construction cost estimates) | nvarchar | |
| ei_rsmLineNumber | RSMeans Line Number (RSMeans is a database of current construction cost estimates) | nvarchar | |
| ei_rsmLocationDescription | RSMeans Location Description (RSMeans is a database of current construction cost estimates) | nvarchar | |
| ei_rsmMaterialCost | RSMeans Material Cost (RSMeans is a database of current construction cost estimates) | decimal | |
| ei_rsmMeasurementSystemDescription | RSMeans Measurement System Description (RSMeans is a database of current construction cost estimates) | nvarchar | |
| ei_rsmReleaseDescription | RSMeans Release Description (RSMeans is a database of current construction cost estimates) | nvarchar | |
| ei_rsmStateID | RSMeans State Id (RSMeans is a database of current construction cost estimates) | nvarchar | |
| ei_rsmTotalCost | RSMeans Total Cost (RSMeans is a database of current construction cost estimates) | decimal | |
| ei_rsmTotalInHouseCost0 | RSMeans Total In House Cost 0 (RSMeans is a database of current construction cost estimates) | decimal | |
| ei_rsmUnitOfMeasure | RSMeans Unit Of Measure (RSMeans is a database of current construction cost estimates) | nvarchar | |
| ei_sh_fk | Shop Id | int | vr_Shop |
| ei_type | Estimate Item Type | smallint | |
| ei_unitCost | Unit Cost | decimal | |
| ei_wk_fk | Technician Id | int | vrpt_Technician |
| etp_code | Estimate Type Code | nvarchar | |
| etp_description | Estimate Type Description | nvarchar | |
| ftr_code | Trade Code | nvarchar | |
| ftr_description | Trade Description | nvarchar | |
| Id | Estimate Item Id | int |
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