vr_LinearAsset

Field NameField DescriptionData TypeFK Join
AccountCodeAccount Codenvarchar 
AccountIdAccount Idintvr_account
AccountNameAccount Namenvarchar 
ActiveIndicates if the Record is Active or Notbit 
ActiveComputedActive Computedbit 
CalibratedThroughCalibrated Throughdatetime 
CodeLinear Asset Codenvarchar 
CreatedDateRecord Creation Datedatetime 
CreatorIdUser Id (Record Creator)intvr_users
DepartmentCodeDepartment Codenvarchar 
DepartmentIdDepartment Idintvr_Department
DepartmentNameDepartment Namenvarchar 
DescriptionDescriptionnvarchar 
direction_nameDirection Namenvarchar 
DistrictCodeDistrict Codenvarchar 
DistrictIdDistrict Idintvr_District
DistrictNameDistrict Namenvarchar 
DivisionCodeDivision Codenvarchar 
DivisionIdDivision Idint 
DivisionNameDivision Namenvarchar 
EndMeasureEnd Measuredecimal 
FacilityCodeFacility Codenvarchar 
FacilityIdFacility Idintvr_facility
FacilityNameFacility Namenvarchar 
GISUniqueIdGIS Unique Iduniqueidentifier 
IdLinear Asset Idint 
ImageImagenvarchar 
LastCalibrationDateLast Calibration Datedatetime 
LatitudeLatitudefloat 
LinearAssetSubTypeCodeLinear Asset Sub Type Codenvarchar 
LinearAssetSubTypeDescriptionLinear Asset Sub Type Descriptionnvarchar 
LinearAssetSubTypeIdLinear Asset Sub Type Idint 
LinearAssetTypeCodeLinear Asset Type Codenvarchar 
LinearAssetTypeDescriptionLinear Asset Type Descriptionnvarchar 
LinearAssetTypeIdLinear Asset Type Idintvr_LinearAssetType
LinearFeatureTypeCodeLinear Feature Type Codenvarchar 
LinearFeatureTypeDescriptionLinear Feature Type Descriptionnvarchar 
LinearFeatureTypeIdLinear Feature Type Idint 
LongitudeLongitudefloat 
ModifiedDateLast Modified Datedatetime 
ModifierIdUser Id (Record Modifier)intvr_users
NameLinear Asset Namenvarchar 
ParentCodeParent Codenvarchar 
ParentIdParent Idintvr_LinearAsset
ParentNameParent Namenvarchar 
PreferredRepairCenterPreferred Repair Centerint 
PreventArchivalPrevent Archivalbit 
RegionCodeRegion Codenvarchar 
RegionIdRegion Idintvr_region
RegionNameRegion Namenvarchar 
StartMeasureStart Measuredecimal 
TagNumberTag Numbernvarchar 
TechnicianIdTechnician Idintvrpt_Technician
TechnicianNameTechnician Namenvarchar 
XcoordinateX Coordinatefloat 
YcoordinateY Coordinatefloat 
Was this article helpful?
0 out of 0 found this helpful

Articles in this section

See more
Announcing WebTMA + Workday Integration
To Learn More, Click Here!
2026 Webinar Training Schedule - Register now!
See the full list of web training events.
TMA Systems - TMA Connect 2026 Registration
Register Now by clicking here!