vr_ReturnAndRepair

Updated November 27, 2025 14:47

Field Name	Field Description	Data Type	FK Join
Attention	Attention	nvarchar
Comment	Comments	nvarchar
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
DocumentDate	Document Date	datetime
DueDate	Due Date	datetime
FullStatus	Concatenated field (Status Description + Status Note)	nvarchar
Id	Return and Repair Id	int
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
Number	Return and Repair Number	nvarchar
Phone	Phone	nvarchar
Reason	Reason	nvarchar
RepairCenterCode	Repair Center Code	nvarchar
RepairCenterId	Repair Center Id	int	vr_RepairCenter
RepairCenterName	Repair Center Name	nvarchar
RequestorEmail	Requestor Email	nvarchar
RequestorFax	Requestor Fax	nvarchar
RequestorId	Requestor Id	int	vr_Requestor
RequestorName	Requestor Name	nvarchar
RequestorPhone	Requestor Phone	nvarchar
ReturnTypeCode	Return Type Code	nvarchar
ReturnTypeDescription	Return Type Description	nvarchar
ReturnTypeId	Return Type Id	int	vr_ReturnType
RMANumber	Return Merchandise Authorization (RMA) Number	nvarchar
ShipDate	Ship Date	datetime
Shipped	Indicates if this record has shipped	bit
ShippingInstructions	Shipping Instructions	nvarchar
ShipTo	Ship To	nvarchar
ShipVia	Ship Via	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
TrackNumber	Track Number	nvarchar
VendorAddressAddress1	Vendor Address Line 1	nvarchar
VendorAddressAddress2	Vendor Address Line 2	nvarchar
VendorAddressCategory	Vendor Address Category	nvarchar
VendorAddressCity	Vendor City	nvarchar
VendorAddressContact	Vendor Contact	nvarchar
VendorAddressEmail	Vendor Email	nvarchar
VendorAddressFax	Vendor Fax #	nvarchar
VendorAddressId	Vendor Address Id	int	vr_VendorAddress
VendorAddressPhone	Vendor Phone #	nvarchar
VendorAddressPhoneExtension	Vendor Phone # Extension	nvarchar
VendorAddressState	Vendor State	nvarchar
VendorAddressZipCode	Vendor Zip Code	nvarchar
VendorCode	Vendor Code	nvarchar
VendorCustomerNumber	Vendor Customer Number	nvarchar
VendorId	Vendor Id	int	vr_Vendor
VendorName	Vendor Name	nvarchar
WorkOrderId	Work Order Id	int	vr_WorkOrder
WorkOrderNumber	Work Order Number	nvarchar

Articles in this section