Primary Key between PS4 & PayPal Data Dump
I want to create a data center for our business, and I need to correlate the data kept by PS4 with data kept on the PayPal side.
Problem: there is no Primary Key in common. There are some "pretty good" keys, like a combo of the date, name & amount, but nothing sure-fire unique in both datasets.
Is there a way to pass an absolutely unique field from PP to PS4 (or even vice-versa) to handle this outness?
Ideally, the PP transaction ID becomes a field in the PS4 order table.
Another solution would be passing the ps4_orders.OrderID to a customizable field in the PP dataset.
Needless to say, this is very desirable. Please advise, PP API guys!