Tableau Connector for Workday

Build 20.0.7740

SettlementRunCustomFilters

Settlement Run Custom Filter

Columns

Name Type References Description
Settlement_Run_Custom_Filter_ID String Settlement Run Custom Filter ID
Custom_Filter_Name String Custom Filter Name
Payment_Source_Reference String Payment Source Reference
All_Open_Supplier_Invoices Bool All Open Supplier Invoices
Resource_Provider_Reference String Resource Provider Reference
Supplier_Category_Reference String Supplier Category Reference
Supplier_Group_Reference String Supplier Group Reference
Supplier_Status_Reference String Supplier Status Reference
Supplier_Reference_Number String Supplier Reference Number
Handling_Code_Reference String Handling Code Reference
Supplier_Document_Received Bool Supplier Document Received
External_PO_Number String External PO Number
Invoice_Amount_greater_than_or_equal_to Decimal Invoice Amount greater than or equal to
Invoice_Amount_less_than_or_equal_to Decimal nvoice Amount less than or equal to
Supplier_Invoice_Adjustment_Reason_Reference String Supplier Invoice Adjustment Reason Reference
Supplier_Invoice_Created_in_Days String Supplier Invoice Created in Days
Supplier_Invoice_Due_In_Days_ String Supplier Invoice Due In (Days)
Invoice_Dates_Up_to_Current_Date_In_Days_ String Invoice Dates Up to Current Date In (Days)
Invoice_Due_Dates_Up_to_Current_Date_In_Days_ String Invoice Due Dates Up to Current Date In (Days)
Discount_Date_in_Days_ String Discount Date in (Days)
Supplier_Invoice_Payment_Type_Reference String Supplier Invoice Payment Type Reference
Additional_Type_Reference String Additional Type Reference
On_Behalf_of_Company_for_Payment_for_Supplier_Invoice_Reference String On Behalf of Company for Payment for Supplier Invoice Reference
All_Available_Expense_Credit_Card_Transactions Bool All Available Expense Credit Card Transactions
Payee_for_Expense_Credit_Card_Tranasaction_Reference String Payee for Expense Credit Card Tranasaction Reference
On_Behalf_of_Company_for_Payment_for_Expense_Credit_Card_Transaction_Reference String On Behalf of Company for Payment for Expense Credit Card Transaction Reference
Financial_Institution_Reference String Financial Institution Reference
Expense_Card_Payment_Type_Reference String Expense Card Payment Type Reference
Expense_Card_Report_Dates_Up_to_Current_Date_In_Days_ Decimal Expense Card Report Dates Up to Current Date In (Days)
Expense_CCT_Billing_Dates_Up_to_Current_Date_In_Days Decimal Expense CCT Billing Dates Up to Current Date In (Days)
Expense_CCT_Charge_Dates_Up_to_Current_Date_In_Days Decimal Expense CCT Charge Dates Up to Current Date In (Days)
Expense_CCT_Loaded_Dates_Up_to_Current_Date_In_Days Decimal Expense CCT Loaded Dates Up to Current Date In (Days)
Expense_CCT_Posted_Dates_Up_to_Current_Date_In_Days Decimal Expense CCT Posted Dates Up to Current Date In (Days)
All_Available_Procurement_Card_Transactions Bool All Available Procurement Card Transactions
Procurement_Card_Corporate_Credit_Card_Account_Reference String Procurement Card Corporate Credit Card Account Reference
Procurement_Card_Financial_Institution_Reference String Procurement Card Financial Institution Reference
Procurement_Credit_Card_Payment_Type_Reference String Procurement Credit Card Payment Type Reference
Procurement_Card_Billing_Dates_Up_to_Current_Date_In_Days_ Decimal Procurement Card Billing Dates Up to Current Date In (Days)
Procurement_Card_Charge_Dates_Up_to_Current_Date_In_Days_ Decimal Procurement Card Charge Dates Up to Current Date In (Days)
Procurement_Card_Loaded_Dates_Up_to_Current_Date_In_Days_ Decimal Procurement Card Loaded Dates Up to Current Date In (Days)
Procurement_Card_Posted_Dates_Up_to_Current_Date_In_Days_ Decimal Procurement Card Posted Dates Up to Current Date In (Days)
All_Open_Expense_Reports Bool All Open Expense Reports
Expense_Payee_Reference String Expense Payee Reference
On_Behalf_of_Company_for_Payment_for_Expense_Report_Reference String On Behalf of Company for Payment for Expense Report Reference
Business_Purpose_Reference String Business Purpose Reference
Expense_Report_Payment_Type_Reference String Expense Report Payment Type Reference
Expense_Report_Dates_Up_to_Current_Date_In_Days_ Decimal Expense Report Dates Up to Current Date In (Days)
Expense_Report_Approval_Dates_Up_To_Current_Date_In_Days_ Decimal Expense Report Approval Dates Up To Current Date In (Days)
Reimbursable_Total_greater_than_or_equal_to Decimal Reimbursable Total greater than or equal to
Reimbursable_Total_less_than_or_equal_to Decimal Reimbursable Total less than or equal to
Multicurrency_Expense_Entry Bool Multicurrency Expense Entry
Payee_Type_Reference String Payee Type Reference
All_Open_Cash_Advances Bool All Open Cash Advances
Number_of_Days_until_Start_Date_is_Equal_to_or_Less_than Decimal Number of Days until Start Date is Equal to or Less than
Cash_Advance_Payee_Reference String Cash Advance Payee Reference
Cash_Advance_Payee_Type_Reference String Cash Advance Payee Type Reference
Cash_Advance_Payment_Type_Reference String Cash Advance Payment Type Reference
On_Behalf_of_Company_for_the_Payment_Reference String On Behalf of Company for the Payment Reference
All_Ad_hoc_Payments_Filter Bool All Ad hoc Payments Filter
Payee_Reference String Payee Reference
Ad_Hoc_Payment_Type_Reference String Ad Hoc Payment Type Reference
Payment_Date_In_Days_ Decimal Payment Date In (Days)
Payment_Date_Prior_To_In_Days_ Decimal Payment Date Prior To In (Days)
Ad_Hoc_Payment_Transaction String Ad Hoc Payment Transaction
Ad_Hoc_Payment_amount_greater_than_or_equal_to Decimal Ad Hoc Payment amount greater than or equal to
Ad_Hoc_Payment_amount_less_than_or_equal_to Decimal Ad Hoc Payment amount less than or equal to
Ad_Hoc_Payment_Handling_Instruction_Reference String Ad Hoc Payment Handling Instruction Reference
All_Open_On_Cycle_Pay_Groups Bool All Open On-Cycle Pay Groups
On_Cycle_Pay_Run_Group_Selection_Reference String On-Cycle Pay Run Group Selection Reference
All_Customer_Refunds_Filter Bool All Customer Refunds Filter
Refund_Customer_Refund_Reference String Refund Customer Refund Reference
Refund_Customer_Category_Reference String Refund Customer Category Reference
Refund_Customer_Group_Reference String Refund Customer Group Reference
Refund_Payment_Type_Reference String Refund Payment Type Reference
All_Customer_Invoices_Filter Bool All Customer Invoices Filter
Invoice_Customer_Invoice_Reference String Invoice Customer Invoice Reference
Invoice_Customer_Category_Reference String Invoice Customer Category Reference
Invoice_Customer_Group_Reference String Invoice Customer Group Reference
Customer_Invoice_Created_in_Days String Customer Invoice Created in Days
Customer_Invoices_Due_In_Days_ String Customer Invoices Due In (Days)
Customer_Invoice_Payment_Type_Reference String Customer Invoice Payment Type Reference
All_Open_Intercompany_Items Bool All Open Intercompany Items
Item_Date_From_Current_Date_In_Days_ Decimal Item Date From Current Date In (Days)
Item_Dates_Up_To_Current_Date_In_Days_ Decimal Item Dates Up To Current Date In (Days)
Intercompany_Affiliate_Reference String Intercompany Affiliate Reference
Intercompany_Originating_Transaction_Type_Reference String Intercompany Originating Transaction Type Reference
Intercompany_Payables_Receivables_Reference_WID String Contains a unique identifier for an instance of an object.
Intercompany_Payables_Receivables_Reference_Account_Posting_Rule_Type_ID String Contains a unique identifier for an instance of an object.
All_Open_Customer_Payments Bool All Open Customer Payments
Customer_Payment_Customer_Reference String Customer Payment Customer Reference
Customer_Payment_Customer_Payment_Reference String Customer Payment Customer Payment Reference
Customer_Payment_Customer_Group_Reference String Customer Payment Customer Group Reference
Customer_Payment_Payment_Type_Payment_Reference String Customer Payment Payment Type Payment Reference
All_Open_Pay_Group_Exceptions Bool All Open Pay Group Exceptions
Off_Cycle_Pay_Run_Group_Selection_Reference String Off-Cycle Pay Run Group Selection Reference
Payroll_Action_Reason_Reference String Payroll Action Reason Reference
Off_Cycle_Payment_Date_In_Days String Off Cycle Payment Date In Days
Off_Cycle_Payment_Date_Prior_To_In_Days String Off Cycle Payment Date Prior To In Days
Pay_Group_Payment_Type_Reference String Pay Group Payment Type Reference
Payment_Amount_Greater_Than_or_Equal_To Decimal Payment Amount Greater Than or Equal To
Payment_Amount_Less_Than_or_Equal_To Decimal Payment Amount Less Than or Equal To
All_Bank_Account_Transfer_Payments Bool All Bank Account Transfer Payments
Bank_Account_Transfer_Payment_Payment_Type_Reference String Bank Account Transfer Payment Payment Type Reference
Bank_Account_Transfer_Payment_Date_From_Current_Date_In_Days Decimal Bank Account Transfer Payment Date From Current Date In Days
Bank_Account_Transfer_Payment_Dates_Up_To_Current_Date_In_Days Decimal Bank Account Transfer Payment Dates Up To Current Date In Days
Bank_Account_Transfer_Payment_Amount_Greater_Than_or_Equal_To Decimal Bank Account Transfer Payment Amount Greater Than or Equal To
Bank_Account_Transfer_Payment_Amount_Less_Than_or_Equal_To Decimal Bank Account Transfer Payment Amount Less Than or Equal To
All_Student_Sponsor_Refunds Bool Retrieves all Student Sponsor Refunds that are available for settlement
Student_Sponsor_Refund_Sponsor_Reference String Retrieves Student Sponsor Refunds available for settlement and the sponsor(s) specified.
Student_Sponsor_Refund_Payment_Type_Reference String Retrieves Student Sponsor Refunds available for settlement and the payment type(s) specified.
All_Miscellaneous_Payment_Requests Bool All Available Miscellaneous Payment Requests
Miscellaneous_Payment_Request_Payee_Reference String Miscellaneous Payment Request Payee Reference
Miscellaneous_Payment_Request_Category_Reference String Miscellaneous Payment Request Category Reference
Miscellaneous_Payment_Request_Document_Date_From_Current_Date_In_Days_ String Miscellaneous Payment Request Document Date From Current Date In (Days)
Miscellaneous_Payment_Request_Document_Date_Up_To_Current_Date_In_Days_ String Miscellaneous Payment Request Document Date Up To Current Date In (Days)
Miscellaneous_Payment_Request_Due_Date_From_Current_Date_In_Days_ String Miscellaneous Payment Request Due Date From Current Date In (Days)
Miscellaneous_Payment_Request_Due_Date_Up_To_Current_Date_In_Days_ String Miscellaneous Payment Request Due Date Up To Current Date In (Days)
Miscellaneous_Payment_Request_Payment_Type_Reference String Miscellaneous Payment Request Payment Type Reference
Miscellaneous_Payment_Request_Payees_to_Exclude_Reference String Miscellaneous Payment Request Payees to Exclude Reference
Miscellaneous_Payment_Request_Handle_Code_Reference String Miscellaneous Payment Request Handle Code Reference
Miscellaneous_Payment_Request_Amount_Greater_Than_or_Equal_To Decimal Miscellaneous Payment Request Amount Greater Than or Equal To
Miscellaneous_Payment_Request_Amount_Less_Than_or_Equal_To Decimal Miscellaneous Payment Request Amount Less Than or Equal To
Miscellaneous_Payment_On_Behalf_Of_Company_Reference String Miscellaneous Payment On Behalf Of Company Reference

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