Tableau Connector for Workday

Build 20.0.7740

BillingSchedules

Billing Schedule Data

Columns

Name Type References Description
Billing_Schedule_Reference_ID String Billing Schedule Reference ID. This is the unique Billing Schedule identifier.
Generate_Installments Bool Generate Installments flag. The service will generate billing installments if this is true. You cannot generate installments if using a Custom schedule distribution method.
Submit Bool Submit flag. The service will attempt to submit the schedule if this is on.
Billing_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Billing_Type_Reference_Billing_Type_ID String Contains a unique identifier for an instance of an object.
Schedule_Status_Reference String Reference element representing the schedule status.
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.
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_To_Customer_Reference_WID String Contains a unique identifier for an instance of an object.
Bill_To_Customer_Reference_Customer_ID String Contains a unique identifier for an instance of an object.
Bill_To_Customer_Reference_Customer_Reference_ID String Contains a unique identifier for an instance of an object.
Bill_To_Customer_Reference_Sponsor_ID String Contains a unique identifier for an instance of an object.
Bill_To_Customer_Reference_Sponsor_Reference_ID String Contains a unique identifier for an instance of an object.
Bill_To_Customer_Reference_Student_Financial_Account_ID String Contains a unique identifier for an instance of an object.
Bill_To_Address_Reference_WID String Contains a unique identifier for an instance of an object.
Bill_To_Address_Reference_Address_ID String Contains a unique identifier for an instance of an object.
Bill_To_Address_Data String Address information
Populate_with_Default_Bill_To_Contacts Bool When Populate with Default Bill-To Contacts is set to true, it will populate Bill To Contact with the Default Values.
Bill_To_Contact_Reference String Bill-To Contact for the billing schedule header.
Billing_Method_Reference_WID String Contains a unique identifier for an instance of an object.
Billing_Method_Reference_Schedule_Distribution_Method_Reference_ID String Contains a unique identifier for an instance of an object.
Frequency_Reference_WID String Contains a unique identifier for an instance of an object.
Frequency_Reference_Frequency_Behavior_ID String Contains a unique identifier for an instance of an object.
From_Date Date From date. The system generates installments based on this value.
To_Date Date To date. The system generates installments based on this value.
Number_of_Installments Decimal Number of installments. The system generates installments based on this value.
Billed_in_Arrears Bool Billed in Arrears flag. The system consolidates invoices based on this value.
Use_From_Date Bool Use From Date flag. The system generates installments based on this value.
Use_To_Date Bool Use To Date flag. The system generates installments based on this value.
Day_of_Month Decimal Day of Month. The system generates installments based on this value.
Day_of_Week_Reference_WID String Contains a unique identifier for an instance of an object.
Day_of_Week_Reference_Day_of_the_Week_ID String Contains a unique identifier for an instance of an object.
Automatically_Regenerate_Installments Bool Automatically Regenerate Installments flag. Use this flag to automatically regenerate installments when Customer Contract Amendments are completed.
Automatically_Submit_Schedule_via_Contract_Amendment Bool Automatically Submit Schedule via Contract Amendment flag. Use this flag to automatically submit the Billing Schedule on Customer Contract Amendment completion after installments are automatically regenerated.
Schedule_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Schedule_Type_Reference_Schedule_Category_ID String Contains a unique identifier for an instance of an object.
Schedule_Description String Schedule Description.
Milestone_Reference String Reference element representing milestones linked to this schedule. Schedule processing is contingent upon these milestones being met.
Schedule_On_Hold Bool Schedule On Hold flag.
Auto_Submit_Invoices_for_Approval Bool Auto-Submit Invoices for Approval flag.
Review_Not_Required_to_Bill Bool Review Not Required to Bill.
Auto_Attach_Expense_Receipts_on_Invoice Bool Auto Attach Expense Receipts on Invoice
Enable_Consumption_of_Prepaid_Balance Bool A boolean flag indicating whether the prepaid balance is currently applied to transactions for this schedule.
Do_Not_Bill_Over_Installment_Total Bool True if the billing schedule doesn't enable you to bill over the installment total for prepaid balances.
Project_Invoice_Summary_Definition_Reference_WID String Contains a unique identifier for an instance of an object.
Project_Invoice_Summary_Definition_Reference_PROJECT_INVOICE_SUMMARY_DEFINITION_ID String Contains a unique identifier for an instance of an object.
Billing_Cycle_Reference_WID String Contains a unique identifier for an instance of an object.
Billing_Cycle_Reference_Billing_Cycle_ID String Contains a unique identifier for an instance of an object.
Billing_Limit Decimal Billing Limit on the Billing Schedule.
Payment_Terms_Reference_WID String Contains a unique identifier for an instance of an object.
Payment_Terms_Reference_Payment_Terms_ID String Contains a unique identifier for an instance of an object.
Payment_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Payment_Type_Reference_Payment_Type_ID String Contains a unique identifier for an instance of an object.
PO_Number String PO Number.
Invoice_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Invoice_Type_Reference_Customer_Invoice_Type_ID String Contains a unique identifier for an instance of an object.
Invoice_Memo String Invoice memo.
Interest_and_Late_Fee_Rules_Override_Data String When you perform the submit or import operation, make sure that the Interest and Late Fee Rule you're trying to override is active.
Contract_Line_Reference String Reference element representing instances Contract Lines linked to this schedule.
Billing_Installment_Data String Billing Installment Data
Billing_Schedule_Installment_Schedule_Data String This element contains data to be used with the Defined Installment or 'RECURRING' schedule distribution method. For each contract line included in the schedule, you can specify a Regular, First, and Last Installment amount that will be used when generating installments to determine how to allocate amounts across each installment.
Percent_to_Retain Decimal The retention percent defined for the billing schedule.
Estimated_Retention_Release_Date Date The estimated retention release date.
Third_Party_Retention Bool Returns true if the contract has 3rd party retention checked.
Retention_Memo String The memo field for the billing schedule retention terms.
Contract_Lines_for_Retention_Reference String Contract lines that include retention.
Include_Tax_on_Prepaid Bool If true, the Billing Schedule will Include Tax on Prepaid.

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