PaymentsRemittanceDetails
Stores detailed breakdowns of remittance lines associated with customer invoice payments, ensuring complete financial reconciliation.
Table Specific Information
Select
The Workday connector requires filtering on Payments_Id in order to perform the query.
For example:
SELECT * FROM PaymentsRemittanceDetails WHERE Payments_Id = '12345' AND Id = '54321';
Workday Resource Information
Retrieves a customer invoice payment remittance line with the specified ID.Secured by: Process: Customer Invoice Payment
Scope: Customer Accounts
Columns
| 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. |