Connector Improvement: Workday Financial Management update OPERATIONAL_TRANSACTION_REFERENCE column keys to include Receipt ID
Not plannedIn addition to adding this column to the Fivetran ERD, can what is registered to the JSON in this column be expanded to include Receipt_ID? We need this to map Journal Entries to Purchase Orders as some receipts don't require supplier invoices.
- Ad_hoc_Payment_Reference_ID
- Customer_Invoice_Adjustment_Reference_ID
- Customer_Invoice_Reference_ID
- EFT_Payment_ID
- Escheatment_Item_ID
- Expense_Report_Reference_ID
- Procurement_Card_Transaction_Verification_ID
- Supplier_Invoice_Adjustment_Reference_ID
- Supplier_Invoice_Reference_ID
-
Official comment
Hi Brad,
Receipt_ID is not listed as a transaction type in Operational_transaction_reference. Here are the listed supported types:

I'd recommend reaching out to Workday support to understand where to get the information you are looking for.
Thanks,
Frank -
Hi Brad,
This is a valuable idea and has been added to our connector improvement backlog. We will keep this thread updated with any progress or changes to this feature.
Thanks,
Frank
Please sign in to leave a comment.
Comments
2 comments