vr_SalesLine

Updated February 04, 2026 17:17

Field Name	Field Description	Data Type	FK Join
AccountCode	Account Code	nvarchar
AccountId	Account Id	int	vr_account
AccountName	Account Name	nvarchar
BackOrder	Back Order	decimal
BatchJobId	Batch Job Id	int	vr_BatchJob
Comment	Comments	nvarchar
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
ExtendedCost	Extended Cost	decimal
ExtendedCostTax1	Extended Cost Tax 1	decimal
ExtendedCostTax2	Extended Cost Tax 2	decimal
ExtendedRetail	Extended Retail	decimal
ExtendedRetailTax1	Extended Retail Tax 1	decimal
ExtendedRetailTax2	Extended Retail Tax 2	decimal
Id	Sales Line Id	int
InventoryBinLabel	Inventory Bin Label	nvarchar
InventoryId	Inventory Id	int	vr_PartInventory
InventorySKUCode	Inventory SKU Code	nvarchar
LineCode	Line Code	nvarchar
LineDescription	Line Description	nvarchar
LineNumber	Line Number	int
ManufacturerCode	Manufacturer Code	nvarchar
ManufacturerName	Manufacturer Name	nvarchar
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
OTS	One Time Sales	bit
OTSCode	One Time Sales Code	nvarchar
OTSDescription	One Time Sales Description	nvarchar
PartCode	Part Code	nvarchar
PartDescription	Part Description	nvarchar
PartId	Part Id	int	vr_Part
PartManufacturerNumber	Part Manufacturer Number	nvarchar
PartSerialized	Indicates if the part record is serialized	bit
PartUnitDesc	Part Unit Description	nvarchar
PCardTransactionDetailId	Purchase Card Transaction Detail Id	int
PostDate	Post Date	datetime
Quantity	Quantity	decimal
Receivable2AccountId	Account Receivable 2 Id	int	vr_account
ReceivableAccountId	Account Receivable Id	int	vr_account
ReturnFromSaleLineId	Return From Sales Line Id	int
SalesLineTypeCode	Sales Line Type Code	nvarchar
SalesLineTypeDescription	Sales Line Type Description	nvarchar
SalesLineTypeId	Sales Line Type Id	int	vr_SalesLineType
SalesLineTypeMarkup	Sales Line Type Markup	decimal
SalesOrderDate	Sales Order Date	datetime
SalesOrderId	Sales Order Id	int	vr_SalesOrder
SalesOrderNumber	Sales Order Number	nvarchar
SerializedPartId	Serialized Part Id	int
SerializedPartNumber	Serialized Part Number	nvarchar
SLPostDate	Sub Ledger Post Date	datetime
Taxable	Indicates if this Sales Line is taxable	bit
TaxCompound	Indicates if the record utilizes tax compound	bit
TaxRate	Tax Rate	decimal
TaxRate2	Tax Rate 2	decimal
TaxRateId	Tax Rate Id	int	vr_TaxRate
TaxRateName	Tax Rate Name	nvarchar
UnitCost	Unit Cost	decimal
UnitOfMeasureCode	Unit Of Measure Code	nvarchar
UnitOfMeasureDescription	Unit Of Measure Description	nvarchar
UnitOfMeasureId	Unit of Measure Id	int	vr_UnitMeasure
WarehouseCode	Warehouse Code	nvarchar
WarehouseId	Warehouse Id	int	vr_warehouse
WarehouseName	Warehouse Name	nvarchar
WholeSaleCost	Wholesale Cost	decimal

Articles in this section