Bryan Beck
- Total activity 17
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 3
- Subscriptions 5
Activity overview
Latest activity by Bryan Beck-
Bryan Beck commented,
Our customer needs to be able to identify which items from a purchase order have been received from the vendor. The FiveTran ERD (https://docs.google.com/presentation/d/1BLjww5562F4iEf8NulgOCcMsQS...
-
Bryan Beck commented,
Is there an update to this request to have processing_fee supported in the Payments table? Thank you!
-
Bryan Beck commented,
I just found another field that we can join on (see highlights in SQL below). This is not intuitive based on what is shown in the ERD, but it works. This ticket can be closed. SELECT count(*) F...
-
Bryan Beck commented,
Yes, there is data in both tables (the supplier id fields contain guid values). The two queries below both return 0 records (the second one is my attempt at a workaround). SELECT * FROM shca_sou...
-
Bryan Beck commented,
Yes, we have access to the goods_purchase_order_line_id field in the PURCHASE_ORDER_GOODS_LINE table. However, this field does not contain values that would allow for a join to the RECEIPT_LINE_GO...
-
Bryan Beck created a post,
Connector Improvement: Workday Financial Management Supplier Invoice Adjustment table and Supplier Invoice JOIN Yields Too Many Rows - Suggest Using GUID
AnsweredThe join suggested in Fivetran support ticket #265527 is a many-to-many join. The original supplier_invoice_adjustment table has only about 1,000 records -- we don't want that to balloon into 5.6 m...
-
Bryan Beck created a post,
Connector Improvement: Workday Financial Management Purchase Supplier Item and Supplier Table Join Results in Zero Purchase Items Mapped to a Supplier
AnsweredFix data populating PURCHASE_SUPPLIER_ITEM and SUPPLIER tables so that they can be joined resulting with a non-zero row count. The ERD appears to have the intent in its design to allow purchase_ite...
-
Bryan Beck created a post,
Connector Improvement: Workday Financial Management Need Key to Join Purchase Order Goods Line and Receipt Line Goods Item tables
CompletedWith Workday FMS, RECEIPT_LINE_GOODS_ITEM and PURCHASE_ORDER_GOODS_LINE need a key to allow the two tables to be joined (show the relationship between a goods item and the goods lines). In Fivetran...
-
Bryan Beck created a post,
Connector Improvement: Additional Field for Square Connector
AnsweredSee square API documentation for Payment endpoint: https://developer.squareup.com/reference/square/objects/Payment The field of "processing_fee" is not supported according to Fivetran support tick...