vr_MaterialRequest

Updated November 26, 2025 17:15

Field Name	Field Description	Data Type	FK Join
AcceptedDate	Accepted Date	datetime
Acceptor	Acceptor	nvarchar
AccountCode	Account Code	nvarchar
AccountId	Account Id	int	vr_account
AccountName	Account Name	nvarchar
AuthorizationDate	Authorization Date	datetime
AuthorizationRequired	Authorization Required	bit
AuthorizationValue	Authorization Value	decimal
Authorized	Authorized	bit
AuthorizerId	User Id (Authorizer)	int	vr_users
AuthorizerName	Authorizer Name	nvarchar
Comment	Comments	nvarchar
Converted	Converted	int
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
Date	Order Date	datetime
DepartmentCode	Department Code	nvarchar
DepartmentId	Department Id	int	vr_Department
DepartmentName	Department Name	nvarchar
Email	Requestor Email	nvarchar
EstimatedTotal	Estimated Total	decimal
Exchdate	Exchange Date	datetime
FullStatus	Concatenated field (Status Description + Status Note)	nvarchar
Id	Material Request Id	int
MaterialRequestPortalUrl	Material Request Portal URL	nvarchar
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
Number	Material Request Number	nvarchar
OrderId	Sales Order Id	int	vr_SalesOrder
OrderNumber	Sales Order Number	nvarchar
PurchaseOrderTypeCode	Purchase Order Type Code	nvarchar
PurchaseOrderTypeDescription	Purchase Order Type Description	nvarchar
PurchaseOrderTypeId	Purchase Order Type Id	int	vr_PurchaseOrderType
ReferenceNumber	Reference Id	nvarchar
Rejected	Rejected	int
RejectedDate	Rejected Date	datetime
RejectedReason	Rejected Reason	nvarchar
Rejector	Rejector	nvarchar
RepairCenterCode	Repair Center Code	nvarchar
RepairCenterId	Repair Center Id	int	vr_RepairCenter
RepairCenterName	Repair Center Name	nvarchar
RequestorCode	Requestor Code	nvarchar
RequestorEmail	Requestor Email	nvarchar
RequestorId	Requestor Id	int	vr_Requestor
RequestorName	Requestor Name	nvarchar
RequestorPhone	Requestor Phone	nvarchar
RequiredDate	Required Date	datetime
SalesOrderTypeCode	Sales Order Type Code	nvarchar
SalesOrderTypeDescription	Sales Order Type Description	nvarchar
SalesOrderTypeId	Sales Order Type Id	int
ShipMethod	Ship Method	nvarchar
ShipToBuildingNumber	Ship To Building Number	nvarchar
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
Source	Source	nvarchar
Status	Status	nvarchar
StatusAllowNote	Indicates if this record allows a status note	bit
StatusDescription	Status Description	nvarchar
StatusId	Status Id	int	vr_Status
StatusNote	Status Note	nvarchar
UseSig	Indicates if this record uses a Signature	bit

Articles in this section