Tableau Connector for Workday

Build 20.0.7740

ExpenseReports

Wrapper element that includes expense report instance and data

Columns

Name Type References Description
Expense_Report_WWSType_Expense_Report_Reference_WID String Contains a unique identifier for an instance of an object.
Expense_Report_WWSType_Expense_Report_Reference_Expense_Report_Reference_ID String Contains a unique identifier for an instance of an object.
Expense_Report_ID String Expense Report ID. This is the Expense Report unique identifier.
Expense_Report_Expense_Payee_Reference_WID String Contains a unique identifier for an instance of an object.
Expense_Report_Expense_Payee_Reference_Applicant_ID String Contains a unique identifier for an instance of an object.
Expense_Report_Expense_Payee_Reference_Contingent_Worker_ID String Contains a unique identifier for an instance of an object.
Expense_Report_Expense_Payee_Reference_Employee_ID String Contains a unique identifier for an instance of an object.
Expense_Report_Expense_Payee_Reference_External_Committee_Member_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.
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.
Locked_in_Workday Bool Set to True to disable editing and canceling the invoice inside the Workday application. Invoice can only be updated from the web service.
Expense_Report_Expense_Report_Number String The document number that will be assigned to the expense report. Leave it blank to have the number auto-assigned.
Expense_Report_Date Date The date the expense report was created.
Expense_Report_Approval_Date Date The date the expense report was approved.
Expense_Report_Status String The status of the expense report.
Budget_Check_Status String Budget Check Status
Committee_Reference_WID String Contains a unique identifier for an instance of an object.
Committee_Reference_Committee_ID String Contains a unique identifier for an instance of an object.
Business_Purpose_Reference_WID String Contains a unique identifier for an instance of an object.
Business_Purpose_Reference_Business_Purpose_ID String Contains a unique identifier for an instance of an object.
Expense_Report_Total_Amount Decimal READ ONLY. The total amount of the expense report.
Expense_Report_Total_Reimbursement_Amount Decimal The total reimbursement amount of the expense report.
Cash_Advance_Applied_Amount Decimal The total cash advance applied amount for the expense report.
Prior_Balance_Applied Decimal The Prior Balance Applied from this Expense Report to a negative reimbursable Expense Report.
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.
Spend_Authorization_Reference_WID String Contains a unique identifier for an instance of an object.
Spend_Authorization_Reference_Spend_Authorization_ID String Contains a unique identifier for an instance of an object.
Final_Expense_Report_for_Spend_Authorization Bool Set to True if this is the Final Expense Report to be used with the related Spend Authorization
Supplier_Reference_WID String Contains a unique identifier for an instance of an object.
Supplier_Reference_Scout_ID String Contains a unique identifier for an instance of an object.
Supplier_Reference_Supplier_ID String Contains a unique identifier for an instance of an object.
Supplier_Reference_Supplier_Reference_ID String Contains a unique identifier for an instance of an object.
Memo String Text describing the use and purpose of the expense report.
Parent_Expense_Report_Reference_WID String Contains a unique identifier for an instance of an object.
Parent_Expense_Report_Reference_Expense_Report_Reference_ID String Contains a unique identifier for an instance of an object.
Child_Expense_Reports_Reference String The Child Expense Reports for this Expense Report.
Expense_Report_Credit_Card_Transactions_Expense_Report_Reference_WID String Contains a unique identifier for an instance of an object.
Expense_Report_Credit_Card_Transactions_Expense_Report_Reference_Expense_Report_Reference_ID String Contains a unique identifier for an instance of an object.
Expense_Report_Credit_Card_Transactions_Expense_Report_Number String The document number that will be assigned to the expense report. Leave it blank to have the number auto-assigned.
Expense_Report_Credit_Card_Transactions_Expense_Payee_Reference_WID String Contains a unique identifier for an instance of an object.
Expense_Report_Credit_Card_Transactions_Expense_Payee_Reference_Applicant_ID String Contains a unique identifier for an instance of an object.
Expense_Report_Credit_Card_Transactions_Expense_Payee_Reference_Contingent_Worker_ID String Contains a unique identifier for an instance of an object.
Expense_Report_Credit_Card_Transactions_Expense_Payee_Reference_Employee_ID String Contains a unique identifier for an instance of an object.
Expense_Report_Credit_Card_Transactions_Expense_Payee_Reference_External_Committee_Member_ID String Contains a unique identifier for an instance of an object.

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