vr_WorkOrderCharge

Updated February 05, 2026 16:00

Field Name	Field Description	Data Type	FK Join
AccountCode	Account Code	nvarchar
AccountId	Account Id	int	vr_account
AccountName	Account Name	nvarchar
Automatic	Automatic	int
BatchJobId	Batch Job Id	int	vr_BatchJob
BatchNumber	Batch Number	int
ChargeComment	Comments	nvarchar
ChargePercentage	Charge Percentage	decimal
ChargeTypeCode	Charge Type Code	nvarchar
ChargeTypeDescription	Charge Type Description	nvarchar
ChargeTypeId	Charge Type Id	int	vr_chargeType
ChargeTypeMarkup	Charge Type Markup	decimal
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
CurrencyExchangeDate	Currency Exchange Date	datetime
CurrencyExchangeId	Currency Exchange Id	int
CurrencyId	Currency Id	int	vrpt_Currency
ExtendedCost	Extended Cost	decimal
ExtendedRetail	Extended Retail	decimal
FailedPM	Indicates if the PM Failed	bit
FreeTagNumber	Free Tag Number	nvarchar
Id	Workorder Charge Id	int
InventoryDate	Inventory Date	datetime
InvoiceNumber	Invoice Number	nvarchar
ItemDescription	Item Description	nvarchar
ItemId	Item Id	int
ItemTagNumber	Item Tag Number	nvarchar
ItemTypeId	Item Type Id	int
LeaseBatchJobId	Lease Batch Job Id	int
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
NoCharge	No Charge	bit
NotLocated	Not Located	bit
OriginalChargeId	Original Charge Id	int
PONumber	Purchase Order Number	nvarchar
PostDate	Post Date	datetime
Product	Product	nvarchar
Quantity	Quantity	decimal
ResolutionId	Resolution Id	int	vr_Resolution
SLPostDate	Sub Ledger Post Date	datetime
SupplierAddressFullInfo	Supplier Address Full Info	nvarchar
SupplierAddressId	Supplier Address Id	int	vr_VendorAddress
SupplierId	Supplier Id	int	vr_Vendor
SupplierName	Supplier Name	nvarchar
TaskCode	Task Code	nvarchar
TaskCompletionDate	Task Completion Date	datetime
TaskDescription	Task Description	nvarchar
TaskFinishDate	Task Finish Date	datetime
TaskId	Task Id	int	vrpt_Task
Taxable	Indicates if this Work Order Charge is taxable	bit
TaxAmount	Tax Amount	decimal
TransDate	Transaction Date	datetime
Unit	Unit	nvarchar
UnitCost	Unit Cost	decimal
WorkNotDone	Work Not Done	bit
WorkOrderId	Work Order Id	int	vr_WorkOrder
WorkOrderNumber	Work Order Number	nvarchar
WorkOrderTaskId	Work Order Task Id	int	vr_WorkOrderTask

Articles in this section