vr_BatchJob

Updated February 03, 2026 16:37

Field Name	Field Description	Data Type	FK Join
AccountCode	Account Code	nvarchar
AccountId	Account Id	int	vr_account
ActualStart	Actual Start	datetime
ArchiveconId	Archive Id	int
Automatic	Automatic	bit
Autoprint	Auto Print	bit
BatchJobStatusId	Batch Job Status Id	int
BatchJobStatusNote	Batch Job Status Note	nvarchar
BatchJobTypeDescription	Batch Job Type Description	nvarchar
BatchJobTypeId	Batch Job Type Id	int
BjsMessageId	Batch Job Status Message Id	int
CanceledById	User Id	int	vr_users
CanceledByName	Cancelled By Name	nvarchar
CanceledDate	Cancelled Date	datetime
CompletedDate	Date Completed	datetime
ContractId	Contract Id	int	vr_contract
ContractNumber	Contract Number	nvarchar
CPElement1Id	UniFormat Level 1 Id	int	vr_cpElement
CPElement2Id	UniFormat Level 2 Id	int	vr_cpElement
CPElement3Id	UniFormat Level 3 Id	int	vr_cpElement
CPElement4Id	UniFormat Level 4 Id	int	vr_cpElement
CpSetupId	Capital Planning Setup Id	int	vrpt_cpSetup
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
CreatorName	Creator Name	nvarchar
DaysForward	Days Forward	int
DepartmentIds	Department Ids (Departments Selected)	nvarchar
DispatchRouteId	Dispatch Route Id	int
DueInterval	Due Interval	int
DueIntervalFrequency	Due Interval Frequency	nvarchar
DueLastDayOfMonth	Indicates if the Due Last Day of Month Checkbox is Checked or Not	bit
Email	Email Address	nvarchar
ForApprovedLabor	For Approved Labor	bit
ForClosedTransaction	For Closed Transaction	bit
ForOpenTransaction	For Open Transaction	bit
GenerateAll	Indicates if the Generate All Checkbox is Checked or Not	bit
Id	Batch Job Id	int
IntervalId	Interval Id	int
ItemCode	Item Code	int
ItemDescription	Item Description	int
ItemId	Item Id	int
ItemTypeId	Item Type Id	nvarchar
LocationCode	Location Code	nvarchar
LocationId	Location Id	int
LocationName	Location Name	nvarchar
LocationTypeId	Location Type Id	int
LookupTypeId	Lookup Type Id	nvarchar
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
MonthBackForProjStartDate	Month Back for Projected Start Date	int
Notes	Notes	nvarchar
NotifyCustomer	Notify Customer	bit
ParentId	Batch Job Parent Id	int	vr_BatchJob
PopulateDueDateWithEstimateEnd	Populate Due Date With Estimated End Date	bit
PostEndDate	Post End Date	datetime
PostStartDate	Post Start Date	datetime
RecurrenceEndDate	Recurring Batch Job Until Date	datetime
RecurrenceValue	Recurring Batch Job Value	int
RecurringBJ	Indicates if the Batch Job is a Recurring Batch Job or Not	bit
RegulatoryOption	Regulatory Option	smallint
ReleasePendingCharges	Release Pending Charges	bit
RepairCenterCode	Repair Center Code	nvarchar
RepairCenterId	Repair Center Id	int	vr_RepairCenter
RepairCenterName	Repair Center Name	nvarchar
RiskLevels	Risk Levels	nvarchar
SelectionType	Batch Job Generation Type (Automatic or Manual)	int
ShopCode	Shop Code	nvarchar
ShopId	Shop Id	int	vr_Shop
StartDate	Batch Job Start Date	datetime
StatusLang	Batch Job Status Language String (Language Id)	nvarchar
TagTypeCode	Tag Type Code	int
TagTypeDescription	Tag Type Description	int
TagTypeId	Tag Type Id	int
TaskCode	Task Code	nvarchar
TaskDescription	Task Description	nvarchar
TaskId	Task Id	int	vrpt_Task
TechnicianCode	Technician Code	nvarchar
TechnicianId	Technician Id	int	vrpt_Technician
TechnicianName	Technician Name	nvarchar
Today	Today	datetime
TradeDescription	Trade Description	nvarchar
TradeId	Trade Id	int	vr_Trade
TransactionTypeIds	Transaction Type Ids	nvarchar
TransNumber	Transaction Number (Work Order # or Sales Order #)	nvarchar
TripTypeId	Trip Type Id	int	vrpt_travelTripType
UfiProcessed	UFI Processed	bit
UserId	User Id	int	vr_users
WorkOrderTypeCode	Work Order Type Code	nvarchar
WorkOrderTypeId	Work Order Type Id	int	vr_WorkOrderType
ZoneCode	Zone Code	nvarchar
ZoneId	Zone Id	int	vr_zone
ZoneName	Zone Name	nvarchar

Articles in this section