Tableau Connector for Workday

Build 20.0.7740

ExpenseCreditCardTransactions

Wrapper element that includes Expense Credit Card Transaction instance and data

Columns

Name Type References Description
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.
Transaction_Number String Expense Credit Card Transaction Number. This is the Expense Credit Card Transaction unique identifier
Expense_Credit_Card_Transaction_File_Reference String Expense Credit Card Transaction File Reference. This Expense Credit Card Transaction File loads all Expense Credit Card Transactions.
Credit_Card_Category_Reference_WID String Contains a unique identifier for an instance of an object.
Credit_Card_Category_Reference_Credit_Card_Category String Contains a unique identifier for an instance of an object.
Transaction_Date Date Expense Transaction Date
Expense_Payee String Expense Payee Employee Number for the Credit Card Transaction
Assignee_Reference_WID String Contains a unique identifier for an instance of an object.
Assignee_Reference_Applicant_ID String Contains a unique identifier for an instance of an object.
Assignee_Reference_Contingent_Worker_ID String Contains a unique identifier for an instance of an object.
Assignee_Reference_Employee_ID String Contains a unique identifier for an instance of an object.
Assignee_Reference_External_Committee_Member_ID String Contains a unique identifier for an instance of an object.
Billing_Date Date Expense Credit Card Billing Date
Posted_Date Date Transaction Posted Date
Merchant_Code_Reference_WID String Contains a unique identifier for an instance of an object.
Merchant_Code_Reference_Merchant_Code String Contains a unique identifier for an instance of an object.
Merchant_Code String Merchant Code
Merchant_Tax_ID String Merchant Tax ID
MIS_Industry_Code_Reference_WID String Contains a unique identifier for an instance of an object.
MIS_Industry_Code_Reference_Merchant_Code String Contains a unique identifier for an instance of an object.
MIS_Industry_Code String MIS Merchant Code
Market_Code String Market Code
Supplier_Reference_Number String Supplier Reference Number
DUNS_Number_for_Supplier String DUNS Number that uniquely identifies the Supplier.
Amount Decimal Transaction Extended Amount
Tax_Amount Decimal Expense Credit Card Extended Tax Amount
Sales_Taxes_Collected Bool Shows whether Sales Taxes were collected.
Source_Currency_Reference_WID String Contains a unique identifier for an instance of an object.
Source_Currency_Reference_Currency_ID String Contains a unique identifier for an instance of an object.
Source_Currency_Reference_Currency_Numeric_Code String Contains a unique identifier for an instance of an object.
Currency_Exchange_Rate Decimal Expense Credit Card Currency Exchange Rate
Converted_Amount Decimal Expense Credit Card Converted Amount
Converted_Tax_Amount Decimal Expense Credit Card Converted Tax Amount
Converted_Currency_Reference_WID String Contains a unique identifier for an instance of an object.
Converted_Currency_Reference_Currency_ID String Contains a unique identifier for an instance of an object.
Converted_Currency_Reference_Currency_Numeric_Code String Contains a unique identifier for an instance of an object.
Euro_Billed_Amount Decimal Expense Credit Card Euro Billed Amount
Euro_Billed_Tax_Amount Decimal Expense Credit Card Euro Billed Tax Amount
Transaction_Type_Code String Expense Credit Card Transaction Type Code
Transaction_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Transaction_Type_Reference_Credit_Card_Transaction_Type_ID String Contains a unique identifier for an instance of an object.
Financial_Category_Code String Expense Credit Card Financial Category Code
Charge_Description_Line_1 String Charge Description Line 1
Charge_Description_Line_2 String Charge Description Line 2
Cost_Center_Reference_WID String Contains a unique identifier for an instance of an object.
Cost_Center_Reference_Cost_Center_Reference_ID String Contains a unique identifier for an instance of an object.
Cost_Center_Reference_Organization_Reference_ID String Contains a unique identifier for an instance of an object.
Purchase_Order_Number String A unique Workday system generated Purchase Order Number. This number can be used to reference the instance of the Purchase Order.
Release_Number String Release Number against Purchase Order previously placed.
Expense_Credit_Card_ID String Expense Credit Card ID of Expense Credit Card for Expense Credit Card Transaction
Expense_Credit_Card_Token String Expense Credit Card Token for Expense Credit Card used in Expense Credit Card Transaction
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.
Employee_ID String Employee ID
Cardholder_Name String Cardholder Name
Account_Number String Account Number
Charge_Description String Charge Description
Number_of_Days_or_Nights Decimal Number of Days or Nights
Credit_Card_Merchant_Name String Credit Card Merchant Name
Credit_Card_Merchant_Location String Credit Card Merchant Location
Merchant_Address String Merchant Address
Merchant_City String Merchant City
Merchant_Country_Region String Merchant Country Region
Merchant_Postal_Code String Merchant Postal Code
Merchant_Country String Merchant Country
Merchant_Document_Number String Document Number
Arrival_Date Date Expense Credit Card Arrival Date
Departure_Date Date Expense Credit Card Departure Date
Reference_Number String Expense Credit Card Reference Number
Participant_Name String Expense Credit Card Participant Name
Daily_Rate Decimal Daily Rate
Domestic Bool Expense Credit Card Domestic
Ticket_Number String Ticket Number
Class_of_Service String Class of Service
Air_Routing String Air Routing
Air_Carrier_Code String Air Carrier Code
Origination_City String Origination City
Origination_State String Origination State
Origination_Country String Origination Country
Origination_Airport_Code String Air Travel Origination Airport Code for Credit Card Transaction
Destination_City String Destination City
Destination_State String Destination State
Destination_Country String Destination Country
Destination_Airport_Code String Air Travel Destination Airport Code for Credit Card Transaction
Class_of_Service_Reference_WID String Contains a unique identifier for an instance of an object.
Class_of_Service_Reference_Class_of_Service_Value String Contains a unique identifier for an instance of an object.
Class_of_Service_Reference_Spend_Data_ID String Contains a unique identifier for an instance of an object.
Credit_Card_Transaction_Status_Reference_WID String Contains a unique identifier for an instance of an object.
Credit_Card_Transaction_Status_Reference_Expense_Status_ID String Contains a unique identifier for an instance of an object.
Reason_for_Assignment String Reason for the assignment of Expense Credit Card Transaction

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