Tableau Connector for Workday

Build 20.0.7740

RecurringJournalTemplates

Recurring Journal Template Data

Columns

Name Type References Description
Recurring_Journal_Template_ID String Recurring Journal Template ID. This is the Recurring Journal Template unique identifier
Round_Ledger_Amounts Bool *A Balancing Worktag Reference is not specified for the Recurring Journal Template
Recurring_Journal_Template_Name String Free form text field for a meaningful Recurring Journal Template Name
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.
Currency_Rate_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Currency_Rate_Type_Reference_Currency_Rate_Type_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_Reference_Company_Reference_WID String Contains a unique identifier for an instance of an object.
Ledger_Reference_Company_Reference_Company_Reference_ID String Contains a unique identifier for an instance of an object.
Ledger_Reference_Company_Reference_Organization_Reference_ID String Contains a unique identifier for an instance of an object.
Ledger_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Ledger_Type_Reference_Ledger_Type_ID String Contains a unique identifier for an instance of an object.
Recurring_Journal_Template_Start_Date Date Recurring Journal Template Start Date
Recurring_Journal_Template_End_Date Date Recurring Journal Template End Date
Reset_Currency_Rate_at_Journal_Generation Bool For Multicurrency journal templates, a boolean to indicate whether the ledger amounts should be recalculated using the current currency exchange rate in affect at journal generation time.
Automatically_Submit_Journals_Generated_from_Recurring_Journal_Template Bool Boolean flag indicating if the journal created from this template should be automatically submitted
Record_Quantity Bool Record Quantity is a flag indicating that this is an accounting journal with at least one line containing the Quantity/Unit of Measure Statistical Pair.
Journal_Entry_Memo String Journal Entry Memo
Document_Link String Link to supporting documents
Create_Reversal Bool Boolean attribute indicating if the journal entry generated for recurring journal template should also create a reversal
Control_Total_Amount Decimal Control Total Amount. Sum of debit and credits must equal this amount
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.
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.
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.
Journal_Entry_Line_Replacement_Data String Journal Entry Line Data
Company_Reference_Company_Reference_WID String Contains a unique identifier for an instance of an object.
Company_Reference_Company_Reference_Company_Reference_ID String Contains a unique identifier for an instance of an object.
Company_Reference_Company_Reference_Organization_Reference_ID String Contains a unique identifier for an instance of an object.
Attachment_Data String Element containing Financial Attachment with Intercompany Attachment Field data.

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