PaymentsRemittanceDetails

Stores detailed breakdowns of remittance lines associated with customer invoice payments, ensuring complete financial reconciliation.

Table Specific Information

The Workday add-in requires filtering on Payments_Id in order to perform the query.

For example:

SELECT * FROM PaymentsRemittanceDetails WHERE Payments_Id = '12345' AND Id = '54321';

Retrieves a customer invoice payment remittance line with the specified ID.

Secured by: Process: Customer Invoice Payment

Scope: Customer Accounts


Name	Type	ReadOnly	Description
Id [KEY]	String	False	The unique identifier for a payment remittance record is a system-generated or externally provided value that differentiates individual records.
Payments_Id [KEY]	String	False	The system-generated unique Workday ID (WID) for the payment transaction associated with this remittance detail.
AmountToPay_Currency	String	False	The currency in which the payment amount is specified, as defined on the customer payment invoice line.
AmountToPay_Value	Decimal	False	The total amount to be paid, as specified on the customer payment invoice line, in the designated currency.
BillToCustomer_Id	String	False	The unique identifier (for example, WID) or reference ID) for the customer being billed for this payment.
Invoice_Id	String	False	The unique identifier (for example, WID, or reference ID) for the invoice associated with this payment remittance detail.