vr_RepairCenter

Updated November 27, 2025 13:21

Field Name	Field Description	Data Type	FK Join
Active	Indicates if the Record is Active or Not	bit
Address1	Address Line 1	nvarchar
Address2	Address Line 2	nvarchar
AdvancedEstimate	Advanced Estimate	bit
ApplyMultipliers	Apply Multipliers	bit
AuthorizationRequired	Authorization Required	bit
AutoCont	Auto Cont	bit
AutoConvertToWorkOrder	Auto Convert to Work Order	bit
AutoEst	Auto Estimate	bit
AutoPOCounter	Auto PO Counter	bit
AutoPOPrefix	Auto PO Prefix	nvarchar
AutoPOSequence	Auto PO Sequence	int
AutoPrintUserFullName	Auto Print User Full Name	nvarchar
AutoPrintUserId	User Id (Auto Print User)	int	vr_users
AutoPrintUserLoginCode	User Login Code (Id)	nvarchar
AutoPrintWorkOrder	Auto Print Work Order	bit
BarCode	Bar Coded	bit
CheckInTaskCode	Check In Task Code	nvarchar
CheckInTaskDescription	Check In Task Description	nvarchar
CheckInTaskId	Check In Task Id	int	vrpt_Task
City	City	nvarchar
CloseTask	Close Task	bit
Code	Repair Center Code	nvarchar
Consolidate	Consolidate	bit
ContractType	Contract Type	bit
Country	Country	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
DefaultPriorityCode	Default Priority Code	nvarchar
DefaultPriorityDescription	Default Priority Description	nvarchar
DefaultPriorityId	Default Priority Id	int	vr_Priority
DefaultTaskCode	Default Task Code	nvarchar
DefaultTaskDescription	Default Task Description	nvarchar
DefaultTaskId	Default Task Id	int	vrpt_Task
DefaultTradeCode	Default Trade Code	nvarchar
DefaultTradeDescription	Default Trade Description	nvarchar
DefaultTradeId	Default Trade Id	int	vr_Trade
DeleteMail	Delete Mail	smallint
Description	Repair Center Description	nvarchar
DiscountPayableAccountCode	Discount Payable Account Code	nvarchar
DiscountPayableAccountId	Discount Payable Account Id	int	vr_account
DiscountPayableAccountName	Discount Payable Account Name	nvarchar
DiscountReceivableAccountCode	Discount Receivable Account Code	nvarchar
DiscountReceivableAccountId	Discount Receivable Account Id	int	vr_account
DiscountReceivableAccountName	Discount Receivable Account Name	nvarchar
DupeCheck	Indicates if the repair center record has duplicate check enabled	bit
DupeCheckOpenWorkOrder	Indicates if the record is set to check for duplicate work orders	bit
DupeCheckRange	Duplicate Check Range	int
Ecri	ECRI	bit
EndTime	End Time	nvarchar
EquipmentView	Equipment View	nvarchar
EstimateRequired	Indicates if records associated with this Repair Center require an estimate	bit
ExcludeNotifyTechnicianPM	Exclude Notify Technician PM	bit
Fax	Fax	nvarchar
FiveSevenDayPM	Five or Seven Day PM Schedules	smallint
FreightPayableAccountCode	Freight Payable Account Code	nvarchar
FreightPayableAccountId	Freight Payable Account Id	int	vr_account
FreightPayableAccountName	Freight Payable Account Name	nvarchar
FreightReceivableAccountCode	Freight Receivable Account Code	nvarchar
FreightReceivableAccountId	Freight Receivable Account Id	int	vr_account
FreightReceivableAccountName	Freight Receivable Account Name	nvarchar
GenWorkOrder	Gen Work Order	smallint
GIBypassCheckOut	General Inspection Bypass Check Out	bit
GoLiveDate	Go Live Date	datetime
HideEstimate	Indicates if records associated with this Repair Center hide estimates	bit
HideWorkOrderArea	Indicates if records associated with this Repair Center hide work order area	bit
HourlyLaborRate	Hourly Labor Rate	decimal
IconAlt	Icon Alternate	float
Id	Repair Center Id	int
IsChargeable	Indicates if records associated with this Repair Center are defaulted to chargeable	bit
IsDSurvey	Indicates if the record utilizes iService Desk Surveys	bit
Laser	Laser	bit
Logo	Repair Center Logo	nvarchar
LogoContentType	Repair Center Logo Content Type	nvarchar
LookBackDays	Look Back Days	smallint
Mailbox	Mailbox	nvarchar
MailboxName	Mailbox Name	nvarchar
MailCenter	Mail Center	nvarchar
MailPass	Mail Pass	nvarchar
MailZone	Mail Zone	nvarchar
Manager	Manager	nvarchar
MarkupReceivableAccountCode	Markup Receivable Account Code	nvarchar
MarkupReceivableAccountId	Markup Receivable Account Id	int	vr_account
MarkupReceivableAccountName	Markup Receivable Account Name	nvarchar
Metric	Metric	bit
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
Name	Repair Center Name	nvarchar
NatOrder	Nat Order	bit
NotLocatedCounter	Not Located Counter	int
OverageAccountCode	Overage Account Code	nvarchar
OverageAccountId	Overage Account Id	int	vr_account
OverageAccountName	Overage Account Name	nvarchar
OverrideAuthorization	Override Authorization	bit
OverrideTechnician	Override Technician	bit
Phone	Phone	nvarchar
PMDays	Default for how many days forward PM Schedules will be generated	smallint
PMPrinterId	PM Printer Id	int
PMPrinterName	PM Printer Name	nvarchar
POAuthorizationRequired	Purchase Order Authorization Required	bit
POCOAuthorizationRequired	Purchase Order Change Order Authorization Required	bit
PositionBasedRate	Indicates if the record utilizes position based rates	bit
PRAuthorizationRequired	PRAuthorizationRequired	bit
PrintBFDetail	Indicates if the record allows belt, filter, part detail to print on report	bit
PrintBuildingAddress	Indicates if the record allows building address to print on report	bit
PrintDetail	Indicates if the record allows detail to print on report	bit
PrinterId	Printer Id	int
PrinterName	Printer Name	nvarchar
PriorityCode	Priority Code	nvarchar
PriorityDescription	Priority Description	nvarchar
PriorityDueInterval	Priority Due Interval	int
PriorityDueIntervalType	Priority Due Interval Type	nvarchar
PriorityId	Priority Id	int	vr_Priority
ProjectReqAuthorizationRequired	Project Requisition Authorization Required	bit
ProjectSurveyTitle	Project Survey Title	nvarchar
PromptForPrint	Indicates if the record's work orders will prompt for printing	bit
ReminderRecipient	Reminder Recipient	nvarchar
ReplyAccept	Reply Accept	nvarchar
ReplyDeny	Reply Deny	nvarchar
ReplyStatus	Reply Status	nvarchar
ReplyType	Reply Type	float
ShipToDeliveryNote	Ship To Delivery Note	nvarchar
ShipToLocationAddress1	Ship To Location Address 1	nvarchar
ShipToLocationAddress2	Ship To Location Address 2	nvarchar
ShipToLocationCity	Ship To Location City	nvarchar
ShipToLocationCode	Ship To Location Code	nvarchar
ShipToLocationId	Ship To Location Id	int	vrpt_ShipToLocation
ShipToLocationName	Ship To Location Name	nvarchar
ShipToLocationState	Ship To Location State	nvarchar
ShipToLocationZip	Ship To Location Zip	nvarchar
ShipToTypeId	Ship To Type Id	int
ShowRequired	Show Required	bit
Signatures	Signatures	bit
SRQAuthorizationRequired	Material Request Authorization Required	bit
StartTime	Start Time	nvarchar
State	State	nvarchar
SuppressRightToKnowGraphics	Indicates if the record is set to suppress the right to know graphics	bit
SurveyNotifyEmail	Email to be notified for surveys	nvarchar
SurveyNotifyShop	Indicates if the record is set up to notify the shop for surveys	bit
SurveyNotifyTrade	Indicates if the record is set up to notify the trade for surveys	bit
TaskTradeID	Task Trade Id	int	vr_Trade
TechnicianFilter	Indicates if the record is using technician filter	bit
TicketTaskCode	Ticket Task Code	nvarchar
TicketTaskDescription	Ticket Task Description	nvarchar
TicketTaskId	Ticket Task Id	int	vrpt_Task
TimeBasedConversion	Time Based Conversion	bit
TimeTypeCode	Time Type Code	nvarchar
TimeTypeDescription	Time Type Description	nvarchar
TimeTypeId	Time Type Id	int	vr_TimeType
TimeZoneDisplay	Time Zone Display	nvarchar
TimeZoneId	Time Zone Id	int	bi_TimeZoneInfo
TQM	Customer Survey	smallint
TQMPM	Customer Survey on PMs	bit
TQMText	Custom Survey Text	nvarchar
Trigger	Trigger	int
TriggerByFinishDate	Trigger By Finish Date	bit
TriggerQuantity	Trigger Quantity	int
UpcomingPMRecipient	Upcoming PM Recipient	nvarchar
Value	Value	nvarchar
WarningRecipient	Warning Recipient	nvarchar
WOQueryCheckCost	Work Order Query Check Cost	bit
WOQueryId	Work Order Query Id	int	vt_userQueryHeader
WOQueryName	Work Order Query Name	nvarchar
WorkOrderCounter	Work Order Counter	bigint
WorkOrderPrefix	Work Order Prefix	nvarchar
WorkOrderPrint	Work Order Print	bit
WorkOrderSize	Work Order Size	int
WorkOrderTypeCode	Work Order Type Code	nvarchar
WorkOrderTypeDescription	Work Order Type Description	nvarchar
WorkOrderTypeDesignated	Work Order Type Designation	smallint
WorkOrderTypeId	Work Order Type Id	int	vr_WorkOrderType
WorkOrderTypeRequireGeneralComment	Work Order Type Require General Comment	bit
WOSurveyTitle	Work Order Survey Title	nvarchar
Zip	Zip Code	nvarchar

Articles in this section