Cmdlets for SAP Concur

Build 24.0.9062

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

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