PaymentRequestDigests

A payment request digest is a collection of summarized payment requests to invoice vendors.

テーブル固有の情報

Select

WHERE 句には、以下のカラムの少なくとも1つを指定する必要があります。

ApprovalStatusCode
PaymentStatusCode
VendorInvoiceNumber
CreateDate
UserDefinedDate
SubmitDate
PaidDate

CreateDate、UserDefinedDate、SubmitDate、およびPaidDate フィルタのみがサポートされています。これらのフィルタは自由に組み合わせることができます。

これらのカラムは、インターバルを定義するためには使用できません。たとえば、次のクエリは結果を返しません。

SELECT * FROM PaymentRequestDigests WHERE CreateDate > '2024-01-01' AND CreateDate < '2024-01-01'
SELECT * FROM PaymentRequestDigests WHERE CreateDate = '2024-01-01'

サポートされるクエリ：

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	References	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 code 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

SSIS Components for SAP Concur

PaymentRequestDigests

テーブル固有の情報

Select

Columns