ExpenseReportsExpensePayment
ExpenseReportsExpensePayment
Columns
| Name | Type | Description |
| ExpenseReportsExpenseReportId [KEY] | Long | Expense report identifier of the expense reports. |
| PaymentDate | Date | Date when the payment is done. |
| PaymentAmount | Double | Amount for which the payment is done. |
| PaymentCurrencyCode | String | The Currency code in which the payment is done. |
| CheckNumber | Long | Bank Check Number for the payment done. |
| CheckId | Long | Bank Check Unique identifier for the payment done. |
| PaymentNumber | Long | Number representing the payment sequence. |
| InvoiceId | Long | Value that uniquely identifies an invoice for the payment. |
| PaymentMethod | String | Method of payment for this expense report such as check, cash, or credit. |
| PaymentMethodCode | String | Code representing Method of Payment. |
| ExpenseReportId [KEY] | Long | Value that uniquely identifies a specific expense report. |
| MailingAddress | String | Mailing address of the employee for whom the payment is done. |
| BankAccountNumber | String | Bank account number to which the expense amount is reimbursed. |
| BankName | String | Bank name to which the expense amount is reimbursed. |
| ProcessingType | String | Processing type of the payment such as PRINTED or ELECTRONIC. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| BusinessUnit | String | BusinessUnit |
| SysEffectiveDate | String | SysEffectiveDate |
| Finder | String | finder |