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:
- ApprovalStatusCode
- PaymentStatusCode
- VendorInvoiceNumber
- CreateDate
- UserDefinedDate
- SubmitDate
- PaidDate
You can use any combination of these filters but the following columns support only semi intervals createDate,userDefinedDate,submitDate,paidDate (Refere to the examples)
These columns can not be used to define intervals.
For example:
SELECT * FROM PaymentRequestDigests WHERE CreateDate > '2024-01-01' AND CreateDate < '2024-01-01' SELECT * FROM PaymentRequestDigests WHERE CreateDate = '2024-01-01'
The above examples will produce 0 results.
Supported queries:
SELECT * FROM PaymentRequestDigests WHERE ApprovalStatusCode = 'R_NOTF' SELECT * FROM PaymentRequestDigests WHERE PaymentStatusCode = 'R_NOTP' SELECT * FROM PaymentRequestDigests WHERE VendorInvoiceNumber = '2000' SELECT * FROM PaymentRequestDigests WHERE CreateDate > '2024-01-01' SELECT * FROM PaymentRequestDigests WHERE CreateDate < '2024-01-01' SELECT * FROM PaymentRequestDigests WHERE UserDefinedDate > '2024-01-01' SELECT * FROM PaymentRequestDigests WHERE UserDefinedDate < '2024-01-01' SELECT * FROM PaymentRequestDigests WHERE SubmitDate > '2024-01-01' SELECT * FROM PaymentRequestDigests WHERE SubmitDate < '2024-01-01' SELECT * FROM PaymentRequestDigests WHERE PaidDate > '2024-01-01' SELECT * FROM PaymentRequestDigests WHERE PaidDate < '2024-01-01' SELECT * FROM PaymentRequestDigests WHERE UserDefinedDate > '2024-01-01' AND ApprovalStatusCode='R_ACCO' AND CreateDate > '2024-03-06'
Columns
| Name | Type | Description |
| ID | String | The unique identifier of the resource. |
| ApprovalStatusCode | String | A code indicating the request's approval status. |
| CreateDate | Date | 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. |
| 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 | Date | 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 | Date | The invoice date as assigned by the user. |
| VendorName | String | The name of the vendor. |
| VendorCode | String | The name of the vendor. |
| VendorInvoiceNumber | String | Vendor invoice number tied to invoice. |
| SubmitDate | Date | The payment request submit date is before this date. Format: YYYY-MM-DD |