vrpt_WorkOrderChargeDetail

Updated January 27, 2026 15:12

Field Name	Field Description	Data Type	FK Join
chargeLineTagDescription	Charge Line Tag Description	nvarchar
chargeLineTagNumber	Charge Line Tag Number	nvarchar
cht_code	Charge Type Code	nvarchar
cht_description	Charge Type Description	nvarchar
cst_code	Account Code	nvarchar
cst_name	Account Name	nvarchar
ex_comment	Comment	nvarchar
ex_company	Company	nvarchar
ex_createdDate	Record Creation Date	datetime
ex_extRetail	Extended Retail	decimal
ex_inventoryAmount	Inventory Amount	decimal
ex_inventoryDate	Inventory Date	datetime
ex_inventoryNumber	Inventory Number	nvarchar
ex_itemType_fk	Item Type Id	int
ex_noCharge	Indicated if this record is chargeable	bit
ex_pk	Work Order Charge Id	int
ex_poNumber	Purchase Order Number	nvarchar
ex_postDate	Post Date	datetime
ex_product	Product	nvarchar
ex_quantity	Quantity	decimal
ex_SLPostDate	Sub Ledger Post Date	datetime
ex_tagNumber	Tag Number	nvarchar
ex_transDate	Transaction Date	datetime
ex_unit	Unit	nvarchar
ex_unitCost	Unit Cost	decimal
fo_code	Task Code	nvarchar
fo_description	Task Description	nvarchar
Id	Work Order Charge Id	int	vr_workorderCharge
wo_pk	Work Order Id	int	vr_WorkOrder
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_workNotDone	Work Not Done	bit