Tableau Connector for Workday

Build 20.0.7740

CustomerPayments_Customer_Payment_Remittance_Advice_Data

Remittance Advice for this Customer Payment, utilized in Workday's Auto-Application logic in determining which Customer Invoices to apply this payment to.

Columns

Name Type References Description
CustomerPayment_Customer_Payment_Reference_WID String

CustomerPayments.Customer_Payment_Reference_WID

The unique identifier type. Each
Customer_Invoice_Reference String Reference to a Customer Invoice that should be paid by the Customer Payment this Remittance Advice is for.
Amount_to_Pay_in_Invoice_Currency Decimal Customer invoice amount to pay in payment currency. This information is for outbound purposes only and is not processed on inbound Workday Web Services requests.
Amount_to_Pay Decimal Suggested amount to pay in this remittance advice.
Bill_to_Customer_Reference_WID String Contains a unique identifier for an instance of an object.
Bill_to_Customer_Reference_Customer_ID String Contains a unique identifier for an instance of an object.
Bill_to_Customer_Reference_Customer_Reference_ID String Contains a unique identifier for an instance of an object.
Bill_to_Customer_Reference_Sponsor_ID String Contains a unique identifier for an instance of an object.
Bill_to_Customer_Reference_Sponsor_Reference_ID String Contains a unique identifier for an instance of an object.
Bill_to_Customer_Reference_Student_Financial_Account_ID String Contains a unique identifier for an instance of an object.
Customer_Payment_Remittance_Advice_Details_Replacement_Data String Remittance Advice Details are any of the following chosen, along with free-form text for each: Customer Name, Customer ID, PO Number, Invoice Number and Other.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7740