vrpt_AssetXRef

Updated February 03, 2026 16:44

Field Name	Field Description	Data Type	FK Join
creatorName	Creator Name	nvarchar
fp_code	Part Type Code	nvarchar
fp_description	Part Type Description	nvarchar
fp_pk	Part Type Id	int	vr_PartType
fps_code	Part Sub Type Code	nvarchar
fps_description	Part Sub Type Description	nvarchar
fps_pk	Part Sub Type Id	int	vr_PartSubType
Id	Part Id	int	vr_Part
inventoryValue	Inventory Value	decimal
lastAdjustment	Last Adjustment	decimal
lastPO_pk	Last Purchase Order Id	int	vr_PurchaseOrder
lastPO_ven_code	Last Purchase Order Vendor Code	nvarchar
lastPO_ven_name	Last Purchase Order Vendor Name	nvarchar
lastPODate	Last Purchase Order Date	datetime
lastPONumber	Last Purchase Order Number	nvarchar
lastPOVenFK	Last Purchase Order Vendor Id	int	vr_Vendor
lastUnitPrice	Last Unit Price	decimal
maximumLevel	Maximum Level	int
mfg_code	Manufacturer Code	nvarchar
mfg_name	Manufacturer Name	nvarchar
minimumLevel	Minimum Level	int
modifierName	Modifier Name	nvarchar
obsolete_ven_isBroker	Obsolete Column (No Longer Used)	bit
obsolete_ven_isTenant	Obsolete Column (No Longer Used)	bit
orderUnitQty	Order Unit Quantity	nvarchar
pa_active	Indicates if the Record is Active or Not	bit
pa_alternateCode	Part Alternate Code	nvarchar
PA_AverageCost	Part Average Cost	decimal
pa_cfc	Indicates if the part record is Chlorofluorocarbons (Refrigerants)	bit
pa_code	Part Code	nvarchar
pa_createdDate	Record Creation Date	datetime
pa_creator_fk	User Id (Record Creator)	int	vr_users
pa_curr_fk	Currency Id	int	vrpt_Currency
pa_dateIn	Part Date In	datetime
PA_deleted	Indicates if the part record has been deleted	bit
pa_description	Part Description	nvarchar
pa_eoq	Part Economic Order Quantity	float
pa_exch_date	Currency Exchange Date	datetime
pa_exch_fk	Currency Exchange Id	int
pa_excludeFromPurchase	Indicates if the part record is excluded from Purchase	bit
pa_excludefromreordercalc	Indicates if the Record is excluded from Reorder Calculations	bit
pa_excludefromRequestor	Indicates if the part record is excluded from Requestor	bit
pa_fb_fk	Building Id	int	vr_building
pa_fd_fk	Facility Id	int	vr_Facility
pa_fp_fk	Part Type Id	int	vr_PartType
pa_hazardous	Indicates if the part record is labelled as hazardous	bit
pa_keyNoun	Part Key Noun	nvarchar
pa_kit	Indicates if the part record is part of a kit	bit
pa_manufacturerNumber	Part Manufacturer Number	nvarchar
PA_markup	Part Markup	decimal
pa_mfg_fk	Part Manufacturer Id	int	vr_Vendor
pa_modelNumber	Part Model Number	nvarchar
pa_modifiedDate	Last Modified Date	datetime
pa_modifier_fk	User Id (Record Modifier)	int	vr_users
pa_orderUnit	Part Order Unit	nvarchar
pa_orderUnitQuantity	Part Order Unit Quantity	int
pa_parent_fk	Parent Part Id	int	vr_Part
pa_parentCode	Parent Part Code	nvarchar
pa_parentDescription	Parent Part Description	nvarchar
pa_parentTag_fk	Parent Part Tag Id	int
pa_pk	Part Id	int	vr_Part
pa_PriceUsed	Part Price Used	decimal
pa_purgeDate	Part Purge Date	datetime
pa_rc_fk	Repair Center Id	int	vr_RepairCenter
PA_recordNumber	Part Record Number	float
pa_reordepointpercent	Part Reorder Point Percent	decimal
pa_reorderPoint	Part Reorder Point	int
PA_reorderQuantity	Part Reorder Quantity	int
pa_sellingcost	Part Selling Cost	numeric
pa_serialized	Part Serailized	bit
PA_shelfLife	Part Shelf Life	datetime
pa_SICCode	Part Standard Industrail Classification Code	nvarchar
pa_specification	Part Specification	nvarchar
pa_Standardcost	Part Standard Cost	decimal
PA_supplyItem	Part Supply Item	bit
pa_taxPurchases	Part Purchases Tax	bit
pa_taxSales	Part Sales Tax	bit
pa_unitofMeasure	Part Unit Of Measure	nvarchar
pa_weight	Part Weight	decimal
pa_weightUnit	Part Weight Unit	nvarchar
pe_comment	Part Link Comment	nvarchar
PE_createdDate	Record Creation Date	datetime
PE_CREATOR_FK	User Id (Record Creator)	int	vr_Users
pe_curr_fk	Currency Id	int	vrpt_Currency
pe_exch_date	Currency Exchange Date	datetime
pe_exch_fk	Currency Exchange Id	int
pe_isActive	Indicates if the Record is Active or Not	bit
pe_item_fk	Item Id	int
pe_itemType_fk	Item Type Id	int
PE_lastDate	Part Link Last Date	datetime
PE_lastPrice	Part Link Last Price	decimal
PE_leadTime	Part Link Lead Time	decimal
PE_leadTimeOld	Part Link Lead Time Old	datetime
PE_modifiedDate	Last Modified Date	datetime
PE_MODIFIER_FK	User Id (Record Modifier)	int	vr_users
PE_PA_FK	Part Id	int	vr_Part
PE_PK	Part Link Id	int
PE_quantity	Part Link Quantity	decimal
PE_VenPartCode	Part Link Vendor Part Code	nvarchar
quantityAllocated	Quantity Allocated	int
quantityAvailable	Quantity Available	int
quantityOnHand	Quantity On Hand	int
quantityOnOrder	Quantity On Order	decimal
quantityOnOrderByOrderUnit	Quantity On Order By Order Unit	decimal
receivedMTD	Received Month to Date	int
receivedYTD	Recieved Year to Date	int
unitcostforPO	Unit Cost for Purchase Order	decimal
usedMTD	Used Month to Date	int
usedYTD	Used Year to Date	int
ven_active	Indicates Whether the Vendor is Active or Not	bit
ven_allowChangePersonalInfo	Indicates if the vendor record allows changes to personal information	bit
ven_alternateID	Vendor Alternate Id	nvarchar
ven_code	Vendor Code	nvarchar
ven_comment	Vendor Comments	nvarchar
ven_companySize	Company Size	int
ven_contact	Vendor Contact	nvarchar
ven_createdDate	Record Creation Date	datetime
ven_creator_fk	User Id (Record Creator)	int	vr_Users
ven_creditLimit	Credit Limit	decimal
ven_cst_fk	Account Id	int	vr_account
ven_curr_fk	Currency Id	int	vrpt_Currency
ven_customerNumber	Customer Number	nvarchar
ven_discountDay	Discount Day	int
ven_discountPercentage	Discount Percentage	decimal
ven_ECRICode	Vendor ECRI Code	int
ven_email	Vendor Email	nvarchar
ven_exch_date	Currency Exchange Date	datetime
ven_exch_fk	Currency Exchange Id	int
ven_hourlyRate	Hourly Rate	decimal
ven_insuranceAmount	Insurance Amount	decimal
ven_insuranceExpiration	Insurance Expiration	datetime
ven_isConsultant	Is Consultant	bit
ven_isContractor	Is Contractor	bit
ven_isManufacturer	Is Manufacturer	bit
ven_isVendor	Is Vendor	bit
ven_lastPO_fk	Last Purchase Order Id	int	vr_PurchaseOrder
ven_modifiedDate	Last Modified Date	datetime
ven_modifier_fk	User Id (Record Modifier)	int	vr_users
ven_name	Vendor Name	nvarchar
ven_organizationUnit	Vendor Organization Unit	nvarchar
ven_OTPTaxable	Indicates if this Vendor's one time purchases are taxable	bit
ven_pcardblock	Indicates if this Vendor's blocked from purchase card transactions	bit
ven_pk	Vendor Id	int	vr_Vendor
ven_rating	Vendor Rating	nvarchar
ven_siccode	Vendor Standard Industrial Classification Code	nvarchar
ven_taxCode	Vendor Tax Code	nvarchar
ven_taxID	Vendor Tax Id	nvarchar
ven_term	Vendor Term	nvarchar
ven_url	Vendor Website URL	nvarchar
ven_vc_fk	Vendor Type Id	int	vr_VendorType
ven_vcs_fk	Vendor SubType Id	int

Articles in this section