Tableau Connector for Workday

Build 20.0.7740

Journals

Journal Entry Data

Columns

Name Type References Description
Journal_Entry_Reference_WID String Contains a unique identifier for an instance of an object.
Journal_Entry_Reference_Accounting_Journal_ID String Contains a unique identifier for an instance of an object.
Journal_Number String Journal Number. The Journal Number is automatically generated through the sequencing number Journal Number configuration.
Journal_Sequence_Number String The Sequence Number assigned to the current journal. It is unique among all journals within a period (or year, depending on the setup.)
Journal_Status_Reference_WID String Contains a unique identifier for an instance of an object.
Journal_Status_Reference_Journal_Entry_Status_ID String Contains a unique identifier for an instance of an object.
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.
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.
Book_Code_Reference_WID String Contains a unique identifier for an instance of an object.
Book_Code_Reference_Book_Code_ID String Contains a unique identifier for an instance of an object.
Ledger_Reference_WID String Contains a unique identifier for an instance of an object.
Ledger_Reference_Ledger_Reference_ID String Contains a unique identifier for an instance of an object.
Display_Account_Set_Reference_WID String Contains a unique identifier for an instance of an object.
Display_Account_Set_Reference_Account_Set_ID String Contains a unique identifier for an instance of an object.
Ledger_Period_Reference_IID String Contains a unique identifier for an instance of an object.
Ledger_Period_Reference_WID String Contains a unique identifier for an instance of an object.
Accounting_Date Date Accounting Date
Journal_Source_Reference_WID String Contains a unique identifier for an instance of an object.
Journal_Source_Reference_Journal_Source_ID String Contains a unique identifier for an instance of an object.
Balancing_Worktag_Reference_WID String Contains a unique identifier for an instance of an object.
Balancing_Worktag_Reference_Business_Unit_ID String Contains a unique identifier for an instance of an object.
Balancing_Worktag_Reference_Cost_Center_Reference_ID String Contains a unique identifier for an instance of an object.
Balancing_Worktag_Reference_Custom_Organization_Reference_ID String Contains a unique identifier for an instance of an object.
Balancing_Worktag_Reference_Fund_ID String Contains a unique identifier for an instance of an object.
Balancing_Worktag_Reference_Organization_Reference_ID String Contains a unique identifier for an instance of an object.
Balancing_Worktag_Reference_Region_Reference_ID String Contains a unique identifier for an instance of an object.
Optional_Balancing_Worktags_Reference String Optional Anchor Balancing Worktags for the Journal.
Transaction_Date Date Transaction Date
Operational_Transaction_Reference_WID String Contains a unique identifier for an instance of an object.
Operational_Transaction_Reference_Ad_hoc_Bank_Transaction_ID String Contains a unique identifier for an instance of an object.
Operational_Transaction_Reference_Ad_hoc_Payment_Reference_ID String Contains a unique identifier for an instance of an object.
Operational_Transaction_Reference_Bank_Account_Transfer_Payment_ID String Contains a unique identifier for an instance of an object.
Operational_Transaction_Reference_Bank_Account_Transfer_Reference_ID String Contains a unique identifier for an instance of an object.
Operational_Transaction_Reference_Bank_Statement_Reference_ID String Contains a unique identifier for an instance of an object.
Operational_Transaction_Reference_Contract_Asset_and_Liability_Reclass_ID String Contains a unique identifier for an instance of an object.
Operational_Transaction_Reference_Customer_Invoice_Adjustment_Reference_ID String Contains a unique identifier for an instance of an object.
Operational_Transaction_Reference_Customer_Invoice_Reference_ID String Contains a unique identifier for an instance of an object.
Operational_Transaction_Reference_Customer_Refund_Reference_ID String Contains a unique identifier for an instance of an object.
Operational_Transaction_Reference_Deferred_Cost_Installment_Reference_ID String Contains a unique identifier for an instance of an object.
Operational_Transaction_Reference_Document_Number String Contains a unique identifier for an instance of an object.
Operational_Transaction_Reference_EFT_Payment_ID String Contains a unique identifier for an instance of an object.
Operational_Transaction_Reference_Escheatment_Item_ID String Contains a unique identifier for an instance of an object.
Operational_Transaction_Reference_Expense_Report_Reference_ID String Contains a unique identifier for an instance of an object.
Operational_Transaction_Reference_External_PO_Number String Contains a unique identifier for an instance of an object.
Operational_Transaction_Reference_Internal_Service_Delivery_Document_Number String Contains a unique identifier for an instance of an object.
Operational_Transaction_Reference_Internal_Service_Delivery_ID String Contains a unique identifier for an instance of an object.
Operational_Transaction_Reference_Investment_Pool_Adjustment_ID String Contains a unique identifier for an instance of an object.
Operational_Transaction_Reference_Investment_Pool_Payout_ID String Contains a unique identifier for an instance of an object.
Operational_Transaction_Reference_Investment_Pool_Purchase_ID String Contains a unique identifier for an instance of an object.
Operational_Transaction_Reference_Investment_Pool_Sale_ID String Contains a unique identifier for an instance of an object.
Operational_Transaction_Reference_Investment_Pool_Transfer_ID String Contains a unique identifier for an instance of an object.
Operational_Transaction_Reference_Investment_Statement_ID String Contains a unique identifier for an instance of an object.
Operational_Transaction_Reference_Miscellaneous_Payment_Request_Reference_ID String Contains a unique identifier for an instance of an object.
Operational_Transaction_Reference_Netting_Transaction_Reference_ID String Contains a unique identifier for an instance of an object.
Operational_Transaction_Reference_Procurement_Card_Transaction_Verification_ID String Contains a unique identifier for an instance of an object.
Operational_Transaction_Reference_Purchase_Order_Reference_ID String Contains a unique identifier for an instance of an object.
Operational_Transaction_Reference_Requisition_Number String Contains a unique identifier for an instance of an object.
Operational_Transaction_Reference_Revenue_Recognition_Installment_Reference_ID String Contains a unique identifier for an instance of an object.
Operational_Transaction_Reference_Spend_Authorization_ID String Contains a unique identifier for an instance of an object.
Operational_Transaction_Reference_Student_Charge_Adjustment_ID String Contains a unique identifier for an instance of an object.
Operational_Transaction_Reference_Student_Charge_Document_ID String Contains a unique identifier for an instance of an object.
Operational_Transaction_Reference_Student_Charge_ID String Contains a unique identifier for an instance of an object.
Operational_Transaction_Reference_Student_Sponsor_Refund_Payment_ID String Contains a unique identifier for an instance of an object.
Operational_Transaction_Reference_Supplier_Contract_Amendment_ID String Contains a unique identifier for an instance of an object.
Operational_Transaction_Reference_Supplier_Contract_ID String Contains a unique identifier for an instance of an object.
Operational_Transaction_Reference_Supplier_Invoice_Adjustment_Reference_ID String Contains a unique identifier for an instance of an object.
Operational_Transaction_Reference_Supplier_Invoice_Reference_ID String Contains a unique identifier for an instance of an object.
Record_Quantity Bool Record Quantity - set to True (1) if setting Quantity and Unit of Measure on a journal line.
Memo String Journal Entry Memo
External_Reference_ID String This is a freeform text reference that is used to associate this Journal with a record in a third party system
Document_Link String Link to supporting documents
Originated_By_Reference_IID String Contains a unique identifier for an instance of an object.
Originated_By_Reference_WID String Contains a unique identifier for an instance of an object.
Approved_by_Reference String For an Operational Journal the Approved by will be blank. For an Accounting Journal, Approved by is the user(s) that approved the Accounting Journal
Total_Ledger_Debits Decimal Total Ledger Debits
Total_Ledger_Credits Decimal Total Ledger Credits
Cancel_Reversed_By_Journal_Entry_Reference_WID String Contains a unique identifier for an instance of an object.
Cancel_Reversed_By_Journal_Entry_Reference_Accounting_Journal_ID String Contains a unique identifier for an instance of an object.
Cancel_Reverses_Journal_Entry_Reference_WID String Contains a unique identifier for an instance of an object.
Cancel_Reverses_Journal_Entry_Reference_Accounting_Journal_ID String Contains a unique identifier for an instance of an object.
Functional_Reversed_By_Journal_Entry_Reference_WID String Contains a unique identifier for an instance of an object.
Functional_Reversed_By_Journal_Entry_Reference_Accounting_Journal_ID String Contains a unique identifier for an instance of an object.
Functional_Reverses_Journal_Entry_Reference_WID String Contains a unique identifier for an instance of an object.
Functional_Reverses_Journal_Entry_Reference_Accounting_Journal_ID String Contains a unique identifier for an instance of an object.
Creation_Date Datetime The date the Journal Entry was created.
Last_Updated_Date Datetime Date and Time that the Journal Entry was last updated for the Updated From and Update To date range provided
Journal_Entry_Line_Data String Journal Entry Line Data
Attachment_Data String Attachment Data

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