Tableau Connector for Workday

Build 20.0.7740

CashSales

Cash Sale Data

Columns

Name Type References Description
Cash_Sale_ID String Cash Sale ID. This is the Cash Sale unique identifier
Submit Bool Submit for Approval is a boolean flag indicating if the transaction is to be submitted or saved in draft mode. If this flag is set, the transaction will be submitted, otherwise the transaction is saved in draft.
Cash_Sale_Number String Sequence number for cash sales. To sequence cash sales, set up the ID Generator for Cash Sale in the Edit Tenant Setup - Financials task. This field is ignored in a Submit Cash Sale request.
Locked_in_Workday Bool Set to True to disable editing and canceling the Cash Sale inside the Workday application. Cash Sale can only be updated from the web service
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.
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.
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.
Customer_Reference_Sponsor_ID String Contains a unique identifier for an instance of an object.
Customer_Reference_Sponsor_Reference_ID String Contains a unique identifier for an instance of an object.
Customer_Reference_Student_Financial_Account_ID String Contains a unique identifier for an instance of an object.
Tax_Code_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Code_Reference_Tax_Code_ID String Contains a unique identifier for an instance of an object.
Tax_Code_Reference_Withholding_Tax_Code_ID String Contains a unique identifier for an instance of an object.
Cash_Sale_Date Date Cash Sale Date
Customer_Invoice_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Customer_Invoice_Type_Reference_Customer_Invoice_Type_ID String Contains a unique identifier for an instance of an object.
From_Date Date Please note that 'From date' and 'To Date' in the invoice header are not used to validate any dates on the invoice lines.
To_Date Date Please note that 'From date' and 'To Date' in the invoice header are not used to validate any dates on the invoice lines.
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.
Check_Number String Check Number
Record_Deposit Bool Boolean flag for Record Deposit
Bank_Account_Reference_WID String Contains a unique identifier for an instance of an object.
Bank_Account_Reference_Bank_Account_ID String Contains a unique identifier for an instance of an object.
Bank_Account_Reference_Petty_Cash_Account_ID String Contains a unique identifier for an instance of an object.
Deposit_Reference_Number String Free form text field for a Cash Sale Reference Number.
Currency_Rate_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Currency_Rate_Type_Reference_Currency_Rate_Type_ID String Contains a unique identifier for an instance of an object.
Currency_Rate_Override Decimal Currency Conversion Rate Data
Payment_Memo String This transaction header memo will print on the delivered transaction. It is optional freeform text
Control_Total_Amount Decimal This is the expected invoice total including tax. It is optional. An invoice cannot be submittted for approval if it has a non-zero control total that does not equal the sum of the extended amount for all invoice lines plus tax.
Cash_Sale_Line_Replacement_Data String Customer Invoice Line Data. A Customer Invoice may have multiple lines.
Attachment_Data String Encapsulating element containing all Business Document Attachment data.
Tax_Code_Data String 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.
Comment String Free form comment regarding the business process.
Worker_Reference_WID String Contains a unique identifier for an instance of an object.
Worker_Reference_Contingent_Worker_ID String Contains a unique identifier for an instance of an object.
Worker_Reference_Employee_ID String Contains a unique identifier for an instance of an object.
Business_Process_Attachment_Data String Element for the attachments pertaining to a Event entered through a web service.

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