ExpenseReportsExpensePayment
Details payment-related information (dates, amounts) for reimbursed expense reports, ensuring visibility into disbursement status.
Columns
| Name | Type | Description |
| ExpenseReportsExpenseReportId [KEY] | Long | Unique identifier for the expense report within the system, used to track and reference specific reports for reimbursement. |
| PaymentDate | Date | The date when the payment for the expense report is processed and completed. |
| PaymentAmount | Decimal | The total amount paid in relation to the expense report, representing the reimbursement amount. |
| PaymentCurrencyCode | String | The currency code in which the payment is made, helping to identify the type of currency used in the transaction. |
| CheckNumber | Long | The unique bank-issued check number associated with the payment for the expense report. |
| CheckId | Long | The unique identifier for the check used to process the payment, often linked to payment records in the system. |
| PaymentNumber | Long | A sequential number assigned to the payment, used to track and reference individual payment transactions. |
| InvoiceId | Long | A unique identifier for the invoice associated with the payment, used for linking payment to the corresponding invoice. |
| PaymentMethod | String | The method used for payment, such as check, cash, or credit, indicating how the reimbursement was processed. |
| PaymentMethodCode | String | A code that represents the method of payment, used for categorizing and identifying different types of payment methods. |
| ExpenseReportId [KEY] | Long | The unique identifier for the specific expense report, linking payments to the correct report in the system. |
| MailingAddress | String | The employee’s mailing address where the reimbursement is sent, typically used for checks or physical payment processing. |
| BankAccountNumber | String | The employee’s bank account number into which the expense payment is deposited, enabling electronic transfers. |
| BankName | String | The name of the bank where the employee’s bank account is held, helping to identify the financial institution used for payments. |
| ProcessingType | String | The processing method for the payment, such as 'PRINTED' for checks or 'ELECTRONIC' for direct deposits. |
| BusinessUnit | String | The business unit within the company associated with the expense report, used for organizational reporting and budget allocation. |
| Finder | String | A search term or keyword used to filter records or identify specific entries within the system. |
| SysEffectiveDate | String | A system-defined date that represents when a particular record or data entry becomes effective in the system. |
| CUReferenceNumber | Int | A reference number used to link child aggregates to their parent tables, often used for data relationships in hierarchical structures. |
| EffectiveDate | Date | The date from which a resource or record is considered effective, used in filtering queries to return relevant data as of that date. |