Release Notes
October 2025
We’ve added a new column, country_alpha_2_code, to the BUSINESS_ENTITY_ADDRESS table.
We’ve added a new column, account_set_name, to the JOURNAL_ENTRY_LINE table.
To backfill the historical data for these columns, re-sync the tables or contact Fivetran Support.
September 2025
We have updated the data type of the supplier_invoice_reference_number column in the SUPPLIER_CONTRACT table from BOOLEAN to STRING.
We have added the following new columns to the COMPANY table:
account_control_rule_set_idaccount_posting_rule_set_idaccount_set_idaccount_translation_rule_set_codeaccounting_date_requiredallow_invoice_accounting_in_arrearsalternate_account_set_idaverage_daily_balance_rule_codeaverage_daily_balance_start_datecurrency_idcurrency_rate_type_codedefault_account_set_iddefault_reporting_book_codedisallow_change_to_operations_transactions_in_closed_periodsenable_automatic_journal_line_numberingfiscal_schedule_codekeep_debit_credit_and_reverse_signprocurement_tax_option_codereverse_debit_credittax_service_nameuse_third_party_tax_service
We have added a new column, sub_type_code, to the ORGANIZATION table.
We have added the following new child tables to the COMPANY table:
company_alternate_fiscal_schedulecompany_account_translation_currencycompany_allow_accounting_in_arrearscompany_alternate_ledger_currency
We are gradually rolling these changes out to all existing connections.
August 2025
We have fixed a bug and rectified the values of the included_ledger_account_id and included_ledger_account_code columns of the ALL_INCLUDED_LEDGER_ACCOUNT table. We have also removed the incorrect records in the ALL_INCLUDED_LEDGER_ACCOUNT table in your destination.
We have removed the toggle button to choose between different OAuth authentication options in the setup form for all connections set up before February 25, 2025. For all connections, we now only support API client for integrations method if you use OAuth based authentication.
July 2025
We have added a new column, purchase_order_goods_line_id, to the RECEIPT_LINE_GOODS_ITEM table.
We now sync the SUPPLIER_INVOICE_LINE table using the Get_Supplier_Invoice API, because Get_Supplier_Invoice_Lines does not return any data. We automatically resync the SUPPLIER_INVOICE_LINE table.
We are gradually rolling out this improvement to all connections.
May 2025
We have added the support for following new tables:
HEADCOUNT_PLANHEADCOUNT_PLAN_LINEHEADCOUNT_PLAN_LINES_WORKTAGINCLUDED_SPEND_CATEGORIESSPEND_CATEGORY_HIERARCHY
We are gradually rolling out these changes to all existing connections. For more information, see the Workday Financial Management ERD.
We have added the following new tables to support the Workday Financial_Management module:
ACCOUNT_POSTING_RULEACCOUNT_POSTING_RULE_CONDITIONACCOUNT_POSTING_RULE_CONDITION_VALUE_GROUPACCOUNT_POSTING_RULE_SETCUSTOMER_ADDRESS_LEVEL_TAX_DETAILSCUSTOMER_TAX_ENTITY_ACTIVITY_CODERESOURCE_CATEGORYRESOURCE_CATEGORY_ALLOWED_WORKTAGSRESOURCE_CATEGORY_RELATED_WORKTAGSUNSPC_CODE_RANGE
We have added the support for following new tables:
AUDIT_TAGAUDIT_TAG_SEGMENTCOST_CENTERCOST_CENTER_ALLOWED_WORKTAGCOST_CENTER_CONTAINER_ORGANIZATIONCOST_CENTER_RELATED_WORKTAGCOST_CENTER_RESTRICTEDCURRENCY_RATE_TYPEORGANIZATION_ASSIGNMENTORGANIZATION_DOCUMENT_FIELD_RESULTORGANIZATION_HIERARCHY_DETAILORGANIZATION_JOB_FAMILYORGANIZATION_JOB_PROFILEORGANIZATION_JOB_PROFILE_EXEMPTORGANIZATION_LEADERORGANIZATION_POSITION_GROUP_POSITIONORGANIZATION_ROLEORGANIZATION_ROLE_WORKERSUPERVISORY_ORGANIZATION_LOCATION
We are gradually rolling out these changes to all existing connections. For more information, see the Workday Financial Management ERD.
April 2025
We have added two new columns, customer_contract_line_id and receivable_contract_line_code, to the CUSTOMER_INVOICE_LINE table.
We have added a new column, worktag_code, to the CUSTOMER_CONTRACT_LINE_WORKTAG table.
We have changed the composite primary key of the REVENUE_RECOGNITION_INSTALLMENT_LINE table. We have removed the line_id column and added the index column as part of the new composite primary key.
We have changed the composite primary key of the REVENUE_RECOGNITION_INSTALLMENT_LINE_WROKTAG table. We have removed the revenueRecognitionInstallmentLineId column and added the lineIndex column as part of the new composite primary key. Also, we have discontinued the revenueRecognitionInstallmentLineId column and will no longer sync this column to the REVENUE_RECOGNITION_INSTALLMENT_LINE_WROKTAG table.
Our Workday Financial Management connector is now generally available. Read our Workday Financial Management connector documentation.
March 2025
Our Workday Financial Management connector now allows you to select between an API client and an API client for integrations on the setup page when configuring the connector. For more information, see our Workday Financial Management connector documentation.
We have made the following schema changes to the connector:
| Table Name | New Primary Key Column(s) |
|---|---|
BILLING_INSTALLMENT_LINE | billing_schedule_id |
BILLING_INSTALLMENT_LINE_TAX_APPLICABILITY | billing_installment_id, billing_schedule_id |
BILLING_INSTALLMENT_LINE_TAX_CODE | billing_installment_id, billing_schedule_id |
BILLING_INSTALLMENT_LINE_WORKTAG | billing_installment_id, billing_schedule_id |
BILLING_INSTALLMENT_MILESTONE | billing_schedule_id |
BILLING_INSTALLMENT_STATUS | billing_schedule_id |
BILLING_SCHEDULE_PREPAID_INSTALLMENT | billing_schedule_id |
BILLING_SCHEDULE_PREPAID_INSTALLMENT_MILESTONE | prepaid_installment_and_mapping_id, billing_schedule_id |
BILLING_SCHEDULE_PREPAID_MAPPING | billing_schedule_id |
LINE_OVERRIDE_DEFAULT | revenue_allocation_configuration_id |
PREPAID_MAPPING_CUSTOMER_CONTRACT_LINE | prepaid_mapping_id, billing_schedule_id |
REVENUE_RECOGNITION_INSTALLMENT_HOLD_REASON | revenue_recognition_schedule_id |
REVENUE_RECOGNITION_INSTALLMENT_LINE | revenue_recognition_schedule_id |
REVENUE_RECOGNITION_INSTALLMENT_LINE_WORKTAG | revenue_recognition_installment_id, revenue_recognition_schedule_id |
REVENUE_RECOGNITION_INSTALLMENT_MILESTONE | revenue_recognition_schedule_id |
REVENUE_RECOGNITION_INSTALLMENT_STATUS | revenue_recognition_schedule_id |
SALES_ITEM_ALLOWED_WORKTAG | sales_item_id |
SALES_ITEM_FAIR_VALUE_PRICE_LIST_RULE_LINE_WORKTAG | sales_item_fair_value_price_list_id |
SALES_ITEM_PRICE_LIST_RULE_LINE_CONTRACT_LINE_TYPE | sales_item_price_list_id |
SALES_ITEM_PRICE_LIST_RULE_LINE_WORKTAG | sales_item_price_list_id |
SALES_ITEM_TIERED_PRICING | sales_item_price_list_id |
We will perform a free re-sync for the above tables to backfill the old data.
February 2025
We have added two new fields, operational_transaction_id and operational_transaction_reference, to the JOURNAL_ENTRY table.
Our Workday Financial Management connector now supports below endpoints of Workday Resource Management Module. To support this enhancement, we have added the following new tables:
BUSINESS_ENTITY_ADDRESS_LINEBUSINESS_ENTITY_ADDRESS_SUBMUNICIPALITYBUSINESS_ENTITY_ADDRESS_SUBREGIONBUSINESS_ENTITY_ADDRESSBUSINESS_ENTITY_COMMUNICATION_USAGEBUSINESS_ENTITY_CONTACT_TYPE_TENANTEDBUSINESS_ENTITY_CONTACT_TYPEBUSINESS_ENTITY_CONTACTBUSINESS_ENTITY_EMAIL_ADDRESSBUSINESS_ENTITY_IMBUSINESS_ENTITY_PERSON_NAMEBUSINESS_ENTITY_PHONEBUSINESS_ENTITY_WEB_ADDRESSCREDIT_CARD_TRANSACTION_LINEEXPENSE_CREDIT_CARD_TRANSACTIONHOTEL_DETAILNAME_MATCHOTHER_HOTEL_SERVICEPROJECT_ATTACHMENTPROJECT_COST_RATE_RULEPROJECT_HIERARCHYPROJECT_RESOURCE_REQUIREMENT_PARAMETERPROJECT_ROLE_CATEGORYPROJECT_ROLE_RATEPROJECT_STANDARD_COST_RATE_SHEETPROJECT_STANDARD_COST_RATE_SNAPSHOTPROJECT_TASK_HIERARCHYPROJECT_TASK_RESOURCEPROJECT_TASKPROJECT_TIMESHEET_DAYPROJECT_TIMESHEET_LINEPROJECT_TIMESHEETPROJECT_WORKER_PROJECT_HIERARCHYPROJECT_WORKER_RATEPROJECT_WORKER_ROLEPROJECTRELATED_WORKTAGRESOURCE_FORECAST_CONFIGURATIONRESOURCE_FORECAST_LINE_ALLOCATIONRESOURCE_FORECAST_LINERESOURCE_FORECASTTAX_DETAILTICKET_DETAILTRIP_LEG_DETAIL_NAME_MATCHTRIP_LEG_DETAIL
We are gradually rolling out these features to all existing connections. If you have any questions, contact our Support team.
January 2025
We have added a new column, currency_rate_type_code, to the CURRENCY_CONVERSION_RATE table.
December 2024
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
CUSTOMER_INVOICE_ADJUSTMENT_LINE_DATA | |||||
| column | New Column | revenue_category_id | Added to foreign key of REVENUE_CATEGORY table. The new column supports the mapping between the CUSTOMER_INVOICE_ADJUSTMENT_LINE_DATA and REVENUE_CATEGORY tables. | ||
CUSTOMER_INVOICE_LINE | |||||
| column | New Column | revenue_category_id | Added to foreign key of REVENUE_CATEGORY table. The new column supports the mapping between the CUSTOMER_INVOICE_LINE and REVENUE_CATEGORY tables. | ||
October 2024
We now support table re-syncs for our Workday Financial Management connector. You can now select or deselect the tables to sync from the Schema tab of your connection details page. We are gradually rolling out this improvement to all existing connections.
September 2024
We have added a new column, ledger_type, to the LEDGER table. To backfill the historical data, re-sync the parent table, JOURNAL_ENTRY, or contact Fivetran support.
July 2024
Workday Financial Management is a cloud-based financial management platform.
Read our Workday Financial Management connector documentation.