Tableau Connector for Workday

Build 20.0.7740

CustomerDeposits

Customer Deposit Data

Columns

Name Type References Description
ID String Customer Deposit ID. This is the Customer Deposit unique identifier.
Submit Bool Submit for Approval is a boolean flag indicating if the transaction is to be submitted or saved in draft mode. If this flag is set, the transaction will be submitted, otherwise the transaction is saved in draft.
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.
Currency_Reference_WID String Contains a unique identifier for an instance of an object.
Currency_Reference_Currency_ID String Contains a unique identifier for an instance of an object.
Currency_Reference_Currency_Numeric_Code String Contains a unique identifier for an instance of an object.
Payment_Deposit_Date Date This is the Customer Deposit date. It must be greater than or equal to all included payment transaction dates.
Bank_Account_Reference_WID String Contains a unique identifier for an instance of an object.
Bank_Account_Reference_Bank_Account_ID String Contains a unique identifier for an instance of an object.
Bank_Account_Reference_Petty_Cash_Account_ID String Contains a unique identifier for an instance of an object.
Deposit_Reference_Number String Free form text for a Customer Deposit Reference Number
Control_Total_Amount Decimal Control Total Amount for the Customer Deposit. Enter this amount to ensure it matches the sum of the payment amounts deposited.
Currency_Rate_Type_Reference String Reference to an existing Currency Rate Type
Currency_Rate_Override Decimal Currency Conversion Rate Data
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_Payment_for_Invoices_Reference String Reference to 1 to many Customer Payments existing in Workday, to include in this deposit.
Total_Deposit_Amount Decimal The total amount for the customer deposit. This value is read-only and will be ignored on the submit web service.

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