vrpt_UFITemplateAssignmentList

Updated January 20, 2026 16:21

Field Name	Field Description	Data Type	FK Join
Id	Universal Financial Interface Template Assignment Id	int
jas_createdDate	Record Creation Date	datetime
jas_creator_fk	User Id (Record Creator)	int	vr_users
jas_fileNameFormat	File Name Format	nvarchar
jas_filePath	File Path	nvarchar
jas_fileType	File Type	int
jas_function	Function	nvarchar
jas_id	Universal Financial Interface Template Assignment Record Id	nvarchar
jas_jrnl_fk	Universal Financial Interface Template Setup Id	int
jas_modifiedDate	Last Modified Date	datetime
jas_modifier_fk	User Id (Record Modifier)	int	vr_users
jas_outputType	Output Type	int
jas_pk	Universal Financial Interface Template Assignment Id	int
jas_postBatchHeader	Post Batch Header	nvarchar
jas_rc_fk	Repair Center Id	int	vr_RepairCenter
jas_rc_fk_computed	Repair Center Id	int	vr_RepairCenter
jas_sql	Validation SQL	nvarchar
jas_ufisetup_fk	Universal Financial Interface Setup Id	int	vrpt_UFISetup
jas_UPIImpSetup_fk	Universal Procurement Interface Import Setup Id	int
jrnl_code	Universal Financial Interface Template Setup Code	nvarchar
jrnl_description	Universal Financial Interface Template Setup Description	nvarchar
jrnl_ledgerGroup	Universal Financial Interface Template Setup Ledger Group	nvarchar
jrnl_pk	Universal Financial Interface Template Setup Id	int
rc_code	Repair Center Code	nvarchar
rc_name	Repair Center Name	nvarchar
ufisetup_code	Universal Financial Interface Setup Code	nvarchar
ufisetup_description	Universal Financial Interface Setup Description	nvarchar
UFIsetup_webservice	Universal Financial Interface Setup Webservice	nvarchar