vrpt_Invoice

Updated December 24, 2025 12:47

Field Name	Field Description	Data Type	FK Join
AR	Accounts Receivable	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
Contact	Contact	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	Date	datetime
DepartmentAddress1	Department Address 1	nvarchar
DepartmentAddress2	Department Address 2	nvarchar
DepartmentCity	Department City	nvarchar
DepartmentCode	Department Code	nvarchar
DepartmentEmail	Department Email	nvarchar
DepartmentFax	Department Fax	nvarchar
DepartmentId	Department Id	int	vr_Department
DepartmentMainPhone	Department Main Phone	nvarchar
DepartmentName	Department Name	nvarchar
DepartmentStateCode	Department State Code	nvarchar
DepartmentZipCode	Department Zip Code	nvarchar
DiscountPercent	Discount Percent	decimal
DiscountTaken	Discount Taken	decimal
DueDate	Due Date	datetime
ExpenseTicketId	Expense Ticket Id	int	vr_ExpenseTicket
Freight	Freight	decimal
GasTicketId	Gas Ticket Id	int	vr_FuelAndOil
Id	Invoice Id	int
InvoiceTaxCompound	Indicates if the record utilizes tax compound	bit
InvoiceTaxPassThruRate	Invoice Tax Pass Thru Rate	decimal
InvoiceTaxRate	Invoice Tax Rate	decimal
InvoiceTaxRate2	Invoice Tax Rate 2	decimal
IsAccountsReceivable	Indicates if this record is from accounts receivable	bit
ItemTypeId	Item Type Id	int
LeaseId	Lease Id	int	vrpt_Lease
Matched	Indicates if this record is matched	bit
MatchedDate	Matched Date	datetime
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
Number	Invoice Numer	nvarchar
Override	Indicates if this record is marked as override	bit
PONumber	Purchase Order Number	nvarchar
Processed	Indicates if this record is marked as processed	bit
ProjectRequisitionId	Project Requisition Id	int	vrpt_ProjectRequisition
PurchaseOrderId	Purchase Order Id	int	vr_PurchaseOrder
PurchaseOrderInvoicing	Indicates if this 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	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 Thru 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
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