Payments
Records and retrieves customer invoice payment transactions, including amounts, payment methods, and processing statuses.
Table Specific Information
Select
The Workday add-in 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 |
A brief summary or preview of the customer payment instance, often used for display purposes. |
| 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. |