Tableau Connector for Workday

Build 20.0.7740

CustomerInvoices

Element content containing Customer Invoice Document element

Columns

Name Type References Description
Customer_Invoice_Reference_WID String Contains a unique identifier for an instance of an object.
Customer_Invoice_Reference_Customer_Invoice_Reference_ID String Contains a unique identifier for an instance of an object.
Customer_Invoice_ID String Customer Invoice ID. This is the Customer Invoice 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.
Locked_in_Workday Bool Set to True to disable editing and canceling the invoice inside the Workday application. Invoice 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.
Sold_To_Customer_Reference_WID String Contains a unique identifier for an instance of an object.
Sold_To_Customer_Reference_Customer_ID String Contains a unique identifier for an instance of an object.
Sold_To_Customer_Reference_Customer_Reference_ID String Contains a unique identifier for an instance of an object.
Sold_To_Customer_Reference_Sponsor_ID String Contains a unique identifier for an instance of an object.
Sold_To_Customer_Reference_Sponsor_Reference_ID String Contains a unique identifier for an instance of an object.
Sold_To_Customer_Reference_Student_Financial_Account_ID String Contains a unique identifier for an instance of an object.
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.
Populate_with_Default_Bill_To_Contacts Bool When Populate with Default Bill-To Contacts is set to true, it will populate Bill To Contact with the Default Values.
Bill_To_Contact_Reference String Billable Entity Contact for Customer Invoice. Contact must be related to Billable Entity and have an Invoice Email Address.
Award_Billing_Sequence_Number Decimal Award Billing Sequence Number. This information is for outbound purposes only and is not processed on inbound Workday Web Services requests.
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.
Billable_Project_Reference_WID String Contains a unique identifier for an instance of an object.
Billable_Project_Reference_Project_ID String Contains a unique identifier for an instance of an object.
Invoice_Number String If adding a new invoice, then make the Invoice Number the same value as Reference ID. If updating an existing invoice, then make it the same value as the Reference ID of that invoice. If you do not make the Invoice Number the same as Reference ID, then duplicate Invoice Numbers for different invoices may be created. The Reference ID is the only value checked as a unique identifier. Note that the name of the Reference ID is different for each invoice type: e.g. Supplier Invoice ID, Supplier Invoice Adjustment ID, Customer Invoice Adjustment ID, and Customer Invoice ID.
Gapless_Invoice_Number String The associated customer invoice is in approved status.
Consolidated_Invoice_Reference_WID String Contains a unique identifier for an instance of an object.
Consolidated_Invoice_Reference_Consolidated_Invoice_ID String Contains a unique identifier for an instance of an object.
Invoice_Date Date If this is left blank, Workday will populate invoice date with the current date.
Accounting_Date Date Override date for Accounting.
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.
Due_Date_Override Date If a date is provided, it will override the due date that Workday automatically determines based on the invoice date and payment terms.
Collection_Date Date The date the Customer Invoice is put into collection. If this field is populated when updating an existing invoice, the invoice will be put into collection.
Payment_Amount_Promised Decimal The amount the customer promised to pay when the Customer Invoice is put into collection. It is optional.
Collection_Reason_Reference_WID String Contains a unique identifier for an instance of an object.
Collection_Reason_Reference_Collection_Code_ID String Contains a unique identifier for an instance of an object.
Followup_Date Date The date the Customer Invoice should be followed up. This field is optional and can be entered in maintain collection, maintain dispute or put on hold.
Dispute_Date Date The date the Customer Invoice is put into dispute. If this field is populated when updating an existing invoice, the invoice will be put into dispute.
Dispute_Amount Decimal The amount the Customer Invoice is in dispute over. It is optional.
Dispute_Reason_Reference String The reason the Customer Invoice is put into dispute.
Risk_Score Decimal Value between 0 and 1 displays for each invoice when you set up the Customer Collections Insight Application.
Risk_Score_Date Date The date the customer collections risk score was last updated. Displays on the customer invoice.
Control_Amount_Total 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.
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_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.
Additional_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Additional_Type_Reference_Additional_Reference_Type_ID String Contains a unique identifier for an instance of an object.
Additional_Reference_Number String The reference number that is encoded with key payment information on the invoice document.
Payment_Status String Shows the Customer Invoice Document's Payment Status.
Document_Status String Document Status for Customer Invoice
Amount_Due Decimal Shows a Customer Invoice Document's Due Amount, assuming it is not cancelled.
Statutory_Invoice_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Statutory_Invoice_Type_Reference_Invoice_Type_ID String Contains a unique identifier for an instance of an object.
Statutory_Invoice_Type_Reference_Spend_Data_ID String Contains a unique identifier for an instance of an object.
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.
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.
Customer_PO_Number String This PO number will print on the delivered customer invoice. It is optional freeform text. This is not a Workday Purchase Order Reference ID.
Finance_Charge Bool Retrieves a flag to indicate that the invoice is generated from Interest and Late Fee calculation run. When the flag has no value, the invoice generated is a regular invoice.
Latest_Interest_and_Late_Fee_Process_Date Date Retrieves the latest processing date of the Interest and Late Fee Calculation Run.
Interest_Rule_Reference_WID String Contains a unique identifier for an instance of an object.
Interest_Rule_Reference_Interest_and_Late_Fee_Rule_ID String Contains a unique identifier for an instance of an object.
Late_Fee_Rule_Reference_WID String Contains a unique identifier for an instance of an object.
Late_Fee_Rule_Reference_Interest_and_Late_Fee_Rule_ID String Contains a unique identifier for an instance of an object.
Exempt Bool A flag when set to true, excludes the interest and late fee charges.
On_Hold Bool If this is set to 'TRUE' the invoice will be put on hold.
Is_Excluded_from_Dunning_Letter Bool This invoice will be excluded from Print Dunning Letters if this flag is TRUE.
Include_Customer_Worktags Bool Include Default Customer Worktags if this flag is TRUE
Worktags_Reference String Reference to existing worktags. Worktags are a way to mark tasks and business objects to make them easier to access and summarize. Each transaction can include one value for each worktag type and is subject to configurable validation when submitted for approval.
Document_Link String Document Link for Customer Invoice
Memo String This transaction header memo will print on the delivered transaction. It is optional freeform text
Company_Tax_ID_Reference_IID String Contains a unique identifier for an instance of an object.
Company_Tax_ID_Reference_WID String Contains a unique identifier for an instance of an object.
Customer_Tax_ID_Reference_IID String Contains a unique identifier for an instance of an object.
Customer_Tax_ID_Reference_WID String Contains a unique identifier for an instance of an object.
Currency_Rate_Type_Override_Reference_WID String Contains a unique identifier for an instance of an object.
Currency_Rate_Type_Override_Reference_Currency_Rate_Type_ID String Contains a unique identifier for an instance of an object.
Currency_Rate_Date_Override Date For a foreign currency invoice, this allows you to override the date used to look up the currency conversion rate. The default date is normally the same as the invoice date.
Currency_Rate_Manual_Override_Reference Decimal For a foreign currency invoice, this allows you to directly override the currency conversion rate that will be used.
Tax_Calculation_Details String Text field to summarize Tax Calculation Details.
Total_Attachment_Size Decimal Sum of all attachments
Total_Size_of_Attachments_Available_To_Customers Decimal Sum of attachments that have the Provide to Customer flag set to yes.
Total_Printable_Attachment_Size Decimal Sum of attachments that have the Print With Flag flag set to yes.
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.
Direct_Debit_Mandate_Reference_WID String Contains a unique identifier for an instance of an object.
Direct_Debit_Mandate_Reference_Direct_Debit_Mandate_ID String Contains a unique identifier for an instance of an object.
Pre_notification_Sent_Date Date Pre-notification Sent Date. This information is for outbound purposes only and is not processed on inbound Workday Web Services requests.
Cancel_Accounting_Date Date The accounting date when the customer invoice was canceled.

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