vr_JournalEntry

Updated November 25, 2025 16:39

Field Name	Field Description	Data Type	FK Join
Amount	Amount	decimal
BatchJobId	Batch Job Id	int	vr_BatchJob
BudgetCodeCode	Budget Code Code	nvarchar
BudgetCodeDescription	Budget Code Description	nvarchar
BudgetCodeId	Budget Code Id	int
Comment	Comments	nvarchar
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
CreditAccountCode	Credit Account Code	nvarchar
CreditAccountId	Credit Account Id	int	vr_account
CreditAccountName	Credit Account Name	nvarchar
CurrencyExchangeDate	Currency Exchange Date	datetime
CurrencyExchangeId	Currency Exchange Id	int
CurrencyId	Currency Id	int	vrpt_Currency
DebitAccountCode	Debit Account Code	nvarchar
DebitAccountId	Debit Account Id	int	vr_account
DebitAccountName	Debit Account Name	nvarchar
Id	Journal Entry Id	int
ItemTypeId	Item Type Id	int
ItemTypeName	Item Type Name	nvarchar
JournalEntryTypeCode	Journal Entry Type Code	nvarchar
JournalEntryTypeDescription	Journal Entry Type Description	nvarchar
JournalEntryTypeId	Journal Entry Type Id	int
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
Number	Journal Entry Number	int
PostDate	Post Date	datetime
ReferenceNumber	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
TransactionDate	Transaction Date	datetime