vr_ExpenseTicket

Updated November 24, 2025 16:10

Field Name	Field Description	Data Type	FK Join
AccountCode	Account Code	nvarchar
AccountId	Account Id	int	vr_account
AccountProgramCode	Account Program Code	nvarchar
AccountProgramId	Account Program Id	int
ArchiveRentalId	Archive Rental Id	int
BudgetCodeCode	Budget Code Code	nvarchar
BudgetCodeDescription	Budget Code Description	nvarchar
BudgetCodeId	Budget Code Id	int
Charge	Indicates Whether the Expense Ticket is Chargeable	bit
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
Date	Expense Ticket Date	datetime
DepartmentCode	Department Code	nvarchar
DepartmentId	Department Id	int	vr_Department
DepartmentName	Department Name	nvarchar
ETTaxCompound	Indicates if the record utilizes tax compound	bit
ETTaxRate	Tax Rate	decimal
ETTaxRate2	Tax Rate 2	decimal
ExpenseTicketTaxRateCompound	Taxt Rate Compounded	bit
ExpenseTicketTaxRateExpense	Tax Rate Expense	bit
ExpenseTicketTaxRateId	Tax Rate Id	int	vr_TaxRate
ExpenseTicketTaxRateName	Tax Rate Name	nvarchar
ExpenseTicketTaxRateRate1	Tax Rate 1	decimal
ExpenseTicketTaxRateRate2	Tax Rate 2	decimal
ExpenseTicketTaxRateTax1Description	Tax Rate 1 Description	nvarchar
ExpenseTicketTaxRateTax2Description	Tax Rate 2 Description	nvarchar
ExpenseTicketTypeCode	Expense Ticket Type Code	nvarchar
ExpenseTicketTypeDescription	Expense Ticket Type Description	nvarchar
ExpenseTicketTypeId	Expense Ticket Type Id	int	vr_ExpenseTicketType
Id	Expense Ticket Id	int
ItemDescription	Item Description	nvarchar
ItemId	Item Id	int
ItemTagNumber	Item Tag Number	nvarchar
ItemTypeId	Item Type Id	int
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
Number	Expense Ticket Number	int
PostDate	Post Date	datetime
Recipient	Recipient	nvarchar
ReferenceNumber	Reference Number	nvarchar
RentalId	Rental Id	int
RentalNumber	Rental Number	int
RentalReferenceNumber	Rental Reference Number	nvarchar
RepairCenterCode	Repair Center Code	nvarchar
RepairCenterId	Repair Center Id	int	vr_RepairCenter
RepairCenterName	Repair Center Name	nvarchar
SLPostDate	Sub Ledger Post Date	datetime
SubTotal	Sub Total	decimal
TaxAmount	Tax Amount	decimal
TaxAmount1	Tax Amount 1	decimal
TaxAmount2	Tax Amount 2	decimal
TaxlineSubTotal	Tax Sub Total	decimal
Total	Total	numeric

Articles in this section