JDBC Driver for SAP Concur

Build 23.0.8839

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839