vr_Account

Updated November 14, 2025 17:23

Field Name	Field Description	Data Type	FK Join
AccountGroupCode	Account Group Code	nvarchar
AccountGroupDescription	Account Group Description	nvarchar
AccountGroupId	Account Group Id	int
AccountSubTypeCode	Account Sub Type Code	nvarchar
AccountSubTypeDescription	Account Sub Type Description	nvarchar
AccountSubTypeId	Account Sub Type Id	int
AccountTypeCode	Account Type Code	nvarchar
AccountTypeDescription	Account Type Description	nvarchar
AccountTypeId	Account Type Id	int	vr_accountType
Active	Indicates if the Record is Active or Not	bit
Alias	Alias	nvarchar
AlternateAccount	Alternate Account Number	nvarchar
BalanceType	Balance Type	nvarchar
BeginningBalance	Beginning Balance	decimal
ChargeAccountName	Account Name	nvarchar
ChargeAccountNumber	Account Number	nvarchar
Code	Account Code	nvarchar
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
CurrencyExchangeDate	Currency Exchange Date	datetime
CurrencyExchangeId	Currency Exchange Id	int
CurrencyId	Currency Id	int	vrpt_Currency
DepartmentCode	Department Code	nvarchar
DepartmentId	Department Id	int	vr_Department
DepartmentName	Department Name	nvarchar
Encumbered	Encumbered	decimal
HasSubContract	Has Sub Contract	bit
Id	Account Id	int
IsHeader	Is Header	bit
LastPostDate	Last Post Date	datetime
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
Name	Account Name	nvarchar
NormalBalance	Account Normal Balance	nvarchar
PurgeDate	Purge Date	datetime
SplitBill	Split Billing	bit
SubContractLaborCode	Sub Contract Labor Code	nvarchar
SubContractLaborId	Sub Contract Labor Id	int	vr_account
SubContractLaborName	Sub Contract Labor Name	nvarchar
SubContractOtherCode	Sub Contract Other Code	nvarchar
SubContractOtherId	Sub Contract Other Id	int	vr_account
SubContractOtherName	Sub Contract Other Name	nvarchar
SubContractPartsCode	Sub Contract Parts Code	nvarchar
SubContractPartsId	Sub Contract Parts Id	int	vr_account
SubContractPartsName	Sub Contract Parts Name	nvarchar
SubLaborCode	Sub Labor Code	nvarchar
SubLaborId	Sub Labor Id	int	vr_account
SubLaborName	Sub Labor Name	nvarchar
SubOtherCode	Sub Other Code	nvarchar
SubOtherId	Sub Other Id	int	vr_account
SubOtherName	Sub Other Name	nvarchar
SubPartsCode	Sub Parts Code	nvarchar
SubPartsId	Sub Parts Id	int	vr_account
SubPartsName	Sub Parts Name	nvarchar
Value	Value	nvarchar

Articles in this section