Tableau Connector for Workday

Build 20.0.7740

CustomerInvoices_Customer_Invoice_Line_Replacement_Data

Encapsulating element containing Customer Invoice Line data.

Columns

Name Type References Description
CustomerInvoice_Customer_Invoice_Reference_WID String

CustomerInvoices.Customer_Invoice_Reference_WID

The unique identifier type. Each
ID_Customer_Invoice_Line_Reference_WID String Contains a unique identifier for an instance of an object.
ID_Customer_Invoice_Line_Reference_Customer_Invoice_Line_Reference_ID String Contains a unique identifier for an instance of an object.
Customer_Invoice_Line_Reference_ID String The Customer Invoice Line Reference ID. This is the Customer Invoice Line unique identifier.
Line_Order String Optional line order. If specified, lines will be sorted by this value when displayed and when invoice is printed.
Intercompany_Affiliate_Reference_WID String Contains a unique identifier for an instance of an object.
Intercompany_Affiliate_Reference_Company_Reference_ID String Contains a unique identifier for an instance of an object.
Intercompany_Affiliate_Reference_Organization_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_Category_Reference_WID String Contains a unique identifier for an instance of an object.
Revenue_Category_Reference_Revenue_Category_ID String Contains a unique identifier for an instance of an object.
Line_Item_Description String This is the description that will print on the customer invoice line.
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 Address information
Tax_Applicability_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Applicability_Reference_Tax_Applicability_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.
Withholding_Tax_Code_Reference_WID String Contains a unique identifier for an instance of an object.
Withholding_Tax_Code_Reference_Tax_Code_ID String Contains a unique identifier for an instance of an object.
Withholding_Tax_Code_Reference_Withholding_Tax_Code_ID String Contains a unique identifier for an instance of an object.
Additional_Tax_Data String Element containing Tax Information
Customer_Contract_Line_Reference_WID String Contains a unique identifier for an instance of an object.
Customer_Contract_Line_Reference_Receivable_Contract_Line_Reference_ID String Contains a unique identifier for an instance of an object.
Customer_Contract_Line_Reference_Student_Sponsor_Contract_Line_ID String Contains a unique identifier for an instance of an object.
Quantity Decimal If this is blank, Workday will assume a value of 1. If invoice line has a quantity and unit price, then Workday will automatically calculate extended amount. But if the line references either a Service or Project-Based Purchase Order or Contract Line, the quantity must be blank and extended amount will not be calculated.
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.
Quantity_2 Decimal Second Quantity for Invoice Line, corresponding to the secondary Unit of Measure.
Unit_of_Measure_2_Reference_WID String Contains a unique identifier for an instance of an object.
Unit_of_Measure_2_Reference_UN_CEFACT_Common_Code_ID String Contains a unique identifier for an instance of an object.
Unit_of_Measure_2_Reference_UOM_EDI_Code_ID String Contains a unique identifier for an instance of an object.
Unit_Cost Decimal This is the Unit Price. If this is blank, Workday will default the unit price from the item if one is configured. If invoice line has a quantity and unit price, then Workday will automatically calculate extended amount.. But if the line references either a Service or Project-Based Purchase Order or Contract Line, the Unit Price must be blank.
Amount_Retained Decimal If the invoice line had retention applied from the Billing Schedule, Workday will calculate the retention amount using the retention percentage and the extended amount.
Amount_Released Decimal If the invoice line was created from a Retention Release on the Billing Schedule, Workday will calculate the amount released based on the amount available from the source invoice lines that contain retention.
Extended_Amount Decimal If the invoice line has a quantity and unit price, then Workday will automatically calculate extended amount.
Transaction_Date Date This will print on the delivered invoice formats for project time and project expense. There is no validation with any other dates in the invoice.
From_Date Date This will print in the date column of the delivered invoice format for project time. Workday will validate that 'From Date' is not greater than 'To Date' on this invoice line. There are no validations related to the from/to dates in the invoice header.
To_Date Date This will print in the date column of the delivered invoice format for project time. Workday will validate that 'To Date' is not less than 'From Date' on this invoice line. There are no validations related to the from/to dates in the invoice header.
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.
Project_Plan_Phase_Reference_WID String Contains a unique identifier for an instance of an object.
Project_Plan_Phase_Reference_Project_Plan_ID String Contains a unique identifier for an instance of an object.
Project_Plan_Task_Reference_WID String Contains a unique identifier for an instance of an object.
Project_Plan_Task_Reference_Project_Plan_ID String Contains a unique identifier for an instance of an object.
Deferred_Revenue Bool This field is mutually exclusive with Contract Line. When present this field will be persisted to indicate that this Invoice has a Deferred Value independent of any Contract or Award. If present in Response this indicates that the returned invoice is not associated to a Contract or Award.
Revenue_Recognition_Schedule_Reference String Returns the Revenue Recognition Schedule tied to the Customer Invoice Line.
Revenue_Recognition_Schedule_Template_Reference_WID String Contains a unique identifier for an instance of an object.
Revenue_Recognition_Schedule_Template_Reference_Revenue_Recognition_Schedule_Template_ID String Contains a unique identifier for an instance of an object.
Memo String Memo for the Invoice line. This is free form text.
Analytical_Amount Decimal The Analytical Amount for the Line. This amount is informational only and is not used in any delivered Workday calculations.
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.
Calculated_Tax_Amount Decimal Calculated Tax Amount to set for Taxable Document Line.

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