EPPaymentRequest
Tracks employee payment requests, recording amounts, statuses, and related data.
Columns
| Name | Type | Description |
| Recordno [KEY] | String | Unique identifier for the employee payment request record. |
| Prbatchkey | Int64 | Key referencing the payment request batch. |
| Recordtype | String | Type of record associated with the employee payment request. |
| Description | String | Description of the payment request or transaction. |
| Totalentered | Double | Total amount entered for the payment request. |
| Totalpaid | Double | Total amount paid for the payment request. |
| Totalselected | Double | Total amount selected for processing in the payment request. |
| Totaldue | Double | Total amount due for the payment request. |
| State | String | Current state or status of the payment request. |
| Whencreated | Datetime | Timestamp when the payment request was created. |
| Whenpaid | Datetime | Timestamp when the payment was made. |
| Termkey | Int64 | Key referencing the payment terms associated with the request. |
| Termname | String | Name of the payment terms associated with the request. |
| Whendiscount | Datetime | Date when any discounts on the payment request apply. |
| Recordid | String | Identifier for the record within the payment request. |
| Userkey | Int64 | Key referencing the user who created the payment request. |
| Whendue | Datetime | Due date for the payment request. |
| Docnumber | String | Document number associated with the payment request. |
| Cleared | String | Indicates whether the payment request has been cleared. |
| Clrdate | Datetime | Date when the payment request was cleared. |
| Modulekey | String | Key referencing the module associated with the payment request. |
| Status | String | Current status of the payment request. |
| Systemgenerated | String | Indicates whether the record was system-generated. |
| Whenposted | Datetime | Timestamp when the payment request was posted. |
| Onhold | Boolean | Indicates whether the payment request is on hold. |
| Currency | String | Currency used in the payment request. |
| Trx_totalentered | Double | Transaction amount entered for the payment request in its original currency. |
| Trx_totalpaid | Double | Transaction amount paid for the payment request in its original currency. |
| Trx_totalselected | Double | Transaction amount selected for the payment request in its original currency. |
| Trx_totaldue | Double | Transaction amount due for the payment request in its original currency. |
| Deliverymethod | String | Method used for delivering the payment request. |
| Recon_date | Datetime | Date of reconciliation for the payment request. |
| Basecurr | String | Base currency used for the payment request. |
| Locationkey | Int64 | Key referencing the location associated with the payment request. |
| Auwhencreated | Datetime | Timestamp when the audit entry for creation was recorded. |
| Whenmodified | Datetime | Timestamp when the payment request was last modified. |
| Createdby | Int64 | Identifier of the user who created the payment request. |
| Modifiedby | Int64 | Identifier of the user who last modified the payment request. |
| Nr_totalentered | Double | Non-reconciled total amount entered for the payment request. |
| Nr_trx_totalentered | Double | Non-reconciled transaction amount entered in the payment request's original currency. |
| Paymenttype | String | Type of payment method used for the request. |
| Paymentdate | Datetime | Date when the payment was made. |
| Receiptdate | Datetime | Date when the payment receipt was issued. |
| Paymentamount | Double | Amount paid for the payment request. |
| Documentnumber | String | Number of the document associated with the payment request. |
| Memo | String | Memo or notes associated with the payment request. |
| Financialaccount | String | Financial account related to the payment request. |
| Employeeid | String | Identifier of the employee associated with the payment request. |
| Contactinfo_name | String | Name of the contact associated with the payment request. |
| Megaentitykey | Int64 | Key referencing the mega-entity associated with the payment request. |
| Megaentityid | String | Identifier of the mega-entity associated with the payment request. |
| Record_url | String | URL link to the record in the system. |