| 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 |