vr_Invoice

Updated November 25, 2025 16:17

Field Name	Field Description	Data Type	FK Join
AR	Indicates if the Invoice is an Accounts Receivable Invoice	bit
ArchiveExpenseTicketId	Archive Expense Ticket	int
ArchiveGasTicketId	Archive Gas Ticket	int
ArchiveLeaseId	Archive Lease Id	int
ArchiveProjectRequisitionId	Archive Project Requisition Id	int
ArchivePurchaseOrderId	Archive Purchase Order Id	int
ArchiveRentalId	Archive Rental Id	int
ArchiveSalesOrderId	Archive Sales Order Id	int
ArchiveUtilityTicketId	Archive Utility Ticket Id	int
ArchiveWorkOrderId	Archive Work Order Id	int
Comment	Comments	nvarchar
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
Date	Invoice Date	datetime
DepartmentId	Department Id	int	vr_Department
DiscountPercent	Discount Percentage	decimal
DiscountTaken	Discount Taken Amount	decimal
DueDate	Due Date	datetime
ExpenseTicketId	Expense Ticket Id	int	vr_ExpenseTicket
Freight	Freight	decimal
FullStatus	Concatenated field (Status Description + Status Note)	nvarchar
GasTicketId	Gas Ticket Id	int	vr_FuelAndOil
Id	Invoice Id	int
InvoiceTaxCompound	Indicates if the record utilizes tax compound	bit
InvoiceTaxPassThruRate	Invoice Tax Pass Through Rate	decimal
InvoiceTaxRate	Invoice Tax Rate	decimal
InvoiceTaxRate2	Invoice Tax Rate 2	decimal
ItemTypeId	Item Type Id	int	vr_WebTMAItemTypes
LeaseId	Lease Id	int	vrpt_Lease
Matched	Indicates if the Invoice has been Matched or Not	bit
MatchedDate	Matched Date	datetime
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
Number	Invoice Number	nvarchar
Override	Indicates if the record has an override	bit
Processed	Indicates if the Invoice has been Processed or Not	bit
ProjectRequisitionId	Project Requistion Id	int	vrpt_ProjectRequisition
PurchaseOrderId	Purchase Order Id	int	vrpt_PurchaseOrder
PurchaseOrderInvoicing	Indicates if the record has purchase order invoicing	bit
ReferenceNumber	Reference Number	nvarchar
RentalId	Rental Id	int
RepairCenterCode	Repair Center Code	nvarchar
RepairCenterId	Repair Center Id	int	vr_RepairCenter
RepairCenterName	Repair Center Name	nvarchar
SalesOrderId	Sales Order Id	int	vr_SalesOrder
StatusAllowNote	Indicates if this record allows a status note	bit
StatusDescription	Status Description	nvarchar
StatusId	Status Id	int	vr_Status
StatusNote	Status Note	nvarchar
SubTotal	Sub Total	decimal
TaxAmount	Tax Amount	decimal
TaxAmount1	Tax Amount 1	decimal
TaxAmount2	Tax Amount 2	decimal
TaxRateCompound	Indicates if the record utilized Tax Rate Compound	bit
TaxRateDescription1	Tax Rate Description 1	nvarchar
TaxRateDescription2	Tax Rate Description 2	nvarchar
TaxRateId	Tax Rate Id	int	vr_TaxRate
TaxRateName	Tax Rate Name	nvarchar
TaxRatePassThruRate	Tax Rate Pass Through Rate	decimal
TaxRateRate1	Tax Rate Rate 1	decimal
TaxRateRate2	Tax Rate Rate 2	decimal
Terms	Terms	nvarchar
TotalAmount	Total Amount	decimal
TotalFreight	Total Freight Cost	decimal
TotalPaid	Total Paid	decimal
TransactionId	Transaction Id	int
TransactionNumber	Transaction Number	nvarchar
TransactionType	Transaction Type	nvarchar
UIExport	Indicates if the UI Export Checkbox is Checked or Not	bit
UtilityTicketId	Utility Ticket Id	int	vr_UtilityTicket
VendorAddressAddress1	Vendor Address Line 1	nvarchar
VendorAddressAddress2	Vendor Address Line 2	nvarchar
VendorAddressCategory	Vendor Address Category	nvarchar
VendorAddressCity	Vendor City	nvarchar
VendorAddressContact	Vendor Contact	nvarchar
VendorAddressEmail	Vendor Email	nvarchar
VendorAddressFax	Vendor Fax #	nvarchar
VendorAddressId	Vendor Address Id	int	vr_VendorAddress
VendorAddressPhone	Vendor Phone #	nvarchar
VendorAddressPhoneExtension	Vendor Phone # Extension	nvarchar
VendorAddressState	Vendor State	nvarchar
VendorAddressZip	Vendor Zip Code	nvarchar
VendorCode	Vendor Code	nvarchar
VendorCustomerNumber	Vendor Customer Number	nvarchar
VendorId	Vendor Id	int	vr_Vendor
VendorName	Vendor Name	nvarchar
WorkOrderId	Work Order Id	int	vr_WorkOrder

Articles in this section