vr_TaxRate

Updated November 27, 2025 15:15

Field Name	Field Description	Data Type	FK Join
AccountCollected1Code	Account Collected 1 Code	nvarchar
AccountCollected1Id	Account Collected 1 Id	int	vr_account
AccountCollected1Name	Account Collected 1 Name	nvarchar
AccountCollected2Code	Account Collected 2 Code	nvarchar
AccountCollected2Id	Account Collected 2 Id	int	vr_account
AccountCollected2Name	Account Collected 2 Name	nvarchar
AccountExpense1Code	Account Expense 1 Code	nvarchar
AccountExpense1Id	Account Expense 1 Id	int	vr_account
AccountExpense1Name	Account Expense 1 Name	nvarchar
AccountExpense2Code	Account Expense 2 Code	nvarchar
AccountExpense2Id	Account Expense 2 Id	int	vr_account
AccountExpense2Name	Account Expense 2 Name	nvarchar
Active	Indicates if the Record is Active or Not	bit
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
ExemptCode	Tax Exempt Code	nvarchar
ExpenseTickets	Indicates if this Tax Rate can be used on Expense Tickets	bit
Fuel	Indicates if this Tax Rate can be used on Fuel and Oil Records	bit
Id	Tax Rate Id	int
IncludeTax2	Indicates if this Tax Rate includes Tax Rate 2	bit
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
Name	Tax Rate Name	nvarchar
PassThruRate	Pass Thru Rate	decimal
PCardTransaction	Indicates if this Tax Rate can be used on PCard Transaction Records	bit
Purchase	Indicates if this Tax Rate can be used on Purchase Order Records	bit
Rate1	Tax Rate 1	decimal
Rate2	Tax Rate 2	decimal
Rental	Indicates if this Tax Rate can be used on Rental Records	bit
SalesOrder	Indicates if this Tax Rate can be used on Sales Order Records	bit
Tax1Description	Tax 1 Description	nvarchar
Tax2Description	Tax 2 Description	nvarchar
Tax2OnTax1	Indicates if this Tax Rate record utilizes tax compounding	bit
WOContractor	Indicates if this Tax Rate can be used on Work Order Contractor Costs	bit
WOLabor	Indicates if this Tax Rate can be used on Work Order Labor Costs	bit
WOOtherCharge	Indicates if this Tax Rate can be used on Work Order Other Charge Costs	bit
WOPart	Indicates if this Tax Rate can be used on Work Order Part Costs	bit

Articles in this section