PaymentRequestDigests
A payment request digest is a collection of summarized payment requests to invoice vendors.
Table Specific Information
Select
At least one of the following columns should be specified in the WHERE clause:
- approvalStatus
- paymentStatus
- vendorInvoiceNumber
- createDateBefore
- createDateAfter
- userDefinedDateBefore
- userDefinedDateAfter
- submitDateBefore
- submitDateAfter
- paidDateBefore
- paidDateAfter
For example:
SELECT * FROM PaymentRequestDigests WHERE approvalStatus = 'sampleApprovalStatus'
Columns
| Name | Type | References | Description |
| ApprovalStatusCode | String | A code indicating the request's approval status. | |
| CreateDate | String | The date the request was created. | |
| CurrencyCode | String | The 3-letter ISO 4217 currency code for the request currency. Examples: USD - US dollars; BRL - Brazilian real; etc. | |
| ID | String | The unique identifier of the resource. | |
| InvoiceNumber | String | The invoice number of the payment request. | |
| IsDeleted | String | A true/false value which indicates whether the request has been deleted. Deleted requests are retained in the system for historical purposes. | |
| OwnerLoginID | String | The login ID of the payment request owner. | |
| OwnerName | String | The name of the payment request owner. | |
| PaidDate | String | The date when all journal entries in the request were integrated with or extracted to the financial system. | |
| PaymentRequestId | String | The unique identifier of the payment request summarized in this digest. | |
| PaymentRequestUri | String | The URI of the payment request summarized in this digest. | |
| PaymentStatusCode | String | A code indicating the request's payment status. | |
| PurchaseOrderNumber | String | The purchase order number for the purchase order associated with the invoice. | |
| Total | String | The total amount of the request. | |
| URI | String | The URI to the resource. | |
| UserDefinedDate | String | The invoice date as assigned by the user. | |
| VendorName | String | The name of the vendor. | |
| VendorCode | String | The code of the vendor. | |
| approvalStatus | String | A code representing a payment request approval status. | |
| paymentStatus | String | A code representing a Payment Request Payment Status. | |
| vendorInvoiceNumber | String | Vendor invoice number tied to invoice. | |
| createDateBefore | String | The payment request create date is before this date. Format: YYYY-MM-DD. | |
| createDateAfter | String | The payment request user defined date is after this date. Format: YYYY-MM-DD | |
| userDefinedDateBefore | String | The payment request user defined date is before this date. Format: YYYY-MM-DD | |
| userDefinedDateAfter | String | The payment request user defined date is after this date. Format: YYYY-MM-DD | |
| submitDateBefore | String | The payment request submit date is before this date. Format: YYYY-MM-DD | |
| submitDateAfter | String | The payment request submit date is after this date. Format: YYYY-MM-DD | |
| paidDateBefore | String | The payment request paid date is before this date. Format: YYYY-MM-DD | |
| paidDateAfter | String | The payment request paid date is after this date. Format: YYYY-MM-DD |