Tableau Connector for Workday

Build 20.0.7740

CustomerPayments

Customer Payment instance and data.

Columns

Name Type References Description
Customer_Payment_Reference_WID String Contains a unique identifier for an instance of an object.
Customer_Payment_Reference_Cash_Sale_ID String Contains a unique identifier for an instance of an object.
Customer_Payment_Reference_Customer_Payment_for_Invoices_Reference_ID String Contains a unique identifier for an instance of an object.
Customer_Payment_Reference_Student_Application_Fee_Payment_ID String Contains a unique identifier for an instance of an object.
Customer_Payment_Reference_Student_Credit_Memo_ID String Contains a unique identifier for an instance of an object.
Customer_Payment_Reference_Student_Disbursement_Payment_ID String Contains a unique identifier for an instance of an object.
Customer_Payment_Reference_Student_Historical_Payment_ID String Contains a unique identifier for an instance of an object.
Customer_Payment_Reference_Student_Payment_ID String Contains a unique identifier for an instance of an object.
Customer_Payment_Reference_Student_Sponsor_Payment_ID String Contains a unique identifier for an instance of an object.
Customer_Payment_Reference_Student_Waiver_Payment_ID String Contains a unique identifier for an instance of an object.
Customer_Payment_for_Invoices_Reference_ID String Customer Payment for Invoices ID. This is the Customer Payment unique identifier.
Locked_in_Workday Bool Set to True to disable editing and canceling the Customer Payment inside the Workday Application. Customer Payment can only be updated from the web service is this is set.
Company_Reference_WID String Contains a unique identifier for an instance of an object.
Company_Reference_Company_Reference_ID String Contains a unique identifier for an instance of an object.
Company_Reference_Organization_Reference_ID String Contains a unique identifier for an instance of an object.
Payment_Currency_Reference_WID String Contains a unique identifier for an instance of an object.
Payment_Currency_Reference_Currency_ID String Contains a unique identifier for an instance of an object.
Payment_Currency_Reference_Currency_Numeric_Code String Contains a unique identifier for an instance of an object.
Payment_Date Date Transaction date of the Customer Payment.
Payment_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Payment_Type_Reference_Payment_Type_ID String Contains a unique identifier for an instance of an object.
Payment_Status String Payment Status.
Cancel_Accounting_Date Date Cancel Accounting Date for Customer Payment for Invoices
Payment_Application_Status String Application Status for Customer Payment for Invoices.
Payment_Number String Sequence number for customer payments. To sequence customer payments, set up the ID Generator for Customer Payment for Invoices in the Edit Tenant Setup - Financials task. This field is ignored in a Put Customer Payment request.
Payment_Amount Decimal Total Payment Amount for the Customer Payment
Remit_from_Customer_Reference_WID String Contains a unique identifier for an instance of an object.
Remit_from_Customer_Reference_Customer_ID String Contains a unique identifier for an instance of an object.
Remit_from_Customer_Reference_Customer_Reference_ID String Contains a unique identifier for an instance of an object.
Remit_from_Customer_Reference_Sponsor_ID String Contains a unique identifier for an instance of an object.
Remit_from_Customer_Reference_Sponsor_Reference_ID String Contains a unique identifier for an instance of an object.
Remit_from_Customer_Reference_Student_Financial_Account_ID String Contains a unique identifier for an instance of an object.
Check_Number String Check Number
Payment_Memo String This transaction header memo will print on the delivered transaction. It is optional freeform text
Ready_to_Auto_Apply Bool Ready to Auto-Apply makes this Customer Payment available to the Auto-Application process if it is run prior to this payment being applied manually. Remit-from Customer is required if Ready to Auto-Apply is checked.
Invoice_Currency_Reference_WID String Contains a unique identifier for an instance of an object.
Invoice_Currency_Reference_Currency_ID String Contains a unique identifier for an instance of an object.
Invoice_Currency_Reference_Currency_Numeric_Code String Contains a unique identifier for an instance of an object.
Currency_Rate_Type_Override_Reference_WID String Contains a unique identifier for an instance of an object.
Currency_Rate_Type_Override_Reference_Currency_Rate_Type_ID String Contains a unique identifier for an instance of an object.
Currency_Rate_Date_Override Date For a foreign currency payment, this allows you to override the date used to look up the currency conversion rate. The default date is normally the same as the transaction date.
Currency_Rate_Manual_Override_Reference Decimal For a foreign currency payment, this allows you to directly override the currency conversion rate that will be used.
Electronic_File_Information String Electronic File Information is free form text that may be entered to identify the Electronic File that initiated this web service integration.
Customer_Deposit_Reference_WID String Contains a unique identifier for an instance of an object.
Customer_Deposit_Reference_Customer_Deposit_Reference_ID String Contains a unique identifier for an instance of an object.
Do_Not_Apply_Payment_to_Invoices_on_Hold Bool If set to True, Do Not Apply Payment to Invoices on Hold indicates whether this payment should be used to apply to Customer Invoices that are On Hold from Payment.
Show_Only_Matched_Invoices_when_Applying Bool If true, the customer payment will show only customer invoice documents that match the remittance criteria during application of payment.

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