vrpt_Part

Updated January 05, 2026 17:40

Field Name	Field Description	Data Type	FK Join
creatorName	Part 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
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	Part CFC	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 Record is Deleted	bit
pa_description	Part Description	nvarchar
pa_eoq		float
pa_exch_date	Currency Exchange Date	datetime
pa_exch_fk	Currency Exchange Id	int
pa_excludeFromPurchase	Indicates if the Record is excluded from Purchase Orders	bit
pa_excludefromreordercalc	Indicates if the Record is excluded from Reorder Calculations	bit
pa_excludefromRequestor	Indicates if the Record is excluded from Requestors	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 Record is hazardous	bit
pa_keyNoun	Part Key Noun	nvarchar
pa_kit	Indicates if the Record belongs to a part kit	bit
pa_manufacturerNumber	Part Manufacturer Number	nvarchar
PA_markup	Part Markup	decimal
pa_mfg_fk	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	vrpt_ParentPart
pa_parentCode	Parent Part Code	nvarchar
pa_parentDescription	Parent Part Description	nvarchar
pa_parentTag_fk	Parent Part Id	int	vrpt_ParentPart
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 Percentage	decimal
pa_reorderPoint	Part Reorder Point	int
PA_reorderQuantity	Part Reorder Quantity	int
pa_sellingcost	Part Selling Cost	numeric
pa_serialized	Indicates if the Record is Serialized	bit
PA_shelfLife	Part Shelf Life	datetime
pa_SICCode	Part SIC Code	nvarchar
pa_specification	Part Specification	nvarchar
pa_Standardcost	Part Standard Cost	decimal
PA_supplyItem	Indicates if the Record is a suppliy item	bit
pa_taxPurchases	Indicates if the Record is taxable on purchases	bit
pa_taxSales	Indicates if the Record is taxable on sales	bit
pa_unitofMeasure	Part Unit of Measure	nvarchar
pa_weight	Part Weight	decimal
pa_weightUnit	Part Weight Unit	nvarchar
quantityAllocated	Quantity Allocation	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 Whether the Vendor record allows change of personal info	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 SIC 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