vr_PaymentItem

Updated March 24, 2026 15:10

Field Name	Field Description	Data Type	FK Join
Id	Payment Item Id	int
PaymentId	Payment Id	int	vrpt_Payment
PurchaseOrderId	Purchase Order Id	int	vr_PurchaseOrder
ProjectRequisitionId	Project Requisition Id	int	vrpt_ProjectRequisition
UtilityTicketId	Utility Ticket Id	int	vr_UtilityTicket
Amount	Amount	decimal
BalanceAmount	Balance Amount	decimal
IsCreditMemo	Indicates if the record is a credit memo	bit
IsCreditMemoUsed	Indiactes if a credit memo is used	bit
CancelledById	Cancelled By Id (User Id)	int	vr_users
CancellationDate	Cancellation Date	datetime
InvoiceId	Invoice Id	int	vr_Invoice
APInvoiceId	Accounts Payable Invoice Id	int	vr_APInvoice
WorkOrderId	Work Order Id	int	vr_WorkOrder
GasTicketId	Gas Ticket Id	int	vr_FuelAndOil
SalesOrderId	Sales Order Id	int	vr_SalesOrder
RentalId	Rental Id	int
ExpenseTicketId	Expense Ticket Id	int	vr_ExpenseTicket
PaymentAmount	Payment Amount	decimal
CreatorId	User Id (Record Creator)	int	vr_users
CreatedDate	Record Creation Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
ModifiedDate	Last Modified Date	datetime
CurrencyId	Currency Id	int	vrpt_Currency
CurrencyExchangeId	Currency Exchange Id	int
CurrencyExchangeDate	Currency Exchange Date	datetime
ArchivePurchaseOrderId	Archive Purchase Order Id	int
ArchiveSalesOrderId	Archive Sales Order Id	int
ArchiveProjectRequisitionId	Archive Project Requisition Id	int
ArchiveInvoiceId	Archive Invoice Id	int
ArchiveGasTicketId	Archive Gas Ticket Id	int
ArchiveRentalId	Archive Rental Id	int
ArchiveExpenseTicketId	Archive Expense Ticket Id	int
ArchiveAPInvoiceId	Archive Accounts Payable Invoice Id	int
ArchiveUtilityTicketId	Archive Utility Ticket Id	int
ArchiveWorkOrderId	Archive Work Order Id	int
TransactionId	Transaction Id	int
TransactionNumber	Transaction Number	nvarchar
ItemType	Item Type	int
TransactionDate	Transaction Date	datetime
TransactionAmount	Transaction Amount	int

Articles in this section