vrpt_WorkOrderChargeList

Updated January 27, 2026 15:14

Field Name	Field Description	Data Type	FK Join
BaseTransactionId	Base Transaction Id	int
BaseTransactionNumber	Base Transaction Number	nvarchar
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_batchID	Charge Batch Id	int
ex_bj_fk	Batch Job Id	int	vr_BatchJob
ex_cht_fk	Charge Type Id	int	vr_chargeType
ex_comment	Charge Comment	nvarchar
ex_company	Charge Company	nvarchar
ex_createdDate	Record Creation Date	datetime
ex_creator_fk	User Id (Record Creator)	int	vr_users
ex_cst_fk	Account Id	int	vr_account
ex_curr_fk	Currency Id	int	vrpt_Currency
ex_exch_date	Currency Exchange Date	datetime
ex_exch_fk	Currency Exchange Id	int
ex_extRetail	Extended Retail	decimal
ex_inventoryAmount	Inventory Amount	decimal
ex_inventoryDate	Inventory Date	datetime
ex_inventoryNumber	Inventory Number	nvarchar
ex_item_fk	Item Id	int
ex_itemtype_fk	Item Type Id	int
ex_lease_bj_fk	Lease Batch Job Id	int	vr_BatchJob
ex_modifiedDate	Last Modified Date	datetime
ex_modifier_fk	User Id (Record Modifier)	int	vr_users
ex_noCharge	Indicated if this record is chargeable	bit
ex_originalex_fk	Original Charge Id	int
ex_pk	Work Order Charge Id	int	vr_workorderCharge
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_taxable	Indicates if this Work Order Charge is taxable	bit
ex_taxamount	Tax Amount	decimal
ex_transDate	Transaction Date	datetime
ex_unit	Unit	nvarchar
ex_unitCost	Unit Cost	decimal
ex_woTask_fk	Work Order Task Id	int	vr_WorkOrderTask
ex_wotypepercentage	Work Order Type Percentage	decimal
fo_code	Task Code	nvarchar
fo_description	Task Description	nvarchar
fromApp	Indicates if this record is from the application	bit
Id	Work Order Charge Id	int	vr_workorderCharge
LinkCode	Link Code	nvarchar
LinkDescription	Link Description	nvarchar
LinkTransactionId	Link Transaction Id	int
LinkTransactionTypeId	Link Transaction Type Id	int
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
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