Tableau Connector for Workday

Build 20.0.7740

ConsolidatedInvoices

Consolidated Invoice Data

Columns

Name Type References Description
Consolidated_Invoice_ID String Consolidated Invoice ID. This is the Consolidated Invoice unique identifier.
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.
Include_Child_Customers Bool Includes Child Customers boolean for consolidated invoice.
Bill_To_Address_Reference_WID String Contains a unique identifier for an instance of an object.
Bill_To_Address_Reference_Address_ID String Contains a unique identifier for an instance of an object.
Bill_To_Contact_Reference String Bill-To Contact for Consolidated Invoice
Invoice_Number String This is the document number for the consolidated invoice.
Invoice_Date Date Consolidated Invoice Date for Consolidated Invoice
Due_Date Date If a date is provided, it will override the due date that Workday automatically determines based on the invoice date and payment terms.
Payment_Terms_Reference_WID String Contains a unique identifier for an instance of an object.
Payment_Terms_Reference_Payment_Terms_ID String Contains a unique identifier for an instance of an object.
Payment_Type_Reference String Payment Type for Consolidated Invoice
Document_Payment_Status_Reference_WID String Contains a unique identifier for an instance of an object.
Document_Payment_Status_Reference_Document_Payment_Status_ID String Contains a unique identifier for an instance of an object.
Document_Status_Reference_WID String Contains a unique identifier for an instance of an object.
Document_Status_Reference_Document_Status_ID String Contains a unique identifier for an instance of an object.
Amount_Due Decimal Shows a Consolidated Invoice's Due Amount.
Memo String Memo for Consolidated Invoice
Net_Invoice_Amount Decimal Shows a Consolidated Invoice's Net Invoice Amount.
Tax_Amount Decimal Shows a Consolidated Invoice's Tax Amount.
Total_Invoice_Amount Decimal Shows a Consolidated Invoice's Total Invoice Amount.
Withholding_Tax_Amount Decimal Shows a Consolidated Invoice's Withholding Tax Amount.
Customer_Invoice_Reference String Customer Invoice for Consolidated Invoice

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