vrpt_ExpenseItems

Updated December 22, 2025 16:16

Field Name	Field Description	Data Type	FK Join
cst_code	Account Code	nvarchar
cst_name	Account Name	nvarchar
fld_code	Expense Type Code	nvarchar
fld_description	Expense Type Description	nvarchar
fld_pk	Expense Type Id	int	vr_expenseType
flt_number	Expense Ticket Number	int
FLT_RC_FK	Repair Center Id	int	vr_RepairCenter
fti_bj_fk	Batch Job Id	int	vr_BatchJob
FTI_createdDATE	Record Creation Date	datetime
FTI_CREATOR_FK	User Id (Record Creator)	int	vr_users
FTI_CST_FK	Account Id	int	vr_account
FTI_curr_fk	Currency Id	int	vrpt_Currency
FTI_exch_date	Currency Exchange Date	datetime
FTI_exch_fk	Currency Exchange Id	int
FTI_extendedCost	Extended Cost	decimal
FTI_FLD_FK	Expense Type Id	int	vr_expenseType
FTI_FLT_FK	Expense Ticket Id	int	vr_ExpenseTicket
FTI_modifiedDATE	Last Modified Date	datetime
FTI_MODIFIER_FK	User Id (Record Modifier)	int	vr_users
FTI_PK	Expense Items Id	int
FTI_postDATE	Post Date	datetime
FTI_Quantity	Quantity	decimal
fti_SLPostDate	Sub Ledger Post Date	datetime
FTI_TAXABLE	Indicates if this record is taxable	bit
FTI_UnitCost	Unit Cost	decimal
FTI_unitOfMeasure	Unit Of Measure	nvarchar
Id	Expense Items Id	int
transdate	Transaction Date	datetime