Tableau Connector for Workday

Build 20.0.7740

PurchaseItems_Supplier_Item_Data

Associated Supplier Catalog Item for the Purchase Item.

Columns

Name Type References Description
PurchaseItem_Purchase_Item_Reference_WID String

PurchaseItems.Purchase_Item_Reference_WID

The unique identifier type. Each
ID String Reference ID for the Supplier Item.
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.
Supplier_Item_Reference_WID String Contains a unique identifier for an instance of an object.
Supplier_Item_Reference_Supplier_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.
Supplier_Item_Identifier String Catalog or Supplier Item Identifier
Item_Description String Supplier or Catalog Item Description.
Sourcing_Priority Decimal Sourcing Priority of the Catalog Item.
Item_URL String Catalog or Supplier Item URL
Supplier_Contract_Reference String Supplier contract(s) for the Catalog or Supplier item
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.
Lead_Time Decimal Catalog or Supplier Item Lead Time
Packaging_String String Packaging String for Catalog Item linked to Purchase Item. Solely used for the Get operation (not the Put operation).
Inactive Bool Used to inactivate an existing Catalog or Supplier Item
Pricing_Effective_Date Date Effective date for the UOM. For Supplier items, this field can be updated at anytime, but for Catalog Items, this field can only be updated when you enable catalog data and pricing for your purchase items.
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_Ordering_Pricing_Data String Bulk UOM Data for Catalog or Supplier Item.
Supplier_Item_JIT_Pricing_Data String JIT UOM Data for Catalog or Supplier Item.
Pricing_History String Pricing History cannot be updated.
Advanced_Pricing_Data String Supplier specific Advanced Pricing rule. Can be an update of existing rule or a new one.

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