vrpt_SalesOrder

Updated January 19, 2026 17:20

Field Name	Field Description	Data Type	FK Join
AccountId	Account Id	int	vr_account
AccountProgramId	Account Program Id	int
Charge	Indicates Whether the Sales Order is Chargeable	bit
Comment	Comments	nvarchar
Contact	Contact	nvarchar
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
Date	Date	datetime
DepartmentId	Department Id	int	vr_Department
DiscountDate	Discount Date	datetime
DiscountRate	Discount Rate	decimal
DueDate	Due Date	datetime
Email	Email	nvarchar
FreightAmount	Freight Amount	decimal
FullStatus	Concatenated field (Status Description + Status Note)	nvarchar
Id	Sales Order Id	int
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
Number	Sales Order Number	nvarchar
OnHandAdjustmentId	On Hand Adjustment Id	int	vr_OnHandAdjustment
PaidAmount	Paid Amount	decimal
PurchaseOrderTypeId	Purchase Order Type Id	int	vr_PurchaseOrderType
Quote	Indicates if the record is from a quote	bit
RateScheduleId	Rate Schedule Id	int	vr_rateSchedule
ReferenceNumber	Reference Number	nvarchar
RepairCenterId	Repair Center Id	int	vr_RepairCenter
RequestorId	Requestor Id	int	vr_Requestor
RequestorName	Requestor Name	nvarchar
RequestorPhone	Requestor Phone	nvarchar
SaleChargeAmount	Sale Charge Amount	decimal
SaleChargeSubTotal	Sale Charge Sub Total	decimal
SalesOrderTypeId	Sales Order Type Id	int
SalesPersonId	Sales Person Id	int	vrpt_Technician
SalesRequestId	Sales Request Id	int
ShipDate	Ship Date	datetime
ShipInstruction	Ship Insruction	nvarchar
Shipped	Indicates if the record is shipped	bit
ShipToDeliveryNote	Ship To Delivery Note	nvarchar
ShipToLocationId	Ship To Location Id	int	vrpt_ShipToLocation
ShipToTypeId	Ship To Type Id	int
StatusDescription	Status Description	nvarchar
StatusId	Status Id	int	vr_Status
StatusNote	Status Note	nvarchar
TaxAmount	Tax Amount	decimal
TaxAmount1	Tax Amount 1	numeric
TaxAmount2	Tax Amount 2	decimal
TaxCompound	Indicates if the record utilizes tax compound	bit
TaxRate	Tax Rate	decimal
TaxRate2	Tax Rate 2	decimal
TaxRatesId	Tax Rate Id	int	vr_TaxRate
Terms	Terms	decimal
TotalAmount	Total Amount	decimal

Articles in this section