vr_PurchaseOrderItems

Updated March 24, 2026 15:11

Field Name	Field Description	Data Type	FK Join
Id	Purchase Order Items Id	int
PurchaseOrderId	Purchase Order Id	int	vr_PurchaseOrder
LineNumber	Line Number	smallint
Quantity	Quantity	decimal
PrevReceived	Previously Received	decimal
PrevReturned	Previously Returned	decimal
UnitCost	Unit Cost	decimal
Taxable	Indicates if the record is taxable	bit
Comment	Comment	nvarchar
OTPCode	One Time Purchase Code	nvarchar
OTPDescription	One Time Purchase Description	nvarchar
ReferenceNumber	Reference Number	nvarchar
Cancelled	Indicates if the record is cancelled	bit
ForeignLineNumber	Foreign Line Number	int
ForeignDistribNumber	Foreign Distribution Number	int
ExtraData	Extra Data	nvarchar
BatchId	Batch Id	int
CreatedDate	Record Creation Date	datetime
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
CreatorId	User Id (Record Creator)	int	vr_users
Remaining	Remaining	decimal
ItemId	Item Id	int
ItemCode	Item Code	nvarchar
ItemDescription	Item Description	nvarchar
OTPTypeId	One Time Purchase Type Id	int
OTPTypeCode	One Time Purchase Type Code	nvarchar
OTPTypeDescription	One Time Purchase Type Description	nvarchar
BudgetCodeId	Budget Code Id	int
BudgetCodeCode	Budget Code	nvarchar
BudgetCodeDescription	Budget Code Description	nvarchar
AccountId	Account Id	int	vr_account
AccountCode	Account Code	nvarchar
PartId	Part Id	int	vr_Part
PartCode	Part Code	nvarchar
PartDescription	Part Description	nvarchar
PartOrderUnitQuantity	Part Order Unit Quantity	int
PartOrderUnitMeasureId	Part Order Unit of Measure Id	int	vr_UnitMeasure
PartOrderUnit	Part Order Unit	nvarchar
PartManufacturerNumber	Part Manufacturer Number	nvarchar
PartSerialized	Part Serialized	bit
PartAlternateCode	Part Alternate Code	nvarchar
PartUnitMeasure	Part Unit of Measure	nvarchar
PartSellingCost	Part Selling Cost	numeric
UnitMeasureId	Unit of Measure Id	int	vr_UnitMeasure
UnitMeasureCode	Unit of Measure Code	nvarchar
PartManufacturerCode	Part Manufacturer Code	nvarchar
PartManufacturerName	Part Manufacturer Name	nvarchar
RepairCenterId	Repair Center Id	int	vr_RepairCenter
RepairCenterCode	Repair Center Code	nvarchar
RepairCenterName	Repair Center Name	nvarchar
WarehouseId	Warehouse Id	int	vr_warehouse
WarehouseCode	Warehouse Code	nvarchar
WarehouseName	Warehouse Name	nvarchar
OrderUnitAndQuantity	Order Unit And Quantity	nvarchar
ISOTP	Indicates if the record is one time purchase	varchar
BackOrder	Back Order	decimal
Balance	Balance	decimal
DetailId	Detail Id	int
DetailCode	Detail Code	nvarchar
DetailDescription	Detail Description	nvarchar
FullDetail	Full Detail	nvarchar
QuantityWithUnitOrder	Quantity With Unit Order	nvarchar
ExtendedCost	Extended Cost	decimal
TaxableString	Taxable String	varchar
ItemTypeCategory	Item Type Category	int
ItemCategoryTypeId	Item Category Type Id	int
SelectedCategory	Selected Category	varchar
ItemTypeName	Item Type Name	nvarchar
ItemTypeId	Item Type Id	int	vr_WebTMAItemTypes
ItemTypeCode	Item Type Code	nvarchar
ItemTypeDescription	Item Type Description	nvarchar
LocationTypeId	Location Type Id	int
LocationId	Location Id	int
LocationCode	Location Code	nvarchar
LocationName	Location Name	nvarchar
OnOrder	On Order	decimal
TaxAmount	Tax Amount	decimal
CurrencyId	Currency Id	int	vrpt_Currency
CurrencyExchangeId	Currency Exchange Id	int
CurrencyExchangeDate	Currency Exchange Date	datetime
LineNumberDescription	Line Number Description	nvarchar

Articles in this section