With the Amazon Seller Central tables, the fees for a financial event group are stored in the table; Financial_Fee_Component. These fees link to another table depending on the fee type and within that table the financial_event_group_id exists. In the financial_fee_component table, there is a column called 'Linked_To' which holds the name of the table that that this fee is linked to. This row will have a "linked_to_id" which will be the same as a "fivetran_id" which will exist in the corresponding fee table. For example, to get all shipment_fees for a financial_event_group I would do something like this:

SELECT 
         fc.*
FROM financial_shipment_event fse
JOIN financial_shipment_event_item fsi
      ON  fsi.financial_shipment_event_id = fse._fivetran_id
JOIN financial_fee_component fc

     ON fc.linked_to_id = fsi._fivetran_id
WHERE fse.Financial_group_event_id = 'knmdjkndkjwdkjwdkwdplwd';


But, If I wanted to do this for 'financial_service_fee_event' It would not work because although it has a functioning 'financial_event_group_id' column, its '_fivetran_id' always = '/V8NKHHJmkJ/yqav/7TgJm7nHoM=' and so does the corresponing 'linked_to_id' in 'financial_fee_component'. This makes it impossible to make use of the service fees as you cant associate them with their financial_event_group or their order_id.

This is an issue to me as we recreate gross and net amounts for products for our clients.
For service fees I need to make an educated guess from the event total and the total of the rest of the fees. The problem with this is I wont know if there is an issue with the calculations with this method, so I can not confirm 100% accuracy of our numbers. 

To summarize, my request is to have a unique id for each financial_service_fee_event similarly to how  financial_shipment_event has a unique _fivetran_id for each event. At the moment there is no value that properly identifies one service fee event.