vrpt_GrnTask

Updated December 23, 2025 15:20

Field Name	Field Description	Data Type	FK Join
associated_pts_fk	Associated Grounds Item Id	int
associated_um_fk	Associated Unit of Measure Id	int	vr_UnitMeasure
associatedBaseMinute	Associated Base Minute	decimal
associatedBaseQuantity	Associated Base Quantity	int
associatedCode	Associated Code	nvarchar
associatedDescription	Associated Description	nvarchar
associatedPoint	Associated Point	nvarchar
associatedRate	Associated Rate	decimal
associatedUnitCode	Associated Unit Code	nvarchar
associatedUnitDescription	Associated Unit Description	nvarchar
baseMinute	Base Minute	decimal
fo_code	Task Code	nvarchar
fo_description	Task Description	nvarchar
FrequencyUnitName1	Frequency Unit Name 1	varchar
FrequencyUnitName2	Frequency Unit Name 2	varchar
FrequencyUnitName3	Frequency Unit Name 3	varchar
FrequencyUnitName4	Frequency Unit Name 4	varchar
FrequencyUnitName5	Frequency Unit Name 5	varchar
grnfj_code	Grounds Task Type Code	nvarchar
grnfj_description	Grounds Task Type Description	nvarchar
grnfj_pk	Grounds Task Type Id	int
grnfo_active	Indicates if the Record is Active or Not	bit
grnfo_associatedTask_fk	Associated Task Id	int	vrpt_Task
grnfo_baseMinute	Base Minute	decimal
grnfo_baseQuantity	Base Quantity	int
grnfo_code	Code	nvarchar
grnfo_comment	Comment	nvarchar
grnfo_createdDate	Record Creation Date	datetime
grnfo_creator_fk	User Id (Record Creator)	int	vr_users
grnfo_description	Description	nvarchar
grnfo_fo_fk	Task Id	int	vrpt_Task
grnfo_frequency1	Frequency 1	tinyint
grnfo_frequency2	Frequency 2	tinyint
grnfo_frequency3	Frequency 3	tinyint
grnfo_frequency4	Frequency 4	tinyint
grnfo_frequency5	Frequency 5	tinyint
grnfo_frequencyUnit1	Frequency Unit 1	tinyint
grnfo_frequencyUnit2	Frequency Unit 2	tinyint
grnfo_frequencyUnit3	Frequency Unit 3	tinyint
grnfo_frequencyUnit4	Frequency Unit 4	tinyint
grnfo_frequencyUnit5	Frequency Unit 5	tinyint
grnfo_grnfj_fk	Grounds Task Type Id	int
grnfo_modifiedDate	Last Modified Date	datetime
grnfo_modifier_fk	User Id (Record Modifier)	int	vr_users
grnfo_pk	Grounds Task Id	int
grnfo_pts_fk	Grounds Item Id	int
grnfo_rate	Rate	decimal
Id	Grounds Task Id	int
pts_description	Grounds Item Description	nvarchar
pts_um_fk	Grounds Item Unit of Measure Id	int	vr_UnitMeasure
um_code	Unit of Measure Code	nvarchar
um_description	Unit of Measure Description	nvarchar

Articles in this section