Cost Code Lookup for Equipment Expense Example
Create a custom lookup that limits cost codes for Equipment expense items based on GL account overrides on the EM Department.
You must be a System Admin to complete the following task.
Viewpoint HR Management for Vista
list_alt
Create a custom lookup that limits cost codes for Equipment expense items based on GL account overrides on the EM Department.
You must be a System Admin to complete the following task.
select Cast(kEMCC.KeyID as varchar(10)) ChoiceShortName, kEMCC.CostCode + ' - ' + kEMCC.Description as ChoiceLongName
from kEMDO
INNER JOIN kEMEM on kEMDO.EMCo = kEMEM.EMCo and kEMDO.Department = kEMEM.Department
INNER JOIN kEMCC on kEMDO.EMGroup = kEMCC.EMGroup and kEMDO.CostCode = kEMCC.CostCode
WHERE kEMEM.Equipment = @Equipment
© 2024 Viewpoint, Inc. All Rights Reserved. Viewpoint®, Vista™, Spectrum®, ProContractor™, Jobpac Connect™, Viewpoint Team™, Viewpoint Analytics™, Viewpoint Field View™, Viewpoint Estimating™, Viewpoint For Projects™, Viewpoint HR Management™, Viewpoint Field Management™, Viewpoint Financial Controls™, Viewpoint Field Service™, Spectrum Service Tech™, ViewpointOne™ and Trimble Construction One™ are trademarks or registered trademarks of Trimble Inc., Viewpoint, Inc., or their affiliates in the United States and other countries. Other names and brands may be claimed as the property of others.
Trimble is developing technology, software and services that drive the digital transformation of construction with solutions that span the entire architecture, engineering and construction (AEC) industry. Empowering teams across the construction lifecycle, Trimble's innovative approach improves coordination and collaboration between stakeholders, teams, phases and processes. Trimble's Connected Construction strategy gives users control of their operations with best-in-class solutions and a common data environment. By automating work and transforming workflows, Trimble is enabling construction professionals to improve productivity, quality, transparency, safety, sustainability and deliver each project with confidence. For more information, visit: construction.trimble.com.