vr_SalesOrder

Updated February 04, 2026 17:19

Field Name	Field Description	Data Type	FK Join
AccountCode	Account Code	nvarchar
AccountId	Account Id	int	vr_account
AccountName	Account Name	nvarchar
AccountProgramId	Account Program Id	int
Charge	Indicates Whether the Sales Order is Chargeable	bit
ChargeTax1	Charge Tax 1	decimal
ChargeTax2	Charge Tax 2	decimal
ChargeTaxAmount	Charge Tax Amount	decimal
ChargeTotalAmount	Charge Total Amount	decimal
Comment	Comments	nvarchar
Contact	Contact	nvarchar
CostTax1	Tax Rate 1	decimal
CostTax2	Tax Rate 2	decimal
CostTaxAmount	Tax Amount	decimal
CostTotalAmount	Total Amount	decimal
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	Date	datetime
DepartmentCode	Department Code	nvarchar
DepartmentId	Department Id	int	vr_Department
DepartmentName	Department Name	nvarchar
DiscountDate	Discount Date	datetime
DiscountRate	Discount Rate	decimal
DueDate	Due Date	datetime
ExtendedCost	Extended Cost	decimal
ExtendedRetail	Extended Retail	decimal
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
PurchaseOrderTypeCode	Purchase Order Type Code	nvarchar
PurchaseOrderTypeDescription	Purchase Order Type Description	nvarchar
PurchaseOrderTypeId	Purchase Order Type Id	int	vr_PurchaseOrderType
Quote	Indicates if the record is a quote	bit
RateScheduleCode	Rate Schedule Code	nvarchar
RateScheduleDescription	Rate Schedule Description	nvarchar
RateScheduleId	Rate Schedule Id	int	vr_rateSchedule
RateSchedulePartPercentage	Rate Schedule Part Percentage	decimal
ReferenceNumber	Reference Number	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
SalesOrderTypeCode	Sales Order Type Code	nvarchar
SalesOrderTypeDescription	Sales Order Type Description	nvarchar
SalesOrderTypeId	Sales Order Type Id	int
SalesPersonCode	Sales Person Code	nvarchar
SalesPersonId	Sales Person Id	int	vrpt_Technician
SalesPersonName	Sales Person Name	nvarchar
SalesRequestId	Sales Request Id	int
SalesRequestNumber	Sales Request Number	nvarchar
ShipDate	Ship Date	datetime
ShipInstruction	Ship Instruction	nvarchar
Shipped	Indicates if the record is shipped	bit
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
SLPostDate	Sub Ledger Post Date	datetime
StatusAllowNote	Indicates if this record allows a status note	bit
StatusDescription	Status Description	nvarchar
StatusId	Status Id	int	vr_Status
StatusNote	Status Note	nvarchar
TaxCompound	Indicates if the record utilizes tax compound	bit
TaxRate	Tax Rate	decimal
TaxRate2	Tax Rate 2	decimal
TaxRatesCompound	Indicates if the record utilizes Tax Rates Compound	bit
TaxRatesId	Tax Rates Id	int	vr_TaxRate
TaxRatesName	Tax Rates Name	nvarchar
TaxRatesPassThruRate	Tax Rates Pass Thru Rate	decimal
TaxRatesPCard	Indicates if the purchase card record utilizes tax rates	bit
TaxRatesRate1	Tax Rate 1	decimal
TaxRatesRate2	Tax Rate 2	decimal
TaxRatesSalesOrder	Indicates if the sales order record utilizes tax rates	bit
TaxRatesTax1Description	Tax Rate 1 Description	nvarchar
TaxRatesTax2Description	Tax Rate 2 Description	nvarchar
TechnicianCode	Technician Code	nvarchar
TechnicianId	Technician Id	int	vrpt_Technician
TechnicianName	Technician Name	nvarchar
Terms	Terms	decimal

Articles in this section