vrpt_GrnTask

Field NameField DescriptionData TypeFK Join
associated_pts_fkAssociated Grounds Item Idint 
associated_um_fkAssociated Unit of Measure Idintvr_UnitMeasure
associatedBaseMinuteAssociated Base Minutedecimal 
associatedBaseQuantityAssociated Base Quantityint 
associatedCodeAssociated Codenvarchar 
associatedDescriptionAssociated Descriptionnvarchar 
associatedPointAssociated Pointnvarchar 
associatedRateAssociated Ratedecimal 
associatedUnitCodeAssociated Unit Codenvarchar 
associatedUnitDescriptionAssociated Unit Descriptionnvarchar 
baseMinuteBase Minutedecimal 
fo_codeTask Codenvarchar 
fo_descriptionTask Descriptionnvarchar 
FrequencyUnitName1Frequency Unit Name 1varchar 
FrequencyUnitName2Frequency Unit Name 2varchar 
FrequencyUnitName3Frequency Unit Name 3varchar 
FrequencyUnitName4Frequency Unit Name 4varchar 
FrequencyUnitName5Frequency Unit Name 5varchar 
grnfj_codeGrounds Task Type Codenvarchar 
grnfj_descriptionGrounds Task Type Descriptionnvarchar 
grnfj_pkGrounds Task Type Idint 
grnfo_activeIndicates if the Record is Active or Notbit 
grnfo_associatedTask_fkAssociated Task Idintvrpt_Task
grnfo_baseMinuteBase Minutedecimal 
grnfo_baseQuantityBase Quantityint 
grnfo_codeCodenvarchar 
grnfo_commentCommentnvarchar 
grnfo_createdDateRecord Creation Datedatetime 
grnfo_creator_fkUser Id (Record Creator)intvr_users
grnfo_descriptionDescriptionnvarchar 
grnfo_fo_fkTask Idintvrpt_Task
grnfo_frequency1Frequency 1tinyint 
grnfo_frequency2Frequency 2tinyint 
grnfo_frequency3Frequency 3tinyint 
grnfo_frequency4Frequency 4tinyint 
grnfo_frequency5Frequency 5tinyint 
grnfo_frequencyUnit1Frequency Unit 1tinyint 
grnfo_frequencyUnit2Frequency Unit 2tinyint 
grnfo_frequencyUnit3Frequency Unit 3tinyint 
grnfo_frequencyUnit4Frequency Unit 4tinyint 
grnfo_frequencyUnit5Frequency Unit 5tinyint 
grnfo_grnfj_fkGrounds Task Type Idint 
grnfo_modifiedDateLast Modified Datedatetime 
grnfo_modifier_fkUser Id (Record Modifier)intvr_users
grnfo_pkGrounds Task Idint 
grnfo_pts_fkGrounds Item Idint 
grnfo_rateRatedecimal 
IdGrounds Task Idint 
pts_descriptionGrounds Item Descriptionnvarchar 
pts_um_fkGrounds Item Unit of Measure Idintvr_UnitMeasure
um_codeUnit of Measure Codenvarchar 
um_descriptionUnit of Measure Descriptionnvarchar 
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!