Tableau Connector for Workday

Build 20.0.7740

Receipts

Receipt Data

Columns

Name Type References Description
Receipt_Number String Document Number
Locked_in_Workday Bool Set to True to disable both editing this Receipt and creating a Receipt Adjustment inside the Workday application.
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.
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.
Bill_of_Lading String Bill of Lading recorded on Receipt. This field is outbound only; any data submitted will be ignored.
Requester_Reference_WID String Contains a unique identifier for an instance of an object.
Requester_Reference_Contingent_Worker_ID String Contains a unique identifier for an instance of an object.
Requester_Reference_Employee_ID String Contains a unique identifier for an instance of an object.
Requisition_Reference_WID String Contains a unique identifier for an instance of an object.
Requisition_Reference_Requisition_Number String Contains a unique identifier for an instance of an object.
Tracking_Number String Tracking Number recorded on Receipt. This field is outbound only; any data submitted will be ignored.
Supplier_Order_Ref String Supplier Order Reference recorded on Receipt.This field is outbound only; any data submitted will be ignored.
Shipment_Date_Time Datetime Shipment date/time recorded on ASN which receipt was created from. This field is outbound only; any data submitted will be ignored.
Shipment_Contact String Shipment Contact recorded on ASN which receipt was created from. This field is outbound only; any data submitted will be ignored.
Bill_of_Lading_Quantity Decimal Bill of Lading Quantity recorded on Receipt. This field is outbound only; any data submitted will be ignored.
License_Plate String License Plate recorded on ASN which receipt was created from. This field is outbound only; any data submitted will be ignored.
Shipment_Ref String Shipment Reference recorded for Receipt. This field is outbound only; any data submitted will be ignored.
Document_Status_Reference_WID String Contains a unique identifier for an instance of an object.
Document_Status_Reference_Document_Status_ID String Contains a unique identifier for an instance of an object.
Supplier_Reference_WID String Contains a unique identifier for an instance of an object.
Supplier_Reference_Contingent_Worker_ID String Contains a unique identifier for an instance of an object.
Supplier_Reference_Internal_Service_Provider_ID String Contains a unique identifier for an instance of an object.
Supplier_Reference_Internal_Service_Provider_Reference_ID 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.
Document_Date Date Document Date
Last_Updated Datetime Date and Time that the Receipt was Last Updated.
Created_for_Worker_Reference_WID String Contains a unique identifier for an instance of an object.
Created_for_Worker_Reference_Contingent_Worker_ID String Contains a unique identifier for an instance of an object.
Created_for_Worker_Reference_Employee_ID String Contains a unique identifier for an instance of an object.
Memo String Header level comment
Receipt_Adjustment_Reference String Reference to Receipt Adjustments that adjusts current Receipt.
Requisition_Type_Reference String Reference to the Requisition Type of Requisitions included in Receipt.
Item_Receipt_Line_Replacement_Data String Goods item receipt lines
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.
Period_Start_Date Date Start Date for the Period defined.
Period_End_Date Date End Date for the Period defined.
Hours_Worked_Data String Hours Worked details.
Additional_Amount Decimal Additional amount, if any, for the Receipt Line which is not associated with Hours Worked.
Amount_to_Receive Decimal Calculated Amount to Receive based on sum of Hours Worked Data plus Additional Amount (if any). The Hours Worked Amount is calculated based on the Time Code Rate Multiplier and the Contract Pay Rate on the Purchase Order Line.
Contingent_Worker_Receipt_Line_Replacement_Memo String Memo for the Receipt Line.
Receipt_Service_Line_Replacement_Data String Receipt Service Line Data
Attachment_Data String Attachments

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