We need to be able to associate orders with a specific payment method. The Recharge docs describe the ADDRESS api includes a payment_method_id field that would allow us to link order -> address -> payment_method.

The payment_method_id column is excluded in the Fivetran table. Can this be added? I am not sure of another way to associate ORDER records with PAYMENT_METHOD records.

There is technically a way to relate ORDER to PAYMENT_METHOD via the customer_id field (order -> customer -> payment_method), but this would only work if customers were restricted to having 1 payment_method at a time. Recharge allows multiple payment_methods per customer, so this would not help identify which specific payment_method was used for an order.

Thanks

Here is the relevant recharge doc: https://developer.rechargepayments.com/2021-11/addresses