vr_Department

Updated November 21, 2025 16:50

Field Name	Field Description	Data Type	FK Join
AccountActive	Indicates if the Department's Account is Active	bit
AccountCode	Account Code	nvarchar
AccountId	Account Id	int	vr_account
AccountName	Account Name	nvarchar
Active	Indicates if the Record is Active or Not	bit
ActiveForWorkOrder	Active For Work Order	bit
Address1	Address Line 1	nvarchar
Address2	Address Line 2	nvarchar
BillingFrequency	Billing Frequency	int
City	City	nvarchar
Code	Department Code	nvarchar
Contact	Contact	nvarchar
Country	Country	nvarchar
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
DepartmentTypeCode	Department Type Code	nvarchar
DepartmentTypeDescription	Department Type Description	nvarchar
DepartmentTypeId	Department Type Id	int	vr_departmentType
Description	Description	nvarchar
dp_pk	Department Id	int
Email	Email	nvarchar
Fax	Fax	nvarchar
Id	Department Id	int
MobilePhone	Contact Mobile Phone #	nvarchar
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
Name	Department Name	nvarchar
OtherInformation	Other Information	nvarchar
ParentCode	Parent Code	nvarchar
ParentId	Department Parent Id	int	vr_Department
ParentName	Department Department Name	nvarchar
Phone	Phone	nvarchar
RateScheduleActive	Rate Schedule Active	bit
RateScheduleCode	Rate Schedule Code	nvarchar
RateScheduleDescription	Rate Schedule Description	nvarchar
RateScheduleId	Rate Schedule Id	int	vr_rateSchedule
RateScheduleWorkOrder	Indicates if the Department is Tied to a Rate Schedule for Work Orders	bit
State	State	nvarchar
Value	Value	nvarchar
Website	Webiste	nvarchar
Zip	Zip Code	nvarchar

Articles in this section