Tableau Connector for Workday

Build 20.0.7740

SupplierItems

Supplier Item Data

Columns

Name Type References Description
Supplier_Reference_WID String Contains a unique identifier for an instance of an object.
Supplier_Reference_Scout_ID String Contains a unique identifier for an instance of an object.
Supplier_Reference_Supplier_ID String Contains a unique identifier for an instance of an object.
Supplier_Reference_Supplier_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_Purchase_Item_ID String Contains a unique identifier for an instance of an object.
Catalog_Item_Reference_WID String Contains a unique identifier for an instance of an object.
Catalog_Item_Reference_Catalog_Item_ID String Contains a unique identifier for an instance of an object.
Manufacturer_Part_Number String Manufacturer Part Number and Manufacturer are used to identify a Purchase Item. It is valid only for Import Supplier Item. Get Supplier Item will not return any value in this field since a Purchase Item reference is already provided.
Manufacturer_Reference_WID String Contains a unique identifier for an instance of an object.
Manufacturer_Reference_Manufacturer_Name String Contains a unique identifier for an instance of an object.
Manufacturer_Reference_Manufacturer_Reference_ID String Contains a unique identifier for an instance of an object.
Supplier_Item_Identifier String Supplier item identifier
Item_Name String Item name. Informational only. Any value entered here will be ignored. You can leave blank since this is derived directly from the Purchase Item reference or Catalog Item reference
Item_Description String Supplier item description. Optional. If left blank, the description of the Catalog Item (if present) will be used. If blank and no Catalog Item, the Purchase Item description will be used. Any value set here will override the Purchase Item's description.
Supplier_Contract_Reference String Note: for Import Supplier Items, Supplier Contracts are not used and contract specific error validations are skipped if there is a Catalog Item reference. You cannot modify any contract information for a Catalog Item reference using this request.
Item_URL String Item URL. Cannot be changed if there is a linked catalog item. Any value entered in this field will be ignored for Import with a linked catalog item, and the catalog item's URL will be unchanged. For other supplier item without a linked catalog item, the URL can be changed.
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.
Sourcing_Priority Decimal Sourcing priority for the supplier item
Lead_Time Decimal Lead time for the supplier item
Calculate_Price_based_on_Conversion_Factor Bool Select to calculate price for Ordering and Just in Time UOMs based on the price entered for the Default Unit of Measure. When advanced pricing applies to a transaction with an undefined UOM, we calculate the price based on the conversion factor of the price rule. This enables you to load 1 price for 1 UOM.
Supplier_Item_Unit_of_Measure_Data String Supplier item UOM level data.
Advanced_Pricing_Data String Advanced Pricing rule data

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