vr_Contract

Updated November 21, 2025 15:07

DepartmentId	Department Id	int	vr_Department
DepartmentName	Department Name	nvarchar
DiscountDay	Discount Day	int
DiscountPercentage	Discount Percentage	decimal
EndDate	Contract End Date	datetime
Estimate	Estimate	decimal
ExtendedThrough	Contract Extended Through	datetime
FixedRate	Indicates if the Contract is a Fixed Rate or Not	bit
HasDeactivatedOldContract	Indicates if the Contract Has a Deactivated Old Contract or Not	bit
HourlyRate	Hourly Rate	decimal
Id	Contract Id	int
IsBid	Indicates if the Contract is a Bid or Not	bit
IsProcessed	Indicates if the Contract is Processed or Not	bit
IsProcessedByTool	Indicates if the Contract is Processed by a Tool or Not	bit
IsRepairCenterContractByDepartment	Indicates if the Contract is a Repair Center Contract by Department or Not	bit
IsRetainedByDollar	Indicates if the Contract is Retained by Dollar	bit
IsTrackWithNoCost	Indicates if the Contract is Track With No Cost or Not	bit
LastWoId	Last Work Order Id	int	vr_Workorder
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
Number	Contract Number	nvarchar
OfferNumber	Offer Number	nvarchar
Projected	Indicates if the Contract is Projected or Not	bit
RepairCenterCode	Repair Center Code	nvarchar
RepairCenterId	Repair Center Id	int	vr_RepairCenter
RepairCenterName	Repair Center Name	nvarchar
RequestDate	Contract Request Date	datetime
RetainAmount	Retain Amount	decimal
RetainPercentage	Retain Percentage	decimal
StartDate	Contract Start Date	datetime
Status	Contract Status	nvarchar
Terms	Contract Term	int
TotalValue	Total Value	decimal
Type	Contract Type	int
VendorCode	Vendor Code	nvarchar
VendorContact	Vendor Contact	nvarchar
VendorId	Vendor Id	int	vr_Vendor
VendorInsuranceAmount	Insurance Amount	decimal
VendorInsuranceExpiration	Insurance Expiration	datetime
VendorName	Vendor Name	nvarchar
VendorRating	Vendor Rating	nvarchar

Articles in this section