Tableau Connector for Workday

Build 20.0.7740

UsageBasedTransactions_Usage_Based_Transaction_Data

Contains all References and Attributes to represent a complete Usage Based Transaction.

Columns

Name Type References Description
UsageBasedTransaction_Usage_Based_Transaction_Reference_WID String

UsageBasedTransactions.Usage_Based_Transaction_Reference_WID

The unique identifier type. Each
Usage_Based_Transaction_ID String Usage Based Transaction Reference ID. This is the Usage Based Transaction Unique Identifier.
Submit_for_Review Bool Submit for Review will automatically submit the usage based transaction so it will be available in the Review Usage Based Transaction Task. Setting the value to 1 will have the same effect as Submitting the transaction in Record Usage Based Transaction Task. To successfully submit, all fields that are required online are also required in the request.
Transaction_Date Date The Usage Based Transaction transaction date.
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.
Contract_Line_Reference_WID String Contains a unique identifier for an instance of an object.
Contract_Line_Reference_Receivable_Contract_Line_Reference_ID String Contains a unique identifier for an instance of an object.
Customer_Reference_WID String Contains a unique identifier for an instance of an object.
Customer_Reference_Customer_ID String Contains a unique identifier for an instance of an object.
Customer_Reference_Customer_Reference_ID String Contains a unique identifier for an instance of an object.
Sales_Item_Reference_WID String Contains a unique identifier for an instance of an object.
Sales_Item_Reference_Sales_Item_ID String Contains a unique identifier for an instance of an object.
Revenue_Start_Date Date Revenue Start Date for the Usage Based Transaction.
Revenue_End_Date Date Revenue End Date for the Usage Based Transaction.
Description String The Description for the Usage Based Transaction.
Quantity Decimal The Quantity for the Usage Based Transaction.
Unit_of_Measure_Reference_WID String Contains a unique identifier for an instance of an object.
Unit_of_Measure_Reference_UN_CEFACT_Common_Code_ID String Contains a unique identifier for an instance of an object.
Unit_of_Measure_Reference_UOM_EDI_Code_ID String Contains a unique identifier for an instance of an object.
Rate Decimal Optional Rate which if provided will override the Usage Based Rate specified for the contract line. If you are providing a Rate you must specify the Contract Line and Currency as well.
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.
Default_Worktags_Reference String Usage Based Transaction Default Worktags Reference
Ship_To_Customer_Reference_WID String Contains a unique identifier for an instance of an object.
Ship_To_Customer_Reference_Customer_ID String Contains a unique identifier for an instance of an object.
Ship_To_Customer_Reference_Customer_Reference_ID String Contains a unique identifier for an instance of an object.
Ship_To_Address_Reference_WID String Contains a unique identifier for an instance of an object.
Ship_To_Address_Reference_Address_ID String Contains a unique identifier for an instance of an object.
Ship_To_Address_Data String The exact address specified in the address reference stored on the Usage Based Transaction.
File_Content String File content in binary format.
Comment String Comment

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