Need to understand the unique reference between the corporate card transaction and expense item

Summary:

From AMEX, the corporate card transactions will flow from SFTP to Oracle. We will see those transactions at Admin level and simultaneously at employee expenses work area.

At admin level, we can see transaction reference number which is the unique ID for all the transactions. At employee expenses work area, there is no transaction reference number.

Need to understand what the common unique reference is between these two.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):