Payments
Records and retrieves customer invoice payment transactions, including amounts, payment methods, and processing statuses.
Table Specific Information
Select
The Workday connector requires filtering on Id in order to perform the query.
For example:
SELECT * FROM Payments WHERE Id = '12345';
Workday Resource Information
Retrieves a customer invoice payment with the specified ID.Secured by: Process: Customer Invoice Payment
Scope: Customer Accounts
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | False |
The unique ID for each customer payment transaction, maintaining data integrity, ensuring that every payment record can be distinctly referenced within the system. |
| Amount_Currency | String | False |
The currency in which the customer payment was made, represented as an International Organization for Standardization (ISO) currency code. |
| Amount_Value | Decimal | False |
The total value of the customer payment in the transaction currency, reflecting the exact amount paid by the customer. |
| Company_Id | String | False |
The unique ID for the company associated with the payment, which can be a Workday ID (WID), a reference ID, or an internal system ID. |
| Date | Datetime | False |
The timestamp indicating when the customer payment was completed, which is formatted as a date-time value. |
| Descriptor | String | False |
The display name of the instance |
| Memo | String | False |
Additional notes or details associated with the customer payment, often provided for reference or reconciliation. |
| ReadyToAutoApply | Bool | False |
Indicates whether the customer payment is eligible for automatic application to outstanding invoices or cash sales. |
| Reference | String | False |
A unique reference number is assigned to settled customer payments but is empty if the status is 'In Progress' or the payment method is check or Electronic Funds Transfer (EFT). |
| RemitFromCustomer_Id | String | False |
The unique ID for the customer who remitted the payment, represented as a WID, a reference ID, or an internal system ID. |
| TransactionNumber | String | False |
The official transaction number associated with the customer payment, used for tracking and reporting. |
| Type_Id | String | False |
An ID specifying the type of payment transaction, represented as a WID, a reference ID, or an internal system ID. |