Tableau Connector for Workday

Build 20.0.7740

SupplierInvoiceLines_Supplier_Invoice_Line_Replacement_Data

Supplier Invoice Line Replacement Data

Columns

Name Type References Description
SupplierInvoiceLine_Supplier_Invoice_Line_Reference_WID String

SupplierInvoiceLines.Supplier_Invoice_Line_Reference_WID

The unique identifier type. Each
Supplier_Invoice_Line_ID String Supplier Invoice Line Reference ID. This is the Supplier 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.
Purchase_Item_Reference_WID String Contains a unique identifier for an instance of an object.
Purchase_Item_Reference_Catalog_Item_ID String Contains a unique identifier for an instance of an object.
Purchase_Item_Reference_Purchase_Item_ID String Contains a unique identifier for an instance of an object.
Purchase_Item_Reference_Supplier_Item_ID String Contains a unique identifier for an instance of an object.
Item_Description String An optional description of the item, especially useful if only a Spend Category is selected for this line.
Purchase_Order_Line_Reference_WID String Contains a unique identifier for an instance of an object.
Purchase_Order_Line_Reference_Line_Number String Contains a unique identifier for an instance of an object.
Purchase_Order_Line_Reference_Purchase_Order_Line_ID String Contains a unique identifier for an instance of an object.
Supplier_Contract_Line_Reference_WID String Contains a unique identifier for an instance of an object.
Supplier_Contract_Line_Reference_Supplier_Contract_Line_Number String Contains a unique identifier for an instance of an object.
Customer_Invoice_Line_Reference_WID String Contains a unique identifier for an instance of an object.
Customer_Invoice_Line_Reference_Customer_Invoice_Line_Reference_ID String Contains a unique identifier for an instance of an object.
Supplier_Invoice_Line_to_Adjust_Reference_WID String Contains a unique identifier for an instance of an object.
Supplier_Invoice_Line_to_Adjust_Reference_Supplier_Invoice_Line_ID String Contains a unique identifier for an instance of an object.
Spend_Category_Reference_WID String Contains a unique identifier for an instance of an object.
Spend_Category_Reference_Spend_Category_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_Contact_Reference_WID String Contains a unique identifier for an instance of an object.
Ship_To_Contact_Reference_Contingent_Worker_ID String Contains a unique identifier for an instance of an object.
Ship_To_Contact_Reference_Employee_ID String Contains a unique identifier for an instance of an object.
Accounting_Treatment_Reference_WID String Contains a unique identifier for an instance of an object.
Accounting_Treatment_Reference_Accounting_Treatment_ID String Contains a unique identifier for an instance of an object.
Trackable_Item Bool This is the track items attribute on Spend Category, at the time the supplier invoice was submitted. As spend categories can change over time, this value is persisted for reporting purposes.
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.
Tax_Point_Date_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Point_Date_Type_Reference_Tax_Point_Date_Type_ID String Contains a unique identifier for an instance of an object.
Tax_Point_Date Date Tax Point Date
Tax_Rate_1_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Rate_1_Reference_Tax_Rate_ID String Contains a unique identifier for an instance of an object.
Tax_Rate_1_Reference_Withholding_Tax_Rate_ID String Contains a unique identifier for an instance of an object.
Tax_Recoverability_1_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Recoverability_1_Reference_Tax_Recoverability_Object_ID String Contains a unique identifier for an instance of an object.
Tax_Option_1_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Option_1_Reference_Tax_Option_ID String Contains a unique identifier for an instance of an object.
Tax_Rate_2_Reference String Reference to Tax Rate for Tax Code.
Tax_Recoverability_2_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Recoverability_2_Reference_Tax_Recoverability_Object_ID String Contains a unique identifier for an instance of an object.
Tax_Option_2_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Option_2_Reference_Tax_Option_ID String Contains a unique identifier for an instance of an object.
Tax_Rate_3_Reference String Reference to Tax Rate for Tax Code.
Tax_Recoverability_3_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Recoverability_3_Reference_Tax_Recoverability_Object_ID String Contains a unique identifier for an instance of an object.
Tax_Option_3_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Option_3_Reference_Tax_Option_ID String Contains a unique identifier for an instance of an object.
Tax_Rate_4_Reference String Reference to Tax Rate for Tax Code.
Tax_Recoverability_4_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Recoverability_4_Reference_Tax_Recoverability_Object_ID String Contains a unique identifier for an instance of an object.
Tax_Option_4_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Option_4_Reference_Tax_Option_ID String Contains a unique identifier for an instance of an object.
Tax_Rate_5_Reference String Reference to Tax Rate for Tax Code.
Tax_Recoverability_5_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Recoverability_5_Reference_Tax_Recoverability_Object_ID String Contains a unique identifier for an instance of an object.
Tax_Option_5_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Option_5_Reference_Tax_Option_ID String Contains a unique identifier for an instance of an object.
Tax_Rate_6_Reference String Reference to Tax Rate for Tax Code.
Tax_Recoverability_6_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Recoverability_6_Reference_Tax_Recoverability_Object_ID String Contains a unique identifier for an instance of an object.
Tax_Option_6_Reference_WID String Contains a unique identifier for an instance of an object.
Tax_Option_6_Reference_Tax_Option_ID String Contains a unique identifier for an instance of an object.
Packaging_String String Packaging String associated with the Item specified on the Supplier Invoice or Adjustment Line. This is not applicable to Ad Hoc payment lines.
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.
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.
Extended_Amount Decimal If the invoice line has a quantity and unit price, then Workday will automatically calculate extended amount.
Retention_Amount Decimal The amount to retain from this invoice line.
Payment_Amount Decimal The Payment Amount is equal to the extended amount minus the retention amount. This field only returns values.
Budget_Date Date Use this field to override the Budget Date from the supplier invoice header.
Prepaid Bool Prepaid flag at the Line level
Supplier_Contract_Reference_WID String Contains a unique identifier for an instance of an object.
Supplier_Contract_Reference_Supplier_Contract_ID String Contains a unique identifier for an instance of an object.
Memo String Memo for the Invoice line. This is free form text.
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.
Billable Bool Billable Flag at Invoice Line Level
Worktag_Split_Template_Reference_WID String Contains a unique identifier for an instance of an object.
Worktag_Split_Template_Reference_Worktag_Allocation_Template_ID String Contains a unique identifier for an instance of an object.
Supplier_Invoice_Split_Line_Data String Encapsulating element containing Supplier Invoice Line Split data.

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