Tableau Connector for Workday

Build 20.0.7740

Payments

Payment Data

Columns

Name Type References Description
Payment_Group_Reference_WID String Contains a unique identifier for an instance of an object.
Payment_Group_Reference_Outsourced_Payment_Group_ID String Contains a unique identifier for an instance of an object.
Payment_Date Date Date the payment was made.
Payment_Group_Currency_Reference_WID String Contains a unique identifier for an instance of an object.
Payment_Group_Currency_Reference_Currency_ID String Contains a unique identifier for an instance of an object.
Payment_Group_Currency_Reference_Currency_Numeric_Code String Contains a unique identifier for an instance of an object.
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_Method_Reference_WID String Contains a unique identifier for an instance of an object.
Payment_Method_Reference_Payment_Method_ID String Contains a unique identifier for an instance of an object.
Payment_Category_Reference_WID String Contains a unique identifier for an instance of an object.
Payment_Category_Reference_Payment_Category_ID String Contains a unique identifier for an instance of an object.
Settlement_Run_Reference_IID String Contains a unique identifier for an instance of an object.
Settlement_Run_Reference_WID String Contains a unique identifier for an instance of an object.
Payment_Status String Payment Status.
Payment_Memo String Memo associated with the payment.
Additional_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Additional_Type_Reference_Additional_Reference_Type_ID String Contains a unique identifier for an instance of an object.
Payment_Accounting_Date Date This field is to retrieve Payment Accounting Date for a settled Payment
Cancel_Accounting_Date Date This field retrieves Payment Cancel Accounting Date for a settled Payment which has been canceled later.
Payment_Reference_Number String Unique reference number for the payment.
Payment_Amount Decimal Payment Amount
Amount_as_Text String Amount as Text
Discount_Taken Decimal Indicates if a discount was taken.
Currency_Reference_Currency_Reference_WID String Contains a unique identifier for an instance of an object.
Currency_Reference_Currency_Reference_Currency_ID String Contains a unique identifier for an instance of an object.
Currency_Reference_Currency_Reference_Currency_Numeric_Code String Contains a unique identifier for an instance of an object.
Currency_Symbol String Currency Symbol
Currency_Description String Currency Description
Check_or_Advice_Number Decimal Check or Advice Number
Check_Number String Check Number
Prenote_Flag Bool Indicates that the payment is a prenote payment.
Payroll_Payment_Display_Order Decimal Payroll Payment Display Order
Handling_Code_Reference_WID String Contains a unique identifier for an instance of an object.
Handling_Code_Reference_Handling_Code_ID String Contains a unique identifier for an instance of an object.
Tax_Code_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Code_Reference_Tax_Code_ID String Contains a unique identifier for an instance of an object.
Tax_Code_Reference_Withholding_Tax_Code_ID String Contains a unique identifier for an instance of an object.
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.
On_Behalf_of_Company_Reference_WID String Contains a unique identifier for an instance of an object.
On_Behalf_of_Company_Reference_Company_Reference_ID String Contains a unique identifier for an instance of an object.
On_Behalf_of_Company_Reference_Organization_Reference_ID String Contains a unique identifier for an instance of an object.
Identification String Unique identification, as assigned by the creditor, to unambiguously identify the mandate.
Date_of_Signature Date Date on which the direct debit mandate has been signed by the debtor.
Creditor_Identifier String Country-specific identification for the creditor of the mandate.
Sequence_Type String Identifies the direct debit sequence, such as first, recurrent, final or one-off.
Originating_Contact_Data String Payment's originating party data
Originating_Bank_Data String Originating party bank data.
On_Behalf_Of_Company_Data String On Behalf Of Company Data
Receiving_Party_Reference_WID String Contains a unique identifier for an instance of an object.
Receiving_Party_Reference_Academic_Person_ID String Contains a unique identifier for an instance of an object.
Receiving_Party_Reference_Ad_hoc_Payee_ID String Contains a unique identifier for an instance of an object.
Receiving_Party_Reference_Applicant_ID String Contains a unique identifier for an instance of an object.
Receiving_Party_Reference_Company_Reference_ID String Contains a unique identifier for an instance of an object.
Receiving_Party_Reference_Contingent_Worker_ID String Contains a unique identifier for an instance of an object.
Receiving_Party_Reference_Corporate_Credit_Card_Account_ID String Contains a unique identifier for an instance of an object.
Receiving_Party_Reference_Customer_ID String Contains a unique identifier for an instance of an object.
Receiving_Party_Reference_Customer_Reference_ID String Contains a unique identifier for an instance of an object.
Receiving_Party_Reference_Deduction_Recipient_ID String Contains a unique identifier for an instance of an object.
Receiving_Party_Reference_Employee_ID String Contains a unique identifier for an instance of an object.
Receiving_Party_Reference_External_Committee_Member_ID String Contains a unique identifier for an instance of an object.
Receiving_Party_Reference_Internal_Service_Provider_ID String Contains a unique identifier for an instance of an object.
Receiving_Party_Reference_Internal_Service_Provider_Reference_ID String Contains a unique identifier for an instance of an object.
Receiving_Party_Reference_Investor_ID String Contains a unique identifier for an instance of an object.
Receiving_Party_Reference_Miscellaneous_Payee_ID String Contains a unique identifier for an instance of an object.
Receiving_Party_Reference_Organization_Reference_ID String Contains a unique identifier for an instance of an object.
Receiving_Party_Reference_Scout_ID String Contains a unique identifier for an instance of an object.
Receiving_Party_Reference_Sponsor_ID String Contains a unique identifier for an instance of an object.
Receiving_Party_Reference_Sponsor_Reference_ID String Contains a unique identifier for an instance of an object.
Receiving_Party_Reference_Student_ID String Contains a unique identifier for an instance of an object.
Receiving_Party_Reference_Student_Proxy_ID String Contains a unique identifier for an instance of an object.
Receiving_Party_Reference_Supplier_Connection_ID String Contains a unique identifier for an instance of an object.
Receiving_Party_Reference_Supplier_ID String Contains a unique identifier for an instance of an object.
Receiving_Party_Reference_Supplier_Reference_ID String Contains a unique identifier for an instance of an object.
Receiving_Party_Reference_Tax_Authority_ID String Contains a unique identifier for an instance of an object.
Receiving_Party_Reference_Tax_Authority_Reference_ID String Contains a unique identifier for an instance of an object.
Receiving_Party_Contact_Data String Receiving party data.
Receiving_Party_Bank_Data String Receiving party bank data.
Merchant_Account_ID String Merchant Account ID
Customer_Profile_ID String Customer Profile Id
Credit_Card_Authorization_ID String Credit card authorization id
Merchant_Processing_ID String Merchant Processing Id
Credit_Card_Credit Bool Credit Card Credit
Remittance_Data String Remittance data
Payroll_Remittance_Data String Payroll Remittance Data
Payroll_Result_Gross_Amount_Data String Payroll Result Gross Amount Data
Payroll_Result_Country_Data String Specific Country Data for the Payroll Result
Cash_Out_Address_Business_Name String Cash Out Address Business Name
Formatted_Cash_Out_Address String Formatted Cash Out Address
Cash_Out_Address_Information_Data String Cash Out Address Information Data
Integration_Field_Override_Data String Result of the evaluation of an External Field based on a contextual instance.
Tax_Certificate_Numbers_Data String Information Relating to Gapless Tax Certificate Numbers

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