Tableau Connector for Workday

Build 20.0.7740

ExpenseReports_Expense_Report_Line_Credit_Card_Transaction_Data

Element containing the expense report line's credit card transaction data

Columns

Name Type References Description
ExpenseReport_Expense_Report_Reference_WID String

ExpenseReports.Expense_Report_Reference_WID

The unique identifier type. Each
Expense_Report_Line_Date Date The date the expense was incurred.
Expense_Credit_Card_Transaction_Reference_WID String Contains a unique identifier for an instance of an object.
Expense_Credit_Card_Transaction_Reference_Credit_Card_Transaction_Number String Contains a unique identifier for an instance of an object.
Posted_Date Date The date the expense was posted.
Transaction_Number String The transaction number.
Expense_Credit_Card_Reference_WID String Contains a unique identifier for an instance of an object.
Expense_Credit_Card_Reference_Expense_Credit_Card_ID String Contains a unique identifier for an instance of an object.
Expense_Credit_Card_Reference_Expense_Credit_Card_Token String Contains a unique identifier for an instance of an object.
Expense_Credit_Card_Reference_Invalid_Expense_Credit_Card_Token String Contains a unique identifier for an instance of an object.
Transaction_Amount Decimal Total amount in the transaction currency.
Non_Personal_Transaction_Amount Decimal Total amount not marked as personal expense in the transaction currency.
Transaction_Currency_Reference_WID String Contains a unique identifier for an instance of an object.
Transaction_Currency_Reference_Currency_ID String Contains a unique identifier for an instance of an object.
Transaction_Currency_Reference_Currency_Numeric_Code String Contains a unique identifier for an instance of an object.
Currency_Exchange_Rate Decimal Currency exchange rate from the transaction currency to the billing currency
Billing_Amount Decimal Total amount in the billing currency.
Non_Personal_Billing_Amount Decimal Total amount not marked as personal expense in the billing currency.
Billing_Currency_Reference_WID String Contains a unique identifier for an instance of an object.
Billing_Currency_Reference_Currency_ID String Contains a unique identifier for an instance of an object.
Billing_Currency_Reference_Currency_Numeric_Code String Contains a unique identifier for an instance of an object.
Market_Code String The market code for the credit card transaction for the expense.
Corporate_Account_Reference_WID String Contains a unique identifier for an instance of an object.
Corporate_Account_Reference_Corporate_Credit_Card_Account_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