Hi Bryan, 

Do you have access to the "goods_purchase_order_line_id" field on the PURCHASE_ORDER_GOODS_LINE table? Does it contain data that can be linked to the "purchase_order_line_id" field in the RECEIPT_LINE_GOODS_ITEM? 

Thanks, 

Frank

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_GOODS_ITEM table using the purchase_order_line_id field.  A fictitious (but realistic) example of what the data looks like is below.

Hi Bryan, 

It looks like we don't get the WID from the Purchase Order endpoint. So I think the potential solution would be sync the readable value for the purchase order line reference for the RECEIPT_LINE_GOODS_ITEM table. Would you agree? If so, I can add this request to the backlog. 

Frank

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/1BLjww5562F4iEf8NulgOCcMsQSAnzsUKPZb9M1AZ6EA/edit?slide=id.g35d5cf92011_0_0#slide=id.g35d5cf92011_0_0) shows that this should be possible.  Specifically, it diagrams the ability to join from RECEIPT_LINE_GOODS_ITEM to PURCHASE_ORDER_GOODS_LINE using the purchase_order_line_id field (see first screenshot below).  However, the PURCHASE_ORDER_GOODS_LINE table does not have a purchase_order_line_id field—it only has purchase_order_id and index (see second screenshot below).  I tried joining from receipt_line_goods_item.purchase_order_line_id to purchase_order_goods_line.goods_purchase_order_line_id , but there were no matches (the former is a guid and the latter is a text field that appears to be a concatenation of multiple fields). 

Our request would be to create a way to join from RECEIPT_LINE_GOODS_ITEM to PURCHASE_ORDER_GOODS_LINE.  I think could be done by adding a purchase_order_line_id field to the PURCHASE_ORDER_GOODS_LINE table. If this alternative was chosen, I would hope the new field would be the primary key in the PURCHASE_ORDER_GOODS_LINE table (replacing the composite key of purchase_order_id and index – though those two fields should still be retained).

I suppose another option could be to add purchase_order_id and index as foreign key fields to the RECEIPT_LINE_GOODS_ITEM table.  However, this alternative seems to deviate from the standard relationship methodology used in the rest of the Workday Financial Management data model (i.e. it would require joining on two different fields instead of just one). 

There may be other ways as well, which I would be happy to hear about.  Please let me know if I need to clarify anything or provide additional info.  Thanks!