V_WorkOrderPartList

Updated November 13, 2025 17:51

Field Name	Field Description	Data Type	FK Join
creatorname	Creator Name	nvarchar
cst_code	Account Code	nvarchar
cst_name	Account Name	nvarchar
f_bj_fk	Batch Job Id	int	vr_BatchJob
f_clnt_fk	Obsolete Column (No Longer Used)	int
f_comment	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 Line is No Charge (Non Chargeable) or Not	bit
f_pk	Work Order Part Line 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 Serial 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	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	From App	bit
inv_minimumLevel	Minimum Level	int
inv_pa_fk	Part Id	int	vr_Part
inv_quantityonhand	Quantity On Hand	int
inv_record_code	Inventory Record Code	nvarchar
inv_wh_fk	Warehouse Id	int	vr_warehouse
ItemTypeId	Item Type Id	int
mfg_code	Manufacturer Code	nvarchar
mfg_name	Manufacturer Name	nvarchar
pa_description	Part Description	nvarchar
pa_manufacturerNumber	Part Manufacturer Number	nvarchar
pci_pk	P Card Transaction Detail Line Id	int
pmov_number	On Hand Adjustment Number	int
ser_serialNumber	Serialized Part Serial Number	nvarchar
serialized	Indicates Whether the Part is Serialized or Not	int
tagDescription	Tag Description	nvarchar
tagNumber	Tag Number	nvarchar
wk_id	Technician Record Id	nvarchar
wk_Name	Technician Name	nvarchar
wk_pk	Technicain Id	int	vrpt_Technician
wo_actionRequested	Action Requested	nvarchar
wo_charge	Indicates Whether the Work Order is Chargeable or Not	bit
wo_completionDate	Completion (Closed) 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
wo_ReferenceNumber	Reference Number	nvarchar
wo_requestDate	Request Date	datetime
wo_requestor	Requestor	nvarchar
woTask_completionDate	Completion Date (Closed Date)	datetime
woTask_failedPM	Indicates if the PM Failed	bit
woTask_finishDate	Finish Date	datetime
woTask_notLocated	Not Located	bit
woTask_rts_fk	Rate Schedule Id	int	vr_rateSchedule
woTask_ss_fk	Status Id	int	vr_Status
woTask_status	Task Status	varchar
woTask_workNotDone	Work Not Done	bit

Articles in this section