WfpmPaymentRequest
Stores information about payment requests, including requested amounts, statuses, and links to vendor or financial data.
Columns
| Name | Type | Description |
| Recordno [KEY] | String | The unique identifier for the payment request. |
| Prbatchkey | Int64 | The batch key associated with the payment request. |
| Recordtype | String | The type of record (for example, payment request, payment batch). |
| Description | String | A description of the payment request. |
| Totalentered | Double | The total amount entered for the payment request. |
| Totalpaid | Double | The total amount paid in the payment request. |
| Totalselected | Double | The total amount selected for payment in the payment request. |
| Totaldue | Double | The total amount due for the payment request. |
| State | String | The current state of the payment request (for example, pending, completed). |
| Whencreated | Datetime | The date and time when the payment request was created. |
| Whenpaid | Datetime | The date and time when the payment was made. |
| Termkey | Int64 | The payment terms associated with the payment request. |
| Termname | String | The name of the payment terms associated with the payment request. |
| Whendiscount | Datetime | The date when any discount for the payment request is applicable. |
| Recordid | String | A unique record identifier for the payment request. |
| Userkey | Int64 | The unique identifier for the user associated with the payment request. |
| Whendue | Datetime | The due date for the payment request. |
| Docnumber | String | The document number for the payment request. |
| Cleared | String | The cleared status of the payment request (for example, yes, no). |
| Clrdate | Datetime | The date when the payment request was cleared. |
| Modulekey | String | The module key related to the payment request. |
| Status | String | The status of the payment request (for example, pending, completed). |
| Systemgenerated | String | Indicates whether the payment request was system-generated. |
| Whenposted | Datetime | The date and time when the payment request was posted. |
| Onhold | Boolean | Indicates whether the payment request is on hold. |
| Currency | String | The currency used for the payment request. |
| Trx_totalentered | Double | The total amount entered for the transaction associated with the payment request. |
| Trx_totalpaid | Double | The total amount paid for the transaction associated with the payment request. |
| Trx_totalselected | Double | The total amount selected for payment in the transaction associated with the payment request. |
| Trx_totaldue | Double | The total amount due for the transaction associated with the payment request. |
| Deliverymethod | String | The delivery method for the payment request (for example, ACH, check, wire). |
| Recon_date | Datetime | The reconciliation date for the payment request. |
| Basecurr | String | The base currency for the payment request. |
| Locationkey | Int64 | The location key associated with the payment request. |
| Auwhencreated | Datetime | The date and time when the payment request was auto-created. |
| Whenmodified | Datetime | The date and time when the payment request was last modified. |
| Createdby | Int64 | The ID of the user who created the payment request. |
| Modifiedby | Int64 | The ID of the user who last modified the payment request. |
| Nr_totalentered | Double | The total entered amount for the payment request (non-transaction). |
| Nr_trx_totalentered | Double | The total entered amount for the transaction associated with the payment request. |
| Paymenttype | String | The type of payment (for example, electronic, check, credit). |
| Paymentdate | Datetime | The date when the payment is scheduled or was made. |
| Receiptdate | Datetime | The date when the payment was received by the vendor. |
| Paymentamount | Double | The total payment amount for the request. |
| Documentnumber | String | The document number associated with the payment request. |
| Memo | String | Any additional notes or comments regarding the payment request. |
| Financialaccount | String | The financial account used for the payment request. |
| Vendorname | String | The name of the vendor associated with the payment request. |
| Vendorid | String | The unique identifier for the vendor associated with the payment request. |
| Megaentitykey | Int64 | The key identifier for the mega entity associated with the payment request. |
| Megaentityid | String | The unique ID for the mega entity associated with the payment request. |
| Record_url | String | The URL for accessing the payment request record. |