vrpt_WorkOrderPartList

Updated January 27, 2026 16:17

Field Name	Field Description	Data Type	FK Join
BaseTransactionId	Base Transaction Id	int
BaseTransactionNumber	Base Transaction Number	nvarchar
cst_code	Account Code	nvarchar
cst_name	Account Name	nvarchar
f_archivepmov_fk	Archive On Hand Adjument Id	int
f_bj_fk	Batch Job Id	int	vr_BatchJob
f_comment	Work Order Part Comment	nvarchar
f_createdDate	Record Creation Date	datetime
f_creator_fk	User Id (Record Creator)	int	vr_Users
f_cst_fk	Account Id	int	vr_account
f_curr_fk	Currency Id	int	vrpt_Currency
f_exch_date	Currency Exchange Date	datetime
f_exch_fk	Currency Exchange Id	int
f_inv_fk	Part Inventory Id	int	vrpt_PartInventoryList
f_lease_bj_fk	Lease Batch Job Id	int	vr_BatchJob
f_modifiedDate	Last Modified Date	datetime
f_modifier_fk	User Id (Record Modifier)	int	vr_users
f_noCharge	Indicates if the Work Order Part Charge Line is Marked as No Charge	bit
f_pk	Work Order Part Id	int
f_pmov_fk	On Hand Adjustment Id	int	vr_OnHandAdjustment
f_postDate	Post Date	datetime
f_quantity	Quantity	decimal
f_ser_fk	Serialized Part Id	int
f_SLPostDate	Sub Ledger Post Date	datetime
f_taxable	Indicates if this Work Order Part is taxable	bit
f_taxamount	Tax Amount	decimal
f_totalcost	Total Cost	decimal
f_totalRetail	Total Retail Cost	decimal
f_transDate	Transaction Date	datetime
f_unitCost	Unit Cost	decimal
f_wholesalecost	Wholesale Cost	decimal
f_woTask_fk	Work Order Task Id	int	vr_WorkOrderTask
f_wotypepercentage	Work Order Type Percentage	decimal
fo_code	Task Code	nvarchar
fo_description	Task Description	nvarchar
fromApp	Static Value (1)	bit
Id	Work Order Part Id	int
inv_minimumLevel	Minimum Level	int
inv_pa_fk	Part Id	int	vr_Part
inv_quantityonhand	Quantity On Hand	int
inv_record_code	Part Code + Warehouse Code	nvarchar
inv_wh_fk	Warehouse Id	int	vr_warehouse
LinkCode	Task Code	nvarchar
LinkDescription	Link Description	nvarchar
LinkTransactionId	Work Order Task Id	int	vr_WorkOrderTask
LinkTransactionTypeId	Static Value (24)	int
mfg_code	Manufacturer Code	nvarchar
mfg_name	Manufacturer Name	nvarchar
pa_code	Part Code	nvarchar
pa_description	Part Description	nvarchar
pa_manufacturerNumber	Part Manufacturer Number	nvarchar
pa_unitofMeasure	Part Unit of Measure	nvarchar
pci_pk	Purchase Card Transaction Detail Id	int
ser_serialNumber	Serialized Serial Number	nvarchar
serialized	Indicates if the Part is Serialized or Not	int
wk_id	Technician Record Id	nvarchar
wk_Name	Technician Name	nvarchar
wk_pk	Technicain Id	int	vrpt_Technician
wo_completionDate	Completion (Closed) Date	datetime
wo_cst_fk	Account Id	int	vr_account
wo_finishDate	Finish Date	datetime
wo_number	Work Order Number	nvarchar
wo_pk	Work Order Id	int	vr_WorkOrder
wo_rc_fk	Repair Center Id	int	vr_RepairCenter
woTask_completionDate	Completion Date (Closed Date)	datetime
woTask_finishDate	Finish Date	datetime
woTask_rts_fk	Rate Schedule Id	int	vr_rateSchedule

Articles in this section