Tableau Connector for Workday

Build 20.0.7740

ビュー

ビューは、カラムと疑似カラムで構成されます。ビューは、データを示すという点でテーブルに似ていますが、ビューでは更新はサポートされません。通常、ビューとして表されるエンティティは、読み取り専用のエンティティです。多くの場合、これらのデータはストアドプロシージャを使用することで更新できます(その機能がデータソースに適用できる場合)。

ビューに対しては、通常のテーブルと同じようにクエリを実行でき、このときに返されるデータも同様です。テーブルおよびストアドプロシージャの詳細については、このヘルプドキュメントの該当エントリを参照してください。

CData Tableau Connector for Workday ビュー

Name Description
AdHocProjectTransactions Ad Hoc Project Transaction Data
AlternateContractRevenueAllocationRules Element contains all data necessary to create or update a Revenue Allocation Scenario Configuration.
AlternateCustomerContracts Element content containing Alternate Customer Contract Document Element.
AlternateCustomerContracts_Attachment_Data Encapsulating element containing all Business Document Attachment data.
AlternateCustomerContracts_Customer_Contract_Line_Replacement_Data Customer Contract Line Data Element
AlternateCustomerContracts_Ship_To_Address_Data Address information
AwardAdditionalData Wrapper element containing the award additional data for requested references or criteria, and for requested response group.
AwardAttachmentSecuritySegment The award attachment security segment data.
AwardCreditDefinitions Contains all References and Attributes to represent a complete award credit definition.
AwardGroups Wrapper Element that includes all data for a single Award Group.
AwardLifecycleStatuses Contains all References and Attributes to represent a complete Award Lifecycle Status.
AwardLifecycleStatusUpdateRules Lifecycle Status Update Rule Data contains all of the data to describe an Lifecycle Status Update Rule.
AwardLineAdditionalData Contains the award line additional data.
AwardProposalLifecycleStatuses Contains all References and Attributes to represent a complete Award Proposal Lifecycle Status.
AwardProposals Award Proposal Data element
AwardProposalSubmissionTypes Contains all References and Attributes to represent a complete Award Proposal Submission Type.
Awards Award Element
AwardSchedules Contains all References and Attributes to represent a complete Award Schedule.
Awards_Attachment_Data Encapsulating element containing all Business Document Attachment data.
Awards_Award_Budget_Data Contains the default setup Budget information for an Award.
Awards_Award_Credit_Data Contains the award credit Allocation Information for an Award.
Awards_Award_Line_Data Award Line Data Element
Awards_Award_Personnel_Data Award Personnel Data Element
Awards_NSF_Code_Allocation_Data NSF Code Allocation Reference
Awards_Special_Condition_Data Special Condition Data Element
AwardTaskListTemplates Award Task List Template Element
AwardTaskListTemplates_Award_Task_Template_Data Award Task Template Data
AwardTasks Element containing all data for one Award Task.
AwardTaskStatuses Element containing Award Task Status Data
AwardTasks_Attachment_Data Encapsulating element containing all Business Document Attachment data.
AwardTasks_Role_Assignment_Data Contains the Role Assignment information for an Award Task.
AwardTaskTypeGroups This element contains all of the data to describe an Award Task Type Group.
BillingSchedules Billing Schedule Data
BillingScheduleTemplates Billing Schedule Template Data
BudgetCheckOptionsSet The budget check options set data.
BusinessConnections Contains all References and Attributes to represent a complete Business Connection.
BusinessEntityContacts Business Entity Contact Data
CashSales Cash Sale Data
CatalogofFederalDomesticAssistance Catalog of Federal Domestic Assistance Data
CompaniesasBusinessEntities Company as Business Entity Data contains essential information about Company as Business Entity.
CompanyCreditorIdentifiers Contains the fields associated with a Company Creditor Identifier as used for Direct Debit Mandates.
ConsolidatedInvoices Consolidated Invoice Data
ContactTypes Element containing data for a single Contact Type.
ContractLineFees Element Container for Contract Line Fee Data
ContractRateSheets Contract Rate Sheet details
ContractRateSheets_Billing_Rate_Rule_Type_Group_Data Contains Billing Rate Rule Type Groups.
ContractRateSheets_Contract_Rates Contains Contract Rates
ContractRateSheets_Time_Definitions Time Definition details the Contract Rate Sheet
CostTypes Cost Type Data
CreditCardAuthorization Element containing data for Credit Card Authorization
CustomerCategories Customer Category Data
CustomerContractAmendments Element content containing Customer Contract Amendment Document Element
CustomerContractAmendments_Customer_Contract_Data Customer Contract Amendment Data Document
CustomerContractChecklistTemplates Element container for Customer Contract Checklist Template Data
CustomerContractDiscountandPremium Customer Contract Discounts and Premiums Data
CustomerContracts Element content containing Customer Contract Document Element
CustomerContracts_Attachment_Data Encapsulating element containing all Business Document Attachment data.
CustomerContracts_Customer_Contract_Line_Replacement_Data Customer Contract Line Data Element
CustomerContracts_Ship_To_Address_Data Address information
CustomerContractTemplates Customer Contract Template Data
CustomerDateMilestones Customer Date Milestone Data
CustomerDeposits Customer Deposit Data
CustomerGroups Customer Group
CustomerInvoiceAdjustments Customer Invoice Adjustment Data
CustomerInvoices Element content containing Customer Invoice Document element
CustomerInvoices_Bill_To_Address_Data Address information data for the Bill-To Address
CustomerInvoices_Business_Process_Attachment_Data Element for the attachments pertaining to a Event entered through a web service.
CustomerInvoices_Customer_Invoice_Line_Replacement_Data Encapsulating element containing Customer Invoice Line data.
CustomerInvoices_Invoice_Attachment_Data This element provides all data related to attachments including, attachment file name, comment, provide to customer, print with customer, customer invoice line reference and expense report/item reference
CustomerInvoices_Note_Data Includes Notes that have been made for a business object. On a Get operation, all existing Notes will be populated. On a Put or Submit operation, any note information on the request will be added as new notes. Existing notes cannot be updated on a Put or Submit request.
CustomerInvoices_Ship_To_Address_Data Address information
CustomerInvoices_Tax_Code_Data Tax Data by Tax Authority and Tax Code. For Customer Invoice Documents and Cash Sales tax data will always be calculated from the line data regardless of what is populated in Tax Rate Application Data. For Purchase Orders, Supplier Invoice Documents and Ad hoc Payments, if data is in Tax Rate Application Data, then that will be the tax information that is saved. Otherwise, the tax will be calculated from the lines.
CustomerPayments Customer Payment instance and data.
CustomerPayments_Customer_Payment_Remittance_Advice_Data Remittance Advice for this Customer Payment, utilized in Workday's Auto-Application logic in determining which Customer Invoices to apply this payment to.
CustomerPortalPaymentSession Element containing all Customer Portal Payment Session data
CustomerRefunds Customer Refund Data
CustomerRequests Customer Request Data
CustomerRequests_Address_Data Address information
CustomerRequests_Email_Address_Data Email Address Information
CustomerRequests_Instant_Messenger_Data Instant Messenger Information
CustomerRequests_Phone_Data Phone Information
CustomerRequests_Web_Address_Data Web Address Information
Customers Customer wrapper element that contains the Customer
Customers_Address_Data Address information
Customers_Business_Entity_Alternate_Name_Data Business Entity Alternate Name Data
Customers_Business_Entity_Attachment_Data Business Entity Attachment Data
Customers_Credit_Card_Data Credit Card Data is the Customer Credit Card Information data.
Customers_Customer_Status_Data Retrieves customer status. This field is read only and returns the current value.
Customers_Email_Address_Data Email Address Information
Customers_Instant_Messenger_Data Instant Messenger Information
Customers_Note_Data Includes Notes that have been made for a business object. On a Get operation, all existing Notes will be populated. On a Put or Submit operation, any note information on the request will be added as new notes. Existing notes cannot be updated on a Put or Submit request.
Customers_Phone_Data Phone Information
Customers_Proposed_Customer_Status_Data Contains proposed changes to customer status.
Customers_Related_Worktags_by_Type_Data Allowed and Default Related Worktags Data by Worktag Type.
Customers_Settlement_Account_Data Settlement Account Data is the Customer Settlement Account detailed data.
Customers_Tax_ID_Data Tax ID values for current customer.
Customers_Tax_Status_Data Tax Status Data includes: Country, Transaction Tax Status, and Withholding Tax Status.
Customers_Web_Address_Data Web Address Information
DailyRateTransactionGroupings Element to add or update Daily Rate Transaction Grouping Data
DeferredCostSchedules Element Container for Deferred Cost Schedule Data
DeferredCostTransactions Contains all References and Attributes to represent a complete Deferred Cost Transaction.
DunningLevelGroups Dunning level group
DunningLevelGroups_Dunning_Level_Data dunning levels
ElectronicInvoicingAcknowledgements An element containing Electronic Invoicing Acknowledgement response data.
ExternalWorkers External Worker Data
FacilitiesandAdminCostRateTypeTypes Facilities and Admin Cost Rate Type Type Data
FacilitiesandAdministrationBasisTypes Element containing data for a single Basis Type.
FacilitiesandAdministrationExceptions This element contains all the data necessary to describe a Facilities and Administration Exception in Workday
FacilitiesandAdministrationRateAgreements The Request for creating a new Rate Agreement.
FacilitiesandAdministrationRevenueAllocationProfiles Contains all references and attributes to represent a complete facilities and administration revenue allocation profile.
FacilitiesandAdministrationWaivedExpenseAllocationProfiles This element contains all the data necessary to describe a Facilities and Administration Waived Expense Allocation Profile in Workday
FacilitiesandAdminObjectClassMappings Contains all References and Attributes to represent a complete Facilities and Administration Object Class Mapping
HoldReasons Hold Reason Data
IntercompanyCustomerContract Customer Contract Intercompany Data to Create/Edit/Get for Intercompany Contract.
MerchantCustomerProfile Element content containing Customer Credit Card Profile element
MerchantCustomerProfile_Bill_To_Address_Information Address information
Opportunities Element content containing Opportunity element
Opportunities_Opportunity_Cost_Data Element content contains Opportunity Cost Data element
Opportunities_Opportunity_Line_Replacement_Data Element contains Opportunity Line Data
OrderFulfillmentTransactions Contains all References and Attributes to represent a complete Order Fulfillment Transaction.
PercentCompleteConfigurations The data for the Percent Complete Configuration
PercentCompleteforRevenue Percent Complete Project Data
ProjectBillingRateSheetConfigurationLines Project Billing Rate Sheet Configuration Line data details
ProjectBillingRateSheets Project Billing Rate Sheet data details
ProjectBillingRateSheets_Project_Billing_Rates Project Billing Rate Sheet data details
ProjectBillingRateSheets_Time_Definitions Time Definition details the Project Billing Rate Sheet
ProjectRateCategories Project Rate Category Element
ProjectRateCategories_Project_Rate_Category_Members Project Rate Category Member Data
Prospects Prospect Data
Prospects_Address_Data Address information
Prospects_Email_Address_Data Email Address Information
Prospects_Instant_Messenger_Data Instant Messenger Information
Prospects_Phone_Data Phone Information
Prospects_Web_Address_Data Web Address Information
RevenueAdjustmentReasons Revenue Adjustment Reason Data
RevenueAllocationConfigurations All Revenue Allocation System Configurations matching the Get Revenue Allocation Configuration request criteria.
RevenueAllocationConfigurations_Override_Revenue_Allocation_Configuration_Line_Data Defines the Revenue Allocation Configuration Lines that will override the Default Revenue Allocation Configuration Line.
RevenueCategories Revenue Category
RevenueCategories_Related_Worktags_by_Type_Data Allowed and Default Related Worktags Data by Worktag Type.
RevenueCategoryHierarchies Revenue Category Hierarchy Data
RevenueRecognitionSchedules Revenue Recognition Schedule Data
RevenueRecognitionScheduleTemplates Wrapper Element that includes Revenue Recognition Schedule Template Instance and Data
SalaryCaps Award Salary Cap Data
SalaryOverTheCapTypes Salary Over The Cap Type
SalesItemFairValuePriceLists Sales Item Fair Value Price List Response Data Element.
SalesItemFairValuePriceLists_Sales_Item_Fair_Value_Price_List_Snapshot_Data Sales Item Fair Value Price List Snapshot Data element.
SalesItemGroups Sales Item Group
SalesItemPriceLists Sales Item Price List Response Data Element.
SalesItemPriceLists_Sales_Item_Price_List_Snapshot_Data Sales Item Price List Snapshot Data element.
SalesItems Sales Item
SalesItems_Related_Worktags_by_Type_Data Allowed and Default Related Worktags Data by Worktag Type.
SpecialConditionTypes Contains a single special condition type reference and all data for the special condition type.
Sponsors This Element contains Sponsor relationships and attributes
SubawardRiskAssessments Subaward Risk Assessment Data
Subawards Subaward element.
Subawards_Attachment_Data Attachment Data
Subawards_Subaward_Contact_Data The Subaward Contact Data related to the Subaward.
SubrecipientRiskRecords Element containing a Subrecipient Risk Record Reference and all data for the single Subrecipient Risk Record.
SubrecipientRiskRecords_Attachment_Data Encapsulating element containing all Business Document Attachment data.
Subrecipients Element containing data for a single Subrecipient.
UsageBasedTransactions The response for a request for Usage Based Transaction data.
UsageBasedTransactions_Usage_Based_Transaction_Data Contains all References and Attributes to represent a complete Usage Based Transaction.
UsageBillingRates Usage Billing Rate details.
UsageBillingRates_Usage_Billing_Rate_Rule_Type_Group_Data Contains Usage Billing Rate Rule Type Groups.
WorkerBillingRates Worker Billing Rate Data. Only one row should exist per worker.
WorkerBillingRates_Billing_Rate_Data Element containing billing rate for an effective date
WorkerRuleBillingRates Worker Rule Billing Rate Data Element

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