vrpt_PPEItemsIssued

Updated January 12, 2026 17:39

Field Name	Field Description	Data Type	FK Join
AvailQTY	Available Quantity	int
Id	Personal Protective Equipment Id	int
inv_record_code	Part Inventory Record Code	nvarchar
issuer_id	Issuer Record Id	nvarchar
issuer_name	Issuer Name	nvarchar
itemCode	Item Code	nvarchar
itemDesc	Item Description	nvarchar
itemType_fk	Item Type Id	int
lastReturner_id	Last Returner Record Id	nvarchar
lastReturner_name	Last Returner Name	nvarchar
mfg_code	Manufacturer Code	nvarchar
mfg_name	Manufacturer Name	nvarchar
pa_pk	Part Id	int	vr_Part
ppe_comment	Comment	nvarchar
ppe_createdDate	Record Creation Date	datetime
ppe_creator_fk	User Id (Record Creator)	int	vr_users
ppe_inv_fk	Part Inventory Id	int	vrpt_PartInventoryList
ppe_issueDate	Issue Date	datetime
ppe_issuer_fk	Issuer Id	int	vrpt_Technician
ppe_lastreturner_fk	Last Returner Id	int	vrpt_Technician
ppe_modifiedDate	Last Modified Date	datetime
ppe_modifier_fk	User Id (Record Modifier)	int	vr_users
ppe_pk	Personal Protective Equipment Id	int
ppe_ppei_fk	Personal Protective Equipment Issued Id	int
ppe_quantity	Quantity	decimal
ppe_returnQty	Return Quantity	int
ppe_ser_fk	Serialized Id	int
ppe_size	Size	nvarchar
ppe_ticketNumber	Ticket Number	int
ppe_wk_active	Indicates Whether the Technician Record is Active or Not	bit
ppe_wk_fk	Technician Id	int	vrpt_Technician
ppe_wk_id	Technician Record Id	nvarchar
ppe_wk_name	Technician Name	nvarchar
ppei_code	Personal Protective Equipment Issued Code	nvarchar
ppei_cost	Personal Protective Equipment Issued Cost	decimal
ppei_description	Personal Protective Equipment Issued Description	nvarchar
ppei_pk	Personal Protective Equipment Issued Id	int
ser_serialNumber	Serial Number	nvarchar
wh_pk	Warehouse Id	int	vr_warehouse
wk_id	Technician Record Id	nvarchar

Articles in this section